Current Costs Blank Title 85870

Yahoo Archive
1
Perhaps you are referring to BOM costs? If so there is a (rather un-friendly) crystal report you can generate within vantage. Vantage does store the "last cost" of a certain part, but that changes based on adjustments and the frequency of adjustments. Keeping track of all costs might be a wee bit complicated since you cannot design your own sql tables in vantage (in theory anyway, you could create your tables in sql in a database separate from MFGSYS and reference then using VB code, but you didn't read that here).

Thanks,
Kunal




________________________________
From: "michael.hutcheson@..." <michael.hutcheson@...>
To: vantage@yahoogroups.com
Sent: Mon, December 14, 2009 8:53:48 AM
Subject: [Vantage] Current Costs


Hi Folks,

Does anyone know of a way in Vantage to keep Current Costs? We currently use Std Costs, and these were updated every month as part of the cost rollup. However, we now no longer want to do cost rollups on a monthly basis but still keep record of when costs do change, ie in a 'Current Cost' field. My first thoughts were use a user defined table and keep current costs in there. However, does anyone have any other ideas?

Regards,

Michael







[Non-text portions of this message have been removed]
2
Hi Folks,

Does anyone know of a way in Vantage to keep Current Costs? We currently use Std Costs, and these were updated every month as part of the cost rollup. However, we now no longer want to do cost rollups on a monthly basis but still keep record of when costs do change, ie in a 'Current Cost' field. My first thoughts were use a user defined table and keep current costs in there. However, does anyone have any other ideas?

Regards,

Michael
3
Michael



The parttran table stores the before and after costs of any transactions
made if that helps



Also, even though you are suing std costs the system still stores the
current average and last costs.



Gary



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of michael.hutcheson@...
Sent: 14 December 2009 2:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Current Costs





Hi Folks,

Does anyone know of a way in Vantage to keep Current Costs? We currently
use Std Costs, and these were updated every month as part of the cost
rollup. However, we now no longer want to do cost rollups on a monthly
basis but still keep record of when costs do change, ie in a 'Current
Cost' field. My first thoughts were use a user defined table and keep
current costs in there. However, does anyone have any other ideas?

Regards,

Michael





[Non-text portions of this message have been removed]