Berikut cara menampilkan variabel berat (item) di preview template Faktur Penjualan :
- Dari Menu Setup | Form Template | Klik Nama Template | Klik Designer as FRF
- Klik Page 2 | Klik ibx 3 dari kiri | tekan F11 | klik […] SQL
- Ubah SQL nya menjadi :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,i.NOTES, i.WEIGHT
From TEMPLATE_ARINVDET(:ARINVOICEID, 0) a
left join item i on a.itemno=i.itemno
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 - Klik tanda Checkmark
- Klik Page 1 | File | Data dictionary | Variable Klik Invoice | Kolom Value ganti menjadi DialogForm.qrySIARInvDet | Klik New Variable | Masukkan Weight | kolom value klik weight dan weight yang di buat pun di klik | Klik ok
- Klik Close | Yes
- Klik Designer | kemudian di klik kolom yang akan menampilkan variable “Weight” tsb
- Klik Insert Expression | Klik Variable | Klik 2 kali variable Weight | Klik ok | Klik tanda Checkmark
- Klik Close | Yes(Available for version 4 & 5)
Tidak ada komentar:
Posting Komentar