Skip to main content
Answer

GI to link Payment, Invoice and SalesOrder

  • July 29, 2022
  • 6 replies
  • 389 views
L
Freshman I

Hello,

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

Best answer by Kandy Beatty

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. 

    6 replies

    D
    Captain II
    Forum|alt.badge.img+7
    • Django
    • Captain II
    • July 29, 2022

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

    Kandy Beatty
    Chris Hackett
    L
    Freshman I
    • Leo05
    • Author
    • Freshman I
    • July 29, 2022

    yes ARPayment and ARInvoice

    Kandy Beatty
    Captain II
    Forum|alt.badge.img+17
    • Kandy Beatty
    • Captain II
    • July 29, 2022

    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 Attachments
    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*.
    Chris Hackett
    T
    L
    Freshman I
    • Leo05
    • Author
    • Freshman I
    • July 30, 2022

    @kbeatty21 , Hi

    Thanks but I do not have priveleges to import GI.

    Kandy Beatty
    Captain II
    Forum|alt.badge.img+17
    • Kandy Beatty
    • Captain II
    • Answer
    • July 30, 2022

    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*.
    Chris Hackett
    L
    L
    Freshman I
    • Leo05
    • Author
    • Freshman I
    • August 2, 2022

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

    T
    Terms & ConditionsCookie settingsAccessibility statement
    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