Contents
Introduction
The mid-period counts feature helps provide more accurate end of period stock count values for larger operations that perform stock counts over a longer period of time during trading hours.
For counts that are entered before the period has ended, the mid-period counts feature adjusts the count value in period reports if stock movements (e.g. sales, wastage, transfers) have occurred between the time that the count was entered and the time that the period has ended.
Enabling The Mid-Period Counts Feature
The mid-period counts feature is enabled per site.
To enable this, log into the relevant site and head to Company Settings > Site Setup > Site.
Select the Inventory Management tab and then enable the Enable Mid Period Counts checkbox.
Select [SAVE SITE].
Using The Mid Period Counts Feature
Entering Counts
IMPORTANT: When entering counts into stock count sheets, it's important to ensure that the period is in the correct state before doing so:
- If the period is ongoing and has not yet ended, the period should be in Current state.
- if the period has ended and final counts are being entered, the period should be in Pending state.
The method of entering counts is no different when the mid-period counts feature is enabled. However, when mid-period counts is enabled, you now have visibility of when the count was entered into any quantity field against the row within the Counted On column:
Note that the Counted On time displays:
- The date and time that the count was entered, if the count is entered before the period end date.
- The period end date, if the count is entered after the period end date.
If the count is later changed, the Counted On time will also update to reflect the update count.
Period Count Exceptions
When Approving the period (or running the Trial Approve), the period will check to see if the product exists on multiple count sheets within the period. If it does, the period will then check to see if any stock movements (e.g. sales, wastage, transfers) occurred between the times that the product was counted on each count sheet.
If any stock movements have occurred, a Period Exception is generated for that product and an updated counted must be entered in order to clear the exception before approving the period. Select [COUNT] against the exception to enter the counts within the applicable stock count sheet(s).
Period Reports
Before reviewing period reports, it is recommended that a Trial Approve is run and all exceptions are cleared within the period.
Within period reports, the closing count figure is adjusted to reflect any movements that occurred after the count was declared. For example:
- 09:31: A count of 1.2 packs is entered.
- 11:15: Wastage of 0.5 packs is declared.
- 12:00 The period ends. The adjusted count displays at 0.7.