Greetings, I am a “manufacturer of water treatment chemicals” and have been successfully using “Manager.io since 2022”. One key feature I utilize is “Inventory Kits”, where our inventory consists of:
“Chemicals” – Combined in various ratios to create our products.
“Packaging Materials” – Includes drums, stickers, and other related items.
To track costs efficiently, we have set up “two separate ledgers”:
“Chemical Ledger” for chemical materials.
“Packaging Cost Ledger” for packaging materials.
While creating inventory items, we assign the “default ledger” accordingly. When an inventory kit is sold, costs are automatically allocated to the respective ledgers, which are visible in the “Summary” section.
Current Challenge:
As we expand into different industries, we frequently adjust our chemical compositions and maintain “ready-to-dispatch finished goods”. To streamline this, I have started using the “Production Order” feature.
However, I encountered an issue:
When creating an “Inventory Item at Stage 2”, it only allows selection of “one Custom Expense Account.”
As a result, all costs are routed into a “single ledger”, instead of splitting them between the “Chemical” and “Packaging Cost” ledgers.
Though, at “Stage 1”, we have selected two different ledgers under each inventory item.
Could you guide me on how to ensure that costs from “Stage 2 Inventory Items” are correctly recorded in “two different ledgers”?
I appreciate your support and look forward to your guidance.
Hi, suddenly I found one bug, previously I have created seperate ledger for recording my inventory consumption naming “Purchases - Local Chemical” instead of using default account of “Inventory Cost”. Suddenly the amounts are reflecting in “Inventory Cost” with difference in amount in previous years as well, please need help restoring back as previously.
We are using Cloud version 25.2.14.2091, my second issue still remains unresolved which is more concerning right now (the bug I mentioned). Please need your assistance, thank you
Hi, I found one bug, I have created seperate ledgers for recording my inventory consumption naming “Purchases - Local Chemical” instead of using default account of “Inventory Cost”. But now amounts are reflecting in default header, also the amounts are reflecting in “Inventory on hand” in previous and current years are showing different values than what we closed, please need help restoring back as previously.
I am using cloud based version 25.2.15.2096. Please need your assistance.
Hello @lubos the solution worked for all items except two item. The items are not disappearing from inventory cost correction sheet when recalculating. Moreover, we usually purchase D.I.Water @ Rs. 5.5/- per kg but unit cost is appearing Rs. 15.82/- per kg. Furthermore, my inventory of D.I. Water (item no. I-0001) is in positive. I am enclosing screenshots for your reference for further guidance, thank you.
Moreover, when I am referring the unit cost by clicking the total cost which is “0” its showing the unit cost of Rs. 15.82/- per kg whereas we actually buy this item at Rs. 5.5/- per kg. Below are the screen shots for your reference.
@Aman_Jaffer what seems to be happening is that even though your quantity is positive. Total cost is negative. Manager will automatically transfer negative cost out of balance sheet to profit & loss statement. This will make your cost of unsold items zero.
If you buy item for 5.5 but unit cost seems to be 15.82 and inventory cost correction doesn’t see any discrepancy. Then there must be a bookkeeping error somewhere.
The easiest explanation (that will explain positive quantity but negative cost) is that you might have entered credit adjustment with very large cost.
The screenshot you have posted shows just a few transaction, it doesn’t show the entire history for the item. You might need to go a few pages back to see when unit cost became 15.82. I’d assume this is where bookkeeping error has occurred.
If you still can’t see it, PM me and share with me access to your accounting file and I can look into this specifically.
