Customer invoices

I have a client that I would like to move away from QuickBooks (so I can completely break away from all things Intuit/QuickBooks). The client is a temporary staffing agency, with about 150 employees, approximately 25 "jobs/positions", and about 25 customers. I am not sure if Sage 50 can create the invoices this client needs.

I use the weekly time sheet feature in Sage 50 to record the hours I work (which shows the client name, the dates and hours worked, and the "job/position" performed. I have never created an invoice for my clients using this time sheet information, so I don't know how the invoices work with regard to showing the information my client needs. It appears that all the information is shown on the time sheet for each client (when I enter my time into the time sheet for my company).

My client needs the customer invoice to show the following information (in the format as shown below):

The first column is the Description field which shows the employee's name;

The second column is the "Job/position" field, which shows the position the employee worked; If an employee worked at a customer where "Distance" is also recorded for the employee the two lines are shown together (line 1 position 1, line 2 position 2 for each employee)

The third column is the "Date" field, which shows the date the employee worked;

The fourth column shows the hours worked for the specific date worked by the employee;

The fifth column shows the billing rate; and

The sixth column shows the total amount (the billing rate times the number of hours).

On some customer invoices, the last line on the invoice might be a credit, which needs to show the same information as above, with a negative total amount (sometimes, an employee might be a new employee and some of the employees hours might be "free training", thus the credit). I'm not sure how to enter this type of information into the employee's weekly time sheet. In QuickBooks, I simply add an additional line in the employee's time sheet, showing the hours worked, etc., and when the information is pulled over to the actual invoice, I change the billing rate to a negative number so it creates a "credit" on the customer invoice.

Some of this clients customers require separate invoices based on the specific positions employees worked. Is it possible to select which "positions" to include when creating customer invoices in Sage 50 so that multiple invoices can be created for the same customer based on the positions worked?

This client specializes in the food service area, so some of the customers need invoices that show FOH (Front of House), BOH (Back of Hous), and/or special events (banquets, etc.).