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?
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……)
Hope this helps.
Thanks.
ZHU
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,993 Most Valuable Professional
nmaenpaa 101,156