Personalization, Customization and Productivity Tools

[asmith63]

It has been awhile since this was last addressed so I thought I'd give it a shot.  We want to use coupon codes in MAS200.  We would like to be able to enter a code in Sales Order Entry and have the assigned discount applied to the order.  Is there programming that can be done or third party solutions that can be applied to accomplish this? 

Using the Misc Item is not a bad idea except that you cannot set a percent off value.

Any suggestions will be appreciated.

Thanks!

[Gator]

Welcome to the forums.

What version of MAS are you on?

This can be accomplished fairly easily with User Defined Scripting (version 4.40 and up).

[asmith63]

I am on v4.4 currently.

[Gator]

This can probably be accomplished in many different ways, but based on your description this is how I would tackle it.

Create a UDT for coupon codes.  Add fields to the UDT:  description, discount type (amount/percent), discount (maybe even starting and ending dates).

Create a UDF for the Sales Order Detail for the coupon code.  The field will be validated against the UDT.  This will make it so that a lookup will be presented to the user.

Add a post validate script that will apply the discount to the line.

These ae the general steps that would have to be taken.  In practice there will probably be more scripting that have to be done (what happens when the quantity is changed after the coupon code is entered, what should happen if the user overrides the price, etc.)

EDIT:  You should probably talk to your reseller about this by the way.

[asmith63]

Thank you!  That is very helpful information. 

I will get with my reseller as he knows about scripting!

[thebottomline]

Send Connex a note here on the forum.  He has written a lot of scripts and is quite knowledgeable.

[mandm]

I just wrote a script for this exact thing for one of my customers.  It basically looks at a UDF "Coupon Code" on the Sales Order Totals tab and when the coupon is applied to the order, it pulls coupon information stored in the UDT "Coupon_Codes" and calculates the coupon amounts.

It works for all different types of coupons;

all Customers and all items,

specific customers and all items'

specific customers and specific items'

all customers and specific items'

either percentage based or amount based

if you are interested, send me a message with your contact information

Mike McNelis

e-mail me here

[Heather]

asmith63 --

There are some video links in this post, one of which is about setting up coupons in sales order.  Even if you won't be doing the scripting yourself, you might find it helpful in understanding the process.