Who's On?

	Membership:
	Latest: Hitman
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5208

	People Online:
	Visitors: 461
	Members: 0
	Total: 461

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

Last received cost

2 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

nwhitacre

New Member

Posts: 4

9/22/2011 4:23 PM

Attempting a data extraction for the last rec cost. The ITEMLOC has a LASTRECDT field that does not match the PORECLINE date. What would be the best table and field to pull the cost for inventory and x/special items?

John Desmarais

Basic Member

Posts: 19

9/26/2011 3:13 PM

I've always pulled this data from the ITEMLOC table.

When you look at the receipe line (in PORECLINE) is the receipt for the same location you are looking at in ITEMLOC?

John Desmarais
Novant Health

JonA

Veteran Member

Posts: 1163

10/4/2011 12:31 PM

I would be concerned that your ITEMLOC LAST-REC-DT does not match the date for the PORECLINE REC-DATE. It should. I just queried the last month of PORECLINE for one location and compared the REC-DATE for the stock items to the LAST-REC-DT for the same stock items at that location and they matched up perfectly for 1200 items.