Skip to main content
Question

Adding applied invoices/documents to Payment and Applications report


  • Freshman I
  • 4 replies

Hi,

I’m trying to add applied (1) invoices / documents informations to (2) Payment and Applications. Is it possible?

 

Kindly refer picture below as reference

(1) information in the red box

 

(2) to be put on this page as additional column

Thank you

2 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • March 21, 2024

Hello,

Yes it is possible to add invoices that payments were applied to, to the Payments & Applications preview. Did you try Acumatica reports such as AR Balance by Customer that already include the invoices with the payments?

 

If reports already showing applications don’t work for you, then Payments & Applications preview list Generic Inquiry may be modified to show the application detail.

I recommend leaving the original Payments & Applications preview list intact and copying it to a new name, new Inquiry on your menu, to meet your need. Change the new copied Generic Inquiry, and connect the new Copy, “Payments with Paid Documents” to your menu as a separate report.

ARAdjust table contains the relationship between Payments and paid documents; please add ARAdjust table to your new generic inquiry copy. In AR Adjust, the payment is the “Adjusting” document and invoices, debit memos, etc. are the “Adjusted” documents. 

For more information and examples, please review this previous post:

Laura


  • Author
  • Freshman I
  • 4 replies
  • March 22, 2024
Laura02 wrote:

Hello,

Yes it is possible to add invoices that payments were applied to, to the Payments & Applications preview. Did you try Acumatica reports such as AR Balance by Customer that already include the invoices with the payments?

 

If reports already showing applications don’t work for you, then Payments & Applications preview list Generic Inquiry may be modified to show the application detail.

I recommend leaving the original Payments & Applications preview list intact and copying it to a new name, new Inquiry on your menu, to meet your need. Change the new copied Generic Inquiry, and connect the new Copy, “Payments with Paid Documents” to your menu as a separate report.

ARAdjust table contains the relationship between Payments and paid documents; please add ARAdjust table to your new generic inquiry copy. In AR Adjust, the payment is the “Adjusting” document and invoices, debit memos, etc. are the “Adjusted” documents. 

For more information and examples, please review this previous post:

Laura

Dear @Laura02 

 

I have tried AR Balance by Customer but it is not what I wanted. 

I have tried to follow the example from the said post,

And add table, relations and data fields to the G.I as below:-

But I still cannot pull out the info.

 

Kindly advise. Thanks


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