Menggabungkan Detail Barang Menjadi Satu Baris Di Template SI pada Accurate Dekstop

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 :

• Klik menu Setup | Form Template.
• Klik New | Isikan nama template dan juga tipe dari templatenya tersebut | Ok.
• Pilih Design as FRF | Klik Page2 | klik satu kali pada IBX ketiga dari kiri layar tampilan | tekan F11.
• Solcen2Klik SQL | ganti SQL-nya menjadi seperti berikut ini:
• 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
• Klik Designer | Double klik di bagian Item Descriptionnya.
• Ganti text editornya menjadi 1 lot dari Invoice No. [Invoice Number] | klik tanda ceklist.
• Di bagian Amount di double klik, ganti rumusan yang ada di text editor menjadi:                              [ [Invoice Amount] – [Freight] – [Tax 1 Amount] – [Tax 2 Amount] + [Discount] ] | klik tanda ceklist
• Di kolom Sub Total, ganti juga rumusnya dengan:                                                                                [ [Invoice Amount] – [Freight] – [Tax 1 Amount] – [Tax 2 Amount] + [Discount] ]
• Close dan Klik Yes

(Available for V4 & V5)