To submit your Open Accounts data using the Universal Connector, you FIRST need to download the Detailed Aged Receivables and Detailed Aged Payables reports from Open Accounts.
Login into your Open Accounts account by entering your User ID and Password for Open Accounts then click Login.
When you download the reports you must open and save them as a '.xlsx' file before you upload them to the portal.
Downloading the Sales Ledger
From the Debtors Reports, select Detailed Aged Debtors Report
In the Aged Debtors report, Set the Date to the end of the month with your parameters.
Once you have set the parameters Click on 'printer' select excel (.xlsx) as the output and click OK
Downloading the Purchase Ledger
From the Creditor Reports, select Detailed Aged Creditors Report
In the Aged Creditor report, Set the Date to the end of the month with your parameters.
Once you have set the parameters Click on 'printer' select excel (.xlsx) as the output and click OK
Once you have these 2 files you will be able to upload them to the Validis Universal Connector. Click here for the guidelines to upload your data using the Universal Connector.