WT Amount shown in RT but didn't post to Accounting

[former_member764721]

Hi all,

We have WT4007 which is showing in RT and posting was done too without any errors. However, for one employee 4007 WT is not reflecting in Posting doc and is not posted to Finance. For all other employees it has been posted except one employee.

I have checked the PPMOD, EE group assignments are correct.

Please help.

[sikindar_a]

if it is maintained in IT0015 for the month of may it wont get paid for the next months june and july (am i correct) hence it wont be seen in RT and also in Postings

[former_member764721]

Hi,

The month we are discussing is also may only. Actually, amount is showing posted in the specific GL for may (when running simulation for that particular employee now) but when entering the GL account of that posted document this particular employee is not showing their. [Please refer to the screenshot attached in Balasubramanian sir chat trail ]

[sikindar_a]

In which infotype 14 or 15

[former_member764721]

Infotype 15

[sikindar_a]

Can you check the validity of wage type for the following employee in the master data for the month fo august

[former_member764721]

It's a one time payment for a year. The amount was maintained on 17th May 2022 for this particular employee.

[VivekPalanivel]

please check before posting in the simulation. You will see under GL header, the list of wage types in cr and dr. What goes to the finance is the final calculated value and not individual wage types impacting that GL.

[BalaAP]

Hi, I guess similar to Vivek's concept.

But I also recommend you to do a simulation posting for this employee selection alone, so that we can check whether the payroll result is considered for payroll posting for this employee.

[former_member764721]

Hi,

I did the simulation of posting as suggested, it is shown as expected. But, when we check in the posting under the Assigned GL Account for 4007 Wage type this employee data is not shown.

[former_member764721]

When getting into G/L account details as per screenshot attached. I can see all the other employees in the G/L but not the employee in discusision (Emp Code- 6667)

[BalaAP]

Hi, Please ensure the followng:

1) Whether live payroll is run for this employee successfully? Check with pc_payresult tcode for this employee.

2) Whether you had already run the posting for this employee? check with tcode pcp0.

If above things are checked then you need to run simulation posting only to this employee (don't run for all employees), and investigate what could be the issue.

[former_member764721]

Hi

1. Yes, the payroll ran successfully it was for the month of May 2022. Checked Pc_payresult it has the wagetype and the amount in RT.

2. Yes, posting was run already.

I'll check running the simulation posting of this particular employee and try to identify the issue

Thank you.

[BalaAP]

Hi, pls check whether this value is entered after posting (means, this is added later).

[former_member764721]

Hi,

I checked the totals in posting of that particular employee Debit and credit has a difference of 4,999 (Exact amount). And, when checking the total of overall posting its matching.

What should be the next step, like identifying where this amount is being credited?

[BalaAP]

Hi, Pls run pc00_m99_cipe in simulation and display the output log (by expanding all the symbolic a/c links) and paste it here (of this employee alone)..(also compare by running a correct employee's log).

[former_member764721]

01 02 2022 29.36 0.00 INR

Expense account 29.36 148,003.00 INR

SymAc 5000 - Employee Salaries 5.00 105,635.00 INR

CCtr 19021 5.00 105,635.00 INR

Wage Type A 1001 Basic Pay 0.00 65,500.00 INR

Wage Type A 1004 Dearness Allowance 0.00 19,650.00 INR

Wage Type A 1012 House Rent Allowance IDA 0.00 17,685.00 INR

Wage Type A 1526 Vehi Maintenance 5.00 2,800.00 INR

SymAc 5001 - Fixed Allowance 34.36 22,925.00 INR

CCtr 19021 34.36 22,925.00 INR

Wage Type A 1037 LTC/LTA 7.00 4,585.00 INR

Wage Type A 4001 Canteen Allow-Meal Vouch 7.00 4,585.00 INR

Wage Type A 4002 Wardrobe Including Wash 7.00 4,585.00 INR

Wage Type A 4003 Knowledge Upgrade 5.00 3,275.00 INR

Wage Type A 4005 Soft Furnishing 8.00 5,240.00 INR

Wage Type A 4007 Gift-in-kind / Gift Vouch 0.00 4,999.00 INR

Wage Type A 4009 Other Allowances 0.36 4,344.00- INR

SymAc 5006 - Telephone Reimbursement 0.00 500.00 INR

CCtr 19021 0.00 500.00 INR

Wage Type A 1501 Tele Reimb 0.00 500.00 INR

SymAc 5095 - NPS-Er Share 10.00- 8,515.00 INR

CCtr 19021 10.00- 8,515.00 INR

Wage Type A 2079 Er Pension Deduction 10.00- 8,515.00 INR

SymAc 5100 - PF-Er Share 0.00 8,968.00 INR

CCtr 19021 0.00 8,968.00 INR

Wage Type A /3F3 Er PF contribution 0.00 8,968.00 INR

SymAc 5101 - FPF-Er Share 0.00 1,250.00 INR

CCtr 19021 0.00 1,250.00 INR

Wage Type A /3F4 Er Pension contribution 0.00 1,250.00 INR

SymAc 5102 - GSLI - Er Contribution 0.00 210.00 INR

CCtr 19021 0.00 210.00 INR

Wage Type A 2057 GSLI Emplyr Contri 0.00 210.00 INR

Balance sheet account 0.00 148,003.00- INR

SymAc 6000 - Salaries Payable 0.00 37,184.00- INR

Wage Type A /559 Bank transfer 0.00 37,184.00- INR

SymAc 6014 - TDS Payable - Empployee wise 0.00 16,969.00- INR

Wage Type A /460 Income Tax 0.00 16,969.00- INR

SymAc 6020 - Festival Advance 0.00 1,500.00- INR

Wage Type A 79RP Repayment-FestivalAdv 0.00 1,500.00- INR

SymAc 6051 - EPF Payable - Employee wise 0.00 20,436.00- INR

Wage Type A /3F1 Ee PF contribution 0.00 10,218.00- INR

Wage Type A /3F3 Er PF contribution 0.00 8,968.00- INR

Wage Type A /3F4 Er Pension contribution 0.00 1,250.00- INR

SymAc 6052 - VPF Payable - Employee wise 0.00 50,000.00- INR

Wage Type A /3F2 Ee VPF contribution 0.00 50,000.00- INR

SymAc 6055 - RCTCS Membership - Employee wi 0.00 400.00- INR

Wage Type A 2015 Rctcs Memb (Sub) 0.00 400.00- INR

SymAc 6062 - NPS Payable - Employee wise 0.00 13,515.00- INR

Wage Type A 2078 EE Pension deduction 0.00 5,000.00- INR

Wage Type A 2079 Er Pension Deduction 0.00 8,515.00- INR

SymAc 6069 - Meal Voucher 0.00 2,200.00- INR

Wage Type A 401G Meal Voucher Deduction 0.00 2,200.00- INR

SymAc 6070 - Gift Voucher 0.00 4,999.00- INR

Wage Type A 4007 Gift-in-kind / Gift Vouch 0.00 4,999.00- INR

SymAc 6111 - GSLI-Ee Contribution-Employeew 0.00 390.00- INR

Wage Type A 2056 GSLI 0.00 390.00- INR

SymAc 6112 - GSLI-Er Contribution-Employeew 0.00 210.00- INR

Wage Type A 2057 GSLI Emplyr Contri 0.00 210.00- INR

SymAc 6126 - Benevolent-Employeewise 0.00 200.00- INR

Wage Type A 2030 R E B Scheme 0.00 200.00- INR

I have made the WT bold 4007. If that helps. Meanwhile I am comparing it with the othe employee for whom it worked.

[BalaAP]

Hi, It shows now in your log. It implies that, during mass payroll run, you had missed this employee. But now it is available, because, payroll is run sub-sequently, but not posted.

You can confirm this by running pcp0 and drill down the payroll result of mass-run and verify whether this employee is appearing.

[former_member764721]

In PCP0, Mass run payroll run employee is appearing. But, while comparing it with the correct employee I see- that this wage type is going to 2 Sym Accounts 5001 and 6070 AA type C and F respectively. For the correct employee it is being posted to both the Symbolic account. But for incorrect employee it is only getting posted to 5001 Sym account and not 6070.

In mass run payroll, this particular employee balance is not matching but when seeing total balance overall it is matching.

[BalaAP]

Hi, I don't understand why WT-4007 is added with symb.a/c 6070 (as balance sheet a/c).

Can you explain, how you are paying the gift voucher? Is it along with the salary or you are crediting separately to the employees?

[BalaAP]

Hi, I also guess, what you attached the posting detail belongs to the correct employee (attached as text format). Please attach the same for the wrong employee also.

Also, please show the symbolic account configuration of 6070 & 5000.

[former_member764721]

Gift Voucher is being credited along with salary. The posting details in Text format was the simulation run for the incorrect employee only.

[former_member764721]

Symbolic OBYG config

[BalaAP]

Hi, If your text screen (posting log) belongs to wrong employee, it is correctly posting to balance sheet symb-a/c 6070. You may have to check any org changes made to this employee during the time of actual posting. Please also check any changes in posting config done recently (by comparing QA with PRD).

[VivekPalanivel]

Mostly its nullified by another wage type with same amount but opposite sign. For ex if this is having an amount of 1000 in cr and there is another wage type with same amount as dr into the same GL account then it will be nullified and hence not show in document.

[former_member764721]

Hi,

I checked the RT there is not any other wage type in that employee's account with same amount in negative.