How RFMS Selects Inventory for the Month-End Inventory Balance Report

  Back to Month-End Accounting Guide

Use this article when you need to understand why a specific inventory record or customer order line appears, does not appear, or has a different value than expected on the Month-End Inventory Balance Report.

For a general overview of the report, see Month-End Inventory Balance Report — Non-ERRM.

How RFMS Selects Records

RFMS starts with the inventory record and reviews the activity tied to that record as of the selected report date.

The report may review:

• received date;
• invoice date;
• available quantity;
• reserved quantity;
• used quantity;
• cut date;
• delivery date;
• job cost date;
• inventory adjustments.

These dates and quantities help determine whether inventory value should be included in the month-end balance.

Whey a Record May Appear or Not Appear

A record may appear on the report when RFMS determines that the inventory value should still be included as of the selected report date.

A record may not appear when RFMS determines that the inventory was not part of inventory as of that date, or when the material was sold, delivered, job costed, adjusted, or otherwise removed before the report date.

If customer order activity happened after the report date, RFMS may still include the related inventory value for the month being reviewed.

What to Check

When reviewing a record, confirm:

• the report date;
• store or Combine selection;
• received date;
• invoice date;
• available, reserved, and used quantity;
• cut date, delivery date, or job cost date, if tied to an order;
• inventory adjustments posted after the report date.

If the record still does not make sense, contact RFMS Support before making manual corrections.

RFMS May review cut date and delivery date on customer order lines when determining whether inventory value belongs on the Month-End Inventory Balance Report.