item last cost

[swabunn]

I have been told to make a report in crystal to show unposted item receipts with last item cost for the site. Have anybody worked on such report to include last item cost of the site or any body knows the table from where I can pull item last purchase price or cost of the site

 

[jazgeek]

You could pull that from one of two locations

either the item vendor master which tracks the last invoice cost of the item per vendor (might not give you everything you're looking for)

or you could look at the historical receipts table to find out the last cost paid cost of the item.

item vendor master - IV00103

purchase order line history - POP30110

you might have to do a union with the POP10310 table as PO'd don't move to history automatically




-----------
and they wonder why they call it Great Pains!

jaz

 

[swabunn]

Thanks for your reply. Actually I want to build my report to pull item unit cost and landed unit cost separately and comapred them to provide users a comparision with last item purchased unit cost and landed unit cost.

column
item number
reciept number(unposted)
quantity(unposted)
unit cost(unposted)
landed cost id(unposted with reciept)
landed unit cost(unposted)
last item cost(posted)
last item unit cost(posted)
last landed cost id(posted)
last landed unit cost (posted)

 

[swabunn]

I am trying to pull last date record from pop10500 table. To my surpirse, tables does not carry time of the transactions. I wanted to pull last transactions among many transactions for same item has been entered. Any idea how can I pull last transaction of the day.

swabunn

 

[jazgeek]

create a trigger to record transaction number and date/time of insert into a table



-----------
and they wonder why they call it Great Pains!

jaz