Tuesday, February 12, 2013

NAV 4.0: Ways to obtain Inventory Value

Financial Management \ Inventory \ Reports \ Inventory Valuation
- too long (need index tuning?)
* alternatively use command on "Kumpulan SQL command"

Financial Management \ Inventory \ Reports \ Item Age Composition - Value
+ fast
UPDATE: Beware! It seems that information on this report is NOT suitable to obtain inventory level at specific time

Financial Management \ Inventory \ Analysis and Reporting \ Analysis Report
+ relatively fast
- cannot filter on Location

Financial Management \ Inventory \ Analysis and Reporting \ Analysis by Dimensions
+ can filter on Location
- requires updated Invt. Analysis View Card

Custom report based on SKU table (Inventory x Unit Cost)
+ fast
- beware of incomplete list of SKUs
..for example, new Location code is created but "Create SKU" menu hasn't been run


No comments:

Post a Comment