Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML Wrap
classcol span_3_of_5

If you have existing data, you can migrate a MAS, Accounts or AO Classic General Ledger to MYOB Ledger.

The data migrated to the MYOB Ledger includes:

  • ledger details (such as entity type, reporting period)
  • chart of accounts
  • closing balances of the financial year.

You can migrate either:

  • the full prior year balances
  • the partial current-year balances, including transactions for any future periods. This migrates transactions that are equal to or greater than the financial year start date as a Journal type.

Use the Select to migrate current year transactions checkbox to choose your preference when migrating data.

Image Removed

Comparative figures are migrated into MYOB Ledger, so you can use the figures for review processing and produce financial statements with up to 5 years of data.

Before you begin

You may want to check the following:

  • the ledger you are migrating is balanced
  • asset journals have been posted from AE Assets or AO Classic Fixed Assets to your legacy ledger
  • the current ledger year has been completed.
UI Text Box
typenote
You don't need to roll forward your MAS, Accounts or AO Classic General Ledger to migrate. The migration process does not make any changes to the MAS, Accounts or AO Classic General Ledger.

There are three tasks you need to perform to migrate your ledger:

UI Expand
title1. Configure the ledger

Before migrating, you need to configure the ledger a MAS, Accounts or AO Classic General Ledger.

  1. Open a client and go to the Client Accounting > Trial Balance (Workpapers) tab.
  2. On the TASKS bar, click Edit Configuration Details. The Client Configuration window appears.

  3. From the Product drop-down list, select MAS, Accounts or AO Classic GL.

  4. Enter the location of the ledger in the MAS ledger, Accounts ledger or AO Classic ledger field.

    UI Text Box
    typenote

    If you're planning on migrating an MYOB AE Assets ledger to MYOB Assets Live, select a current-year ledger.

  5. Click OK. The Configured Ledger Details are displayed on the right of the Trial Balance (Workpapers) tab.

Review the Migrate data window's options and change if necessary.

 

  • Use the Select to migrate current year transactions checkbox to choose your preference when migrating data

  • If you are not using an MYOB standard chart, click in the ledger account column in the table at the bottom of the Migrate data window and enter the correct value to use for each account in the list.
    The specified codes are displayed against these accounts after migration in the Workpapers tab and the Manage Accounts window.
    If you are using an MYOB standard chart, the ledger account values displayed in the table at the bottom of the window are correct.
  • Click OK. When the migration is successfully completed, the Migration summary window appears displaying the migration details, including the prior-year balances available (from and to dates).
  • If you closed the Migration summary window after successfully migrating your ledger and you want to review the migration details, click Migration summary from the TASKS bar any time.
  • Excerpt

    You can either:

  • leave clear to migrate the full prior-year balances
  • select to migrate the partial current-year balances, including transactions for any future periods.

    , click the Entity type drop-down menu and choose the correct entity type for your client.

  • If you have entered journals or transactions in the current financial year for the ledger (for example, you have not rolled forward your ledger into a new period), tick Select to migrate current year transactions. If there are no transactions or journals to migrate in the current financial year, skip this step.

  • UI Expand
    title2. Migrate to MYOB Ledger
    1. Go to the client’s

      From within your client's Client Accounting > Workpapers

      tab.

      On the TASKS bar (or Trial Balance) tab, click Migrate to AE ledger or Migrate to AO ledger.
      Image Removed Image AddedThe

    2. In the Migrate data window appears. Most details are automatically retrieved from your existing ledger but there are some options you can change:

    Data migratedDescription
    Source productThe general ledger type that you are migrating.
    NameThe name of the configured existing ledger.
    Client codeThe client code for the selected client's ledger.

    Entity type

    The entity type defined when you configured the ledger. Select a different entity type from the drop down if required.
    If the client is configured using legacy ledgers the Entity type defaults to <Select Entity>. You can edit this as required.
    Current year end dateThe last day of the current year in the selected client’s ledger.
    Select to migrate current year transactions
    UI Text Box

     

    This migrates transactions that are equal to or greater than the financial year start date as a Journal type.

    Start date for new AE/AO LedgerThe date from which you want to start using the AE Ledger.
    UI Expand
    title3. Check your migrated data

    You can view the migration log to view and action any warnings or errors.

    1. On the TASKS bar, click View migration log. The Migration Log window for the client appears.

    2. Optionally, to export the migration log to Microsoft Excel, click Export to Excel.

    3. Review the migration log and action the following:

      TypeDescription

      Error

      Errors in the migration log are an indication that the data was not migrated. If the migration is initiated for a general ledger which has already been migrated to an AE Ledger, the following error message is displayed: "The ledger already exists in the AE/AO Ledger system".Where the ledger does not balance and the migration fails, the following error message is displayed: " Please balance the ledger and re-migrate "
      WarningWarnings in the migration log indicate that some data was not migrated. This is normally happens where the configured  ledger  does not support migration of this kind of data. For example: "For Account code ***, the account name is migrated as Unknown Account Name". The warning message "Please verify the GST rate for each account code" is displayed for every successful migration.
      UI Text Box
      typenote

      If you migrate a ledger that has been migrated before, the prior year balances are overwritten.

    HTML Wrap
    width15%
    classcol span_1_of_5
     
    HTML Wrap
    floatleft
    classcol span_1_of_5

    UI Button
    colorpurple
    sizelarge
    linkModule 1. Setup
    textSetup >
    title<< Back
    urlhttp://help.myob.com/ps/wiki/x/2Y0x
     
    UI Button
    colorpurple
    sizelarge
    linkModule 1. Setup
    textSetup >
    titleNext >>
    urlhttp://help.myob.com/wiki/x/jQVNAQ

    Panelbox
    nameyellow
    titleYou're in MYOB Ledger module...
    HTML Wrap
    classsidebarlinks
    HTML
    <style>
    #container {
        text-align: justify;
        -ms-text-justify: distribute-all-lines;
        text-justify: distribute-all-lines;
        display:inline-block;
        width:100%;
        white-space: nowrap;
        overflow:hidden !important;
        overflow-x:hidden !important;
        margin-left:-5px;
        margin-right:-5px;
        margin-top:-3px;
        margin-bottom:-3px;
    }
    .box img {
        height:100%;
        width:100%;
    }
    .stretch {
        width: 100%;
        height: 110%;
        display: inline-block;
        font-size: 0;
        line-height: 0
    }
    .box {
        display:inline-block;
    }
    </style>
     <div id="container">
        <div class="box">
            <a href="http://help.myob.com/wiki/x/aAVNAQ"><img src="/wiki/download/attachments/21824856/step1.png?api=v2"></a>
        </div>   
    Panelbox
    nameyellow
    titleTasks in this module
    HTML Wrap
    classsidebarlinks

    Page Tree
    expandCollapseAlltrue
    rootMYOB Ledger module 1. Set up MYOB Ledger

    Panelbox
    nameyellow
    titleOther MYOB Ledger modules
    HTML Wrap
    classsidebarlinks

    Module 1. Set up MYOB Ledger

    Module 3. Add current-year data

    Module 4. Substantiate balances

    Module 5. Produce financial statements

    Panelbox
    nameyellow
    titleRelated topics
    HTML Wrap
    classsidebarlinks

    Create MYOB Ledger

    Configuring the client (AE Help)