Printing Wrong Address

Problem

Getting wrong addresses when check printing from MacNail construction accounting software.

Diagnosis

Usually happens after they have added or changed lines in Master Addresses file.

NOTE-- Goldenseal accounting software stores addresses in each vendor account, so there is no risk of weird lookup errors like this.

Solution

Select all the lines in the Master Address file except for the titles, and sort by first column. It should solve the problem.

Master Addresses file in MacNail construction accounting software must be in ascending order for LOOKUP formulas to work correctly.

They should use Update Addresses (MacNail Accounting Mgr, Data menu) to add new items in Master Addresses file. It automatically puts them in the correct place.

NOTE: If a supplier is NOT listed in Master Addresses, it will still 'look up' the NEXT line's values. They should add all suppliers etc. to the Master Addresses file so it will get correct addresses.

Comments

Entered 10/23/92 by Dennis. Updated 11/10/2010.