Logic of GLPCT update

Summary

Symptom

How are the balances updated in GLPCT for periodic data transfer program in PCA?

Other terms

1KEH, 1KEK, 1KEI and 1KEJ ----- SUPPORTGUIDE 20010207191452 -----
REPORTWRITER, SGRW_DOCU_CONS_NOTE
SGRW_PCA

Reason and Prerequisites

The below-mentioned logic of the update of GLPCT is only referring to periodic data transfer programs, namely, 1KEH, 1KEK, 1KEI and 1KEJ.

Solution

The following explanation is using TA 1KEK as an example. This explanation is also applied to TA 1KEH, 1KEI and 1KEJ. However, the basis for reconcilation is different among these programs. Here are the differences :

• 1KEK total balance should reconcile with FI Account balance.

• 1KEH total balance should reconcile with Material Account Balance in MM.

• 1KEI total balance should reconcile with Asset Account Balance and Accumulated Depeciation Account Balance in FI-AA.

• 1KEJ total balance should reconcile with WIP balance caculated in the Result Analysis in CO-PC.

Example :

                  ( TA FS10 )        |   ( TA KE5Z )     ( TA GD13 )
                FI Account Balances  |      GLPCA            GLPCT
                ---------------------|------------------------------
Period 0            600              |        0              600
Period 1            800              |        800            200
Period 2            100              |        100            -700

Note that GLPCT is referring to 'Totals table' of PCA and GLPCA is referring to 'Actual Line Items table' of PCA. FI account balances are referring to the Account Receviable and Account Payable balances.

In period 0, Balance Carried Foward program ( TA 2KES ) is run in PCA. Note that this carried forward balance will only be updated in GLPCT and not GLPCA. Thus, in period 0, there is a balance of 600 in GLPCT and 0 balance in GLPCA.

In period 1, there is an ending balance of 800 in FI. When using 1KEK to transfer the balance from  FI to PCA , GLPCA will be updated as 800. As the period data transfer program updates GLPCT using a delta technique, it will calculate the balance using

  current ending balance(from FI) - pevious periods balance(from GLPCT)

Thus, for period 1, GLPCT = ( 800 - 600 ) = 200.

For period 2, FI ending balance is 100. Therefore GLPCA will be updated as 100. GLPCT will be updated as (100 - 200 - 600 ) = -700.

Now, if you would like to know the total balance for period 1 in PCA, one has to add ( GLPCT Period 0 + GLPCT period 1 ) = ( 600 + 200 ) = 800. And for period 2, one has to add ( GLPCT Period 0 + GLPCT Period 1 + GLPCT Period 2 ) = ( 600 + 200 - 700 ) = 100. The total balance should then be reconciled with FI Account balances.

Report Group 8A2N

In PCA, report group 8A2N can be used to display the total balance of Balance Sheet items. However, this report is showing balances at Controlling and Account level. To compare the total balance with FI, 8A2N has to be modified to display balance at Company Code and Account level. This can be achieved by the following steps :

• • Use TA GR31 ( Report Writer ) to copy report from 8A-PCA46 to ZA-PCA46 in the same library.

• • Select 'General data selection' -> Select 'Insert Set' -> 8A-RBUKRS.GLPCT (release 4.0* and above) or 8A-RBUKRS ( release 3.0* ).

• • Save and generate the newly created report. When generating or executing the report, you will be asked to create a new report group. You can specify any report group name or ZA2N.