Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Set or Change InvoiceId

Set or Change InvoiceId

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello everyone,

My team and I are currently working on a project where we are onboarding several new locations into our Dynamics AX 2012 R2 environment.

We would like to historically add sales orders / invoices into AX to represent sales orders / invoices from legacy systems used by these new locations.

With that being said, I have exposed some X++ code via an AIF inbound port to dynamically create sales orders, sales lines, and post the sales order to create an invoice.

However, we would like to use the original invoice number from the legacy system once the invoice has been 'recreated' in Dynamics AX.

Can anyone think of a way to either:

1. Set the invoice number to be used before invoicing the sales order so it uses that number

2. Reliably Update all of the related records after the fact such as InvoiceId on CustInvoiceJour, CustInvoiceTrans, Invoice on CustTrans ... etc?

Any and all help on this would be greatly appreciated.

Thank you,

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Set or Change InvoiceId

Hi,

Why don't you write the old invoice number into a new field or even an existing one such as the customer reference field? To me this seems safer and easier than trying to change or modify the AX invoice number.

Best regards

Ludwig