Design Details: Posting Date on Adjustment Value Entry
This article provides guidance for users of the Inventory Costing functionality in Business Central, and in particular for how the Adjust Cost - Item Entries batch job identifies and assigns a posting date to the value entries that the batch job is about to create.
How posting dates are assigned
The Adjust Cost – Item Entries batch job assigns a posting date to the value entry it is about to create in the following steps:
Initially the Posting Date of the entry to be created is the same date as the entry it adjusts.
The Posting Date is validated against Inventory Periods and/or General Ledger Setup.
Assignment of Posting Date; If the initial Posting Date is not within allowed posting date range the batch job will assign an allowed Posting Date from either General Ledger Setup or Inventory Period. If both Inventory Periods and allowed posting dates in General Ledger Setup are defined, the later date of the two will be assigned to the Adjustment Value Entry.
Let’s review this process more in practice. Assume we have an Item Ledger Entry of Sale. The item was shipped on September 5, 2020 and it was invoiced the day after.
Item Ledger Entry
| Entry No. | Item No. | Posting Date | Entry Type | Document No. | Location Code | Quantity | Cost Amount (Actual) | Invoiced Quantity | Remaining Quantity |
|---|---|---|---|---|---|---|---|---|---|
| 319 | A | 2020-09-05 | Sale | 102033 | Blue | -1 | -11 | -1 | 0 |
Below are the related value entries:
- Entry No. 379 represents the shipment and carry the same Posting Date as the parent Item ledger Entry.
- Entry No. 381 represents the invoice.
- Entry No. 391 is an Adjustment of the invoicing Value Entry (Entry No. 381 above).
| Entry No. | Item No. | Posting Date | Item Ledger Entry Type | Entry Type | Document No. | Item Ledger Entry No. | Location Code | Item Ledger Entry Quantity | Invoiced Quantity | Cost Amount (Actual) | Cost Amount (Expected) | Adjustment | Applies-to Entry | Source Code |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 379 | A | 2020-09-05 | Sale | Direct Cost | 102033 | 319 | Blue | -1 | 0 | 0 | -10 | No | 0 | Sales |
| 381 | A | 2020-09-06 | Sale | Direct Cost | 103022 | 319 | Blue | 0 | -1 | -10 | 10 | No | 0 | Sales |
| 391 | A | 2020-09-10 | Sale | Direct Cost | 103022 | 319 | Blue | 0 | 0 | -1 | 0 | Yes | 181 | INVTADJMT |
To assign the posting date for Entry No. 391 the following steps were applied:
The Adjustment Value Entry to be created (Entry No. 391) is assigned same Posting Date as the entry it adjusts.
The Adjust Cost – Item Entries batch job determines if the initial Posting Date of the Adjustment Value Entry is within allowed posting date range based upon Inventory Periods and/or General Ledger Setup.
Let’s review the above mentioned Sale by adding setup of allowed posting date ranges.
Inventory Periods
| Ending Date | Name | Closed |
|---|---|---|
| 2020-01-31 | January 2020 | Yes |
| 2020-02-28 | February 2020 | Yes |
| 2020-03-31 | March 2020 | Yes |
| 2020-04-30 | April 2020 | Yes |
| 2020-05-31 | May 2020 | Yes |
| 2020-06-30 | June 2020 | Yes |
| 2020-07-31 | July 2020 | Yes |
| 2020-08-31 | August 2020 | Yes |
| 2020-09-30 | September 2020 | |
| 2020-10-31 | October 2020 | |
| 2020-11-30 | November 2020 | |
| 2020-12-31 | December 2020 |
The first allowed posting date is the first day in the first open period, which is September 1, 2020.
General Ledger Setup
| Field | Value |
|---|---|
| Allow Posting From: | 2020-09-10 |
| Allow Posting To: | 2020-09-30 |
| Register Time: | |
| Local Address Format: | Post Code |
The first allowed posting date is the date stated in field Allow Posting From: September 10, 2020. If both Inventory Periods and allowed posting dates in General Ledger Setup are defined, the later date of the two will define the allowed posting date range.
Assignment of an allowed posting date
The initial assigned Posting Date was September 6 as illustrated in step 1. However, in the second step the Adjust Cost – Item entries batch job identifies that earliest allowed Posting Date is September 10 and thereby assigns September 10 to the Adjustment Value Entry (Entry No. 391), below.
| Entry No. | Item No. | Posting Date | Item Ledger Entry Type | Entry Type | Document No. | Item Ledger Entry No. | Location Code | Item Ledger Entry Quantity | Invoiced Quantity | Cost Amount (Actual) | Cost Amount (Expected) | Adjustment | Applies-to Entry | Source Code |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 379 | A | 2020-09-05 | Sale | Direct Cost | 102033 | 319 | Blue | -1 | 0 | 0 | -10 | No | 0 | Sales |
| 381 | A | 2020-09-06 | Sale | Direct Cost | 103022 | 319 | Blue | 0 | -1 | -10 | 10 | No | 0 | Sales |
| 391 | A | 2020-09-10 | Sale | Direct Cost | 103022 | 319 | Blue | 0 | 0 | -1 | 0 | Yes | 181 | INVTADJMT |
Common problems with the "Adjust Cost - Item entries"-batch job
There are two scenarios that the support team encounters frequently enough for them to warrant their own problem resolution articles.
Error message: "Posting Date is not within your range of allowed posting dates…"
If you encounter this error you need to adjust the dates for which the user is allowed to post entries. To learn more, see Error Message "Posting Date is not within your range of allowed posting dates".
Posting Date on Adjustment Value Entry versus Posting Date on entry causing the adjustment such as Revaluation or Item charge
To learn more, see Posting Date on Adjustment Value Entry Compared to the Source Entry.
See also
Design Details: Inventory Costing
Design Details: Item Application