It is not clear how to establish the employer loan if multiple summary accounts are available instead of a single summary account for the various loan types.
This note is no longer valid in Release 4.6C. If you intend to store loan results in separate wage types, proceed as described in the implementation guide (IMG) for Payroll under "Loans -> Calculation -> Store Additional Values".
Several summary accounts
========================
If multiple loan types are used, you may want to post to multiple summary accounts instead of a single summary account, for example, you may want to post short-term loan types to one summary account and all other loan types to a different summary account.
This requirement can be implemented as follows:
Define wage types /Lxx in processing class 32 in a way that they cannot be posted.
Copy cycle XLON and extend it as follows: at the end of the two branches for installment loans and annuity loans which obtained the parameter LNCLS through the VAKEY operation (>OPEC.VAKEY), an additional branch is configured containing a refinement in the LNTYP parameter using the VAKEY operation.
Use the resulting refinement to generate user wage types which will contain the amounts to be posted. Use the branch configuration to ensure that the user wage types contain the amounts to be posted to the respective summary account.
Use parameter N in operation AMT to read the technical loan wage types in the branches, and use operation ADDWT with parameter E to store it to table RT.
Example: ZERO= ANR ELIMI * AMT=N /LRPADDWTE1000
The following part was subsequently added for better understanding.
Procedure shown by means of an example:
The following example shows the entire procedure. Modify the settings depending on the respective case.
The wage types /LOP (payment accounting), /LEP (special repayment accounting), and /LRP (repayment) given in the standard system are to be posted to separate accounts for building loans (loan type 0100) and for car loans (loan type 0110).
By copying, first create new wage types 1LOP (for example) and 2LOP for wage type /LOP, which are then used for the assignment to the two different accounts. Now set processing class 32 for wage type /LOP to blank so that this wage type is no longer posted. Instead, 1LOP and 2LOP assume this task by retaining the value of /LOP in processing class 32 (this value is 3).
In the same way copy the new wage types 1LEP and 2LEP for wage type /LEP with the original value of /LEP (this value is 2) in processing class 32 and set the value of this processing class to blank for /LEP.
The same applies to wage type /LRP with copies 1LRP and 2LRP and value 4 in processing class 32.
The wage types /LOP, /LEP, and /LRP in evaluation class 1 have a specification for posting (for example, D6). Now, also wage types 1LOP, 1LEP, and 1LRP, which contain the amounts for the building loans (0100), are to be posted to this "symbolic account".
You can display the use of the symbolic accounts with report "Wage type utilization" (in menu "Human resources -> Payroll accounting -> Environment") in the part "Meaning of evaluation classes and their values".
The wage types 2LOP, 2LEP, and 2LRP should get a new specification (for example, DB) for evaluation class 1.
In Release 3.0 with the payroll IMG and "Basic settings -> Processing Classes, Evaluation Classes -> Maintain evaluation classes and their specifications", you can access the maintenance of view V_T52D3 and then, with the navigation, view V_T52D4 to maintain the specifications (in 2.2 with Table maintenance of T52D4).
Here, you can add a new specification (DB) for evaluation class 1 with the corresponding text (repaym. loan accnt. Create account 2). Afterwards, the new specification "DB" for wage types 2LOP, 2LEP, and 2LRP can be entered in evaluation class 1.
The next step deals with filling the new wage types depending on the loan type. For this purpose, copy cycle XLON to cycle XLO1 (for example). You then enter this new cycle also in the loan schema (XLON or a copy of it): P0045 XLO1 NET.
Now, the new cycle XLO1 needs to be modified so that loan types 0100 can be posted to symbolic account D6 and all other loans (including car loans) to the new symbolic account DB. Cycle XLO1 is then as follows:
D ELIMI * VAKEYLNCLS ANNUITY/INSTALMENT
A AMT=N /LIDADDWTN/LLBNEXTR INTEREST
A 1 AMT=N /LEPAMT
A 3 AMT=N /LEPSUBWTN/LEPAMT=& HELPADDWTN/LEPNEXTR
A 4 AMT= ANRTEAMT
A 6 D VAKEYLNTYP ABFRAGE DLART <===
A **** ZERO= ANR ELIMI * AMT=N /LRPADDWTE2LRPNEXTR <===
A **** 1 ZERO= ANR ELIMI * AMT=N /LEPADDWTE2LEPNEXTR <===
A **** 2 ZERO= ANR ELIMI * AMT=N /LOPADDWTE2LOP <===
A 0100 ZERO= ANR ELIMI * AMT=N /LRPADDWTE1LRPNEXTR <===
A 0100 1 ZERO= ANR ELIMI * AMT=N /LEPADDWTE1LEPNEXTR <===
A 0100 2 ZERO= ANR ELIMI * AMT=N /LOPADDWTE1LOP <===
I AMT=N /LIDSUBWTI/110NEXTR INTEREST
I 1 AMT=N /LEPAMT
I 3 AMT=N /LEPSUBWTN/LEPAMT=& HELPADDWTN/LEPNEXTR
I 4 AMT= TILBTAMT
I 6 D VAKEYLNTYP ABFRAGE DLART <===
I **** _ ZERO= ANR ELIMI * AMT=N /LRPADDWTE2LRPNEXTR <===
I **** 1 ZERO= ANR ELIMI * AMT=N /LEPADDWTE2LEPNEXTR <===
I **** 2 ZERO= ANR ELIMI * AMT=N /LOPADDWTE2LOP <===
I 0100 _ ZERO= ANR ELIMI * AMT=N /LRPADDWTE1LRPNEXTR <===
I 0100 1 ZERO= ANR ELIMI * AMT=N /LEPADDWTE1LEPNEXTR <===
I 0100 2 ZERO= ANR ELIMI * AMT=N /LOPADDWTE1LOP <===
New lines or lines to be changed are indicated with an arrow at the end of the line. In the following line 5, add "NEXTR" for annuity loans and installment loans.
Since the loan type (LNTYP) is queried in the VAKEY statement, the amount of wage type /LRP is now put into the 1LRP for loan type 0100 and into 2LRP for all other loan types (also for /LOP and /LEP). You can make this assignment according to your requirements.
As soon as the cycle is created and the changed schema is generated, you can restart the payroll driver with accounting schema (X000) and evaluation schema (X500). In the log of the evaluation schema, the payment and repayment of the building loan will then appear on the symbolic account "D6", and the car loan on "DB".
No comments:
Post a Comment