How to find when an item was last purchased?

[SpeedyGonza]

Is there Inquiry tools / reports in GP that will allow someone to find How to find when an item was last purchased (the latest date)? Specifically, our company would like to do the following:
Given a list of Item number, find the last date this item has been placed on order.
If someone would have a SQL query for this that'll be great.

 

[BobSchleicher]

This will show you the last time you received an item into the system.

SELECT MAX(dbo.POP30300.receiptdate) AS MaxDate, dbo.POP30310.ITEMNMBR
FROM dbo.POP30300 INNER JOIN
dbo.POP30310 ON dbo.POP30300.POPRCTNM = dbo.POP30310.POPRCTNM
GROUP BY dbo.POP30310.ITEMNMBR
HAVING (dbo.POP30310.ITEMNMBR = 'PUT YOUR ITEM HERE')

Change POP30300.receiptdate to POP30300.GLPOSTDT if you want to know when you posted the receipt.

BobSchleicher

 

[PTina]

You could go to Item Trx Inquiry:
Transaction --> Inventory --> Item Transaction

Sort by document type and see when the last POP receipt was.

or print the Purchase Receipts report:
Reports --> Inventory --> Activity --> Purchase Receipts

 

[jazgeek]

item card>quantity and sites

select your site ID

it shows last order date, last receipt date and vendor ID

if you go to item card> vendor

you'll see all the associated vendors for the item via the scroll button showing last order date/receipt date/quantity ordered and originating invoice cost for each vendor

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

jaz