Sage 100

 View Only

  • 1.  Error #35: Invalid date/time specified

    Posted 09-04-2021 13:41
      |   view attached
    Any one familiar with this error when migrating 3.71 to 4.50.8?  One company worked; one gets this error.

    ------------------------------
    Douglas Luchansky
    ACI Consulting
    ------------------------------

    Attachment(s)

    txt
    F05_error35.txt   8 KB 1 version


  • 2.  RE: Error #35: Invalid date/time specified

    Posted 09-04-2021 13:52
    Did you try to open the file (company F05, file GL_FiscalYearDetail) in DFDM and look for any abnormalities about the records near the record referenced (looks like record 199402)?

    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------



  • 3.  RE: Error #35: Invalid date/time specified

    Posted 09-04-2021 13:54

    Thanks David – we checked that out but I think I am going to look again – appreciate it

     

     

    Thank you,

     

    Douglas Luchansky

    ACI Consulting

    p 714.282.0378 ext. 302    f 714.282.0235

     

    douglas@ACIconsulting.com

     

     

     

     




    Original Message


  • 4.  RE: Error #35: Invalid date/time specified

    Posted 09-07-2021 08:23
    Edited by Brett Zimmerman 09-07-2021 08:25

    Error: "35 GL_FiscalYear_svc.pvc 147"

    Created on 02-10-2014 | Last modified on 04-01-2021

    Summary

    "35 GL_FiscalYear_svc.pvc 147" during data conversion.

    Disclaimer

    Backup Warning

    Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.

    Cause

    This error is caused by an invalid date in General Ledger Fiscal Maintenance Table or redefine the fiscal year dates in the previous version.

    Resolution

    • Remove bad record from GL_FiscalYear.M4T :
      1. Open Library Master, Utilities, Data File Display and Maintenance
      2. Select file ..\MAS90\MAS_ABC\GLABC\GL_FiscalYear.M4T
      3. Click Key Scan button and delete any records where Key does not contain valid year
      4. Proceed with conversion
    • Manually reinitialize Fiscal Year Masterfile:
      1. Open Sage MAS 90 in the previous version.
      2. Rename (in Windows Explorer) and Manually Reinitialize GLC (Fiscal Year Masterfile).
      3. Expand General Ledger and Setup. Double-click Fiscal Year Maintenance.
      4. Click the Fiscal Year lookup button, and select the year to be redefined.
      5. In the Number of Accounting Periods field, enter the correct number of periods.
      6. Verify the start and end dates.
      7. Click Accept.
      8. Repeat for all required fiscal years.
      9. After all fiscal years have been redefined, migrate and convert the data again in the current version.

    Keywords: 



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------

    Original Message


Related Content