Report Name: RPT-IN-014 Inventory Turns and All Items Valuation Report
Report Description: Inventory Turns Report lists Cost Organization, Cost Book, Inventory Organization Code, Inventory Organization Name, Item Number, Item Description, Primary UOM, Beginning On-hand Qty, Beginning Value, Ending On-hand Qty, Ending Value , Cost of Goods Sold (COGS), Inventory Turns, Current On-hand Qty, Current On-hand value and Days Sale of Inventory based on the date range parameter provided. Warehouse managers/staff should be able to view the report output for the organization(s) which they have access to.
Report Data Flow: Customers/end users create Internal Requisition orders (consumption orders) in Self-Service Procurement. Warehouse managers/staff can request transfer of items from other Inventory Organizations by using Transfer Orders and can process returns to other Inventory Organizations by using Transfer Order Returns (Issuing or Receiving warehouse). Warehouse managers/staff can issue items over the counter using miscellaneous transactions, movement request issue, inter-organization transfer using direct/in-transit transfers and can process returned items in full or partial that were shipped over the counter using Miscellaneous Transactions (Issuing warehouse manager) or through transfer order returns. Warehouse managers/staff receives the Purchase Order in inventory organization(s). Warehouse managers run and review the ‘Inventory Turns Report’ to review the Cost Organization, Cost Book, Inventory Organization Code, Inventory Organization Name, Item Number, Item Description, Primary UOM, Beginning On-hand Qty, Beginning Value, Ending On-hand Qty, Ending Value , COGS, Inventory Turns, Current On-hand Qty, Current On-hand value and Days Sale of Inventory based on the date range parameter provided.