Thank you for your post Janice W-

Hopefully there are some other Sage 100 Contractor users out there that have a suggestion for you.

Sounds like you might need to use the Service Receivables module and set up routes or templates.  What does your company do?  Are the recurring invoices fixed amounts or do they need to vary?

We are a General Contractor; however, this issue pertains to our Security Division which performs Service Work Orders aa well as Monthly Monitoring (400+ recurring receivables)

Then you want to purchase the Add on module for Service Receivables and process the security receivables through there.  You should also consider seting up departments for your Income and Expense accounts to track profitability between the two divisions.  You can start that at the beginning of your fiscal year before you post any new transactions.

Hi Janice,

Char (CKS) is correct.   I can empathize with your situation because there is not a quick fix.

The suggestion to add the Service Receivables module is the best answer.  You are a contractor filling Service Work Orders for Fixed (Monitoring) and/or Variable (Service Labor/Mat/Sub) costs.   Service Receivables is be designed to manage that billing process with the Work Order & Invoice templates you need.

The question rephrased is: How can you create Recurring Receivables (Template) without creating a job for each individual Receivables Client?  This is not possible through the Recurring Receivables Template.

If you use T&M billing, where you bill the customer for fixed and variable costs, the JOB/Customer Record is necessary for tracking the actual costs (AP invoices, payroll) and markups to be billed to each customer.  The JOB is the KEY to accounting from source doc to posting account.

Also, as Char (CKS) conveyed, it would be prudent to set up Departments, and assign Revenues / Expenses generated by the Security Services department to a Subaccount.  Transitioning to Departmental bookkeeping mid-annual-cycle is difficult for various reasons, but this is a good idea regardless.

In Summary, use the Service Receivables Module, or find a way to create a job record for each client.  You can manually enter new Jobs, or IMPORT a .csv/.xls file (which is really only recommended to be done at start FY).  If you have a Job for each Client, you can create a Recurring Receivable Template for each Job and Post/Print/Send invoices in Batches.

Best Regards,

Joe S.

Ambrose CI

I have departments set up for my income and expense accounts already.  I wil look into the Service Receivables module.  Thank you for your help!