Hi Want to check if Navision is able to generate inventory ageing report as at a historical date. What I mean is say there are few receipts in Jan 2002 and a few issue in feb - Balance as on feb end is 100 and balance as at Jan end is 350. IS it possible to see a Ageing as at Jan which shows 350. Thanks in anticipation.
Attain has such reports, one for quantities, one for value (less than beautiful formats, if you ask me). Version 2.6 doesn’t have any such, but the data would support them. Liberty Grove Software is offering its version to North American NSCs for their clients. Dave Studebaker das@libertyforever.com Liberty Grove Software A Navision Services Partner
Hi Dave, That true but it shows the latest Ageing balance and as per the date it runs the bucket. But am looking for a report which could run on an historical date This kind of function we have it for AR & AP Report No 106 which is a details report and can run as on Historical dates. where as 105 can run only on current dates. Any suggestions
You are correct. I missed that one. A modification is required to make the existing reports do what you want. The reports are driven by the Item Table. There is a Date Filter in the Item Table that could relatively simply be used to constrain the data considered to an “as of” date. But you will need the assistance of a developer for the modification. My apology for misleading you initially. Dave Studebaker das@libertyforever.com Liberty Grove Software A Navision Services Partner