Cash is entered in AR. Often we entered cash BEFORE our sales invoices were posted (deposits etc.) and created cash batches later to apply the cash to the invoice. This worked fine as far as cash being applied properly. We were advised last December that when entering the cash receipts if we knew the sales invoice number we should enter it with the cash batch to avoid having to create a 2nd cash batch later to "apply" the cash properly. This is what we've been doing, however the cash has been applied to the customers but HAS NOT been applied to the jobs. All of our invoices are coded to jobs. All of our tracking is done by jobs. Now when we look up a job status or a job summary we are seeing jobs that report no payments have been made when in fact the payment has been made.
Question # 1 - Why did the cash not flow to job cost when it was applied to an invoice that was coded to job cost?
Question # 2 - How do I now clear this up so our job cost records are accurate? I printed out old AR Cash posting journals and found at least 100 cash transactions that are "UP" or unapplied. Do I now have to match these (the job numbers do not show up in the posting journal)to the jobs by looking up each invoice? Then, do I have to do a payment batch in JC for each job that did not get the cash applied? Sounds like a lot of time to do something that I thought was being done through Adagio automatically.
Sorry to sound frustrated but I'd love to hear of a way to do this in a proficient manner.
Thanks in advance,
Karen