Reply To: Inventory Report with Location Bin an Lot + On Hand

  • Laurie Baldwin

    Member
    January 13, 2025 at 3:07 pm
    Up
    0
    Down
    ::

    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.

    Inventory-Power-BI-Relationships.jpg 83 KB Image File - Click to view
    Options

Report

Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts
  • Invite this member to groups
  • Message this member
  • Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!