Items with no purchase history

 7 Replies
 3 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Bev Edwards
Veteran Member Send Private Message
Posts: 366
Veteran Member
What tables would I use to get a list of all the items we have with no purchase history?
JonA
Veteran Member Send Private Message
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 Send Private Message
Posts: 366
Veteran Member

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 Send Private Message
Posts: 366
Veteran Member

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

 

John Henley
Send Private Message
Posts: 3351
Send message via Private Message should now be working.
Thanks for using the LawsonGuru.com forums!
John
Bev Edwards
Veteran Member Send Private Message
Posts: 366
Veteran Member
Thank you John!!
Stephanie
Veteran Member Send Private Message
Posts: 86
Veteran Member

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 Send Private Message
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