Skip to Content
0
Former Member
Apr 27, 2010 at 07:54 AM

Alternative Periods in Report Painter

39 Views

I'm trying to create a report painter report for labour efficiency, it compares actual labour confirmations to a statistical key figure for payroll hours.

I have the basic elements, but my problem is this. We currently run our accounts on a calendar month basis, so we have 12 periods in FI. This report is required on a weekly basis for each weeks payroll. Is it possibly to report totals for a given week, when that is not your accounting period?

I can't see any obvious characterisics that will give me a weekly total of each figure, but I'm wondering if it os possible to define alternative periods (e.g. 52/53 week years ending each sunday for a period, and bring that in as a row characteristic).

Has anybody managed to achieve anything like this, and if so how?

Postings can occur anytime in the week, so I don't think posting date is an option, but may be if you can specify ranges that can be logically extrapelated in the report (i.e. Mon-Sun).

Thanks for any advice on this

Graham