There is a Suite Answers article about this: 33986
I've been researching this for days trying to figure out the best way without having to write a script.
Solution
- Navigate to Reports > Saved Searches > All Saved Searches > New
- Select Transaction link
- Set the following Filters under Criteria Tab > Standard Subtab:
Type = Item Fulfillment
Date
Main Line = Yes/true (optional this is to avoid duplication)
4. Set the following Fields under Results Tab > Column Subtab:
Date
Document Number
Name
Amount
Applied To Transaction
Applied To Transaction fields… > Item
Applied To Transaction fields… > Line ID
When I tried this, it almost works.. but I'm only getting one line per Item Fulfillment. If the sales order has multiple lines that ship on one IF, only one of those lines is appearing on the results.
Can you advise how I can get all lines to appear?
And just for context, I'm trying to get a report of all Items that have been shipped and pull related data from the corresponding sales order lines. I've also wanted to try exporting sales orders and IF records separately and then marry them up, but there is no Line ID on item fulfillments. From what I read, there is a field "orderline" that links the two records but it's not exposed for reporting through saved searches or Analytics. Any plans to change that? I just logged that to SuiteIdeas.
Thanks for any suggestions!
Judy