An Accounting Seed recommended best practice for month-end close is to reconcile all sub-ledgers to the general ledger. (see Best Practices for Month End for more detail). When utilizing inventory accounts, this includes a periodic reconciliation between the inventory sub-ledger and the Trial Balance. An inventory sub-ledger is essentially the detail of your inventory that isn’t captured in your general ledger. In this case, the inventory quantities are captured in two different objects:
- Inventory Quantity Available - Captures the inventory quantities available and inventory movements as of the current point in time in the system. (see Checking Inventory Quantity Available for more detail).
- Inventory Quantity Available Histories - Captures the inventory quantities available and inventory movements as of a specific past point in time in the system. Typically, you will generate these history records at month-end but it can be for any date.
A key requirement for performing inventory reconciliations at month-end is to create a snapshot of the inventory quantities at that date. The method used to create this historical Inventory Quantity Available detail is the Create Inventory History process available on the Inventory Quantity Available list view.
Create an Inventory Quantity Available History Record(s)
Perform these steps to create an Inventory Quantity Available History record(s):
- Navigate to Accounting Home and under Orders & Inventory, click Inventory Quantity Available.
- Select the “All” list view to ensure that all Inventory Quantity Available records are available to the Create Inventory Histories process. If only a subset of the Inventory Quantity Available records are required, a custom list view can be created.
- For this example, a custom list view was selected.
- Select the specific Inventory Quantity Available records, by checking the checkbox beside them, that Inventory Histories need to be created for.
- If Inventory Histories are required for all Inventory Quantity Available records shown in the selected list view, select the checkbox in the column heading section will automatically select all records.
- Due to limits on the number of records you can select in a list view, it is important to note that you can only select a maximum of 200 records at one time. If you have more than 200 records, you will need to process in batches of 200 at a time.
- If you have a substantially large number of Inventory Quantity Available records whereby doing them in batches of 200 would be inefficient, you can create an automated job to run through this process in batch. A Salesforce developer or an Accounting Seed certified service partner can assist with this. Please contact Support for more information.
- Once the Inventory Quantity Available records required have been selected click the Create Inventory History button to start the process.
- Select the date you would like to create Inventory History records for. This is the period end date and should align with the end date of the period that is being reconciled. Once set, click the Create History button to create the Inventory History records.
The Inventory History job, based on the number of Inventory Quantity Available records selected, could take a bit of time to complete. As such, the notification displayed is only that the job was successfully submitted.
- The job’s status can be ascertained by either:
- If the number of records is small, directly checking the Inventory Quantity Available records.
- Wait for the email notification.
- Goto the Apex Jobs Status list and verify the status. This list can be viewed by going into Setup, entering “job” in the Quick Find search box and then select Apex Jobs in the side menu.
- When the job has successfully completed, the Inventory History record created for a specific Inventory Quantity Available record can be found on that record’s related list.
- The Inventory Quantity Available History record detail can be seen by either clicking the Inventory Quantity Available History name or by clicking on View All.
- The Inventory History record is cumulative up to the date set on the request. Below is an example showing the 8/31 record, an interim record for 9/10 which includes all transactions through 9/10, and the 9/30 record which now includes all transactions through 9/30.
- Once the Inventory History records have been created, they can now be used in reports and to perform reconciliations. See the Report on and Reconcile Inventory article for more detail.
- The Create Inventory Quantity Available History intermediate screen is available in the Lightning UI.
- The Inventory Balance object has been renamed to Inventory Quantity Available.