Open the Service Invoice Statistics window.

Specifies statistical information about the contents of the posted service invoice. To open the window, from the Posted Service Invoice window, on the Related Information menu, point to Invoice, and then click Statistics.

The window consists of two parts, the header and the lines. The header includes two FastTabs: General and Customer. These FastTabs show information such as quantity, amount, VAT, cost, profit and customer credit limit. The amounts in the window are expressed in the currency of the service document unless otherwise indicated.

The fields on the General FastTab display the following information:

Field Description

Amount

This field shows the net amount of all the lines in the posted service invoice. This amount does not include VAT or any invoice discount but does include line discounts.

Inv. Discount Amount

This field shows the invoice discount amount for the entire service invoice. If there is a check mark in the Calc. Inv. Discount field in the Sales & Receivables Setup window, the discount was calculated automatically. Otherwise, it is calculated when you click Actions, point to Functions, and then click Calculate Invoice Discount before posting the invoice.

Total

This field shows the total net amount less any invoice discount amount for the posted service invoice. The amount does not include VAT.

% VAT or

VAT Amount

This field shows the total VAT amount on the posted service invoice.

Total Incl. VAT

This field shows the total amount, including VAT, that has been posted as invoiced to the customer's account.

Sales (LCY)

This field shows the figure in the Total field above converted to LCY.

Original Cost (LCY)

This field shows the total cost, in LCY, of the G/L account entries, costs, items and/or resources in the posted service invoice. The cost was calculated as a product of unit cost (in LCY) multiplied by quantity of the relevant items, resources and/or costs on the posted invoice.

Adjusted Cost (LCY)

This field shows the total cost, in LCY, of the items in the posted service invoice, adjusted for any changes in the original costs of these items. A zero value in this field indicates that there were no value entries to calculate, possibly because of data compression or because the adjustment batch job (Adjust Cost - Item Entries) has not yet been run.

Cost Adjmt. Amount (LCY)

This field shows the difference between the original cost and the total adjusted cost of the items in the posted service invoice. A zero value in this field indicates one of the following: either the original cost is equal to the adjusted cost, or there were no entries to calculate, possibly because of data compression.

Original Profit (LCY)

This field shows the amount of profit on the service invoice (in LCY), prior to any item cost adjustments. The program calculates the amount as the difference between the values in the Amount and the Original Cost (LCY) fields.

Adjusted Profit (LCY)

This field shows the amount of profit for the service invoice, in LCY, adjusted for any changes in the original item costs. The program calculates the amount as the difference between the values in the Amount and the Adjusted Cost (LCY) fields. If this field contains a value of zero, it means that there were no entries to calculate, possibly because of data compression.

Original Profit %

This field shows the profit amount for the invoiced quantity, expressed in percentage, prior to any item cost adjustments on the service order.

Adjusted Profit %

This field shows the amount of the adjusted profit on the service invoice, expressed as percentage of the amount in the Amount field.

Quantity

This field shows the quantity of all G/L account entries, costs, items and/or resource hours in the posted service invoice. If a rounded amount results because the Invoice Rounding check box in the Sales & Receivables Setup window was selected, the Quantity field will contain the quantity of items, resource hours, costs and/or G/L account entries in the service document plus one.

Parcels

This field shows the total number of parcels that were invoiced.

Net Weight

This field shows the total net weight of the invoiced items.

Gross Weight

This field shows the total gross weight of the invoiced items.

Volume

This field shows the total volume of the invoiced items.

The amount in the Total Incl. VAT field is rounded according to the contents of the Invoice Rounding Precision field in the Currency table for the relevant currency. The values in the Amount, Cost (LCY) and Profit (LCY) fields are rounded according to the contents of the Amount Rounding Precision field in the Currency table.

The fields on the Customer FastTab display the following information:

Balance (LCY)

This field shows the balance in LCY on the customer's account.

Credit Limit (LCY)

There are two fields that show information about the customer's credit limit. The first field shows the maximum credit in LCY that can be extended to the customer that you created and posted this service invoice for. The second field represents a progress bar showing the percentage of the credit limit that the customer has used.

The lines at the lower part of the Service Invoice Statistics window provide a VAT % breakdown of the amounts in the posted service invoice.

Tip

See Also