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

 

Untuk Download Manualbook ACCURATE 5 Klik Disini

 

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=”http://accurateonline.co/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