Membuat Report WO Outstanding
Membuat Report WO Outstanding | Apa bila anda Membutuhkan Report WO Outstanding Yang Belum Ada Material Release dan Product and Material Result, di ACCURATE kami memberika bagaimana cara setting Report WO tsb.
“left outer join GETWOTRANSACTION(’01/01/1900′, CURRENT_DATE) GETWOTRANSACTION ON GETWOTRANSACTION.WOID=WO.ID”
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
Jika Anda membutuhkan Penawaran Resmi ACCURATE klik dibawah ini :
[flm_button link_address=”https://agent.accurate.id/landing/request-quotation.do?a=LWDRW93G” link_target=”_blank” icon_placement=”Right” small_placement=”Left” button_text=”ACCURATE 5 & RENE 2″ font_family=”{CLASS-Times-New-Roman}” button_size=”MD” button_color=”Dark” button_style_icon=”Mask-Right” button_hover=”HoverB-Black” rounded_corners=”3″ icon=”fa-shopping-cart”] [flm_button link_address=”https://agent.accurate.id/landing/online-offer/LWDRW93G/commercial.do” link_target=”_blank” icon_placement=”Right” small_placement=”Left” button_text=”ACCURATE ONLINE” font_family=”{CLASS-Times-New-Roman}” button_size=”MD” button_color=”Dark” button_style_icon=”Mask-Right” button_hover=”HoverB-Black” rounded_corners=”3″ icon=”fa-shopping-cart”] [flm_button link_address=”https://fac-institute.com/order/” link_target=”_blank” icon_placement=”Right” small_placement=”Left” button_text=”PENAWARAN TRAINING FAC” font_family=”{CLASS-Times-New-Roman}” button_size=”MD” button_color=”Dark” button_style_icon=”Mask-Right” button_hover=”HoverB-Black” rounded_corners=”3″ icon=”fa-group”] [flm_button link_address=”https://account.co.id/cara-membeli-accurate-5/” link_target=”_blank” icon_placement=”Right” button_text=”Cara Beli ACCURATE” button_size=”MD” button_color=”Black” button_style_icon=”Lines-Right” button_style_3d=”D3″ rounded_corners=”3″ icon=”fa-shopping-cart”]INFO : Jika anda sudah mengisi Form penawaran di Atas, anda akan dikirimkan penawaran oleh ACCURATE Cloud License service yang dikirim langsung dari ACCURATE CPSSOFT ke email yang didaftarkan.
Untuk Trail ACCURATE Online, Silahkan Klik Disini
Atau Hubungi :
Marketing Accurate Mal Metropolitan Cabang Bekasi
Anis Wahyu Wijaya
081299029493
Email : anis.wahyu@myabcshop.com
Alamat : Mall Metropolitan Bekasi Lt. Basement BS-06 Jl.K.H Noer Alie Bekasi Selatan 17148
