PDA

View Full Version : How do you verify a Job has been assigned to a Payment?


robert_evans
02-06-2002, 05:20 AM
I am a small volume builder. I use Job Costing to track the expenditures and construction loan draws based upon the different phases of completion. I need to be able to find all transactions containing line items DO NOT have a Job assigned BUT SHOULD.

I can easily search for all Purchases that do not have a job assigned by using the 'Find...' dialog to look for transactions with a Job ID in the range of "" to "A"

The situation is not quite so obvious for Payments. When I look for transactions that are in the 'CDJ' journal and have a Job ID in the range "" to "A" I get those that are payment of an Invoice included as well. While this makes sense from a Job Costing perspective (I wouldn't want both the invoice of the $10 hammer and the payment of the $10 hammer showing in job costing as $20) it makes it very difficult to easily audity my entries. I can visually inspect each entry to ensure that it is either a payment on an Invoice or has a job assigned, but it would be much easier if the report contained only those entries that were missing a Job ID.

Any ideas on how to either find or list the Cash Disbursements that do not have a Job assigned either directly or by virtue of the Invoice they are associated with?

Thanks,
R Evans