Please note that this routine needs to be completed prior to closing the relevant period in either Asset Manager or Dimensions.
Log into your Asset Manager application and then follow the following steps:
Please take a backup of your Asset Manager database as this routine is irreversible!
On the Data tab, click Access Link. The Access Accounts Login screen will be displayed.
Enter your User Name and Password details to connect to your accounts database.
Click Login. The Access SQL Link – Import and the Access SQL Link – Export windows will open.
Close the Access SQL Link – Import screen so that the Access SQL Link – Export will be the only screen visible.
Enter or select the required options.
Please note the following:
Period and Year refer to period and year values in your Dimensions database.
The Generate Nominal Accounts option will be disabled automatically if you are using Advanced Nominal Ledger in your accounts database.
Enter the Reference and Description that you wish to appear in your journal.
The default setting for Date is today but can be overtyped.
You have the option to either Batch your journal (Recommended) or directly post to your Nominal Ledger accounts.
If you wish, you can click Print to print/preview the journal prior to posting into Dimensions.
Click the Options tab. A new screen will be displayed, where you can select the transaction type(s) to export
Please note the following:
You can tick the Use Transaction Refs option to use the reference, date and description information from the Asset Manager transaction rather than those entered in the Export window. This is recommended as it passes more detail to your accounts.
If the Summarise Journal option is not ticked, the data that is exported will contain a separate detail line for each transaction from Asset Manager. If ticked, the data will be grouped by the Nominal account that is to be updated, ie. There will be one entry per Nominal account. Each line may then contain a number of transactions and the information specific to individual transactions will be lost.
Untick the Do Not Post To Costing option, If costing fields are included in the selected export fields, and you want them to be exported
Click OK to create and batch/post the journal to Dimensions.
The journal will be posted and an Update Asset Manager query will appear.
Check if the transactions have been fully posted/batched to Dimensions Accounts.
If the transactions can be seen in Dimensions, click Yes. The transactions will be flagged as transferred and will not be included in the next export.
Note: Clicking No will cause the same transactions to be duplicated in the next Asset Manager export; therefore, you should only click No if you intend to export the same journal again.