[D365 Project Operation] How to Correct Duplicate Invoices

Scenario :
There is one invoice with number (INV-02403-B7F0H3) where amount is $ 23,908.
and Due to System issue, it Created Duplicate Invoice with number (INV-02402-R5S8B9) where amount is same $ 23,908.

Both the invoice are moved to Finance and operation and both invoice proposal are posted in FNO.

Now we need to correct these invoices.
To correct the invoice, we need to post a negative entry in FNO and make sure those milestone are not posted again to FNO.

Step 1 : Go To Projects Ops > Sales > Invoice and Open the invoice which was created by mistake by system,

Step 2 : Click Correct This Invoice Button from Ribbon and wait for some time, it will create new invoice

Step 3 : New Invoice will be created with Negative amount of same as duplicate amount, All values are same except amount is in negative , Click Confirm,

Step 4 : Click Confirm to Post Invoice Proposal in Finance & Operations

Go To > Finance & Operations > Module > Project Management & Accounting Module > Project invoice proposal

Search for the invoice proposal number which got generated by system in Project Ops

You will see, System has created Invoice proposal in FNO,

Catch (Optional) Step 5 :

In Case, If Invoice proposal is created in FNO with 0 value or not exact value, We need to “Import from staging table”, Sometime Values are in Staging table,
Go to Module > Project Management and Accounting > Click Import from staging and click ok to run batch job

Step 6 : POST INVOICE PROPOSAL, Now We have negative invoice proposal in FNO, We post the invoice in FNO and see its reversal entry in FNO.

You can see three entries now, one Correct one, another which was duplicated and last one the negative one which we did as a part of correction.

At Finance and Operation side, its done we can generate invoice and send to customer,
But Now the duplicated invoice which System created has Invoice milestone in Ready to Invoice status which is not correct, it may get post again if we keep it in Ready to invoice status.

What is the issue > Same contract for which duplicate invoice created,
That Contract line had 1 contract line and that contract line had 2 milestone,

This milestones once posted to FNO, status must be Customer invoice posted, but due to correction we did, the status for this two milestone has been reversed to Ready for Invoice,

Which is not true, We posted one correct invoice which was of $ 23,908, So we need to make the invoice milestone status as “Customer Invoice Posted” again.

IF you try to update directly on screen it will throw validation error,

2 onload JavaScript functions
1 on change JavaScript function
1 SDK message

All of above we need to disable so it allows us to update milestone status from ready to invoice to Customer invoice posted

Step 7 : Go To Default solution > Project milestone entity > Forms > Open Project Information Form

Click Form Properties

Disable Both onload functions

Click Ok, Save, and Publish.

Disable On Change Event of Invoice Status Field
Click Ok, Save, and Publish.

Go to Default Solution -> Sdk Message Processing Steps and find and deactivate the [Project Service – Pre Validate Update of msdyn_contractlinescheduleofvalue] step:

Disable it

Update Invoice status to Customer invoice posted for both the line items

Enable SDK steps which was disabled previously

Current Solution Layers for Project Contract line milestone entity > Project information form.

Remove this solution layer

This will roll back all the functional changes which we disabled on above steps