Adding Warehouse to Parts in a Function vs BPM

Epicor ERP 10
,
1

I’ve written a function to:

  1. loop through the Plants associated to a Part and get all of the Warehouses.
  2. If Part and Warehouse aren’t associated, create the relationship.

But the Update method fails with error “Warehouse is required”. I’m quite stumped on what’s missing?

I created a Part service and set ds PartTableset.
Then I called the method GetNewPartWhse
Set the one field that is required WarehouseCode
Then tried to update the object it errors with “Warehouse is required.”

I verified required fields (Company, Part, Plant, Warehouse Code) are set on the pds.PartWhse.

ANY ideas on how else to root cause this issue? The trace does show at Erp.Services.BO.PartSvc.Update(PartTableset& ds) in C:_releases\ERP\ERP12.1.100.10\Source\Server\Services\BO\Part\Part.Designer.cs:line 6365

image
image635×217 10.2 KB

1 Like
2

Why not just do it as a BPM per the example?

3

Well–I may

I was trying to use a Function instead and in theory should be able to. I’ll have to rewrite the BPM looping through Plants/Warehouses to dynamically set the values. The BPM is hardcoded.

1 Like
4

You can use DMT to do a mass change to a bunch of parts if that’s what you’re trying to do. Could also setup a uBAQ as well probably.

1 Like
5

Thank you, Randy. This would need to be either a tool or BPM as engineering doesn’t have access to DMT.

6

Hi Donna,

Are you sure you’re getting a new row with RowMod = “A”? I have a function that does the same thing (albeit using mostly widgets :face_vomiting:). In between the GetNewPartWhse and Update calls I have the following:

var addedRow = dsPart.PartWhse.FirstOrDefault(partWH => partWH.Added());

if(addedRow == null)
{
    throw new Ice.BLException("Added row not found.");
}

addedRow.WarehouseCode = warehouse;

Hope this helps,

Nathan

1 Like
7

Hi Donna! Keep in mind that, when you call GetNew, it adds a new record at the end of the table. So you may need something like

pds.PartWhse[pds.PartWhse.Count - 1].WarehouseCode = sWhse;

instead of

pds.PartWhse[0].WarehouseCode = sWhse;

Working function example:

// CALL PART SERVICE
this.CallService<Erp.Contracts.PartSvcContract>(pc => {

  // define ds
  Erp.Tablesets.PartTableset tsPart = new Erp.Tablesets.PartTableset();

  // get part ds
  tsPart = pc.GetByID("YourPartNo");
 
  // add new partwhse
  pc.GetNewPartWhse(ref tsPart, "YourPartNo", "YourPlant");

  // set new whse
  tsPart.PartWhse[tsPart.PartWhse.Count-1].WarehouseCode = "YourWarehouseCode";

  // save
  pc.Update(ref tsPart);

// END CALL PART SERVICE
});
1 Like
8

Thank you!! Thank you!! That was it. The index I was using was 0. :dizzy: