Any help on the following would be greatly appreciated.
Background: trying to find a way to account for landed costs when using WMS! This triggers multiple item receipts (IR) per PO.
We have dismissed using Inbound shipments (too flaky/unsupported)
We are therefore trying to use estimated landed costs. Everything set up as should be. All works fine in testing via UI. HOWEVER - the "calculate estimated landed costs" field (CELC) on the IR is not copied across from the PO when creating an IR via the mobile app. Support have confirmed this behaviour is as expected! This means the landed cost estimate is not triggered. We can manually open the IR in edit mode and set the CELC field to Yes and everything then works as expected. Naturally I cannot do this manually with 1000s of IR.
I couldn't find a way to do this with mass update. I also cannot find a way to update IR using CSV import.
Therefore trying to create a workflow to therefore set this after the IR has been created.
Best attempt to date is via a scheduled workflow using a search (IR where landed cost template exists on the record but CELC field = No). This makes use of a sublist action group to set field value
I can see the workflow has initiated on the IR - but I get the following error message: "SETFIELDVALUE [Warning: Value cannot be set to a missing field.]"
I have tried creating a custom form and making the CELC visible on the form with no effect.
If I open the IR I can see the field.
Any suggestions welcome
Sandra