you're reading...
Uncategorized

Item yang sama beberapa RI jadi Satu Baris di PI

Berikut ini langkah-langkah untuk Item yang sama di beberapa RI, menjadi satu PI, mau ditampilkan di preview/print Purchase Invoice dalam satu baris :

  1. Setup  | Form Template | Purchase Invoice, Edit template yang dimaksud.
  2. Klik button Design as Frf, pilih Page2, klik sekali di IBX ke3 dari kiri, lalu tekan F11 di keyboard, di Object Inspector tsb double klik bagian SQL.
  3. Ganti isi dari SQL Editor yang tampil dengan skrip dibawah ini, lalu klik tanda cawang dan close Design, save changes pilih Yes :
Select
--a.BILLID,
NULL PINO, --a.INVOICENO PINO,
a.ITEMNO, a.ITEMOVDESC, SUM(a.QUANTITY) QUANTITY,
a.ITEMDISCPC, a.BRUTOUNITPRICE, a.UNITPRICE,
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,
NULL PONO, --a.PONO,
a.DEPTID, a.DEPTNO, a.DEPTNAME,
a.PROJECTID, a.PROJECTNO, a.PROJECTNAME,
a.WAREHOUSEID, a.NAME WPIName
From TEMPLATE_APITMDET(:APInvoiceID) a
Where 1=1
Group by
--a.BILLID,
--a.INVOICENO,
a.ITEMNO, a.ITEMOVDESC,
a.ITEMDISCPC, a.BRUTOUNITPRICE, a.UNITPRICE,
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.PONO,
a.DEPTID, a.DEPTNO, a.DEPTNAME,
a.PROJECTID, a.PROJECTNO, a.PROJECTNAME,
a.WAREHOUSEID, a.NAME
Order by a.ITEMNO

(Available for v4)

Discussion

Comments are closed.

%d bloggers like this: