Where can I find an open sales order invoice amount in the database

(0) Share

Report

Posted on by appsac

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?

All responses (2)

Answers (1)

appsac 5 on at

Like (0)

Report

RE: Where can I find an open sales order invoice amount in the database

Thanks for your quick reply.
Verified answer

André Arnaud de Cal... 292,516 Super User 2025 Season 1 on at

Like (0)

Report

RE: Where can I find an open sales order invoice amount in the database

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.