Credit notes integration process

This feature introduces seamless integration of Revised invoices/Credit notes created in D365 Project Operations into Business Central. Confirmed Revised Invoices in Project Operations will now synchronize with Business Central through a configured Dataverse Connection setup.

New parameters have been added under the General tab in the evergreen parameter.

Allow partial credit notes – If set to No only complete invoices can be reversed. No option to reverse certain lines will be available
Auto confirm credit note invoice – If set to Yes, revised invoices will automatically change status to Confirmed after creation.

Fields and Descriptions

Field	Description
Allow Partial Credit Notes	If set to No, only complete invoices can be reversed
Auto Confirm Credit Note Invoice	If set to Yes, reversed invoices will automatically change status to Confirmed after creation.

evergreen BC Invoice staging enhancement

evergreen BC Invoice Staging, has been expanded with additional fields. When Revised invoices are confirmed in Project Operations, additional details will be added in header and lines of the original invoice.
Upon confirmation of a revised invoice, invoice details will automatically update in the evergreen BC Invoice Staging form based on the ‘Activate BC Invoice Integration’ parameter. If this parameter is turned off, users must manually trigger the ‘Process Confirmed Invoice’ button within the SAG BC Invoice Staging form to initiate the integration of invoice details into Business Central.

Sales > SAG BC Invoice Stagings

Fields and Descriptions

Field	Description
Is Correction Invoice	Indicates if the invoice has corrections or if it is revised.
Credit Note Invoice Id	Indicates the Credit Memo Id.
BC Unposted Credit Memo Id	Indicates the BC unposted document number.
BC Posted Credit Memo Id	Indicates the BC posted document number.

A button “Process Confirmed Invoices” in SAG BC Invoice stagings page, when the “Activate BC Invoice Integration” field has been set to No, clicking on this button will populate the staging table with these additional credit memos that are ready to be integrated from Project Operations to Business Central.

Integrate Credit memos in Business Central

A new table, “Dataverse Credit Memos,” has been introduced in Business Central to streamline the integration of Credit Memos from Project Operations. This integration ensures seamless synchronization and supports both manual and automatic updates between Project Operations and Business Central.

Users can create Credit memos from Project Operations directly into Business Central.

Users can select a record in the Dataverse Credit memos form and manually trigger the “Correct Invoice” button. This action will create credit memos in Business central.
A “Coupled” field in the Dataverse Credit memos table switches to “Yes” upon successful creation of the invoices in Business Central. Sales Documents from Navigation Menu)> Sales Credit memo > Dataverse Credit memos

Invoice header details:

Fields and Descriptions

Field	Description
Coupled	Is a Yes/No field which indicates if data has been created in BC or not.
Credit Note Invoice ID	Indicates the Credit note Invoice ID in Project Operations.
Invoice ID	Indicates the Invoice ID in Project Operations.
Document Date	Indicates the document creation date.
BC Posting Date	Indicates the BC posting date.
BC Unposted Credit Memo ID	Indicates the Unposted Credit Memo ID in BC.
BC Posted Credit Memo ID	Indicates the Posted Credit Memo ID in BC.
BC Unposted Invoice Number	Indicates the Unposted Invoice No in BC.
BC Posted Invoice No	Indicates the Posted Invoice No in BC.
Customer Account Number	Indicates the Customer No in BC.
Currency	Indicates the currency code.
Status	Indicates the status of the Credit Memo line.
Total Tax	Indicates the total tax on the invoice.
Total Amount	Indicates the total amount of the Credit Memo.
Modified On	Indicates when the invoice was last modified.

Invoice lines details:

Fields and Descriptions

Field	Description
Coupled	Is a Yes/No field indicating if data has been created in BC or not.
Name	Indicates the Name on the credit memo line.
Document No	Indicates the Invoice number.
Description	Indicates the description of the invoice line.
Billing Type	Indicates the billing type of the invoice.
Transaction Category	Indicates the transaction category of the invoice.
Transaction Class	Indicates the transaction class of the invoice.
Dimension Code	Indicates the project ID that the invoice belongs to.
Dimension Value	Indicates the project GUID that the invoice belongs to.
Quantity	Indicates the quantity in the invoice lines.
Unit Price	Indicates the unit price of the invoice line.
Line Amount	Indicates the line amount of the invoice.
Status	Indicates the status of the invoice line.
Line Amount (Base)	Indicates the line amount of the invoice in base currency.
Created On	Indicates when the invoice line was created.
Exchange Rate	Indicates the exchange rate of the invoice line.
Import Sequence Number	Indicates the sequence number imported.
Modified On	Indicates when the invoice line was last modified.

Once Credit memo is successfully integrated, it will create unposted Credit memo in Business Central.
Sales Documents (from Navigation Menu) >Sales Credit Memos >Business Central > Unposted Credit memos

Fields and Descriptions

Field	Description
Coupled	Is a Yes/No field indicating if data has been created in BC or not.
Name	Indicates the Name on the credit memo line.
Document No	Indicates the Invoice number.
Description	Indicates the description of the invoice line.
Billing Type	Indicates the billing type of the invoice.
Transaction Category	Indicates the transaction category of the invoice.
Transaction Class	Indicates the transaction class of the invoice.
Dimension Code	Indicates the project ID that the invoice belongs to.
Dimension Value	Indicates the project GUID that the invoice belongs to.
Quantity	Indicates the quantity in the invoice lines.
Unit Price	Indicates the unit price of the invoice line.
Line Amount	Indicates the line amount of the invoice.
Status	Indicates the status of the invoice line.
Line Amount (Base)	Indicates the line amount of the invoice in base currency.
Created On	Indicates when the invoice line was created.
Exchange Rate	Indicates the exchange rate of the invoice line.
Import Sequence Number	Indicates the sequence number imported.
Modified On	Indicates when the invoice line was last modified.

User can validate the invoice details and process for posting. Once invoice is successfully posted, it will add under posted invoices form.

User can previously select what fields must not be subjected to manual change in BC before posting by selecting the respective filed.

Sales Documents (from Navigation Menu) >Sales Credit Memos >Business Central > Sales Credit Memo Non-changeable fields.

A new parameter is added in setting which defines if the posting of credit memos is done manually or automatically

Administration (from Navigation Menu) >Dataverse integration setup>tab sales

In field Correct posted invoice there are two options:

Cancel invoice – if this option selected posting of Credit Notes is done automatically
Create credit memo – if this option selected posting of Credit notes is done manually by the user

Once posted
Sales Documents (from Navigation Menu) >Sales Credit Memos >Business Central > Posted Credit Memos.

Cancel transactions

Before invoice is posted in Business Central, if invoices are Revised in D365 Project Operations, then the invoice moves from Dataverse Invoices to Dataverse Credit memos with BC Unposted Invoice Number column set to Deleted when the Invoices are Corrected by using the Correct Invoice button.
Sales Documents (from Navigation Menu) >Sales Credit Memos > Dataverse Credit memos

Correct Invoices

Correct Invoices: Invoice correction is enabled, and the BC Unposted Invoice Number column is set to “Deleted”.

Invoice Header Details

Field	Description
Coupled	Is a Yes/No field indicating if data has been created in BC or not.
Credit Note Invoice ID	Indicates the Credit Note Invoice ID in Project Operations.
Invoice ID	Indicates the Invoice ID in Project Operations.
Document Date	Indicates the document creation date.
BC Posting Date	Indicates the BC posting date.
BC Unposted Credit Memo ID	Indicates the Unposted Credit Memo ID in BC.
BC Posted Credit Memo ID	Indicates the Posted Credit Memo ID in BC.
BC Unposted Invoice Number	Indicates the Unposted Invoice Number in BC.
BC Posted Invoice Number	Indicates the Posted Invoice Number in BC.
Customer Account Number	Indicates the Customer Number in BC.
Currency	Indicates the currency code.
Status	Indicates the status of the Credit Memo line.
Total Tax	Indicates the total tax on the invoice.
Total Amount	Indicates the total amount of the Credit Memo.
Modified On	Indicates when the invoice was last modified.

Invoice Line Details

Field	Description
Coupled	Is a Yes/No field indicating if data has been created in BC or not.
Name	Indicates the Name on the credit memo line.
Document No	Indicates the Invoice number.
Description	Indicates the description of the invoice line.
Billing Type	Indicates the billing type of the invoice.
Transaction Category	Indicates the transaction category of the invoice.
Transaction Class	Indicates the transaction class of the invoice.
Dimension Code	Indicates the project ID that the invoice belongs to.
Dimension Value	Indicates the project GUID that the invoice belongs to.
Quantity	Indicates the quantity in the invoice lines.
Unit Price	Indicates the unit price of the invoice line.
Line Amount	Indicates the line amount of the invoice.
Status	Indicates the status of the invoice line.
Line Amount (Base)	Indicates the line amount of the invoice in base currency.
Created On	Indicates when the invoice line was created.
Exchange Rate	Indicates the exchange rate of the invoice line.
Import Sequence Number	Indicates the sequence number imported.
Modified On	Indicates when the invoice line was last modified.

Once the invoice has been corrected(cancelled) in Business Central, the Project Service Invoices page in D365 Project Operations is also updated with the latest info