Share
Report
182Hello Experts,
I have a requirement where I need to create a report on Inventory Aging report in NAV.
I have seen one report in NAV Inventory availability (705) but that does not look per my requirement.
My requirement is like below:
Showing a summary of stock-on-hand items by items and sum up the item cost in different stock-in period interval
Report has the following fields:
|
Fields |
Definition |
|
Brand |
Brand Description |
|
Product Group |
Inventory Posting Group |
|
Item No |
Item Brand Description |
|
Total Cost |
Sum of current Stock-on-hand item cost |
|
0-6 Mths |
Sum of current Stock-on-hand item cost which stock-in date is 0 - 6 months |
|
7-12 Mths |
Sum of current Stock-on-hand item cost which stock-in date is 7 - 12 months |
|
13-18 Mths |
Sum of current Stock-on-hand item cost which stock-in date is 13 - 18 months |
|
19-24 Mths |
Sum of current Stock-on-hand item cost which stock-in date is 19 - 24 months |
|
25-30 Mths |
Sum of current Stock-on-hand item cost which stock-in date is 25 - 30 months |
|
31-36 Mths |
Sum of current Stock-on-hand item cost which stock-in date is 31 - 36 months |
|
Over 36 Mths |
Sum of current Stock-on-hand item cost which stock-in date is > 36 months |
|
Last Stock-in Date |
Last Stock-in Date |
|
Last Stock-out Date |
Last Stock-out Date |
Any idea how to start onn it.
Thanks
*This post is locked for comments
All responses (
Answers (
