Item Restrictions by Ship To

JMast

Reputable Poster
Hello All,

There may be solutions at an application level or a developer level so I am posting this to both Applications and Developers, and I apologize to those of you who prowl both forums.

We need a way to prevent certain liquids (and in some cases specific sizes of a liquid) from being shipped into certain states. I will use California as the example.

Item Restrictions is currently driven by Sold To during Sales Order Entry. It works fine if all the Ship Tos are in CA and we can be sure that no future Ship Tos will be outside CA.

However, we have many customers with Ship Tos in various states, so Sold To restrictions will not work unless we are willing to turn away customers in non CA states. That, of course, is definitely not acceptable.

I read on the List that there are ways to do this if the customers can be grouped and Advanced Pricing records created. We are already using Advanced pricing and customer price group to drive discounts in pricing for all customers. Is there a way to add another grouping at the customer level?

If there are other solutions out there, even if it means a high level of what a mod would be in P4210, I would greatly appreciate it.

I hope all in the US have a fun and safe holiday on Monday.

Thanks for your time,

Jer
 

andyklee

Reputable Poster
Try looking up JDEtips on YouTube. You can definitely do this by ship to
with Advanced Pricing. If you want the article as well, let me know.



http://www.youtube.com/results?search_query=jdetips





Andy

www.JDEtips.com





From: [email protected] [mailto:[email protected]] On
Behalf Of JMast
Sent: Friday, May 28, 2010 8:24 AM
To: [email protected]
Subject: Item Restrictions by Ship To



Hello All,

There may be solutions at an application level or a developer level so I am
posting this to both Applications and Developers, and I apologize to those
of you who prowl both forums.

We need a way to prevent certain liquids (and in some cases specific sizes
of a liquid) from being shipped into certain states. I will use California
as the example.

Item Restrictions is currently driven by Sold To during Sales Order Entry.
It works fine if all the Ship Tos are in CA and we can be sure that no
future Ship Tos will be outside CA.

However, we have many customers with Ship Tos in various states, so Sold To
restrictions will not work unless we are willing to turn away customers in
non CA states. That, of course, is definitely not acceptable.

I read on the List that there are ways to do this if the customers can be
grouped and Advanced Pricing records created. We are already using Advanced
pricing and customer price group to drive discounts in pricing for all
customers. Is there a way to add another grouping at the customer level?

If there are other solutions out there, even if it means a high level of
what a mod would be in P4210, I would greatly appreciate it.

I hope all in the US have a fun and safe holiday on Monday.

Thanks for your time,

Jer

E1 8.0 SP23_ZA1, Win2003, SQL Server 2005 SP3, all fat client

_____


The entire
JDELIST thread is available for viewing.


Looking for a job? Check out the Job
forum


This is the JDELIST EnterpriseOne Developers Mailing List.
JDELIST is not affiliated with JDEdwardsR.

To unsubscribe from this list via email, Click
<mailto: [email protected]?Subject=Unsubscribe&Body=Sirs,

P
lease remove this address from the JDELIST EnterpriseOne
 

JMast

Reputable Poster
Re: RE: Item Restrictions by Ship To

Andy,

Wow, that was easy. I didn't know you could use Item category codes in Advanced Pricing. I had focused on the Customer Price Group and forgotten that we have a couple Address Book codes being used for specific pricing programs.


The video is a great idea for quickly showing something straightforward like that.

Thank you for the help and quick response,

Jer
 

WhippingBoy

VIP Member
In Adv Pricing you would use 'mandatory adjustments'. Create a Sold To customer group and use this to list the customers that are allowed to purchase the material.
 
Call Orchestrations From Excel – The Easy Way to Make the Orchestrator Work for You.
Top