To support Discounting by Product Group or Brand the WMS uses the Special Pricing Schedule (SPS) and NONINVENTORY items that identify the Brand/Group being discounted.

Allocate brands as custom list fields (you must only user CUSTOMLIST#1)

Items are associated with a BRAND or GROUP using CUSTOMLIST#1. The field chosen in CUSTOMLIST#1 indicates the BRAND or GROUP of the item.

For example you could have a CUSTOMLIST option of ALine or DATAPEL as your product group or as a brand.

Create brand group items

To allow discounts to be APPLIED in a MULTI “Special Pricing Schedule” (SPS) a NON-INVENTORY ITEM is created with its ITEM NUMBER as the CUSTOMLIST Brand or Group field name. The item name is usually set to read BRAND or GROUP ITEM.

IMPORTANT: CUSTOMLIST#1 and the ITEM NUMBER must be an exact match for the Item to be recognized as a BRAND / GROUP identifier.

Detail Steps


Open MYOB – login to your company file. Select the LISTS menu then click Custom Lists and Field Names, now click the Items Tab.


It is recommended that Custom List #1 be replaced with BRAND or GROUP.


Again select the LISTS menu then click Custom Lists – Items. Here you create all possible Brand or Group labels that will be used in associating items with Brands or Groups.

STEP 4. For each of these LIST ITEMS, a NON-INVENTORY BRAND/GROUP item must be created. Remember that the Item Number must correspond with the Custom List#1 selection.

* Item Customlist and Item number must match 

* The Brand/Grouping Item should have a price set to $0.

Step 5:Start replication to bring over the cards to WMS. This feature requires the optional Special Pricing module for WMS.

Anything that doesn't fit into a brand category that needs the discount needs to go into something such as OTHER.


.Datapel do not recommend to amend Special Price Quotes  #Phone1 field in MYOB as this might affect reporting information. Please consult your form/report developer before amending any information.

Related Information

Brand items are now treated as any other item in the creation of SPS – MULTI. Note that Quantity should be 1 as ONLY a PERCENTAGE is used for BRAND/GROUP discounts - the sell price should be set to zero to save confusion when running MYOB Reports.).

This feature requires the optional Special Pricing module for WMS.