Customer Invoices

(0) Share

Report

Posted on by AdnDalhi

336

Hello,

I have a quick technical question about, the exact AX table to use for the Customer Invoices, i need to retreieve these fields for each customer invoice whatever the status

Creation date time of the customer invoice
Cust account
Invoice ID
Status
Billing Address

I'm wondering if the "CustInvoiceJour" the correct tables to use or not, could you please confirm me this quick information :)

Thanks in advance :)

*This post is locked for comments

I have the same question (0)

All responses (20)

Answers (1)

Suggested answer

Mea_ 60,284 on at

Like (1)

Report

RE: Customer Invoices

It is correct source and has all fields required.

Was this reply helpful? Yes No
AdnDalhi 336 on at

Like (0)

Report

RE: Customer Invoices

Perfect, thanks Ievgen :)

Was this reply helpful? Yes No
Suggested answer

Mohammed Khatib 430 on at

Like (1)

Report

RE: Customer Invoices

Hi,

CustInvoiceJour table will hold all posted invoices, there is no Status on this table. You can retrieve the details as below:

Select CreatedDateTime, InvoiceAccount, InvoiceId, CustInvoiceJour.INVOICEPOSTALADDRESS from CustInvoiceJour

Thanks.

Was this reply helpful? Yes No
AdnDalhi 336 on at

Like (0)

Report

RE: Customer Invoices

Hi Mohammed,

Thanks a lot, from where can i get the cust invoice status please, i do not only need posted but all invoices whatever the status.

Thanks in advance :)

Was this reply helpful? Yes No
Mohammed Khatib 430 on at

Like (0)

Report

RE: Customer Invoices

Do you have active Customer Free Text Invoices Workflow?

Was this reply helpful? Yes No
AdnDalhi 336 on at

Like (0)

Report

RE: Customer Invoices

No, im not activating workflow on Cust Free text

Was this reply helpful? Yes No
Mohammed Khatib 430 on at

Like (1)

Report

RE: Customer Invoices

So can you tell me what kind of status you are looking for? list the possible values and I can help you out with it.

Was this reply helpful? Yes No
AdnDalhi 336 on at

Like (0)

Report

RE: Customer Invoices

Thanks Mohammed,

I would like to know is the cust invoice is paid or not

Thanks

Was this reply helpful? Yes No
Mohammed Khatib 430 on at

Like (1)

Report

RE: Customer Invoices

Last question from my side, do you need this to be done in SQL or X++?

Was this reply helpful? Yes No
AdnDalhi 336 on at

Like (0)

Report

RE: Customer Invoices

Thanks Mohammed,

Yes, i'm using SQL now

Was this reply helpful? Yes No