Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Relationship table Sales Line Invoice in ax 2009

Posted on by 10

Dear All,

Could you please guide for me how to get relationship between tables in Sales Line Invoice?

I try get from some tables: CUSTINVOICETRANS, CUSTINVOICEJOUR but I loss some rows data.

Many thanks

  • WillWU Profile Picture
    WillWU 22,350 on at
    RE: Relationship table Sales Line Invoice in ax 2009

    Hi partner,

    Please give us more details about your business requirement.Also please check the CustInvoiceSalesLink table, it links Sales orders and invoices.

  • Khoa Phan Tan Profile Picture
    Khoa Phan Tan 10 on at
    RE: Relationship table Sales Line Invoice in ax 2009

    Dear  Will WU,

    Please guide for me.

    How many tables is created from Sales Line Invoice?

    And if better, you no worry  please show me relationship this.

    Many thanks.

  • WillWU Profile Picture
    WillWU 22,350 on at
    RE: Relationship table Sales Line Invoice in ax 2009

    Hi Khoa Phan Tan,

    Not sure what you need,  you could get invoice account and customer name from CUSTINVOICETRANS.

    And please check INVENTTRANSID.

    CUSTINVOICETRANS.INVENTTRANSID=SalesLine.INVENTTRANSID

    Hope this helps.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans