Purchase Order Statistics Window
This window appears when you click Order and then Statistics from the Purchase Order window. The window shows statistics for the relevant purchase order. The Purchase Order Statistics window includes five FastTabs: General, Invoicing, Shipping, Prepayment, and Vendor. These FastTabs show information such as quantity, amount, VAT, and vendor balance.
The purchase order statistics provide you with a quick overview of the contents of the entire purchase order, the details in the specific purchase order lines, and the quantities that will be invoiced and received.
The amounts in the Purchase Order Statistics window are in the currency of the purchase document, unless otherwise indicated.
General, Invoicing, and Shipping FastTabs
The fields are the same on the General, Invoicing, and Shipping FastTabs but the field contents vary for each FastTab:
The General FastTab displays information regarding the entire purchase order. The total quantity is specified in the Quantity field on each of the purchase lines.
The Invoicing FastTab displays information about the quantity of items to be invoiced. The quantity to invoice is specified in the Qty. to Invoice field on each of the purchase lines.
The Shipping FastTab displays information about the quantity of items to be received. The quantity to receive is specified in the Qty. to Receive field on each of the purchase lines.
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. The program rounds off, the amounts in the Amount, Inv. Discount Amount, Total, and VAT fields that make up the amount in the Total Incl. VAT field. The amount in the Amount (LCY) field is rounded according to the contents in the Amount Rounding Precision field in the Currency table for the relevant currency.
The fields on the General, Invoicing, and Shipping FastTabs show the following information for the relevant quantities (total quantity, quantity to invoice, or quantity to receive) as mentioned above:
| Field | Description |
|---|---|
Amount |
This field shows the net amount of all the lines in the purchase order. 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 purchase order. If the Calc. Inv. Discount field is selected in the Purchases & Payables Setup window, then the discount was calculated automatically. Otherwise, it was calculated when you used the Calculate Invoice Discount function. |
Total |
This field shows the total amount less any invoice discount amount and excluding VAT for the purchase order. |
% VAT or VAT Amount |
This field shows the total VAT amount that has been calculated for all the lines in the purchase order. |
Total Incl. VAT |
This field shows the amount, including VAT. On the Invoicing FastTab, this is the amount that is posted to the vendor's account for all the lines in the purchase order if you post the purchase order as invoiced. |
Purchase (LCY) |
This field shows the amount in the Total field converted to LCY. |
Quantity |
This field shows the total quantity of G/L account entries, fixed assets, and/or items in the purchase order. If a rounded amount results because there is a check mark in the Invoice Rounding field in the Purchases & Payables Setup window, the Quantity field contains the quantity of items in the purchase document plus one. |
Parcels |
This field shows the total number of parcels in the purchase order. |
Net Weight |
This field shows the total net weight of the items in the purchase order. |
Gross Weight |
This field shows the total gross weight of the items in the purchase order. |
Volume |
This field shows the total volume of the items in the purchase order. |
Prepayment FastTab
The fields on the Prepayment FastTab display the following information:
| Field | Description |
|---|---|
Prepmt. Amount Excl./Incl. VAT |
This field shows the total prepayment amount for the order, for all lines and all prepayment invoices. (If the Prices Including VAT field on the purchase header contains a check mark, this field is including VAT. If the Prices Including VAT field on the purchase header does not contain a check mark, this field is excluding VAT.) |
% VAT or VAT Amount |
This field shows the total VAT amount on prepayments for all the lines in the order. (The VAT % is specified in the field name only if all lines in the order have the same VAT %.) |
Prepmt. Amount Excl./Incl. VAT |
This field shows the total prepayment amount for the order, for all lines and all prepayment invoices. (If the Prices Including VAT field on the purchase header contains a check mark, this field is excluding VAT. If the Prices Including VAT field on the purchase header does not contain a check mark, this field is including VAT.) |
Prepmt. Amt. Invoiced |
This field shows the total prepayment amount that has been invoiced for the order. |
Prepmt. Amt. Deducted |
This field shows the prepayment amount that has been deducted from ordinary invoices issued for the order. |
Prepmt. Amt. to Deduct |
This field shows the prepayment amount that is deducted if an ordinary invoice is issued for the order. The Prepmt. Amt. to Deduct for each line = (Prepmt. Amt. Invoiced - Prepmt. Amt. Deducted) x (Qty. to Invoice / Quantity). This field contains the sum of all the lines. |
Vendor FastTab
The field on the Vendor FastTab displays the following information:
| Field | Description |
|---|---|
Balance (LCY) |
This field shows the balance (in LCY) due to the vendor. |
Tip
For more information on how to navigate in the user interface, see Work with Microsoft Dynamics NAV. For assistance in finding specific pages, see Search.
See Also
Reference
Quantity
Qty. to Invoice
Qty. to Receive
Calc. Inv. Discount
Prices Including VAT
Purchase Header
Other Resources
Invoice Rounding Precision
Amount Rounding Precision
How to: View Purchase Order Statistics
How to: View the Status of Blanket Purchase Orders
VAT Amount Line