Stock Reconciliation Report

Understand what's shown on the report and how they are calculated.

Example:

  • Opening Balance - Closing balance of the stock take for a previously closed stock take for each location

    • Only full stock takes (not partial)

    • Previous stock take e.g. if the current month is June, it shows the May stock take if closed

  • Closing Balance - Closing balance of the stock take for the current closed stock take for each location

    • Only full stock takes (not partial)

    • Current stock take e.g. if the current month is June, it shows the June stock take if closed

  • Direct Purchase Value - The sum of all the transfer items from Suppliers to the stock locations i.e. Stock Receipts

    • Where the destination is the specified location

  • Sale Value - The sum of all the transfer items of completed outgoing transfers to the location that were processed between an open and closed date

    • Where the origin is the specified location

  • Transfer In Value - The sum of all the transfer items of completed incoming transfers of the following types: Stock Transfer, Internal Requisition Transfer

    • Where the origin is the specified location

  • Transfer Out Value - The sum of all the transfer items of completed outgoing transfers of the following types: Stock Transfer, Internal Requisition Transfer

    • Where the origin is the specified location

  • Adjustment Value - The difference of the outgoing adjustment transfers and the incoming adjustments transfers

    • Incoming adjustment transfers - sum of all the transfer items of completed incoming adjustment transfers

    • Outgoing adjustment transfers - sum of all the transfer items of completed incoming adjustment transfers

  • Price Adjustment Value - The sum of the adjusted value of all the value adjustments

  • Variance Value - The sum of the completed variance transfers

Opening Balance - Closing balance of the stock take for a previously closed stock take for each location

  • Only full stock takes (not partial)

  • Previous stock take e.g. if the current month is June, it shows the May stock take if closed

Closing Balance - Closing balance of the stock take for the current closed stock take for each location

  • Only full stock takes (not partial)

  • Current stock take e.g. if the current month is June, it shows the June stock take if closed

Direct Purchase Value - The sum of all the transfer items from Suppliers to the stock locations i.e. Stock Receipts

  • Where the destination is the specified location

Sale Value - The sum of all the transfer items of completed outgoing transfers to the location that were processed between an open and closed date

  • Where the origin is the specified location

Transfer In Value - The sum of all the transfer items of completed incoming transfers of the following types: Stock Transfer, Internal Requisition Transfer

  • Where the origin is the specified location

Transfer Out Value - The sum of all the transfer items of completed outgoing transfers of the following types: Stock Transfer, Internal Requisition Transfer

  • Where the origin is the specified location

Adjustment Value - The difference of the outgoing adjustment transfers and the incoming adjustments transfers

  • Incoming adjustment transfers - sum of all the transfer items of completed incoming adjustment transfers

  • Outgoing adjustment transfers - sum of all the transfer items of completed incoming adjustment transfers

Price Adjustment Value - The sum of the adjusted value of all the value adjustments

Variance Value - The sum of the completed variance transfers

Notes:

  • The periods need to be fully closed (not partial)

  • Transfers need to be completed to be included