stock movement tables

ppiglet

hi all,

1.
i need to develop a stock movement report but i still not sure about what tables i have to use. it should covers stock movement for every location, for every bin location. it also need to cover inventory transaction using Reason Code (Item Journal transaction or Output Journal)
the question is : what tables i have to use for the report?

i found these tables:
- Item Ledger Entry (where i can find Qty & Location but no Reason Code field)
- Warehouse Entry (i can find Quantity, Location, Bin Code and Reason Code field, but sometimes the Reason Code field were empty for some transaction)
- Value Entry (where i can find Quantity, Location and Reason Code which is filled with proper Reason Code. But i cannot find the Bin Code )

2.
how to relate above tables if i need to combine them ?

3.
how those tables filled for inventory transactions (Output Journal, Item Journal , etc .. )?

thank you

johnson_alonso

hi,
Have you ever seen : financial management --> inventory ---> report --> stock movement ?

you may use that instead of making it. or if it's different than what you want maybe you can use it as a comparison.


rgds,
Johnson ALonso


"fight fire with fire"