Stock valuation Report problem in crystal

[Former Member]

Hello

I have created Stock Valuation report on crystal & give parameter For Selection 'from Date' To 'To DATE'

I maintain 'On Hand' field for quantity available in between selected period

But Suppose I have Item code 'X01' having actual balnce qty 67 between 1 Jully 2011 To 31 jully 2011 when i run the

report by same date it display 67 qty it right but the Item 'X01' Sold out 5 Qty on date 2 Augst and i again run the report

between date 1 Jully 2011 and 31 jully 2011 it Show 62 qty but upto 31st Jully i have 67 Qty remaining but it show 62 this is wrong

so how i brought 67 qty upto 31 Jully in Crystal Report

In Inventory audit Report it show perfect qty on date selection but i want right value in my crystal report

[Former Member]

ok

[Former Member]

Hi,

The on hand balance is dynamic. You can not get it from any table for historical balance.

You have to create a temporary table to calculate from day one of inventory transaction for the item.

Thanks,

Gordon

[Former Member]

Hello,

This type of report is so important for industry level ,so how i create table that you say, or there is any other table that maintain

all information regarding stock

[Former Member]

In old version before 8.8, you can find them easily under OINM table. However, this table become a view now. You have to find the exact table behind it to get better performance.