you're reading...
ACCURATE, Template

Menggabungkan Detail Barang Menjadi Satu Baris 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:

  • 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 rumusannya dengan :

[ [Invoice Amount] – [Freight] – [Tax 1 Amount] – [Tax 2 Amount] + [Discount] ]

  • Close | Yes

(Available for v4)

Discussion

Comments are closed.

%d bloggers like this: