Menampilkan Form No Received Item di Preview Purchase Invoice

1. Setup | Form Template | Purchase Invoice, edit template yang dimaksud.
2. Klik button Design As frf, lalu pilih Page2. Klik sekali di IBX ke dua dari kanan, kemudian tekan F11 di keyboard, akan muncul tampilan Oboject Inspector(qryAPItmDet: TfrlBXQuery), double klik bagian SQL.
3. Tambahkan :

• “b.SEQUENCENO” sebelum baris “From TEMPLATE_APITMDET(:APInvoiceID) a“
• Tambahkan :

  left outer join apitmdet z on z.apinvoiceid=a.apinvoiceid and z.seq=a.seq
  left outer join APINV b on b.APINVOICEID=z.riid

  sesudah baris “From TEMPLATE_APITMDET(:APInvoiceID) a“

Sehingga keseluruhan SQL-nya menjadi sbb :

Select a.APINVOICEID, a.SEQ, a.BILLID,
a.INVOICENO PINO,
a.ITEMNO, a.ITEMOVDESC, a.QUANTITY,
a.ITEMDISCPC, a.BRUTOUNITPRICE, a.UNITPRICE,
a.ITEMHISTID, a.ITEMCOST, a.ITEMCOSTBASE,
a.ITEMUNIT, a.UNITRATIO,
a.ITEMTYPE, a.UNIT1, a.UNIT2, a.UNIT3, a.RATIO2, a.RATIO3, a.NOTES,
a.INVENTORYGLACCNT, a.COGSGLACCNT, a.SALESGLACCNT, a.UNBILLEDACCOUNT,
a.TAXCODES, a.TAXABLEAMOUNT1, a.TAXABLEAMOUNT2,
a.ITEMRESERVED1, a.ITEMRESERVED2, a.ITEMRESERVED3, a.ITEMRESERVED4,
a.ITEMRESERVED5, a.ITEMRESERVED6, a.ITEMRESERVED7, a.ITEMRESERVED8,
a.ITEMRESERVED9, a.ITEMRESERVED10,
a.POID, a.POSEQ, a.PONO,
a.DEPTID, a.DEPTNO, a.DEPTNAME,
a.PROJECTID, a.PROJECTNO, a.PROJECTNAME,
a.WAREHOUSEID, a.NAME WPIName, a.ReqNo RequestNo, a.SNLine, a.SNExpDate,
a.QTYCONTROL, b.SEQUENCENO
From TEMPLATE_APITMDET(:APINVOICEID) a
left outer join apitmdet z on z.apinvoiceid=a.apinvoiceid and z.seq=a.seq
left outer join APINV b on b.APINVOICEID=z.riid
Where 1=1
Order by A.APInvoiceID, a.SEQ