Earnings % Distribution F/M (PRF120)

This program allows the user of the FACTS system to create and maintain records in the earnings % distribution file.

In some cases, an employee may divide his working hours between departments, thereby requiring more than one general ledger account number for earnings distribution. In those and other appropriate cases, this program is used to record the average percent of earnings (or time) to be distributed to each account number. During the GL distribution report of the Check Register, total earnings are distributed according to the percentages in this file.

The user determines if the GL Distribution Report and/or earnings % distribution features are utilized through flags set through the PR static control record.

Example: An employee is assigned to the following earnings GL posting table:

*.

GL Table 100

 

 

2.

Desc. Administrative

 

 

3.

Reg

570-00-00

Salaries-Regular

4.

Sick

571-00-00

Salaries-Sick

5.

Vac

572-00-00

Salaries-Vacation

6.

Hol

573-00-00

Salaries-Holiday

7.

Dum1

570-00-00

Salaries-Regular

8.

Dum2

570-00-00

Salaries-Regular

9.

Comm

574-00-00

Salaries-Consulting

10.

Comm

575-00-00

Salaries-Commission

11.

Not used

 

 

12.

Not used

 

 

13.

Not used

 

 

14.

Not used

 

 

The employee earns the following:

Regular   $1000.00

Vacation    1000.00

Commission   500.00

    $2500.00

If the Use Earnings Distribution flag is set to N, the system uses the GL table to distribute the earnings as follows:

       Debit

570-00-00 Salaries-Regular  1000.00

572-00-00 Salaries-Vacation  1000.00

575-00-00 Salaries-Commission    500.00

If the Use Earnings Distribution flag is set to Y, and there is an earning % distribution record set up for the employee in the pay cycle, the system uses the earnings % distribution from the Earnings % Distribution F/M program. If the earnings % distribution is set up as follows:

*.

Employee

E100 Steven S. Invencent

 

*.

Pay Cycle

 

02 Biweekly

 

G/L #

Description

Percent

3.

581-00-01

Salaries-Branch 1

50.00%

4.

581-00-02

Salaries-Branch 2

50.00%

5.

 

 

 

6.

 

 

 

7.

 

 

 

8.

 

 

 

9.

 

 

 

10.

 

 

 

11.

 

 

 

12.

 

 

 

 

 

 

100.00%

The system distributes the earnings as follows:

      Debit

581-00 -02Salaries-Branch 1  1250.00

581-00-02 Salaries-Branch 2  1250.00

Use the following fields to create an earnings % distribution record:

1. Employee

Enter a valid employee number.

2. Pay Cycle

Enter the pay cycle (up to 2 characters). The entry must be a valid pay cycle code. F2 allows a search.

3. GL Account Number

Enter general ledger account number to be used for earnings distribution. The entry must be a valid GL account number. Up to 10 general ledger account numbers may be entered along with their percentages. F2 allows a search.

4. Percent of Total

For each GL account number entered, field the % of total earnings to be distributed to that account (up to 99.99). F3 ends fields. Enter (CR) initially defaults to 0.

The sum of percents must equal 100% to exit the program.