The views and opinions expressed in this blog are those solely of the author(s) and do not necessarily reflect Microsoft’s current policy, position, or branding. For official announcements and guidance on Dynamics 365 apps and services, please visit the Microsoft Dynamics 365 Blog.
Personalized Community is here!
Quickly customize your community to find the content you seek.
Check out the latest Business Central updates!Learn about the key capabilities and features of Dynamics 365 Business Central and experience some of the new features.
Download overview guide | Watch Business Central video
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
Creating Configuration Packages is a great way to import/export table data in Business Central. In this blog, we will go over some tips in creating these packages.
Building the Configuration Package:
In Configuration Packages, we give you the option to remove/add columns to the pages you are trying to integrate. It is recommended to make sure that the fields you include in the Configuration package are the fields that you would normally ‘manually’ enter when entering the transaction in the front end solution.
To access the fields you would click the Fields button on the Configuration Package page:
To Add/Remove a column from the integration you would check/uncheck the Include Field Check box:
You can also order the fields of a configuration package. The best practice would be to order the fields in the same order as you would manually entering the line. That way you ensure the proper checks are being made as some fields change based on another field.
To change the order of the columns you would use the Move up/Move Down buttons:
When manually entering a transaction, if there are fields that are automatically populated, before importing the transaction that field data will need to be in the system. For example, if you are importing Customers and you are including the Payment Terms, you need to make sure that the Payment Terms which you are including in the import exist in the system.
Adding Shortcut Dimensions (1&2) to a package:
There are a few ways to create Configuration Packages in Business Central. The first is through the Configuration Package page and the other is through Configuration Worksheet page. Through the Configuration Package page there is not an option to include Shortcut Dimensions in the integration. With the Configuration Worksheet there is an option check box called Dimensions as Columns. Below is the tooltip from that option field:
Specifies whether the configuration includes dimensions as columns. When you select the Dimensions as Columns check box, the dimensions are included in the Excel worksheet that you create for configuration. In order to select this check box, you must include the Default Dimension and Dimension Value tables in the configuration package.
Comparing integrated data vs manually entered data:
There are multiple ways to for data to flow into Business Central (Manual entry, Edit in Excel, Configuration Package/Worksheets). If the data you are importing is not looking correct on the page you can manually enter the line on the page and export the configuration package. You can then compare the manually entered line vs the integrated line to see what specific columns are populated that might be different than the imported file.
Integrating Historical data:
We dont allow importing into historical (Archive) tables. If you are importing Invoices and Payments/Cash Receipts those will need to be applied to be fully settled on the Customer/Vendor accounts.
Prepare a Configuration package
Importing Business Data from Other Finance Systems
The post Configuration Package tips from Business Central support. appeared first on Dynamics 365 Blog.
Business Applications communities