Splitting Card Holder Name

[Sly9er]

I am trying to get the customer's name to land in Quick Books Pro
2003 with the last name first, followed by a comma and space,
and then the first name last:
EX: Clinton, Bill
I realized that there is only one field (Card Holder/Name) on the
check out form.
But I also noticed that Authorize Net is able to split it into
two seperate fields (First name, Last name) on the page where
you enter the credit card number. So it IS possible to do.
How can I make this happen in Actinic Business v6 automatically?
I also noticed that the first and last name fields in Quick Books Pro
2003 don't get populated. The only thing that gets populated is
the "customer name" field as follows. EX: Bill Clinton.
I am asking for this because my client wants to be able to sort
thier customers by last name. But it probably can't be done with
out the first and last namefields being populated.
And I must admit, that being able to sort by last name IS a
reasonable expectation. But right now, they have to go into each
customer file and edit it. Thus defeating the whole premis of
Actinic Business. "To eliminate multiple data entry".
Hope to hear form someone soon.

[cdicken]

There is no way to split it properly in Actinic - online you can use the 'Job Title' or 'Company' fields as an extra field, but these may not be picked up when you go through to QuickBooks.

The only thing I can think of is running a query on the 'Name' field in the 'Person' table in the ActinicCatalog.mdb database before you do the transfer to QuickBooks, which would do the re-ordering.

We are looking closely at having a 'First Name'/'Last Name' facility in Actinic for a future release.