Does anyone have a saved search they have created to identify cogs going through at zero value for particular items? mainly item fulfilments where you have 10 lines and instead of 10 cogs line, you have 9 because one item was booked in at zero value and therefore the subsequent fulfilment has gone through at zero value... trying to create one however not sure how to do this?

@G try this from an SO search. Return the SO line items and then NVL of the cogs amount from the fulfillment. You should be able to find items that have no COGS on the fulfillment

@AK47 sounds promising.. would you mind elaborating a bit pls? would the formula be looking at applying transactions fulfilment cogs amount and would it be part of the criteria or the result? any additional tips would be useful.. thanks

@G i was playing around with that and didn't seem to work as I expected. Looks easy enough from a fulfillment search though. This criteria would bring all lines with 0 COGS. I have it filtered to the one COGS account that this client uses.

@AK47 you are a legend! 🫡