Menggabungkan Detail Barang Menjadi Satu Baris Di Template SI

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

Menggabungkan Detail Barang Menjadi Satu Baris Di Template SI

Menggabungkan Detail Barang Menjadi Satu Baris Di Template SI

Klik 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

Menggabungkan Detail Barang Menjadi Satu Baris Di Template SI

  • 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

Untuk Informasi Lebih Lanjut mengenai Software Akuntansi ACCURATEACCURATE Online yang cocok dengan Perusahaan Anda atau Download Gratis ACCURATE, Silahkan Menghubungi :

RIKI SAEPUL ROHMAN

Tlpn : 0822-4435-2122

Email : riki@myabcshop.com

 

Kami melayani penjualan ACCURATE di seluruh Indonesia.

Beli ACCURATE Jakarta, Beli ACCURATE Bekasi, ACCURATE Tangerang, ACCURATE Karawang, Beli ACCURATE Pulogadung, ACCURATE Surabaya,  ACCURATE Pasuruan, ACCURATE Makassar,  ACCURATE Medan, ACCURATE Bandung, ACCURATE Yogyakarta,  ACCURATE Denpasar, ACCURATE Manado, ACCURATE Batam, ACCURATE Banjarmasin,  ACCURATE Palembang, ACCURATE Semarang,  ACCURATE Balikpapan, ACCURATE Pekanbaru, Beli ACCURATE Ambon, ACCURATE Jayapura,  ACCURATE Kupang,  ACCURATE Padang, ACCURATE Pontianak, ACCURATE Malang,Beli ACCURATE Cikarang, ACCURATE Cibitung, ACCURATE MM2100,  ACCURATE Bantargebang, ACCURATE Solo , penjualan resmi accurate, penjualan resmi accurate, penjualan resmi accurate, accurate resmi,, accurate resmi,, accurate resmi, agen penjualan resmi accurate, agen penjualan resmi accurate, agen penjualan resmi accurate, accurate 5 accounting software, accurate 5 accounting software, accurate 5 accounting software, Beli ACCURATE 5 Accounting Software Dan RENE 2 (RESMI), Software ACCURATE Bekasi, Software ACCURATE Bekasi,

By |2017-08-11T11:40:59+07:00Agustus 11th, 2017|Tutorial|0 Comments

About the Author:

Profesional, komitmen dan integritas. Menguasai filosofi dan seni dalam menjual

Leave A Comment


Notice: Undefined index: url_condition in /home/u6384775/public_html/wp-content/plugins/pixel-caffeine/includes/class-aepc-pixel-scripts.php on line 340
%d blogger menyukai ini: