There are also fields in the opmaster and WrkCenter tables which might help
you.
Look at QSetupLRate, QProdLRate, QProdBurRate and QSetupBurRate.
Mark Dupuis
Ranor, Inc.
Bella Drive
Westminster, MA 01473
Tel: (978) 874-0591 X221
Fax: (978) 874-2748
mailto:dupuism@...
IMPORTANT NOTICE:
This email, together with any attachments, is confidential. It may be
legally privileged, and is for the intended recipient only. Access,
disclosure, copying, or distribution of it by anyone else is prohibited and
may be a criminal offense. Please delete if obtained in error; and email a
notification to the sender.
-----Original Message-----
From: Lepley, Scott A. [mailto:sal@...]
Sent: Monday, April 19, 2004 12:12 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Calculating or aggregating quote costs in Report
Builder
I'm sorry if I misled you, Bob, but estimated costs are EXACTLY what I'm
trying to calculate or aggregate. What I wish to be able to do ultimately
is compare the actual costs from the job (relatively easy to determine
using
the JobAsmbl table and filtering for records where AssemblySeq=0) to the
estimated costs from the quote's manufacturing details (while probably not
rocket science, does seem to require some advanced physics knowledge!)
Nonetheless, thanks for your reply.
Regards,
Scott
-----Original Message-----
From: Robert Throckmorton [mailto:rthrockmorton@...]
Sent: Monday, April 19, 2004 11:24 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Calculating or aggregating quote costs in Report
Builder
?
then it looks like you are trying to get actual job costs which you can
find
in the job tables. look at joboper. the quote tables only relect the
estimate data.
regards,
bobt
-----Original Message-----
From: Lepley, Scott A. [mailto:sal@...]
Sent: Friday, April 16, 2004 1:39 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Calculating or aggregating quote costs in Report
Builder
Nope, looking for costs here, not selling prices.
Setting prices is easy, ESPECIALLY when you don't know what the costs
are...
;-)
Regards,
Scott
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, April 16, 2004 4:24 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Calculating or aggregating quote costs in Report
Builder
Quotes can get complex if you quote out the routing and BOM. If you are
just looking to total the price you see on the quote line, use the
quoteqty
table, and it would be the "UnitPrice" field (also use OurQuantity and
pricepercode to calculate extended price)
-----Original Message-----
From: Lepley, Scott A. [mailto:sal@...]
Sent: Friday, April 16, 2004 4:12 PM
To: 'Online Vantage Users Group (E-mail)'
Subject: [Vantage] Calculating or aggregating quote costs in Report
Builder
I am attempting to calculate or aggregate quote costs in Report Builder,
but
I am not having any success doing so. I am not even sure which tables and
fields to use. I have been experimenting with the QuoteAsm, QuoteCst,
QuoteDtl, QuoteMtl and QuoteOpr tables. Anybody have any suggestions?
Regards,
Scott Lepley
Systems Administrator
Mauell Corporation
Phone: 717-432-8686, ext. 14
Fax: 717-432-8688
Email: sal@...
Vantage version: 6.10.504
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
you.
Look at QSetupLRate, QProdLRate, QProdBurRate and QSetupBurRate.
Mark Dupuis
Ranor, Inc.
Bella Drive
Westminster, MA 01473
Tel: (978) 874-0591 X221
Fax: (978) 874-2748
mailto:dupuism@...
IMPORTANT NOTICE:
This email, together with any attachments, is confidential. It may be
legally privileged, and is for the intended recipient only. Access,
disclosure, copying, or distribution of it by anyone else is prohibited and
may be a criminal offense. Please delete if obtained in error; and email a
notification to the sender.
-----Original Message-----
From: Lepley, Scott A. [mailto:sal@...]
Sent: Monday, April 19, 2004 12:12 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Calculating or aggregating quote costs in Report
Builder
I'm sorry if I misled you, Bob, but estimated costs are EXACTLY what I'm
trying to calculate or aggregate. What I wish to be able to do ultimately
is compare the actual costs from the job (relatively easy to determine
using
the JobAsmbl table and filtering for records where AssemblySeq=0) to the
estimated costs from the quote's manufacturing details (while probably not
rocket science, does seem to require some advanced physics knowledge!)
Nonetheless, thanks for your reply.
Regards,
Scott
-----Original Message-----
From: Robert Throckmorton [mailto:rthrockmorton@...]
Sent: Monday, April 19, 2004 11:24 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Calculating or aggregating quote costs in Report
Builder
?
then it looks like you are trying to get actual job costs which you can
find
in the job tables. look at joboper. the quote tables only relect the
estimate data.
regards,
bobt
-----Original Message-----
From: Lepley, Scott A. [mailto:sal@...]
Sent: Friday, April 16, 2004 1:39 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Calculating or aggregating quote costs in Report
Builder
Nope, looking for costs here, not selling prices.
Setting prices is easy, ESPECIALLY when you don't know what the costs
are...
;-)
Regards,
Scott
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, April 16, 2004 4:24 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Calculating or aggregating quote costs in Report
Builder
Quotes can get complex if you quote out the routing and BOM. If you are
just looking to total the price you see on the quote line, use the
quoteqty
table, and it would be the "UnitPrice" field (also use OurQuantity and
pricepercode to calculate extended price)
-----Original Message-----
From: Lepley, Scott A. [mailto:sal@...]
Sent: Friday, April 16, 2004 4:12 PM
To: 'Online Vantage Users Group (E-mail)'
Subject: [Vantage] Calculating or aggregating quote costs in Report
Builder
I am attempting to calculate or aggregate quote costs in Report Builder,
but
I am not having any success doing so. I am not even sure which tables and
fields to use. I have been experimenting with the QuoteAsm, QuoteCst,
QuoteDtl, QuoteMtl and QuoteOpr tables. Anybody have any suggestions?
Regards,
Scott Lepley
Systems Administrator
Mauell Corporation
Phone: 717-432-8686, ext. 14
Fax: 717-432-8688
Email: sal@...
Vantage version: 6.10.504
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]