Trying to get the Transfer price on inventory Transfer Orders to equal the average cost for that item. I found suiteanswer 90075 called "Source the Transfer Price From the Item Record Average Cost After Saving a Transfer Order Record", which is exactly what I am trying to do. I have followed the steps in the suiteanswer to the letter. However, when I run a test order I am getting an error: "Notice (Suitescript) You have entered an invalid Field Value ERROR: Field 'line.item.averagecost' Not Found for the following field: rate". I am pretty new to workflows, so I am probably missing something basic, but I am fairly certain I followed the instructions exactly. Anyone have any suggestions to get this working?

Average Cost is not an available field to workflows

Makes sense. And yes, that is wierd, esp given the last update on the suiteanswer was january of 2023, pretty recent.

Also just FYI the averagecost field is really just an average of ALL the averagecosts of each location. So if you have multiple locations then the more accurate date would come from the Location Average Cost and not the Average Cost

So I would duplicate the instruction, but the record would be an item record, and the formula used would be the same?

Kind of

Can I just do all active items? We are only talking a couple hundred sku's. I'm not clear how to set it off of a saved search. Thank you by the way, I REALLY appreciate the help.

No problem...do you know how to make a saved search?

dont worry, I have much thicker skin that that! Yes, can make saved searches, although am certainly not a whiz. Just have never done it as part of a workflow. The workflows are still a bit of a black box for me, even as simple as they are.

ok no problem...we can walk through it together

OMG, this is fantastic. Cant thank you enough.

no problem happy to help

Think I have it built. 🤞 I sure appreciate the help.

Yes if you leave it in Testing mode instead of released then there is an Execute now button at the top

The first 10? Is there a way to tell which ones to spot-check?

I don't know the exact number but its like a dozen or so

understood. Only issue is I am not seeing the "execute now" button. How do I access that? (I did set it to release, and then moved it back to testing...did I lose the button?)

it's in the intial config page of your workflow

GOT IT. I can see it has run in the history, but its not working. Do I need to do anything with the top of the workflow action screen, i.e. "trigger on": scheduled, contexts, saved search condition, schedule, recurrence, etc? I initially set that info on the main configuration screen from your screenshot but did not do any of the other settings.

Did you change any of those configurations on the main workflow?

Believe I did exactly as pictured. Is it possible the "inventory part" is the wrong subtype? I have not run into that term before, the items in question are all "inventory item", but I did not see that in the menu.

You are a star for that level of help @MGBC

Hi @Dave Furman sorry for the delay here, I was away from my computer all weekend. (not annoyed at all, happy to help)

I think you may have to have an "Available Filters" set as well for the workflow to pick it up. Like "Internal ID". You don't need to display it though.

Yes, I agree, this is rock star status. No, I never did get it to work last week. This morning I started over following the instructions and it did work in my test. I believe the issue was that on the workflow action I had "after submit" selected, which is what was leftover from the erroneous netsuite answer...when I set it to "on entry" it worked. Apparently I missed that, you had indeed specified it above. Thank you! I really can't tell you how much I appreciate this. I will pay it forward as I can. 🙏

@Dave Furman glad you got it to work! (Yes scheduled WF do not trigger the after submit)