Menampilkan Kategori Item di Preview Template Faktur Pajak
Berikut cara menampilkan Kategori Item di template Faktur Pajak :
1. Dari menu Setup ( Persiapan) | Form Template ( Rancangan Formulir) | Klik Nama templatenya1
2. Klik Design As Frf ( Desain sebagai FRF)
3. klik Page 2 | klik IBx ke 3 dari kiri | Tekan Tombol F11 | Klik […] SQL3
4. Sebelum baris ‘From TEMPLATE_ARINVDET(:ARINVOICEID, 1) a’ tambahkanlah baris :
,e.name CategoryName
5. Setelah baris ‘From TEMPLATE_ARINVDET(:ARINVOICEID, 1) a‘ tambahkanlah baris-baris :
left outer join item d on d.itemNo=a.ITEMNO
left outer join itemcategory e on d.categoryid=e.categoryid
6. Sehingga keseluruhan Querynya menjadi seperti dibawah ini :
Select a.ARINVOICEID, a.SEQ, a.USEDINSIID,
a.USEDINSI, a.INVOICENO, a.PONOFROMDO,
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.SALESDISCOUNTACCNT, a.GOODSTRANSITACCNT,
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.SOID, a.SOSEQ, a.SONO, a.PONOFROMSO,
a.DEPTID, a.DEPTNO, a.DEPTNAME,
a.PROJECTID, a.PROJECTNO, a.PROJECTNAME,
a.WAREHOUSEID, a.NAME WPIName, a.QuoteID, a.QuoteNo, a.SNLine, a.SNExpDate,
a.QTYCONTROL
,e.name CategoryName
From TEMPLATE_ARINVDET(:ARINVOICEID, 1) a
left outer join item d on d.itemNo=a.ITEMNO
left outer join itemcategory e on d.categoryid=e.categoryid
Where 1=1
and (a.GroupSeq is null or (a.GroupSeq is not null
and (Exists (select s.Seq from ARINVDET s
inner join Item it on it.itemNo=s.ItemNo and it.ItemType=3
where it.MinimumQty=1 and s.ARInvoiceID=a.ARInvoiceID and s.Seq=a.GroupSeq))))
Order by a.Seq
7. Klik Page 1 | File | Data dictionary6
8. Klik Invoice | New Variable (Masukkan Item Kategori) | kolom Value pilih DialogForm.qryCompany7
9. Klik Item Kategori | kemudian di kolom value tsb juga klik CATEGORY NAME
10. Klik ok | Close | Yes
11. Kemudian klik Designer (Desain)
12. Variable Item Kategori tsb bisa di letakkan di satu kolom dengan item description dengan cara :
– Klik kolom Item Description
– Klik Insert Expression | Variable | Invoice | Kategori Item
– Klik ok | ok | CheckMark | Close | Yes