Earlier this year, I updated a workflow to add a Set Field Value for our A/P due dates. I had it working where it would add in the number of days from the terms {terms.daysuntilnetdue} to the custom field. We had to remove it at a request, but then the team adjusted things again and now needs it back. However, when I went to do this, nothing is correctly working.
Currently, my workflow is setup for After Field Sourcing of the Terms Field. However, while something is filled into my Days Until Due field, it is the internal ID of the terms, not the specific field. Why is the formula only looking at the internal ID? (Please see images below.)
I've looked at SuiteAnswers: 89025 and also referred to these articles. None of these things are working at all. The figures do not show up in most of the cases. And we have multiple Days Until Net Due options so having the formulas from the below articles seem like they'd take a lot of time and effort if we needed to add another option for Days Until Net Due.
I even tried adding it on the vendor page and I got the same issue with the internal ID. Does anyone have any idea how I can get the correct integer for my A/P team?