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
raghav
02/17/2024, 10:24 AM
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
John ORourke
02/17/2024, 4:47 PM
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
Chris Lentz
02/17/2024, 4:50 PM
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.
Chris Lentz
02/17/2024, 4:50 PM
It must be a bug.
Chris Lentz
02/17/2024, 4:50 PM
There is no way to join an IF to the FR that it is associated with.