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 :
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 :
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
5. Klik Designer | Double klik di bagian Item Descriptionnya
6. Ganti text editornya menjadi 1 lot dari Invoice No. [Invoice Number] | klik tanda ceklist
7. 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
8. Di kolom Sub Total, ganti juga rumusannya dengan :
[ [Invoice Amount] – [Freight] – [Tax 1 Amount] – [Tax 2 Amount] + [Discount] ]
9. 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.
Untuk mencoba trail Accurate Online, silahakan klik disini
Atau Hubungi :
Marketing Accurate Mal Metropolitan Cabang Bekasi
Anis Wahyu Wijaya
Telp : 0812 9902 9493 (Telp. WA & SMS)
Email : anis.wahyu@myabcshop.com
Website : accurateonline.co & penjualanresmiaccurate.com
Alamat : Mall Metropolitan Bekasi Lt. Basement BS-06 Jl.K.H Noer Alie Bekasi Selatan 17148
