Gentable definitions

Invoice with order reference and goods receipts or credit memo with return order reference and shipments of goods (epiFiles_bc_with_po_Def.xml)

Field	Name	UserExit	UserExit ändert field
ItemDifference
ItemType	Type
ItemNumber	Number (depending on type)
btnTypeAndNumber		Purchase invoice - Line items - Type and number table	ItemType ItemNumber ItemGenBusPostingGroup ItemGenProdPostingGroup ItemVatBusPostingGroup ItemVatProdPostingGroup
ItemGenBusPostingGroup	Business posting group
ItemGenProdPostingGroup	Product posting group
btnGeneralPostingSetup		Purchase invoice - Line items - Posting matrix table	ItemGenBusPostingGroup ItemGenProdPostingGroup
ItemVatBusPostingGroup	Sales tax/VAT business posting group
ItemVatProdPostingGroup	Sales tax/VAT product posting group
btnVatPostingSetup		Purchase invoice - Line items - Sales tax/VAT posting matrix	ItemVatProdPostingGroup ItemVatBusPostingGroup
ItemOrderNumber	Order number/return order number
btnFindOrderNumber		Purchase invoice - Line items - Order number table	ItemOrderNumber ItemOrderItemNumber ItemText ItemQuantity ItemPriceUnit ItemSingleAmount ItemUnitOfMeasure ItemAccount ItemCostCenter ItemCostUnit ItemReceiptNumber ItemTotalAmount ItemOrderPrice
ItemOrderItemNumber	Order lines number/return order lines number
btnFindPurchaseOrderItem		Purchase invoice - Line items - Order line item number table	ItemOrderItemNumber ItemText ItemOrderPrice ItemQuantity ItemPriceUnit ItemUnitOfMeasure ItemAccount ItemCostCenter ItemCostUnit ItemReceiptNumber ItemNumber ItemType
ItemReceiptNumber	Good receipt number/Goods return number
ItemReceiptItemNumber	Good receipt line number/Goods return line number
btnReceiptItemNumber		Purchase invoice - Line items - Good receipts table	ItemType ItemQuantity ItemReceiptNumber ItemReceiptItemNumber
ItemText
ItemQuantity	Quantity
ItemUnitOfMeasure	Unit of measure	Microsoft Business Central Connector - UserExit - Line Items - Hit Unit Of Measure	ItemUnitOfMeasure
btnUnitOfMeasure		Purchase invoice - Line items - Unit of measure table	ItemUnitOfMeasure
ItemSingleAmount	Unit price
ItemOrderPrice	Order price
ItemDiscountRate	Discount (%)
ItemDiscountAmount	Discount
ItemPriceUnit	Price unit
ItemTotalAmount	Net total amount
ItemCostCenter	Cost center
btnFindCostCenter		Purchase invoice - Line items - Cost center table	ItemCostCenter
ItemCostUnit	Cost unit
btnFindCostUnit		Purchase invoice - Line items - Cost unit table	ItemCostUnit
ItemComment

Invoices without order reference or credit memos without return reference (epiFiles_bc_without_po_Def.xml)

Field	Name	UserExit	UserExit changes field
ItemDifference
ItemType	Type
ItemNumber	Number (depending on the type)
btnTypeAndNumber		Purchase invoice - Line items - Type and number table	ItemType ItemNumber ItemGenBusPostingGroup ItemGenProdPostingGroup ItemVatBusPostingGroup ItemVatProdPostingGroup
ItemGenBusPostingGroup	Business posting group
ItemGenProdPostingGroup	Product posting group
btnGeneralPostingSetup		Purchase invoice - Line items - Posting matrix table	ItemGenBusPostingGroup ItemGenProdPostingGroup
ItemVatBusPostingGroup	Sales tax/VAT Business posting group
ItemVatProdPostingGroup	Sales tax/VAT Product posting group
btnVatPostingSetup		Purchase invoice - Line items - Sales tax/VAT posting matrix table	ItemVatProdPostingGroup ItemVatBusPostingGroup
ItemText
ItemQuantity	Quantity
ItemUnitOfMeasure	Unit of measure	Microsoft Business Central Connector - UserExit - Line Items - Hit Unit Of Measure	ItemUnitOfMeasure
btnUnitOfMeasure		Purchase invoice - Line items - Unit of measure table	ItemUnitOfMeasure
ItemSingleAmount	Unit price
ItemDiscountRate	Discount (%)
ItemDiscountAmount	Discount
ItemPriceUnit	Price unit
ItemTotalAmount	Net total amount
ItemCostCenter	Cost center
btnFindCostCenter		Purchase invoice - Line items - Cost center table	ItemCostCenter
ItemCostUnit	Cost unit
btnFindCostUnit		Purchase invoice - Line items - Cost unit table	ItemCostUnit
ItemComment	Comment

Shadow database "InvoiceControlDb"

The following tables are used:

table	Content(s)	Remark
vendor	Vendors
transactionitem	G/L accounts, items, resources, assets	New features in EASY Invoice
costunit	Cost unit
costcenter	Cost centers
vatpostingsetup	Sales tax/VAT Posting matrix	New features in EASY Invoice
generalpostingsetup	Posting matrix	New features in EASY Invoice
unitofmeasure	Units of measure	New features in EASY Invoice
orderheader	Purchase orders, purchase return orders	To enter the correct values for purchase invoices and purchase credit memos in the file and Gentable fields and provide them for extraction or validation, the data of the corresponding objects (Purchase invoice -> Purchase order; Purchase credit memo -> Purchase return order) must be provided in this table. Purchase orders are identified via the value purchaseorder in the orderheadercustom1 field. Purchase return orders are identified via the value purchasereturnorder in the oderheadercustom1 field.
orderitem	Purchase order line items, purchase return order line items	To enter the correct values for purchase invoices and purchase credit memos in the Gentable fields and provide them for extraction or validation, the data of the corresponding objects (Purchase invoice -> Purchase order; Purchase credit memo -> Purchase return order) must be provided in this table. Purchase orders are identified via the value purchaseorder in the orderheadercustom1 field. Purchase return orders are identified via the value purchasereturnorder in the oderheadercustom1 field.
receipts	Goods receipt line items, goods return line items	To enter the correct values for purchase invoices and purchase credit memos in the Gentable fields and provide them for extraction or validation, the data of the corresponding objects (Purchase invoice -> Posted goods receipt line items; Purchase credit memo -> Posted goods return line items) must be provided in this table. Posted goods receipt line items are identified via the value receipt in the receiptscustom2 column. Posted goods return line items are identified via the value returnshipment in the receiptscustom2 column.

DataTools

EASY ECM2Design DataTools version 1.3.1 are required.

DataTools for maintaining other DataTools

To easily make the same changes to multiple DataTools with similar structure, two DataTools are provided.

"Microsoft Business Central Connector - Customize DataTools - Imports", finds all Import DataTools and customizes them

"Microsoft Business Central Connector - Customize DataTools - UserExits", customizes all UserExit DataTools

Application of these DataTools is described here: Installation.

Export DataTool

By default, a DataTool is shipped that deals with exporting an EASY Invoice invoice file to EASY Invoice Connector.

"Microsoft Business Central Connector - Export"

The Export DataTool requires the transformation Callbackscript cb.ehrmDataTools.transform.invoice2businesscentral as well as the Response-Handler script cb.ehrmDataTools.handler.invoice2businesscentral.

You can customize and extend export mapping in cb.ehrmDataTools.transform.invoice2businesscentral; however, you have to save it because it is custom and might be overwritten during an update.

Import DataTools

To provide master and transaction data from Dynamics 365 Business Central for EASY Invoice, various Import DataTools are shipped. They query the data and save it in the shadow database InvoiceControlDb.

Manual execution of the Import DataTools is not possible without customization. For a test, you should copy the corresponding Import DataTool, customize it, and then test it.

These tools are configured such that they are executed either once every day or every hour using two job scripts; this happens to all existing EASY Invoice accounting entities.

Name	What	Frequency of execution	Target table in InvoiceControlDb
Microsoft Business Central Connector - Import Cost Center	Cost centers	daily	costcenter
Microsoft Business Central Connector - Import Cost Unit	Cost unit	daily	costunit
Microsoft Business Central Connector - Import Fixed Asset	Assets	daily	transactionitem
Microsoft Business Central Connector - Import GL Account	GL accounts	daily	transactionitem
Microsoft Business Central Connector - Import Item	Item	daily	transactionitem
Microsoft Business Central Connector - Import Resource	Resources (humans)	daily	transactionitem
Microsoft Business Central Connector - Import Unit Of Measure	Units of measure	daily	unitofmeasure
Microsoft Business Central Connector - Import VAT Posting Setup	Sales tax/VAT Posting matrix	daily	vatpostingsetup
Microsoft Business Central Connector - Import General Posting Setup	Posting matrix	daily	generalpostingsetup
Microsoft Business Central Connector - Import Vendor	Vendors	daily	vendor
Microsoft Business Central Connector - Import Vendor Bank	Bank details of the vendors	daily	vendor
Microsoft Business Central Connector - Import Purchase Order Header	Purchase orders	hourly	orderheader
Microsoft Business Central Connector - Import Purchase Order Item	Purchase order lines	hourly	orderitem
Microsoft Business Central Connector - Import Receipt	Posted goods receipt lines	hourly	receipt
Microsoft Business Central Connector - Import Purchase Return Order Header	Sales Return Orders	hourly	orderheader
Microsoft Business Central Connector - Import Purchase Return Order Item	Return order lines	hourly	orderitem
Microsoft Business Central Connector - Import Return Shipment Line	Posted goods return lines	hourly	receipt

UserExit-DataTools

To simplify changing data in purchase invoice lines for users, multiple UserExit DataTools have been provided.

Name	What
Microsoft Business Central Connector - UserExit - Line Items - Hit Purchase Order Item	Autocomplete in Purchase order line number
Microsoft Business Central Connector - UserExit - Line Items - Hit Unit Of Measure	Autocomplete in unit of measure
Purchase invoice - Line items - Purchase order line number	Table UserExit for purchase order line number
Purchase invoice - Line items - Goods receipt table	Table UserExit for goods receipts
Purchase invoice - Line items - Type and Number table	Table UserExit for Type and Number
Purchase invoice - Line items - Sales tax/VAT posting matrix table	Table UserExit for sales tax/VAT Posting matrix (sales tax/VAT business posting group, sales tax/VAT product posting group)
Purchase invoice - Line items - Unit of measure table	Table UserExit for units of measure
Purchase invoice - Line items - Posting matrix table	Table UserExit for posting matrix (business posting group, product posting group)

Components

Gentable definitions

Invoice with order reference and goods receipts or credit memo with return order reference and shipments of goods (epiFiles_bc_with_po_Def.xml)

Invoices without order reference or credit memos without return reference (epiFiles_bc_without_po_Def.xml)

Shadow database "InvoiceControlDb"

DataTools

DataTools for maintaining other DataTools

Export DataTool

Import DataTools

UserExit-DataTools

Search results