12 | Stock Purchases Data Explained

This article covers the basic formulas used to calculate data in the Stock Purchase Report. There are two (2) default View types for Stock Purchase Reports - Purchase Orders and Supplier Totals. The Purchase Order view creates orders on the basis of purchases made whereas Supplier Totals displays the total payment amounts for different Suppliers.

This article covers the basic formulas used to calculate data in the Stock Purchase Report.

There are two (2) default View types for Stock Purchase Reports - Purchase Orders and Supplier Totals.

The Purchase Order view creates orders on the basis of purchases made whereas Supplier Totals displays the total payment amounts for different Suppliers.

Prerequisites

To access Stock Purchases Settings, the applicable Operator Privileges will need to be enabled

Operator Maintenance 'Reporting' Tab

Sales Reports: "Allow Stock Reports" Flag

"_Purchase Orders" View Formulas

Purchase Orders is one of the default views for the Stock Purchases Report and consists of the following data columns by default:

Column Heading	Data Description	Formula
LineItem Total Ex	This shows the total cost price of all the Line Items purchased excluding tax	Total quantity of Product X Unit Price (Excluding tax)
LineItem Total Inc	This shows the total cost price of all the Line Items purchased including tax	Total quantity of Product X Unit Price (Including tax)
Invoice TotalEx	This shows the total amount of invoice excluding tax	Sum of all the LineItem Total Ex
Invoice Total Inc	This shows the total amount of invoice including tax	Sum of all the LineItem Total Inc

"_Supplier Totals" View Formulas

This is the second default view for Stock Purchases Reports
This type displays the Invoice Totals of all the Suppliers from whom purchases have been made
This View consists of the following data columns by deault:

Column Heading	Data Description	Formula
Invoice TotalInc	This shows the Total amount of Invoice including Tax	Sum of all the LineItem Total Inc
Invoice Total Ex	This shows the Total amount of Invoice excluding Tax	Sum of all the LineItem Total Ex
Invoice Tax1	This is the total tax amount	Invoice Total Inc- Invoice Total Ex
LineItem TotalInc	This shows the total cost price of all the Line Items purchased including Tax	Sum of all the LineItem Total Inc
LineItem TotalIEx	This shows the total cost price of all the Line Items purchased excluding Tax	Sum of all the LineItem Total Ex

12 | Stock Purchases Data Explained

Column Heading

Data Description

Formula

Column Heading

Data Description

Formula