Menampilkan Variabel Berat (Item) Di Preview Template Faktur Penjualan
Berikut cara menampilkan variabel berat (item) di preview template Faktur Penjualan :
1. Dari Menu Setup | Form Template | Klik Nama Template | Klik Designer as FRF
2. Klik Page 2 | Klik ibx 3 dari kiri | tekan F11 | klik […] SQL
3. Tambahkan sebelum from >> ,i.NOTES, i.WEIGHT
4. Tambahkan sebelum where >> left join item i on a.itemno=i.itemno
5. Sehingga keseluruhan SQL 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
6. Klik tanda Checkmark
7. 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
8. Klik Close | Yes
9. Klik Designer | kemudian di klik kolom yang akan menampilkan variable “Weight” tsb
10. Klik Insert Expression | Klik Variable | Klik 2 kali variable Weight | Klik ok | Klik tanda Checkmark
11. Klik Close | Yes
Jika Anda membutuhkan Penawaran Resmi ACCURATE klik dibawah ini :
INFO : Jika anda sudah mengisi Form penawaran di Atas, anda akan dikirimkan penawaran oleh ACCURATE Cloud License service yang dikirim langsung dari ACCURATE CPSSOFT ke email yang didaftarkan.
Atau Hubungi :
Marketing Accurate Mal Metropolitan Cabang Bekasi
Anis Wahyu Wijaya
Telp : 081299029493 (Telp. WA & SMS)
Email : anis.wahyu@myabcshop.com
Website : accurateonline.co
Alamat : Mall Metropolitan Bekasi Lt. Basement BS-06 Jl.K.H Noer Alie Bekasi Selatan 17148