Need a help to get the total cost on my sales report - Epicor 9

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]
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
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]