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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Avoid Number sequence only for free text invoice created through integration

(0) ShareShare
ReportReport
Posted on by

Hi,

We have external application that is creating free text invoices  and once these invoices are created with its own number sequence in this external application, we migrate them to AX 2009.

As part of this migration, we create records in CustInvoiceTable and CustInvoiceLine tables through integration code. AX Users then post them manually or through batch job.

Now during posting in AX, it creates new number sequence for these free text invoices. We don't want to use AX's number sequence here for such invoices which are created externally as it has it's own number sequence. we want to use the same invoice number that has been set for the invoices created in the external application before. Same invoice number should be shown everywhere in AX i.e in AR module.

Also, if user creates invoices in AX directly (which didn't come from external application), it should use number sequence of AX only.

Is this possible  and how? Kindly provide some hints if anyone come across this scenario.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    ZvikaR Profile Picture
    190 on at

    The fix is in your integration code, not in AX.

    Somehow you need to get your integration code to by-pass the AX sequence number and populate the Free Text Invoice number to be populated manually.

  • Community Member Profile Picture
    on at

    Hi Zvika,

    Thanks for replying.

    As you can see that I mentioned that integration code is just making entries in CustInvoiceTable and CustInvoieLine and doesn't post them. Posting happens from AX 2009 by users manually or through AX batch jobs.

  • Suggested answer
    Community Member Profile Picture
    on at

    I found that the CustPostInvoiceJob class does posting job and it calls CustPostInvoice.run() method which creates invoiceId using the numbersequence. I believe this is where i need to put my logic to avoid number sequence in case if the CustInvoiceTable  record is created from Integration.

    Anyway, Thanks for your time.

  • ZvikaR Profile Picture
    190 on at

    your direction sounds correct, but I don't know more than that...

    good luck (and don't forget to mark the thread as closed)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans