BAQ Calculation for Sum of all costs

Epicor ERP 10
1

Hi all,

I’m pretty new with Epicor and using BAQ. Question, is there a way to add the transaction costs of a part?

I extract this data from PartTran, and I would like to sum up MtlUnitCost, LbrUnitCost, etc.

image
image1183×125 6.18 KB

Appreciate any ideas regarding this query.

Thanks :slight_smile:

2

Your screenshot looks like SSMS, but yes in a BAQ you can achieve this using a calculated field (column)

In this case, ExtCost is already the sum of the unit costs times the TranQty so not sure if you really need a calculated field, but that’s what they can be used for

3

We have a crystal report and we are trying to recreate the report into a dashboard. I made a query on SSMS for PartTran and I found out that crystal report sums up the costs for all the transactions that was done on the part.

4

@Raymark Are there any other groupings like job, lotnum? All costs by part seems to be a big bucket. Is the CR report from Epicor? If so it was possibly a baq report which would be usable in a dashboard. If it was from a stored procedure that would give you the details you would need for a baq.