Sage 100

This is an update to an earlier request. My client actually creates the invoices in AR, but there can be only one job per invoice. Are there any known enhancements that allow selecting the job on line items when billing?

Not that I'm aware of any. I suppose that it would be nice to bill more than on job on and invoice, but could be a real pain when trying to locate the specific line on an invoice when rolling up job billings from specific invoices to job revenue.

I have a client in need of this functionality as well, but haven't been able to find anything. I think I talked to a master developer about it years ago and it was extremely cost prohibitive for the client. They currently enter separate invoices for the customer for each job. We've discussed setting up a custom form to combine separate invoices into one form, thus imitating multiple jobs on one invoice, just haven't done this yet.

Does the client have the Job Cost module @JonParkinson? In AR with Job cost, you may select the Job number at the header of the AR invoice. This then would also allow for the indexing by job number by invoice as @MyronStevenson suggested. I've setup simplified Job Cost systems that work well for this situation. Also, Job Cost integrates with Sales Order too, if that is a future need.

Thank you for all of the responses. Barb, I believe you understand exactly what we need. Moira, yes the client has JC, and this is the issue.

If you happen to find a solution for this let me know. I think we're looking for exactly the same thing. Thankfully my client is able to make do with separate invoices, but they'd really prefer to have one invoice to several jobs.

@JonParkinson - sorry after re-reading the post I see the issue now and the limitation of one job # per invoice.

1. Is there a reason that they are using Job Cost? 2. Do the billings have to write back to the J/C module? Thoughts: Create a customized invoice entry screen in custom office with job numbers on the lines. Have all the lines post to a clearing account, and then generate a mess of individual invoices -- each one billed against a single job. It would definitely be a hack, but it could be done.

Check with Champ Systems they have several one off's for job cost that I have utilized in the past.

If they just want a way of tagging any transaction in the system with a ""job ID"" then you can set up a UDT with job info. the Job ID field on that table is avialable as a lookup at the header or line detail of pretty much any transaction in AR, AP, SO,PO, IM,GL. You can then use SMI to tie it all together, or cyrstal, access....