To submit your SAP data using the Universal Connector, you FIRST need to download the Detailed Aged Receivables and Detailed Aged Payables reports from SAP.
Login into your SAP account by entering your User ID and Password for SAP then click Login.
You will need to use both the 'Customer Receivables Ageing' and 'Supplier Liabilities Aging' reports found by going to 'Modules' > 'Reports' > 'Financials' > 'Accounting' > 'Ageing'
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 Modules dropdown, select Customer Receivables Ageing.
In the Aged Debtors report, Set the Date to the end of the month, and tick ignore future remit.
Click Ok when you are ready to run the report and export it to Excel
Open the report and save it as an Excel workbook (.xlsx)
Downloading the Purchase Ledger
From the Modules dropdown, select Supplier Liabilities Ageing.
In the Aged Credit report, Set the Date to the end of the month, and tick ignore future remit
Click Ok when you are ready to run the report and export it to Excel.
Open the report and save it as an Excel workbook (.xlsx)
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.