02-24-2006 11:16 PM
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 Im 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
02-25-2006 4:25 AM
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.
02-25-2006 4:25 AM
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.
02-27-2006 6:12 PM
Thanks Amit ....
Any other suggestion/input guys ..!!!
Thanks
Message was edited by: Saquib Khan
06-15-2007 3:18 PM
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!