Populating custom field up on VendorID field in the Create Purchase Order (PO505000)

Is there a reason you are using fieldupdated, but trying to update all of the rows when only one of the rows’ vendor is updated? It seems like you might want to only be running this for the specific row you are on instead of looping through all of them?

Is the code hitting those lines where you set your usr field values, and do the soLineExt fields have value?

You could also try using setvalueext and see if that gives you any different result. Other things you could try is using field selecting if you don’t need to update the field value, or using attributes, as it looks like the source code for POFixedDemand VendorLocationID uses attributes to default the value based on the vendor, you could look at mimicking that logic if all else fails.

​@josiahl64 

In our scenario, we have items in the PO Fixed Demand grid where:

• Some items (e.g., AMDOORSH01) are configurable, and

• These configurable items do not default the VendorID automatically.

To handle this, I wrote a FieldUpdated event handler on the VendorID field.

Here's the logic I'm implementing:

• When a VendorID and Vendor Location are selected on one of the lines with the same UsrParentLineNbr,

• The system should automatically apply the same VendorID and Location to all other lines that share the same UsrParentLineNbr.

• In addition, we also want to default:

  • ShipTo

  • Shipping Location

  • Shipping Destination Type (this should be "Vendor" by default)
    
    using the FieldUpdate event its only defaults on the selected line.

​@josiahl64 

In our scenario, we have items in the PO Fixed Demand grid where:

• Some items (e.g., AMDOORSH01) are configurable, and

• These configurable items do not default the VendorID automatically.

To handle this, I wrote a FieldUpdated event handler on the VendorID field.

Here's the logic I'm implementing:

• When a VendorID and Vendor Location are selected on one of the lines with the same UsrParentLineNbr,

• The system should automatically apply the same VendorID and Location to all other lines that share the same UsrParentLineNbr.

• In addition, we also want to default:

  • ShipTo

  • Shipping Location

  • Shipping Destination Type (this should be "Vendor" by default)
    
    using the FieldUpdate event its only defaults on the selected line.

I don’t see in the code you originally shared where you are updating the other vendor/locations for the other lines, but if you are indeed doing that, it sounds like you could potentially have an infinite loop if you don’t have the correct conditions, and that could be why it isn’t updating as expected.

Have you gone in to debug and verify that it is indeed looping through and finding each line?

 

Hi ​@josiahl64  User will select the VendorID  for the configurable Item so, that it should default Vendor Name and  Location in the code line 331 i  have set if condition Usrconfigurable = true. In the method updateudf() i have checked parentlinenbr and Issupplemental  = true at line 357 then its defaulting the VendorId and Vendor Location to Shipto and ShiptoLocation. The debugger was attach an defaulting on values in the above screen shot but its not updating in the View FixedDemand. If i write on the rowselected then its only defaults on the selected line.There was a mistake above i was not trying to default 
 

There was a mistake here “The System should automatically apply the same VendorID and Location to all Other lines that share the same UsrParentLineNbr” meaning VendorID and Location of the configurable item should default on the Shipto and ShiptoLocation which has same ParentLineNbr.

Hi ​@HarikanthMantri,

Have you checked below forum?

Hope, it helps!

​@Nilkanth Dipak  Thank you for looking at the issue. yes i have checked the forum but that is different from what actually im facing the issue.

​@darylbowman Yes, i have tried in the RowSelected event that doesn’t works.

Not the same