BeyondERP.Newsletter
Menu

Setup step on the Electronic document property types page · Accounts receivable

Set up Electronic document property types

Defines named property types and the tables they apply to so that additional values can be captured on legal entities, customers, vendors or invoices and written into electronic invoice XML.

Used by
Accounts receivable clerk, Accounts receivable manager, Auditor and 12 more roles
Business process
Issue sales invoices
Menu item
EInvoicePropertyTypeTable
Main table
EInvoicePropertyTypeTable
Data entity
EInvoicePropertyTypeTableEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you define electronic document property types and the tables (such as Customers and Legal entities) that each type applies to.
What you do hereUse it to create properties whose values are entered per customer or legal entity and then output to blocks of the electronic invoice XML for different business cases.
ExampleFor Italian electronic invoices, a property type can hold the certified email address (PEC) of a private company or professional, or stamp duty details, so they are written to the XML file.
Electronic document property types 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
Menu pathAccounts receivable › Setup › Electronic document property types
Used next byAll customers Microsoft Learn
In this processSet up Electronic signature certificates
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.

Step by step, with screenshots

Set up Electronic document property types1 screen

Defines named property types and the tables they apply to so that additional values can be captured on legal entities, customers, vendors or invoices and written into electronic invoice XML.

  1. Screen 1

    Create the electronic document property type

    Go to Accounts receivable > Setup > Electronic document property types

    1. Select New
    2. Enter the sorting number, type and descriptions
    3. Leave Applicable to blank
    1TypeBEAT-DEMO
    Sorting0
    Group descriptionElectronic document properties
    DescriptionProperty
    Create the electronic document property type (zoomed on the outlined fields)
    Show the full screenCreate the electronic document property type
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Accounts receivable > Setup > Electronic document property types and select New.
  2. In the Type field, enter the property type code exactly as your e-invoicing setup needs it, for example FormatType.
  3. Select Applicability to add the table the property applies to.
  4. On the Electronic document property type applicability setup page, in the Table name field, select the table, such as Customers.
  5. Save, and return to the Electronic document property types page.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
TypeThe code of the property type; it must match the value your e-invoice format expects.Microsoft Learn Type
Table nameThe table the property type applies to, such as Customers or Legal entities.Microsoft Learn
DescriptionFilled in automatically from the Group description and Description fields.Microsoft Learn PropertyDescriptionLabel
Sorting0Sorting
Group descriptionElectronic document propertiesGroupDescriptionLabel

Test checklist

  1. Create the PEC property type with the Customers table.
  2. On a private-company customer with a blank Authority office, open Electronic document properties and enter the certified email address.
  3. Post a free text invoice for the customer and create the XML on the Electronic customer invoices page.
  4. Check that PECDestinatario holds the address and CodiceDestinatario is 0000000.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Electronic document property typesCreate the property types with the exact codes the Italian FatturaPA setup uses (for example VATnonEU and PEC on Customers, Bollo and BolloPay on Legal entities, DocumentType on the invoice journals) and set the table each one applies to.Each property type feeds a specific block of the XML file, and the electronic document property type must have the same code that Learn specifies for that business case.Setting up the type but not entering its value on the customer or legal entity (Electronic document properties on the Action Pane). The XML block that needs it, such as PECDestinatario for private companies with a blank Authority office, is then empty.
Solution architect

5Design impact

Shared or per companyShared: the same records are used by every legal entity. Microsoft data model
Can it be undoneReversible: Types and values can be changed; they're read when the electronic invoice XML is generated, so files already created keep the old values.
If you change it laterIn Belgium, schema codes set through electronic document property types take priority over the built-in default schema code. Microsoft Learn
Technical architect

6Technical

Menu itemEInvoicePropertyTypeTable Checked in Dynamics 365
FormEInvoicePropertyTypeTable Checked in Dynamics 365
TableEInvoicePropertyTypeTableKey field: RecIdChecked in Dynamics 365
Data entitiesEInvoicePropertyTypeTableEntityElectronic document property types Microsoft data model
Who can open itPrivilegesMaintain accounts receivable parameters CustParametersMaintainView accounts receivable parameters CustParametersViewDutiesEnable collections process CollectionLetterCollectionsProcessEnableEnable credit cards CreditCardCreditCardEnableEnable credit cards process CreditCardCreditCardsProcessEnableMaintain collections process automation setup CustAutomationSetupMaintainInquire into invoice and cash policies CustInvoiceInvoiceAndCashPoliciesInquirEnable invoice and cash process CustInvoiceInvoiceAndCashProcessEnableEnable shipping process InventShippingProcessEnableInquire into invoice and cash policies RentalCustInvInvoiceAndCashPolInquirEnable invoice and cash process RentalCustInvoiceInvAndCashProcEnableInquire into quotation to sales order policies RentalSalesQuotationToSlsOrdPoliciesInquireEnable quotation to sales order process RentalSalesQuotationToSlsOrdProcessEnableInquire into quotation to sales order policies SalesQuotationToSalesOrderPolInquireEnable quotation to sales order process SalesQuotationToSalesOrderProcessEnable
15 security rolesAuditor AuditPolicyManagerCollections manager CollectionLetterCollectionsManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkRental coordinator agent RentalCoordinatorAgentRental manager RentalManagerRental representative RentalRepresentativeRental sales manager RentalSalesManagerRetail service RetailServiceSales manager TradeSalesManagerWarehouse manager WMSWarehouseManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRental manager RentalManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerRental coordinator agent RentalCoordinatorAgentCollections manager CollectionLetterCollectionsManagerAccounting supervisor LedgerAccountingSupervisorTo use itAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAuditor AuditPolicyManagerRental representative RentalRepresentativeGive people one of these roles. On this system, 15 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=EInvoicePropertyTypeTable
Integrate withEInvoicePropertyTypeTableEntity data entity Microsoft data model
Data migrationEInvoicePropertyTypeTableEntity (Electronic document property types): shared by all companies.Microsoft Learn
Table definitionEInvoicePropertyTypeTable columns and relations Microsoft data model
Everyone

8Sources