SageForum for UK versions of Sage 50- Help and support.

Hi. I am trying to bulk import a 4 digit number into the 'Analysis 2' field of the customer records.

I've done all kinds of imports before, so I am comfortable doing it, however for the first time i've hit an error and I can't see where to go.

I'm using just two columns, the A/C reference and the Analysis 2 field. I KNOW the acc references are correct, as I went as far as exporting the entire list of customers, deleting everything except the A/C codes, then vlookup on my import list to confirm the A/Cs are correct.

When i run the import, I get...

Error in record {number}: Default Nominal: Reference to non-existent Nominal Ledger Account.

I get this error for every record, and nothing is imported.

Any clues?

Cheers
Sam

Oh, I forgot, we've updated since last time i imported, but we haven't changed anything. (We keep up with updates, currently

Ver 21.4.7.159
SBD Ver 12.1.369.0
Updates SDO Update 1, SP3, SP4, SP5

During the import Sage checks the default nominal code.

On that record,there is no default code set and there is no default set in sage so it is baulking, if you set a value in the customer defaults or on that record all should be well

Ahhh so simple, thanks. I didn't make the connection that 'default nominal code' and 'default nominal ..... nominal ledger account' were the same thing, and I guess we never had this problem before because the old version had probably already had a global customer default set.

Many thanks.

Sam