Identify PRDISTRIB Records used in PR195 Accrual Calculations

Hi All,

I have a data warehouse that analyzes labor usage from Lawson. The detail is downloaded from Lawson's PRTIME and PRDISTRIB records. Accruals are then re-calculated at the labor detail level and several other manipulations are performed to give us several data sets that will tie back to the GL. The problem I have is correctly identifying the PRDISTRIB records that have had an accrual ratio applied. I have a methodology in place that gets me close, but since the operators can run PR195 multiple times for a pay period and do not always apply an accrual ratio for the period when it normally would have one I always end up with some differences between what I calculate and what the GL shows. My question is this...

Is there a way to identify records in PRDISTRIB that have had accruals applied to them? Is there any table that tracks them or any field that flags it? I have done a lot of research and am not getting too far. Thanks.

Find more posts tagged with

Infor Lawson Human Resources Group - Discussion

Comments

f-secchi

I've not found any flags for PR195 in any of the PR tables. Best I could do on my reports was join the paycodes to the PR195 payclass if there is one, calculate on expenses, and compare to GLTRANS. You can probably calculate the rate b/t GLTRANS and PRDISTRIB. It'll be awesome if there is a flag.

Infor CloudSuite_Field_Service Monthly_Newsletter_August-September.pdf

unknown

Thanks. I have the rate that is SUPPOSED to be applied to the last pay period of the month. The accruals I am talking about are the accruals created to estimate the labor expense for the last X days reamining in the month after the last full pay period. Theoretically (3/14) * [Wage_Amount] for all records in the last full pay period should be what is created in PR195 for the accrual that gets posted to the GLTRANS as an entry with Source Code = 'PR'. Most of the time I can tie back to that journal entry. But since our PR Dept can process several runs in the pay period not all the records get that accrual ratio applied. I was looking for a way to identify which PRDISTRIB records were used to create the PR entry in GLTRANS. I didn't see anything in any of the PR tables either, but I did manage to create a system of strored procedured in SQL Server that handled all of the PRTIME and PRDISTRIB detail except for some of the voided checks from the previous periods. The voided checks seem to reverse the initial accrual rather than have the current accrual ratio applied. I have some code in test that might handle that situation as well, but for now I tie to all 89K records in the GL Accts over 4.5 years of data with the exception of 66 records. All of those are voided checks.

It would be nice if the ratio appled for accruals was recorded in such a way that you could tie it back to the labor detail record in some fashion or if the GLT_OBJ_ ID of the PR Journal Entry was ties back tot he PW record in some way.

Copyright © 2025 Infor. All rights reserved.