you're reading...
ACCURATE, Sales

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 :
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

6. Klik tanda cawang untuk menyimpan perubahan SQL nya

7. Ganti isi memo yang akan digunakan untuk menampilkan Qty On Hand dengan :
[First_Query.”QTYONHAND”]

8. Tutup tampilannya, jika ingin di Memorize silahkan. Cara membuat Memorize Report bisa lihat disini

(Available for V4)

Advertisements

Discussion

Comments are closed.

%d bloggers like this: