Widgets

Inventory Movement Trend

This widget displays the trend of inventory value movement over time, including overall movement and the impact of received, issued, and adjusted transactions for the selected filters.

The inventory value can be calculated using this formula: Sum (Posted Amount)

Inventory Transaction Trend

This widget displays the trend of total inventory transaction activity over time to identify peaks, seasonality, or unusual spikes.

The total inventory transaction can be calculated using these formulas:

• Sum (Posted Amount) where Qty > 0
• Sum (Posted Amount) where Qty < 0
• Sum (Posted Amount) where Qty = 0

Top 10 Items Received

This widget displays the top ten items by total received amount during the selected period.

The total received amount can be calculated using this formula: Sum (Posted Amount) where Qty > 0

Top 10 Items Issued

This widget displays the top 10 items by total issued amount during the selected period.

The total issued amount can be calculated using this formula: Sum (Posted Amount) where Qty < 0

Cycle Count Variance Value By ABC Class

This widget displays the cycle count variance by ABC classification to identify inventory classes contribute with count differences.

The cycle count variance can be calculated using these formulas:

• Sum (Qty) where transaction Type is Cycle Count
• Sum (Posted Amount) where Transaction Type is Cycle Count