Solved

GI to link Payment, Invoice and SalesOrder

  • 29 July 2022
  • 6 replies
  • 260 views
L
Rank

Hello,

I need to build GI that links Payment, Invoice and SalesOrder. Could you please suggest how to link?

icon

Best answer by Kandy Beatty 30 July 2022, 23:09

View original

6 replies

D
Rank
Userlevel 7
Badge +5

Just to confirm - you’re referring to Receivables Payments, Sales Invoices?

L
Rank

yes ARPayment and ARInvoice

Kandy Beatty
Rank
Userlevel 7
Badge +16

Hi @Leo05 

Here is one that I have in my local:

You can possibly use this as a template and change it to your needs. 

 

 

1 Attachment
Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
L
Rank

@kbeatty21 , Hi

Thanks but I do not have priveleges to import GI.

Kandy Beatty
Rank
Userlevel 7
Badge +16

Hi @Leo05 

Here are the screenshots of the tables and the joins along with the results grid:

 

Please let me know if you need to see anything else. 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
L
Rank

Thanks. Also could you please suggest how to link ARPayment to ARInvoice?

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved