Open the Sales Invoice Statistics window.

The Sales Invoice Statistics window appears when you click Invoice and then Statistics from the Posted Sales Invoice window. The window shows statistics for the relevant sales invoice lines.

This window includes two FastTabs: General and Customer. These FastTabs show information such as quantity, amount, VAT, and customer credit limit for the posted sales invoice.

On the General FastTab, the amount in the Total Incl. VAT field is rounded according to the contents in the Invoice Rounding Precision field in the Currency table for the relevant currency. Then the program will round off the amounts in the Amount, Inv. Discount Amount, Total, and VAT fields that make up the Total Incl. VAT amount. The amounts in the Amount, Cost (LCY), and Profit (LCY) fields are rounded according to the contents in the Amount Rounding Precision field in the Currency table for the relevant currency.

The amounts in the fields on the General FastTab are in the currency of the sales document unless otherwise indicated. The fields on the General FastTab display the following information:

Amount

This field shows the net amount of all the lines in the posted sales 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 sales 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.

Total

This field shows the total amount less any invoice discount amount and exclusive of VAT for the posted sales invoice.

% VAT or VAT Amount

This field shows the total VAT amount of the posted sales 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 converted to LCY.

Original Cost (LCY)

This field shows the total cost, in LCY, of the G/L account entries, items and/or resources in the posted sales invoice. The cost is calculated as (unit cost * quantity to invoice).

Adjusted Cost (LCY)

This field shows the total cost, in LCY, of the items in the posted sales invoice, adjusted for any changes in the original costs of these items. If this field contains a value of zero, it means that there were no entries to calculate, possibly because of date compression or because the adjustment batch job 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 sales invoice. If this field contains a value of zero, it means either that the original cost and adjusted cost are the same or that there were no entries to calculate, possibly because of date compression.

Original Profit (LCY)

This field shows the difference, in LCY, between the amounts in the Amount and Original Cost (LCY) fields for the quantity invoiced on this document.

Adjusted Profit (LCY)

This field shows the difference, in LCY, between the amounts in the Amount and Adjusted Cost (LCY) fields for the quantity invoiced on this document. If this field contains a value of zero, it means that there were no entries to calculate, possibly because of date compression.

Original Profit %

This field shows profit expressed as a percentage of the amount in the Amount field.

Adjusted Profit %

This field shows the profit, adjusted for any changes in the original costs of the items, expressed as a percentage of the amount in the Amount field.

Quantity

This field shows the total quantity of G/L account entries, items and/or resources in the posted sales invoice. If a rounded amount resulted because there was a check mark in the Invoice Rounding field in the Sales & Receivables Setup table, the Quantity field will contain the quantity of items in the sales 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 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 credit limit in LCY of the customer that you created and posted this sales invoice for. The second field shows the percentage of the credit limit that the customer has used.

Tip