Skip to main content
Solved

Import scenario for AR payment and apply to invoice


Forum|alt.badge.img

I need to have an import scenario that records the payment and applies the payment to the related invoice or invoices.  I started using the one included but I am getting the error:

The system failed to commit the adjustment rows.

Here is a screenshot of the application section of my import.

 

Any help would be appreciated.

Thanks...coleen

Best answer by Naveen Boga

HI @coleenmcnally22 

I tried in my local instance and working as expected. Please find the attached screenshot for import scenario.

 

Hope this helps!!

 

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

8 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3404 replies
  • Answer
  • March 18, 2021

HI @coleenmcnally22 

I tried in my local instance and working as expected. Please find the attached screenshot for import scenario.

 

Hope this helps!!

 


Forum|alt.badge.img

Hi @Naveen B 

are you applying to multiple invoices or just one invoice?


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3404 replies
  • March 22, 2021

@coleenmcnally22  I did verify the above import scenario with only one invoice and observed working as expected!


pkohler91
Freshman II
  • Freshman II
  • 9 replies
  • May 4, 2021

@coleenmcnally22 

We have an import scenario working for applications to multiple invoices in version 2020 R2 but we are not applying cash receipts to specific lines of the invoices. 

The one notable difference is in our scenario the Financial Details → Link to GL row is positioned before the Payment Summary Payment Ref. row before the Documents to Apply section.

Also we do not have the Commit check box selected on the Documents to Apply Doc Type row.

I recall having similar issues with the out of the box import scenario in 2020 R2 and we ended up creating a custom one.


  • Freshman I
  • 9 replies
  • February 23, 2022

Which date does this import scenario use?


Forum|alt.badge.img
  • Varsity I
  • 46 replies
  • July 1, 2022

Hi @pkohler91 - any chance you can share your import scenario for this? I cannot seem to get mine to work. Below is a screenshot:

 

 

 


pkohler91
Freshman II
  • Freshman II
  • 9 replies
  • July 1, 2022

Hi @ashleyb, I will share the import scenario and supporting files but I must edit any customer sensitive data first and create a write up on their specific processes on which the import scenario is designed around.


Forum|alt.badge.img
  • Varsity I
  • 46 replies
  • July 1, 2022

Hi @pkohler91 you can actually disregard - I was able to get it working! :) Thank you though!


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