• Registered: 11/18/2011
  • Posts: 5

Topic: Problems importing Customers into 2.3.7

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

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Problems importing Customers into 2.3.7

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

  • Registered: 11/18/2011
  • Posts: 5

Re: Problems importing Customers into 2.3.7

Thanks Joe,

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