Skip to content
English
Contact us
  • There are no suggestions because the search field is empty.

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