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.

STEP 1.

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

STEP 2.

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

STEP 3.

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 Custom list 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.

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.