I’m having some issues with creating a calculated field that subtracts an InvoiceAmt from any MiscCharges with a “SHIP” Code attached to it. So say there’s an invoice with 2 Misc Charges on it, one for “TAX” and one for “SHIP”; I want the calculated field to subtract only the “SHIP” MiscAmt from th…

If you are using the BAQ designer, I would do a subquery to add up the Invoice amounts grouped by orders, then another to add up the MIsc Charges summed by order. Then you can filter the table for the Misc charges so you only get the SHIP code lines. Then, on the top level, match up the two sub quer…

Calculated Field Issue

Epicor ERP 10

Banderson (Brandon Anderson) August 16, 2017, 6:10pm 4

Do you know how to do a subquery?

this post shows how to make a sub query if you don’t.

Topic		Replies	Views
Subquery on InvcDtl to InvMisc Epicor ERP 10 baq	2	403	February 19, 2019
Calculated Field Help Epicor ERP 9	5	739	January 5, 2017
SQL Query Help Epicor ERP 10 e10 , sql	7	3130	November 11, 2017
Trying to add a Shipped Qty Total to the bottom of the AR Invoice Report Kinetic ERP ssrs	17	447	April 10, 2024
BAQ to show "Total Value" of a Customer Shipment Epicor ERP 10 e10	3	1227	July 28, 2023

Calculated Field Issue

Related Topics