BeyondERP.Newsletter
Menu

Job page · Sales and marketing

Delete proforma invoices manually

A cleanup page that lists proforma invoices by customer account, due date, date, invoice account, sales order and invoice amount, so an orphaned one can be deleted.

Business process
Invoice sales orders in Dynamics 365 Supply Chain Management
Menu item
CustInvoiceProformaCorrection
Main table
CustInvoiceJour
Data entity
SalesInvoiceHeaderV2Entity
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA cleanup page that lists proforma invoices by customer account, due date, date, invoice account, sales order and invoice amount, so an orphaned one can be deleted.
What you do hereUse it to delete a proforma invoice that was orphaned when the system was interrupted during the sales proforma invoice process.
ExampleFor example, a service interruption stops the proforma invoice run for BEAT order SO-001234; the orphaned proforma invoice of 4,250.00 for BEAT-000123 is deleted here and a new proforma invoice is printed from the order.
Delete proforma invoices manually page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processManage accounts receivable › Issue sales invoices › Invoice sales orders in Dynamics 365 Supply Chain Management
Menu pathSales and marketing › Periodic tasks › Clean up › Delete proforma invoices manually
Set up firstAll sales orders Microsoft Learn
Used next byAll sales orders Microsoft Learn
Related pagesCorrect invoice journal link to sales order Checked in Dynamics 365
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itAfter a system interruption during the sales proforma invoice process has left an orphaned proforma invoice.
How oftenOn demand, only after an interrupted proforma invoice run.
What the output showsThe list of proforma invoices. A proforma invoice is an estimate prepared before posting, so deleting it changes no posted amount.

Source: Microsoft Learn

Setup steps on this page

Delete orphaned proforma invoices

Clear a proforma invoice left behind by an interrupted run so the order can be processed again.

Steps from Microsoft

  1. Go to Sales and marketing > Periodic tasks > Clean up > Delete proforma invoices manually.
  2. Find the proforma invoice that was orphaned by the interrupted run, by sales order or customer account.
  3. Check Customer account, Sales order, Date and Invoice amount to be sure it is the orphaned one.
  4. Select it and select Delete.
  5. Print the proforma invoice again from the sales order if the customer still needs one.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Customer accountThe customer of the proforma invoice.Checked in Dynamics 365BEAT-000123
DueThe due date of the proforma invoice.Checked in Dynamics 365
DateThe date of the proforma invoice.Checked in Dynamics 365
Invoice accountThe invoice account of the proforma invoice.Checked in Dynamics 365
Sales orderThe sales order the proforma invoice was prepared for.Checked in Dynamics 365SO-001234
Invoice amountThe estimated invoice amount.Checked in Dynamics 3654,250.00

Common errors and fixes

MessageWhat to do
A proforma invoice for an order can't be printed again after an interrupted run.The interrupted run left an orphaned proforma invoice; delete it on this page, then print again. Microsoft Learn

Test checklist

  1. Find the orphaned proforma invoice for the sales order.
  2. Delete it.
  3. Check that 0 proforma invoices are listed for that sales order and a new one can be printed.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Delete orphaned proforma invoicesDelete only a proforma invoice orphaned by an interrupted run, checked by sales order and amount, then print a new one from the order.Microsoft names this page for orphaned proforma invoices after a system interruption; a proforma invoice is only an estimate before posting.Who deletes orphaned proforma invoices?Deleting proforma invoices that customers already received, so the document they hold no longer exists in the system.Test: Orphaned proforma invoice removed

Feature management and licence

Licence or add-inOn the live system, no standard role holds the Clean up proforma invoices duty; give it only to the users who handle interrupted invoice runs.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: proforma invoices are kept per legal entity. Microsoft data model
Can it be undoneIrreversible: A deleted proforma invoice can't be restored, but you can print a new one from the sales order. Delete only proforma invoices orphaned by an interrupted run. Microsoft Learn
If you change it laterDeletes the selected proforma invoice record. A proforma invoice is an estimate of the invoice amounts prepared before posting, so posted invoices and ledger amounts don't change. On the live system no standard role has the Clean up proforma invoices duty. Microsoft Learn
Technical architect

6Technical

Menu itemCustInvoiceProformaCorrection Checked in Dynamics 365
FormCustInvoiceProformaCorrection Checked in Dynamics 365
TableCustInvoiceJourShown as “Customer invoice journal” in Record infoChecked in Dynamics 365
Data entitiesSalesInvoiceHeaderV2EntitySales invoice headers V2 Microsoft data model SalesInvoiceJournalHeaderEntitySales invoice journal header Microsoft data model
Who can open itPrivilegesClean up proforma invoices. CustInvoiceProformaCorrectionDutiesClean up proforma invoices. CustInvoiceProformaCorrectionChecked in Dynamics 365
Actions on the pageOptions: Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CustInvoiceProformaCorrection
Integrate withSalesInvoiceHeaderV2Entity data entity Microsoft data model
Data migrationSalesInvoiceJournalHeaderEntity Posted invoice journal headers only.Load order: Proforma invoices are estimates and aren't migrated; print them again in the new system when needed.Microsoft Learn
Table definitionCustInvoiceJour columns and relations Microsoft data model
Everyone

8Sources