I am stumped. I have tried a tone of different thi...
# general
c
I am stumped. I have tried a tone of different things, but it appears the relationship between an IF and FR doesn't exist via SuiteQL.
r
I haven't tested it yet, will check once I am on system, but do try to see whether it exists in transaction main line.
j
Hey @Chris Lentz... I checked the Transaction and TransactionLine tables. Maybe you're looking for Employee field or some other custom field? You may want to start within the IF screen to see how it's named there and then search the records catalog from there. Hope that helps.
c
It isn't a custom field. When you create an Item Fulfillment record, you use the requested by field to associate the fulfillment request. But in SuiteQL that field doesn't exist on the IF record.
It must be a bug.
There is no way to join an IF to the FR that it is associated with.