Can I use SAGE 100 Visual Integrator to export data from Job Cost's JobHistoryTransDetail table to a SAGE 100 User Defined Table?

Question

I've encountered problems while trying to use SAGE 100's Visual Integrator to export data from Job Cost's JobHistoryTransDetail table 
 to a SAGE 100 User Defined Table? I need to export all of the JobHistoryTransDetail table records for a desired date range. 
 I can get the export (to a .csv) to work correctly, but when I try to import into the User Defined Table, it only creates one record in the UDT based on the 
 "Key field" that I've created for the UDT. 
 Any thoughts on how to resolve this?

StefanouM · Answer

Your user defined table will need a Primary Key that makes each record unique. If you are trying to bring in multiple transactions for the same Job, then the key needs to be unique in some way. Probably something like a Key Field that is a concatenation of Job Number + Transaction Type + Cot Code + Cost Code Type + Transaction Date. Based on your data, find something that makes it "unique".

Sage 100

Can I use SAGE 100 Visual Integrator to export data from Job Cost's JobHistoryTransDetail table to a SAGE 100 User Defined Table?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING