Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

Item journal line, Item ledger entry, warehouse entries and value entry

Posted on by 55

Hi,

We are looking to dump a lot of BC tables to a datawarehouse for analysis. Time has come to look at "items" and Im having a hard time figuring out what the "master" table is when it comes to items.

From what I can tell the item ledger entry contains most of it. However the value entry table contains information related to costs and value that might not be in the item ledger. This can occur when we revalue items or recieved goods gets invoiced. There is also the warehouse entries which gives extra information about bins (which we use)

But what is actually the point of the item journal line table? To be honest it almost seem like it has the information from the other tables so maybe thats the master I should use, or are there transactions I would miss then?

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 73,171 Super User 2024 Season 2 on at
    RE: Item journal line, Item ledger entry, warehouse entries and value entry

    Hi, below are the Business Central E/R Diagrams for item journal line table.

    https://dynamicsdocs.com/nav/2018/w1/table/item-journal-line

    And in the next version, Posting preview in item postings feature may be added, which may make it easier for you to understand.

    Business Central upcoming update: Posting preview in item postings (Transfer Orders, Item Journals……)

    https://yzhums.com/32288/

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: Item journal line, Item ledger entry, warehouse entries and value entry

    Item Journal Line table is what the system uses when posting from sales and purchases into the item ledger. It is also the table that holds inventory adjustments as entered in the Item Journal.  I would think that you do NOT need the Item Journal for your data warehouse.

  • DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: Item journal line, Item ledger entry, warehouse entries and value entry

    hi

    look this

    businesscentralhelp130.fenwickcloud.com.au/main.aspx

    DAniele

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans