Menggabungkan Detail Barang Menjadi Satu di Template SI

Berikut ini langkah-langkah menjadikan satu baris item yang di tarik dari beberapa Delivery Order (DO) yang berbeda dengan jumlah qty dan amount tertotal di dalam template SI :

1. Klik menu Setup | Form Template.
2. Klik New | Isikan nama template dan juga tipe dari templatenya tersebut | Ok.
3. Pilih Design as FRF | Klik Page2 | klik satu kali pada IBX ketiga dari kiri layar tampilan | tekan F11.
4. Solcen2Klik SQL | ganti SQL-nya menjadi seperti berikut ini:
5. Select
   a.ARINVOICEID,
   0 as SEQ,
   0 as USEDINSIID,
   ” as USEDINSI,
   ” as INVOICENO,
   ” as PONOFROMDO,
   ‘Penjualan’ as ITEMNO,
   ‘===’ as ITEMOVDESC,
   Sum(a.QUANTITY) as Quantity,
   ” as ITEMDISCPC,
   0 as BRUTOUNITPRICE,
   0 as UNITPRICE,
   0 as ITEMHISTID,
   0 as ITEMCOST,
   0 as ITEMCOSTBASE,
   ” as ITEMUNIT,
   1 as UNITRATIO,
   1 as ITEMTYPE,
   ” as UNIT1,
   ” as UNIT2,
   ” as UNIT3,
   1 as RATIO2,
   1 as RATIO3,
   ” as NOTES,
   ” as INVENTORYGLACCNT,
   ” as COGSGLACCNT,
   ” as SALESGLACCNT,
   ” as SALESDISCOUNTACCNT,
   ” as GOODSTRANSITACCNT,
   ” as TAXCODES,
   Sum(a.TAXABLEAMOUNT1) as TAXABLEAMOUNT1,
   Sum(a.TAXABLEAMOUNT2) as TAXABLEAMOUNT2,
   ” as ITEMRESERVED1,
   ” as ITEMRESERVED2,
   ” as ITEMRESERVED3,
   ” as ITEMRESERVED4,
   ” as ITEMRESERVED5,
   ” as ITEMRESERVED6,
   ” as ITEMRESERVED7,
   ” as ITEMRESERVED8,
   ” as ITEMRESERVED9,
   ” as ITEMRESERVED10,
   ” as SOID,
   ” as SOSEQ,
   ” as SONO,
   ” as PONOFROMSO,
   0 as DEPTID,
   ” as DEPTNO,
   ” as DEPTNAME,
   0 as PROJECTID,
   ” as PROJECTNO,
   ” as PROJECTNAME,
   1 as WAREHOUSEID,
   ” as WPIName,
   0 as QuoteID,
   ” as QuoteNo,
   ” as SNLine,
   0 as SNExpDate,
   Sum(a.QTYCONTROL )as QtyControl
   From TEMPLATE_ARINVDET(:ARINVOICEID, 0) a
   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))))
   group by a.ARINVOICEID
6. Klik Designer | Double klik di bagian Item Descriptionnya.
7. Ganti text editornya menjadi 1 lot dari Invoice No. [Invoice Number] | klik tanda ceklist.
8. Di bagian Amount di double klik, ganti rumusan yang ada di text editor menjadi:
9. [ [Invoice Amount] – [Freight] – [Tax 1 Amount] – [Tax 2 Amount] + [Discount] ] | klik tanda ceklist
10. Di kolom Sub Total, ganti juga rumusnya dengan:
11. [ [Invoice Amount] – [Freight] – [Tax 1 Amount] – [Tax 2 Amount] + [Discount] ]
12. Close dan klik Yes

(Available for V4 & V5)