Processing Documents in Migration Mode

Before you start the migration process in MYOB Advanced, you need to prepare the list of all accounts receivable and accounts payable documents that you want to migrate to the system. This list can contain all both outstanding and closed documents. For each document, you need to specify its original amount, document date, currency, exchange rate, and balance open on the migration date.

Note: The documents that are added when migration mode is activated do not update the general ledger. If you need to update account balances, you can import either the trial balance (for details, see Importing Financial Data) or the general ledger transactions.

Types of Accounts Receivable and Accounts Payable Documents That Can Be Migrated

The following types of accounts receivable documents can be entered in migration mode:

  • Invoice, Debit Memo, and Credit Memo: You add these documents by using the Invoices and Memos (AR301000) form.
  • Payment, Prepayment, and Refund: You add these documents by using the Payments and Applications (AR302000) form.
  • Cash Sale and Cash Return: You add these documents by using the Cash Sales (AR304000) form.

The following types of accounts payable documents can be entered in migration mode:

  • Bill, Debit Adjustment, and Credit Adjustment: You add these types of documents by using the Bills and Adjustments (AP301000) form.
  • Payment, Prepayment, and Refund: You add these types of documents by using the Checks and Payments (AP302000)
  • Cash Purchase: You add this type of a document by using the Cash Purchases (AP304000) form.

In migration mode, you add the needed documents with the On Hold or Balanced status. These documents can be edited and released only when migration mode is activated.

Entry of a Document's Open Balance

When you are adding an accounts receivable or accounts payable document, you specify the open balance of a migrated document on the document entry form as follows:

If you need to migrate historical documents that have been already settled in full, enter zero as the open balance of these migrated documents.

When you save a document, the system validates that the open balance does not exceed the document's original amount; if it does, the system displays an error.

An open balance that you specify in a document in migration mode will be displayed in the Migrated Balance box on the Financial tab on the document entry form once you save a document. This box is available for migrated documents only.

Note: In documents entered in migration mode, the system calculates taxes based on the tax zone and tax category specified in the documents.

Entry of Migrated Documents with Unreleased Retainage

In addition to using import scenarios, on the Invoices and Memos (AR301000) and Bills and Adjustments (AP301000) forms, you can enter migrated AR documents and AP documents, respectively, with unreleased retainage.

You enter a document with unreleased retainage on the Invoices and Memos or Bills and Adjustments form by performing the following steps:

  1. You create the document.
  2. You specify its settings in the Summary area, including the selection of the Apply Retainage check box.
  3. You add a document line on the Details tab and specify the retainage percent in the Retainage Percent column.

    On the Retainage tab, the system displays the calculated retainage amount in the Unreleased Retainage and Unpaid Retainage boxes.

For details on creating a document with retainage, see Processing AP Documents with Retainage and Processing AR Documents with Retainage.

Release of Migrated Documents

The release of migrated accounts receivable documents causes customer balances to be updated; similarly, the accounts payable documents update vendor balances. These released documents do not produce batches in the general ledger. Thus, on the Financial tab of the corresponding document entry forms, instead of the link to the general ledger batch, the word Migrated will be displayed for a migrated document in the Batch Nbr. box.

On release of a historical accounts receivable or accounts payable document with an open balance of zero, the system adds a line with this document to the Applications tab on the document entry form and assigns the Closed status to the document. On the Financial tab, the Migrated Balance box shows 0.00, which means that the document was closed before migration.

Note: Migrated documents cannot be edited or released when migration mode is deactivated, and documents created in MYOB Advanced cannot be edited or released when migration mode is activated.

Migration of Project Balances

If migration mode is turned on for projects, you can import pro forma invoices and the corresponding project transactions—along with their balances, original amounts, and dates—without affecting the general ledger. Also, you must link these pro forma invoices and project transactions to the AR documents that correspond to them.

Important: In order to correctly update project balances without affecting the general ledger, in the lines of the project transactions being imported, you must specify only debit account and debit subaccount, and leave credit account and credit subaccount empty. As a result, release of these project transaction will not produce general ledger transactions.

After the migrated pro forma invoices and project transactions are released, on the Invoices tab of the Projects (PM301000) form, the system will show a line for each pro forma invoice that corresponds to the project, along with the corresponding AR document (if one was specified), which is shown in the same row. Also, on the Revenue Budget tab of this form, project budget values will be calculated based on the imported data.

Note: To indicate that a pro forma invoice has been migrated, the system selects the Migrated check box on the Financial tab of the Pro Forma Invoices (PM307000) form.

Known Limitations

When accounts payable bills are entered in migration mode on the Bills and Adjustments (AP301000) form, the links to related subcontracts and purchase orders cannot be specified in the Subcontract Nbr. and PO Number columns, respectively, on the Details tab because there is no migration mode for subcontracts and purchase orders. This information also cannot be imported when the accounts payable bills are imported in migration mode by using import scenarios.