We are using AR 9.0C, and are running into something a bit odd. After much detective work, I have at least found the problem creating the issue, just need to know the fix now. Basically it comes down to this:

Our Accounts Receivable trial balance is out of balance with our ledger on some months, then it balances again at the end of the month following, or perhaps even the next month after that. We have been scratching our heads, trying to figure out what is going on, why we are not balanced at the end of each month. We have a "test" data, and I've been playing around in there, trying to recreate the problem, and I can do that, but only with certain customers, which leads me to believe that this is either a data integrity error, or I need to set up something further in our company profile.

If we invoice any of our customers (in Order Entry - 8.1E) where those customers have accent symbols above the FIRST letter in their company name, that invoice does not show up on our Trial Balance in AR. It does not show up on any reports at all, which makes it pretty difficult to collect the money. We usually run weekly reports that show us who to call, and those customers are obviously absent.

The invoice goes through Day End in our usual process, prints on the Audit List in O/E, retrieves to AR as normal, and also retrieves to the Ledger at end of day. It just does not show up on the Trial Balance in AR at all.

Customers with accent symbols further into their company name do not create any issues. Only where the accent symbol is over the first letter of the company name.

I tested this by taking the accent off of a customer that was so entered in AR, then going into OE and creating a new invoice. Ran it through Day End, retrieved to AR and printed an Aged Trial Balance. The new invoice, done without any accent over the first letter of the customer's name, shows up. Previous invoices (done with the accent over first letter in customer's name) still do not show.

Can you advise if I have a problem that requires an Adagio "Fix" or do I need to set up something further in our company profile?

Thank you.

Barb

You will need to change the Customer name ending range..

Although it is not obvious ZZZZ is "smaller" than ÇZZZ

If you change first Z in your ending Customer Name range to the largest 1st accented Customer Name you have I suspect you will be OK.

Hi, Barb,

The problem is probably that the uppercase 'Z' sorts above the character(s) that have an accent symbol on them as (eg. as many French characters do). If you're using these characters when entering a customer name, you'll want to use them as the first character of the Customer Name field in the Sort by criteria of the Print Aged Trial Balance report window also.

Or, you could Change the Customer Name field on the window to something else that might be relevant to you, like Territory, or even remove it from the list by changing it to the 'blank' field name setting. This will effectively move it to the bottom of the field criterial list.