Is it possible to update an item fulfillment either via workflow or csv to include a custom segment? A custom segment was missed on the sales order which has now been updated but we want to fix this on the IF as well so that it flows through natively for COGS on the P and L? To me it seems NS 's answer is to delete the IF which to me seems very arduous when dealing with thousands across multiple periods. The custom segment is correct on both the item record and the sales order source record for the IF.
k
KevinJ of Kansas
05/01/2020, 4:03 PM
I would expect you could script this.
z
ZergiNate
05/01/2020, 4:06 PM
Thanks Kevin, this is what I was thinking but was hoping there was another way around it organically within the system or a workflow.
k
KevinJ of Kansas
05/01/2020, 4:07 PM
If your custom segment posts to the GL, all your periods will have to be open
KevinJ of Kansas
05/01/2020, 4:07 PM
That said, maybe you could try set field value with a workflow sublist group
z
ZergiNate
05/01/2020, 4:55 PM
Hey Kevin, when I approached it that way it shows that the value is changed once the workflow runs and I look at the workflow history but the transaction value never changes. So the log records it but the change isn't actually made in the system, very strange
ZergiNate
05/01/2020, 6:52 PM
Just an update - I tinkered and it was user error (facepalm). You can use the set field value for that value.