Complete this routine before closing the relevant period in either Asset Manager or Dimensions. Log in to Asset Manager, then follow these steps:
Take a backup of your Asset Manager database. This routine is irreversible.
On the Data tab, click Access Link. The Access Accounts Login screen opens.
Enter your User Name and Password to connect to your accounts database.
Click Login. The Access SQL Link – Import and Access SQL Link – Export windows open.
Close the Access SQL Link – Import screen, leaving only the Export screen visible.
Enter or select the required options.
📌 Note:
Period and Year refer to the period and year in your Dimensions database.
Generate Nominal Accounts is disabled automatically if you use the Advanced Nominal Ledger.
Enter the Reference and Description to appear in the journal.
The Date defaults to today and can be changed.
Choose to Batch the journal (recommended) or post directly to the Nominal Ledger.
Click Print to preview the journal before posting.
Click the Options tab. Select the transaction types to export.
📌 Note:
Tick Use Transaction Refs to use the reference, date, and description from the Asset Manager transaction rather than what was entered in the Export window. Recommended — it passes more detail to your accounts.
If Summarise Journal is unticked, a separate detail line is exported for each Asset Manager transaction. If ticked, data is grouped by nominal account — one entry per account — and transaction-level detail is lost.
Untick Do Not Post To Costing if costing fields are included in the export and you want them exported.
Click OK to create and batch or post the journal to Dimensions.
The journal posts and an Update Asset Manager prompt appears.
Confirm the transactions are fully posted or batched in Dimensions.
If the transactions are visible in Dimensions, click Yes. They are marked as transferred and excluded from the next export. 📌 Note: Clicking No causes the same transactions to be exported again next time. Only click No if you intend to re-export the same journal.