Need help with a select statement for adding total sales to job cost journal?

Question

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.

Char DeLange · Answer

I would not attempt to use a job cost journal for an invoice. That is what our T&M billing module is for. You can bill at cost plus a markup and flat hourly rates for employees or cost codes. A job cost journal is an internal report for your company only. There would be no way for it to calculate or add sales tax, but the T&M module does

Sage Construction & Real Estate

Need help with a select statement for adding total sales to job cost journal?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING