By Mmcasey-Oracle on Aug 12, 2015
Receivables lets you define several options for your invoices and use of Autoinvoice. You can specify whether to purge the interface tables that you use for Autoinvoice, the maximum number of bytes to use, whether SQL Trace is active for Autoinvoice, and the grouping rule to use for revenue and credit transactions you create through Autoinvoice.
The System Options form has four sub tabs: Accounting, Trans and Customers, Claims and Miscellaneous
Responsibility: Receivables Manager
Navigation: Setup > System > System Options
The tab with the Autoinvoice options is the Trans and Customers tab.
- Since Autoinvoice processes bulk data through an open interface table, its is not necessary to retain the data in the interface table once the transactions have been generated in Receivables. By checking Purge Interface Tables checkbox in the System Options form, you are allowing Autoinvoice to clean up after itself once it has completed processing.
- Setting your Max Memory (in bytes) is also important for Autoinvoice, the recommended setup is 3MB (3145728 bytes).
- Log File Message Level is recommended at 0 (zero). Setting the log file message level to 0 provides the least detailed debug message but still includes errors and warning messages. After you have completed and tested Autoinvoice for the first time you should need only minimal messages in the log file. You can change the log file message level to 3 or above only when you want to troubleshoot Autoinvoice.
- Enter the grouping rule that was setup in Receivables > Setup > Transactions > Autoinvoice > Grouping Rules. Autoinvoice uses grouping rules to group invoices, credit memos and debit memos. Grouping rules contain various transaction attributes (columns in RA_INTERFACE_LINES_ALL table) that must be identical across several interface records if the intention was for it to create one transaction.
Excellent Resources for Autoinvoice: