Hi All,

Over the past few weeks, on several occasions now, we have encountered an issue/problem in AR when keying cash entries. When we choose a customer, and pull them up to key in a cash entry, normally the outstanding invoices show up in the bottom detail area, however, in these odd cases, there are no outstanding invoices that appear, and instead, there is a detail line showing type as "UP" (unposted), and all other columns are blank and/or have zeros.

I have checked and double-checked that the customer's monthly invoice was posted properly and is indeed showing in both the specific customer transactions as well as the invoice batch was posted (and retrieved) into the GL. Yet the invoice won't show up when I open their customer # to key the cash entry in my cash batch.

I can manually apply it (using drop down boxes) under that "Unposted" line item (total hassle), but then when I open a new entry in the same batch to key the next customer's cash entry, that customer's invoice comes up. It is extremely sporatic and very, very strange.

I did a DIC and there was 1 error that shows an issue with Doc Storage....would this impact the cash entry?

Thanks, Orianne

Hi Orianne,

For the customers not showing the list of posted invoices, are they defined as 'Open Item' or 'Balance Forward' customer types? This can be found on the Accounting tab, with the first field called Account Type. I believe only 'Open Item' customers will show specific invoices to pay, and 'Balance Forward' customers will only allow entering a payment amount which you cannot specifically apply to invoices. What you have described is the behaviour for customers with a 'Balance Forward' type. If this is your situation, then it would always happen for those particular customer(s) and not sporadically. To fix this, you would have to find a time when there are no open batches, make a backup of your data, and edit the customer(s) to be 'Open Item' type. A Data Integrity Check should be done when you are finished.

The DocStorage DIC error is likely minor and would not have any impact over this situation.Though it's reasonable to rebuild that error when time permits.

Yay! thank you! That was it! Those specific customers were in fact set as Balance Forward rather than Open Item (somehow they got changed).

So glad! I checked all other customers and had a few others with that same option - now corrected.

As for the Doc Store error, I'll have that corrected with our consultant.

Thank you again!
Orianne