tables save posted data in cosumption and output journal

ahmedba

when i make post to consumption journal this data posted in which table save this data and also output journal in which table save posted
thanks

David_Cox

Posted Inventory goes to the "Item Ledger Entry" and "Value Entry" tables.

"Entry Type" Field Options = Purchase,Sale,Positive Adjmt.,Negative Adjmt.,Transfer,Consumption,Output

HTH

David

ahmedba

OK good this mean
1- consumption journal posted saved in table item ledger entry in entry type Purchase,Sale,Positive Adjmt.,Negative Adjmt.,Transfer,Consumption,Output
and
2-output journal posted save in value entry table
3- consumption journal represent posted inventory
please reply for me by details if possible your answer excellent

ahmedba

are this what you means

David_Cox

Purchase,Sale,Positive Adjmt.,Negative Adjmt.,Transfer,Consumption,Output

These are all entry types in the Item Ledger Entry "Entry Type" field, the Item Ledger Entry records the Inventory Movement (Item/Stock) Quantities count
Value Entries record the Financial Values, Expected, Actual, Non Inventorial Costs, Item Charge values and Sales values etc:

So Consumption,Output create both Item Ledger Entries (Movements) and Value Entries (Costs)

HTH

David

ahmedba

ok good if i want to know what are remaining raw material found in inventory what must i do to know this information in dynamic nav 2009r2

ahmedba

meaning if i want to know different between consumed and purchased that found now in inventory what i will do

kine

All info about item movements are in Item Ledger Entry. I recommend to work with some NAV consultant to learn how NAV is working...

ahmedba

OK THIS I know but how to know remaining quantity in inventory i know this found in item ledger entry but how if possible can you show to me

kine

SUM? Or Inventory filed on Item? ;-)

ahmedba

two both if possible please
thanks

kine

It was tip for you to look at this ways. Try to think about it, if you have some technical problem, than ask. But I expect that you alone will try to lear how it works. It will be good for you. Giving you solution without any effort from your side is not what I want to give you. 8)

ahmedba

i ask you because i want to make report to my company that show are this item is available and based on it can buy or purchase this item this is the goal from my question.

kine

Again, field Inventory on Item. Ask users how it could be used. I am sure that you will find someone who is working with NAV and will tell you how to use flow fields, flow filters etc.