Report Column Definitions

Column	Description
Agency	Agency that the transaction was linked to (for Agency Sales)
COGS	Cost of Goods Sold for the transaction (Average Cost of Stock Line at time of transaction)
Customer	Customer that the transaction was made to
Date	Date of the transaction
Day	Day of the week the transaction was made
Day(Distinct)	Date the transaction was made
Department	Department that the transaction was linked to (for Stock Lines, Department Sales and Agency Sales)
Discount	Total discounts given on transaction
Discounted Price	The price the customer has changed the sell price to Subtotal/Qty Sold
Govt Cont	Government Contribution at time of transaction (for PBS Claimable Scripts)
GST	GST collected for transaction
Hour	Hour of the day that the transaction was made
Hour(Distinct)	Hour and Date the transaction was made
Item Description	Description of the transaction
Item Type	Type of transaction eg Sale, Script Department sale, Debtor Payment, etc
Month	Month of the year the transaction was made
Month(Distinct)	Month and Year the transaction was made
Original Price	The original sell price of the item at that time
Promo Desc	Description of Promotion (for Promotional Lines)
Promo Discount	Sell Price - Promo Price (both values at time of transaction)
Qty Sold	Quantity of transaction
Receipt No	Receipt No that the transaction was made on
Register	Register number that the transaction was made on
Sales GP$	Gross Profit of transaction (Sales Val Ex - COGS)
Sales GP%	Gross Margin of transaction (Sales GP$/Sales Val Ex* 100)
Sales M/Up%	Markup of transaction (Sales GP$/COGS*100)
Sales Val	Sales Value including GST of transaction (Subtotal + Govt Cont)
Sales Val Ex	Sales Value excluding GST of transaction (Subtotal + Govt Cont - GST)
Sell Price	Stock Sell Price for 1 unit at the time of the transaction
Staff	Staff member that processed the transaction
Stock Cost	Cost of Stock Line at time of transaction (for Stock Lines)
Stock Cost Avg	Average Cost of Stock Line at time of transaction (for Stock Lines)
Stock Name	Name of Stock Line at time of transaction (for Stock Lines)
Subtotal	Sell Price - Promo Discount - Discounts + Surcharges (including Payment Method Surcharges) (all values at time of transaction
Surcharge	Total general surcharges added on transaction (excludes Payment Method Surcharges)
Total Discount	The total discounted amount (Original Price * Qty Sold) - Subtotal
Year	Year the transaction was made

Column	Description
Active	Is the Stock currently Active (Yes or No)
APN	Current default APN
Avg Cost	Avg Cost = Sum of Cost / Qty Ordered e.g. if you buy 6 at $6 and then 6 at $10, Avg Cost = (6 * 6 + 6 * 10) / 12 = $8 (Considers all orders for the life of the product)
Avg Value	(Stock Value at beginning of selected period + Stock Value at end of selected period)/2
Categories	Current Categories that the Stock belongs to
COGS	Cost of goods sold within selected period based on Average Cost of stock at time of sale
Cost	Current Cost
Created	Date Stock was created
Dept	Current Department
GP $	Current Sell Price Ex - Current Cost
Last Inv Cost	Current Last Inv Cost
Last Purchased	Date Stock was last purchased
Last Sold	Date Stock was last sold
Locations	Current Locations that the Stock belongs to
Manufacturer	Current Manufacturer
Margin	(Current Sell Price Ex - Current Cost)/current Sell Price Ex
Markup	(Current Sell Price Ex - Current Cost)/Current Cost
PDE	Current default PDE number for default Supplier
Prev Inv Cost	Current Prev Inv Cost
Qty on Ord	Current Quantity on order
Qty Purchased	Quantity Purchased within selected period
QTY Sold	Quantity Sold within selected period
Sales GP$	Sales Val Ex - COGS
Sales M/Up%	(Sales Val Ex - COGS)/COGS
Sales Margin%	(Sales Val Ex - COGS)/Sales Val Ex
Sales Val	Sales Value within selected period including GST
Sales Val Ex	Sales Value within selected period excluding GST
Schedule	Current Schedule
Sell Price	Current Sell Price
Sell Price Ex	Current Sell Price Ex
Stock Groups	Current Stock Groups that the Stock belongs to
Stock Name	Current Stock Name
Stock on Hand	Current Stock on Hand
Stock Value	Current Stock on Hand * Current Avg Cost
Stock Value (end date)	Average Cost at end date * SOH at end date
Stock Value (Last)	Last Invoice Cost at end date * SOH at end date
Stock Value (WS1)	WS1 Cost at end date * SOH at end date
Sub-Dept	Current Sub-Department
Supplier	Current Supplier
Turnover	COGS/Avg Value
WS1 Cost	Current Wholesale List Cost

Column	Description
Address(H)	Current Home Address
Address(P)	Current Postal Address
Bed No	Current Nursing Home Bed number
Concession	Current Concession number
Concession Exp	Current Concession number expiry date
DOB	Current DOB
Email	Current Email address
Family	Current Safety Net Family that the Customer is linked to
Fax	Current Fax number
First Name	Current First Name
Medicare	Current Medicare number
Medicare Exp	Current Medicare number expiry date
Mobile	Current Mobile number
Nursing Home	Current Nursing Home
Owing Scripts	Current number of scripts owing
PCode(H)	Current Home Postcode
PCode(P)	Current Postal Postcode
Phone	Current Phone number
Repat	Current Repat number
Repat Exp	Current Repat number expiry date
Repat Type	Current Repat card Colour
Room No	Current Nursing Home Room number
Sex	Current Sex
SN Entitlement	Current Safety Net number
State(H)	Current Home State
State(P)	Current Postal State
Suburb(H)	Current Home Suburb
Suburb(P)	Current Postal Suburb
Surname	Current Surname
Title	Current Title
Ward	Current Nursing Home Ward

Hi, how can we help?

Comments

Hi, how can we help?

Sales Report

Stock Report

Customer Report