Business Central / NAV UG
Business Central / NAV UG
Organizer:
- Organized by
-
-
Inventory Report with Location Bin an Lot + On Hand
-
Inventory Report with Location Bin an Lot + On Hand
Hi All,
Is there an out-of-the-box report that can show the
Item, On Hand, Location + Bin, Lot ?
We are using Basic Warehousing [no require receive or require shipment] so Warehouse documents likely won’t work.
I get close but not all fields.
Regards and thanks. -
4 Replies
-
Joseph – Looks like no one replied to this however back when we went live in 2023 I ended up coming across this exact question on a different forum and unfortunately there just are not great out of the box reports for Business Central that include lot number. Our financial reporting expert was able to create a Power BI report for our inventory team with the fields you mentioned here and I think that is likely the only way it can be done. Including a screenshot of the tables he included that he made relationships between. We have multiple companies in Business Central which is why there are a few General Ledger Entries tables here and I’m not entirely sure why he included them all as inventory transactions only flow through one company currently but I assume he did this in case anything changes in the future. If you have other questions let me know I can try to help or ask him to see if he can provide a quick answer.
-
Hello Inventory geeks! Microsoft does have a Power BI app for Inventory that has Inventory by Lot 🙂 Screen Print below
Power BIYou can also try the Item Ledger Entries Analysis Mode and create an Analysis view by lot number. Once you have the view set up the way you desire, it stays there and can be toggled from the list view to the Analysis view whenever you need to examine the inventory by lot.
Log in to reply.
