MRP and Customer Part Numbers

[jkane (John Kane)]

Wait, Customer Number is not a native field in Job Entry. Did you check to see if it was added to the screen?

[bruce6s (Bruce Crile)]

I tried a couple of different combinations going through MRP and was not successful in getting it to populate the Customer Number. I did use the Order Job Wizard to create Job and it did pull the Customer Number into the Job. Is it possible that the old Jobs had been created using the Order Job Wizard?

[jhecker (Jason Hecker)]

@bruce6s

Is it possible that the old Jobs had been created using the Order Job Wizard?

The jobs were created with MRP based off of the Sales Order demand that comes in through EDI.

Those Unfirm jobs are then firmed up and put into production.

[hkeric.wci (Haso Keric)]

@jhecker

SELECT * FROM Erp.Part WHERE PartNum IN (SELECT XPartNum FROM Erp.CustXPrt WHERE CustNum = 23)

It will not set it as PartNum. Run this

SELECT * FROM Erp.JobHead WHERE XRefPartNum IN (SELECT XPartNum FROM Erp.CustXPrt WHERE CustNum = 23)

[jhecker (Jason Hecker)]

@hkeric.wci

SELECT * FROM Erp.Part WHERE XRefPartNum IN (SELECT XPartNum FROM Erp.CustXPrt WHERE CustNum = 23)

There is no XRefPartNum in the Erp.Part table though.

[hkeric.wci (Haso Keric)]

Meant JobHead oops.