Invoicing Analysis (W/O)

OBJECTIVE

The invoicing analysis (W/O) report compares costs charged to work orders or projects with the revenue generated when the same work orders and projects are invoiced using Invoice Preparation (W/O) or Direct invoicing of the Enter Work orders option. Based on the settings in the invoicing project, maestro* displays an analysis for each work order or for the project as a whole.

This report includes all of the items entered in the Work Orders module as well as transactions from other maestro* modules in which the work order was identified. Only transactions (with or without work orders) related to an invoicing project are included in the report. In the Direct Invoicing option, if the Selling Qty, Unit Selling, % Discount, U.P. or Not Billable columns are modified and a sale has been transferred, columns containing the selling and profit values are not displayed. Work orders are grouped by project on the report.

 

PREREQUISITE

• Invoice Preparation (W/O) and / or Enter Work Orders

 

Steps

maestro* > Projects > Work Orders > Reports > Invoicing Analysis (W/O)

 

Generate the Invoicing Analysis (W/O) report

1. Select one or more Projects.

The ... symbol is used to select more advanced search criteria. The + symbol is used to drill down further to expand the information that can be selected.

2. Select a Date Range.

The dates in the Date Range are the posting dates of the transactions.

3. Select one or more Work Orders.

To select all work orders, check ALL.

4. Select the other choices based on specific requirements.

Field	Description
Format	Report Detail Level. Available values. Summary Displays only the total costs and revenue per work order. Detailed Displays all transactions linked to each work order and groups them by source. Detailed by Type of Item Displays all transactions linked to each work order and groups them by type of item defined in Catalogue Management.
Scope of Transactions	Available values. Only on Billable Activities Displays only transactions entered for billable project activities, depending on the billable activity range defined in Invoicing Contract (W/O). On All activities Displays transactions entered for all activities in the project, regardlessof the billable activity range defined in Invoicing Contract (W/O).
Status Selection	Available values. Only Billable transactions Display only billable transactions, whether they have already been invoiced or not. Only Billable Transactions not Invoiced yet Display only billable transactions that have not yet been invoiced. All transactions Displays all transactions, whether billable or not, and whether they have been invoiced or not. NOTE: During the processing of a CSST transaction the following warning message appears "CSST transactions will now be included in the transactions displayed and/or in the totals of the costs of the work orders."
Print a summary by item	Prints a summary by item if the box is checked.
Print one Work Order per page	Inserts a page break after each work order if the box is checked.
Include non-transferred trans.	Displays the non-transferred transactions that are included on the work order if the box is checked.
Print Summary and Documents	If the box is checked: A summary will be printed at the beginning of the report, containing a list of all the work orders that will be printed, specifying the number of documents to be printed for each. For each work order selected: The Invoicing Analysis will be printed. Additionnal relevant documents will also be printed (see note in section 5). NOTE: If you check this option, maestro* prints one work order per page.

5. Click Accept.
   The invoicing analysis report is displayed in the report viewer.

A Document icon is displayed in the report viewer in the upper left corner of each work order. The display of the icon changes depending on whether relevant documents related to the work order exist or not. Only documents linked to a document category in which the Include in Invoicing Analysis field is checked will be added to the report. You can view, add or remove a document using the options available when you click the Document Management icon. Documents added or removed in this screen will not affect documents in Document Management in the Work Order option. Changes apply only to the current report. During printing, the documents will be printed by work order in the order of the document category code. When you click the Print icon, a question is displayed on the screen. Answer Yes to print the attachments or No to print only the report. If you click the Send to all recipients icon, the documents will be included in the mass mailing.

 

See also

• Invoicing Contract W/O
• List of Work Orders to Invoice
• Catalogue Management

 

Last modification: September 20, 2024