How are the columns “FIFO value and “Value at month-end” calculated?

How pricing works

Both columns use the same price source:

• The delivery price registered when spare parts are received into stock

There is no difference in pricing logic—only in which quantities are included.

FIFO value (current value)

FIFO value shows the current inventory value.

How it is calculated

• Based on remaining quantities in stock
• Uses FIFO (First In, First Out) layers
• Calculation:
  • Remaining quantity per delivery × delivery price

This reflects the real-time stock value.

Value at month-end

Value at month-end shows the inventory value at the end of the previous month.

How it is calculated

1. Identify all deliveries made before the month shift
2. Subtract any withdrawals made before that date
3. Calculate value based on remaining quantities at that point

This represents a historical snapshot of inventory.

Why is the value 0.00?

If Value at month-end = 0.00, the most common reason is:

• All deliveries were made during the current month
• No stock existed at the previous month-end

Therefore, the system has no quantity to calculate a value from.

Key difference

• FIFO value = value now
• Value at month-end = value at a past point in time

Troubleshooting

Value at month-end is unexpectedly low or zero

• Check delivery dates (were items received after the month shift?)
• Verify if stock existed at the end of the previous month

Values do not match expectations

• Review withdrawals made before month-end
• Confirm delivery prices were correctly registered