Item Ledger Entry - Stock as on Report

Hi,

I want to make a stock as on report from Item Ledger Entry table. There are many Entry types i.e. Purchase, Sale, Transfer, Return etc. Can anyone help me - how I can find stock report as on previous date. I only want to display stock report with it purchase date.

Now I want to know that on 30/11/2009, how much stock was there, with date of receipt of that stock. No other entry. Only stock entry should show.

Example as below -

Posting Date Entry Type Document No. Date Of Receipt Quantity Invoiced Quantity Remaining Quantity Entry No. 28/10/2009 Purchase GR-EINO-0910-00170 28/10/2009 1 1 0 71665 30/10/2009 Purchase GR-EINO-0910-00174 30/10/2009 1 1 0 72478 30/11/2009 Sale EINO-T-EINO-1554 -1 -1 0 72486 30/12/2009 Sale EINO-T-EINO-1560 30/10/2009 1 1 1 72609 30/01/2010 Sale EINO-T-EINO-1561 -1 -1 0

72612

for starting point, you can use Item Register Report. put filter in Entry Type and Posting date.

if you need more columns from ILE table, just modify the report to add columns you want to show.

Hi JP,

Why not use the standard Inventory Valuation Report?

By this, i can not find exact balance inventory with it purchase date. Sale entry or other entry also comes. i.e. If I have 3 inventory purcahsed on 2/02/2010 and 1 inventory is purchase on 05/02/2010. Out of this 4 invenotry, 2 inventroy has been sold. Now i found only 2 inventory lines with its purchase date.

any idea?

This wil not help me.

By this, i can not find exact balance inventory with it purchase date. Sale entry or other entry also comes. i.e. If I have 3 inventory purcahsed on 2/02/2010 and 1 inventory is purchase on 05/02/2010. Out of this 4 invenotry, 2 inventroy has been sold. Now i found only 2 inventory lines with its purchase date.

any idea?

what report are you using? did you try to work around with filters?

or did you try to open report designer, and tune the table filters?

Could you answer Dave’s question?

Inventory valulation report does not include date of purchase/posting. i.e. I have 2 inventory of any item which purchase date is 01/04/2010 and 2 inventory having purchase date 05/04/2010. Now i have sold out 1 inventory on basis of FIFO. means there is 1 invnetory left of purchase date 01/04/2010 inventory. now inventory valulation date will not show only two lines having purhcase date for the same.

any idea?

Hi JP,

I would take the Inventory Valuation as a start and then code finding the earliest purchase date using a record variable. You can do this by linking to the item ledger entry from the value entry using the Item Ledger Entry No.