Special Pricing - Brand Discount

Created by Datapel Integration, Modified on Fri, 6 Jun at 4:18 PM by Datapel Integration

Description

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

This feature requires the optional Special Pricing module for WMS.
Ensure the SPS tag is switched on in Prefs.xml <WMSAsSPSSource>True</WMSAsSPSSource> (done by Datapel Support)
Ensure that SPS is also switched on in Preferences (Sales tab) under "Use Special Pricing Schedules (SPS)"
Special price uses best price , lowest price.
If the same Item involved in two or more SPS setups then if any setup price set to 0 price and/or 0 discount then WMS will default to Base Sell Price. To resolve this issue please amend/delete zero value line or put 100% discount to give for free to re-calculate correct price.

NOTE:

Tools > Preferences > Sales setting - "Always use Item Special Price if available".

When this option is ON, Best price is ignored and the priority is individual Customer in special pricing then Group pricing.

For example:
Item Standard price = $800.00
SPS for the customer = $1000.00
SPS for the customer Group = $500.00

If "Always use Item Special Price if available" is ON, the customer sales will be charged $1000.00
If "Always use Item Special Price if available" is OFF, the customer sales will be charged $500.00

Detail Steps

Create brand group items

To allow discounts to be APPLIED 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.

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

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

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.

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.

5. Apply Brand to all your required stock Items.

6. Open WMS.

7. Perform Maintenance Replication.

Related Information

Setup in WMS