Oracle eBS經驗分享

一般庫存盤點的程序

1. 制定盤點時程計畫
2. 凍結庫存
3. 列印盤點清冊、盤點卡
4. 實際盤點
5. 輸入實際盤點數量
6. 盤點差異列印
7. 盤差盈虧調整
8. 庫存凍結解除
9. 盤點差異對策分析

Oracle Physical Inventory

1. Define physical inventory
2. Snapshot of on-hand quantities
3. Generate tags(列印盤點清冊、盤點卡)
4. Count Items(實際盤點)
5. Enter counts(輸入實際盤點數量)
6. Approve counts(盤差盈虧調整)
7. Run adjustment program

• Define Physical Inventory

Path: Counting > Physical Inventory>Physical Inventories

 

Notes:

Count Subinventories ==>盤點全部的Subinventories 就選All ..如只盤特定其他的Subinv就選Specific

==> [Save] 之後Physical Name 不能再變動

 

• Define Physical Inventory

按下

View-->Request

Check your "Freese physical inventory" Request Completed.

You can find out physical inventory name to check "Snapshot Complete" Status (as below picture)

• Generate tags(列印盤點清冊、盤點卡)

Default Tag Type: Contain information on the items in your physical inventory definition.

Oracleinventory generates atag for very unique combination of item,subinventory,locator,revision,lot number, and serial number that exists in your physical inventory definition.

Check "Generate physical inventory tags" Request Status ==> Completed

 

PHYSICAL_INVENTORY_ID=2767, STARTING_TAG_NUMBER=TI200900001, DIGIT_INCREMENTS=00011111111, ENDING_TAG_NUMBER=TI200904405, NUMBER_OF_BLANK_TAGS=4405, PREPRINT_TAGS=1, SHOW_SERIAL_NUMBERS=1