Overview of the BC endpoints for master data imports and transactional data exports

In edoc invoice, you can configure an import for master data from Microsoft Dynamics 365 Business Central (BC) or a transactional data export to Dynamics 365 Business Central. You must establish a REST API connection in edoc invoice. To import the individual Business Central fields into edoc invoice, map the Business Central fields to the edoc invoice fields.

If you map the fields, you can use certain default tables and default pages in Business Central.

This article provides you with an overview of the mapping of the respective fields per Business Central table to the edoc invoice fields.

Some edoc invoice fields are not used by default in the Business Central context:

• Cost center managers

• Cost center managers | Invoice without order reference

• Cost center managers | Invoice for goods

• Value set - posting key

• Value set - invoice type

Some fields in Business Central are not mapped to any edoc invoice fields by default and vice versa. In the tables, the fields are marked accordingly with a one-way street symbol.

BC endpoints for default fields in edoc invoice

If you want to transfer certain fields of the master data in Business Central, certain fields are available in edoc invoice by default, which you must map.

BC endpoint "edocVendors" for edoc invoice destination object "Vendors"

• BC table 23: Vendor

• BC page 72290946: edoc Vendor List

BC endpoint "edocVendorOrderAddresses" for edoc invoice destination object "Vendor addresses"

• BC table 224: Order Address

• BC page 72290947: edoc Order Address List

BC endpoint "edocVendors" for edoc invoice destination object "Vendor addresses"

• BC table 23: Vendor

• BC page 72290946: edoc Vendor List

BC endpoint "edocVendorBankAccounts" for edoc invoice destination object "Vendor bank data"

• BC table 288: Vendor Bank Account

• BC page 72290948: edoc Vendor Bank Account List

BC endpoint "edocPaymentTerms" for edoc invoice destination object "Payment terms"

• BC table 3: Payment Terms

• BC page 72290949: Edoc Payment Terms

BC endpoint "edocVATProductPostingGroups" for edoc invoice destination object "Sales tax code"

• BC table 324: VAT Product Posting Group

• BC page 72290950: edoc VAT Prod. posting groups

BC endpoint "edocPurchaseOrders" for edoc invoice destination object "Purchase order numbers"

• BC table 38: Purchase Header

• BC page 72290951: edoc Purchase Order List

The Document Type field in Dynamics 365 Business Central contains two different values that you need to know if you want to post both purchase orders and return orders in Business Central:

• Order (purchase order)

• Return order

BC endpoint "edocPurchaseOrderLines" for edoc invoice destination object "Purchase order lines"

• BC table 39: Purchase Line

• BC page 72290952: edoc Purchase Order Lines

The Document Type field in Dynamics 365 Business Central contains two different values that you need to know if you want to post both purchase orders and return orders in Business Central:

• Order (purchase order)

• Return order

BC endpoint "edocPurchaseReceiptLines" for edoc invoice destination object "Packing slips"

• BC table 121: Purch. Rcpt. Line

• BC page 72290953: edoc Purchase Receipt Lines (deprecated since edoc D365 BC invoice cockpit version 4.5.0). Use this BC page instead.

BC endpoint "edocGLAccounts" for edoc invoice destination object "Value set - G/L account"

• BC table 15: G/L Account

• BC page 72290954: edoc G/L Account List

BC endpoint "edocDimensionValues" for edoc invoice destination object "Value set - Dimension"

• BC table 349: Dimension Value

• BC page 72290955: edoc Dimension Value List

BC endpoint "edocCurrencies" for edoc invoice destination object "Value sets - Currencies"

• BC table 4: Currency

• BC page 72290956: edoc Currencies

BC endpoints for custom fields in edoc invoice (best practice)

If you want to transfer certain fields of the master data in Business Central that are not available in edoc invoice by default, you can first create the fields in edoc invoice and then map them accordingly.

BC endpoint "edocVATProductPostingGroups" for edoc invoice destination object "Value set - VAT Prod. Posting Group"

• BC table 324: VAT Product Posting Group

• BC page 72290950: edoc VAT Prod. posting groups

BC endpoint "edocVATBusinessPostingGroups" for edoc invoice destination object "Value set - VAT Bus. Posting Group"

• BC table 323: VAT Business Posting Group

• BC page 72290957: edoc VAT Bus. Posting Groups

BC endpoint "edocGeneralProductPostingGroups" for edoc invoice destination object "Value set - Gen. Prod. Posting Group"

• BC table 251: Gen. Product Posting Group

• BC page 72290958: edoc Gen. Prod. posting groups

BC endpoint "edocGeneralBusinessPostingGroups" for edoc invoice destination object "Value set - Gen. Bus. Posting Group"

• BC table 250: Gen. Business Posting Group

• BC page 72290959: edoc Gen. Bus. Posting Groups

BC endpoint "edocItems" for edoc invoice destination object "Value set - Items"

• BC table 27: Item

• BC page 72290960: edoc Item List

BC endpoint "edocFixedAssets" for edoc invoice destination object "Value set - Fixed asset"

• BC table 5600: Fixed Asset

• BC page 72290961: edoc Fixed Asset List

BC endpoint "edocResources" for edoc invoice destination object "Value set - Resource"

• BC table 156: Resource

• BC page 72290962: edoc Resource List

BC endpoint "edocItemCharges" for edoc invoice destination object "Value set - Charge (Item)"

• BC table 5800: Item Charge

• BC page 72290963: edoc Item Charges

BC endpoint "edocAllocationAccounts"

• BC table 2670: Allocation Account

• BC page 72290964: edoc Allocation Account List

The Business Central fields are not yet assigned to any field in edoc invoice.

BC endpoint "edocItemChargeDistributions" for edoc invoice destination object "Value set - Item charge allocation type"

• BC table 32: Item Ledger Entry

• BC page 72290965: edoc Item Charge Distribution

The BC table Item Ledger Entry is only used temporarily for item charges.

BC endpoint "edocPurchaseReceiptLines" for edoc invoice destination object "Packing slips"

• BC table 39: Purchase Line (Temporary)

• BC page 72290967: edoc Purch. Receipt Lines (new BC page as of edoc D365 BC invoice cockpit version 4.5.0)

If you configure in edoc invoice for edoc D365 BC invoice cockpit with regard to purchase receipts and purchase return orders, you must note the following for the fields:

• The Document Type field always has the same value Order and can be ignored.

• Quantity Not Invoiced field contains item quantity that has not yet been invoiced.

• The Posted Document Type field can only contain two values.

  • Purchase Receipt is the posted purchase receipt.

  • Return Shipment is the posted purchase return shipment.

• The Document No. field is dependent on the Posted Document Type field.

  • Posted Document Type = Purchase Receipt is the posted purchase receipt number.

  • Posted Document Type = Return Shipment is the posted purchase return order number.

• The Line No. field is dependent on the Posted Document Type field.

  • Posted Document Type = Purchase Receipt is the order line number.

  • Posted Document Type = Return Shipment is the return order line number.

• The Order No. field is dependent on the Posted Document Type field.

  • Posted Document Type = Purchase Receipt is the purchase order number.

  • Posted Document Type = Return Shipment is the return order number.