Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Item ledger entries vs Item value entries

Posted on by 25

Hi all,

i would like to ask whether it is normal in navision that item ledger entries and item value entries is different by total of cost actual?

by total invoiced qty it is all same no difference.

my understanding is that item ledger entries is used for item physical movement analysis, while item value entries is used for costing analysis therefore if i want to compare iventory valuation i can only use item value entries bcs all adjustments and revaluations only appeared in item value entries. Is it correct?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item ledger entries vs Item value entries

    Hello,

    You overview is correct but let me give you some background to help...

    Each inventory transaction, such as a purchase receipt or a sales shipment, posts two entries of different types.

    DESIGN DETAILS: INVENTORY POSTING
    Entry type Description
    Quantity Reflects the change of quantity in inventory. This information is stored in item ledger entries.

    Accompanied by item application entries.
    Value Reflects the change of inventory value. This information is stored in value entries.

    One or more value entries can exist for each item ledger entry or capacity ledger entry.

    In relation to quantity postings, item application entries exist to link inventory increase with inventory decrease. This enables the costing engine to forward costs from increases to the related decreases and vice versa.

    Item ledger entries, value entries, and item application entries are created as a result of posting an item journal line, either indirectly by posting an order line or directly in the Item Journal window.

    At regular intervals, value entries that are created in the inventory ledger are posted to the general ledger to reconcile the two ledgers for financial control reasons.

    pastedimage1618507150893v1.png

    Example

    The following example shows how item ledger entries, value entries, and item application entries result in general ledger entries.

    You post a purchase order as received and invoiced for 10 items with a direct unit cost of LCY 7 and an overhead rate of LCY 1. The posting date is 01-01-21. The following entries are created.

    Item Ledger Entries

    EXAMPLE
    Posting Date Entry Type Cost Amount (Actual) Quantity Entry No.
    01-01-21 Purchase 80.00 10 1

    Value Entries

    TABLE 3
    Posting Date Entry Type Cost Amount (Actual) Item Ledger Entry No. Entry No.
    01-01-21 Direct Cost 70.00 1 1
    01-01-21 Indirect Cost 10.00 1 2

    Item Application Entries

    TABLE 4
    Entry No. Item Ledger Entry No. Inbound Item Entry No. Outbound Item Entry No. Quantity
    1 1 1 0 10

    Next, you post a sale of 10 units of the item with a posting date of 01-15-21.

    Item Ledger Entries

    TABLE 5
    Posting Date Entry Type Cost Amount (Actual) Quantity Entry No.
    01-15-21 Sale -80.00 -10 2

    Value Entries

    TABLE 6
    Posting Date Entry Type Cost Amount (Actual) Item Ledger Entry No. Entry No.
    01-15-21 Direct Cost -80.00 2 3

    Item Application Entries

    TABLE 7
    Entry No. Item Ledger Entry No. Inbound Item Entry No. Outbound Item Entry No. Quantity
    2 2 1 2 -10

    At the end of the accounting period, you run the Post Inventory Cost to G/L batch job to reconcile these inventory transactions with the general ledger.

    The following tables show the result of reconciling the inventory transactions in this example with the general ledger.

    Value Entries

    TABLE 8
    Posting Date Entry Type Cost Amount (Actual) Cost Posted to G/L Item Ledger Entry No. Entry No.
    01-01-21 Direct Cost 70.00 70.00 1 1
    01-01-21 Indirect Cost 10.00 10.00 1 2
    01-15-21 Direct Cost -80.00 -80.00 2 3

    General Ledger Entries

    TABLE 9
    Posting Date G/L Account Account No. (En-US Demo) Amount Entry No.
    01-01-21 [Inventory Account] 2130 70.00 1
    01-01-21 [Direct Cost Applied Account] 7291 -70.00 2
    01-01-21 [Inventory Account] 2130 10.00 3
    01-01-21 [Overhead Applied Account] 7292 -10.00 4
    01-15-21 [Inventory Account] 2130 -80.00 5
    01-15-21 [COGS Account] 7290 80.00 6

     Note

    The posting date of the general ledger entries is the same as for the related value entries.

    The Cost Posted to G/L field in the Value Entry table is filled.

    The relation between value entries and general ledger entries is stored in the G/L - Item Ledger Relation table.

    Relation Entries in the G/L – Item Ledger Relation table

    TABLE 10
    G/L Entry No. Value Entry No. G/L Register No.
    1 1 1
    2 1 1
    3 2 1
    4 2 1
    5 3 1
    6 3 1

    I hope this helps.

    Thanks,

    Steve

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans