Occasionally, the quantity of an item in a warehouse or location doesn’t look right. May it be Quantity on Hand or Quantity Available it just doesn’t tie out. This can cause issues with purchasing, sales or the warehouse doing transfers. Having these inventory problems can be frustrating to you and your customer when trying to troubleshoot the issue.
Acumatica provides a utility in Inventory – Processes called Validate Inventory which can be used to correct these issues.
First select the warehouse you want to run the utility on and then determine if you need to Rebuild Item History and/or Re-plan Back Orders.
| Rebuild Item History | A check box that you select to have the system build the history of items selected for processing based on the available open and released documents. |
| Re-plan Back Orders | A check box that you select to allow the system to update the plans for back orders if the available quantities of stock items have been detected during the validation. Applicable only to sales orders that do not require allocation. |
For a quick fix I suggest you filter by Inventory ID and only process the item you are having an issue with.
Depending on the size of you inventory and history this utility can take several hours to run if you Process All. To do this, you can manually run the utility after hours or use the schedule option to have it run weekly.
By validating inventory in Acumatica, you an ensure that you have correct quantities of current inventory. This overall allows for correct purchasing, sales and warehouse management. It is important that you regularly validate your inventory to ensure proper quantities.
Don’t forget that we have created an Acumatica Tips and Tricks page on our website. This page contains information on common troubleshooting issues within Acumatica. For even more assistance, we offer support plans and live support!
Solutions by Industry
What's New
Vacation-Ready Operations: Achieve Seamless Integration with Acumatica
With Acumatica's powerful features and flexible architecture, businesses can achieve vacation-ready operations without compromising on efficiency or productivity. Read MoreSubmitted by Stephanie Dean on Tue, 07/16/24 - 5:00
Summertime Efficiency: Transform Your Business with Acumatica Integration
Summertime is the perfect opportunity to boost efficiency, streamline operations, and take your business to new heights with the power of Acumatica. Read MoreSubmitted by Stephanie Dean on Tue, 07/09/24 - 5:00
Celebrate Independence: Unlocking Business Freedom with Acumatica and Sage 100
This Fourth of July, as we celebrate the spirit of independence, let's also celebrate the freedom and flexibility that Acumatica and Sage 100 bring to businesses. By liberating companies from legacy systems, empowering them to adapt and grow, enabling mobility, and declaring efficiency. Read MoreSubmitted by Stephanie Dean on Thu, 07/04/24 - 5:00