| Section | ||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
Where Is It Found - System Table Set-up
PSSCM.MOC - Maintain Order Controls
PS Wine Club Control
Wine Club control - radio button #2
PS Wine Club Control
Ranking Wine clubs
...
When a club member quits a club they will get the default retail Price Type (TPT), Customer Type (CTY), Market (MKT) and optionally a User Defined code (UDC) from this table.
When opening menu option PSSCM.MOC you are first taken to the state control, to access the Tasting room defaults you will need to click on the blue button "Tasting Room Defaults".
(INSERT SCREENSHOT)
When a club member has quit the wine club there is a night job that will update the customers Price type, Customer type and optionally Market and User Defined codes. The job will look to this table for the Retail codes for these customers.
| Info |
|---|
Question: When a wine club member quits a wine club how does the system know which Tasting room entry in the MOC to use for the default retail codes?
|
Central Table TWC - Entering the Default Tasting Room for each wine club code
Access may be limited to your Central Tables and you may need to talk to your In house AMS administrator for assistance.
Central tables are located under SYA - System Administration, CTL - Sub System Controls, CCT - Change central table database.
Once in the central tables you will go to Table Code TWC. Here you will add your Default Tasting Room.
Final step for Set Up - Going Live
*Please use caution when changing or setting up codes in your Central Table ZZZ. If you have an questions or concerns please contact the Helpdesk.*
In the central tables you will go to Table Code ZZZ.
Likely you will add this new code by typing it directly into the Code box.
Code= PSDYNCLUB
The only information here that is needed is a "Y" in the free form data. When you are done it should look like the screenshot below.
This switch turns on the ability to enter a Price Type on the customer record of "$" and the system will automatically calculate what the correct pricing would be.
Examples
This customer belongs to two different wine clubs. The WC club gets 20% off and the 2C club gets 25% off.
This is what the customer master would say if "$" was entered in the Price Type field and Dynamic Pricing is turned ON.
Since the 2C club gets a higher discount and the ranking for the 2C club is higher than the WC club, it will use the pricing for the 2C club and not the WC club.
If the customer quits the 2C club, the system will automatically change the customer back to get the appropriate discount and change the customer type as needed.
The following screenshot will show you what occurred on page 2 of the customer master when she quit the 2C club.
- If this customer quit all Wine Clubs they are enrolled in the "$" will stay in the customer record but it will show they are now at a Retail price.
- It will also change their Customer Type to the default code defined in the MOC - Tasting Room defaults.
| Info |
|---|
Pricing Tip: How Price Type Code connects to Price Class Code The Pricing is set up by a combination of Tasting Room (TRM) and Tasting Room Price Type (TPT) codes and defined in the Tasting Room Price Class Translation (TPC) as to which Price Class (PRS) code to use.
|