Can Report Show Item Journal's Transactions?

Business Central/NAV Developers Forum
1

Hi, is it possible to create a report that shows you the item movements in the Item Journal? If possible, how?

E.g.

Item123 transfer from Bin123 to Bin234 with Qty of 5.

So i want the report to show that Item123 under Bin123 -5 Qty and then Item123 Under Bin234 +5 with the Document No. written as stock transfer.

or

E.g.

Item123’s stock qty Under Bin123 will amended from 100pcs to 90pcs. With the report showing that Item123 under Bin123 Qty-10 with Document No. Amend Stock Qty.

Thanks.

2

If you want your report to be based on what’s actively in the journal, that’s easy enough - just create a report based on the Item Journal (or Warehouse Journal) lines…

If you want a report based on journals you have run historically, then you will have to add the journal name and the batch name to the Item Ledger Entries (or Warehouse Entries).

3

Every time you post a journal it will create a warehouse register / item register.

Print your report based in that table.