v6-SOP-Any way to limit an item on sales order to only once 1

[markajem]

We are running v6 GP

Is there any way to limit that an item can only be placed on a sales order once and not multiple times. Non of our customers order the same item more than once with different ship dates on the same order. We would create separate orders. The only time the same item would appear on the same sales order is by human error. Because we have a WMS many of the items on an item are picked by different people.

I looked in Sales Order Proc setup but dont see any options like that.

Thanks

 

[jazgeek]

There isn't any way to prevent it short of custom programming. However, you could manage it by a trigger on insert into the SOP10200 table looking for duplicates in the same order and email your order entry person(s) with that information.



-----------
and they wonder why they call it Great Pains!

jaz

 

[markajem]

Thanks Jaz I will suggest this.

 

[winthropdc]

Do you have access to VBA?

It would be fairly easy to add code to the Item Number user changed event and perform a quick SQL select statement to check if the Item Number has already been saved as a line for the current transaction.

You would need to use RetrieveGlobals to get the login credentials and then ADO to connect to SQL.

If you have access to Dexterity, similar code can be written.

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer
MBS Support - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

 

[winthropdc]

Examples of using the DUOS are available from PartnerSource and CustomerSource.

Just search for "Sample Applications" and look at the VBA samples for your version.

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer
MBS Support - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.