Start with PartTran then sort by date, filter for whatever PartTran TranType
records you want.
Patrick Winter
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ben Belzer
Sent: Thursday, May 04, 2006 4:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Average Cost History
Anyone know what table stores historical info for average costing? I would
like to create a query that shows a the daily average cost, to see where and
when it gets changed.
Thanks!
Ben
Ben Belzer
IT Manager
TCI Precision Metals
800.234.5613.W
310.323.1255.F
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.
records you want.
Patrick Winter
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ben Belzer
Sent: Thursday, May 04, 2006 4:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Average Cost History
Anyone know what table stores historical info for average costing? I would
like to create a query that shows a the daily average cost, to see where and
when it gets changed.
Thanks!
Ben
Ben Belzer
IT Manager
TCI Precision Metals
800.234.5613.W
310.323.1255.F
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.