Share
Report
215Hi Everyone!
I am encountering a big issue with Report Writer when trying to create a position rate table-based 'Project Billing Invoice'. I currently have an invoice that was created prior to my client switching over to Position Rate Tables, where the original invoice would roll-up all data into a single line in accordance to the position set on the employee card.
I created some DUOS fields to store account numbers associated with all positions added to any position rate tables. Therefore, if employee A submits a time sheet allocating 10 hours as a 'Technician', and another 20 hours as 'Consultant, then the invoice would display 2 lines, each with the employee ID, position (of either tech or cons), account# assigned to that position, and the rate/qty/total. The client will only be creating invoices with a single project attached.
I have reviewed the SQL calls, and it appears that it uses Dexterity to pull the position set on the employee card, and rolls up all billing data to a single line with this single position, then stores it in temp tables for use in RW. This is a huge problem.
Does anyone know of a way that this can work in RW to display all PA Billing Sub-Details (timesheet entries, positions for particular timesheet line, etc)? I am currently modifying the 'PA Billing Invoice Format - Invoice Format 1' report in RW. I have been unable to successfully link any tables in report writer as they all utilize the rolled-up temp tables. The client currently prints a "Biling Format" from the Print Billing Documents that prints 3 invoices, a summary, details, and time sheet details.
Since the current iteration of the invoices is in RW, I would love to NOT have to re-do all three invoices in Crystal reporting. Any ideas or suggestions would be greatly appreciated.
Thank you very much.
*This post is locked for comments
All responses (
Answers (
