BPM help: Fill in VendorID for material

Hi all,

 

I am trying to write a bpm to fill in VendorID and PurPoint.  QuoteMtl.Purpoint populates fine, but QuoteMtl.VendorID does not exist as a field.

 

I was thinking of querying the Vendor table, but I can't figure out how to do that...

 

My BPM is for QuoteAsm.GetMtlPartInfo

Post Processing

 

------------------------------------------

 

for each ttQuoteMtl where ttQuoteMtl.PurPoint = "".

if avail ttQuoteMtl then do:

                for first Part where Part.Company = ttQuoteMtl.Company and Part.Partnum = ttQuoteMtl.PartNum and Part.QtyBearing = TRUE and Part.nonstock = FALSE.

                if avail Part then do:

                                find first PartPlant where PartPlant.Company = ttQuoteMtl.Company and PartPlant.Partnum = ttQuoteMtl.PartNum no-lock no-error.

                                if avail PartPlant then Do:

                                ttQuoteMtl.VendorNum = PartPlant.VendorNum.  /* This does not work */

                                ttQuoteMtl.PurPoint = PartPlant.PurPoint.  /* This works */

end.

end.

end.

end.

end.

 

-----------------------------

 

The reason I need to write this BPM: stock items manually added to MOMs do not populate vendor info.  Vantage 8.03.409A.

 

Any help would be appreciated.

 

Thanks,

Dan

 

 

This email has been filtered by SMX. For more information visit smxemail.com