Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

ReportID
Report Name
Built In (1)
Category
Key Columns
How To Run The Report (2)
Purpose
Show Me
A-001GST SummaryYesFinancials Bas Code, Tax Code, Site,Transaction Type, Value Ex Tax, GST Paid Value, GST Received Value, Value Inc Tax, Grand TotalsReports >Analysis> Double click on the report > Click on Bind Data > Select the Filter or Parameter> Select your criteriaThis report outputs a one line summary for each Bas Code, the Total Value Ex, Total GST Paid, Total Gst Received and Total Value Including the GST for the date or period range selected and then an overal total.
Expand
titleShow me

 

 

A-002Live Stock ReportYesInventoryProduct Category, Product Display Name, Pricing, Last Received, Last Shiped, Qty on hand, Qty on Sales Order, Qty on Purchase Order, Qty on Sales Backorder, Qty allocated, Qty Transfer out, Net Qty on Hand, Qty Available, Grand Totals.Reports >Analysis> Double Click on the report > Click on Bind Data > Select the Filter or Parameter> Select your criteriaThis report is as it states , LIve stock as of the time it is run. Gives you an indication of what makes up the nett result of Qty Available.
Expand
titleShow me

A-003Sales By Day By Site AnalysisYesSalesDate, Value Inc, Gross Profit %Reports >Analysis> Double Click on the report > Click on Bind Data > Select the Filter or Parameter> Select your criteriaThis report is summarised by Day to give you an overall total by Day of the Dollar Value of Sales Inc GST and GP% .
Expand
titleShow me

 

A-004Sales by Customer by PeriodYesSalesCustomer Code, Customer Name, Period, Value Ex Tax, Value Inc Tax, Cost Ex Tax, Margin Percent, Gross Profit Percent, Grand TotalReports >Analysis> Double Click on the report > Click on Bind Data > Select the Filter or Parameter> Select your criteriaThis report is summarised for each cusotmer for each period to give you an indication of the Value of Sales along with Cost, Margin and GP%
Expand
titleShow me

 

A-005Sales by Sales Person by Customer by CategoryYesSalesSalesperson,Customer code and name, Category, Value Ex GSt, Gross Profit %Reports >Analysis> Double Click on the report > Click on Bind Data > Select the Filter or Parameter> Select your criteriaThis report is summarised by Salesperson to give the dollar value of sales for the Rep for each customer that has purchased . This report can also be used to work out the sales commissions for the sales people.
Expand
titleShow me

 

 Sales by Salesperson by Customer By Category DetailedNoSalesSales Person, Customer, Level 2 and 3 Product Category and each invidivual product within that category, Value Ex Tax, Margn, GP%, Grand totalReports >Analysis> Double Click on the report > Click on Bind Data > Select the Filter or Parameter> Select your criteriaAnalyse sales person sales by customer and category by month. This report summaries the details to category level 3 and does not show individual product details for that category.This report is handy in identifying the sales for cost centres/departments which we classify as Product Categories
Expand
titleShow me

 Sales by Salesperson by Customer By Category By Product DetailedNoSalesSales Person, Customer, Level 2 and 3 Product Category and each invidivual product within that category, Value Ex Tax, Margn, GP%, Grand totalReports >Analysis> Double Click on the report > Click on Bind Data > Select the Filter or Parameter> Select your criteriaAnalyse sales person sales by customer and category by month down to the individual product level. This report is handy in identifying the sales for cost centres/departments which we classify as Product Categories
Expand
titleShow me

 

 Contract Sales By Customer By Product DetailedNoContractContract, Custmer Code and Name, Product and Product Name, Value Ex, Margin, GP%Reports >Analysis> Double Click on the report > Click on Bind Data > Select the Filter or Parameter> Select your criteriaUsed to identify the sales for Customers/Products that have been sold that have a Contract Price.
Expand
titleShow me

 

 Contract SalesSummaryNoContractContract, Value Ex, Margin, GP%Reports >Analysis> Double Click on the report > Click on Bind Data > Select the Filter or Parameter> Select your criteriaUsed to identify the sales for a Contract in summary by period.
Expand
titleShow me

 

 Sales by Salesperson SummaryNoSalesSales Person, Value Ex, Margin, GP%Reports >Analysis> Double Click on the report > Click on Bind Data > Select the Filter or Parameter> Select your criteriaThis report can be used to work out the sales person commsion. It is a in summary format by sales person with the values required to work out the commission and how muchSales person for total value sold.
Expand
titleShow me