I’m setting up the item inventory management in Business Central Navision.
Up to now, this was a manual system in Excel and I try to recreate the inventory in BC as from 01 Oct 2020 up to now.
Important is that the quantities & actual costs in BC are the same as in the manual system.
I have entered already data purchases-sales-consumption from Oct2020 up to Aug2021.
Now I’m checking the monthly data to match the manual system.
For the first month Oct2020 I have a small difference on 3 items, quantities are correct, value is higher/lower.
I would like to adjust the inventory value with the item revaluation journal, but the ‘Calculate Inventory Value’ does not show the quantities and Inventory Value (Calculated) as when I export the Oct data to excel and make manual checks.
All items have 'average ’ costing method.
Question : can I adjust the inventory value of an item just for the transactions up to the end of that month?
Thank you in advance for your quick replies.
You will need to enter the Revaluation Journal specific to the Item Ledger Entry you want to revalue. Let me explain in this example:
First, find the “Entry No.” you want to revalue in the “Item Ledger Entries” list for this item. I want to revalue the positive adjustment posted on 12/31/2013. In the Item Ledger Entries list below, the Entry No. for that Item Ledger Entry is 34:
Figure 5 – Locate the Entry No. of interest in the Item Ledger Entries list
Next, populate the Revaluation Journal by manually entering the item number, then the Entry No. Finally, enter the “Unit Cost (Revalued)” and post:
Figure 6 – Enter the item number, the Entry Number, and the Unit Cost (Revalued)
You may encounter the error regarding being out of the allowed posting date range. In this case, you might need to change the General Ledger Setup date range, the User Setup date range, and/or reopen an inventory period. The challenge here is that the General Ledger posting may be in a prior accounting period. If this is the case, you would likely post a General Journal that moves the accounting effect out of the closed period into the current period.
Hope this helps.
Actually if you use Calculate Inventory Value, it will get the Remaining Qty, if you enter Applies-to entry manually, it will get the Quantity.
We are talking about revaluing explicit “Item Ledger Entries”. “Calculate Inventory Value” is not used here. An explicit journal line needs to be created for each “Item Ledger Entry” to be revalued.
Yes, “Calculate Inventory Value” is based on “Remaining Qty” as it’s calculating the current value.
I’m still struggling with this topic.
I need to reset the value of an item at a certain date.
Revaluation journals do not let me to reduce the value of the item.
Each time I try to use a revaluation journal line, the actual cost amount goes up, increasing the difference to the manual (excel) kept item valuation.
In a desperate attempt, I made a Purchase Creditmemo for the quantity and value of the item:
credit qty 108080 - unit cost 0.80318 = -86807.69€
This resulted in a quantity = 0 and a value of 71482.53€ → where is the decrease coming from?
Then I tried to post another creditnote with qty = 1 and unit cost 71472.53 but this results in a inventory qty of -1 and a value of 71482.39, a very small decrease of the value.
Can this problem be solved?
And how can you use the revaluation journal to reduce the value of an item and to which entry should this be applied?
Thank you very much in advance.
For more information, please do not hesitate to contact me.