web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / The link between Gener...
Microsoft Dynamics AX (Archived)

The link between General Ledger and Sales Ledger

(0) ShareShare
ReportReport
Posted on by Mangosteen 5

Hi All,

I hope someone could enlighten me with what link between general ledger and sales ledger. We are using Microsoft Dynamic AX 2009 ( very old version) and I would like to have all sales orders number link to finish goods (general ledger account). I am using Microsoft query to our database as I don't know how to use SQL. When I try to link LedgerTrans and CustTrans, Total sum of transaction for Finish Good does not agree with TB.

Thanks very much for your help.

Shu

*This post is locked for comments

I have the same question (0)
  • Mangosteen Profile Picture
    Mangosteen 5 on at

    Hi Crispin,

    Thank you so much for your prompt reply. Sorry I don't know anything about SQL so I am using Microsoft Query to extract data from our database. I have linked CustTrans.Voucher == LedgerTrans.Voucher, CustInvoiceJour.InvoiceId ==CustTrans.InvoiceId (there is no field name called 'invoiceid' on CustTrans table, only 'Invoice' ), I don't understand what it means (LedgerTrans.Posting == LedgerPostingType::CustBalance )

    I can see a field name 'Posting' on LedgerTrans table.

    Thanks

    Shu

  • Verified answer
    Rustem Galiamov Profile Picture
    Rustem Galiamov 8,072 on at

    Hi Mangosteen!

    If you have access to AOT in Ax you can try to check the Relation node of the table and get relations from there.

    Screenshot-2018_2D00_11_2D00_29-at-17.14.13.png

    The LedgerTrans.Posting field contain value about type of transaction (Tax, Cust balance, Vend payments ...).

  • Mangosteen Profile Picture
    Mangosteen 5 on at

    Thank you very much, Rustem. I don't have AOT in Ax as the system has not been upgraded for years since it was installed. I only have a little bit of knowledge of Microsoft Query. Is there anything you can suggest how I can learn about table relationship?

    Thanks

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans