Sales order line, adding via Supplier UPC?

[DannyC]

Hi,

Reading DEV-5112 I see we can add a line to a sales order via UPC, IN_Main.Aux2. Tested & working well in 7.0.175.

I have a client who's asked if it can look at Supplier UPC as well? Their scenario is the product barcode is not universal. As a result, each supplier has a different UPC for the same widget. When it comes time for scanning the barcode at POS, they want to be able to get the widget on the SO line. Bottom line is they need to search through both IN_Main.Aux2 and also IN_Creditor.SupplierUPC. Possible?

[Scott.Pearce]

Anything's possible using a plugin.

[SBarnes]

Hi Danny

If this is using the sales order form try using the event FormDoPartNoSearchBefore then client cancel exception to stop Jiwa and do what you want.

[Scott.Pearce]

Here's a plugin that jumps in at grdLines_Change and attempts to resolve what was entered to a part no based on the entered text being a supplier UPC. If it resolves OK, the part is added, client cancelled is thrown, and the job is done. If it does not resolve OK, then standard behaviour occurs.

[DannyC]

Anything's possible using a plugin.

World peace? Lifetime free beer?

Fortunately neither required at this moment. But I'm still happy - your plugin works!

[SBarnes]

Forget world peace but the free beer plugin I am sure we could get a number of contributors to work on.