PRTIME / PRDISTRIB linkage

Trying to link PRTIME and PRDISTRIB tables in a Crystal Report but am getting duplicate data on some of the records. I'm linking Company, Employee, Check_ID, and PCD_SEQ_NBR. Seems to be creating duplicate records due to OBJ_ID fields that are different on PRDISTRIB, but I don't even know what the OBJ_ID is for. Does anyone have any tricks to get having duplicate data?

Any help would be greatly appreciated!

Thanks!

Find more posts tagged with

Comments

patrycja-szymanska

What are you trying to produce by link those 2 tables, maybe there is a better way.

436.jpg

0712131256598360.doc

0904080939293831.xls

Legacy Contributor

You need to link the GLT-OBJ-ID field between the two tables. Every posted transaction to GL has a unique GLT-OBJ-ID.

436.jpg

0712131256598360.doc

0904080939293831.xls

pbuckley

I'm trying to pull TR date detail but also show the Acct-Unit it posted to in GL.

I tried linking the GLT-OBJ-ID but then didn't get any Acct-Unit information.

436.jpg

0712131256598360.doc

0904080939293831.xls

Legacy Contributor

You can get the expense accounting unit and account from PRTIME without going to PRDISTRIB. The fields are DST-ACCT-UNIT, DST-ACCOUNT, and DST-SUB-ACCT.

436.jpg

0712131256598360.doc

0904080939293831.xls

pbuckley

Think I figured it out. It's duplicating due to Shift Differential account on the PRDISTRIB (that isn't separated on the PRTIME). I created formulas to eliminate duplicate data due to shift diff account number.

Thanks

436.jpg

0712131256598360.doc

0904080939293831.xls

Legacy Contributor

What are you getting out of PRDISTRIB that you cannot get out og PRTIME?

436.jpg

0712131256598360.doc

0904080939293831.xls

pbuckley

In response to Kathaleen's posting, we are needing to use the PRDISTRIB instead of the PRTIME because of salary split information that doesn't appear on PRTIME table.

436.jpg

0712131256598360.doc

0904080939293831.xls

pbuckley

Hi all ~ ran into another snag trying to link the PRTIME and PRDISTRIB tables and was wondering if anyone knew a solution. They basically want to be able to see day-by-day hours but list the Acct_Units that were charged (using Pr23 salary splits) for each day. This becomes a problem since PRTIME hours are day-by-day but PRDISTRIB is summarized.

The dilemna is that PRTIME will show 10 hours to home AU on day 1 and 5 hour on day 2. The PRDISTRIB will show it split, for example PR23 might be 75% home AU and 25% to "b" AU...such as 11.25 hours to home AU and 3.75 hours to "b" AU.

Is there any report or means to separate day-by-day to show...7.5 hours to home AU and 2.50 hours to "b" AU on day 1, and 3.75 hours to home AU and 1.25 hours to "b" AU on day 2?

(Maybe I'm asking too for much...)

436.jpg

0712131256598360.doc

0904080939293831.xls

sriman-shivakoti

I don't know that you can get it day by day. I used to have a report that could pull it that way but requred joining to the records on the PR23 which was close but not 100% since changes may have been made.

We are pulling PRDISTRIB now since it will record by period end but I recently found a little bug when payroll adjustments were processed and the same pay code was used in multiple pay ending dates. I plan on opening a case regarding this as soon as I can.

436.jpg

0712131256598360.doc

0904080939293831.xls

Copyright © 2025 Infor. All rights reserved.