I would like to directly add customers to quickbooks and have qb automatically assign them a refID number. Is this possiblre and what do I need to map from a query?

Phares

The ListID is automatically assigned by QuickBooks. You cannot insert this column and a number of other columns in the Customer table. Adding customers can even be done in a Form created using the Form Wizard:

Just click on the [>*] button and add them!

You can use the SP_COLUMNS tablename stored procedure command in VB Demo to get the EXACT table schema rules for the QuickBooks Company file you have open. The last few columns have Queryable, Updateable, Insertable, Required_On_Insert and the format ie:-

sp_columns TableName

See also: How do I add customers?