month to date total

[deamn]

I am trying to develope a custom payroll report for ACCPAC. I am trying to get monthy, quarterly, and year to date totals for items such as Regular Pay, Overtime Pay, etc. I have determined the Category and Detail ID's for each of the items I want shown, but don't know how to combine them to get one response. For example, Regular Pay in my system is under Category "A" and Detail ID "1". I want this shown as a line item on the report for each employee, but everytime I try a formula to derive it I get multiple responses on each employee in my system so instead of 100 responses correlating to my 100 employees I get 1210 responses with multiple lines of information on each.

 

[MalcolmW]

What version of SCR?
If you get 1210 records instead of 100, what do those extra records represent? Are they records you are not using in the report, and should filter out? If you can answer the question "Why are they there?" you can likely figure out "How do I get rid of them?". Malcolm
Remember, if it wasn't for electricity, we'd be surfing the net by candlelight.