,(select LIST(distinct so.PONO) from so
where so.SOID in (select SOID from arinvdet f where f.arinvoiceid=a.arinvoiceid)
) LISTPONO

select a.*,
x1.TaxName TaxName1, x1.Rate Tax1Rate, x2.TaxName TaxName2,
c.ADDRESSLINE1, c.ADDRESSLINE2, c.CITY, c.CONTACT, c.COUNTRY, c.DEFAULTINVDESCRIPTION,
c.NAME, c.PERSONNO, c.PHONE, c.STATEPROV, c.ZIPCODE, c.TAX1EXEMPTIONNO, c.PersonMessage,
c.Fax, c.Email, c.WebPage, c.TaxAddress1, c.TaxAddress2, c.TAX2EXEMPTIONNO,
t.TERMNAME, t.NetDays, t.TERMMEMO, cu.CURRENCYNAME, s.FIRSTNAME, s.LASTNAME, v.NAME SHIPNAME,
w.Name WarehouseName, br.ExchangeRate BankRate
,c.CHRRESERVED1,c.CHRRESERVED2,c.CHRRESERVED3,c.CHRRESERVED4,
c.CHRRESERVED5,c.CHRRESERVED6,c.CHRRESERVED7,c.CHRRESERVED8,
c.CHRRESERVED9,c.CHRRESERVED10,c.CURRRESERVED1,c.CURRRESERVED2,
c.CURRRESERVED3,c.DATERESERVED1,c.DATERESERVED2, sn.SNList
,(select LIST(distinct so.PONO) from so
where so.SOID in (select SOID from arinvdet f where f.arinvoiceid=a.arinvoiceid)
) LISTPONO
from ARINV a
Inner join PersonData c on a.CustomerID=c.ID
Inner Join Currency cu on c.CurrencyID=cu.CurrencyID
Left Outer Join TermOPmt t on t.termID=a.TermsID
Left Outer Join Salesman s on a.SalesmanID=s.SalesmanID
Left Outer Join Shipment v on a.ShipVia=v.ShipID
Left Outer Join Tax x1 ON x1.TaxID=a.Tax1ID
Left Outer Join Tax x2 ON x2.TaxID=a.Tax2ID
Left Outer Join WareHS w ON w.WarehouseID=a.WarehouseID
Left Outer Join Currency br on br.CurrencyID=(select CurrencyID from GLAccnt where GLAccount=a.DepositTo)
Left Outer Join View_SN_ByTrans(a.ARInvoiceID, ‘ARINV’) sn ON sn.ID=a.ARInvoiceID
Where a.ARInvoiceID=:ARINVOICEID

7. Masuk ke dalam designer | di bagian kolom yang akan di tampilkan nomor PO nya tersebut silahkan diisikan dengan [DialogForm.qrySIARInv.”LISTPONO”]