Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Traci Albosta]

We are using NAV 2017.  Is there a report in NAV that will give me inventory valuation by bin?  Or tables with the information (bin, item, quantity, valuation) that I can pull the information into JET Express?  Thanks for any suggestions you can offer.

——————————
Traci Albosta
Comitt Well Solutions LLC
Katy TX
——————————

[Franz Kalchmair]

you could add a flowfield in table bin content using table value entry.

——————————
Franz Kalchmair
Microsoft MVP
Senior Consultant
Vienna, Austria, Europe
——————————
——————————————-

[David Wiser]

Just be aware that you would need to calculate the cost for the specific bin since no costing data resides at the bin level, its all at the location level.  So, if you have quantity in two bins within a location, you would need to allocate the location cost to the bins based on the quantity in that bin compared to the total location quantity.  That is, unless I’m missing bin costing somewhere.

——————————
Dave Wiser
Controller
Beckwith & Kuffel
Seattle WA
——————————
——————————————-

[Naveen Jain]

If you are maintaining inventory by lot or Serial Number, then can write custom reports to calculate the inventory values of those lots/serials in the bin, but as a standard NAV you do not have any report which can give you valuation by Bin. 

Otherwise you can calculate the value of the item by location, and based on the bin content inventory you can calculate the valuation.

——————————
Naveen Jain
Director of IT
Symbex Companies
Santa Fe Springs CA
——————————
——————————————-

[Traci Albosta]

Thank you very much for all of your input!  I was hoping there was an easy report someplace, but I guess not.

——————————
Traci Albosta
Comitt Well Solutions LLC
Katy TX
——————————
——————————————-

[Aaron Brown]

Are you using standard costs?  If so, you could query the bin contents by item and multiply the quantity on hand by the standard per the item table.  This may or may not tie to the GL, depending on where you’re at in your inventory reconciliation cycle, but it should get you to the theoretical cost by bin.

——————————
Aaron Brown
Director of Finance
Oregon Ice Cream
Camas WA
——————————
——————————————-