Microsoft Dynamics AX (Archived)

What is the field for the invoice date in the SalesTable in AX

(0) Share

Report

Posted on by SteveWhyte

583

Hi:

Which field should I use in the SalesTable in order to identify the invoice date in AX 2012 R3?

Thanks

Steve

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello Steve

Out of box AX has an Invoice date field under CustInvoiceJour table.

There is no invoice date field under SalesTable unless you have other customization on the table.

Thanks

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

The SalesTable does not hold the invoice date.

Please check the CustInvoiceJour Table and there the InvoiceDate field.

Best regards,

Ludwig

Was this reply helpful? Yes No
Rustem Galiamov 8,072 on at

Like (0)

Report
Copy link

Link copied!

Hi Steve Whyte!

What is you business requirement?

Was this reply helpful? Yes No
SteveWhyte 583 on at

Like (0)

Report
Copy link

Link copied!

Thanks Ludwig for your response:

I need to write some reports. Can you advise what tables and related tables I should use?

a. Sales by Customer/Country

b. Sales by Sku – units available, US dollars required also - to match the USD from territory sales

c. Sales by Brand by Country (Soaps) – units and dollars

Was this reply helpful? Yes No
SteveWhyte 583 on at

Like (0)

Report
Copy link

Link copied!

I need to write some reports. Can you advise what tables and related tables I should use?

a. Sales by Customer/Country

b. Sales by Sku – units available, US dollars required also - to match the USD from territory sales

c. Sales by Brand by Country (Soaps) – units and dollars

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Steve,

For a: There is a standard report in the sales and marketing module available called "customer turnover". Have you checked that one?

For b: Also in the sales and marketing module we have the "customer/item statistics" report, the "gross margin by item" and the "sales item group statistics" reports available.

For c: Here I do not know. What is your "brand"? Is this a Financial Dimension or another classification criteria? Please check the standard reports that are available in sales and marketing under the "statistics" menu. There might be one that fits your requirement.

Best regards,

Ludwig

Was this reply helpful? Yes No
André Arnaud de Cal... 304,293 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Steve,

If the standard reports are not suitable, you should use at least transaction tables for your reports. Sales invoices are stored in the tables CustInvoiceJour (header) and CustInvoiceTrans (lines). Possible, you need to look at inventory transactions, then you can also look at InventTrans and InventTransOrigin tables.

The SalesTable is a worksheet table which can be archived/deleted. So for this reason, please use the mentioned transaction tables as basis for your report.

Was this reply helpful? Yes No
SteveWhyte 583 on at

Like (0)

Report
Copy link

Link copied!

Thanks much Andre...Appreciated

Steve

Was this reply helpful? Yes No