I don't have the form in front of me but quote entry shouldn't require any additional custom assemblies or adapters to get to the data you need.
Perhaps they have simply obscured it by using a pared down (and differently named) view.
If it really isn't there (hard to believe as this IS the entry app to create such details) - you should still natively have all the adapters needed to add the (tables) as foreign key views.
The relationship is QuoteDtl to QuoteAsy (as an FKV) to QuoteMtl (as either an FKV or Subtable).
Rob Brown
Perhaps they have simply obscured it by using a pared down (and differently named) view.
If it really isn't there (hard to believe as this IS the entry app to create such details) - you should still natively have all the adapters needed to add the (tables) as foreign key views.
The relationship is QuoteDtl to QuoteAsy (as an FKV) to QuoteMtl (as either an FKV or Subtable).
Rob Brown
--- On Tue, 8/19/08, Calvin Krusen <ckrusen@...> wrote:
From: Calvin Krusen <ckrusen@...>
Subject: [Vantage] Determining Quote Material Costs [V8.03.403D]
To: vantage@yahoogroups.com
Date: Tuesday, August 19, 2008, 10:05 AM
I'm trying to create a customization to extract the material costs of a
quote and store it in the Number01 filed of the QuoteHed table.
My customization is linked to a custom button I placed on the Quote
Entry form. It is supposed to crawl through the quote details, and
thier underlying assmblies and materials, and sum up the material
costs. But it looks like no adapters or dataViews exist for the
QuoteMtl table.
The Quote Form worksheet provides most of the info I'm looking for, but
it can't be edited, and doesn't provide the total material costs.
If it helps, we don't use operations, only quote one price point, and
assemblies are only one level deep.
Any help would be appreciated.
Calvin