Sage 100

 View Only
  • 1.  Upgrade data conversion issue - Sage 100 Adv 4.30.

    Posted 01-28-2016 09:01
    Upgrade data conversion issue - Sage 100 Adv 4.30.18 to 2015.3 Has anyone had an issue where the Upgrade data conversion (with 'PO history creation' enabled on the screen that appears at the beginning of data conv) just seems to hang forever and never finishes, but then upon re-trying a fresh data conversion (without 'PO history creation' enabled), it completes successfully?


  • 2.  RE: Upgrade data conversion issue - Sage 100 Adv 4.30.

    Posted 01-28-2016 09:20
    How much PO history do they have?


  • 3.  RE: Upgrade data conversion issue - Sage 100 Adv 4.30.

    Posted 01-28-2016 09:22
    Ditto Therese's question. Did you run the utilities on the PO tables? They could have a lot of garbage out there?


  • 4.  RE: Upgrade data conversion issue - Sage 100 Adv 4.30.

    Posted 01-28-2016 09:29
    Also from what I recall the PO History convert indicates if you skip it you can go and re-build history on PO Utilities - might try letting things convert without PO History then go to the PO Utilities.


  • 5.  RE: Upgrade data conversion issue - Sage 100 Adv 4.30.

    Posted 01-28-2016 12:06
    Well it _appears_ this issue is due to the client's PO Entry files being rather large. Header has 15,150 records and Detail has 83,908 records. # of days to retain completed PO's is set to 360, and they look to be performing P/O Period-end Processing in a somewhat timely manner. In general they apparently issue lots and lots of PO's. Ran the data conversion without enabling PO History Creation. Looked in Sage 100 and saw that the new PO Hist Inq has 0 records (as expected). Ran the PO History Creation utility (only took 3min!!) ""This utility will create records in the PO History files from standard orders, drop ship orders, and material requisitions contained in the PO Data Entry files"". The new PO Hist Inq now has the 15,150 PO's. I don't understand why we ran into this issue if after-the-fact it only took 3min to create the PO History. I also don't understand why the data conv appeared to hang on ""A/P Creating new tables"". Btw, before data conv I had also tried rebuilding Keys and Sorts (po, im, ap, ci) but that didn't seem to help.