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) / Set customer invoice n...
Microsoft Dynamics AX (Archived)

Set customer invoice number sequence same as sales order

(0) ShareShare
ReportReport
Posted on by Dan Vandermeulen 700

Hello all,

I have a possible requirement to set the number sequence for Customer invoice to be the same as the Sales order.  I see where I can use the "Use same number as" field in the reference section of the Number sequences form.  However, I am not able to select Sales order when in the Customer invoice number sequence.  Does anyone know if this is possible to do?

A little background, we are using Sales orders to import customer invoices from another system so that we can bring other valuable information into AX 2012 via the Sales order.  Our hope is to have the Sales order number be the same as the Order from our other integrated system.  We would then post a customer invoice with the same number so that in the end our invoice number in AX matches the invoice number in our other integrated system.

Any ideas would be much appreciated!

Thank you,

Dan

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi Dan,

    I have the same problem,  did you find the solution? can you help me?

    Any ideas would be much appreciated!

    Thank you,

    Johanna

  • Andrew Xu Profile Picture
    Andrew Xu 3,877 on at

    I think the reason why out-of-box AX does not allow the invoice id to be the same as sales order Id is because the 1 sales order can have multiple invoices.

    But you can add customization to realize this. Try to add code to the class 'SalesInvoiceJournalCreate', method 'initJournalHeader' to keep the invoice id be the same as sales Id.

  • Dan Vandermeulen Profile Picture
    Dan Vandermeulen 700 on at

    Hi Johanna,

    We came to the same conclusion as Andrew suggested.  Ax does not allow it to be the same.  We ended up having our MS partner create a customization for this.  In our process we are importing sales orders from an outside system.  Then generating invoices on that sales order.  Our customization was created to give us a check box to check on the sales order that tells AX to use the sales order number as the invoice number when an invoice is generated.

    This way, if we ever do want the ability to create multiple invoices on 1 sales order, we would not check the box on the sales order and it would adhere to standard AX number sequence functionality.

    Hope that helps!

    Dan

  • Community Member Profile Picture
    Community Member on at

    Hi Dan!!!,

    Thanks a lot!!!, thi is the unique solution for this situation ... and i will do the customization,

    if you need any developments on ax 2012 not hesitate to contact me.

    Johanna

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