View My Drafts
I am trying to create an inventory obsolescence month to month trend graph. In my Inventory Warehouse (Syspro ERP) table i have the DateLastStockMove and the inventory value.
My approach is to calculate <<end of month - date last stock move>>, then with the number of days classify obsolete >365*2, and finally calculate the inventory value for each period of time.
My issue is that i am not able to create a measure of the <<end of month - date last stock move> because they are in different tables. Now, in the inventory warehouse table i don't have any other date reference.