Downloading Sales and Purchase Ledger data from Access Dimension for the Universal Connector

To submit your Access Dimension data using the Universal Connector, you FIRST need to download the Detailed Aged Receivables and Detailed Aged Payables reports from Access Dimension.

Login into your Access Dimension account by entering your User ID and Password for Access Dimension then click Login.

When you download the reports you must open and save them before you upload them to the portal.

Downloading the Sales Ledger

From the Reports section, select Debtors, and As At Period Aged Debtors Report (detailed) 

In the Aged Debtors report, set the period to the current month.

Make sure that you select 'Microsoft Excel' as the file format and click download. 

Downloading the Purchase Ledger

To download the Purchase Ledger, follow the same process as for the Sales Ledger. Select reports As At Period Aged Creditor Report (detailed)

In the Aged Creditors report, set the period to the current month.

Make sure that you select 'Microsoft Excel' as the file format and click download. 

Once you have these 2 files you will be able to upload them to the Barclays LedgerShare Universal Connector. Click here for the guidelines to upload your data using the Universal Connector.

Example of output