Skip to main content

Grouping Rules


Define grouping rules that AutoInvoice will use to group revenue and credit transactions into invoices, debit memos, and credit memos. Grouping rules specify attributes that must be identical for lines to appear on the same transaction.
Grouping rules include mandatory attributes which are always included in all grouping rules, and optional attributes which may be included in a grouping rule. Optional attributes may be added to the mandatory attributes to create new grouping rules. To be included in a group a transaction must always match on all of the mandatory attributes as well as on all of the optional attributes included in a grouping rule. For complete lists of the mandatory attributes and the optional attributes see the section titled "Using Grouping Rules to Create Transactions" in the Transactions chapter. 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.
Note: The Grouping Rules window only displays the optional attributes included in a grouping rule. This window does not display any mandatory grouping attributes. The mandatory attributes are the same for all grouping rules. Use the Ordering and Grouping Rules Listing report to view all of the mandatory and optional attributes assigned to your grouping rules. See: Ordering and Grouping Rules Listing Report.
In the diagram below, the grouping rule specifies that to appear on the same invoice items must match on all of the mandatory attributes, for example currency (CURRENCY_CODE) and bill-to address (ORIG_SYSTEM_BILL_ADDRESS_ID) and must also match on the optional attribute of order type (SALES_ORDER_SOURCE). For example, in the diagram, assume that all mandatory attributes match other than currency and bill-to address. 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).
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.

Comments

  1. techhighwayMarch 7, 2019 at 2:15 AM

    I wondered upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon.
    mobile app developers pune

    ReplyDelete

Post a Comment

Popular posts from this blog

Applying Prepayments to Invoices

You can apply the available amount of Item type distributions from a Temporary type prepayment to one or more invoices to offset the amount you pay on the invoice(s). If you entered the prepayment as a Permanent type and want to apply it, you can query the prepayment in the Invoices window and change the Prepayment Type to Temporary. If you use Automatic Offsets then your setting for the Prevent Prepayment Application Across Balancing Segments Payables option controls whether you can apply a prepayment to an invoice or expense report with a different balancing segment. Prerequisites The invoice type is Standard, Mixed, or Expense Report. Today's date is on or after the Settlement Date of the prepayment. The invoice date is on or after the date of the prepayment. The prepayment is type Temporary, fully paid, validated, not cancelled, has no active holds, and has not already been fully applied. The prepayment has the same supplier, invoice currency and payment currenc...
1 comment
Read more

Overview of Encumbrance Accounting

With General Ledger you can record pre-expenditures commonly known as encumbrances. The primary purpose of tracking encumbrances is to avoid overspending a budget. Encumbrances can also be used to predict cash outflow and as a general planning tool. To use the full capabilities of encumbrance accounting, you must enable the budgetary control flag for a set of books. When you enable the budgetary control flag, the system automatically creates encumbrances from requisitions, purchase orders and other transactions originating in feeder systems such as Purchasing and Payables. When you do not enable the budgetary control flag, you can still enter manual encumbrances via journal entry, but you cannot generate encumbrances from requisitions and purchase orders. You have two options for using encumbrance data to monitor over-expenditure of a budget: After actuals and encumbrances have been posted, you can generate reports to show over-expenditures. You can also can use funds checking to preve...
Post a Comment
Read more

Apply/Unapply Prepayments Window Reference

Payables provides two ways to apply prepayments to an invoice. You can do either of the following: i-> Create or query an invoice and apply one or more prepayments to the invoice. ii-> Create or query the prepayment and apply it to one or more invoices. Selecting an Invoice and Applying it to a Prepayment When you select an invoice and choose the Apply/Unapply Prepayment option in the Invoice Actions window, the Apply/Unapply Prepayments window opens. It automatically displays all prepayments that have been applied to the invoice, and all available Prepayment distributions that you can apply to the invoice. Payables displays prepayment item type distributions that meet the following criteria: same supplier, and invoice currency as the invoice. The prepayment's Settlement Date is on or before today's date. The prepayment's date is on or before the date of the invoice. The prepayment is type Temporary with a status of Available. If you use Automatic Offsets, you can se...
Post a Comment
Read more