Skip to content
  • There are no suggestions because the search field is empty.

HOMEBUILDER:  DATA MIGRATION

See the links below for general instructions on sales retainage data migration in Business Central:

There are two primary methods for performing data migration in basic Microsoft Dynamics 365 Business Central. See the links below for general instructions on data migration:

  1. Configuration Packages

  2. Edit in Excel

 

Open Sales Retainage (AR) Data Migration

Make sure you have set up Sales Retainage Setup and Processing before migrating Open Sales Retainage.

Tip

Owing to the complexity of the relationship between the Retainage Ledger and Sub-ledger, most companies do not import open Retainage. If you would still like to do this view this page Sales Retainage Import

Create Your Journal to Enter or Import the Open Receivables:

In General Journals, create a dedicated Batch for migrating Open AR and Open Retainage. As an Account Type, choose Customer to post to the Customer Subledger. In the example below:

    Open_Sales_Retainage_(AR)_data_migration1

  In this example:

  • $9,000 is the Regular AR from that Customer (GL account 12000 is the AR control Account)
  • $1,000 is the full AR – Retainage/ Holdbacks amount. (We post this to the same GL account for migration, as we are posting straight to the receivables account and not to the retainage account.)
  • For migration purposes, it is best to combine the Net Amount and the Tax Amount. (This is the Receivable value owing.)
Tip

Using a clear description, like “Retainage-Invoice xyz,” will help you identify which line belongs to which original invoice.

 

View the Results of the Posting:

We are migrating Open AR and Open Retainage Entries. The GL impact is already reflected in GL balances. This means that the current migration is NOT going to affect GL balances. (There will be a NET zero effect.)

    Open_Sales_Retainage_(AR)_data_migration2