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