Offset payment to a vendor with credit to a customer

Hi All,

We are wondering how to implement the following case in dolibarr:

We buy a batch of scrap material from a customer at a certain price. We then sell the same batch to a vendor at a slightly higher price and he pays for it via bank. But instead of paying our customer, we give them credit (at the same amount we bought the scrap for) that he then uses when buying new products from us. Also, the stock management module needs to record the movement of the batch of scrap as the puchase and sale of them can sometimes be months apart.

In Dolibarr we have done the following:
-Firstly we changed the customer into both a customer and a vendor
-We then created a product refering to the batch of scrap, and added a buying and selling price
-We then booked the purchase and receipt of the batch of scrap, and created the purchase invoice.
-We then booked the sale of the batch of scrap, created an invoice and booked the payment we received for it.

And then we run into the following problem: Dolibarr needs us to make a payment for the invoice we created, but we never pay them directly. In reality we create for them a credit note to use in later sale.

We did create an absolute discount for the customer that is equal to the value of the purchase of the scrap, but accouning wise that does not add up, as we cannot find a way to off-set this open invoice on the ā€˜vendor-sideā€™ with credit on the ā€˜customer-sideā€™ even though the vendor in this case is also marked as customer.

So our question is: is it possible in dolibarr to ā€˜settleā€™ an invoice that is open in ā€œvendor invoicesā€ by creating an absolute credit to be used in ā€œcustomer invoicesā€? or is there another way to create the credit without having to add the customer as a vendor?

Any thoughts and help will be much appreciated as this is a very comon business case in our company.

Thanks
Running Dolibarr 17.02. no external modules

1 Like