Solved

Adjustment: IN Error: The multiplier must be equal to 0 or 1.

  • 20 June 2023
  • 6 replies
  • 181 views

Userlevel 5
Badge

Good day,

We are trying to adjust out inventory that no longer exist or has been used in an old warehouse that is no longer going to be used.  We want to reduce to the On Hand to zero and the close/deactivate the warehouse to avoid any new sales/purchases to this warehouse.

IN Error: The multiplier must be equal to 0 or 1.  I can’t fine a fix to this error to allow us to release the adjustment.  Any suggestions would be helpful

Thank you.

@Evan G 

 

 

icon

Best answer by Laura02 26 June 2023, 23:49

View original

6 replies

Badge +18

Hello EvanG,

I have some ideas for you, but perhaps not a full solution yet:

  1. See whether there are more errors in the trace.
  2. It looks like this is a multi-currency tenant. If so, make sure Currency Rate Refresh has been run for every currency, so there is at least one rate available to the system. I’m not sure mutli-currency is used in IN module; we want to rule out currency as a cause.
  3. Run Recalculate Inventory process for the items in the above batch and try to release again.
  4. Copy the batch above to a new batch and try to release again.
  5. Compare the total costs on each line of the batch to the Inventory Valuation Report for the same warehouse. If all items are being adjusted out of stock, we need 0 quantity and 0 cost left on hand. Each line quantity and extended cost needs to match the quantity and amount on the Inventory valuation report.
  6. If the above steps do not help, you may need to open a Case with Acumatica or your partner.

Good luck!

 

Laura

 

Badge +18

Hello @EvanG ,

Here are a few more steps you might take to release your adjustments batch:

Check Inventory Allocation Details.  Do any of the items in the above adjustment have unfinished shipments in the system? 

Do the items in the shipment allow negative quantity?

If the items do not allow negative quantity on hand and there are shipments confirmed but not completed, please try deleting shipments, cancelling the orders, and then releasing the adjustments batch. 

Please let us know how this works out. Good luck!

 

Laura

Badge +18

Hello @EvanG ,

If the above ideas don’t work, perhaps just Inactivate the warehouse.

Userlevel 5
Badge

Thank you @Laura02 

Userlevel 3
Badge

Please note that, this is fixed in 2021R208.  

Userlevel 5
Badge +1

with zero on hand but -1 available, it sounds like you have demand for that item.  You would need to relieve that demand then the adjustment should go through.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved