payroll parallel reconciliation with external non-SAP System

[former_member181966]

Hi folks,

Did any one of you work on "payroll parallel reconciliation” project . We have data coming through SAP "payroll" results as well as from an external system. We have some wage types, schemas and some results tables in SAP payroll out put, they also have something like wage types and payroll results in external system. What I’m thinking that we can download the payroll result and write some macros in excel sheet or do Vlookup. Other approach is to upload external system data in to Sap and validate , or check what every condition are there .

What else can we do? Please give your inputs/suggestions.

Thanks

Message was edited by: Saquib Khan

[Former Member]

Hi saquib,

1. I suppose, apart from compareison of

sap figures <-------> external software figures,

, there is no other motive / purpose.

2. There are 2 important things :

a) No need to validate thru macro

or paralllel online comparison.

(don't go for such approach, as it may

hinder sap normal business process)

b) after payroll is processed in both systems,

only after that,

comparison should be done.

3. Now the question comes, where should the

validation be done ?

a) sap

b) external software

c) excel

d) others.

4. Doing in excel and checking each figure

can be done, provided we know how to do

and we are expert at it.

5. Other thing is,

a) make y table for uploading data of external system

(simple y table with wage type, amount, period.

b) make a small z program to upload

the data,

do the comparison, one by one.

c) if required, the program can list

out the variances.

6. I personally feel, this shold be the

best approach.

(This comparison program can be developed

in external software also.

However, to download sap data

we once again have to create a small z program.,

so why not, make one z program, once and for all )

regards,

amit m.

[former_member181966]

Thanks Amit ....

Any other suggestion/input guys ..!!!

Thanks

Message was edited by: Saquib Khan

[Former Member]

Well i have no suggestions just questions, there is another systemn which does the payroll for this organisation, and i would like to know how to post into SAP Payroll tables and fields , so that the payroll is captured in SAP!