I'm new to S100C and report modifying so not sure if this is even possible but I am trying to add just a total AR invoice amount to the bottom of the modified job cost journal and it's not working. I have tried many versions of SELECT statements but can't get it right.

Ideally we would like to have the AR invoice as a line item as well but it's fine if I can even just get the total from the invoice.