• Sage 100 2021: Exporting List Boxes To Excel Results In Wrong Cell Formatting Applied

    On a 2021.0 and 2021.2 system, exporting to Excel from a list box results in the cell formatting applied being off by one column whereas on a 2020.1 system, the cells have the correct formatting applied. On the 2021 systems, this was observed when exporting…
  • Sage 100 button link - pass variable to vbscript for shell call

    From Main Item Maint Panel I added a button link to run a vbscript, which runs a shell command. How can I pass the ItemCode to the vbscript. ' init vars Dim itemcode Dim oShell itemcode = "S-209220" 'hardcoded here works, but needs to change…
  • Create invoice using BOI

    We are using sage 100 2019 and developing c# code for creating invoice in sage.i am able to create sales orders in sage with BOI but whenever i am creating invoice it is throwing error {"Exception has been thrown by the target of an invocation."}…
  • How to use Azalea software, provided with Sage 100 in EXCEL?

    I'm not finding any real instructions on how to generate Code 128 bar codes in excel using Azalea's add-ins. I see them in my workbook as VBA projects, but I can't figure out how to run/execute them. Any help would be appreciated.
  • Entry exceeds available quantity

    Hi All, I am trying to enter a Sales order in Sage 100 using BOI with .Net program, I have the problem to handle the "Entry exceeds available quantity" pop up. I am searching for a method but I am not able to find it. Is anyone has an how I can…
  • VI Sales Order Invoice comment lines

    I'm have problems importing comment lines on Sage 100 version 2017 . I don't see the comment line as an available field on the Data tab. I tried using L_ItemCodeDesc but it doesn't work. Line type = 4 on the Records tab. Any suggestions?
  • Sage 100 2016 with Office 2016 and Visual Integrator - getting error message

    We are running on Sage 100 2016. Just installed Microsoft Office 2016 on 2 computers. Both computers now get an error message "An error has occured. Program is shutting down" when trying to import a spreadsheet using VI. It kicks me out of VI. If I import…
  • Sage 100 - Export Excel/Calc

    Seems like Sage only exports to Excel. We have several users running Libre Office Calc From various windows in Sage 100, there is an Excel icon on the bottom right of the screen. Anyone have a secret to export as csv file...maybe a script I can attach…
  • The AR Division Number is required

    Hello, I am creating AR_Invoice via BOI. We have Account Receivable Division check box unchecked. I assume ARDivisionNo$ is optional. Here is my code //Set the A/P Invoice Header record retVal = oARInvoice.nSetValue("InvoiceDate$", _invoiceDate…
  • Integrate MAS 90 BOI with the C#.net for Delete record.

    Hi I am new in BOI integration with the C#, Can anyone share with me sample code for the delete a record from the Sage MAS 90 using C#.net? Or if you have any good reference document please, I google much about I did not find anything helpful. Please…
  • Email - Outlook Web App

    MAS 4.5.07 My goal is to allow users to email Sales Orders etc without using a local mail client, but instead use the Outlook Web App hosted by Rackspace. (I don't want to install or manage local email clients) Our mail is hosted on Exchange. Anyone have…