Thanx Cathy. i'm getting there....appreciated.
________________________________
From: Cathy <cathy@...>
To: vantage@yahoogroups.com
Sent: Thursday, 8 August 2013 12:42 AM
Subject: RE: [Vantage] need a help to get the total cost on my sales report - Epicor 9.05.700C
Â
You will need to add the InvcMisc table to add the Misc Charges.
There is already a report under Accounts Receivable > Reports > Sales Gross
Margin report.
On the Miscellaneous Charge Maintenance screen there is a flag for the
charge to be included in Sales Analysis.
For what I understand, the miscellaneous charge from the Sales Order get
attached to the last line of the Invoice Detail.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
bistakaji82
Sent: Tuesday, August 06, 2013 8:49 PM
To: vantage@yahoogroups.com
Subject: [Vantage] need a help to get the total cost on my sales report -
Epicor 9.05.700C
Hi everyone,
I got an assignment to produce a date driven sales report which should show
the cost as well.
what I've done so far is I have created a BAQ which gives me the total sales
figure along with the total cost for the jobs.
where,
total cost =(invcdtl.mtlunitcost + invcdtl.lbrunitcost +
invcdtl.mtlburunitcost + invcdtl.burunitcost + invcdtl.subunitcost) *
invcdtl.ourshipqty
But i believe that the total cost which i have fetched isn't right because
there must be some other costs like warranty, freight, etc. which i excluded
in BAQ.
So my question is how do i get the actual total cost for my sales
report?????
your help will be truly appreciated.
Regards
Niraj
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
________________________________
From: Cathy <cathy@...>
To: vantage@yahoogroups.com
Sent: Thursday, 8 August 2013 12:42 AM
Subject: RE: [Vantage] need a help to get the total cost on my sales report - Epicor 9.05.700C
Â
You will need to add the InvcMisc table to add the Misc Charges.
There is already a report under Accounts Receivable > Reports > Sales Gross
Margin report.
On the Miscellaneous Charge Maintenance screen there is a flag for the
charge to be included in Sales Analysis.
For what I understand, the miscellaneous charge from the Sales Order get
attached to the last line of the Invoice Detail.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
bistakaji82
Sent: Tuesday, August 06, 2013 8:49 PM
To: vantage@yahoogroups.com
Subject: [Vantage] need a help to get the total cost on my sales report -
Epicor 9.05.700C
Hi everyone,
I got an assignment to produce a date driven sales report which should show
the cost as well.
what I've done so far is I have created a BAQ which gives me the total sales
figure along with the total cost for the jobs.
where,
total cost =(invcdtl.mtlunitcost + invcdtl.lbrunitcost +
invcdtl.mtlburunitcost + invcdtl.burunitcost + invcdtl.subunitcost) *
invcdtl.ourshipqty
But i believe that the total cost which i have fetched isn't right because
there must be some other costs like warranty, freight, etc. which i excluded
in BAQ.
So my question is how do i get the actual total cost for my sales
report?????
your help will be truly appreciated.
Regards
Niraj
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]