Primary Bin UBAQ

[deschultz (Doug Schultz)]

I am attempting to create an Updatable BAQ to update the Primary Bin in the PlantWhse table.

The business object for the update is erp.PlantWhseSearch and the Update Method is UpdateExt.

When I run the UBAQ it returns a list of values, allows me to double click on a row and update the Primary Bin value.

However, when a select Update I receive the following error:
Severity: Exception, Table: PlantWhseSearch, Field: , RowID: aa079fd4-d1df-42b3-86c9-50273a7b90e8, Text: Object reference not set to an instance of an object.
Query returned 1 row(s).

[ckrusen (Calvin Krusen)]

Does the uBAQ include all the indexes and keys required?

[Banderson (Brandon Anderson)]

If you do a trace, It uses the part update BO and method. I don’t think the UpdateExt will work for PlantWhse updates (it will come back without and error, but it won’t actually change it).

I think for this to work, you might have to call he method in in advanced BPM and do it manually.

And as you can see from previous attempts, it’s not trivial.

UBAQ to update Primary Warehouse and Bin

I’m trying to create an updateable BAQ for users to be able to set or modify the primary warehouse and bin. I see that the fields aren’t DB fields, so I’m trying to use the advanced BPM to write a base processing directive to use the BO and update the data set, but I’m getting an out of range error. Can someone point me in the right direction? Here’s the code I’m running on base: foreach(var r in ttResults.Where(r => r.Updated())) { using(var partBO = Ice.Assemblies.ServiceRenderer.GetServi…