Columns, Fields, and Filters

A

Australian Business Number.

The number of transactions that have been cancelled.

Accounts can be broken up into several formats which are Credit, Lay by, Hire and Loyalty.  The Credit account format includes different account types such as Personal, TAC, Work cover and Other. Please note while other account types can be added (via the “Tools” menu, “Accounts”, “Options”, “Account Types” tab) only these default account types can be direct charged to from Fred Dispense.

The group the account belongs to (if applicable).  Some reports include an account group filter allowing you to restrict your report to show only accounts in the group(s) selected.

The name of the account.

The unique account number.

An active or open account.

Payments (or payment totals) made to the account.

Sales made onto the account.

A reporting filter allowing you to search and restrict the report to a specific account(s).

Accounts can be broken up into several formats which are Credit, Lay by, Hire and Loyalty.  The Credit account format includes different account types such as Personal, TAC, Work cover and Other. Please note while other account types can be added (via the “Tools” menu, “Accounts”, “Options”, “Account Types” tab) only these default account types can be direct charged to from Fred Dispense.

In some reports an account type filter exists to assist you restrict reports to the desired account type(s) only.

A reporting filter allowing you to show only accounts that are active in the report.  This will exclude any inactive (closed) accounts.

A reporting filter (available under advanced filters) in the Account Activity report allowing you to select to view only activities with a discount.

A reporting filter (available under advanced filters) in the Account Activity report allowing you to select to view only activities with a return (negative quantities).

A reporting filter which allows you to select a date range to restrict the report to.

Comments recorded against the item or account when the sale was performed.

A report filter which allows you to restrict the report to display only accounts with a transaction, adjustment, payment or with a close/ open performed.

A reporting filter allowing you to show only account activity with comments previously entered.  This could be a standard comment added at the POS, a comment used for adjustments/ payments etc.

Please note this search only looks at the start of the field for the term you have entered.

Part of the account or customer address.

Throughout Fred Office Plus the “Add” button appears to assist you add.  For instance alias’ or suppliers (to items), accounts or patients (to customers) etc.

Available from “Statements” this feature allows you to generate statements in bulk, additional to scheduled statement runs.

The dollar amount of the account adjustment performed.

The quantity of the account adjustment performed.

Allows you to perform an account adjustment (credit or debit).  This function is available from the account card toolbar.

Adjustments made during the current period.

A column in reporting which allows you to compare the promotion sale period to the same time period after the promotion has ended.  For instance if the promotion ran for 2 weeks, the “after promotion” would be for the 2 weeks following the promotion period. 

Please note this is relevant to promotions set up via the Pricing section of Fred Office Plus only.

Is the quantity of stock available for sale or stock transfer. It is calculated by the following formula:

Quantity on Hand – Committed Quantity = Available Quantity

B

Items on order which are unable to be supplied with the initial delivery may be placed on backorder.  They will generally appear on a new invoice when they next become available.

The quantity of the item to be supplied on backorder.

A report filter allowing you to restrict the report to based on open or closed batches and the date the batch was closed between.

The date the batch number was closed.

A unique number that automatically generates on every Z-Report at the register.

The date the batch number was opened.

This features allows you to search for an existing batch entry.

The batch status will confirm whether the batch is currently “open” or “closed”.

A column in reporting which allows you to compare the promotion sale period to the same time period before the promotion started.  For instance if the promotion ran for 2 weeks, the “before promotion” would be for the 2 weeks before the promotion period.

Please note this is relevant to promotions set up via the Pricing section of Fred Office Plus only.

C

A tender type available for selection when completing a transaction at the till.

A column in reports which identifies the staff member that performed the transaction at the till.

The cashier’s first name.

The cashier’s first name and last name.

The cashier’s last name.

A report filter allowing you to restrict to display a specific cashier(s).

A category is the secondary classification of items in the merchandise hierarchy.  Items in categories facilitate ease of reporting, ordering, pricing etc.

Note: An item must be allocated to a department before a category can be assigned.

A tender type available for selection when completing a transaction at the till.

The suburb name when creating a new contact.

A statement option allowing you to set the wording which will appear before the claim number on a statement.

Available from an open account card toolbar, it closes the current account.

The date the account was closed.

The total outstanding amount for the current period.

Comments recorded against the item or account when the sale was performed.

This is the total quantity of an item committed to be sold, but yet to be collected. This includes such things as open lay bys and prescriptions awaiting collection.

The unit cost price of the item excluding GST.

The unit cost price of the item including GST.

The last date the item was counted in a stocktake.

Generates an ad-hoc statement for the selected account. It will automatically open a PDF of this statement for printing and also create a statement record (viewable in “Previous Statements”).

Please note if these are created and not deleted after printing they can interfere with the production of a full month’s details on the next statement run.

A report filter user to restrict the activities in this report to “Greater” than, “Greater or Equal” to, “Equal” to, “Less” than or “Less or Equal” to the stock on hand figure entered in the adjacent field. 

A report filter used to restrict the activities to “Greater” than, “Greater or Equal” to, “Equal” to, “Less” than or “Less or Equal” to the stock on hand dollar value figure entered in the adjacent field. 

The count of customers that a transaction has occurred for, during this batch period.

D

A report filter that restricts information to only appear for a date range specified.

This is not a “time” based setting but rather 30 is the previous statement’s overdue amount, 60 is the overdue from the statement before that and 90 the amount outstanding from statements prior to these two.

These figures will only display if you have “Show 30, 60, 90 day balances” ticked in the statement options.

An option in ordering to record any additional charges associated with drugs of addiction orders.

An option in ordering that is used to enter any additional freight charges.

Department is the primary classification of items in the merchandise hierarchy.  Items in departments facilitate ease of reporting, ordering, pricing etc.

This filter allows you to restrict the data in the report by department(s), including all associated categories, or by specific categories in departments.

For example, to include the “Analgesics” Department (all categories) but only the “Creams and Lotions” Category in the “Baby” Department select as shown (to the right).

If you want to include all departments and categories, do not make any selections.

The discount scheme set for the item. See Discounts for more details.

Money that has been removed from the till and placed in the safe or taken to the bank.

A unique code that is assigned to all drugs created in Fred Dispense.  This helps assist matching to items in Fred Office Plus.

This is a column displayed in the Promotion Performance report and indicates details for the item(s) during the promotion period. 

E

The extended cost excluding GST.  That is the unit cost price of the item excluding GST x the quantity.

The extended cost including GST.  That is the unit cost price of the item including GST x the quantity.

G

Script Type

A report filter allowing you to restrict the report to sales “With Recovery” or sales “Without Recovery”.

The GST or Tax Status of the item.

I

Generates an interim statement for the selected account. It will automatically open a PDF of this statement for printing, however no record of such will be maintained on the account (with no statement appearing in “Previous Statements”).

A filter allowing you to restrict the report to invoices with a status of  “Receiving Required”, “Pricing Required” or “Completed” only.

A filter available in the AppCAT Matching report allowing you to restrict the report to show all unmatched items, old unmatched items or new unmatched items.

“Old Unmatched Items” refers to items where matching has been attempted previously through the Bulk AppCAT Matching Wizard.  “New Unmatched Items” refers to items where matching has not yet been attempted through the Bulk AppCAT Matching Wizard.

A report filter allowing you to restrict the report to show only active or inactive items.

A unique code is assigned to all items. If a code is unknown, a self generated code can be created.

An option to include extra details about an item or service during a transaction at the till. The comment will print on the customer receipt.

A report filter used to prevent newly added ranges from reporting (such as on the Dead Stock report).

Items can be grouped even when they have no common link. Groups can be very useful if you want to apply changes in bulk (via the “Quick Action Wizard”), set up staff incentives, and manage ordering and/or reporting.

This report filter allows you to restrict your report by item groups.  Click those you want to include in the report.  Alternatively if you want to exclude a group(s), tick “Exclude instead of Include”.

Item Messages can be set and appear when the item is scanner or searched at the POS Till. These messages can be configured via the Tools Menu and set in the item stockcards in the “Inventory” then “Items” section of Fred Office Plus.

A report filter used to restrict the report to show only items below cost price.

A report filter allowing you to restrict the report to specific item(s).

There are a number of item types available in Fred Office Plus, each with its own attributes and business rules.  For further detail on item types please refer to the “Item Type” details page by clicking  here: Item Type

A report filter allowing you to restrict the report to specific a item type(s).

An option when selected will not allow the price to be discounted when sold at the till.

A report filter which allows you to restrict the report to display only items that are set as “Not Discountable” or items that are “Discountable”.

A report filter which allows you to restrict the activities to show “Only show sold items”, “Only show items not sold” or to “Show all items”.  Usually this filter is used to help drill down on stock which has not been sold over a time period or from a department or supplier.

J

Accessible from the POS tills (by pushing <F4>) the journal allows you to view transaction history or reprint receipts.

L

The date the item was last counted (in a stocktake).

There is also a reporting filter called “Last Counted” which allows you to restrict the report to show only items counted after this date. 

The date the item was last placed on order.

The date the item was last received on an invoice.

The date the item was last sold at the till.

Last date a stocktake was performed on the item.

A sale in which the total sales amount is paid in instalments and the item(s) deemed  not “sold” until the full amount is paid.

The total payment value received for the lay by.

The total value of any completed labs.

M

Profit margin refers to a measure of profitability. It is calculated by finding the net profit as a percentage of the price. The profit margin is calculated as follows:

[(Price - Cost) / Price] x 100

Margin differs from Markup.  Markup is the difference between the cost of an item and its selling price.

For example, if an item cost is $1.00 and its retail price is $1.50, then the profit margin would be 33.33% and the markup would be 50%.

A report filter allowing you to restrict the activities in this report to “Greater” than, “Greater or Equal” to, “Equal” to, “Less” than or “Less or Equal” to the percentage entered in the adjacent field.

Markup is the difference between the cost of an item and its selling price.

Markup differs to Margin.  Profit margin refers to a measure of profitability. It is calculated by finding the net profit as a percentage of the price. The profit margin is calculated as follows:

[(Price - Cost) / Price] x 100

For example, if an item cost is $1.00 and its retail price is $1.50, then the profit margin would be 33.33% and the markup would be 50%.

The date the object was last modified.

The date and time the stock quantity movement occurred. 

The type of movement which occurred (e.g. initial value; sales; adjustment etc.).

N

Stipulates GST is applied to the wholesale price (pharmacy pays GST to the supplier) but GST is NOT applied to the Recommended Retail Price (at retail level). See GST Helper.

This is a record of the number of times the till draw has been opened by a cashier using the “no sales” till option.

An option when selected will not allow the price to be discounted when sold at the till.

A flag set in the item stock card to prevent the item from being automatically added to a draft or an order.

The count of customers that a transaction has occurred for, during this batch period.

A reporting filter allowing you to restrict your report by nursing home(s).

O

The quantity of the item currently “on order” and expected to arrive shortly to store.

The current out of stock quantity for the item.  Click here for further information about Out of Stocks.

A report filter allowing you to restrict the activities in this report to “Greater” than, “Greater or Equal” to, “Equal” to, “Less” than or “Less or Equal” to the quantity entered in the adjacent field .

An option available from the main “Tools menu > Account > Options that control what appears on printed statements.

An option available from the main “Tools menu > Account > Options that control what appears on printed statements.

An option available from the main “Tools menu > Account > Options that control what appears on printed statements.

A report filter allowing you to restrict the activities in the report to “Greater” than, “Greater or Equal” to, “Equal” to, “Less” than or “Less or Equal” to the quantity entered in the adjacent field.

P

The pack quantity for the item.  This is configurable via the item stockcard > Inventory & Ordering > Suppliers.  This information can also be applied in bulk via Assistants > AppCAT for items and suppliers in your database matched to AppCAT. 

Q

A report filter allowing you to restrict the activities in this report to “Greater” than, “Greater or Equal” to, “Equal” to, “Less” than or “Less or Equal” to the percentage entered in the adjacent field. 

R

A report filter allowing you to restrict by a specific register(s).

S

A report filter allowing you to restrict the report to display a specific script type(s).

Self-generated number applied every time a statement is run (or individual statement) is created.

A report filter allowing you to choose the statement batch you want to report on. 

A report filter allowing you to set a date for the report to look at; this allows a “historic” look at the stock valuation at any date prior to today.

T

The GST or Tax Status of the item.