What version are you using? For 6.1 the avg/std/last part costs (full
breakdown of labor, materials, burden, etc) are in the Part table but in
8.0 they have been pulled out into a separate PartCost table. You
should also be able to get profit info from the Sales Gross Margin
report which is sorted by customer, by (AR) invoice and by job.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Paul V. Blais
Sent: Friday, February 23, 2007 11:40 AM
To: vantage@yahoogroups.com
Subject: [Vantage] tricky crystal question
I'm writing a report that is basically a summary of the production
detail report but I'm doing it over a range of completed dates. I'm
using JobAsmbl and JobHead to get my costs. To my knowledge the only
way to get unit cost for the part in is OrderDtl. Question is, how do I
write a formula using the OrderDtl.Unitprice from the sub report? I
need this to compute profit or loss.
Thanks,
Paul
[Non-text portions of this message have been removed]
This is an e-mail from Saab Barracuda LLC. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.
###########################################
This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f-secure.com/
[Non-text portions of this message have been removed]
breakdown of labor, materials, burden, etc) are in the Part table but in
8.0 they have been pulled out into a separate PartCost table. You
should also be able to get profit info from the Sales Gross Margin
report which is sorted by customer, by (AR) invoice and by job.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Paul V. Blais
Sent: Friday, February 23, 2007 11:40 AM
To: vantage@yahoogroups.com
Subject: [Vantage] tricky crystal question
I'm writing a report that is basically a summary of the production
detail report but I'm doing it over a range of completed dates. I'm
using JobAsmbl and JobHead to get my costs. To my knowledge the only
way to get unit cost for the part in is OrderDtl. Question is, how do I
write a formula using the OrderDtl.Unitprice from the sub report? I
need this to compute profit or loss.
Thanks,
Paul
[Non-text portions of this message have been removed]
This is an e-mail from Saab Barracuda LLC. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.
###########################################
This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f-secure.com/
[Non-text portions of this message have been removed]