We booked, shipped and invoiced a sales order with a valid part number. It wreaked some havoc. Is there a setting in Company Configuration that would require a valid part number in sales order entry? I looked all over to no avail. Thanks in advance, Randy Weber

I don’t know of any setting out of the box that would do this. You could easily address this through a BPM on the ChangePartNum or ChangeRevisionNUm method.

there is not. Epicor will allow you to add a part on the fly in the sales order, make it direct or purchase it direct to the order, ship it and invoice it If you do not want that to happen you will have to write a simple BPM when the part is not part of your part master to pop up a notice to the…

i used a method directive, salesorder.masterupdate here’s the code i wrote. you can remove the part revision portion. you can modify to check the part table. Erp.Tables.Part Part; Erp.Tables.PartRev PartRev; Erp.Tables.Company Company; // check if they are adding a line foreach (var ttOrderDtl…

I tried the code and I get a CS0103 The name ttOrderDtl does not exist in the current context. I will try to debug it, but if I could get pointers on what to fix to make it work I would appreciate it. Thank you!

What version of Epicor are you on? That might be the issue. Please create a new thread as this one is a bit old to resurrect.

[image] Replace ttResults for Kinetic Kinetic ERP It’s different in each screen. BAQ stuff is queryResultDataset.Results. Data Directive is still ttTable Method Directive is ds.Table So annoying trying to remember which one to use. try ds.OrderDtl

thank you Seems I have to use Db in our coding. I will debug trying to compare what was coded for other methods. At least the code provided in this thread will get me started.

db is the database itself. ds is the dataset from the client.

So here is my final code that seems to be working fine after a few tests : foreach (var sod in ds.OrderDtl.Where(od => od.RowMod == "A" || od.RowMod == "U")) { // Vérifier si le PartNum dans OrderDtl est valide var part = Db.Part.Where(p => p.Company == sod.Company && p.PartNum == sod.Part…

Prevent Sales Order without Valid Part Number

Epicor ERP 10

knash (Ken Nash) May 15, 2024, 1:55pm 8

try ds.OrderDtl

Topic		Replies	Views
Preventing misc. parts on Sales Orders Vista/Vantage 8 salesorder	3	617	March 5, 2020
Partnumber should not be the same for all the order entry Epicor ERP 10 salesorder	9	780	March 13, 2024
Parts on the fly Epicor ERP 10 e10 , customization	10	2512	August 18, 2025
Get Kinetic ERP	10	629	February 10, 2023
BPM on Sales Order Question Epicor ERP 10	6	655	October 25, 2018

Prevent Sales Order without Valid Part Number

Related topics