Membuat Report WO Outstanding Yang Belum Ada Material Release dan Product and Material Result

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

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 :

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.ultimasolusindo.com/2012/01/06/import-dan-membuka-file-fr3-di-accurate/

9.) Selesai

(Available for V4 & V5)