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

9. Selesai

(Available for V4 & V5)