By using this website, you agree to our Terms of Use (click here)
We periodically have stock which cannot be sold (for example stock which is damaged and can neither be returned to the vendor nor sold to customers) and which we want to remove from our inventory.
Because the inventory cannot be sold, we have it in a separate warehouse location in Acumatica which does not allow sales (Sales Allowed = False). However, we want to get this inventory out of Acumatica. A natural solution, it seems would be to do an Inventory Issue to remove the items from the warehouse. However, since the location does not allow sales, an Issue is not allowed.Â
What is the recommended way to clear out unsalable inventory from a warehouse location that does not allow sales?
I tested this quickly and it appears to work.
Perform a Physical Inventory on the Warehouse and set the counted quantities to zero and provide an appropriate reason code to handle the accounting.
-John
@jmasi great idea especially if you want to clear out the entire warehouse with one swift process!
Â
@abulger if you wanted to do this for one off items in the designated warehouse, you could do this with an adjustment, making the quantity negative in the entry and selecting the appropriate reason code configured for this usage and the necessary accounting considerations.Â
Actually I think I like Kevin's idea better. Run the Inventory Balance report on the Warehouse with Location Details, export it to Excel, clean up the spreadsheet and add the columns you need and feed it to the Adjustment screen. Much easier.
Thanks Kevin!
Â
-John
Â
@jmasithe the one place my process can get messy is on tiered items where you may need to reference the receipt number which would require some changed to the Inventory Balance report.
Agreed. The devil is always in the details. 🤣Â
Have you tried using a negative qty on an Inventory Adjustment instead of a positive qty on an Inventory Issue?
A negative quantity on the Adjustments (IN303000) screen will work. Just watch out for the requirement to populate the TRANSACTION DETAILS -> Receipt Nbr. field like Kevin pointed out when the Valuation Method of the Item is something other than Average.
Not sure what I am missing. I cannot adjust negative inventory. Allow negative inventory is allowed on the item class. Reason code is applied. The location is a "returns" location, so it is not calculated into available inventory. The following error message appears and wont allow release.
IN Error: Updating item '1-0260 0' in warehouse '' quantity available will go negative.
2020 R1 Build 20.111.0017