Excuse me, who knows the salary management in Kingdee Software Professional Edition-formula setting, and it is best to give an example.

In formula setting, salary calculation formula can be established according to the salary system of the enterprise. Before creating a formula, you should define a salary item in project management so that you can refer to it when defining the formula. Otherwise, when checking the formula, the system will prompt "salary item or variable is undefined".

When setting formulas, commonly used statements are as follows:

Alarm statement

Judgment statement

Annotation statement

Truncated statement

Integer statement

Date function

Data statistics function

The function and usage of each statement are explained below.

Alarm statement

Function: generate alarm prompt information when calculating formula.

Usage:

Select, and "Alarm" will appear in the formula editor, followed by a space. Enter the alarm information in quotation marks ""; You can also directly enter the "alarm" statement in the editing interface, and enter the alarm information after the space. Similarly, alarm messages need quotation marks. The format is as follows:

Alarm "alarm information"

Or warning "alarm message"

For example, in the calculation formula interface, enter an alarm that "sick leave days cannot exceed monthly working days"; Or: early warning "sick days cannot exceed monthly working days". When this statement is executed, the alarm message "Sick days cannot exceed monthly working days" will pop up.

Judgment statement

Function: judge and execute according to conditions, either in Chinese or English.

Usage:

If ... then ... if it's over

(If ... and then ... ENDIF)

If ... then ... otherwise ... if it's over.

(if ... then ... other ... ENDIF)

If ... then ... otherwise, if ... then ... if it's over.

(If ... then ... Ersev ... then ... ENDIF).

The following example illustrates the application of the judgment statement:

1, alarm setting:

If the number of sick days is >; workday

Then call the police "sick leave days cannot be greater than working days"

If completed

2. The calculation formula setting of quarterly award:

If the month = 2 or 5 or 8 or 1 1.

Quarterly Award = 120.

Otherwise, quarterly prize = 0.

If completed

3, income tax calculation formula settings:

Income excluding tax = salary payable-1400

If the income excluding tax is less than = 500, then

Tax rate = 0.05 Deduction = 0

Otherwise, if the income excluding tax is less than = 2000, then

Tax rate = 0. 10 Deduction = 25

Otherwise, if the income excluding tax is less than = 5000, then

Tax rate = 0. 15 deduction = 125

Otherwise, if the income excluding tax is less than = 20000, then

Tax rate = 0.20 Deduction = 375

Otherwise, if the income excluding tax is < = 40000, then

Tax rate = 0.25 Deduction = 1375

Otherwise, if the income excluding tax is < = 60000, then

Tax rate = 0.30 Deduction = 3375

Otherwise, if the income excluding tax is less than = 80000,

Tax rate = 0.35 Deduction = 6375

Otherwise, if the income excluding tax is less than = 100000,

Tax rate = 0.40 Deduction = 10375

otherwise

Tax rate = 0.45 Deduction = 15375

If completed

If income excluding tax < = 0, then

Income tax = 0

otherwise

Taxable income = (excluding tax income-deduction) /( 1- tax rate)

Income tax = taxable income × tax rate-deduction

If completed

Annotation statement

Function: Annotate the content of this line in the formula, and its content does not participate in calculation, but only prompts the relevant content in the formula.

Usage://Annotate the content

For example://month workday = 23.5

Warm reminder: If the statements in the formula need to participate in calculation or judgment, you can't use comments//.

Truncated statement

Function: take the integer part of the numeric content. Two truncated statements are provided in the software: FIX and FIXX.

Usage:

1, repair ()

Truncated (number) or fixed (number)

Example: Truncation (9.8) = 9

FIX(9.8) = 9

2、FIXX()

FIXX (number, n)

Where: n-is an integer that specifies the starting position of rounding. This position is based on the decimal point, which is negative before the decimal point and positive after the decimal point.

Example: In the following example, if the value of x is 2634.6874, the formula for taking two decimal places is:

FIXX(X，2)=267634.68

Then the formula for taking the first two decimal places is:

FIXX(X，-2)= 267600.00

Integer statement

Function: Rounding numbers. Kingdee software provides two integer statements: ROUND and ROUNDX.

Usage:

1、ROUND()

Round (a number) or round (a number)

For example: Round (9.8) = 10.

ROUND(9.8) = 10

2、ROUNDX()

ROUNDX (number, n)

Where: n-is an integer that specifies the starting position of rounding. This position is based on the decimal point, which is negative before the decimal point and positive after the decimal point.

For example, if the value of x is 2634.6874, the formula for rounding to two decimal places is:

ROUNDX(X，2)=267634.69

Then the formula for taking the first two decimal places is:

ROUNDX(X，-2)=267600.00

Warm reminder: If the calculation result may exceed two decimal places, the user must use the ROUNDX function to modify it to ensure that there will be no tail difference. If the calculated result of the formula "overtime pay = basic salary /22.5* overtime days" may have salary data with more than two decimal places, users must modify the formula to the format of "overtime pay =ROUNDX (basic salary /22.5* overtime days, 2)" to ensure that the two decimal places of the calculated result remain unchanged.

Date function

The date functions provided by the system are as follows:

1, SetWorkDay: used to set which workdays are in a week (5 days by default), such as: SetWorkDay( 1, 2,3,4), which means 1-4 is a workday. Where the parameter cannot be greater than 7.

2. Working days: used to obtain the working days in a given time period, for example, working days = working days (#1999/1#, Curdate), which means that the work from the date 1999+ 1 has been calculated.

3. Days: used to obtain all the days in a given time period. Usage is the same as working days.

4.GetYear: the year when the date parameter is obtained, for example, year = GetYear (employment date), which indicates the year when the employment date is calculated.

5.GetMonth: get the month of the date parameter. Usage is the same as GetYear.

6.GetDay: the date when the date parameter is obtained. Usage is the same as GetYear.

7. Get the system date of the SQL database server.

Data statistics function

MIN ("basic salary", n), MAX ("basic salary", n), SUM ("basic salary", n), AVG ("basic salary", n): a statistical function for finding the maximum, minimum, sum and average of current salary items; Where n can only be 0 and 1, where 0 means to count the current salary items of all authorized employees in the current salary category and current paying period; 1 means to count the current salary items of all employees with permission under the current salary entry scheme under the current salary category. For example, if the minimum basic salary is 100, then min ("basic salary", 0)= 100.

Warm reminder: For these functions, salary items must be enclosed in double quotation marks as parameters, otherwise the correct calculation results cannot be obtained, and other function parameters do not need to be set like this.

2.COUNT(n): Calculate the number of people participating in the statistics; N can only be 0 and 1, where 0 means to count the current salary items of all authorized employees in the current salary category and current paying period; 1 means to count the current salary items of all employees with permission under the current salary entry scheme under the current salary category.

3. Power (salary item, n) and extraction (salary item, n): perform power sum root operation on the current salary item; N is a positive integer, that is, n>= 1. For example: basic salary = 100, then Power (basic salary, 2) =10000; Withdrawal (basic salary, 2)= 10.

New formula

The data items involved in the new formula are:

Data item

make it clear

Required (Yes/No)

project

Wage items involved in wage calculation

be

Project value

Contents corresponding to salary items

be

situation

Conditional statements required for setting wage calculation formula

be

operational character

Operation symbol for wage calculation

be

Detailed operation steps are as follows:

brick by brick

describe

Is it necessary (Yes/No)

first step

Select salary management;

be

Second step

Select formula setting to open the salary accounting item setting interface;

be

Third step

Click Add to activate the option;

be

Fourth step

Select an item, item value, operator, condition or function in the "Calculation Method" edit box, and write a salary calculation formula;

be

Step five

Click Formula Check, and the system will automatically check the correctness of the formula to see if there are grammatical errors. If there is an error, you can't save it until debugging is correct. Or click Save directly, and the system will directly check the formula and save it after the grammar of the formula is correct; Click < b > Cancel to discard the edited contents of the formula;

be

Step 6

Click OK or Cancel at the bottom of the salary accounting item setting interface to exit the salary accounting item setting interface; If you do this before saving the edited information, the system will prompt "Hello, you haven't saved the data. Are you sure you want to quit? " Click [OK] to exit directly without saving, and click [Cancel] to give up the exit operation.

be

Import formula

You can use the salary formula import function to import other salary formulas of a single category into the current salary category. Detailed operation steps are as follows:

brick by brick

describe

Is it necessary (Yes/No)

first step

Select salary management;

be

Second step

Select formula setting to open the formula setting interface;

be

Third step

Click Import to open the scheme import page;

be

Fourth step

In the < b > Select Salary Category node, select the salary category to import the filtering scheme from the drop-down list, and the currently logged-in user can only select the salary category with permission;

be

Step five

In the Select Formula to Import node, all formulas under the selected salary category will be listed in the interface. Select the salary formula to be imported into the current category, and click Import to import the selected salary formula into the current salary category for use;

Step five

If you want to import all salary formulas under the selected category, click Select All; If you want to clear the selected content, click Clear All;

be

Step 6

Click Cancel to cancel the operation of importing salary formula.

be

Modify formula

brick by brick

describe

Is it necessary (Yes/No)

first step

Select salary management;

be

Second step

Select formula setting to open the salary accounting item setting interface;

be

Third step

At, select the formula name to modify from the drop-down list box;

be

Fourth step

Click Edit to activate the option;

Step five

In the Calculation Method node, select items, item values, operators, functions and conditions in the edit box to modify the salary calculation formula;

be

Step 6

Click Formula Check, and the system will automatically check whether there are grammatical errors in the formula. If there is an error, you can't save it until debugging is correct. Or click Save directly, and the system will directly check the formula and save it after the grammar is correct;

be

Step 7

Click OK to exit the salary accounting item setting interface.

be

Delete formula

Detailed operation steps:

brick by brick

describe

Is it necessary (Yes/No)

first step

Select salary management;

be

Second step

Select formula setting to open the salary accounting item setting interface;

be

Third step

At, select the formula name to delete from the drop-down list box;

be

Fourth step

Click Delete, and you will be prompted whether to delete the formula [××] and related attributes;

be

Step five

Click OK to delete, and click Cancel to cancel the deletion;

be

Step 6

Click OK to exit the Salary Accounting Item Setting interface.

be