To submit your NetSuite data using the Universal Connector, you FIRST need to download the Detailed Aged Receivables and Detailed Aged Payables reports from NetSuite.
Login into your NetSuite account by entering your User ID and Password for NetSuite 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 Reports dropdown, go to Customer/Receivables -> A/R Aging Summary -> Select Detail
In the Aged Debtors report, Set the Date to the end of the month, click refresh, and export the report.
Downloading the Purchase Ledger
From the Reports dropdown, go to Vendors/Payables -> A/P Aging Summary -> Select Detail
In the Aged Creditor report, Set the Date to the end of the month, click refresh, and export the report.
Once you have these 2 files you will be able to upload them to the DataShare Universal Connector. Click here for the guidelines to upload your data using the Universal Connector.
If you experience an error when uploading the report please ensure:
- You have removed a column called Currency in the report