This week we're talking craft beer, Business Central May 2019 updates, Business Central data migration options, the new Business Central feature allowing you to merge customers and vendors, and commission apps.
Show Notes
Segment 1 - Craft Beer
New Belgium Brewing
Fat Tire Beer
Pilsner
Segment 2 - What's New in Business Central for May 2019
Dynamics 365 Business Central Team Members
Based on partner feedback, the Dynamics NAV to Dynamics 365 Business Central on-premises Full user ratio of 1:2 is increasing to 1:3. This change will come into effect on May 15, 2019.
Each Dynamics NAV Full user licensed before May 1, 2019, will receive three Dynamics 365 Business Central on-premises Essentials or three Dynamics 365 Business Central on-premises Premium users.
Each Dynamics NAV Limited Concurrent User Client Access License (CAL) licensed before May 1, 2019 will receive three Dynamics 365 Business Central on-premises Team Members users.
Dynamics 365 Business Central External Accountant and System Administrator User
Business Central on-premises customer licenses have been updated to include, at no charge, one CAL for an External Accounting User and one CAL for a System Administrator User.
Segment 3 - Special Segment: Business Central Data Migration Options
RapidStart Data Configuration Packages (user-based tools to Import/export data)
Pros:
• User-based, no development or Extensions required
• Very easy to tailor to any file format using Excel and user interface from within the Business Central environment.
• Auto-applies all standard BC record and system validations (date formats, code field validations, etc.)
Cons:
• Import of large data sets may take longer than ideal
• No business logic can be included to determine how to handle data (multiple tables, if/then/else statements during the import)
Sample use cases:
• Customers
• Ship-to Addresses
• Vendors
• Items (?)
• On-hand inventory
• Outstanding Receivables
• Outstanding Payables
• Monthly G/L history (summarized net change entry per month)
XML Ports (available as a custom Extension to be developed and deployed within a Business Central environment)
Pros:
• Useful for very large data sets due to efficiency of processing XML Ports
• Useful for when business logic is needed when data is imported into BC
• Useful for when a repeatable process is required for multiple import runs (test runs or importing data multiple time for whatever reason)
Cons:
• Requires a developer to:
o Build an Extension, so time/investment required
o Edit the format or business logic
Sample use cases:
• Detailed historical G/L Entry records
• Posted Sales Invoice history (insert into both header and line type records using a complex import file format)
Segment 4 - Business Central Feature Spotlight: Merge Customers and Merge Vendors
• Feature: Merge Customers/Vendors
• Version: Added with the Spring 2019 Release of Business Central
• Overview: This new feature allows the user to merge two existing Customer records together or merge two existing Vendor records together. This can be useful when two existing customers or vendors merge with one another, or when a user sets up a new record for an existing customer or vendor because they didn’t know they already exist in the system, and then creates and/or posts transactions against this new customer. Prior to this feature, there was no way to merge existing records, particularly due to all of the related data that would also have to be moved including posted invoices, credit memos, ledger entries, comments, prices, cross-references, ledger entries.
• Functionality:
o Navigate to the customer you would like to continue to maintain in Business Central
o Select More Options Actions Functions Merge With…
o Populate the “Merge With…” field
o Review the fields to be applied and confirm if any fields on the current customer should be overridden by the field contents from the customer that is to be merged.
o Re