LP balances - taeemaster

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.

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.

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.

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?

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.

Ok, will do. Thank you again