Dear Experts,

Is there any way to find out inventory transaction history with value through Distribution / Manufacturing modules other than through Finance Integration sessions?


Thanks

Baan doesn't store the value in any other history transaction table, but it would be possible to know the value by getting the cost from the history table and then multiplying of tdinv700.quan.

Arvind

Hi,

Thanks for your reply.

Do you mean the cost history from table ticpr300?

Thanks

Hello,

Yes , cp history table ticpr300.

even i had also done a small cust using the same logic long back.


select ticpr300.item ,ticpr300.amnt ,max(ticpr300.indt)
from ticpr300
where ticpr300.item =:tdinv700.item
and ticpr300.indt <=:tdinv700.trdt
group by ticpr300.item ,ticpr300.amnt
selectdo
i.val = ticpr300.amnt * iqty
selectempty
i.val=tiitm001.copr * iqty
endselect

Thanks a lot

Shanidh