Dating Inventory Report

Karen Atkinson

May 01, 2019 17:57

None

I would like to pull a high level report

locations down the side, and the following headings across the top:

Current Inv - Inv > 4M - Inv > 6M ... etc

I am currently using and it works.

Current Inventory =NL("Sum","G/L Account","Balance at Date","Company=",Options!$C$3,"No.",$B7,"Date Filter",NP("DateFilter",,$D$4),"Branch Dimen. Filter",Options!$C$9)

Where $B is the inventory GL list and $D$4 is a date, and Branch Dim. Filter is a range.

What I am stumped with is:

How to I find out how much of this current inventory is older than 4M, and how much is older than 6M, etc.?

Date Votes

2 comments

0

Harry Lewis May 02, 2019 14:20

Hello Karen -

Have you checked if any of the sample aging reports would suit your purpose?

Comment actions Permalink
0

Karen Atkinson May 02, 2019 15:04

These all appear to be for Payables and Receivables. I will take a look and see if I can translate any of the logic to work for Inventory.

Thanks

Update: I looked at these reports - and they are pretty fancy !!

Nothing in the set looks like Aged Inventory. I did see Aged Receivables, but the Pivot Tables pulled from Cube Data-- I am not at that level yet.

I am still pulling directly from NAV database.

Edited by Karen Atkinson May 02, 2019 17:10

Comment actions Permalink

Please sign in to leave a comment.