Production Management Breaks Visual Integrator Export Ability: Error 88 in program VI_Export_UI.PVC at line 1001

There seems to be a bug in VI EXPORTS when Production Management is installed. So far as well can tell it may impact the ability to export any data through VI though the KB only mentions certain tables.  

For example, if I try to just export an AP vendor list I get the same error 88.

Normally this isn't an issue because you'd just use Crystal Reports to create an export. However, some third-party solutions make use of VI Exports as a way to generate their interface files ( ACCUPOS is one ) which makes the Crystal workaround impractical.

I can't tell what versions this may apply to. I have a customer on v2020.2 that this is happening to after we installed PM.

Error 88 VI_Export_ui.pvc line 1001 when running Visual Integrator Export job

  • Update - 2/2/22 - this continues to be an open product defect ( Sage KB 111814 ) SAGE CASE #: 8008968847

    Error 88 VI_Export_ui.pvc line 1001 when running Visual Integrator Export job with JT_Template and CI_ExtendedDescription linked with ExtendedDescription as the Primary Expression

    Although this defect report references specific tables I believe that the defect impacts all exports from VI.

    Business Reason Customer Can't Just Use Crystal Reports: Customers uses third-party Accupos POS ( which was purchased during the brief time that it was an endorsed solution ). And Accupos uses VI EXPORT to gather data from Sage.

    Sage's latest replay to 2/1/22 inquiry by customer: 

    Sage just called me back. Could be " a couple months". Slight smile

    Said a Sage must put a compliance update before addressing any bug fixes. He suggested I call back in once a month. Sounds like it will come from Scanco.

    Based on my experiences with this customer who insisted they needed to use a production management type solution - I probably would not have put myself into the middle of the engagement.

    Use caution with any new production management implementations

  • Use Excel or Access to PULL the data. 

  • FormerMember
    FormerMember in reply to Wayne Schulz

    You could write a ScriptBasic BOI or ODBC  script to create your export file. Here is an example of reading the ABC customer file.

    Note: (Optional Syntax) You don't need () for functions if they aren't returning anything. You don't need a :CALL if you're not passing any arguments. These examples use this syntax scheme.

    BOI

    ' BOI Customer Directory
    
    IMPORT com.sbi
    
    oscript = COM::CREATE(:SET, "ProvideX.Script")
    COM::CBN oScript, "Init", :CALL, "C:\\Sage\\Sage 100 Standard\\MAS90\\Home"
    
    osession = COM::CBN(oscript, "NewObject", :SET, "SY_Session")
    COM::CBN osession, "nsetcompany", :CALL, "ABC"
    COM::CBN osession, "nSetModule", :CALL, "A/R"
    ocust = COM::CBN(oscript, "NewObject", :SET, "AR_Customer_svc", osession)
    
    COM::CBN ocust,"nMoveFirst"
    DO UNTIL COM::CBN(ocust, "nEOF", :GET)
      PRINT COM::CBN(ocust, "sCustomerNo", :GET) & " - " & _
            COM::CBN(ocust, "sCustomerName", :GET) & " - " & _
            COM::CBN(ocust, "sCity", :GET) & " - " & _
            COM::CBN(ocust, "sState", :GET) & " - " & _
            COM::CBN(ocust, "sTelephoneNo", :GET) & "\n"
      COM::CBN ocust, "nMoveNext"
    LOOP        
    
    COM::CBN ocust, "DropObject"
    COM::CBN osession, "DropObject"
    COM::RELEASE oscript
    

    ODBC

    ' ODBC Customer Directory
    
    IMPORT odbc.sbi
    
    dbh = odbc::RealConnect("SAGE100","","")
    odbc::Query dbh,"SELECT * FROM AR_Customer"
    
    WHILE odbc::FetchHash(dbh, column)
      PRINT column{"CustomerNo"} & " - " & _
            column{"CustomerName"} & " - " & _
            column{"City"} & " - " & _
            column{"State"} & " - " & _
            column{"TelephoneNo"} & "\n"
    WEND
    
    odbc::Close dbh
    

    Output

    C:\ScriptBasic\examples>sbc custdir_boi.sb
    ABF - American Business Futures - Milwaukee - WI - (414) 555-4787
    ABS - ABS - Sage cloud for invoices - Newport Beach - CA - (949) 555-7814
    AVNET - Avnet Processing Corp - Racine - WI - (414) 555-2635
    BRESLIN - Breslin Parts Supply - Molalla - WI - (414) 555-9654
    HILLSB - Hillsboro Service Center - Hillsboro - WI - (414) 555-6599
    INACTIV - Inactive Customer **INACTIVE** - Milwaukee - WI - (414) 555--8747
    INTMEX - Int. Cust with Mexican Address Name expanded to 50 - Ensenada - BC - +52 646 177 1466
    MAVRK - Maverick Papers - Chicago - IL - (312) 861-1200
    RSSUPPL - R & S Supply Corp. - Milwaukee - WI - (414) 555-5587
    SHEPARD - Shepard Motorworks - Milwaukee - WI - (414) 555-6544
    ALLENAP - Allen's Appliance Repair - Fountain Valley - CA - (714) 555-3121
    AMERCON - American Concrete Service - Anaheim - CA - (714) 555-2134
    ATOZ - A To Z Carpet Supply - Newport Beach - CA - (714) 555-2231
    AUTOCR - Autocraft Accessories - Newport Beach - CA - (714) 555-0101
    BAYPYRO - Bay Pyrotronics Corp. - San Francisco - CA - (415) 555-9654
    CAPRI - Capri Sailing Ships - Santa Ana - CA - (714) 555-4421
    CUSTOM - Custom Craft Products - Santa Ana - CA - (714) 555-7848
    GREALAR - Greater Alarm Company - Fountain Valley - CA - (714) 555-5531
    JELLCO - Jellco Packing - Orange - CA - (714) 555-9451
    ORANGE - Orange Door & Window Co. - Irvine - CA - (714) 555-7823
    
    C:\ScriptBasic\examples>sbc custdir_odbc.sb
    ABF - American Business Futures - Milwaukee - WI - (414) 555-4787
    ABS - ABS - Sage cloud for invoices - Newport Beach - CA - (949) 555-7814
    AVNET - Avnet Processing Corp - Racine - WI - (414) 555-2635
    BRESLIN - Breslin Parts Supply - Molalla - WI - (414) 555-9654
    HILLSB - Hillsboro Service Center - Hillsboro - WI - (414) 555-6599
    INACTIV - Inactive Customer **INACTIVE** - Milwaukee - WI - (414) 555--8747
    INTMEX - Int. Cust with Mexican Address Name expanded to 50 - Ensenada - BC - +52 646 177 1466
    MAVRK - Maverick Papers - Chicago - IL - (312) 861-1200
    RSSUPPL - R & S Supply Corp. - Milwaukee - WI - (414) 555-5587
    SHEPARD - Shepard Motorworks - Milwaukee - WI - (414) 555-6544
    ALLENAP - Allen's Appliance Repair - Fountain Valley - CA - (714) 555-3121
    AMERCON - American Concrete Service - Anaheim - CA - (714) 555-2134
    ATOZ - A To Z Carpet Supply - Newport Beach - CA - (714) 555-2231
    AUTOCR - Autocraft Accessories - Newport Beach - CA - (714) 555-0101
    BAYPYRO - Bay Pyrotronics Corp. - San Francisco - CA - (415) 555-9654
    CAPRI - Capri Sailing Ships - Santa Ana - CA - (714) 555-4421
    CUSTOM - Custom Craft Products - Santa Ana - CA - (714) 555-7848
    GREALAR - Greater Alarm Company - Fountain Valley - CA - (714) 555-5531
    JELLCO - Jellco Packing - Orange - CA - (714) 555-9451
    ORANGE - Orange Door & Window Co. - Irvine - CA - (714) 555-7823
    
    C:\ScriptBasic\examples>

  • Update - this appears to be resolved with 2020.4 or 2021.2 

    Note that while the KB linked about makes this seem as if it is limited to Production Management related exports, my testing of trying to create a vendor export from AP produced the same results (prior to updating the PU).