Items with no purchase history

 7 Replies
 3 Subscribed to this topic
 39 Subscribed to this forum
Sort:
Author
Messages
Bev Edwards
Veteran Member
Posts: 366
Veteran Member
New Poster
New Poster
Congrats on posting!
What tables would I use to get a list of all the items we have with no purchase history?
JonA
Veteran Member
Posts: 1163
Veteran Member
I have a Crystal report that shows all active stock and nonstock and pulls in last date for receipt activity. Any items that have no receipts show the po number and receipt date as blank. Since I can't upload files to the forum, send me your email in a private message and I'll send it to you.
Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
Bev Edwards
Veteran Member
Posts: 366
Veteran Member
New Poster
New Poster
Congrats on posting!

Private Message will not open for me. Getting an error (not displayed.)

Here is my email: bedwards@gbmc.org

 

Thank you very much!!

Bev

Bev Edwards
Veteran Member
Posts: 366
Veteran Member
New Poster
New Poster
Congrats on posting!

Object doesn't support this property or method is the error when trying to use Private Message.

 

John Henley
Posts: 3363
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
Send message via Private Message should now be working.
Thanks for using the LawsonGuru.com forums!
John
Bev Edwards
Veteran Member
Posts: 366
Veteran Member
New Poster
New Poster
Congrats on posting!
Thank you John!!
Stephanie
Veteran Member
Posts: 86
Veteran Member
New Poster
New Poster
Congrats on posting!

Hi Jon,

 

Would you be willing to share this with me as well?

Stephanie.kowal@bhs.org

Thanks!

Stephanie Kowal

Baystate Health

Stephanie Kowal | skowal@rpic.com
Patti D
Basic Member
Posts: 10
Basic Member

Hi Jon,

 

Would you be willing to share this with me as well?

demaske@utwn.org

 

Patti Demaske

Uniontown Hospital

thanks