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.