Sage 100

Is it possible to avoid entering in a Customer Number into the Job Master when integrating AR & JC? A new client of mine rarely is able to create a one-to-one relationship between a job and a customer, but unless we link a customer to a job, we are unable to see a list of job numbers in AR Invoice Data Entry. Client would like to be able to invoice one job to many different customers without having to use Job Posting Entry, but I cannot see a way to avoid creating a relationship, or even being able to create a many-to-one relationship. Any tricks to this, as I'm not that comfortable with JC?

They could turn on SubJobs, which divides the job number into 2 segments - the main job is the first 4 characters and the subjob is the last 3. You can assign different sub jobs to different customers. I don't know if any of the standard reports group the info on subjobs together, but you could always do some custom reports.

You can initially link the job to one customer and then change the customer number in job cost in order to bill to different customers. Maybe set up a ""default job"" customer or something similar until you need to invoice, then change the customer for the job to the actual customer being invoiced. Not ideal, but it is one option. However, there can be issues when looking into history and applying payments to an invoice for a job if the customer has been changed. I have a client who would also like to be able to invoice multiple customers for the same job and we've gone back and forth with how to deal with this. It seems there's always some quirk that causes it to not be a perfect solution.