#NAV2017
Good day! I am building a report to show value of the inventory, by lot, by a certain date.
I can achieve inventory by lot by date OR value by date but not both.
Has anyone successfully achieved this?
I used the Item Ledger Entry table to achieve the lots by date using Table Builder
I used the Item to achieve value by date (Valuation table and Net Change) using the NL function