Menampilkan Daftar PO No Yang Ada di SO Saat Preview DO
Apabila ada kondisi pada saat pembuatan Sales Order memasukkan beberapa nomor Purchase Orderatas barang tersebut berbeda dan ketika di preview di DO ingin di munculkan keseluruhan nomor PO nya tersebut, silahkan dijalankan langkah panduan berikut ini :
1. Masuk ke dalam Setup | Form template | masuk ke dalam template Delivery Order yang digunakan
2. Masuk ke dalam Design As FRF
3. Pilih tab Page 2
4. Pilih IBX kedua dari kiri (qrySIARInv: TfrIBXQuery) | tekan F11
5. Di bagian sebelum baris from ARINV a silahkan tambahkan SQL berikut ini :
,(select LIST(distinct so.PONO) from so
where so.SOID in (select SOID from arinvdet f where f.arinvoiceid=a.arinvoiceid)
) LISTPONO
,(select LIST(distinct so.PONO) from so
where so.SOID in (select SOID from arinvdet f where f.arinvoiceid=a.arinvoiceid)
) LISTPONO
6. Sehingga keseluruhan SQL-nya menjadi seperti ini :
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
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”]
8. Save & close
(Available for V4)
Tidak ada komentar