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.