Logic of GLPCT update
来源:互联网 发布:国家为什么不管公知 编辑:程序博客网 时间:2024/06/09 05:52
Summary
How are the balances updated in GLPCT for periodic data transfer program in PCA?
Other terms1KEH, 1KEK, 1KEI and 1KEJ ----- SUPPORTGUIDE 20010207191452 -----
REPORTWRITER, SGRW_DOCU_CONS_NOTE
SGRW_PCA
The below-mentioned logic of the update of GLPCT is only referring to periodic data transfer programs, namely, 1KEH, 1KEK, 1KEI and 1KEJ.
SolutionThe 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.
( 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.
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.
- Logic of GLPCT update
- 592 - Island of Logic
- 592 - Island of Logic
- uva592 - Island of Logic
- 592 - Island of Logic
- uva 592 Island of Logic
- UVa 592 - Island of Logic
- UVa 592 - Island of Logic
- UVA 592 - Island of Logic
- UvaOJ 592 Island of Logic
- UVA 592 Island of Logic
- UVa 592 - Island of Logic
- The Summary of Sequential Logic
- uva 592 Island of Logic (搜索)
- Secret of oracle logic IO: Consistent Gets
- Secret of oracle logic IO: Current Mode
- [暴力搜索]Island of Logic UVA592
- Island of Logic uva 暴力枚举
- ADS 中的 semihosting 问题
- ActiveX 控件与Internet
- SetWindowOrg和SetViewportOrg
- Oracle函數11-20
- WebClient类 详细使用教程
- Logic of GLPCT update
- Oracle函數31-40
- Apache james mailserver + Claros inTouch webmail
- Oracle函數21-30
- window下安装ubuntu(网上找到的,先储备着,呵呵)
- 将一个文件 读入一个数组中
- Oracle函數41-67
- Java 常用API文档
- 《Linux程序设计》读书笔记(一)