ID

Column

Description

ALLOC

Allocated Quantity

The quantity to immediately allocate (reserve) on back order.

Sales orders only.

STALLOC

Allocated Stock

The quantity of stock already allocated (reserved).

Purchase orders only.

NAME2

Alternate Product Code

This column can be used to find products based on the entry contained in the Alternate field.

FREESTOCK

Available Stock

The quantity of stock available for sale.

BQTY

Back Order Quantity

The quantity to place on back order.

Invoicing only.

BORDER

Back Ordered Stock

The quantity of stock already on back order.

Purchase orders only.

BOHOLD

Back Order Held Stock

The quantity of stock on back order hold.

Purchase orders only.

BOXLIST

Box List Price

The list price of the line item in the box unit of measure. If the item is not sold in a box unit of measure the standard list price is displayed instead.

For more information on box quantities see: Dimension Based Pricing.

Invoicing, sales orders & quotes.

Cqty

Credit Quantity

The quantity to credit (return) into stock. This column is equivalent to entering a negative quantity in the Qty column.

Invoicing only.

Carrier

Carrier

The carrier code of the stock item. If not specified this defaults to the transaction's carrier code. The carrier code may be assigned automatically if the Carrier Management system is used. It is only recommended that you specify a carrier if you want to override the default carrier assignment.

Invoicing only.

CUSCODE

Customer Account Code

The customer account code assigned to the item that is being returned for repair.

Stock Returns Only.

CUSPCODE

Customer Product Code

You may view or enter your customer's product code using this column. For more information consult the topic: Customer & Supplier Product Codes.

Available for invoicing, quotations, sales orders and customer related transactions.

This column is available in the Enterprise & Corporate Edition Only.

LASTSELL

Customer's Last Sell Price

The unit sell price the item was last sold to this customer for.

Invoicing, sales orders and quotations only.

DISCOUNT

Discount Description

The description of the discount.

DIMCOST

Cost Price

The cost price. If the item is sold by a dimension, this is the cost per dimension (e.g., cost per metre) otherwise if no dimension has been set-up, it will be the cost per unit or piece.

DIMQTY

Box Dimension Quantity

The box dimension quantity. For more information on box quantities see: Dimension Based Pricing.

DELIVERY

Delivery Date

The item's expected delivery date.

Purchase Orders Only.

TITLE

Description

The product description.

DISC

Discount %

The product's discount percentage off the item's sell price.

LISTDISC

Discount Off List Price

The product's discount percentage off the item's sell price.

DIMENSION

Dimension

The product's dimension. For more information on dimension conversion factors see: Dimension Based Pricing.

ESTRETDATE

Estimated Return Date

The estimated return/repair date of the item (if known), when repair details are being recorded against it.

Stock Returns Only.

EXCISE #1

Excise Value

The stock item's first excise/duty or charge.

EXCISE #2

Excise Value

The stock item's second excise/duty or charge.

EXCISE #3

Excise Value

The stock item's third excise/duty or charge.

EXTENSION

Extension

The price extension. This is the unit price multiplied by the cost price for purchase orders, stock returns and stock receipts, and the sell price for invoices, sales orders and quotations.

EXTTAX

Extension + Taxes & Duties

The price extension including applicable taxes and duties. This is the unit price multiplied by the sell price.

Invoicing Only.

GLCODE

General Ledger Code

If the general ledger is activated this column becomes available. You may assign general ledger codes to stock and non-stock items. The general ledger code will replace the default sales account code of the transaction's line item.

INVOICENO

Invoice No. Ref

The invoice number this purchase ordered item refers to. This is used to indicate when a purchased item is for a specific invoice/customer.

Purchase Orders Only.

JOBNO

Job No. Ref

The job number to assign (transfer) stock to when a purchase order is delivered.

Purchase Orders Only.

Also cosult the topic: Service Manager Purchase Transfer.

LASTBUY

Last Buy

Last unit purchase price paid for a stock item.

LEADTIME

Lead Time

The lead time in days for this product.

LOCATION

Location

The stock item's location.

LINETYPE

Line Type

Describes the transaction line item's type. For example, if the item was hired out, the entry next to the line item would read 'Hire'.

LISTPRICE

List Price

The list price of the line item in the standard unit of sale.

MARGIN

Margin (ex) %

The margin ex tax as a percentage.

MARKUP

Mark-up (ex) %

The mark-up ex tax as a percentage.

MEASURE

Measure

The unit measure.

NEXTDEL

Next Delivery Expected Date

The next expected purchase order delivery date of the selected stock item.

ORDERNO

Order No. Ref

The order number this purchase ordered item refers to. This is used to indicate when a purchased item is for a specific sales order/ customer.

Purchase Orders Only.

OQTY

Ordered Quantity

The total quantity ordered including the quantity sold and the quantity placed on back order.

Invoicing Only.

STOCKIN

Physical Stock

The quantity physically in stock.

PCODE

Product Code

The stock item's product code, part number or main reference code.

PURCHMIN

Purchase Unit Minimum

The minimum supplier purchase quantity for this stock item.

QTYDELOLD

Qty Delivered Previously

The quantity previously delivered on this purchase order.

Purchase Orders Only.

QTYDELNOW

Qty To Deliver Now

The quantity to now deliver when the Stock It! button is pressed on the purchase order. This column only applies to purchase order delivery mode.

Purchase orders only.

QTY

Quantity Sold

The quantity being sold.

QTYPUTAWAY

Quantity Put Away By Warehouse

The quantity that has been counted by warehouse staff when the items relating to the purchase order were received. This column only applies when the Warehouse Manager is in use.

RECVQTY

Receive Qty

The quantity received back from your supplier relating to repairs.

Stock Returns Only.

REF1

Ref #1

Reference #1. This can contain up to 20 characters of information.

REF2

Ref #2

Reference #2. This can contain up to 20 characters of information.

RETDATE

Repair Date

The date the item was repaired/returned.

Stock Returns Only.

REQUIRED

Required

The date required for warehouse picking and packing.

Sales orders only.

RANUM

Return Authorisation Number.

Your supplier's return authorisation number/reference.

Stock Returns and Stock Receipts Only.

SELLPRICE

Sell Price

The sell price. If the item is sold by a dimension, this is the sell price per dimension (e.g., sell price per metre) otherwise if no dimension has been set-up, it will be the sell price per unit or piece.

ONORDER

Stock Already Ordered

The total quantity of stock already on order.

Purchase orders only.

STOCKID

Stock ID

The Stock ID. This is a unique 7 digit code assigned to every stock item in Stock Control.

SUPPCODE

Supplier Product Code

You may view your supplier's product code using this column. For purchase orders, stock returns and stock receipts, you may also use this column to directly enter your supplier's product code.

For more information consult the topic: Customer & Supplier Product Codes.

This column is available in the Enterprise & Corporate Edition Only.

RINVOICE

Tran No.

The transaction number of the sale relating to this return/repair. (Stock Returns).

The transaction of the stock return that the repaired item was sent out on. (Stock Receipts.)

Stock Returns and Stock Receipts Only.

COST

Unit Cost Price

The unit of stock cost price. Unless Dimension Based Pricing is used this is the same as the cost price. With this column the cost price is always shown by unit, regardless of the dimension.

SOLDFOR

Unit Sell Price

The unit of stock sell price. Unless Dimension Based Pricing is used this is the same as the sell price. With this column the sell price is always shown by the unit, regardless of the dimension.

Stockgroup

Stock Group Name

The description of the stock item's stock group.

TAX

Tax Rate

The tax rate code applied to the line item.

TAXCHARGE

Tax Amount

The total tax amount in dollars and cents for this line item.

WARRANTY

Under Warranty

When recording repair details on a stock return, this column is used to indicate if the item is under warranty cover or not.

Stock Returns Only.

VOLUME

Volume

The unit volume of the item.

WDATE

Warranty Date

The sale or purchase date of the stock item if under warranty.

Stock Returns Only.

WEIGHT

Weight

The unit weight of the item.

Zone

Zone (of delivery)

The delivery zone the stock item is assigned to. This is normally assigned automatically if the Delivery Zonesystem is used. It is only recommended that you specify a zone code if you want to override the default zone assignment (if applicable).

Invoicing only.

Line Number

The line number of the transaction. The first item on the transaction is 1, the second 2, and so on.