接單出貨明細資料列印查詢. (Transaction Data Listing)
交貨日期表列印查詢. (Delivery Schedule)
尚未下採購單之資料列印查詢. (Order Placement Status Report)
ET521 P/O Control Reports
訂貨單資料查詢
Contents
00. Overview
|
待交貨訂單資料列印查詢. (Outstanding Order List) 接單出貨明細資料列印查詢. (Transaction Data Listing) 交貨日期表列印查詢. (Delivery Schedule) 尚未下採購單之資料列印查詢. (Order Placement Status Report)
|
|
P/O Work Sheet
|
| Data range | 依 retrieve data using 的選擇, 設定適當的資料範圍. 任何設定, 都會影響查詢結果. |
| Retrieve data using | 與 data range 適當配合, 會加速查詢. 資料擷取方式有: (1) P/O No. (2) Supplier No. + P/O No. (3) P/O Date + P/O No. |
| Data ordered by | 最終報表有多種排列方式: (1) P/O No. + Part No. (2) Supplier No. + P/O No. (3) P/O Date + P/O No. (4) Delivery Date + P/O No. |
| Filters | 設定篩選項目. Customer No. 只對有 S/C 之訂貨單有效. |
| Show outstanding items only | |
| Do not show prices | |
| Deduct R/D quantities | 有些 items 已做 R/D, 但尚未做 delivery data input 沖銷 (PODET). 勾選本選項, 會讓 outstanding 數量更正確. |
| Show original order quantity | 加總. |
| Show customer item nos. instead | 用 customer item no. 取代 our item no. |
| Landscape | 橫式報表: (1) None (2) Short description (3) Customer no. + customer order no. (4) Customer no. + customer order no. + short description. 第 (4) 項選擇會使用較小的字型. |
| Note |
| Beginning...Ending | 要查詢資料的範圍. 任何欄位之設定, 都會影響查詢結果. |
| Retrieve data using | 資料擷取方式: (1) Date (2) P/O No. + Part No. 與上述資料範圍適當配合, 會加速查詢. |
| Data ordered by | 報表資料排列方式: (1) Date (2) P/O No. + Part No. |
| Price to show | (1) Normal (2) 2nd prices (3) 3rd prices. |
| Filters | |
| Show orders | |
| Show deliveries | |
| Show cancellations | |
| Show returns | |
| Use landscape to show | 橫式報表增加欄位選項: (1) Short description (2) S/C nos. (3) S/C nos. + invoice nos. + dates. |
| Print note |
在報表的 T 欄位, 1 代表訂貨, 2 代表交貨, 3 代表取銷, 4 代表退貨.
根據採購單預計交貨日期查詢 P/O 上之未收貨資料, 若要查詢所有 P/O 上完整之資料, 不要選擇 "Show outstanding only".
14. Order Placement Status Report
本節主要在查詢已接國外訂單卻尚未下之國內採購單之資料. 作業時, 可直接指明國外客戶及其 S/C 號碼.
印出之報表, 若 S/C 無對應之 P/O 資料, 表示未曾下國內採購單; 如非空白, 但餘額不為零, 則表示尚有單子未下完, 應再補下. 若不需列出 S/C 已出貨之資料, 請選擇 "Exclude shipped items".
當你做好 S/C 但未下單前, 可先產生這份報表. 報表內容為 S/C 項目, 品名, 數量, 單價, 交期,
以及各產品之供應廠商和其報價.
60. Custom-Made: IDC P/O Outstanding Order List
| Data range | Any combination of range settings is effective during retrieval of data. |
| Retrieve data using | Options: P/O no., P/O date + P/O no., Supplier no. + P/O no., S/C no. + P/O no., P/O delivery date. |
| Data ordered by | Options: P/O no., P/O date + P/O no., Supplier no. + P/O no., S/C no. + P/O no., P/O delivery date + P/O no., Part no. + delivery date + P/O no., S/C shipping date + P/O no., Invoice no. (1st available) + P/O no. |
| Filters | Company nos.: Use company number 1, 2, 3,
etc., or any combination like 13. Customer nos.: Enter customer nos. for whom you want outstanding order data. Separate numbers with commas. Part nos.: Enter part nos. for which you want outstanding order data. Separate numbers with commas. |
| Show outstanding items only | If unchecked, all P/O items will be shown, disregarding whether items have been delivered or not. |
| Excel template file | File must be available in data folder. |
| Date | Version | Downloads | Explanations |
|---|---|---|---|
| 2008-10-9 | SP3 Secured | et521zip.exe. | Margin offsets for reports of landscape orientation. Refer to system codes ET521-OFFSETX and ET521-OFFSETY below. |
| Code | Field | Value | Explanation |
|---|---|---|---|
| ET521-LAYOUT-INSPRPT | 3 | 11 numbers | Column positions for
inspection report. Default: 0.0,0.7,1.4,2.1,3.3,4.8,5.8,6.6,7.4,8.2,10.0 |
| ET521-LAYOUT-LATEST | 3 | 11 numbers | Column positions for latest
purchase prices. Default: 0.0,1.5,2.5,3.2,3.9,5.1,6.1,7.1,8.5,10.2 |
| ET521-LAYOUT-ODRSTAT | 3 | 8 numbers | Column positions for order
status report. Default: 0.0,1.6,2.9,4.5,5.8,6.6,7.8,10.2 |
| ET521-LAYOUT-OUTSTAN | 3 | 12 numbers | Column positions for
outstanding order list. Default: 0.0,0.7,2.5,3.7,4.5,5.6,6.2,6.9,7.6,8.2,10.2,13.2 |
| ET521-LAYOUT-SCHED | 3 | 11 numbers | Column positions for
delivery schedule. Default: 0.0,0.8,1.6,3.1,4.4,5.7,6.3,7.1,7.7,10.2,10.2 |
| ET521-LAYOUT-SCHED2 | 3 | 11 numbers | Column positions for
delivery schedule with landscape 1. Default: 0.0,0.8,1.6,3.1,4.4,5.7,6.5,7.9,8.7,10.2,10.2 |
| ET521-LAYOUT-SCHED3 | 3 | 11 numbers | Column positions for
delivery schedule with landscape 2. Default: 0.0,0.8,1.6,3.1,4.4,5.7,6.3,7.1,7.7,9.2,13.2 |
| ET521-LAYOUT-SCHEDC1 | 3 | 13 numbers | Column positions for custom
delivery schedule I. Default: 0.0,0.595,2.125,2.72,3.91,4.59,5.61,6.29,7.31,7.90,8.5,9.35,10.37 |
| ET521-OFFSETX | 3 8 |
22222222... 33333333... |
To adjust left margin for
printing of portrait orientation. 1/10 of value used. To adjust left margin for printing of landscape orientation. Note: field 3 used if field 8 not available. |
| ET521-OFFSETY | 3 8 |
22222222... 33333333... |
To adjust top margin for
printing of portrait orientation. 1/10 of value used. To adjust top margin for printing of landscape orientation. Note: field 3 used if field 8 not available. |
| ET521-SCHEDULEC1 | 3 | 20 bytes | Program key for Custom Delivery Schedule I. |
| LAYOUT-ET521-TRANS | 3 | 13 numbers | Column positions for
transaction data listing. Default: 0.0,0.7,1.5,3.0,3.2,4.4,5.0,6.4,7.2,7.8,8.6,9.4,10.2 |
Last modified: September 2011