Previous	Next		Contents	Index	Navigation	Glossary	Library

AutoInvoice requires mandatory grouping on the transaction attributes Currency Code and Bill-To Customer (only one of each attribute is allowed per invoice). Receivables automatically applies these required grouping rules to any additional transaction attributes that you assign to your grouping rules. All attributes of the Transaction Flexfield are optional within a grouping rule and you can assign these attributes as optional grouping characteristics in the Grouping Rules window.

In the figure below, the grouping rule specifies that items must have the same currency, Bill-To address, and Order Type to appear on the same invoice. Items A and B share the same currency and Order Type, so they appear on the same invoice (Invoice 1). Item C has the same currency as A and B, but it has a different order type, so it appears on its own invoice (Invoice 2). Items D and E share the same currency and Order Type, so they appear on the same invoice (Invoice 3).

AutoInvoice uses the following hierarchy to determine which grouping rule to use for a transaction line:

1) The grouping rule specified in the Transaction Sources window for the batch source of the transaction line

2) The grouping rule specified in the Customer Profile Classes window for the bill-to site use of the transaction line

3) The grouping rule specified in the Customer Profile Classes window for the bill-to customer of the transaction line

4) If you do not specify a rule in either the Transaction Sources or Customer Profile Classes window, AutoInvoice uses the default grouping rule specified in the System Options window. See: Defining Receivables System Options.

Receivables provides the grouping rule 'DEFAULT' which contains all required groupings based on the transaction attributes. If you upgrade from a previous version of Receivables, this grouping rule initially becomes your default grouping rule. If you use this rule to create transactions, Receivables does not require that you define any additional grouping rules. You can customize this grouping rule by including additional transaction attributes.

Attention: If you are doing a fresh install of Receivables, you must enter a default grouping rule in the System Options window. You can enter the grouping rule that Receivables provides or one that you create.

Receivables lets you assign an invoice line ordering rule to each of your grouping rules. AutoInvoice uses the invoice line ordering rule to order your transaction lines when grouping revenue and credit transactions into invoices, debit memos, and credit memos. See: Invoice Line Ordering Rules.

Note: You cannot view the required grouping on transaction attributes from the Grouping Rules window. Use the Ordering and Grouping Rules Listing report to view all grouping on transaction attributes that are assigned to your grouping rules. See: Ordering and Grouping Rules Listing Report.

Prerequisites

   Define Invoice Line Ordering Rules

   To define a grouping rule:

1. Navigate to the Grouping Rules window.

2. Enter a Name for this grouping rule.

3. Enter a Description for this grouping rule (optional).

4. Enter the invoice line ordering rule for this grouping rule (optional). The invoice line ordering rule tells AutoInvoice how to order transaction lines within this grouping rule.

5. Enter a range of Effective Dates for this grouping rule. The default Start Date is today's date, but you can change it. If you do not enter an end date, this grouping rule will be active indefinitely.

6. Enter the Transaction Class to define for this grouping rule. Choose from the following classes: Invoice, Debit Memo, or Credit Memo.

Note: If AutoInvoice uses grouping rules and it is processing a transaction class that is not defined for this grouping rule, AutoInvoice will only use the mandatory grouping transaction attributes.

7. Enter any Optional Grouping Characteristics you want to use to group your transactions. For example, if you enter the transaction flexfield attribute 'Attribute2' (order type), only transactions with the same order type can appear together on a transaction. Use the list of values to review the description and sources of each attribute.

Receivables ensures that you do not assign duplicate transaction class grouping characteristics to your grouping rule.

8. Save your work.

See Also

Using AutoInvoice

Ordering and Grouping Rules Listing