Skip to main content
Question

Import Scenario AP Reverse Application


cgrigg
Freshman I

Need a little help here and I'm hoping someone on here has done this before. 

Business Case:  We misapplied 400+ Prepayments to 20,000+ Bills and Released them using an import scenario.  Each Prepayment has at least one and in some cases hundreds of Bills applied to them, so clicking through each Bill to reverse application is not an option.  What I need is an import scenario to Reverse Application of these prepayments to bills.  I used this posting → https://community.acumatica.com/import-and-export-scenarios-117/import-scenario-to-reverse-ar-payment-application-10371?tid=10371&fid=117 to develop an Import Scenario for the AP problem I’ve got, but it doesn’t work.

Issues Experienced:  The first Bill on each Prepayment will Reverse and Release, but then the second Bill on the Prepayment will not release and I get an "Index is out of bounds of the array" error. I can only guess that this happens because reversing the application adds a line to the Application History screen, but I'm not sure how to fix it. Any help would be greatly appreciated.
Thank you!

Kandy Beatty
Captain II
Forum|alt.badge.img+16

HI @cgrigg 

Please see this previous post. It does not appear that you can perform that action to reverse.

https://community.acumatica.com/financials-7/import-scenario-to-reverse-ap-bills-9355?tid=9355&fid=7


cgrigg
Freshman I
  • Freshman I
  • November 7, 2023

The post cited refers to reversing an AP Bill, which would of course trigger a Debit Adj.  My scenario needs to take a Prepayment and Reverse Application of the Bill amounts, not Reverse the Bill itself.


Kandy Beatty
Captain II
Forum|alt.badge.img+16

I don’t believe you can accomplish this with an import scenario due to the Action. 


cgrigg
Freshman I
  • Freshman I
  • November 7, 2023

I can get the first line to process with my scenario, but then the second line says either “Release button is disabled” or “Save button is disabled” depending on how I tweak the scenario. Here is the base scenario I’m working from.

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • December 13, 2023

Hi @cgrigg were you able to find a solution? Thank you!


martingaxiola
Varsity I
Forum|alt.badge.img

 

Ok, i found a workaround, I hope I can explain myself:

 

  1. Select the bills to be reverse from the Bills and Adjuments screen . 
  2. Create an import scenario that will create the Debit Adjusment from the Bills and Adjusments screen. Something like this:
    1. Using now the Debit Transactions created, release those, and they should have the Original Reference Number as the Bill that they are proceeding, I have attached that Bills and Adjusment GI witht the original reference number that will be the bill in the case of the new Debit Adjusments. 
    2. With that new table, use it to create a checks and payments import scenario, where you can apply the bill to the debit adjusment by doing the following import: (Note, make sure to also modify the application date as desired and even to release the transaction from this import)

    3. This should reverse your bills using import scenarios.

I hope I explain myself. Thank you.

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • March 14, 2024

Thank you for sharing your solution with the community @martingaxiola!


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