When I run the query below, it does not pull all the data I need. It looks like it's only pulling about half, but I'm not sure how to troubleshoot. Basically, I want to see all PO history and the corresponding GRPO#. Not sure why the query below does...

I have a query to show all items, POs against them, and their corresponding invoices. It's bringing up duplicate DocNum for each PO. Is there a way to limit it to just the invoice rather than all invoice documents? SELECT T0."ItemCode",T0."Dscripti...

Hey hey, Is there a way to build a query that shows all of these fields? Below is what I have: SELECT DISTINCT T0."ItemCode", T0."itemName", T0."DistNumber" as "SynergyLabs Lot #", T0."MnfSerial" as "Vendor Lot #", T0."ExpDate" FROM OBTN T0 I...