3035677 - Sum of base lines equals zero in Document Splitting

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."

S/4 HANA Cloud

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

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.

Document Splitting
Document Splitting Process
Vendor Invoice (Business Transaction 0300)

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

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions