Skip to main content
Solved

Reverse an Inventory Receipt Document that was created manually


Forum|alt.badge.img

This question is a bit different from a prior question regarding how to reverse an inventory receipt.  In our case, we did an Issue out of inventory that reduced our Inventory account and went to our inventory shrinkage account.  We have to make some changes to the sku accounting methods, so we transferred it all out in order to make the change, then will move it all back in.

After we issued it out, however, we received in via the Receipts transaction rather than do a corresponding inventory adjustment in. It correctly increased the inventory, but the other side of the transaction hit their finished goods control account rather than shrinkage.  Now we have an imbalance and we can’t determine how to reverse the purchase receipt so we can adjust the inventory in properly and make it all balance.

The Issue out:

The Receipt:

 

Since accounts 1200 and 1202 are control accounts in our case, we can’t just reverse the batch for the receipt.

Does anyone know how we can do a reversal of the Receipt such that it simply reverses the above receipt transaction and then we can do a proper Adjustment in which will offset the Initial issue out?

Thank you

Patrick

Best answer by Samvel Petrosov

patrickACA wrote:

@Samvel Petrosov Thank you.  question - I don’t see that you have used quantities in the above example.  Will the fact that we are not using quantities matter or is the solution required only a financial one?

 

The quantity is required to be null so that Acumatica process cost only adjustment.

If you set the quantity, Acumatica will either receive in or issue out the corresponding quantity. 

View original
Did this topic help you find an answer to your question?

Samvel Petrosov
Jr Varsity II
Forum|alt.badge.img+5

The accounts that are being debited (during IN Issue) and credited (during IN Receipt) are controller by the Reason Codes you configure and apply to the transaction lines.

As an option, you can configure 2 reason codes for IN Adjustment (first to offset to 5100, second to 1202) and create an IN Adjustment only adjusting the costs of the item in that warehouse/location. Something like below
 

 

Processing this IN Adjustment will result in GL update looking something like this:

 

So this should correct the balances in your financials.

But before processing the transactions in your production, please validate them in sandbox environment or with your partner.


Forum|alt.badge.img
  • Jr Varsity II
  • March 17, 2025

@Samvel Petrosov Thank you.  question - I don’t see that you have used quantities in the above example.  Will the fact that we are not using quantities matter or is the solution required only a financial one?

 


Samvel Petrosov
Jr Varsity II
Forum|alt.badge.img+5
patrickACA wrote:

@Samvel Petrosov Thank you.  question - I don’t see that you have used quantities in the above example.  Will the fact that we are not using quantities matter or is the solution required only a financial one?

 

The quantity is required to be null so that Acumatica process cost only adjustment.

If you set the quantity, Acumatica will either receive in or issue out the corresponding quantity. 


Forum|alt.badge.img
  • Jr Varsity II
  • March 17, 2025

@Samvel Petrosov understood.  Thank you so much!  I have tested in our sandbox and it works as you describe.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings