Option Here you… Comment Company Select the target company you E.g. CEU wish this journal to be posted into. Description Enter a short description of the E.g. Opening Balances 2013 journal Date a year end date E.g. 30/06/2012 Voucher series Enter a number sequence you wish to use as a voucher Journal series Enter a number sequence you wish to use as a journal Main Account Enter Natural Account code for Paste this list from your re-coded trial balance each account that appears in the Trial Balance Legacy account Enter the legacy system’s account Paste this list from the legacy system’s trial balance. This provides a useful (Description) code in this column cross reference and can be used in reconciliation between systems Type Select Ledger Currency Enter a currency code to match E.g. USD that of the base currency of the ledger Rate Enter an exchange rate. E.g. 100 or 1 Enter the debit amount for this Leave blank if credit transaction Credit Enter the credit amount for this Leave blank if debit transaction Document a reference for this transaction E.g. FY2012 Document date Enter a year end date E.g. 30/06/2012 or leave blank Financial Enter dimension codes to suit Paste values from the re-coded trial balance dimensions each main account Upload this into Microsoft Dynamics AX. Option Here you… Comment Atlas ribbon Select Journal Ensure mode is Standard Document template list Tick to select Year End Trial Balance Journal Confirmation tab Double-click to open Confirmation tab Click to select Upload This sends the journal to Microsoft Dynamics AX. If it is successfully loaded, the journal number in cell I5 is updated and the number of records, along with the journal number is shown in the template confirmation tab.
Option Here you… Comment Company Select the target company you wish this journal to be posted into. E.g. CEU Description Enter a short description of the journal E.g. Opening Balances 2013 Date a year end date E.g. 30/06/2012 Voucher series Enter a number sequence you wish to use as a voucher Journal series Enter a number sequence you wish to use as a journal Main Account Enter Natural Account code for each account that appears in the Trial Balance Paste this list from your re-coded trial balance Legacy account (Description) Enter the legacy system’s account code in this column Paste this list from the legacy system’s trial balance. This provides a useful cross reference and can be used in reconciliation between systems Type Select Ledger Currency Enter a currency code to match that of the base currency of the ledger E.g. USD Rate Enter an exchange rate. E.g. 100 or 1 Enter the debit amount for this transaction Leave blank if credit Credit Enter the credit amount for this transaction Leave blank if debit Document a reference for this transaction E.g. FY2012 Document date Enter a year end date E.g. 30/06/2012 or leave blank Financial dimensions Enter dimension codes to suit each main account Paste values from the re-coded trial balance Upload this into Microsoft Dynamics AX. Option Here you… Comment Atlas ribbon Select Journal Ensure mode is Standard Document template list Tick to select Year End Trial Balance Journal Confirmation tab Double-click to open Confirmation tab Click to select Upload This sends the journal to Microsoft Dynamics AX. If it is successfully loaded, the journal number in cell I5 is updated and the number of records, along with the journal number is shown in the template confirmation tab.
Data%20Migration_GLSEPT13.docx