Membuat Report WO Outstanding Yang Belum Ada Material Release| Cara membuat Report WO Outstanding yang Belum Ada Material Release dan Product and Material Result , langkah-langkahnya adalah :

Membuat Report WO Outstanding Yang Belum Ada Material Release

1). Buka form List | Manufacture | Work Order

2). Uncheck filter tanggal

3). Klik tombol Print

4). Klik tombol Designer | Tab Data | double klik First_Query

5). Edit SQL sbb :

 

-Sebelum baris “WHERE 1=1” tambahkan baris :

left outer join GETWOTRANSACTION(’01/01/1900′, CURRENT_DATE) GETWOTRANSACTION ON GETWOTRANSACTION.WOID=WO.ID

-Setelah baris “AND (WO.FINISHED in (‘0’))” tambahkan baris-baris dibawah ini :

GROUP BY

WO.WONO,

WO.ID,

WO.DESCRIPTION,

WO.WODATE,

WO.EXPECTEDDATE,

WO_PERSONINCHARGEID.INCHARGENAME,

WO_PERSONINCHARGEID.INCHARGEID,

WO_PRODDEPARTMENTID.PRODDEPARTMENTNAME,

WO_PRODDEPARTMENTID.PRODDEPARTMENTID,

WO.RESERVED1,

WO.RESERVED2,

WO.RESERVED3,

WO.RESERVED4,

WO.RESERVED5,

DATA_COUNT.DATACOUNT,

DATA_COUNT.DATACOUNT,

WO.FINISHED

having COUNT(GETWOTRANSACTION.TXNO)=0

-Sehingga keseluruhan SQL-nya menjadi sbb :

Membuat Report WO Outstanding Yang Belum Ada Material Release

SELECT

WO.WONO COLUMNVALUE_1,

WO.ID PRIMARYKEYVALUE_10001,

WO.DESCRIPTION COLUMNVALUE_2,

WO.WODATE COLUMNVALUE_3,

WO.EXPECTEDDATE COLUMNVALUE_4,

WO_PERSONINCHARGEID.INCHARGENAME COLUMNVALUE_5,

WO_PERSONINCHARGEID.INCHARGEID PRIMARYKEYVALUE_6,

WO_PRODDEPARTMENTID.PRODDEPARTMENTNAME COLUMNVALUE_6,

WO_PRODDEPARTMENTID.PRODDEPARTMENTID PRIMARYKEYVALUE_10,

WO.RESERVED1 COLUMNVALUE_7,

WO.RESERVED2 COLUMNVALUE_8,

WO.RESERVED3 COLUMNVALUE_9,

WO.RESERVED4 COLUMNVALUE_10,

WO.RESERVED5 COLUMNVALUE_11,

DATA_COUNT.DATACOUNT COLUMNVALUE_12,

DATA_COUNT.DATACOUNT PRIMARYKEYVALUE_30001,

WO.FINISHED COLUMNVALUE_13

FROM

WO WO

LEFT OUTER JOIN GET_REPORTCUSTOMFIELD ON 1=1

LEFT OUTER JOIN DATA_COUNT ON 1=1

LEFT OUTER JOIN PERSONINCHARGE WO_PERSONINCHARGEID ON WO.PERSONINCHARGEID=WO_PERSONINCHARGEID.INCHARGEID

LEFT OUTER JOIN PRODDEPARTMENT WO_PRODDEPARTMENTID ON WO.PRODDEPARTMENTID=WO_PRODDEPARTMENTID.PRODDEPARTMENTID

left outer join GETWOTRANSACTION(’01/01/1900′, CURRENT_DATE) GETWOTRANSACTION ON GETWOTRANSACTION.WOID=WO.ID  

WHERE 1=1

AND (WO.FINISHED in (‘0’))

GROUP BY

WO.WONO,

WO.ID,

WO.DESCRIPTION,

WO.WODATE,

WO.EXPECTEDDATE,

WO_PERSONINCHARGEID.INCHARGENAME,

WO_PERSONINCHARGEID.INCHARGEID,

WO_PRODDEPARTMENTID.PRODDEPARTMENTNAME,

WO_PRODDEPARTMENTID.PRODDEPARTMENTID,

WO.RESERVED1,

WO.RESERVED2,

WO.RESERVED3,

WO.RESERVED4,

WO.RESERVED5,

DATA_COUNT.DATACOUNT,

DATA_COUNT.DATACOUNT,

WO.FINISHED

having COUNT(GETWOTRANSACTION.TXNO)=0  

ORDER BY

WO.WONO ASC

6). Klik Tanda Cawang (v) untuk menyimpan SQL yang baru.

7.) Dan untuk menyimpan Laporan Terdesain (Designed Report) ini, caranya Klik menu File | Save As, Save di folder apa saja dengan nama yg sudah kita tentukan.

8.) Kemudian untuk cara mengimport dan membuka file FR3 yg sudah disimpan tadi, bisa dilihat pada Link https://solutioncenter.wordpress.com/2012/01/06/import-dan-membuka-file-fr3-di-accurate/

 

Untuk informasi lebih detail silahkam menghubungi :

Riki Saepul Rohman

Membuat Report WO Outstanding Yang Belum Ada Material Release 0822-4435-2122

Membuat Report WO Outstanding Yang Belum Ada Material Release dan Product and Material Result [email protected]

Alamat :Mall Metropolitan Bekasi. Lt. Basement BS-06 Jl. K. H. Noer Alie Bekasi Selatan

Minta Penawaran

 

Download Trial