Inventory reports

Summary of report

Displays items with no link established to AppCAT Items.

Use for:

  • Identify and resolve items with no AppCAT item Matches.

Column Definitions

Column Heading Definition/Calculation Group by Add from Column Chooser
Department Department the item belongs to Y  
Category Departmental Category the item belongs to    
Item Code Item look-up code for item    
Item Description Detailed description of item    
SOH Current stock on hand count (total SOH)    
Cost Ex Unit cost of the item excluding GST    
Retail Unit retail price of item inc GST    
Last Sold date the item was last sold    
GST Status GST; No GST; GST-FREE   Y

Summary of report

Displays all items in Fred Office Plus which have “Committed” Stock levels greater than zero, including dispensed item not yet sold and lay-by items.

Use for:

  • Identify items marked as “committed” but where the items has left the store.

Column Definitions

Column Heading Definition/Calculation Group by Add from Column Chooser
Department Department the item belongs to Y  
Category Departmental Category the item belongs to    
Item Code Item look-up code for item    
Item Description Detailed description of item    
SOH Current stock on hand count (total SOH)    
Committed Qty of stock showing as committed on item stock card    
On Order Qty of stock currently on open order/open invoice    
Qty Sold Last Week Count of item sold in the past week   Y
Qty Sold Last Month Count of Item sold in the past month   Y
Orderable Yes shows absence of “do not re-order” flag; No shows presence of flag   Y
Available SOH – Committed    

Summary of report

Displays inventory that has not been sold in a specific period. Allows users to filter on current stock value of SOH.

You can review specific suppliers, departments or categories to find stock that is not moving.

Newly create items from the list.

Use for:

  • Locate item that have not sold since a specific date.

  • Optionally find items that have a current SOH or $ value greater than a nominated amount.

  • Display item that have low sales values or qty over a specific period of time.

Column Definitions

Column Heading Definition/Calculation Group by Add from Column Chooser
Item Code Item look-up code for item    
Department Department the item belongs to Y  
Category Departmental Category the item belongs to Y  
Item Description Detailed description of item    
Cost Ex Unit cost of the item excluding GST    
Retail Unit retail price of item inc GST    
SOH Current stock on hand count (total SOH)    
SOH $ Current SOH x Unit cost of item ex GST    
Last Ordered Date Date last order was created for this item   Y
Last Sold Date Date item was last sold   Y
Sales Value of sale    
Qty Sold Count of items in a transaction    
Is Active Is item active Y/N   Y
Item Location Location in store recorded in Item Stock card   Y

Summary of report

Displays Fred Dispense drugs and the Fred Office Plus item to which they are matched.

Displays drugs which have no Fred Office Plus item match present.

Use for:

  • Locate those drugs which have no matched linked items. matched means the drugs, when dispensed, will be recorded correctly in Fred Office Plus (usage, cost price, profitability) rather than reported as a “999999” items.

  • Identifying which item within Fred Office Plus a Fred Dispense drug will use when dispensed. This can be reviewed and altered from this report.

Column Definitions

Column Heading Definition/Calculation Group by Add from Column Chooser
Drug Code Code assigned in Fred Dispense to Drug    
Drug Name Drug Name from Fred Dispense    
Strength mg; mcg; mg/ml; mcg/ml etc    
Form Tab; cap; elix etc    
Item Description Detailed description of item    

Summary of report

View item Pricing information including any advanced pricing information.

Use for:

  • Producing list of items with common features (department, category, supplier, item options).

  • Identify items with item messages applied.

  • Identify items with retail set below cost price.

  • Identify current items pricing plans.

  • Identify current item profit, markup and/or margin.

Column Definitions

Column Heading Definition/Calculation Group by Add from Column Chooser
Item Code Item look-up code for item    
Item Description Detailed description of item    
SOH Current stock on hand count (total SOH)    
Committed Qty of stock showing as committed on item stock card   Y
Available SOH – Committed   Y
Cost Ex Unit cost of the item excluding GST    
Retail Unit retail price of item inc GST    
GST Value of GST    
Markup % [(Retail ex tax- cost price ex tax)/( cost price ex tax)] x 100    
Margin % [(Retail ex tax- cost ex tax)/(Retail ex tax)] x 100    
Category Departmental Category the item belongs to   Y
Department Department the item belongs to   Y
Ext Cost Ex (Cost ex) x SOH   Y
Profit Retail ex tax – Cost ex tax   Y
item message Message attached to item for display at register   Y
Pricing Plan Name of plan item is linked to    
Discount Scheme Discount Scheme this item is linked to.   Y
GST Type Tax Type, GST; No GST; GST Free   Y
Primary Supplier Name of the preferred supplier   Y
Re-order # PDE number of the preferred supplier   Y
Price Level A Calculated value of Defined price level A   Y
Price Level B Calculated value of Defined price level B   Y
Price Level C Calculated value of Defined price level C   Y
Last Price Review date of last review   Y
Price Type is item a Fixed price, Y;N   Y
Tester is item a tester, Y;N   Y
Created date item was created   Y
Item Location is item a tester, Y;N   Y

Summary of report

Identifies items here the stock on hand quantity has been manually adjusted.

Use for:

  • Identify where adjustments are being done, when and by whom.

Column Definitions

Column Heading Definition/Calculation Group by Add from Column Chooser
Department Department the item belongs to    
Category Departmental Category the item belongs to    
Item Code Item look-up code for item   v
Item Description Detailed description of item Y  
Neg Qty Sum of negative adjustments in period   Y
Neg$ Sum of value of negative adjustments in period   Y
Pos Qty Sum of positive adjustments in period   Y
Pos $ Sum of value of positive adjustments in period   Y
Net Adj Sum of adjustments to item in report period    
Net Adj $ Value of sum of adjustments to item in period    
% Sales Ex {(sum of adjustment in period)/ qty sold in period] x 100    
Reason Reason code for adjustment   Y
Source Connector; register etc   Y

Summary of report

Compare manual stock adjustments over two designated periods.

Use for:

  • Highlights stock items where stock adjustments are being done frequently.

Column Definitions

Column Heading Definition/Calculation Group by Add from Column Chooser
Department Department the item belongs to    
Category Departmental Category the item belongs to    
Item Code Item look-up code for item   Y
Item Description Detailed description of item    
Neg Qty 1 Sum of negative adjustments to item SOH in first period    
Neg Qty 2 Sum of negative adjustments to item SOH in second period    
Neg Qty Var [(Neg Qty 2) – (Neg Qty 1)]   Y
Neg $ 1 Sum of value of negative adjustments to item SOH in first period    
Neg $ 2 Sum of value of negative adjustments to item SOH in second period    
Neg $ Var [(Neg $ 2) – (Neg $1)]    
Pos Qty 1 Sum of positive adjustments to item SOH in first period    
Pos Qty 2 Sum of positive adjustments to item SOH in second period    
Pos Qty Var Sum of positive adjustments in period   Y
Pos $ 1 Sum of value of positive adjustments to item SOH in first period    
Pos $ 2 Sum of value of positive adjustments to item SOH in second period    
Pos $ Var Sum of value of positive adjustments in period   Y
Net Adj 1 [(Pos qty 1 + Neg Qty 1)]   Y
Net Adj 2 [(Pos Qty 2 + Neg Qty 2)]   Y
Net Adj Var {(Net Adj 2) – (Net Adj 1)]   Y
Net Adj $ 1 [(Pos $ 1 + Neg $1)]   Y
Net Adj $ 2 [(Pos $ 2 + Neg $2)]   Y
Net Adj $ Var [(Net adj $2) – (Net adj $1)]   Y
% sales 1 Ex [(nett value of adjustment in period 1)/Sales ex in period 1]    
% Sales 2 Ex [(nett value of adjustment in period 2)/Sales ex in period 2]    
% Sales var [(% sales 2 ex) –(% sales 1 ex)]   Y

Summary of report

Displays items which have stock on hand figures less than zero.

Use for:

  • Identify and resolve items with a stock on hand vale less then zero.

  • Housekeeping report to maintain stock levels.

Column Definitions

Column Heading Definition/Calculation Group by Add from Column Chooser
Department Department the item belongs to Y  
Category Departmental Category the item belongs to    
Item Code Item look-up code for item    
Item Description Detailed description of item    
SOH Current stock on hand count (total SOH)    
Orderable Yes shows absence of “do not re-order” flag; No shows presence of flag    
On Order Qty of stock currently on open order/open invoice    
Cost Ex Unit cost of the item excluding GST    
Last Ordered Date Date last order was created for this item    
Item Location     Y

Summary of report

For any specific promotion, display items performance based on dates before, during and after the promotion dates.

The “Before Promotions” and “After Promotions” date ranges are based on the same length of time as the “During Promotion” date range.

Use for:

  • Compare profitability and the effect of a promotion on sales with the same preceding or subsequent time period.

  • To track immediate changes in sales volume following a promotion.

Column Definitions

Column Heading Definition/Calculation Group by Add from Column Chooser
Item Description Detailed description of item    
SOH Current stock on hand count (total SOH)    
Before - Sales Count Count of transactions for item in period    
Before - Quantity Sold Count of number of item sold in period    
Before - Ext Sales Inc Total Sales value (inc tax) for item in period    
Before - Profit $ Total value of profit generated by item in period    
Before - Avg Sales Price [(ext sales inc)/quantity sold] in period    
During - Sales Count The value of the tender “cash” for the Batch    
During - Quantity Sold Count of number of item sold in period    
During - Ext Sales Inc Total Sales value (inc tax) for item in period    
During - Profit $ Total value of profit generated by item in period    
During - Avg Sales Price [(ext sales inc)/quantity sold] in period    
After - Sales Count Count of transactions for item in period    
After - Quantity Sold Count of number of item sold in period    
After - Ext Sales Inc Total Sales value (inc tax) for item in period    
After - Profit $ Total value of profit generated by item in period    
After - Avg Sales Price [(ext sales inc)/quantity sold] in period    
Promotion Name     Y

Profit $

Sale ex – Cost ex

    

Summary of report

Identifies what rate of usage scheme has been set for items.

Use for:

  • Check rate of usage scheme assigned to items(s).

  • Check and rank rate of usage values for items.

  • Identify high usage items.

  • Identify very low usage items.

Column Definitions

Column Heading Definition/Calculation Group by Add from Column Chooser
Item Description Detailed description of item    
Item Code Item look-up code for item    
Category Departmental Category the item belongs to Y  
Department Department the item belongs to Y  
ROU Scheme Unit cost of the item excluding GST    
ROU Value Unit cost of the item excluding GST    
SOH Current stock on hand count (total SOH)    

Summary of report

Displays all item which has recorded movement within a date range.

This include movement type of sale, refund, invoices receipt, manual alteration of SOH and stocktake adjustment.

Use for:

  • Investigation of reasons for inconsistent stock levels.

  • Negative stock on hand figures for items with movement over a date range.

  • Item which had SOH manually adjusted and by whom.

Column Definitions

Column Heading Definition/Calculation Group by Add from Column Chooser
Department Department the item belongs to Y  
Category Departmental Category the item belongs to    
Item Code Item look-up code for item    
Item Description Detailed description of item    
Movement Type Description of type (initial value; invoice; sale; refund etc)    
Adj. Qty Qty involved in the stock movement    
SOH Current stock on hand count (total SOH)    
Reason Reason code for adjustment    
Source Connector; register etc    
Movement Date Date movement was done.    
Adj. $ Value of stock movement   Y
SOH $ Current SOH x Unit cost of item ex GST   Y
Cost Ex Unit cost of the item exclusing GST   Y

Summary of report

Displays full detail of any selected stocktake.

Retains historically the stock count of items at a specific time in history.

Use for:

  • Provides a discrepancy report after a stocktake is committed.

  • Gives a checkpoint for stock on hand at a specific date.

Column Definitions

Column Heading Definition/Calculation Group by Add from Column Chooser
Item Code Item look-up code for item    
Department Department the item belongs to Y  
Category Departmental Category the item belongs to Y  
Item Description Detailed description of item    
Cost Ex Unit cost of the item excluding GST    
Counted Number counted in stocktake    
Expected Qty Number system showed as on hand prior to Stocktake    
Counted $ [(Number counted in stocktake) x Cost ex]    
Differences [(Counted} – {Expected)]    
% Differences Differnce / Expected x 100    
Expected Cost [(Expected Qty) x Cost ex]    
Difference Cost [(counted $) – (Expected $)]    
Item Location Location in store recorded in Item Stock card    

Summary of report

Displays current stock value by department, category or item. Can be optionally filtered to show items no included in a stock take or stock value by supplier.

Includes a breakdown of value by department/category an item.

Use for:

  • Display current stock valuations.

  • Display which items have not been included in a stocktake since a given date.

  • What percentage of stock value is in which department/category/item group.

  • Investigate items not received on orders since a given date.

  • Investigate items not sold since a given date.

  • Investigate items not modified since a given date.

Column Definitions

Column Heading Definition/Calculation Group by Add from Column Chooser
Item Code Item look-up code for item   Y
Department Department the item belongs to Y  
Category Departmental Category the item belongs to Y  
Item Location Location in store recorded in Item Stock card   Y
Item Description Detailed description of item    
Cost Ex Unit cost of the item excluding GST    
Retail Unit retail price of item inc GST    
SOH Current stock on hand count (total SOH)    
SOH $ Current SOH x Unit cost of item ex GST    
Total Retail [(retail price inc tax) x SOH]   Y
Markup % [(Sale value ex tax- extended cost ex tax)/(Extended cost ex tax)] x 100    
Margin % [(Sale value ex tax- extended cost ex tax)/(Sale value ex tax)] x 100    
Value % [(Value of item/category/department)/Report total value] x 100    
Last Received Date when item was last received into Stock (from invoice)   Y
Last Sold Date Date item was last sold   Y
Modified Date this item was last modified   Y
Last Stocktaked Date item was last counted   Y
Primary Supplier Name of the preferred supplier   Y
Reorder # PDE number of the preferred supplier   Y
HQID AppCAT Item number   Y
Created date item was created   Y

Summary of report

Allows user to perform a stock valuation at any given point in time.

Will only show data that can be reviewed in a historical sense (cost & quantity only).

Items created after nominated date will be excluded from the report.

Use for:

  • Review stock value at a given date.

  • Review stock value for a supplier or department at any given date.

Column Definitions

Column Heading Definition/Calculation Group by Add from Column Chooser
Item Code Item look-up code for item   Y
Department Department the item belongs to Y  
Category Departmental Category the item belongs to Y  
Item Description Detailed description of item    
Cost Ex Unit cost of the item excluding GST    
SOH Current stock on hand count (total SOH)    
SOH $ Current SOH x Unit cost of item ex GST    
Value % [(Value of item/category/department)/Report total value] x 100    
Primary Supplier Name of the preferred supplier   Y
Reorder # PDE number of the preferred supplier   Y