creating withholding report

[wdean52]

We are using Cougar Mountain stand alone payroll.__We pay 700+ employees, therefore we break down our payroll into batches.____I^m needing to create one report with all the data my general ledger person needs: Gross, taxes, other withholding (this is our problem child), net, ch#, pay date, emply name, etc.____After the batches are posted the other withholding data is found in a file ^PRLINUM^. As a matter of fact the whole years transaction are in this file. Therefore we have to define file #, pay date & deduction code to get accurate data to the report.____In the ^PRLINUM^ file we have:__ PRLINUM-C; column for employee file # __ PRLIDATE-D; column for pay date__ PRLIBENDED-C; column for deduction codes__ PRLIPREG-N; column for deduction amounts ($)____We are trying to do this with a calculation and have not be successful.____Our Company Code; TIL____Our Master Table; TILPRON____One of our deductions "code"; RE____Our Relations; approx(TILPRPON--}PROPNUN,TILPRMSD:FULL,blank)__ scan(TILPROPN--}PROPNUN,TILPRLIN:PRLINUM,full,blank)__ __In the above relation string there is a bold bar in front of both of the words blank that I could not dublicate with my key board.______We are using ^IIF^ function for our calculation expression.__IIF(condition, true value, false value)____Our Calculation; IIF((PRLINUM=PROPNUM AND PRLIDATE=PROPDATE AND PRLIBENDED="RE"),PRLIPREG,0)____We have tested this calculation with and without the second set of () and both verfiy as a good expression, but produce the same result "0.00".________We are getting all 0.00 in our RE data column.____All of our other data being being brought into this report is good.____Bill____

[kfleming]

The relation to TILPRMSD should be an exact match rather than approximate.____The relation to TILPRLIN should be an a partial match of 20 characters since the linking field PROPNUM will only match the first 20 character of the PRLINUM index tag whose expression is:__UPPER(PRLINUM) + DTOS(PRLIDATE) + UPPER(PRLICHECK) + STR(PRLIUNIQ) + UPPER(PRLITYPE) + STR(PRLIDETAIL) + UPPER(PRLIBENDED)____See if these changes help.____Kathleen__R&R Support____(Also you should post general questions to the R&R Users forum rather that the RattleRR forum in order to be seen by the widest audience)