Dynamics 365 Business Central Data Targets

Overview

DataBlend Supports the following data targets for creating and modifying records in Dynamics 365 Business Central.

Journal Lines
Vendors
Purchase Invoices
Vendor Payments
Vendor Payment Journals
Dimension Set Lines
Journals
Purchase Invoice Lines

Configuration

Setting	Required/ Optional	Description
Type	Required	Dynamics 365 Business Central
Query	Required	Select the query that will generate the data for this target. See the relevant target type documentation for additional details on what query columns are required for your target.
Query Mode	Required	Choose New unless you have a reason for choosing Latest or Specific.
Credential	Required	Select a Dynamics 365 Business Central Credential from the list.
Target Type	Required	Choose the Dynamics 365 Business Central collector type from the drop-down menu.
Dynamics 365 Business Central Data Target Type	Required	Select from the pre-populated drop-down menu.

To learn more about Dynamics 365 Business Central API requirements, please visit API (V2.0) for Dynamics 365 Business Central - Business Central.

Troubleshooting

Some Dynamics 365 Business Central Data Targets are more complex than others. Here are some commonly asked questions to help better troubleshoot any errors that arise.

What Columns Are Included in the Query?

Users can easily utilize our public query templates. Users may also wish to find information for their Vendors, Journal Line, or Update Journal Line Data Targets from their corresponding Collectors.

Another User Has Already Changed the Record

Another user has already changed the record. CorrelationId: xxxx-xxxx-xxxx-xxxx. In order to avoid this, a new collection from that object must be run to get the latest ___odata_etag__ value. This an additional unique identifier needed to update the record, and will change each time the record gets updated. To find the ___odata_etag__ value, collect from the Vendors Collector. The stream collected will provide the necessary information.

Advanced

History Retention

History Retention (Days) allows users to decide how long they want the information from their data targets to be stored. This field is optional.

Timeout (seconds)

The Timeout section allows users to determine if they would like to timeout collections taking longer than a set number of seconds to collect data.

Skip If No Records Found

The “Skip if No Records Found” button is used to eliminate sending information to Data Targets unnecessarily. Simply enable the “Skip if No Records Found” toggle. The use of this toggle is optional.

Agent

The Agent drop-down for users to select any agent they have established. This is optional.

Run As

Run As allows users to select from a drop-down list of users to run the Workflow. This is optional. Please note that Run As is only available to Admin users. If a user is set as the Run As and then demoted to a Member, the user which demoted the Run As user will instead be set as the Run As.