Edit

Share via


Customize Electronic reporting configurations to generate an electronic document

Note

Community interest groups have now moved from Yammer to Microsoft Viva Engage. To join a Viva Engage community and take part in the latest discussions, fill out the Request access to Finance and Operations Viva Engage Community form and choose the community you want to join.

The Electronic reporting (ER) framework lets you upload the ER configurations that Microsoft provides into your Microsoft Dynamics 365 Finance instance. By using these Microsoft-provided configurations, you can generate electronic customer invoices (e-invoices). Use this ER solution to configure your custom ER solution to access your custom database fields and generate e-invoices that comply with your specific requirements, without editing the source code.

Overview

For the example in this article, you must specify a federal tax identification code as a new custom attribute for every customer that you electronically invoice. Therefore, you must customize the structure of the invoice that is currently used by adding a new item that you fill with the tax code in every e-invoice that you generate.

The procedures in this article explain how a user in the System Administrator, Electronic Reporting Developer, or Electronic Reporting Functional Consultant role can perform the following tasks in your Finance instance:

You can complete all these procedures in the DEMF company.

Configure the ER framework

As a user in the Electronic Reporting Functional Consultant or Electronic Reporting Developer role, you must configure the minimal set of ER parameters. You can then start to use the ER framework to design custom versions of the standard configurations of the ER solution that is used to generate e-invoices.

Configure ER parameters

  1. Go to Organization administration > Workspaces > Electronic reporting.
  2. On the Localization blueprint page, in the Related links section, select Electronic reporting parameters.
  3. On the Electronic reporting parameters page, on the General tab, set the Enable design mode option to Yes.
  4. On the Attachments tab, in the Configurations field, select File.
  5. In the Job archive, Temporary, Baseline, and Others fields, select the File type.

For more information about ER parameters, see Configure the ER framework.

Activate an ER configuration provider

Each ER configuration you add is owned by an ER configuration provider. The ER configuration provider that you activate in the Electronic reporting workspace is used for this purpose. Therefore, you must activate an ER configuration provider in the Electronic reporting workspace before you start to add or edit ER configurations.

Note

Only the owner of an ER configuration can edit it. Therefore, before you can edit an ER configuration, you must activate the appropriate ER configuration provider in the Electronic reporting workspace.

Review the list of ER configuration providers

  1. Go to Organization administration > Workspaces > Electronic reporting.
  2. On the Localization blueprint page, in the Related links section, select Configuration providers.
  3. On the Configuration provider table page, each provider record has a unique name and URL. Review the contents of this page. If a record for Litware, Inc. (https://www.litware.com) already exists, skip the next procedure, Add a new ER configuration provider.

Add a new ER configuration provider

  1. Go to Organization administration > Workspaces > Electronic reporting.
  2. On the Localization blueprint page, in the Related links section, select Configuration providers.
  3. On the Configuration providers page, select New.
  4. In the Name field, enter Litware, Inc.
  5. In the Internet address field, enter https://www.litware.com.
  6. Select Save.

Activate an ER configuration provider

  1. Go to Organization administration > Workspaces > Electronic reporting.
  2. On the Localization blueprint page, in the Configuration providers section, select the Litware, Inc. tile, and then select Set active.

For more information about ER configuration providers, see Create configuration providers and mark them as active.

Import the initial versions of standard ER configurations

To add the standard ER configurations to your current Finance instance, import them from the ER repository that you configured for that instance.

  1. Go to Organization administration > Workspaces > Electronic reporting.
  2. On the Localization blueprint page, in the Configuration providers section, select the Microsoft tile, and then select Repositories to view the list of repositories for the Microsoft provider.
  3. On Configuration repositories, select the repository of the Global type, and then select Open. If you're prompted for authorization to connect to Regulatory Configuration Service, follow the authorization instructions.
  4. On Configuration repository, in the configuration tree in the left pane, select the Peppol Sales Invoice format configuration.
  5. On the Versions FastTab, select version 11.2.2.
  6. Select Import to download the selected version from the Global repository.

Screenshot of the Configuration repository page.

Tip

If you have trouble accessing the Global repository, you can download configurations from Microsoft Dynamics Lifecycle Services instead.

Review the imported ER configurations

  1. Go to Organization administration > Workspaces > Electronic reporting.
  2. On the Localization blueprint page, in the Configurations section, select the Reporting configurations tile.
  3. On the Configurations page, expand the Configuration components FastTab.
  4. In the configuration tree in the left pane, expand Invoice model, and then expand UBL Sales invoice.

You see that, in addition to the selected Peppol Sales Invoice ER format, the import process brings in other required ER configurations. Because new versions of ER configurations are constantly published to the Global repository and Lifecycle Services to keep the corresponding solutions compliant with new requirements, the latest versions of the required data model configuration and its model mapping configurations are imported.

Screenshot of the Configurations page.

To simulate the state that ER configurations in the current Finance instance would be in if you imported version 11.2.2 of the Peppol Sales Invoice ER format in the past (for example, on August 7, 2019), follow these steps:

  • On the Action Pane, select Delete to delete all ER configurations that were published after August 7, 2019. The only Invoice model, Invoice model mapping (initially named Customer invoice model mapping), UBL Sales invoice, and Peppol Sales Invoice configurations remain.
  • For the remaining ER configurations, on the Versions FastTab, select Delete to delete all versions of ER configurations that were published after August 7, 2019.

Then verify that the following configurations are available in the configuration tree:

  • Invoice model ER data model configuration (initially named Customer invoice model):

    • Version 11 contains version 10 of the data model ER component that represents the data structure of the invoicing business domain. This ER configuration is imported as an ancestor of the Peppol Sales Invoice ER format that you selected for import.
    • Version 50 contains version 31 of the data model ER component. This ER configuration is imported as an ancestor of the August 7, 2019, version of the Invoice model mapping ER model mapping configuration.

    Screenshot of the Invoice model ER data model configuration on the Configurations page.

    Tip

    If you don't see version 50 of this data model, open the Global repository, and import version 50.19 of the Invoice model mapping ER configuration.

  • Invoice model mapping ER model mapping configuration (initially named Customer invoice model mapping):

    • Version 50.19 is imported as the latest implementation of version 50 of the Invoice model ER data model configuration. It contains two model mapping ER components that describe how the data model is filled in with application data at runtime.

    Screenshot of the Invoice model mapping ER model mapping configuration on the Configurations page.

    Tip

    If you don't see version 50.19 of this model mapping, open the Global repository, and import version 50.19 of the Invoice model mapping ER configuration.

  • UBL Sales invoice ER format configuration:

    • Version 11.2 contains the format and format mapping ER components. The format component specifies the report layout. The format mapping component contains the model data source and specifies how this data source is used to fill in the report layout at runtime. This ER format is configured to generate e-invoices in Universal Business Language (UBL) format. It's imported as a parent of the Peppol Sales Invoice ER format that you selected for import.
  • Peppol Sales Invoice ER format configuration:

    • Version 11.2.2 contains the format and format mapping ER components that are configured to generate e-invoices in Pan-European Public Procurement OnLine (PEPPOL) format.

    Screenshot of the Peppol Sales Invoice ER format configuration on the Configurations page.

Configure the Accounts receivable parameters

  1. Go to Accounts receivable > Setup > Accounts receivable parameters.
  2. On the Electronic documents tab, in the Electronic reporting section, select Peppol Sales Invoice in the Sales and Free text invoice field.
  3. Select Save.

Screenshot of the Electronic documents tab on the Accounts receivable parameters page.

Configure the legal entity parameters

  1. Go to Organization administration > Organizations > Legal entities.
  2. For the selected DEMF company, in the Bank account information section, enter 1234 in the Routing number field.
  3. Select Save.
  4. Close the Legal entities page.

Prepare a customer record

  1. Go to Accounts receivable > Customers > All customers.
  2. On the All customers page, select the DE-014 customer account link.

Add a customer contact

  1. Go to Accounts receivable > Customers > All customers.
  2. On the Action Pane, on the Customer tab, in the Accounts group, select Contacts.
  3. Select Add contacts.
  4. On the Contacts page, in the First name field, open the lookup, select Adam Carter, and then select Select to close the lookup.
  5. Select Save.
  6. Close the Contacts page.

Define a primary contact

  1. Go to Accounts receivable > Customers > All customers.
  2. On the Sales demographics FastTab, in the Primary contact field, select Adam Carter.

Set the e-invoicing option

  1. Go to Accounts receivable > Customers > All customers.
  2. On the Invoice and delivery FastTab, set the eInvoice option to Yes.
  3. Select Save.
  4. Close the All customers page.

Process a customer invoice by using the standard ER configurations

Use the standard ER configurations that you imported to electronically send a free text invoice to a customer.

Add a new invoice

  1. Go to Accounts receivable > Invoices > All free text invoices.

  2. On Free text invoice, select New.

  3. On the Free text invoice header FastTab, in the Customer account field, select DE-014.

  4. On the Invoice lines FastTab, an invoice line is automatically added. On this line, set the following fields:

    • In the Description field, enter Notebook.
    • In the Main account field, select 401100.
    • In the Unit price field, enter 1000.
  5. Select Save.

Screenshot of the Free text invoice page.

For more information, see Create a free text invoice.

Post a new invoice

  1. Go to Accounts receivable > Invoices > All free text invoices.
  2. On Free text invoice, on the Action Pane, select Post.
  3. In the Post free text invoice dialog box, select OK.

Screenshot of the Free text invoice details page.

Send a posted invoice

  1. Go to Accounts receivable > Invoices > All free text invoices.

  2. On Free text invoice, on the Action Pane, in the Document group, select Send > Original.

    Screenshot of the preview of the original invoice.

  3. Close Free text invoice.

Analyze a generated e-invoice

  1. Go to Organization administration > Electronic reporting > Electronic reporting jobs.

  2. On Electronic reporting jobs, select the initial record that has the task description Send the eInvoice XML.

  3. Select Show files to access the list of generated files.

    Screenshot of the Electronic reporting jobs page.

  4. Select Open to download the e-invoice XML file.

  5. Analyze the e-invoice XML file. The customer tax schema is currently represented by the schemeID and schemeAgencyID XML attributes. The cbc:CustomizationID XML element currently contains the following text: urn:www.cenbii.eu:transaction:biicoretrdm010:ver1.0:# urn:www.peppol.eu:bis:peppol5a:ver1.0.

    Screenshot of the preview of the generated e-invoice XML file.

Add a custom database field

Use the Custom field feature to customize the current Finance instance:

  • Customize the database structure by adding a new custom database field that stores a federal tax identification code for every customer.
  • Customize the Customer page by adding a new data entry field that you can use to enter a tax code value in the new custom database field.

Follow these steps to do the customization.

  1. Go to Accounts receivables > Customers > All customers.

  2. On the All customers page, select the DE-014 customer account link.

  3. On the General FastTab, right-click any blank area under the Language field, and then select Personalize: UpperGroup.

    The contents of the General FastTab are highlighted, and a Personalize menu appears.

  4. On the Personalize menu, select Add a field.

  5. In the Add columns dialog box, select Create new field.

  6. In the Create new field dialog box, in the Table name field, select Customers.

  7. In the Name prefix field, enter FederalTaxID.

    Note

    The whole field name is automatically defined as FederalTaxID_Custom.

  8. In the Label field, enter Federal Tax ID.

  9. In the Type field, select Text.

  10. In the Length field, enter 20.

  11. Select Save.

  12. In the message box that appears, select Yes to confirm that you want to create a new FederalTaxID field entry for the Customers table.

  13. Select Insert to add the FederalTaxID_Custom field to the current page.

    Screenshot of the All customers page.

  14. Close the All customers page.

Refresh the ER metadata

To make the custom field you added visible in the ER model mapping designer, refresh the ER metadata.

  1. Go to Organization administration > Electronic reporting > Rebuild table references.
  2. In Update data model, select OK.

Design the custom ER configurations

Use the Microsoft-provided ER configurations as a starting point to design your custom ER configurations. This way, you can generate e-invoices that contain the new tax code.

Customize the data model configuration

As a user in the Electronic Reporting Functional Consultant role, you can design your custom ER data model.

Add a custom data model configuration

  1. Go to Organization administration > Electronic reporting > Configurations.
  2. On Configurations, in the configuration tree in the left pane, select Customer invoice model.
  3. On the Action Pane, select Create configuration.
  4. In the drop-down dialog box, in the New field, select Derive from Name: Customer invoice model, Microsoft to indicate that your new custom ER data model configuration should be based on the ER data model configuration.
  5. In the Name field, enter Invoice model (Litware).
  6. Select Create configuration to add the new ER configuration.

You can now use the ER data model designer to edit version 50.1 of the Invoice model (Litware) ER configuration in Draft status.

Screenshot of version 50.1 of the ER configuration on the Configurations page.

Configure a custom data model

Modify your custom data model by adding a new field to provide the value of a federal tax identification code. This code is part of the customer data for every ER format that uses this data model as a data source.

  1. On Configurations, in the configuration tree in the left pane, select Invoice model (Litware).

  2. On the Versions FastTab, select version 50.1 of the selected ER data model configuration in Draft status.

  3. On the Action Pane, select Designer for the selected configuration version.

  4. On the Data model designer page, in the data model tree, select Customer information (Customer).

  5. Select New.

  6. In the drop-down dialog box, in the New node as a field, accept the default value, Child of an active node.

  7. In the Name field, enter FederalTaxID_Litware.

  8. In the Item type field, accept the default value, String.

  9. Select Add, and then select Save.

    Screenshot of the Data model designer page.

    Note

    The Label and Description fields describe the purpose of the new field. You can fill in these fields in multiple languages. For more information, see Design multilingual reports in Electronic reporting.

  10. Close the Data model designer page.

Complete a custom data model configuration

Complete your work with version 50.1 of your custom ER data model configuration to make it available so that other custom ER configurations can be added.

  1. Go to Organization administration > Electronic reporting > Configurations.
  2. On Configurations, in the configuration tree in the left pane, expand Invoice model, and select Invoice model (Litware).
  3. On the Versions FastTab, select Change status > Complete, and then select OK.

The status of version 50.1 changes from Draft to Completed, and the version becomes read-only. A new editable version, 50.2, is added and has a status of Draft. You can use this version to make further changes in your custom ER data model configuration.

Screenshot of version 50.1 completed on the Configurations page.

Customize the model mapping configuration

As a user in the Electronic Reporting Developer role, you can design your custom ER model mapping.

Add a custom model mapping configuration

  1. Go to Organization administration > Electronic reporting > Configurations.

  2. On Configurations, in the configuration tree in the left pane, expand Customer invoice model, and select Customer invoice model mapping.

  3. On the Action Pane, select Create configuration.

  4. In the drop-down dialog box, in the New field, select Derive from Name: Customer invoice model mapping, Microsoft to indicate that your new custom ER model mapping configuration should be based on the ER model mapping configuration.

  5. In the Name field, enter Invoice model mapping (Litware).

  6. In the Target model field, select Invoice model (Litware).

    Important

    This step is very important. If you omit it, you can't use your custom data model in the configured model mapping.

  7. Select Create configuration to add the new ER configuration.

Screenshot of adding a custom model mapping configuration on the Configurations page.

Configure a custom model mapping

You must modify your custom model mapping and specify how the custom FederalTaxID_Litware field of the custom data model should be filled in with application data at runtime.

  1. Go to Organization administration > Electronic reporting > Configurations.

  2. On Configurations, in the configuration tree in the left pane, expand Customer invoice model > Customer invoice model mapping, and select Invoice model mapping (Litware).

  3. On the Action Pane, select Designer.

  4. On the Model to datasource mapping page, select the Customer invoice mapping.

    Screenshot of the Model to datasource mapping page.

  5. Select Designer.

  6. On the Model mapping designer page, in the Data sources pane, expand the CustInvoiceJour data source that represents the CustInvoiceJour application table.

  7. Under CustInvoiceJour, expand Relations to review the list of relations of the many-to-one (N:1) type for the CustInvoiceJour table.

  8. Under CustInvoiceJour > Relations, expand Customers (CustTable) to access the fields and relations of the Customers (CustTable) table.

  9. Select the FederalTaxID_Custom data source field that you implemented earlier.

  10. In the Data model pane, expand Customer information (Customer), and select the FederalTaxID_Litware data model field.

  11. Select Bind.

    Screenshot of the Model mapping designer page.

  12. Select Save.

  13. Close the Model mapping designer page.

  14. Close the Model to datasource mapping page.

Complete a custom model mapping configuration

You must complete your work with version 50.19.1 of your custom ER model mapping configuration to make it available for use.

  1. Go to Organization administration > Electronic reporting > Configurations.
  2. On Configurations, in the configuration tree in the left pane, expand Customer invoice model > Customer invoice model mapping, and select Invoice model mapping (Litware).
  3. On the Versions FastTab, select Change status > Complete, and then select OK.

The status of version 50.19.1 changes from Draft to Completed, and the version becomes read-only. A new editable version, 50.19.2, is added and has a status of Draft. You can use this version to make further changes in your custom ER model mapping configuration.

Screenshot of version 50.19.1 completed on the Configurations page.

Note

The supported configuration lifecycle doesn't cover the lifecycle of database changes. If you export version 50.19.1 of the Invoice model mapping (Litware) configuration from the current Finance instance and try to import it into another instance that doesn't contain the custom FederalTaxID_Custom field in the CustTable table, an exception occurs. The exception states that the imported ER configuration isn't compatible with the metadata of the target Finance instance.

Customize the format configuration

As a user in the Electronic Reporting Functional Consultant role, you can design your custom ER format.

Add a custom format configuration

  1. Go to Organization administration > Electronic reporting > Configurations.

  2. On Configurations, in the configuration tree in the left pane, expand Customer invoice model > UBL Sales invoice, and select Peppol Sales Invoice.

  3. On the Action Pane, select Create configuration.

  4. In the drop-down dialog box, in the New field, select Derive from Name: Peppol Sales Invoice, Microsoft to indicate that your custom ER format configuration should be based on the ER format configuration.

  5. In the Name field, enter Peppol Sales Invoice (Litware).

  6. In the Data model field, select Invoice model (Litware) to use your custom data model and model mapping components.

    Note

    This step is very important. If you omit it, you can't use your custom data model in the configured format.

  7. In the Data model field, select the InvoiceCustomer root definition.

  8. Select Create configuration to add the new ER configuration.

Screenshot of adding a custom format configuration on the Configurations page.

You can now use the ER Operations designer to edit version 11.2.2.1 of the Peppol Sales Invoice (Litware) ER configuration in Draft status.

Screenshot of version 11.2.2.1 of the ER configuration on the Configurations page.

Configure a custom format

Modify your custom format by adding a new format element to fill in the value of an invoiced customer's federal tax identification code.

  1. Go to Organization administration > Electronic reporting > Configurations.
  2. On Configurations, in the configuration tree in the left pane, expand Customer invoice model > UBL Sales invoice > Peppol Sales Invoice, and select Peppol Sales Invoice (Litware).
  3. On the Action Pane, select Designer.
  4. In the format tree, expand XMLHeader > Invoice > cac:AccountingCustomerParty > cac:Party > cac:PartyTaxScheme > cac:TaxScheme, and select cbc:ID.
  5. Select Add, and then select XML > Attribute.
  6. In the Component property dialog box, in the Name field, enter FederalTaxID.
  7. Select OK to add a new format element to create a new FederalTaxID XML attribute in a generated XML file.
  8. In the format tree, under XMLHeader > Invoice > cac:AccountingCustomerParty > cac:Party > cac:PartyTaxScheme > cac:TaxScheme > cbc:ID, select FederalTaxID.
  9. Select Move up.

Screenshot of the new format element on the Format designer page.

Configure a custom format mapping

  1. On the Format designer page, on the Mapping tab, expand the Invoice data source of the Model type.

  2. Under Invoice, expand Customer information (Customer), and select FederalTaxID_Litware.

  3. Select Bind.

    Screenshot of the Format designer page.

  4. Select the Invoice data source of the Model type, and then select Edit.

  5. In the Version field, select version 1 of your custom data model, and then select OK.

  6. Select Save.

  7. Close the Format designer page.

Complete a custom format configuration

Complete your work with version 11.2.2.1 of your custom ER format configuration to make it available for use.

  1. Go to Organization administration > Electronic reporting > Configurations.
  2. On Configurations, in the configuration tree in the left pane, expand Customer invoice model > UBL Sales invoice > Peppol Sales Invoice, and select Peppol Sales Invoice (Litware).
  3. On the Versions FastTab, select Change status > Complete, and then select OK.

The status of version 11.2.2.1 changes from Draft to Completed, and the version becomes read-only. The system adds a new editable version, 11.2.2.2, with a status of Draft. Use this version to make further changes in your custom ER format configuration.

Screenshot of version 11.2.2.1 completed on the Configurations page.

Configure the Accounts receivable parameters to start using custom ER configurations

  1. Go to Accounts receivable > Setup > Accounts receivable parameters.
  2. On the Electronic documents tab, in the Electronic reporting section, select Peppol Sales Invoice (Litware) in the Sales and Free text invoice field.
  3. Select Save.

Screenshot of the Accounts receivable parameters page, Electronic documents tab, Electronic reporting FastTab.

Update a customer record by adding a federal tax identification code

  1. Go to Accounts receivable > Customers > All customers.

  2. On the All customers page, select the DE-014 customer account link.

  3. On the General section, enter LITWARE-6789 in the Federal Tax ID field.

  4. Select Save.

    Screenshot of the DE-014 customer details page.

  5. Close the All customers page.

Process a customer invoice by using custom ER configurations

Select and send a posted invoice

  1. Go to Accounts receivable > Invoices > All free text invoices.
  2. On Free text invoice, select the invoice that you previously added and posted.
  3. On the Action Pane, in the Document group, select Send > Original.
  4. Close Free text invoice.

Analyze a generated e-invoice

  1. Go to Organization administration > Electronic reporting > Electronic reporting jobs.

  2. On Electronic reporting jobs, select the latest record that has the task description Send the eInvoice XML.

  3. Select Show files to access the list of generated files.

  4. Select Open to download the e-invoice XML file.

  5. Analyze the e-invoice XML file. Notice that, in accordance with your customization, the customer tax schema includes the custom FederalTaxID XML attribute in addition to the schemeID and schemeAgencyID XML attributes. The value of this new XML attribute is specified by the LITWARE-6789 federal tax ID that you entered for an invoiced customer.

    Screenshot of the preview of the generated e-invoice XML file with your customizations.

Import the latest versions of standard ER configurations

To keep the set of standard ER configurations in your Finance instance up to date, import new versions whenever they become available in the ER repository that you configured for the instance.

  1. Go to Organization administration > Workspaces > Electronic reporting.
  2. On Localization configurations, in the Configuration providers section, select the Microsoft tile, and then select Repositories to view the list of repositories for the Microsoft provider.
  3. On Configuration repositories, select the repository of the Global type, and then select Open. If you're prompted for authorization to connect to Regulatory Configuration Service, follow the authorization instructions.
  4. On Configuration repository, in the configuration tree in the left pane, select the Peppol Sales Invoice format configuration.
  5. On the Versions FastTab, select version 32.6.7 of the selected ER format configuration that supports customer electronic invoices in PEPPOL BIS 3 format. For more information, see KB4490320.
  6. Select Import to download the selected version from the Global repository to the current Finance instance.

Screenshot of version 32.6.7 selected on the Configuration repository page.

For information about how to automate this process, see Import updated versions of ER configurations.

Review the imported ER configurations

  1. Go to Organization administration > Workspaces > Electronic reporting.
  2. On Localization configurations, in the Configurations section, select the Reporting configurations tile.
  3. Expand the Configuration components FastTab.
  4. In the configuration tree in the left pane, expand Invoice model. The name of Customer invoice model changed to Invoice model in one of the imported ER data model configurations.
  5. In the configuration tree in the left pane, expand Invoice model mapping. The name of Customer invoice model mapping changed to Invoice model mapping in one of the imported ER model mapping configurations.
  6. Expand UBL Sales invoice > Peppol Sales Invoice.

In addition to the selected Peppol Sales Invoice ER format, the latest versions of other required ER configurations are imported. Because new versions of ER configurations are constantly published to the Global repository and Lifecycle Services to keep the corresponding ER solutions compliant with new requirements, the latest versions of the required data model configuration and its model mapping configurations are imported.

Make sure that the following ER configurations are eventually available in the configuration tree:

  • Invoice model ER data model configuration:

    • Version 206 (or later) contains version 24 (or later) of the data model ER component that represents the data structure of the invoicing business domain. This ER configuration is imported as an ancestor of the latest available Invoice model mapping ER model mapping configuration.

    Screenshot of version 206 on the Configurations page.

  • Invoice model mapping ER model mapping configuration:

    • Version 206.132 (or later) is imported as the latest implementation of version 206 of the Invoice model ER data model configuration. It contains several model mapping ER components that describe how the data model is filled in with application data at runtime.

    Screenshot of version 206.132 on the Configurations page.

  • UBL Sales invoice ER format configuration:

    • Version 32.6 contains the format and format mapping ER components. The format component specifies the report layout. The format mapping component contains the model data source and specifies how this data source is used to fill in the report layout at runtime. This ER format is configured to generate e-invoices in UBL format. It's imported as a parent of the Peppol Sales Invoice ER format that you selected for import.
  • Peppol Sales Invoice ER format configuration:

    • Version 32.6.7 contains the format and format mapping ER components that are configured to generate e-invoices in PEPPOL format.

    Screenshot of version 32.6.7 on the Configurations page.

Adopt the changes to the new standard ER configurations in your custom ER configurations

Adopt your custom ER data model

  1. Go to Organization administration > Electronic reporting > Configurations.

  2. On Configurations, in the configuration tree in the left pane, expand Invoice model, and select Invoice model (Litware).

  3. On the Versions FastTab, for draft version 50.2 of the selected data model configuration, select Rebase.

  4. In the Target version field, confirm the selection of version 206 of the base ER data model configuration, and then select OK.

    The system renumbers the draft version of your custom ER data model configuration from 50.2 to 206.2 to indicate that it now contains your customization that was merged with the changes in the latest version (206) of the base ER data model configuration.

    Note

    The rebase action is reversible. To cancel this rebase, select version 50.1 of the Invoice model (Litware) model on the Versions FastTab, and then select Get this version. Version 206.2 is renumbered back to 50.2, and the content of draft version 50.2 matches the content of version 50.1.

  5. On the Versions FastTab, select Change status > Complete, and then select OK.

The status of version 206.2 changes from Draft to Completed, and the version becomes read-only. A new editable version, 206.3, is added and has a status of Draft. You can use this version to make further changes in your custom ER data model configuration.

Screenshot of version 206.2 completed on the Configurations page.

Adopt your custom ER model mapping

  1. Go to Organization administration > Electronic reporting > Configurations.

  2. On Configurations, in the configuration tree in the left pane, expand Invoice model > Invoice model mapping, and select Invoice model mapping (Litware).

  3. On the Versions FastTab, for draft version 50.19.2 of the selected model mapping configuration, select Rebase.

  4. In the Target version field, confirm the selection of version 206.132 of the base ER model mapping configuration, and then select OK.

    The system renumbers the draft version of your custom ER model mapping configuration from 50.19.2 to 206.132.2 to indicate that it now contains your customization that was merged with the changes in the latest version (206.132) of the base ER model mapping configuration.

    The system discovers some rebase conflicts. You must now manually resolve those conflicts.

    Screenshot of the rebase conflict message on the Configurations page.

  5. On the Action Pane, select Designer, and then, in the list of mappings, select Customer Invoice.

  6. For each rebase conflict, select Retain own value, because you must keep the version number of your custom data model for every component that the system mentions.

    Screenshot of the rebase conflicts on the Model mapping designer page.

  7. Select Save, and then close the Model mapping designer page.

  8. In the list of mappings, select Project Invoice.

  9. For each rebase conflict, select Retain own value, because you must keep the version number of your custom data model for every component that the system mentions.

  10. Select Save, and then close the Model mappings page.

    Note

    The rebase action is reversible. To cancel this rebase, select version 50.19.1 of the Invoice model mapping (Litware) model mapping on the Versions FastTab, and then select Get this version. The system renumbers version 206.132.2 back to 50.19.2, and the content of draft version 50.19.2 matches the content of version 50.19.1.

  11. On the Versions FastTab, select Change status > Complete, and then select OK.

The system changes the status of version 206.132.2 from Draft to Completed, and makes the version read-only. The system adds a new editable version, 206.132.3, and sets its status to Draft. You can use this version to make further changes in your custom ER model mapping configuration.

Screenshot of version 206.132.2 completed on the Configurations page.

Adopt your custom ER format

  1. Go to Organization administration > Electronic reporting > Configurations.

  2. On Configurations, in the configuration tree in the left pane, expand Invoice model > UBL Sales invoice > Peppol Sales Invoice, and select Peppol Sales Invoice (Litware).

  3. On the Versions FastTab, for draft version 11.2.2.2 of the selected format configuration, select Rebase.

  4. In the Target version field, confirm the selection of version 32.6.7 of the base ER format configuration, and then select OK.

    The system renumbers the draft version of your custom ER format configuration from 11.2.2.2 to 32.6.7.2 to indicate that it now contains your customization that was merged with the changes in the latest version (32.6.7) of the base ER format configuration.

    The system discovers some rebase conflicts. You must now manually resolve those conflicts.

  5. On the Action Pane, select Designer.

  6. For each rebase conflict, select Retain own value, because you must keep the version number of your custom data model for every component that the system mentions.

  7. Select Save.

  8. On the Mapping tab, select the Invoice data source of the Model type, and then select Edit.

  9. In the Version field, select version 2 of your custom data model, and then select OK.

  10. Select Save.

    Note

    The rebase action is reversible. To cancel this rebase, select version 11.2.2.1 of the Peppol Sales Invoice (Litware) format on the Versions FastTab, and then select Get this version. Version 32.6.7.2 is renumbered back to 11.2.2.2, and the content of draft version 11.2.2.2 matches the content of version 11.2.2.1.

  11. Close the Format designer page.

  12. On the Versions FastTab, select Change status > Complete, and then select OK.

The status of version 32.6.7.2 changes from Draft to Completed, and the version becomes read-only. A new editable version, 32.6.7.3, is added and has a status of Draft. You can use this version to make further changes in your custom ER format configuration.

Screenshot of version 32.6.7.2 completed on the Configurations page.

Process a customer invoice by using new versions of the custom ER configurations

Select and send a posted invoice

  1. Go to Accounts receivable > Invoices > All free text invoices.

  2. On Free text invoice, select the invoice that you previously added and posted.

  3. On the Action Pane, in the Document group, select Send > Original.

    Note

    Because you now have two versions of the Peppol Sales Invoice (Litware) ER format configuration, and neither version has an effective date value, the latest version is used to generate an e-invoice.

  4. Close Free text invoice.

Analyze a generated e-invoice

  1. Go to Organization administration > Electronic reporting > Electronic reporting jobs.

  2. On Electronic reporting jobs, select the most recent record that has the task description Send the eInvoice XML.

  3. Select Show files to access the list of generated files.

  4. Select Open to download the e-invoice XML file.

  5. Analyze the e-invoice XML file. Notice that, in accordance with your customization, the customer tax schema still contains the custom FederalTaxID XML attribute in addition to the schemeID and schemeAgencyID XML attributes. Additionally, because the changes in the new version of the base UBL Sales invoice format were merged with your customization, the text of the cbc:CustomizationID XML element changed from urn:www.cenbii.eu:transaction:biicoretrdm010:ver1.0:# urn:www.peppol.eu:bis:peppol5a:ver1.0 to urn:cen.eu:en16931:2017#compliant#urn:fdc:peppol.eu:2017:poacc:billing:3.0.

    Screenshot of the preview of the generated e-invoice XML file with customizations.

Additional resources