Hi all! I am working on a BAQ to update all of our vendors to the same payment method. I first created an updateable BAQ that lists all the vendors with PMUID=0. Next, I created a custom action in the BPM to update all the results rows. I setup a dashboard to run the BAQ from, just in case I need…

I got something that seems to work at least some of the time. There must be something wrong with a few records in my vendor table. As the custom action proceeds through changing the payment method for each vendor, sometimes it still errors out with the error above. However most of the records get up…

It mostly looks fine, 2 changes that I can see. The reference in service renderer needs changed, and before changing the PayMethod you have to get the vendor record first. The GetByID returns the dataset you need, change the myVendorNum variable as needed. # code block using ( Erp.Contracts.Vendo…

[image] Joseph_Martin: Thank you for the reply. I added your modifications and the code compiled nicely. The custom action ran, and completed without error. However, the records do not get updated. Here are the changes I made based on your suggestions: foreach (var ttResults_iterator in (from …

You might have to actually change the value on dsVend and then call ChangeVendPayMethod followed by setting RowMod = “U” and then call Update. Sometimes the ChangeXXX require the dataset to actually have the change.

[image] hkeric.wci: dsVend and then call ChangeVendPayMethod followed by setting RowMod = “U” and then call Update. Sometimes the ChangeXXX require the dat I would do that with an Update by Query widget, right?

Example: [image] You see how the change is made in code to dataset and then the Change… method is called.

foreach (var ttResults_iterator in (from ttResults_Row in ttResults select ttResults_Row)) // for every line in the BAQ results do this stuff... { using (Erp.Contracts.VendorSvcContract svc = Ice.Assemblies.ServiceRenderer.GetService<Erp.Contracts.VendorSvcContract>(Db)) { var dsVend = svc.G…

No dont do it on ttResults do it on dsVend

foreach (var ttResults_iterator in (from ttResults_Row in ttResults select ttResults_Row)) // for every line in the BAQ results do this stuff... { using (Erp.Contracts.VendorSvcContract svc = Ice.Assemblies.ServiceRenderer.GetService<Erp.Contracts.VendorSvcContract>(Db)) { var dsVend = svc.G…

[image] NateS: var dsVend = svc.GetByID(ttResults_iterator.Vendor_VendorNum); Does this actually get you a record should this be Vendor_VendorID instead of Num? EDIT Nevermind it is vendorNum

Get by id wants an int. I tried with VendorID (nvarchar) first and got that error. I could try to convert from string to int. I think it gives the right record, because when I was updating ttResults, it changes the values for all the vendors in the BAQ results. At least, until the for is refreshed.

Update Vendor Payment Method With BAQ

Epicor ERP 10

NateS (Nate Schoonover) January 20, 2021, 1:11pm 5

I would do that with an Update by Query widget, right?

Update LINQ Returns using BO.Update

Topic		Replies	Views
UBAQ Not Updating Posted AP Invoice Fields Epicor ERP 10 ubaq	3	1538	September 29, 2020
There is no BPM customization attached to (BAQ) Update method Epicor ERP 10	5	5067	May 21, 2019
Run Updateable BAQ from customisation [C#] Epicor ERP 10	19	11008	June 19, 2020
Updating Buyer on all Parts by Vendor UBAQ Epicor ERP 10 e10 , baq	3	1073	October 29, 2021
BAQ - Customer Payment Method Epicor ERP 10 baq	7	1652	September 1, 2021

Update Vendor Payment Method With BAQ

Related topics