You’re offline. This is a read only version of the page.
35
I have been auditing systems of one of our entities. They have recently implemented NAV.
They are able to generate inventory aging report on any date, as long as it is current date.
However, in real world, all supplier invoices for any month are not received / entered in the system by the end-date of that month.
So, after a few days (say, 5th of next month), when all data entries of previous month are over, inventory as of end of previous month has changed compared to what it was as of that month-end (but say, five days ago).
When an inventory aging report as of previous month-end is requested on Day 5 of next month, I have been told that such historic inventory aging cannot be generated. Is this true?
If not, how does one generate a historic inventory aging report?
Thanks,
*This post is locked for comments
Thank you.
I shall convey your method to the in-house NAV team, and see if it works here.
I have the same issue and our NAV support firm can't understand why I am asking for this information. My needs are similar but more detailed. I want to be able to list an inventory quantity and value by lot number and with the vendor designation for each product on hand. I have been told it cant be done. Maybe not by Navision support people but I accomplished this task myself by downloading the Item transaction detail into an excel program.
The problem is that Navision uses a source field that has multiple designations. If it is a purchase then source=vendor no., if a sale the source=customer number, if an assembly then source=finished goods inventory no, and so on. Each purchase record maintains a remaining quantity value and when NAV reports are run it uses that real time balance for the report. There are no NAV reports that can do an as of date report but via excel you can calculate the value and quantity on hand for all the items in the data base.
Your starting point is the Item Transaction Detail which can be run for the specific time frame. You set the Date to the entire file date in the first filter and then in the limit total filter set the date range for the cutoff date you want. Put this file out to Excel.
Then you have to calculate the quantity field and the value field for each item and presto you have a value as of the cutoff date.
In my case since I want vendor information I have to add the vendor number information to each record that does not have the vendor number in it. For me it is based on Lot number so I sort my detail by lot number and use the vendor number from the purchase record to populate the other source records.
Once I have the file created, I use a pivot table to do the calculations. its fast and easy to do this in excel.
I hope this helps. If you find someone who has a program that does this without going into Excel, let me know.
You may also want to look into Inventory Valuation report which is a standard report. If you list the cutoff date you want to use, the report does list the quantity as of the date and an item cost and valuation as of the date. It is only at the item level. This may be all you are looking for.
Good Luck. Let me know if this works for you.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (