Menampilkan Qty On Hand di Report

Menampilkan Qty On Hand di Report Open Sales Order By Item

Langkah-langkanya adalah sebagai berikut :

  1. Buka Report | Index to Report | Sales Report | Open Sales Order By Item
  2. Dikotak Report Format, ke Tab Available Column, cari dan double klik variable “Calculated Field 1”
  3. Ke Tab Selected Column and Filter, centang “Calculated Field 1” dan informasi lain yang dibutuhkan dan Klik Ok.
  4. KLik Designer – Data, double klik “First Query”
  5. Tekan Ctrl + A, lalu Delete. Untuk menghapus semua rumus variablenya. Lalu copas rumusan dibawah ini :

Menampilkan Qty On Hand di Report SELECT

SO.SONO COLUMNVALUE_1,

SO.SOID PRIMARYKEYVALUE_10001,

SO.SODATE COLUMNVALUE_2,

SODET.QUANTITY COLUMNVALUE_3,

SODET.SOID PRIMARYKEYVALUE_30001,

SODET.QTYSHIPPED COLUMNVALUE_4,

SODET.ITEMUNIT COLUMNVALUE_5,

GET_VALUE_SODET.STATUSITEM COLUMNVALUE_6,

GET_VALUE_SODET.SOID PRIMARYKEYVALUE_40001,

DATA_COUNT.DATACOUNT COLUMNVALUE_7,

DATA_COUNT.DATACOUNT PRIMARYKEYVALUE_60001,

SODET_ITEMNO.ITEMNO COLUMNVALUE_8,

SODET_ITEMNO.ITEMNO PRIMARYKEYVALUE_144,

SODET_ITEMNO.ITEMDESCRIPTION COLUMNVALUE_9,

GET_REPORTCUSTOMFIELD.CUSTOMFIELD1 COLUMNVALUE_10,

GET_REPORTCUSTOMFIELD.PKFIELD PRIMARYKEYVALUE_50001

,GETITEMQUANTITY.QUANTITY QTYONHAND

FROM

SO SO

LEFT OUTER JOIN GET_OTHERSODATA (SO.SOID) ON SO.SOID=GET_OTHERSODATA.SOID

LEFT OUTER JOIN SODET ON SO.SOID=SODET.SOID

LEFT OUTER JOIN GET_VALUE_SODET (SODET.SEQ, SO.SOID) ON SO.SOID=GET_VALUE_SODET.SOID AND SODET.SEQ=GET_VALUE_SODET.SEQ

LEFT OUTER JOIN GET_REPORTCUSTOMFIELD ON 1=1

LEFT OUTER JOIN DATA_COUNT ON 1=1

LEFT OUTER JOIN ITEM SODET_ITEMNO ON SODET.ITEMNO=SODET_ITEMNO.ITEMNO

LEFT OUTER JOIN GETITEMQUANTITY (SODET.ITEMNO, :PARAMDATE1, -1) ON SODET.ITEMNO=GETITEMQUANTITY.ITEMNO_QTY

WHERE 1=1

AND (SO.SODATE <= :PARAMDATE1)

AND (GET_VALUE_SODET.STATUSITEM in (‘2′,’3’))

ORDER BY

SODET_ITEMNO.ITEMNO ASC,

SO.SODATE ASC

Menampilkan Qty On Hand di Report

  1. Klik tanda cawang untuk menyimpan perubahan SQL nya
  2. Ganti isi memo yang akan digunakan untuk menampilkan Qty On Hand dengan :

[First_Query.”QTYONHAND”]

  1. Tutup tampilannya, jika ingin di Memorize silahkan

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

Menampilkan Qty On Hand di Report Open Sales Order By Item Menampilkan Qty On Hand di Report

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-10T11:13:51+00:00Agustus 10th, 2017|Tutorial|0 Comments

About the Author:

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

Leave A Comment

%d blogger menyukai ini: