Hi i am using dolibarr 19.0.1 to manage my manufacturing business.
I got a scenario in which i receive an item of qty X from customer and provide service on it and return back the item of qty Y. Such that the balance of item between the customer is X - Y. Now i wan to record the item transaction summary and able to view the remaining balance of the item with the customer.
Can some one explain how to achieve this ?
If more clarification needed i will be happy to provide details further.
As usual in accounting, there are multiple ways of doing this. The simplest way would be to use the warehouse function under “Products | Services.”
You would create a warehouse for “unfinished product” and another one for “finished product.”
As you receive an unfinished item from a business [I assume you already have an item number established], you would move that lot of items to the “unfinished” warehouse.
As you complete the work on the product, you would move those items to the “finished” warehouse.
This would work fine for a few products and a few customers. However, a more elegant solution would be needed for many customers and many products.
Hope this helps.
Frank
Thank you so much for your reply Frank.
The suggestion you explained is good and i have already tried it. It updates the inventory items well. But the big issue here is there is not proper transaction summary maintained for the items.
We can consider the warehouse movements but the movements record are too restricted. We can not modify or make corrections. Can not alter the dates. In most cases the items received very late and entries made in stock on next day. The movement record the current date for the stock and not the invoice date. The module should have some flexibility.
My main concern is keeping a summary of item like we have for bank entries.
Thanks for your suggestion once again.
Since no one else has taken a stab at this, I thought I might tender another suggestion.
I have come up with a possible scenario for your book keeping system that would allow you to have multiple customers and multiple items while accounting for everything.
What you are doing is similar to but not exactly like consignment accounting. Most of the accounting steps are the same. If set up and used correctly, your inventories will be correct as well as your work flow.
I would suggest researching and understanding consignment workflow such as:
Once again, I hope this helps.
Frank
Another alternative could be to use batches (Lots), for example one lot for each supplier or for each receipt.
