Alert of an existing sales order for same client?

Question

Hello, 
 We deal with 100's of counterparts in retail in the US. Some sends us several purchase orders per week and we wanted to find a way to aggregate these orders and have one shipment instead of multiple so to save on shipping costs...and the environment! 
 In Sage 100, when creating a SO and selecting a Ship To is there a way for the system to alert us that another SO is still open in the system for this particular ShipTo? I insist on the ShipTo as we deal with stores chains...so the client (billing entity) is the same but the ShipTo address obviously would be key here. 
 Thanks for any guidance! 
 Nicolas.

glrickert · Answer

You could setup the customer numbers by ship to address, for example: ABC TEXAS, ABC NYC, etc... Billing would be same for all, SO would now be grouped by Customer/ship to and SO Entry staff could easily review and group other orders due same location.

David Speck · Answer

Do you use the standard CustomerPONo field? 
 If not, then you could have the users throw the ship to in there and then enable this option. 
 
 You may or may not want to also check the one for Invoice Data Entry. 
 If you do use the CustomerPONo field then either of the other suggestions are possible solutions. 
 If you go the route of having a customer number for each ship to, then you can teach the users to use the sales order lookup to see if there is already an order for the customer and ship to combination.

Sage 100

Alert of an existing sales order for same client?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING