To submit your LakeView data using the Universal Connector, you FIRST need to download the Detailed Aged Receivables and Detailed Aged Payables reports from LakeView.
Login into your LakeView account by entering your User ID and Password for LakeView 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 Sales dropdown, select Reports, and Retrospective Aged Debtors.
In the Aged Debtors report, open 'Report Options'
Set the date to the end of the month you are reconciling and add any other parameters needed.
Open the report and select change layout, then choose the option 'W (historical debt)'
Set the output to Comma separated (MS Excel)
Once all the parameters have been filled out, run the report.
Downloading the Purchase Ledger
From the Purchase dropdown, select Reports, and Retrospective Aged Creditors.
Follow the same steps outlined in Downloading the Sales Ledger but for the creditors.
In the Aged creditor's report, open 'Report Options'
Set the date to the end of the month you are reconciling and add any other parameters needed.
Open the report and select change layout, then choose the option 'W (historical debt)'
Set the output to Comma separated (MS Excel)
Once all the parameters have been filled out, run the report. The report should look like the example below.
Open the CSV file and ensure that the report is saved in an Excel workbook (.xlsx) format before attempting to upload
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.