How AutoInvoice Processes Transactions with Document Sequencing

If the primary ledger is enabled for document sequencing, AutoInvoice validates and assigns document numbers to transactions according to the requirements of the ledger settings.

Note: If an imported transaction line already has a document number, then AutoInvoice accepts this document number without further validation.

Settings That Affect AutoInvoice Processing with Document Sequencing

If the primary ledger option Enforce Chronological Order on Document Date is enabled, then you must set the Receivables system option Accounting Dates Out of Order. Setting this option determines how AutoInvoice processes transactions when the accounting date is out of order within the document sequence.

Before you run the Import AutoInvoice program, you must also create and assign document sequences to the document categories of the transaction types that you plan to assign to imported transactions.

How Transactions with Document Sequencing Are Processed

For the most complete example, if the primary ledger is set for document sequencing at the legal entity level, AutoInvoice processes transactions in this way:

1. Validate and group transaction lines into transactions.

2. Derive the legal entity for each transaction and assign the legal entity to the transaction.

3. If the transaction doesn't have an accounting date, then derive the accounting date.

4. If the primary ledger option Enforce Chronological Order on Document Date isn't enabled:

   1. Retrieve the document sequence for the document category of each transaction type assigned to transactions.

   2. Assign the document number to the transaction according to the combination of legal entity, transaction type, document sequence, and accounting date.

5. If the primary ledger option Enforce Chronological Order on Document Date is enabled:

   1. Order transactions by legal entity and then by transaction type.

   2. Retrieve the document sequence for the document category of each transaction type assigned to transactions.

   3. Order transactions by document sequence and then by accounting date in ascending chronological order.

   4. Compare the document sequence accounting date to the accounting date of the transaction.

   5. If the transaction accounting date is equal to or later than the document sequence accounting date, assign the document number to the transaction according to the combination of legal entity, transaction type, document sequence, and accounting date.

   6. If the transaction accounting date is earlier than the document sequence accounting date, retrieve the value of the Receivables system option Accounting Dates Out of Order.

   7. If the Accounting Dates Out of Order option is set to:

      • Reject: Reject the transaction and transfer the transaction to the error table.

      • Adjust: Update the transaction accounting date with the document sequence accounting date.

        Note: If the document sequence accounting date is in a closed period, then adjust this date to the first open accounting period.

   8. Assign the document number to the transaction according to the combination of legal entity, transaction type, document sequence, and accounting date.