How can I contact the manager’s management due to the forum being useless? I have a big problem since the last update, and I have not received a response to all my messages until I move to another accounting program. It is my right as a user of the cloud version to obtain appropriate support to solve what you have corrupted. My problem is that the cost of inventory and related accounts changes retroactively, even though we have issued final financial statements, as well as the change in the opening balances for the current year, and I try to control that with accounting entries, but the problem persists.
Without Thanks.
1 Like
The figures would retrospectively change only for users who use:
- Inventory items
- Production orders
- and had any production orders with insufficent quantity where output item would be sold (or used in another production order) before insufficent quantity was resolved.
If your Inventory on hand balance has changed, it means Manager has calculated different unit costs.
-
Go to balance sheet report which now has changed figure.
-
Click on
Inventory on handbalance -
You will see
Unit costcolumn being furnished with unit costs.
You can click on any unit cost and increase it or decrease so that Total cost that represents your Inventory on hand balance on balance sheet will be your desired figure.
So no need for any adjusting journal entries, just modify your unit costs so the total comes to your desired balance. Most businesses will increase/decrease unit cost of one random inventory item. It doesn’t really matter which one.
Remember that Inventory on hand balance on balance sheet is now a function of multiplying Qty owned by Unit cost for each inventory item to obtain Total cost for inventory item and adding all total costs together. So to change Inventory on hand balance, modify Unit cost for one or more items.
Look, I’m not jumping out of joy breaking historical figures. However this work was also done so the figures can’t be broken by future upgrades anymore. So while I understand that this change has decreased the confidence in the program for now, it was necessary price to pay to make the program more reliable in long run.
3 Likes
Dear Lubos ,
I have done this and written about it in this forum, but the unit cost is still the same after many transactions, which means it has to be revalued after each purchase, and it affects the historical numbers again. I have tried all the hints in this forum. The weighted average cost policy was chosen, which means that the pricing should be the same for all transactions, but I did not find that, the unit cost of the inventory items remains at the last update. The inventory equation starts with the opening balances, then the movements during the period, then the closing balances and so on, but after applying what you indicated in your reply, unfortunately I cannot reach the correct numbers.
we update the unit cost at the balance sheet date, and we found some Inventory items with negative values without any quantity (inactive items).
Go to balance sheet to the period when these items were last available. Then recalculate and update costs of these items.
@lubos I think these values are from the Automatic Revaluation which is running in parallel for items for which the Unit Cost is never entered. Automatic revaluation is not working as it used to do so it’s better to completely remove it if you have no plans to bring it back as this is causing more confusion.
2 Likes
I think for inventory items with negative balance, Manager should still figure out the unit cost and create it so that Qty owned multiplied by Unit cost will be zero. I’ll rectify this.
That’s the plan but I need to do this step by step.
2 Likes
When Qty owned for an item is zero it should still suggest the last known cost for the item even if its value equals zero. This is important because if an item is used 100% in a production order before recalculating its Unit cost then the Unit cost calculated for Finished Item on Recalculate screen is not correct.
2 Likes
i agree with you
Please see FAQ - Manager Forum specifically:
- Don’t post replies like “Bump”, “+1” or “Agreed." Use the Like button instead.
1 Like
Thanks for your update 12.12 and we are waiting for more update about automatic revaluation as it was in previous versions of manager.
I still have a difference in the values of Profit or loss ( income statement) and difference in balance sheet in Project under constructions PUC / WIP, which receiving a costs from BOM production order and inventory transaction with a little values.
The difference have accumulated since the first year of using Manager and not related to the last Financial closing .
Thanks