Sage 100

 View Only
  • 1.  PR conversion from 2017 to 2019 - where to find the bad record?

    Posted 07-31-2019 11:06
    Would like to clean this record out in 2017 data, but can't find it anywhere.  Not in PRU.  Any idea what data file(s) might have this record with the space before "CA"?


    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------


  • 2.  RE: PR conversion from 2017 to 2019 - where to find the bad record?

    Posted 07-31-2019 12:26
    Can you see it and delete it in Tax Table Maintenance?


    ------------------------------
    Michelle Taylor
    ERP Consulting Manager, CS3 Technology
    918-388-9772
    ------------------------------



  • 3.  RE: PR conversion from 2017 to 2019 - where to find the bad record?

    Posted 07-31-2019 12:29
    No, only CA with no space.

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------



  • 4.  RE: PR conversion from 2017 to 2019 - where to find the bad record?

    Posted 07-31-2019 14:21
    Check PR3.

    ------------------------------
    Eric Lunceford
    First Mate Business Solutions
    Oklahoma City, OK
    877-880-8960
    https://www.firstmatellc.com/
    ------------------------------



  • 5.  RE: PR conversion from 2017 to 2019 - where to find the bad record?

    Posted 07-31-2019 16:41
    Thanks, checked.  Not that file.

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------



  • 6.  RE: PR conversion from 2017 to 2019 - where to find the bad record?

    Posted 07-31-2019 17:24
    These are all the other files with STATECODE (except for data entry):

    PRE, PRH, PRM, PRV, PRW, PR_09, PR_23


    ------------------------------
    Eric Lunceford
    First Mate Business Solutions
    Oklahoma City, OK
    877-880-8960
    https://www.firstmatellc.com/
    ------------------------------



  • 7.  RE: PR conversion from 2017 to 2019 - where to find the bad record?

    Posted 07-31-2019 17:58
    Thanks so much Eric, but I can't find that offending space in any of those files.  I'm going to go ahead and convert the company and see if I can find it in the new version.

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------



  • 8.  RE: PR conversion from 2017 to 2019 - where to find the bad record?

    Posted 08-02-2019 12:30
    Edited by Barbara Goldstein 08-02-2019 12:31
    Haven't converted yet, because not sure if it will affect any other companies (there are 59 in this installation).  I had originally migrated from a copy of their old version.  When I was searching the data files after encountering the conversion issue, I looked in their live data, not the copy, thinking the data were identical.  In the copy, however, I found that PRE had the offending record and removed it. PRE in their live data had a Date Modified after the copy/migration (don't know what caused that to change).  I also did data dumps to Excel of many of the other files Eric listed in their live data (as well as PR3 & PR_40), but did not find the "spaceCA" record anywhere else.  I re-migrated, system files and all from live data, thinking that if PRE was "clean" in live data, I would get better results.  I did not.  I have a case open with Sage, waiting for a call-back, but at this point, I'm wondering if going ahead with the PR conversion and mapping the record to the CA tax group will change anything in any system file that could affect the other companies.  Sage analyst didn't know.  Thoughts?

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------



  • 9.  RE: PR conversion from 2017 to 2019 - where to find the bad record?

    Posted 08-02-2019 14:51
    Worked with Sage.  Couldn't find it.  Converted the company.  Compared Quarterly Tax reports - they tied between versions.  Moving on.

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------