module:inventory:inventoryonhand:list
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
module:inventory:inventoryonhand:list [2014/06/20 18:02] target |
module:inventory:inventoryonhand:list [2015/05/29 18:17] (current) target |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| This section is the Inventory On Hand. It contains the quantity of items on hand or in the warehouse. \\ | This section is the Inventory On Hand. It contains the quantity of items on hand or in the warehouse. \\ | ||
| - | Overview: Inventory On Hand is the tally module of active items in item master file. Inventory on hand balance computation comes from system job orders and inventory adjustment. Items shown here were classified according to warehouse and item class. | + | **Overview: |
| + | ** | ||
| + | Inventory On Hand is the tally module of active items in item master file. Inventory on hand balance computation comes from system job orders and inventory adjustment. Items shown here were classified according to warehouse and item class. | ||
| - | Balance Calculation Basis: | + | **Balance Calculation Basis:** |
| + | |||
| + | System inventory balance calculation is sensitive to document report date and reported physical count dates. Meaning, user (in this case the report doer) should know when actual transaction made and whether the transaction is made on or before the reference physical count. | ||
| + | |||
| + | PM Quantity | ||
| + | * system resets inventory on hand balance base on Inventory Count JO reported quantity; | ||
| + | * system subtracts count from balance base on Preparation JO __requested__ quantity; | ||
| + | * system adds count from balance base on Receiving JO __requested__ quantity; | ||
| + | * system adds count from balance base on Back-load JO __requested__ quantity; | ||
| + | * system either add or subtracts from balance base on Inventory Adjustments made; | ||
| + | * system either add or subtracts from balance base on Transfer JO __requested__ quantity; | ||
| + | * system performs check and balance to consider mismatched request and reported quantities | ||
| + | note: JO preparation limits the allowable request quantity base on this balance assuming that PM request are followed every time. | ||
| + | |||
| + | WH Quantity | ||
| + | * system resets inventory on hand balance base on Inventory Count JO __reported__ quantity; | ||
| + | * system subtracts count from balance base on Preparation JO __reported__ prepared quantity; | ||
| + | * system adds count from balance base on Receiving Report __reported received__ quantity; | ||
| + | * system adds count from balance base on Back-load JO __reported back-loaded__ quantity; | ||
| + | * system either add or subtracts from balance base on Inventory Adjustments made; | ||
| + | * system either add or subtracts from balance base on Transfer JO __reported transferred__ quantity; | ||
| + | note: This balance is the current item inventory in the warehouse excluding all preparation | ||
| + | |||
| + | ACCT Quantity | ||
| * system resets inventory on hand balance base on Inventory Count JO reported quantity; | * system resets inventory on hand balance base on Inventory Count JO reported quantity; | ||
| - | * system subtracts count from balance base on Preparation JO reported prepared | + | * system subtracts count from balance base on Delivery Report__ Delivered__ |
| * system adds count from balance base on Receiving Report received quantity; | * system adds count from balance base on Receiving Report received quantity; | ||
| * system adds count from balance base on Back-load JO reported back-loaded quantity; | * system adds count from balance base on Back-load JO reported back-loaded quantity; | ||
| * system either add or subtracts from balance base on Inventory Adjustments made; | * system either add or subtracts from balance base on Inventory Adjustments made; | ||
| - | * system either add or subtracts from balance base on Transfer JO transferred quantity; | + | * system either add or subtracts from balance base on Transfer JO transferred quantity; |
| + | note: This balance is the current item inventory in the warehouse including all preparation | ||
| Notes to consider to Keep Inventory Accuracy using this system: | Notes to consider to Keep Inventory Accuracy using this system: | ||
| Line 25: | Line 51: | ||
| * communicate with concern department officers as soon as question arises | * communicate with concern department officers as soon as question arises | ||
| - | Ways on how to re-align inventory to current count: | + | Guide on how to re-align inventory |
| - | * Unordered List Item | + | * have all inventory affecting job orders reported to reflect most updated count |
| + | * conduct inventory count (physical or cycle) using system Inventory count JO | ||
| + | * encode and check actual count versus system count | ||
| + | * check items with huge variance and trace transaction history (double click " | ||
| + | * check for over looked transactions | ||
| + | * make necessary adjustments in affected records (use inventory adjustment as last resort) | ||
| + | * re-check until variances are minimized | ||
| + | * post inventory count report to reflect new and accurate actual count | ||
| + | note: system inventory balance under inventory item class should align with accounting' | ||
| + | |||
module/inventory/inventoryonhand/list.1403258543.txt.gz · Last modified: 2014/06/20 18:02 by target
Page Tools
