Symptom
You try to carry out posting and receive error GLT2201 or although a posting is made, it is not as expected having regard to the causing account assignments.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
SAP S/4HANA Cloud Public Edition
Cause
Where the sum of the base lines equal to zero the split will not take place based on the relevant account assignment string.
Base Lines:
Base item categories determine for each line item all the possible lines in the document that account assignments should be derived from. From all the possible base item categories only the ones are taken into consideration that do exist in the document to be split.
The following examples explains the logic applied during document splitting:
The formula for calculating the document splitting amount and assignment in general ledger accounting is as follows:
Amount of line to be split *(multiply by) the Sum of base lines with same account assignment - i.e. the split criteria for document splitting, for example (PRCTR, SEGMENT) as in the line to be split /(divided by) the sum of all base lines
see customizing for split criteria:
Manage Your Solution -> Configure Your Solution -> Application Area: Finance, Sub Application Area: General Ledger
Define Document Splitting Characteristics for General Ledger Accounting ID 102322
Define Document Splitting Characteristics for Controlling ID 103055
Document splitting is performed separately in each currency.
Hypothetical Scenario
Fields configured for splitting
Field Zero balance Partner Field Mandatory
PRCTR Profit Center X PPRCTR X
SEGMENT Segment X PSEGMENT X
Example 1
For Supplier invoice document type KR business transaction/transaction variant 0300/0001
A document with the following lines in the entry view
Item Account Amount Profit Center Segment
001 Supplier 20,00-
002 Expense 10,00 PC01 SEGMENTA
003 Expense 10,00 PC02 SEGMENTB
004 Balance Sheet Account 20,00- PC01 SEGMENTA
005 Supplier 20,00
The document splitting rule is defined in such a way that the Supplier items (item category 03000) are split based on the expense items (item category 20000) and the balance sheet account items (item category 01000)
(Note that inheritance cannot come into play in this example as there is not a unique account assignment.)
Line item 001 would be split as follows
20,00- * (10,00- /0,00) PC01 SEGMENTA
20,00- * (10,00 /0,00) PC02 SEGMENTB
However as this calculation includes a division by zero, the split is not possible.
There is no split of Supplier line on Profit Center PC01/Segment SEGMENTA or Profit Center PC02 SEGMENTB
Likewise item 005 cannot be split based on the causing account assignments
As a result of no splitting of the Supplier items, the following line items now exist on the simulation of the General Ledger (zero balance clearing lines are also generated to balance the account assignments to zero. See note 973342 which explains the concept of zero balance clearing lines)
Item Account Amount Profit Center Segment
001 Supplier 20,00
002 Expense 10,00 PC01 SEGMENTA
003 Expense 10,00 PC02 SEGMENT2
004 Balance Sheet Account 20,00- PC01 SEGMENTA
005 Supplier 20,00-
Zero Balance Clearing 10,00 PC01 SEGMENTA
Zero Balance Clearing 10,00- PC02 SEGMENTB
Error GLT2201 Balancing field "Profit Center" in line item 001 not filled. (Note if a constant value is present in customizing Edit Constant for Nonassigned Processes ID 120100, this would be used in Supplier line item)
Example 2
For Supplier invoice document type KR business transaction/transaction variant 0300/0001
A document with the following lines in the entry view is posted
Item Account Amount Profit Center Segment
001 Supplier 11,90-
002 Expense 10,00 PC01 SEGMENTA
003 Expense 10,00- PC01 SEGMENTA
004 Expense 10,00 PC02 SEGMENTB
005 Tax 1,90
The document splitting rule is defined in such a way that the tax items (item category 05100) are split based on the expense items (item category 20000) and the Supplier line items (item category 03000) are split based on both the expense items (item category 20000) and the tax items (item category 05100) .
Since the split tax items are required as a basis for splitting the Supplier line items, the tax items are split before the Supplier line items are split.
Line item 005 is split as follows
1,90 * ( 0,00 /10,00) = 0,00 to PC01 SEGMENTA
1,90 * (10,00 /10,00) = 1,90 to PC02 SEGMENTB
There is no split to the tax item based on Profit center PC01/Segment SEGMENTA
As a result of splitting the tax items, the following line items now exist:
Item Account Amount Profit Center Segment
001 Supplier 11,90
002 Expense 10,00 PC01 SEGMENTA
003 Expense 10,00- PC01 SEGMENTA
004 Expense 10,00 PC02 SEGMENTB
005 Tax 1,90 PC02 SEGMENTB
The expense and tax items create the basis for splitting the Supplier line items
Line item 001 is split as follows
11,90 * ( 0,00 / 11,90) = 0,00 to PC01 SEGMENTA
11,90 * ( 11,90 / 11,90) = 11,90 to PC02 SEGMENTB
The resulting posting in GL view is as follows
Item Account Amount Profit Center Segment
001 Supplier 11,90- PC02 SEGMENTB
002 Expense 10,00 PC01 SEGMENTA
003 Expense 10,00- PC01 SEGMENTA
004 Expense 10,00 PC02 SEGMENTB
005 VAT 1,90 PC02 SEGMENTB
The Tax and Supplier lines have no split of the account assignment characteristic values for Profit Center and Segment PC01 SEGMENTA
Example 3
If a value to split is not equal to zero in one currency type, but the total of base values is zero in both this currency type and in the general ledger update currency, the system attempts to determine the split ratio for this currency type from the values of another currency type
A document with the following lines in the entry view. (Amount in Document currency (EUR) and Local (Company Code) currency (EUR) are the same.
Values in Group currency (Second local currency LC2 - USD) to show demostration
Item Account Amount (LC EUR) Amount(LC2 USD) Profit Center Segment Tax
001 Supplier 20,00- 21,00- **
002 Expense 10,00 11,00 PC01 SEGMENTA V0
003 Expense 10,00 12,00 PC02 SEGMENTB V0
004 Balance Sheet Account 20,00- 21,00- PC01 SEGMENTA
005 Supplier 20,00 19,00 **
The document splitting rule is defined in such a way that the Supplier items (item category 03000) are split based on the expense items (item category 20000) and the balance sheet account items (item category 01000)
Please note that documents splitting internally considers the tax code, because it may be required for follow-up processes.
The splitting is performed separately in all currencies
In Group currency Line item 001 is be split as follows internally
21,00- * (11,00/2) = -115,50 PC01 SEGMENTA V0
21,00- * (21,00-/2) = 220,50 PC01 SEGMENTA
.........
105.00
21,00- * (12,00/2) = -126,00 PC01 SEGMENTB
For the Local currency the sum of the base values equals zero (likewise with document currency as in example 1) however as in this case total of base values is not equal to zero in group currency the value Local Currency Line (and document currency) is split using a precentage value to determine amount.
The system uses the percentage value to determine amount
Percent = Sum of base lines with same account assignment /(divided by) the sum of all base lines
Item 001 is split as follows
(11,00/2) = 5,50 PC01 SEGMENTA V0
(21,00-/2) = -10.5 PC01 SEGMENTA
(12,00/2) = 6,00 PC02 SEGMENTB V0
The amount to be split in local currency is multiplied by Percentage values
20,00 - * 5,50 = -110,00 PC01 SEGMENTA V0
20,00 - * -10,50 = 210,00 PC01 SEGMENTA
20,00 - * 6,00 = -120,00 PC02 SEGMENTB V0
The resulting posting in GL view is as follows
Item Account Amount(LC EUR) Amount(LC2 USD) Profit Center Segment Tax
001 Supplier 100,00 105,00 PC01 SEGMENTA **
001 Supplier 120,00- 126,00- PC02 SEGMENTB **
002 Expense 10,00 11,00 PC01 SEGMENTA V0
003 Expense 10,00 12,00 PC02 SEGMENTB V0
004 Balance Sheet Account 20,00- 21,00- PC01 SEGMENTA
005 Supplier 100,00- 95,00- PC01 SEGMENTA **
005 Supplier 120,00 114,00 PC02 SEGMENTB **
Zero Balance Clearing 10,00 0,00 PC01 SEGMENTA
Zero Balance Clearing 10,00- 0,00 PC02 SEGMENTB
Resolution
Rules of document splitting:
A posting should only contain one business process not multiple. In case two processes are posted in a document. We recommend that you split the document. Enter a separate document for each sub-process. Example invoice and credit memo.
See Also
Keywords
GLT2 201, GLT2201, balancing field, difference, GLT0004, GLT0 004, OVERFLOW, large amounts in general ledger view, BASIS_SUM_WA-WRBTR, AMOUNT_WA-WRBTR, API , KBA , FI-GL-FL , Flexible Structures , FI-GL-FL-2CL , Flexible Structures (Public Cloud) , Problem