To create a SalesRep, the person must already be in the Other Names List in QuickBooks. If the new SalesRep is not in the Other Name List, we can create the entry using the following insert statement:
Insert into OtherName (Name, IsActive, FirstName, MiddleName, LastName) Values ('Tom QODBC', 1, 'Tom', 'A', 'QODBC')
This creates Tom QODBC in the Other Names List in QuickBooks:
Which now can be seen in the QODBC OtherName table:
SELECT * FROM OtherName
The new SalesRep can now be inserted using the Name from the OtherName table.
Insert into SalesRep (Initial, IsActive, SalesRepEntityRefFullName) Values ('TA', 1, 'Tom QODBC')
With this step, the new SalesRep is created!
SELECT * FROM SalesRep
|