Hi there,
My client is using NAV2017 and during financial audit, the auditor asked the questions as to inventory valuation report.
By default, NAV calculates item quantity and unit cost via value entries tables from open inventory balance as of System GoLive. This client was started to use NAV 2021. So, when running inventory valuation report, NAV tries to pull out all data from 2021 to sum-up.
During financial audit, auditor picked one item as sample for audit testing. Via value entries data, auditor calculates the unit cost from recent transaction by using Excel. However, inventory valuation shows different unit cost. The auditor understood NAV default report (Inventory valuation report) is calculating from beginning but he is wondering if there is another way to evaluate inventory unit cost via recent transactions instead of running inventory valuation report. Without developing custom report, is there any workaround to response to the auditor's question?
By the way, the client installed Jet-report by themselves, and the controller of the client is familiar with Jet Report even if my company does not support Jet-report.. If Jet report can be a tool what they are looking for, could you let me know which table they should to setup (maybe, either value entries tables or item ledger entries) to create their own custom report by Jet report?
Regards,