Steve:

Very unfortunate that Softrak hasn't yet added Note import for Vendors or Items when it has existed for some time in the other modules.

I've done some database repairs on the Notes (though it's been a couple of year) using GV-RW. Not positive but I'm fairly certain that at some point in the past I've also used GV-RW to add new notes.

The trick is to figure out the Header and Details relate and how Note Key & Line Numbers are assigned. For a one time import with GV-RW this shouldn't be too big of a challenge but definitely not a solution for end users who are looking for a solution to import notes on a regular basis.

I don't recall having ever do anything with the Additional Comments but they are in the Note Details with a Note Key of ######000000 and a sequential line number. Use GV-RW requires that you figure out the next line number to use.


Edited by Douglas Dickie (11/11/20 11:08 AM)
Edit Reason: Clarification
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com