Account Matching Report Considerations
Take note of the following considerations when using the Account Matching Report SuiteApp:
-
To avoid issues with the report, ensure that all accounting periods are assigned before you use the SuiteApp. For more information, see Accounting Period Management.
-
Each exported CSV file can have up to 1,000,000 rows, and the file size is approximately 200 megabytes.
With 4 exported CSV files, you can have up to 3,400,000 transaction lines, including all child transactions.
-
The Applied Debit Amount and Applied Credit Amount columns are only included in the CSV file, and do not appear on the Account Matching Report page user interface.
-
The total Debit and Credit amounts in NetSuite may not match the Applied Debit Amount and Applied Credit Amount totals in the CSV file.
This behavior is expected because a parent transaction amount can be applied to several child transactions, and the applied amount can be either a debit or a credit. However, the total applied amounts will always match the parent transaction's original amount.
Tip:You can use the SUM (n:m × 100) ÷ 100 function in your exported CSV file to match the total Debit and Credit amounts in NetSuite. Here, n is the first row number and m is the last row number in the CSV file.
-
The maximum number of parent transaction lines, in the NetSuite user interface, for the selected start period and end period is 100,000.
-
To avoid issues, the AMR Customized Model role of the SuiteApp should not be customized.