FormerMember

G/L Exchange - 2020

Posted By FormerMember

I getting an error 200 when I try to do a simple export of G/L account numbers and descriptions to Excel using General Ledger Exchange. (Utilities)

Is it just me or has anyone else had this issue?

Thanks in advance for any feedback on this.

Details:

Windows 10 Pro - Office 360 subscription

Sage 100 2020 Standard

  • FormerMember
    FormerMember

    I tried the same with the ABC demo data and it worked fine. It seems the company data I converted has issues.

  • in reply to FormerMember

    Can you post the error info (program name, line number, etc.)?

  • FormerMember
    FormerMember in reply to BShockley

    Thanks for the reply!

  • FormerMember
    FormerMember in reply to BShockley

    Here are the details for the company that fails.

    OBJECTS:
    
    [100001]           SY_Session
    [100002]           SY_File
    [100003]           SY_Crypto
    [100004]           SY_Registration
    [100005]           SY_Theme
    [100006]           SY_SagePEP
    [100007]           SY_UI
    [100008]           SY_LocaleInfo
    [100009]           SY_Security
    [100010]           SY_Security
    [100011]           GL_ExchangeSelection_UI
    [100012]           SY_Security
    [100013]           SY_Collection
    [100014]           GL_ExchangeSetting_bus
    [100015]           SY_DocDateWarn
    [100016]           SY_BusinessColl
    [100017]           CM_Customizer_Svc
    [100018]           GL_EXCHANGEWIZARD_UI
    [100019]           GL_AccountStructure_svc
    [100020]           SY_Collection
    [100021]           GL_ExchangeWizard_bus
    [100022]           SY_DocDateWarn
    [100023]           SY_BusinessColl
    [100024]           GL_ExchangeSetting_bus
    [100025]           SY_DocDateWarn
    [100026]           SY_BusinessColl
    [100027]           GL_Budget_BUS
    [100028]           SY_DocDateWarn
    [100029]           GL_BudgetOptions_bus
    [100030]           SY_Collection
    [100031]           SY_ChildColl
    [100032]           SY_DocDateWarn
    [100033]           SY_BusinessColl
    [100034]           GL_FiscalYear_Svc
    [100035]           SY_BusinessColl
    [100036]           Sy_PopupXref_Svc
    [100037]           SY_Script
    [100038]           SY_ActivityLog
    [100039]           SY_ActivityLog
    [100040]           SY_ErrorInfo_UI
    [100041]           SY_Collection
    [100042]           SY_ErrorInfo_BUS
    [100043]           SY_DocDateWarn
    [100044]           SY_BusinessColl
    [100045]           *obj/folder
    [100046]           *obj/group
    [100047]           *obj/tab
    [100048]           *obj/tab
    [100049]           *obj/tab
    [100050]           *obj/tab
    
    
    FILES:
    
    Channel        File Name
    ---------------------------------------------
    32702          *memory*
    32703          *memory*
    32704          C:\SB2020\GL
    32705          *memory*
    32706          C:\Sage\Sage 100 Standard\MAS90\MAS_SYSTEM\SY_PopupXref.M4T
    32707          *memory*
    32708          *memory*
    32709          *memory*
    32710          *memory*
    32711          C:\Sage\Sage 100 Standard\MAS90\MAS_BIO\GLBIO\GL_FiscalYear.M4T
    32712          *memory*
    32713          C:\Sage\Sage 100 Standard\MAS90\MAS_BIO\GLBIO\GL_BudgetOptions.M4T
    32714          *memory*
    32715          *memory*
    32716          *memory*
    32717          C:\Sage\Sage 100 Standard\MAS90\MAS_BIO\GLBIO\GL_BudgetOptions.M4T
    32718          *memory*
    32719          *memory*
    32720          *memory*
    32721          C:\Sage\Sage 100 Standard\MAS90\MAS_BIO\GLBIO\GL_Budget.M4T
    32722          *memory*
    32723          *memory*
    32724          *memory*
    32725          C:\Sage\Sage 100 Standard\MAS90\MAS_BIO\GLBIO\GL_Exchange.M4T
    32726          *memory*
    32727          *memory*
    32728          *memory*
    32729          *memory*
    32730          *memory*
    32731          C:\Sage\Sage 100 Standard\MAS90\MAS_BIO\GLBIO\GL_ExchangeSelection.M4T
    32732          *memory*
    32733          *memory*
    32734          *memory*
    32735          C:\Sage\Sage 100 Standard\MAS90\MAS_BIO\GLBIO\GL_Options.M4T
    32736          *memory*
    32737          C:\Sage\Sage 100 Standard\MAS90\MAS_BIO\GLBIO\GL_AccountStructure.M4T
    32738          *memory*
    32739          *memory*
    32740          *memory*
    32741          *memory*
    32742          *memory*
    32743          *memory*
    32744          C:\Sage\Sage 100 Standard\MAS90\MAS_SYSTEM\SY_Module.M4T
    32745          C:\Sage\Sage 100 Standard\MAS90\SOA\SY0CTL.SOA
    32746          *memory*
    32747          *memory*
    32748          C:\Sage\Sage 100 Standard\MAS90\MAS_BIO\GLBIO\GL_Exchange.M4T
    32749          C:\Sage\Sage 100 Standard\MAS90\MAS_SYSTEM\SY_LockFileInfo.M4T
    32750          *memory*
    32751          C:\Sage\Sage 100 Standard\MAS90\LOCK\_BIO\GL_Exchange.LCK
    32752          *memory*
    32753          *memory*
    32754          *memory*
    32755          C:\Sage\Sage 100 Standard\MAS90\MAS_SYSTEM\SY_RoleSecurity.M4T
    32756          C:\Sage\Sage 100 Standard\MAS90\MAS_SYSTEM\SY_UserSecurity.M4T
    32757          C:\Sage\Sage 100 Standard\MAS90\MAS_SYSTEM\SY_User.M4T
    32758          C:\Sage\Sage 100 Standard\MAS90\MAS_SYSTEM\SY_Task.M4T
    32759          C:\Sage\Sage 100 Standard\MAS90\MAS_SYSTEM\SY_RoleSecurity.M4T
    32760          C:\Sage\Sage 100 Standard\MAS90\MAS_SYSTEM\SY_UserSecurity.M4T
    32761          C:\Sage\Sage 100 Standard\MAS90\MAS_SYSTEM\SY_User.M4T
    32762          C:\Sage\Sage 100 Standard\MAS90\MAS_SYSTEM\SY_Task.M4T
    32763          C:\Sage\Sage 100 Standard\MAS90\MAS_SYSTEM\SY_RoleSecurity.M4T
    32764          C:\Sage\Sage 100 Standard\MAS90\MAS_SYSTEM\SY_UserSecurity.M4T
    32765          C:\Sage\Sage 100 Standard\MAS90\MAS_SYSTEM\SY_Task.M4T
    32766          C:\Sage\Sage 100 Standard\MAS90\providex.dde
    32767          C:\Sage\Sage 100 Standard\MAS90\providex.ddf
    
    
    STACK:
    
    Stack    Line       Program
    ----------------------------------------------------------------------------------------------------
    00015   00001  C:\Sage\Sage 100 Standard\MAS90\SY\SY_ErrorInfo_ui.pvc
    00014   00143  C:\Sage\Sage 100 Standard\MAS90\SY\SY_ErrorInfo_ui.pvc
    00013   00040  C:\Sage\Sage 100 Standard\MAS90\Home\lib\_winproc.xeq
    00012   07120  C:\Sage\Sage 100 Standard\MAS90\Home\lib\_winproc
    00011   00550  C:\Sage\Sage 100 Standard\MAS90\Home\lib\_nomads.pvc
    00010   02227  C:\Sage\Sage 100 Standard\MAS90\SY\SY_CommonUI.pvc
    00009   00495  C:\Sage\Sage 100 Standard\MAS90\SY\SY_ERROR
    00008   00046  C:\Sage\Sage 100 Standard\MAS90\GL\GL_ExchangeSetting_bus.pvc
    00007   00698  C:\Sage\Sage 100 Standard\MAS90\GL\GL_ExchangeWizard_ui.pvc
    00006   00161  C:\Sage\Sage 100 Standard\MAS90\GL\GL_EXCHANGESELECTION_UI.pvc
    00005   00040  C:\Sage\Sage 100 Standard\MAS90\Home\lib\_winproc.xeq
    00004   07120  C:\Sage\Sage 100 Standard\MAS90\Home\lib\_winproc
    00003   00550  C:\Sage\Sage 100 Standard\MAS90\Home\lib\_nomads.pvc
    00002   02227  C:\Sage\Sage 100 Standard\MAS90\SY\SY_CommonUI.pvc
    00001   00341  C:\Sage\Sage 100 Standard\MAS90\soa\SY_StartUp.M4P
    

  • FormerMember
    FormerMember in reply to BShockley

    My guess at this point is the imported company doesn't have its dependencies fully intact. The data migrated from 4.5 to 2017 then to 2019 then to 2020.