FINANCE BPP

Updated 11/17/14 Page 1 of 19

Transaction

ZFIR018

11/17/14

Financial Report for Payroll Posting

See Change Record at end of document for updates to this BPP.

Business Process Procedure Overview:

As part of the validation process for posting payroll, the agency should run ZFIR018. The summary

version can be used to verify total dollar amount on the report with the CMCS amount. The detail version

can be used to see the detail account, wage types, and cost distribution for each employee. This report

should be run after payroll post to General Ledger. Variants have been set up to use when running the

report. These variants are in the format of :

/090327 CMCS REQS POSTED 03 27 09 A X 01342656 03/30/2009

This includes the payroll runs for CMCS posting date of March 27, 2009.

/0903MM TOTAL PAYROLL POSTINGS 03 2009

This includes all payroll runs for month of March 2009. Medical is excluded.

/091103 CMCS M REQS POSTED 11 03 09 MEDICAL

This includes the medical expenditures for the October payroll which post on November 3,

2009.

The output file that is created can be modified. The following BPP will show how to make changes. It is

also possible to save the file as a spreadsheet.

Access Transaction:

Via Transaction Code: ZFIR018

Title: Financial Report for Payroll Posting Transaction: ZFIR018

Updated 11/17/14 Page 2 of 19

Procedure

1. Update the following field:

Field Name Description Values

Command White alphanumeric box in upper left

corner used to input transaction

codes

Enter value in Command.

Example: ZFIR018

2. Click the Enter button.

Title: Financial Report for Payroll Posting Transaction: ZFIR018

Updated 11/17/14 Page 3 of 19

Information

You may want to enter this transaction code in your Favorites folder.

From the menu at the top of the screen, choose Favorites >

Insert Transaction.

Type in ZFIR018.

Click Enter.

To see the transaction code displayed in front of the link in your

favorites, from the menu at the top of the screen:

Choose Extras > Settings.

Place a check next to Display Technical Names.

Click Enter.

3. Click the Get Variant (Shift+F5) button.

Title: Financial Report for Payroll Posting Transaction: ZFIR018

Updated 11/17/14 Page 4 of 19

4. Click the Delete button.

5. Click the Execute (F8) button.

Title: Financial Report for Payroll Posting Transaction: ZFIR018

Updated 11/17/14 Page 5 of 19

6. Click the Variant name column.

NOTE: Select the variant to match the date you want to verify. The format is /Year Month Day.

The monthly variants do not include medical expenses because they post in the next month. There

is a special variant created for the medical run.

/0903MM TOTAL TOTAL PAYROLL POSTINGS 03 2009

This includes all payroll runs for month of March 2009. Medical is excluded.

/091103 CMCS M REQS POSTED 11 03 09 MEDICAL

This includes the medical expenditures for the October payroll which post on

November 3, 2009.

7. Click the Choose (F2) button.

Title: Financial Report for Payroll Posting Transaction: ZFIR018

Updated 11/17/14 Page 6 of 19

8. Update the following field:

Field Name Description Values

Business area Code identifying the organizational

unit within the company for which

balance sheets and income

statements are prepared

Enter value in Business

Area.

Example:4600

NOTE: Enter your business area.

Title: Financial Report for Payroll Posting Transaction: ZFIR018

Updated 11/17/14 Page 7 of 19

9. Click the Exclude Single Values (5) tab button.

NOTE: Look at the exclude list for the accounts that will not be displayed in this run of the report.

10. Click the Copy (Enter) button.

Title: Financial Report for Payroll Posting Transaction: ZFIR018

Updated 11/17/14 Page 8 of 19

11. Update the following field:

Field Name Description Values

Fund Budget funds are program numbers

mandated by the Office of State

Budget and Management

Enter value in Fund.

Example: 46

NOTE: Enter your agency identifier followed by an asterick (*). This is a wildcard search and all

of your agency funds will be selected. This will also eliminate the liability accounts in the report

which are not passed to NCAS.

Title: Financial Report for Payroll Posting Transaction: ZFIR018

Updated 11/17/14 Page 9 of 19

12. Click the Display Variant matchcode.

13. Click .

This layout is the normal one used when the variants are created. You can create your own layout

or use another.

Title: Financial Report for Payroll Posting Transaction: ZFIR018

Updated 11/17/14 Page 10 of 19

14. Click the Execute (F8) button.

Title: Financial Report for Payroll Posting Transaction: ZFIR018

Updated 11/17/14 Page 11 of 19

15. Select the Pers.No. column.

16. Click the Set Filter (Ctrl + F5) button.

Title: Financial Report for Payroll Posting Transaction: ZFIR018

Updated 11/17/14 Page 12 of 19

17. Click the Personnel Number matchcode.

18. Click .

19. Click the Copy (Enter) button.

Title: Financial Report for Payroll Posting Transaction: ZFIR018

Updated 11/17/14 Page 13 of 19

20. Click the Execute (F8) button.

This technique can be used on any column. Filter out all data but a specific item. In this example,

we are looking for all the data related to this employee. You could have also entered the employee

on the first selection screen; but often you will want to use this method to isolate information for

researching a problem.

21. Click the Delete Filter (Ctrl + Shift + F2) button.

You want to delete the filter to show all employees again.

Title: Financial Report for Payroll Posting Transaction: ZFIR018

Updated 11/17/14 Page 14 of 19

22. Click the Account Number with Text column.

23. Update the following field:

Field Name Description Values

Account Number

with Text

Classifies revenues, expenditures,

and balance sheet information

Enter value in Column

Account Number with

Text.

Example:

SAPGUI.GridViewCtrl.1

24. Click the Account Number with Text column.

Title: Financial Report for Payroll Posting Transaction: ZFIR018

Updated 11/17/14 Page 15 of 19

25. Update the following field:

Field Name Description Values

Account Number

with Text

Classifies revenues, expenditures,

and balance sheet information

Enter value in Column

Account Number with

Text.

Example: 50121000 SPA-

REGULAR SAL

26. Click the Change Layout… (Ctrl + F8) button.

27. Click the Column Name column.

28. Click the Column Name column.

29. Click Show selected fields button.

30. Click the Transfer (Enter) button.

Title: Financial Report for Payroll Posting Transaction: ZFIR018

Updated 11/17/14 Page 16 of 19

31. Select the Fund column.

32. Click the Set Filter (Ctrl + F5) button.

33. Click the Fund matchcode.

Title: Financial Report for Payroll Posting Transaction: ZFIR018

Updated 11/17/14 Page 17 of 19

34. Click .

You would select the default fund value. This will allow you to identify employees that do not have

cost distribution set up correctly on the position or IT0027.

35. Click the Copy (Enter) button.

36. Click the Execute (Enter) button.

Title: Financial Report for Payroll Posting Transaction: ZFIR018

Updated 11/17/14 Page 18 of 19

37. Click the Delete Filter (Ctrl + Shift + F2) button.

38. Click List >> Export >> Spreadsheet....

39. Click the Continue (Enter) button.

Title: Financial Report for Payroll Posting Transaction: ZFIR018

Updated 11/17/14 Page 19 of 19

40. Update the following fields:

Field Name Description Values

File name Descriptive value for information to

be stored (for future reference)

Enter value in File name.

Example:

Test_Oct2009.xls

41. Click the Save button.

The system task is complete!

Change Record

Change Date: 11/12/14 Changed by: M Kendall

Changes: New format

New screen captures

New descriptions for Field Names