Accpac Payroll - Paystub modification

[Year2009]

I need to modify an ACCPAC Payroll Paystub.

The Paystub looks like this

Category Desc Amount YTD

Earnings REG 833.20 2721.4
OT Hrs 150.00 250.00

Deductions RPPP 15.00 753.00
UDUES 5.00 5.00
UDUESM 40.00 40.00
CSB 58.00 890.00

Taxes INCTAX 15.33 72.65


I need to put a formula to combine both UDUES and UDUESM together. There is only 1 details on my crystal report.

Your help is highly appreciated

Thanks

 

[Madawc]

Create a formula field, something like

if {desc} in ["UDUES", "UDUESM"
then "UDU Group"
else {desc}

Also have a group total, suppress the details.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Madawc]

Sorry, that should be

if {desc} in ["UDUES", "UDUESM"]
then "UDU Group"
else {desc}

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Year2009]

Thanks for your reply. I am still having the following problem.

In the detail section, I have the following formula

IF {CPPCKD.PCATEGORY} = 1 THEN
"Earnings"
ELSE IF {CPPCKD.PCATEGORY} = 2 THEN
"Deductions"
ELSE IF {CPPCKD.PCATEGORY} = 3 THEN
"Taxes"
ELSE IF {CPPCKD.PCATEGORY} = 4 THEN
"Other"
ELSE IF {CPPCKD.PCATEGORY} = 5 THEN
"Benefits"
ELSE IF {CPPCKD.PCATEGORY} = 6 THEN
"Direct Deposit"
ELSE
"Invalid Category"

How do I modify this formula so that when the deductions = UDUES and UDUESM, then combine then together....? I also need to combine the amount together

I know you gave me the previous formula, but when I am pasting it in, it is saying "a boolean is required"

Thanks again for your quick response.

 

[Madawc]

Try doing a separate formula with my code, and putting it where you have "Deductions"

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[IanWaterman]

As UDUES and UDUESM are sub sets of Deductions you will have to add another group similar to Madawcs.

Then instead of using details summarise the the values in that group footer. Then UDUES and UDUESM will appear as UDU Group and CSB will show as it is.

Ian

 

[lbass]

You can just use formulas like this:

if {desc} in ["UDUES", "UDUESM"] then
{table.amt} //or {table.ytd}

Then insert a sum on this formula at whatever report level you want to see the summary.

-LB

 

[Year2009]

I am getting the following message when trying to print an AR invoice in Accpac. I am able to dbverfiy the report in Crystal report 11 but is not able to run it within Accpac.

I am using Accpac 5.5

"Description: Crystal Reports Error: Logon failed."

Anybody has come across such an error message..

Thanks for you help