This message was deleted.
# generals
Slackbot
10/25/2023, 2:17 PMThis message was deleted.
a
AK47
10/25/2023, 5:43 PM@Michal Zelazny can probably come up with a more elegant answer using analytic workbooks, but I would probably do 2 exports and a simple vlookup
AK47
10/25/2023, 5:44 PMexport a list of invoices, created from, and items. Concatenate the Created From + Item. Then a list of SO and Items. Concatenate the Order + Item. Compare?
AK47
10/25/2023, 5:45 PMnot elegant, but would only take a couple of minutes to get an answer
AK47
10/25/2023, 5:45 PMclearly any invoice that doesn't have a created from didn't have an SO...so that could be a separate list.