I have 3 issues; not sure if they're related. It is a foreign currency set-up, and I'm aware of the Knowledgebase article saying that one should call Sage support for database repair -- but I'm not sure I'm at that point -- would prefer to explore ideas from the community first. Thanks.
1. First issue is in the summary report displayed by the data consistency check. Does the A/R balance shown in that report get drawn from the balance sheet A/R (control) account? [This is what I would expect.] However, in my case, although the amounts on each side of the inconsistencies summary report are within $30 of each other, the base amounts are on the order of $176,000. Whereas, on my B/S and A/R listing, the amounts from those sources are on the order of $186,000 (but also showing a discrepancy of $30). [FWIW, I see from another forum post that the customer deposit account comes into the picture, but the amount there is only around $100.] The point here is not the $30 difference [see next], the point is why the roughly $10,000 difference.
2. Second issue: is how to track down the discrepancy between the B/S side versus the A/R listing side in the inconsistency summary window. I've tried searching the AR listing for the discrepancy amount, but without finding anything helpful.
3. Third issue is a F/X problem: At the moment, we have one customer with a USD balance, which balance is correct and is fully understood how it arose, and it's a very recent entry (about USD$51; strictly speaking a customer deposit item, so a credit balance). But, when I display (in home and foreign currency), the B/S, trial balance, and also the unrealized FX gain/loss report, the USD balance shown for A/R balance is about USD$117 (also a credit balance). Whereas in the AR listing itself, it's only showing the one USD $51 item as the sole foreign currency item. In the AR listing, I have searched for the difference between those two amounts (in both USD and CAD), with nil results. So I'm not sure what Sage is looking at when it finds the USD$117 amount.