Reconcile gives Bad Value Row 3

Problem

*Reconcile Ledger not working- gives "Bad value in row 3" always.

Diagnosis

see reconcile checklist for discussion of what might be causing this.

If none of those things work, check the name of the ledger that's being reconciled: it should NOT have a single-quote (apostrophe) in it. E.g., the name "TCL Ledger '94 " will break *Reconcile.

Caused by a very weird Excel quirk.

Solution

Change the file name in MacNail construction accounting software . Single quotes cause problems.

NOTE-- Goldenseal construction estimating software stores all company data in one file, which prevents many of the odd files we experienced in MacNail.

Comments

Entered 2/14/94 by Vinay. Updated 11/9/2010.