Invoice grouping

Invoices are created based on several grouping criteria that determine how ledger entries are combined into a single invoice. The system provides default grouping rules and advanced configurable grouping options.

Default grouping rules

The system automatically groups ledger entries using these criteria:

Grouping field	Description
Sell-to/Buy-from No.	The customer for the entry
Bill-to/Pay-to No.	The party that is billed
Invoice Type Code	Entries with the same invoice type are grouped
Currency Code	Entries with the same currency
Business Unit Code	Entries with the same business unit
Subsidiary Code	Entries with the same subsidiary

All of these fields must match for entries to be grouped into the same invoice. Entries that result in a credit are grouped into a separate credit memo.

Invoice period integration

When a customer has an Invoice Period Code assigned, the grouping system additionally considers the period dates:

• Entries are only grouped within the same invoice period.
• The period start date is used as part of the grouping key.
• This supports flexible billing cycles (weekly, monthly, quarterly, etc.).

Advanced grouping options

You can configure additional grouping criteria through the Customer Invoicing Setup to create more specific grouping rules.

Configuration levels

The system supports three levels of configuration, applied in priority order:

1. Customer — specific rules for individual customers
2. Customer Price Group — rules applied to customers in the same price group
3. All Customers — global rules applied to all customers

Grouping criteria codes

You can set up Grouping Criteria Codes that define exactly how ledger entries should be grouped. These criteria can include:

• Field-based grouping — group by specific field values (for example, source type, external document)
• Date-based grouping — group entries within specific date ranges
• Filter-based grouping — apply complex filtering rules before grouping

When a grouping criteria code is configured, the system evaluates each ledger entry against the criteria filters. If the entry matches, the grouping criteria key is appended to the default grouping key, creating sub-groups within the default grouping.

Multiple grouping rules

You can configure multiple grouping criteria for the same customer or group. The system evaluates each criteria in order and uses the first matching one.

Example scenarios

Example 1: Project-based grouping

• Setup: Group entries by external document reference
• Result: Each project or contract gets its own invoice
• Ideal for project-based billing arrangements

Example 2: Periodic grouping

• Setup: Assign an Invoice Period Code to the customer
• Result: Entries are grouped by period (weekly, monthly, quarterly)
• Customer receives consolidated invoices for specific time periods

Example 3: Split by source type with different billing cycles

• Setup: Configure two grouping criteria for the same customer. The first criteria filters on entries with sub-source type Storage Charge and assigns a monthly invoice period. The second criteria filters on source Service and assigns a weekly invoice period.
• Result: Storage charges are grouped into monthly invoices, while service charges are grouped into weekly invoices.
• The customer receives separate invoices per billing cycle and charge type.