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
+18
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
Userlevel 1
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
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.