Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Integration / Customization
S3 Customization/Development
LP balances - taeemaster
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Wayne
Past 24 Hours:
0
Prev. 24 Hours:
1
Overall:
5120
People Online:
Visitors:
209
Members:
0
Total:
209
Online Now:
New Topics
Lawson S3 Financials
PO Matched Dollars and Matched Quantity
5/10/2024 6:51 PM
Can anyone share the Lawson calculation to determi
S3 Customization/Development
COBOL CSV file
5/10/2024 2:36 PM
We have a custom Cobol program ZU200 that creates
S3 Systems Administration
Using MFA for Lawson S3 Access
5/8/2024 1:23 PM
Does anyone use Multi Factor Authentication when u
Lawson Landmark
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
IPA/ProcessFlow
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1357
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
S3 Customization/Development
LP balances - taeemaster
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Chesca
Veteran Member
Posts: 490
8/9/2013 3:22 PM
I am writing a custom program to apply caps to the available balance after payroll close. The program is updating the balances but I jus realized TAEMPTRANS might have to be updated as well. How can I find out what other tables might have to be updated if updating balances in taeemaster?
Employee Mastr
TAEEMASTER
Required
TTR-COMPANY -> TEM-COMPANY
TTR-EMPLOYEE -> TEM-EMPLOYEE
TTR-PLAN -> TEM-PLAN
TTR-EMPLOYEE-GROUP -> TEM-EMPLOYEE-GROUP
TTR-POSITION -> TEM-POSITION
jaherb
Veteran Member
Posts: 164
8/9/2013 5:15 PM
you could do it programmatically, however I would probably generate manual adjustment transactions (LP70) to process and let the system take care of what else it need to do. This would give you better auditability of the transactions.
On another note, why isn't your LP plans applying the caps? That would be the best way to go.
Chesca
Veteran Member
Posts: 490
8/9/2013 5:32 PM
Thank you for your response.
We are actually using a library routine LPCUSTOMPD to calculate accruals based on 70% hours worked and cycle based as well. It's complex. I believe we couldn’t use the LP Plans applying the caps because the timing of when the cap is applied by the system. Because of the user exit, I think it was applying the cap prior to looking at the accrual and the usage in the user exit. We had tested it and found it did not work correctly.
APS-D
Posts: 3
8/12/2013 1:37 AM
Jaherb is correct. You may want to use LP70 to generate your adjustment transaction.
Or you can write a batch program to update TAEMPTRANS. Let your LPCUSTOMPD compute accruals per your cycle based calc. Then batch program will kick in somewhere before LP140 and write an off-setting transaction (difference between running total for the plan and the limit). Be sure to use the correct trans type, status etc. If you want the overage to go to a seperate bucket, you may have to write a corresponding (in) transaction for that plan as well.
LP140 will then kick in, update the TAEEMASTER and keep the balance (LP31) in sync with your TAEMPTRANS (LP64.3).
As an example, lets say SICK plan has a 400 hour limit
Employee ABC for the pay-period ending has the following numbers -
Let's say - the beginning balance from 7/31 = 398 hours
8/12 hours used = -2 - running total 396 (from standard time processing)
8/15 hours accrued = 4.8 - running total 400.8 (this is standard time procesing with LPCUSTOMPD I assume)
8/15 hours lost = -0.8 - running total 400 (this transaction will be written by your new batch program)
LP140 will update master balances and your LP31 will reflect the correct balances to go with your transactions.
Chesca
Veteran Member
Posts: 490
8/13/2013 11:57 AM
Thank you both for your input, it's greatly appeciated. Actually LPCUSTOMPD is called by LP140 to calculate accruals and the balances at this point are zero until LP197 is run to close transactions. So the new batch program would have to kick in after and to update the balances (TAEEMASTER, TAEMPTRANS, TATRANSUM). So the beginning balance = 400.8. I will apply the caps and the new balance should be 400. The hours lost = 0.8 should go to a separate bucket, where should hours lost be stored?
APS-D
Posts: 3
8/13/2013 7:43 PM
You can create a plan called OVERAGE and enroll all active employees in it. And, let hours lost go to the overage bucket. The overage plan in LP64.3 will reflect trasactions for hours lost from each plan that go over the limit.
Chesca
Veteran Member
Posts: 490
8/15/2013 10:51 AM
Ok, will do. Thank you again
You are not authorized to post a reply.