Support:
A client using Job Cost had an interesting suggestion yesterday.

At certain points in the lifetime of a Job, they release cheques to vendors for work related to that Job. There can be several dozen vendors and the run could total to a large dollar amount. Could the System Cheque run function include an option to select Job(s) and only invoices related to those Jobs would be included? It isn't possible to segregate by vendor because a single vendor could work on multiple jobs.

Thank you.

Hi Bruce

The problem with that is that one invoice might be distributed to multiple jobs. Are you suggesting having the system check run calculation automatically know to partially pay an invoice for the portion that is applied to selected jobs? I think that would be quite complicated to implement.

I think it would be easier to write a GridView report and then use the results to import into a manual check batch.

Steve

Hello Steve:
That's a good point. For this client, it's almost certain that 1 invoice = 1 Job. However I can see that one can't make that assumption in all cases. Paying just the portion of an invoice related to the selected Job(s) would be good, although the complexity level is increasing at that point.

I'll pursue the GridView option. Thank you for the suggestion.

Steve:
It turns out that the only AP table with both Invoice information and Job number is "Invoice Posting Journal AJ". The problem is that table is usually purged at least once per year. Of course, that also makes my initial suggestion impractical based on the existing data dictionaries.

Hi Bruce

That being the case, the workaround is to have the clerk enter the job number in the reference field when they enter the invoice. I know it's not elegant and is double-entry but it makes creating the report a snap. And it will work for your client (and most users) whose invoices are coded to 1 job.

Steve

Steve:
That's a good thought. It's not watertight, but it's better than what they are doing now. I'll talk with the client tomorrow. Thanks.