FrontAccounting forum — Problems importing Customers into 2.3.7

Re: Problems importing Customers into 2.3.7

null@example.com (malcrf) — Mon, 28 Nov 2011 15:14:16 +0000

Thanks Joe,

I didn't realize that there was a suitable extension for 2.3.7

Re: Problems importing Customers into 2.3.7

null@example.com (joe) — Mon, 28 Nov 2011 14:37:51 +0000

You cannot import directly with INSERT INTO debtors_master, because of a lot of secondary keys into other tables. You should use one of the extensions that are in the repository, Setup tab, 'install / activate extensions'.

/Joe

Problems importing Customers into 2.3.7

null@example.com (malcrf) — Mon, 28 Nov 2011 14:32:00 +0000

I've imported a small number of customers into debtors_master that were created on our FrontAccounting Test database, using Insert Into from the table on the test database into the table on the live database.

However when I come to maintain the customers none of them are listed in the combo selection box. This is also true of new customers I've added through Front Accounting subsequently. Is there something else I should have updated?

In fact none of the imported customers are selectable through any combo box anywhere in the Sales module.

Any thoughts gratefully received