Greetings!
I recently joined a company using Business Central, and I am trying to configure the system to show a truly accurate "Available Inventory" figure on the Item Card without requiring manual investigation every time.
For example, on an Item Card (Item 123456789), I currently see:
- Quantity on Hand: 11
- Demand Quantity: 13 (a mix of open Sales Orders and Production Order component requirements)
- Qty. on Hand less Demand: -2
- Supply Quantity: 7
In theory, Qty. on Hand less Demand should represent my current availability. However, the -2 is highly inaccurate for what is actually usable.
When drilling down into the warehouse bins, I can see that out of the 11 units on hand, 6 are sitting in a specific Quality Assurance bin (which we call QARMA) because they just failed a QA inspection at the end of the production line. These 6 units are completely unusable for production or sales and are awaiting a vendor return. Because they are still counted in the overall Quantity on Hand, BC thinks they are available to satisfy demand.
I have two main questions for the group:
- Quarantining Post-Production: Is there a standard way to immediately isolate items when they fail QA so they are blocked from being looked at as available inventory, specifically excluding them from calculations on the Item Card?
- Preventative/Incoming Inspection: We also lack an incoming inspection process. What is the best practice in BC for setting up an incoming inspection bin or location where items must pass QA before they are moved into an "Available" status, preventing them from hitting the production line in the first place?
I want our team to see true availability at a glance without having to dig into bin contents for every item. If you need any specific details about our current Location or Directed Put-Away and Pick configurations to help point me in the right direction, I’m happy to provide them.
Thank you in advance for your help!
