Skip to main content

Inventory Valuation Report

Distributor steps for running the Inventory Valuation report in Encompass for a date range, with what each column means (posted vs FIFO value, posted before received, unposted purchases). Requires v22.01+.

B
Written by Bailey Naas-Thornton

Minimum Version Required: 22.01

Steps

How to Make an Inventory Valuation Report
​
​

1. Using Universal Search, navigate to the Inventory Valuation link.
​
​2. Select a date period by setting the start and end date.
​
3. Users can add more information to the report by selecting the column checkboxes on the left-hand side or filtering the report by "Product Name", "Product Type", "Supplier", or "Brand".
​
4. Click the Create Report to show changes made.
​

Fields And Definitions

Report Column Definitions
​
​

  • Posted Value (Beginning) - Inventory Value for Verified status inventory transactions at the selected report Start Date as of 12 am.
    ​
    ​

  • Posted Qty (Beginning) - Inventory Quantity in units at the selected report Start Date as of 12 am.
    ​
    ​

  • Posted Invoices - Inventory sales transactions in Verified status that fall within the period specified by the Start Date and End Date selected.
    ​
    ​

  • Posted Purchases - Inventory purchase transactions in Verified status that fall within the period specified by the Start Date and End Date selected.
    ​
    ​

  • Posted Value (Ending) - Inventory Value for Verified status inventory transactions at the End Date specified.
    ​
    ​

  • Posted Qty (Ending) - Inventory Quantity in units for Verified status transactions through the End Date specified.
    ​
    ​

  • Posted Before Received - This column reports received date vs accounting date discrepancies for QuickBooks Desktop accounting system users.
    ​
    - For Encompass Financials users, this may also reflect amounts when the Receive Date for a Purchase transaction falls AFTER the Post Date.
    ​
    - Example, Receive Date is 11/1 but Post Date was changed to 10/31.
    ​
    ​

  • Posted Before Received Qty - This column reports receive date vs accounting date quantity discrepancies for QuickBooks Desktop accounting system users.
    ​
    - For Encompass Financials users, this may also reflect amounts when the Receive Date for a Purchase transaction falls AFTER the Post Date.
    ​
    - Example, Receive Date is 11/1 but Post Date was changed to 10/31.
    ​
    ​

  • Unposted Purchases - Received and Confirmed Purchase transactions stated in dollars.
    ​
    ​

  • Unposted Purchases Qty - Received and Confirmed Purchase transactions stated as a quantity.
    ​
    ​

  • Pending FIFO Adj - Default Freight and Default Tax values can be updated in manual or auto-calculated fashion. Pending transactions of this type are displayed in this report column.
    ​
    ​

  • FIFO Value (Ending) - Includes inventory Purchase transactions in Received and Confirmed status, which are excluded from POSTED inventory valuation totals.
    ​
    - Note: Since “Received” and “Confirmed” transactions are transient (not yet verified) data statuses, these values will continue to change as related Purchase transactions are finalized. Therefore, this report total should not be used for end of month inventory valuation.
    ​
    ​

  • FIFO Qty (Ending) - Includes Inventory Purchase transactions in Received and Confirmed status, which are excluded from POSTED inventory valuation totals.
    ​
    - Note: “Received” and “Confirmed” transactions represent transient (not yet verified) purchases.

Did this answer your question?