SAP Knowledge Base Article - Public

3035677 - Sum of base lines equals zero in Document Splitting

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

S/4 HANA Cloud

Cause

Where the sum of the base lines equal to zero the split will not take place based on the relevant account assignment string.


The following examples explains the logic applied during document splitting:


The formula for calculating the document splitting amount and assignment in new 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 vendor 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 Vendor                             20,00-
002 Expense                          10,00  PC01          SEGMENTA
003 Expense                          10,00  PC02          SEGMENTB
004 Balance Sheet Account  20,00- PC01          SEGMENTA
005 Vendor                            20,00

The document splitting rule is defined in such a way that the vendor 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 vendor 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 vendor 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 Vendor                               20,00
002 Expense                             10,00    PC01          SEGMENTA
003 Expense                             10,00    PC02          SEGMENT2
004 Balance Sheet Account     20,00-   PC01          SEGMENTA
005 Vendor                               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 vendor line item)



Example 2

For vendor 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 Vendor   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 vendor 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 vendor line items, the tax items are split before the vendor 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 Vendor    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 Vendor 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 new GL is as follows

Item Account Amount Profit Center Segment
001 Vendor   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 Vendor 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  Vendor                        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  Vendor                        20,00                     19,00                                                                 **


The document splitting rule is defined in such a way that the vendor 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 mulitplied by Precentage 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 new GL is as follows

Item Account Amount(LC EUR)         Amount(LC2 USD) Profit Center Segment Tax
001 Vendor                         100,00      105,00                    PC01               SEGMENTA **
001 Vendor                         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 Vendor                         100,00-       95,00-                 PC01               SEGMENTA **
005 Vendor                         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

Document Splitting

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 , Problem

Product

SAP S/4HANA Cloud all versions