Calculation of In-Warehouse Quantities on Count Date
The posting date and the creation date of an inventory transaction are not necessarily the same.
Note
The creation date (database system date) is not visible on the user interface; it is recorded in the database.
Depending on your setting of the Calculate In-Whse Qty on Count Date Based On
field in the Document Settings
window, the system calculates the in-warehouse quantities on the count date differently, as illustrated in the examples below. Note that this field is available for both inventory counting and inventory posting documents but its setting must be the same for both documents. For more information, see Document Settings: Per Document Tab.
Example
A batch of items is issued from the warehouse on November 6, 2013 (posting date), but you do not record the inventory transaction in the system until November 8, 2013 (creation date). The item quantity is 10.
On November 7, 2013 (count date), you perform inventory counting. On November 9, 2013, you create an inventory counting document to record the results.
In-warehouse quantities on the count date differ, depending on the calculation basis:
Transaction posting date: A quantity of 10 is added to the in-warehouse quantity of the item on the count date.
Transaction creation date: The in-warehouse quantity of the item on the count date does not include the 10.
Example
Prerequisite: You have enabled future posting for this company. For more information, see Document Settings: General Tab.
A batch of items is issued from the warehouse on November 6, 2013 (posting date). You foresaw this transaction and recorded it in the database on November 4, 2013 (creation date). The item quantity is 10.
On November 5, 2013 (count date), you perform inventory counting and create an inventory counting document to record the results.
In-warehouse quantities on the count date differ, depending on the calculation basis:
Transaction posting date: The in-warehouse quantity of the item on the count date still includes the 10 items.
Transaction creation date: A quantity of 10 is subtracted from the in-warehouse quantity of the item on the count date.
Other Different Behaviors
Some other differences exist between the two options, as listed below in the table:
Subject |
|
|
|---|---|---|
Ability to record the count time | Disabled | Enabled |
If a transaction is created on the count date or posted to the count date, what happens? | Transactions posted to the count date are included in the calculation of in-warehouse quantities on the count date. To avoid inconsistency between the system and the actual numbers, we highly recommend that you do not allow any inventory transactions after counting begins on the count date. | Transactions created before the count time are included in the calculation of in-warehouse quantities on the count date. The creation time of transactions is also recorded in the database and not visible on the user interface. |
Automatic refresh of in-warehouse quantities on the count date | The system asks whether you want to recalculate in-warehouse quantities when you do one of the following:
If you agree to recalculate the in-warehouse quantities, the following information is recalculated as well:
| Irrelevant |