Data handling in Dynamics 365 Business Central

The way in which Dynamics 365 Business Central handles certain data types affects the data that is pulled from the accounting platform into Codat. This article highlights things to look out for when you view datasets.

Null values in invoices, bills, credit notes, and bill credit notes

In Dynamics 365 Business Central, certain data types may display 'null' field values.

Invoices and credit notes without linked customers show the following values:

  • CustomerName is Customer not specified
  • Id is NullId

Bills and bill credit notes without linked suppliers show the following values:

  • SupplierName of Supplier not specified
  • Id of NullId

Line items of invoices, bills, credit notes, and bill credit notes without linked accounts show the following values:

  • Name of Account not specified.
  • Id of NullId

Bill credit notes and currencies

When the currency of a bill credit note is not set by the supplier, Codat uses the local, or base currency of the company. In Dynamics 365 Business Central, this is the LCY code on the General Ledger Setup page.


Did this page help you?