Hello all,
I am investigating importing our non-Tessitura sales point data into the Purchase History section of the Constituent record.
I know that this is achieved via SQL directly into the 'T_GS_PURCHASE' table rather than through the client.
The only example of a workflow for doing this is in a past TLCC presentation (from the talented Henry Kelly from Woodrull Arts Center) that describes using a MS Access app to talk directly to a retail POS DB and the Tessitura DB.
Has anyone else been populating the 'Purchase History' section in a different way, perhaps just a simple SQL query, or a report that creates the entries in a similar method to the Constituent Import or Order Import Utilities?
Best,
Nicholas