Questions and Answers

Question

Answer

Are outstanding purchase orders (orders where goods receipt has not yet been posted) synchronized to EASY Invoice?

Yes

Can cost objects at line level (cost centers, cost units) be passed to EASY Invoice and from EASY invoice to EASY Invoice Connector?

Yes

This requires customizing the Purchase order page, as well as Purchase invoice. In both, Short Dimension Code 1 and Short Dimension Code 2 must be mapped to cost centers or cost units.

In the workflow, you need to check and, if necessary, customize the mapping in the Transformation callbackscript of the Export DataTool.

Can the unit of measure in EASY Invoice workflow be changed, and will this be reflected after export to Dynamics 365 Business Central?

Yes

Can the business and product posting group to be used for a line in EASY Invoice workflow be changed, and will this be reflected after export to Dynamics 365 Business Central?

Yes

Can the sales tax/VAT business and sales tax/VAT product posting group to be used in EASY Invoice workflow be changed, and will this be reflected after export to Dynamics 365 Business Central?

Yes

Can the sales tax/VAT rate that applies to a line in EASY Invoice workflow be displayed and used for calculations ?

Not by default.

Yes, the percentage is available in the shadow database, but the Gentable definitions do not provide that field and there will be no automatic calculation building on it.

Can the currency code located in the invoice by transferred by EASY Invoice to EASY Invoice Connector?

Yes

Can users change the payment terms in EASY Invoice, and will the changed payment terms key be reflected in the purchase invoice in Dynamics 365 Business Central?

Not by default.

However, a description of how to integrate payment terms keys with the process has been documented.

How are number formats (prices, quantities, etc.) used?

Selection:

Export:

How are date formats (invoice date, scan date, etc.) used?

Import: The Microsoft Dynamics 365 Business Central Web services output data as ISO 8601 formatted date (YYYY-MM-DD). In this format, they are written in the shadow database InvoiceControlDb by the Import DataTools.

Selection:

Export: The EASY Invoice Connector Web service expects dates in ISO 8601 format.

Where are purchase return orders synchronized in EASY Invoice?

Return order header: orderheader table in InvoiceControlDb

Return order lines: orderitem table in InvoiceControlDb

In what ways do return order lines differ from order lines when both are located in the orderitem table after import?

The difference is via the content in the new custom column orderitemcustom2.

Where are goods receipts synchronized?

receipts Table in InvoiceControlDb

Where are goods returns (return orders) synchronized?

receipts Table in InvoiceControlDb

How do posted goods return lines differ from posted goods receipt lines when both are located in the receipts table after import?

The difference is via the content of the new custom column receiptscustom2.

In EASY Invoice, how do I assign the lines of a credit memo with order reference a purchase return order or purchase return order lines and posted goods return lines?

Use the

  • Order No. fields for return order number,

  • Line No. for the return order line number,

  • Goods receipt No. for the goods return number

  • as well as Goods receipt line for the goods return line number

as if you were capturing the information for an invoice with order reference. The goods return and goods return line number are relevant here.

How can I withdraw special vendors (e.g. locked vendors) from synchronization with the shadow database?

Use the capability of the OData query syntax to limit the data query of the Web services.