Previous  Next          Contents  Index  Navigation  Glossary  Library

Using AutoInvoice

AutoInvoice Purge Program

You can choose whether to delete data from the AutoInvoice Interface tables once it has been validated and transferred into Receivables. If you want AutoInvoice to automatically delete the data, check the Purge Interface Tables check box in the System Options window. If you want to delete data from the AutoInvoice Interface tables later, do not check this check box. You can choose to run the AutoInvoice Purge program at any time from the Run AutoInvoice window.

The AutoInvoice Purge program and the Purge Interface Tables system option only delete data that has been validated and successfully transferred into Receivables.

Calculating Tax

AutoInvoice provides the functionality you need to meet your sales tax and other taxing requirements, such as Value Added Tax (VAT). You can either pass tax code lines, tax exempt lines or have AutoInvoice automatically determine your tax rates using the hierarchy determined by the tax calculation flow charts. See: Overview of Calculating Tax. If AutoInvoice determines your tax rates, it will take into account any customer or item tax exemptions or item tax exceptions.

Transactions in Closed Accounting Periods

Use AutoInvoice to pass transactions in closed accounting periods. Receivables automatically uses the first day of the next open accounting period as your default date to determine your accounting distributions. See: Adjusting General Ledger Dates.

Creating Transactions

AutoInvoice creates invoices, debit memos, credit memos and on-account credits using the grouping and invoice line ordering rules you specify. AutoInvoice verifies that your data is valid before it creates transactions in Receivables.

Deriving Invoice and Accounting Dates

AutoInvoice lets you choose how you want to determine invoice and accounting dates for your transactions. Your feeder program can either load these dates directly into the interface tables or, if you leave the date fields empty, Receivables will determine your invoice and accounting dates using a straightforward algorithm. See: Determining Dates.

Invoices Against Commitments

AutoInvoice lets you create invoices against commitments in the same way you would with a manually entered invoice.

Running AutoInvoice

You submit AutoInvoice using the Run AutoInvoice window. If AutoInvoice converts your transaction data into the required data format, and all of the data passes validation in Receivables, then you can run AutoInvoice in one step. However, if your feeder program loads the interface tables with invalid data, AutoInvoice informs you of the validation errors in both the AutoInvoice Processing and AutoInvoice Validation reports. In this case, you must correct any errors by modifying data in the interface tables and then rerun AutoInvoice on the corrected data. See: Importing Transactions Using AutoInvoice.

Receivables lets you treat transactions created by AutoInvoice the same as you would those entered manually through Receivables windows.

Execution Phases

AutoInvoice can be divided into three major phases: pre-grouping, grouping, and transfer.

In the pre-grouping phase, AutoInvoice validates all of the line-level data as well as any other data that is not dependent upon successful grouping. Some examples include validating that a transaction type is valid and validating that only one freight account exists for each freight line passed.

In the grouping phase, AutoInvoice groups lines based on the grouping rules and validates header-level data that is dependent on how your lines are grouped. Some examples include validating the over-application rules specified for your batch source and validating that the general ledger date of an invoice against a commitment is not before the general ledger date of the commitment.

In the transfer phase, AutoInvoice validates information that exists in Receivables tables, such as tax defaulting and AutoAccounting data.

Reviewing the AutoInvoice Execution and Validation Reports

Use the AutoInvoice Execution Report to review summary information about your transactions. AutoInvoice automatically creates this report each time you run AutoInvoice. The AutoInvoice Execution report lists the total number of transaction, sales credit, and distribution lines that were successfully imported, as well as those that failed. See: AutoInvoice Validation.

Note: It is possible to have the number of Successfully Processed lines be less than the number Selected and have no lines that Failed Validation. This will occur when a credit memo for an invoice and the invoice itself are submitted in the same batch and the credit memo is selected first. Since the invoice has not been processed yet, the credit memo will go unprocessed during this import but will not fail. The unprocessed credit memo remains in the interface table and will be processed the next time you submit AutoInvoice. In this example, the Interface Lines section of the execution report would appear as follows:

Selected: 9
Successfully Processed: 8
Failed Validation: 0

AutoInvoice also automatically generates the AutoInvoice Validation Report if you have records that failed validation. This report displays all error messages associated with each transaction, sales credit, and distribution line that failed validation. You can use this information to identify which transactions need to be fixed. Refer to the next section, Correcting Errors.

For each line, AutoInvoice can only display error messages for the phase the line is in when it fails. For example, if a line fails validation in the pre-grouping phase, AutoInvoice will display all error messages encountered in the pre-grouping phase. Likewise, if a line is already in the transfer phase when it fails, AutoInvoice will display all error messages encountered in the transfer phase.

If you encounter sales credit or distribution errors, AutoInvoice prints a separate section for these errors. These sections will display below each line.

Lastly, a Summary of Transactions Rejected section is printed at the end of the report. See: AutoInvoice Reports.

Correcting Errors

You can correct errors based on the error messages you receive in the AutoInvoice Validation Report. You may need to make changes in Receivables or in your feeder program. For example, if you receive an error message explaining that the salesperson you specified for an invoice does not exist in Receivables, you can add the salesperson to Receivables or fix your feeder program to only transfer salespersons that Receivables recognizes.

Transaction Flexfields

AutoInvoice provides you with a way to uniquely identify each transaction you import into Receivables. Use Transaction Flexfields to capture information that will help you trace transactions from Receivables back to the systems from which they originated.

AutoInvoice ensures that each Transaction Flexfield is unique so you can refer to previously processed transactions. For example, if you are importing a credit memo, you would use the Transaction Flexfield of the credit memo to refer to the transaction being credited. You can also use Transaction Flexfields to link transaction lines to other transaction lines and to tax and freight lines. See: Transaction Flexfields.

See Also

Passing Payment Methods and Customer Bank Accounts

Importing Transactions Using AutoInvoice

Importing Invoice Information into Receivables Using AutoInvoice

Importing Freight Lines

Importing Tax


         Previous  Next          Contents  Index  Navigation  Glossary  Library