Edit

Products (Items)

Internal name Product

FieldTypeSizeNotes
BarCodeT19The item's barcode. This can be used in transaction entry instead of the product code
Build....Subfile: Refer to Build file
BuyPriceNThe undiscounted buy price of one buy unit of the item (in the currency of the purchase). This is updated automatically by MoneyWorks if "Update price whenever purchased" option is on
BuyPriceCurrencyT3The currency of the last purchase of the item
BuyUnitT5The units in which you buy the product. e.g. "ea", "kg", "ml", "dz". If the buy units are different from the sell units, you must supply a scalar conversion factor in the ConversionFactor field that will convert from buy units to sell units.
BuyWeightNThe weight/volume of the buy unit of the item
Category1T15Any value. This can be used for analysis purposes.
Category2T15Any value. This can be used for analysis purposes.
Category3T15Any value. This can be used for analysis purposes.
Category4T15Any value. This can be used for analysis purposes.
CodeT31The product code.
COGAcctT13Cost Of Goods account. If you only buy the product, this is the Expense account that is debited each time you purchase this product. If you stock and sell the product, this account is debited when you sell the product.
ColourNThe colour of the product record (not necessarily of the actual product), represented internally as a numeric index in the range 0-7 but rendered as a textual colour name
CommentT1020Any additional information about the product.
ConversionFactorNThis is used to calculate the number of sell units that equate to one buy unit. When you purchase product, the quantity purchased is divided by this conversion factor to calculate the number of selling units of stock on hand. Note that the reciprocal of the conversion factor is displayed on the product entry screen.
CostPriceNThe standard cost of the item. For purchased items, this is the purchase price (adjusted for discount if any) converted to the base currency.
Custom1T255For your own use
Custom2T255For your own use
Custom3T15For your own use
Custom4T15For your own use
Custom5T15For your own use
Custom6T15For your own use
Custom7T15For your own use
Custom8T15For your own use
DescriptionT255The name of the product.
FlagsNSee Product Flags table below
HashNFor fast searching of products by buy/sell/stock. A bit is set for each status: If buy, #0002; if sell, #0004, if inventory, #0008, Thus all inventoried items will have Hash >= 8.
JobPricingModeNSell price determinator for job costing: 1 = Use Product Sell Price, 2 = Apply Job Markup to Standard Cost, 3 = Use Undiscounted Purchase Price
LastModifiedTimeSDate and Time the record was last modified
LeadTimeDaysNThe expected lead time e for the delivery of the product
MarginWarningNThe minimum margin/markup level for the product below which to show a warning on the Selling Price screen
MinBuildQtyNThe minimum build quantity--items must be built in multiples of this
NormalBuildQtyNThe normal build/reorder quantity
PlussageNAmount to add to the purchase price for margin calculations within the product sell matrix. Not included in the costs maintained by MoneyWorks
QtyBreak1NQuantity at which the first break price is used
QtyBreak2NQuantity at which the second break price is used
QtyBreak3NQuantity at which the third break price is used
QtyBreak4NQuantity at which the fourth break price is used
QtyBrkSellPriceA1NThe A sell price, if the quantity is greater than or equal to QtyBreak1
QtyBrkSellPriceA2NThe A sell price, if the quantity is greater than or equal to QtyBreak2
QtyBrkSellPriceA3NThe A sell price, if the quantity is greater than or equal to QtyBreak3
QtyBrkSellPriceA4NThe A sell price, if the quantity is greater than or equal to QtyBreak4
QtyBrkSellPriceB1NThe B sell price, if the quantity is greater than or equal to QtyBreak1
QtyBrkSellPriceB2NThe B sell price, if the quantity is greater than or equal to QtyBreak2
QtyBrkSellPriceB3NThe B sell price, if the quantity is greater than or equal to QtyBreak3
QtyBrkSellPriceB4NThe B sell price, if the quantity is greater than or equal to QtyBreak4
ReorderLevelNThe stock level at which a reordering warning should be given. (in selling units)
SalesAcctT13The Income account that is credited whenever the product is sold.
SellDiscountNThe percentage discount. This is used only if the discount mode is 1 or 3
SellDiscountModeNA number representing the discount mode as selected in the discount mode pop-up menu in the product entry window. 1=None; 2 = by customer; 3 = by product; 4=Add
SellPriceNThe "A" sell price at which you sell the product. This is GST exclusive and exclusive of any discount that you may apply.
SellPriceBNThe B sell price (before GST and discounts)
SellPriceCNThe C sell price (before GST and discounts)
SellPriceDNThe D sell price (before GST and discounts)
SellPriceENThe E sell price (before GST and discounts)
SellPriceFNThe F sell price (before GST and discounts)
SellWeightNThe weight/volume of one sell unit
SellUnitT5The units in which you sell the product. e.g. "ea", "kg", "ml", "doz"
StockAcctT13The Current Asset account that is debited whenever you buy a product that you stock and is credited whenever you sell it.
StockOnHandNThe total number of items of stock of the product that you have on hand. This is represented in the selling units for the product. Use the SOHForLocation(location) function for the stock at a given location
StockTakeNewQtyNThe total entered stock count for a stock take. Use the StocktakeNewQtyForLocation(location) function for the entered stock count at a given location
StockTakeStartQtyNThe total stock on hand when a stock take is commenced. Use the StockTakeStartQtyForLocation(location) function for the commencing stock at a given location
StockValueNThe value of the stock on hand (based on purchase cost)
SupplierT11The supplier code of your usual supplier. If present, this should be the code of a supplier in the names list.
SuppliersCodeT19The product code that your usual supplier uses to refer to the product.
TaggedTextT255Scriptable tag storage
TypeT1P = product; R = resource; T = time; S = ship method; O=other.
UseMultiplePricesBTrue if using multiple sell prices
UserNumNUser Defined
UserTextT255User Defined

Product Flags

Use TestFlags(), Setflag(), and ClearFlag() functions for flags.

We buy it 0x00000002Price C is Tax Inclusive0x00000080
We sell it0x00000004Price D is Tax Inclusive0x00001000
We inventory it0x00000008Price E is Tax Inclusive0x00002000
Job Cost is Tax Inclusive0x00000010Price F is Tax Inclusive0x00004000
Append Salesperson - Expense0x00000020Price D is Cost Plus0x00010000
Append Salesperson - Sales0x00000040Price E is Cost Plus0x00020000
Price Break on Additional Units0x00008000Price F is Cost Plus0x00040000
Reorder Warning0x00000100Price D is Discount0x00080000
Price A is Tax Inclusive0x00000200Price E is Discount0x00100000
We Build it0x00000400Price F is Discount0x00200000
Auto-Build Item0x00000800Do not update Buy0x00400000
Price B is Tax Inclusive0x00000001Item has serial number0x01000000
Item has batch/lot number0x02000000
Batch/lot expires0x04000000