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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Customer Invoices
Microsoft Dynamics AX (Archived)

Customer Invoices

(0) ShareShare
ReportReport
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

  1. Creation date time of the customer invoice
  2. Cust account
  3. Invoice ID
  4. Status
  5. 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)
  • Suggested answer
    Mea_ Profile Picture
    Mea_ 60,284 on at

    It is correct source and has all fields required.

  • AdnDalhi Profile Picture
    AdnDalhi 336 on at

    Perfect, thanks Ievgen :)

  • Suggested answer
    Mohammed Khatib Profile Picture
    Mohammed Khatib 430 on at

    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.

  • AdnDalhi Profile Picture
    AdnDalhi 336 on at

    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 :)

  • Mohammed Khatib Profile Picture
    Mohammed Khatib 430 on at

    Do you have active Customer Free Text Invoices Workflow?

  • AdnDalhi Profile Picture
    AdnDalhi 336 on at

    No, im not activating workflow on Cust Free text

  • Mohammed Khatib Profile Picture
    Mohammed Khatib 430 on at

    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.

  • AdnDalhi Profile Picture
    AdnDalhi 336 on at

    Thanks Mohammed,

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

    Thanks

  • Mohammed Khatib Profile Picture
    Mohammed Khatib 430 on at

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

  • AdnDalhi Profile Picture
    AdnDalhi 336 on at

    Thanks Mohammed,

    Yes, i'm using SQL now

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans