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

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / From what table is Sal...
Microsoft Dynamics AX (Archived)

From what table is Sales Tax displayed?

(0) ShareShare
ReportReport
Posted on by Community Member

When the "totals" button is clicked on a sales order, information about the order is displayed on the screen such as subtotal amount, Total discounts, Sales Tax ... among others. What table is this information being pulled from in order to display this information on this screen? If they all come from different locations, which table does the Sales tax field get pulled from to be displayed to the screen?

I want to be able to change the values in those tables and get those changes to be displayed when this screen is displayed.

*This post is locked for comments

I have the same question (0)
  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,636 Super User 2026 Season 1 on at

    on totals form this is shown by run-time computation. a class named SalesTotal is used for this.

    Once order is invoiced the sales tax information is saved in invoice tables which are probably CustInvoiceJour and CustInvoiceTrans.

  • Community Member Profile Picture
    Community Member on at

    I'm looking more into the SalesTotals, because I'm only working with sales orders (more like quote calls as opposed to invoices).  I think I understand your response, but correct me if I am not.

    My Understanding:

    You are saying that the display that appears on the screen, after I click the "totals" button, gathers the information from the salesTotals class and then displays the information. (The quote call information from the sales order).

    If I wanted to display the information from an invoiced order (sales invoice) then I would pull the information from CustInvoiceTrans table.

    Now if my understanding is correct, then where would I pull the information from in the SalesTotals class? Either the table this information gets stored in, or the method that displays the information would be exactly what I need in order to progress. (I know it isn't the SalesTable or SaleLine tables because neither of them contain the taxAmount variable). If my understanding is not correct can you please rephrase/explain?

  • Community Member Profile Picture
    Community Member on at

    you can take look at taxjournaltrans and taxtrans table

  • Verified answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 49,636 Super User 2026 Season 1 on at

    As you click that totals button and order is open, the amounts are calculated at run-time to show you total.Fixing total and keeping those somewhere before order is invoiced, means you are writing too many modifiedField methods, in the sense you have to update your totals every time if there is change in any of the lines. So AX author is adopting good way to show you by calculation at runtime. For invoiced part information is saved in tables. Though if you would look at tables which are before invoice such as CustConfirmJour (which is for order confirmation), you can find amount fields in that table. But it’s hard to trust those, because anytime user can change any line(s) in order and confirmation will not have updated information unless you re-confirm order. This makes sense to calculate at run-time, for non-invoiced order

  • Verified answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 49,636 Super User 2026 Season 1 on at

    One more point which I forget to add for your observation, in standard system if you will click Totals buttons for an invoiced order, you will see TOTALS as zero.

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the January Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans