Announcements
No record found.
I'm very new to Dynamics. I'm using Dynamics AX (not sure which version) Finance and Operations. I'm trying to find the invoice amount in the database for a sales order with open order status. The CustInvoiceJour table doesn't have a record for this sales order since it's not in Invoiced status yet, but I can see an invoice total amount on the Sales Order Totals screen (Sales Order - View - Totals). I can also see a SalesOrderTotals table but it's empty. Can anybody tell me which table stores the invoice amount?
Hi appsac,
The invoice total is not stored as this is depending on what exactly you will go and invoice. The sales totals form can calculate the total sales amount depending on several parameters, but this value is not stored in the database. It calculates it from sales order lines, discounts, charges and sales tax.
Thanks for your quick reply.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 658
André Arnaud de Cal... 468 Super User 2026 Season 1
Syed Haris Shah 333 Super User 2026 Season 1
