Sage 100

 View Only
  • 1.  Anyone with experience extracting data out of Sage

    Posted 03-27-2014 07:45
    Anyone with experience extracting data out of Sage PFW? GL & AP transaction history?


  • 2.  RE: Anyone with experience extracting data out of Sage

    Posted 03-27-2014 08:04
    I've done a couple of conversions extracting data from PFW... even some very old versions. Did you have a question?


  • 3.  RE: Anyone with experience extracting data out of Sage

    Posted 03-27-2014 08:35
    @alanniergarth we have converted about 35 customers from PFW to other applications. The key is to pull the data from Pervasive into an intermediary data repository; specifically, MS Access or MS SQL. From there, you have some standard data conversion issues to work with. AP is pretty straight forward. You will pull open invoices from APTran. Vendor data will come from APVend. You will need to be careful if pulling into Sage 100. The Vendor Class in PFW is comparable to the Vendor Division in 100. However, in PFW, this is a default in the Vendor master and can be changed on a voucher (vendor invoice). In GL, you will work with NLChart and NLSegmnt to pull the chart of accounts and the various components that make up the accounts. History data will come from NLTXDH and NLTXBH. There are several transaction types you will want to exclude from your migration. These are unique to PFW and include income summary entries and year-end close entries.


  • 4.  RE: Anyone with experience extracting data out of Sage

    Posted 03-27-2014 08:45
    I've used this several times for tough extractions. What I like is that so long as you can export to a report text file you can grab the right data. No need for dictionaries, etc since the report typically lays out the field names for you. http://en.wikipedia.org/wiki/Monarch_(software)


  • 5.  RE: Anyone with experience extracting data out of Sage

    Posted 03-28-2014 14:32
    thanks all for the tips. deciding whether to outsource this part of an implementation.