You may create invoices from Personnel Scheduling using a Custom Setting to print an additional line item on the invoice which shows Total Hours. This additional line is added to the Invoice at the time of Invoice Print. To do this you must use the following custom setting:
| Section | Item | Value | Purpose |
|---|---|---|---|
| ARInvoicePrint | AddTotalHours | Yes | This setting is used to print the total hours for each job on that job’s detail line on invoices created from Personnel Scheduling. This additional line is added to the invoice when it is printed. |
Rules
Once the Custom Setting is in place, a new line is added to each invoice when the Invoice is printed as long as it meets the following criteria:
- The Personnel Scheduling check box must be selected in the AR Invoice (this tell the system that the invoice was created from Personnel Scheduling). This Custom Setting will not effect any other type of invoice.
- The invoice cannot be marked as Posted or Paid.
- There must be at least one item on the invoice with a quantity greater than blank or 0.
- If a line item already exists on the invoice that says Total Hours (the system will look for this verbiage), then the system will not add another line to the invoice for Total Hours and will not calculate any Total Hours quantity.
Results
The new line item is formatted as follows:
Description - Total Hours
Quantity - 1,320 (result of the calculated total hours )
Amount - $0.00
When Reprinting invoices, if a line called Total Hours already exists, no additional line is added to the invoice and recalculation of the total hours will NOT occur. If there was not a Total Hours line on the invoice, Invoice Print adds the Total Hours line and calculates the Quantity for Total Hours.
Total Hours will always have the Print Order 10 more than the greatest Print Order on any line so that the last line picks up all Hours.
Tip: If you determine that there is an invoice whose hours are not correct and you have to go back and make corrections to the invoice, delete the Total Hours line and have the system recreate it when you print it.