Hi,
I saw a previous discussion that displays the following saved search. I am trying to modify this SS to display the items that are missing between the Billing Transaction and Fulfilling/Receving Transaction.
Here are the Criteria filters and Results fields.
Criteria filters:
Type = Sales OrderBilling Transaction Fields... = Type = InvoiceFulfilling/Receiving Transaction Fields... = Type = None, Item FulfillmentTax Line = False
Results fields:
NameDocument NumberBilling TransactionBilling Transaction Fields... = DateBilling Transaction Fields... = AmountFulfilling/Receiving TransactionFulfilling/Receiving Transaction Fields... = DateFulfilling/Receiving Transaction Fields... = Amount
This Search will show you the Sales Orders related Invoices and Item Fulfillment.