GL52 Inventory Control Reports
庫存報表

內容

00. Overview
10. Current Inventory Listing
11. Daily Inventory Listing
12. Inventory Relations Report
20. Transactions Listing
21. Stock Movement Report
30. Pick List Listing
80. Inventory Position Estimates (Custom)
98. Upgrades
99. System Codes

00. Overview

　

10. Current Inventory Listing

11. Daily Inventory Listing

　

12. Inventory Relations Report

　

20. Transactions Listing

　

21. Stock Movement Report

　

30. Pick List Listing

Data range 　
Retrieve data using Pick date, P/O no., invoice no., S/C no., item no.
Data ordered by Pick date + item no.
Item no. + pick date
P/O no. + item no.
Invoice no. + item no. + pick date
S/C no. + item no. + pick date: 此選擇會產生 landscape 報表, 亦會取代 show short descriptions.
Supplier no. + P/O no. + item no.
Customer no. + invoice no. + item no.
Filters Supplier no.
Customer no.
Data source: 指 pick list 資料產生源頭.
Show outstanding only 　
Show short descriptions 會被 data ordered by = S/C no. + item no. + pick date 取代.

80. Inventory Position Estimates (訂製程式.)

估計所選 items 庫存數量的變化. 

Item No....Description 使用 Query 取得貨號. Query 可重複使用.
Query
Expand product items into BOM parts 由產品 item 轉為 parts.
Data ordered by Item no., S/C no., customer order no., shipping date, picking date, item no.
Filters  Nature - none:
Nature - stockin-PO: 
Nature - instock-PO:
Nature - pick-PO: 領料.
Nature - pick-invoice:
Nature - pick-manufacturing:
P/O status: 指定 P/O item 的目前狀態.
Show mode Real: 實際庫存 + stockin-PO + pick-PO + pick-invoice.
Estimate: 實際庫存 + stockin-PO + pick-PO + pick-invoice + instock-PO.
Replace our item nos. with customers' 改顯示客戶貨號.
Use pending quantity for S/C data S/C 數量顯示訂單數量或餘額.
Export to Excel 匯出至 Excel.
Print Paper A3
Letter or A4 with shrunk font: 由 A3 縮小至 A4.

98. Upgrades

Date Version Downloads Actions Explanations
2011-12-27 SP3 Secured gl52zip.exe, etconvzp.exe. 啟動 etconv.exe, 選擇 31. Initem. 若已轉換過, 加點選 copy self, 再執行轉換. 增加 Inventory Threads Listing 報表.
2008-4-18 SP3 Secured gl52zip.exe, etconvzp.exe. 安裝 etconvzp.exe 後, 啟動 etconv.exe, 執行 40. Pickdet. 安裝 etconvzp.exe 後, 啟動 etconv.exe, 執行 40. Pickdet.

99. System Codes

Code Field Value Explanation
GL52-INVENTORYPOS 3 20 characters Program key for the custom-made Inventory Position Estimates
GL52-LAYOUT-INVTHRE 3 　 　
GL52-LAYOUT-IR 3 7 numbers Customizes column positions for Inventory Relations Report. Default value:
0.0,1.5,3.0,4.0,4.8,6.0,7.3,10.0
GL52-LAYOUT-PICKDET 3 12 numbers Customizes column positions for Pick List Listing. Default values: 0.0,0.6,2.1,2.3,3.0,4.0,4.7,5.7,6.7,7.4,8.2,10.0
GL52-OFFSETX 　 　 　
GL52-OFFSETY 　 　 　
INVENTORY-GENRE 3 0 1. Show real/estimate mode (0-1)

Last modified: December 2011