We recently implemented B1 version 2007A from 2005 and in the process manually entered several A/R Invoices as Service Invoices since we were unable to copy over during the upgrade. I am currently trying to write a query to detail open A/R invoices including new ones established and those from the 2005 version put in as service invoices. The two tables I am using are the OINV and INV1 tables. The reason for the INV1 table is to capture row information. Unfortunately, whenever I do an outer join in the query it will not pick up the 2005 A/R invoices that we manually keyed in. Below is the SQL query that I would ask if anyone has a suggetion to fix so that it picks up all of the open A/R invoices I would be very grateful.
SELECT T1.DocNum AS 'Inv #', T1.DocDate, T1.CardCode AS 'Customer #', T1.CardName AS 'Customer', T1.U_ISGI_pono AS 'MP #', T1.U_ISGI_prjd,T1.U_ISGI_type, T0.ItemCode, T0.Quantity, T0.LineTotal, T0.PriceBefDi
FROM INV1 T0 FULL OUTER JOIN OINV T1 ON T1.DocEntry = T0.DocEntry
WHERE (T1.DocDate >'[%0]' and T1.DocDate <'[%1]' and T1.U_ISGI_pono Like '%[%2]%') AND ((T0.ItemCode <> 'a9999') AND (T0.ItemCode <> 'c9999') AND (T0.ItemCode <> 'Z_Freight'))
Order By T0.ItemCode