Posting date on adjustment value entry compared to the source entry

This article compares the Posting Date on the Adjustment Value Entry with the Posting Date on the entry causing the running of the Adjust Cost - Item Entries batch job, in particular a Revaluation scenario and an Item Charge scenario.

The Adjust Cost - Item Entries batch job will process your data depending on your scenario and configuration of Business Central. In this section, we describe two separate processes, and for each one we show the type of impact the Adjust Cost - Item Entries batch job has on the data.

Revaluation scenario

Prerequisites

Please enter the following values:

Inventory setup:

  • Automatic Cost Posting = Yes

  • Automatic Cost Adjustment = Always

  • Average Cost Calc. Type = Item

  • Average Cost Period = Day

General Ledger Setup:

  • Allow Posting From = January 1, 2021

  • Allow Posting To = Empty

User Setup:

  • Allow Posting From = December 1, 2020

  • Allow Posting To = Empty

To test the scenario

Test this scenario by carrying out the following steps.

  1. Create an Item called TEST with the following values:

    • Base unit of measure = PCS

    • Costing Method = Average

    • Select optional posting groups.

  2. Open an Item Journal, then create a new entry, and post a line as follows:

    • Posting Date = December 15, 2020

    • Item = TEST

    • Entry Type = Purchase

    • Quantity = 100

    • Unit Amount = 10

  3. Open an Item Journal, then create a new entry, and post a line as follows:

    • Date = December 20, 2020

    • Item = TEST

    • Entry Type = Negative Adjustment

    • Quantity = 2

  4. Open an Item Journal, then create a new entry, and post a line as follows:

    • Date = January 15, 2021

    • Item = TEST

    • Entry Type = Negative Adjustment

    • Quantity = 3

  5. Open an Item Revaluation Journal, then create a new entry, and post a line as follows:

    • Item = TEST

    • Applies-to Entry = select Purchase entry posted at step 2. The Posting Date of the revaluation will be the same as the entry it adjusts.

    • Unit Cost (Revalued) = 40

The following Item Ledger and Value Entries have been posted:

Item Ledger Entry - purchase:

Entry NumberItem No.Posting DateEntry TypeDocument No.QuantityCost Amount (Actual)Remaining Quantity
317TEST2020-12-15PurchaseT00001100400095

Value Entries

Entry NumberItem No.Posting DateItem Ledger Entry No.Item Ledger Entry TypeEntry TypeDocument No.Item Number Entry QuantityCost Amount (Actual)Cost Posted to G/LAdjustmentApplies to EntrySource Code
376TEST2020-12-15317PurchaseDirect CostT000011001 000,001 000,00No0ITEMNL
379TEST2020-12-15317PurchaseRevaluationT0400203 000,003 000,00No0REVALINL

Item Ledger Entry - negative adjustment, Step 3

Entry No.Item No.Posting DateEntry TypeDocument No.QuantityCost Amount (Actual)Remaining Quantity
318TEST2020-12-20Negative Adjmt.T00002-2-800

Value Entries

Entry NumberItem No.Posting DateItem Ledger Entry No.Item Ledger Entry TypeEntry TypeDocument No.Item Number Entry QuantityCost Amount (Actual)Cost Posted to G/LAdjustmentApplies to EntrySource Code
377TEST2020-12-20318Negative Adjmt.Direct CostT00002-2-20-20No0ITEMNL
380TEST2021-01-01318Negative Adjmt.Direct CostT040020-60-60Yes377INVTADAMT

Item Ledger Entry - negative adjustment, Step 4

Entry No.Item No.Posting DateEntry TypeDocument No.QuantityCost Amount (Actual)Remaining Quantity
319TEST2021-01-15Negative Adjmt.T00003-3-1200

Value Entries

Entry NumberItem No.Posting DateItem Ledger Entry No.Item Ledger Entry TypeEntry TypeDocument No.Item Number Entry QuantityCost Amount (Actual)Cost Posted to G/LAdjustmentApplies to EntrySource Code
378TEST2021-01-15319Negative Adjmt.Direct CostT00003-3-30-30No0ITEMNL
381TEST2021-01-15319Negative Adjmt.Direct CostT040030-90-90Yes378INVTADAMT

The Adjust Cost – Item Entries batch job has recognized a change in cost and adjusted the Negative Adjustments.

Review of Posting Dates on created adjustment value entries: The earliest allowed Posting Date the Adjust Cost - Item Entries batch job has to relate to is January 1, 2021 as stated in the General Ledger Setup.

Negative Adjustment in step 3: assigned Posting Date is January 1, provided by General Ledger Setup. The Posting Date of the Value Entry in the scope for adjustment is December 20, 2020. According to the General Ledger Setup, the date is not within the allowed posting date range. Therefore the Posting Date stated in the Allow Posting From field in the General Ledger Setup is assigned to the Adjustment Value Entry.

Negative Adjustment in step 4: assigned Posting Date is January 15. The Value Entry in scope of adjustment has Posting Date January 15, which is within the allowed posting date range according to General Ledger Setup.

The adjustment made for the Negative Adjustment in step 3 causes discussion. The favorable Posting Date for the Adjustment Value Entry would have been December 20 or at least within December as the revaluation causing the change in COGS was posted in December.

To achieve adjustment in December of the Negative Adjustment in step 3, the General Ledger Setup, Allow Posting From field, needs to state a date in December.

Conclusion

With the experience gained in this scenario, when considering the most suitable setup for an allowed posting date range for a company, you might want to consider the following. As long as you allow changes in the inventory value to be posted in a period, such as December in this case, the setup that the company uses for allowed posting date ranges should be aligned with this decision. The Allow Posting From in the General Ledger Setup, stating December 1, would allow the revaluation made in December to be forwarded to affected outbound entries in the same period.

User groups not allowed to post in December but in January, which was probably intended to be limited by the General Ledger Setup in this scenario, should instead be addressed via the User setup.

Item charge scenario

Prerequisites

Please enter the following values:

Inventory setup:

  • Automatic Cost Posting = Yes

  • Automatic Cost Adjustment = Always

  • Average Cost Calc. Type = Item

  • Average Cost Period = Day

General Ledger Setup:

  • Allow Posting From = December 1, 2020.

  • Allow Posting To = Empty

User Setup:

  • Allow Posting From = December 1, 2020.

  • Allow Posting to = Empty

To test the scenario

Test this scenario by carrying out the following steps:

  1. Create an Item Charge with the following values:

    • Base unit of measure = PCS

    • Costing Method = Average

    • Select optional posting groups.

  2. Create a new Purchase Order with the following values:

    • Buy-from Vendor No.: 10000

    • Posting Date = December 15, 2020

    • Vendor Invoice No.: 1234

    On the Purchase Order Line select the following values:

    • Item = CHARGE

    • Quantity = 1

    • Direct Unit Cost = 100

    To complete the step, Post the document as Received and Invoiced.

  3. Create a new Sales Order with the following values:

    • Sell-to Customer No.: 10000

    • Posting Date = December 16, 2020

    On the Sales Order Line:

    • Item = CHARGE

    • Quantity = 1

    • Unit Price = 135

    To complete the step, Post the document as Received and Invoiced.

  4. Enter values for the General Ledger Setup page:

    • Allow Posting From = January 1, 2021

    • Allow Posting To = blank

  5. Create a new Purchase Order with the following values:

    • Buy-from Vendor No.: 10000

    • Posting Date = January 2, 2021

    • Vendor Invoice No.: 2345

    On the Purchase Order Line:

    • Item Charge = JB-FREIGHT

    • Quantity = 1

    • Direct Unit Cost = 3

    • Assign the Item Charge to the Purchase Receipt from step 2.

    To complete the step, Post the document as Received and Invoiced.

Status Item Ledger Entry of purchase step 2:

Entry NumberItem No.Posting DateEntry TypeDocument No.QuantityCost Amount (Actual)Remaining Quantity
324CHARGE2020-12-15Purchase10703011050

Value Entries

Entry NumberItem No.Posting DateItem Ledger Entry No.Item Ledger Entry TypeEntry TypeDocument No.Item Charge No.Item Ledger Entry QuantityCost Amount (Actual)Cost Posted to G/LAdjustmentApplies-to Entry
397CHARGE2020-12-15324PurchaseDirect Cost1080291100100NO0
399CHARGE2021-01-02324PurchaseDirect Cost108009JBFREIGHT033NO0

Status Item Ledger Entry sale:

Entry No.Item No.Posting DateEntry TypeDocument No.QuantityCost Amount (Actual)Remaining Quantity
325CHARGE2020-12-16Sale102035-1-1050

Value Entries

Entry NumberItem No.Posting DateItem Ledger Entry No.Item Ledger Entry TypeEntry TypeDocument No.Item Charge No.Item Ledger Entry QuantityCost Amount (Actual)Cost Posted to G/LAdjustmentApplies-to Entry
398CHARGE2020-12-16325SaleDirect Cost109024-1-100-100NO0
400CHARGE2021-01-01325SaleDirect Cost1090240-3-3Yes398
  1. On work date January 3, a purchase invoice arrives containing an additional item charge to the purchase made in step 2. This invoice has document date December 30, and is therefore posted with Posting Date December 30, 2020.

    Create a new Purchase Order with the following values:

    • Buy-from Vendor No.: 10000

    • Posting Date = December 30, 2020

    • Vendor Invoice No.: 3456

    On the Purchase Order Line select the following values:

    • Item Charge = JB-FREIGHT

    • Quantity = 1

    • Direct Unit Cost = 2

    Assign Item Charge to the Purchase Receipt from step 2

    To complete the step, Post the document as Received and Invoiced.

Status Item Ledger Entry of purchase:

Entry NumberItem No.Posting DateEntry TypeDocument No.QuantityCost Amount (Actual)Remaining Quantity
324CHARGE2020-12-15Purchase10703011050

Value Entries

Entry No.Item No.Posting DateItem Ledger Entry No.Item Ledger Entry TypeEntry TypeDocument No.Item Charge No.Item Ledger Entry QuantityCost Amount (Actual)Cost Posted to G/LAdjustmentApplies-to Entry
397CHARGE2020-12-15324PurchaseDirect Cost1080291100100No0
399CHARGE2021-01-02324PurchaseDirect Cost108030JBFREIGHT033No0
401CHARGE2020-12-30324PurchaseDirect Cost108031JBFREIGHT022No0

Status Item Ledger Entry sale:

Entry NumberItem No.Posting DateEntry TypeDocument No.QuantityCost Amount (Actual)Remaining Quantity
325CHARGE2020-12-16Sale102035-1-1050

Value Entries

Entry No.Item No.Posting DateItem Ledger Entry No.Item Ledger Entry TypeEntry TypeDocument No.Item Charge No.Item Ledger Entry QuantityCost Amount (Actual)Cost Posted to G/LAdjustmentApplies-to Entry
398CHARGE2020-12-16325SaleDirect Cost103024-1-100-100No0
400CHARGE2021-01-01325SaleDirect Cost1030240-3-3Yes398
402CHARGE2021-01-01325SaleDirect Cost1030240-2-2Yes398

Inventory Valuation report is printed as of Date December 31, 2020

[Content of the Inventory Valuation report.]

Summary of scenario:

The described scenario ends up with an Inventory Valuation report demonstrating Quantity = 0 while the Value = 2. The Item charge posted in step 6 is part of the Inventory Increase value of December while the Inventory Decrease of the same period is not affected.

Having the General Ledger Setup stating Allow Posting From January 1 was a good thing for the first Item charge. The costs of the Inventory Increase and Decrease was recorded in the same period. For the second Item charge however, the General Ledger Setup causes the change in COGS to be recognized in the period after.

Conclusion:

It is a challenge to get the Inventory Valuation report to demonstrate Quantity = 0 while the Value <> 0. In this case it is also more difficult to express the optimal settings, having purchase invoices arriving the same day but addressing different periods or even fiscal years. Crossing to a new fiscal year usually requires some planning and as part of that the insight into Adjust Cost – Item entries process, recognizing COGS, is to be considered.

In this scenario one option could have been to have the General Ledger Setup, field Allow Posting From, stating a date in December for a couple of more days and the posting of the first item charge postponed to allow all costs for the previous period/fiscal year to be recognized for the period they belong to first, having the Adjust Cost – Item entries batch job run and thereafter move the allowed posting date to the new period\/fiscal year. The first item charge with posting date January 2 could then be posted.

Design Details: Posting Date on Adjustment Value Entry
Design Details: Inventory Costing
Design Details: Item Application

Find free e-learning modules for Business Central here