This article covers the following topics:
Product Reconciliations
This section shows a log of Product Reconciliations to date and is used to physically reconcile inventory.
How do I create a Reconciliation?
- Log in to the Inventory application.
- From the left navigation pane click Administration then Product Reconciliations.
- This will take you to the Product Reconciliations page where you can initiate a reconciliation and view past reconciliations listed on the table.
- The first blue header indicates that you are viewing Product Reconciliations, at the end of this header you'll see the Per page field that allows you to choose how many rows per page you can view, and the Search field for you to search for a particular reconciliation.
- Below this are the column headers:
- Date: The date the reconciliation was carried out.
- Initiated By: The name of the user who carried out the reconciliation.
- Initiated At: The date and time the reconciliation began.
- Status:
- Completed Status: The reconciliation was successfully completed and saved to inventory.
- Active Status: A reconciliation was backed out of without canceling or saving, the system views this as the reconciliation is still in process.
- Products Reconciled: The difference between the inventory listed in the system and the product recently counted.
- Actions: Click the blue icon to view a completed reconciliation and the orange icon to edit an active reconciliation.
- Click the blue + New Reconciliation to begin a new reconciliation.
- A note will generate alerting you that once the reconciliation begins, quantities and weights will not be editable until the reconciliation is complete.
- Click Start Reconciliation to start the reconciliation.
- A full list of reconciliation details will appear.
- Enter any changes to the System Quantity in the Actual Quantity field of the product(s) you are reconciling.
- Enter any changes to the System Weight in the Actual Weight fields of the product(s) you are reconciling.
- Once you've completed your changes scroll to the bottom of the page and click Finish Reconciliation.
- If you are unable to complete the reconciliation click Cancel & Delete; if a reconciliation is backed out of without canceling or saving, the system views this as the reconciliation is still in process and other users will not be able to record quantities or weights.
- In the top right-hand corner, click on Printable Version to print the list or Export to Excel to export the list to Excel.
- When you click Finish Reconciliation the screen will dim and a warning will pop up asking if you're sure you want to make the adjustment.
- Click OK to finish the reconciliation and Cancel to return to the Reconciliation Details page.
Reconciliation Column Details:
- Category: Category of the product.
- Product: Name of the product.
- Location: Where the product is located.
- Item Number: The item number of the product (if applicable).
- System Quantity: Current quantity of that product in the system.
- System Weight: Current weight of that product in the system.
- Actual Quantity: Actual quantity counted of that product.
- Actual Weight: Actual weight of the product once weighed during reconciliation.
- Notes: Any notes applicable to the product being reconciled.
One User at a Time
Only one user can perform a reconciliation at a time. If another user within the organization has already begun a reconciliation, another user cannot begin one until that reconciliation is complete.
Only one user can perform a reconciliation at a time. If another user within the organization has already begun a reconciliation, another user cannot begin one until that reconciliation is complete.
How do I view a Completed Reconciliation List?
- Log in to the Inventory application.
- From the left navigation pane click Administration then Product Reconciliations.
- This will take you to the Product Reconciliations page where you can initiate a reconciliation and view past reconciliations listed on the table.
- Click on the blue view icon in the Actions column of the reconciliation entry.
- A complete list will appear of the completed reconciliation.