Page 1 of 1

Sales order line, adding via Supplier UPC?

PostPosted: Fri Jul 13, 2018 10:24 am
by 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?

Re: Sales order line, adding via Supplier UPC?

PostPosted: Fri Jul 13, 2018 10:28 am
by Scott.Pearce
Anything's possible using a plugin.

Re: Sales order line, adding via Supplier UPC?

PostPosted: Fri Jul 13, 2018 12:26 pm
by 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.

Re: Sales order line, adding via Supplier UPC?  Topic is solved

PostPosted: Fri Jul 13, 2018 12:33 pm
by 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.

Re: Sales order line, adding via Supplier UPC?

PostPosted: Fri Jul 13, 2018 5:36 pm
by 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!

Re: Sales order line, adding via Supplier UPC?

PostPosted: Fri Jul 13, 2018 6:39 pm
by SBarnes
Forget world peace but the free beer plugin I am sure we could get a number of contributors to work on. :lol: