experchange > solomon

momotaro (10-08-04, 08:01 PM)
I am trying to import payments from excel spreadsheet to Account Receivable
in Solomon. Can anyone help me how to do it? Thank you.
Sammy Caras (10-09-04, 05:07 PM)
There are a few ways you can accomplish this. No method listed here is
"simple", except the fourth.

1. Read the documentation on Transaction Import, and implement it. This is
the most-direct method for non-programmers.

2. Develop an interface using the Solomon Object Model, which will mimic
user-entry on the Payment entry screen if you program it correctly.

3. Use DTS to bring your Excel spreadsheet into a temp table on SQL server,
and write directly to the database using T-SQL.

4. Hire a Solomon Developer/Consultant to set it up for you. Someone who
knows what they are doing can have it up and running in less than a day.

Good luck,

Sammy Caras, SCAD

"momotaro" wrote:
Similar Threads