• Unable to retrive purchase order and lines using the dispatch object mentioned on the description

    using (DispatchObject poObject = new DispatchObject(pvx.InvokeMethod("NewObject", "PO_PurchaseOrder_bus", oSS.GetObject()))) Could any one of you suggest, which dll or nuget to be used for this dispatch object. We are using the below object management…
  • sage mas90 odbc version 3.3.100 error can't start transaction

    Hello i wanna to connect mas90 using odbc i know mas90 odbc is only read information, but i need also write some values in some tables for example on Purchase Orders when we received a pdf invoice read information from there and put on file detail of…
  • Attempting to use ODBC Driver returns `[S0000] [ProvideX][ODBC Driver][FILEIO]Table is not accessible (12)`

    I'm attempting to pull data from Sage across the ProvideX ODBC connection via external application (Python, C#, etc). After I establish a connection using the existing Data Source, every subsequent attempt to read any table returns the following error…
  • BM_GrossReqrmntReport_rpt

    I'm not finding a way to import several Bill Numbers into this report's parameters. Can you help me? It seems like i should be able to do this, however i'm not finding the right path yet. VI doesn't offer it and i'm having trouble finding clues to help…
  • Customer Type in the AR_Customer Table

    Hi Team I would like to know about the description for the values in the column (CustomerType) in the AR_Customer table
  • SO_SalesOrderHistoryDetail has records with a null SalesOrderNo

    I've noticed that we have just over 14,000 records in the SO_SalesOrderHistoryDetail table where the SalesOrderNo field is null. This is causing some issues with trying to do a copy into a MySQL database due to the Primary Key not accepting null values…
  • Vendor Pricing Method Field

    In Vendor Pricing Maint. there is field called "Pricing Method" What table is this field in and what is the field name under the covers? Thanks
  • Customer Last Purchase History on Sales Order not working

    Hi Guys So we recently upgraded to Sage 2023. Since the upgrade some users have being reporting that the Customer Last purchase history (Red Binoculars) is not populating for them on sales order. I first thought it might have been a permissions issue…
  • Adding and Modifying Records to the PL_JournalPDFLog

    Trying to update file names in the PDF_JournalPDFLog. Identified the Records but need to know what table I need to modify. Through VI, the table is not available. Suggestions?
  • Sage100 BOI : AR_InvoiceDetail

    We are currently exploring usage of the Sage100.ObjectManagement NuGet package (.NET 6 FYI). I can create AR_InvoiceHeader and AR_InvoiceDetail line items. Preface: Already have an instance of MasSession that is all well and good (authorized and functions…
  • Passing parameters from SSRS

    How do you pass an SSRS report parameter to Sage? It seems you can pass an explicit value in the sql where clause but cannot pass it from a parameter. The only place to further narrow the data is to add it as a filter to the report. Is there a more…
  • Multi-Bin Location Maintenance

    I need to delete approximately 1200+ bin locations. Please tell me there is a way to mass delete? Thanks for any assistance.
  • How do I remove an unposted invoice for error handling using BOI.

    I want to improve error handling in a script I have. How do I remove a unposted invoice using BOI. I couldn't seem to get the Delete function to work.
  • oShipLines.nCopyLinesFromSalesOrder(soOrder) is copying an extra line

    Hi Forum, I am using .nCopyLinesFromSalesOrder(soOrder) to bring in all lines from the Sales Order into Shipping Invoice data entry and every order I import is duplicating the lines. Any advice on this will be greatly appreciated. Regards, Ma…
  • Changing Vendor No

    Hello I need to change all items with Vendor No# NOV02 to NOV04 would I do this within VI??
  • Cash Receipts Import

    Hi Forum, I've been trying to import Cash Receipts via a BOI script and i am going nowhere. Once i was able to import the lines but they came in with no AmountPosted. Then i changed the script to find the invoice Lines and all of a sudden, no…
  • Adding a markup to a number during Visual Integrator Import

    Running Sage 100 v2018 and am trying to create a VI import where one of the numeric fields being imported needs to have a $0.10 markup (i.e. if the field is populated with $2.35, the import should add .10 so the record would import the price as $2.45…
  • Using a Sage UDT (Sage Premium SQL table) as a source for a VI job?

    How can I use a Sage UDT SQL table as a source for a VI job?
  • Best option for extracting data out of Sage 100 into Third-Party software

    We are looking at a Third-Party software called Master Control for our QA/QC documentation processing. With that, we want to be able to extract data out of Sage 100c Advanced v2019.2 (upgrading to v2021 shortly) from Scanco's Manufacturing module, as…
  • MyAssistant / Office Connector Functionality in Sage 100

    Does Sage 100 have MyAssistant or functionality similar to it or Office Connector? My use case is extracting data regularly for Reporting.
  • How to automatically create Work Ticket in Production Management from Sales Order using BOI

    I have built an order importer that automatically creates sales orders based off of an EDI file from our customers. It works great. We are currently upgrading Sage 100 to include Production Management Plus and I want to be able to add in the ability to…
  • PO Clearing Table

    Hello not sure if this is the right place to ask this question but I'm looking to see if there is a table that hold records for the Purchases Clearing report..
  • Importing Sales order in BOI doesn't import zip codes

    Hi Forum, We have a script that we use to import sales orders from a website. It has been working but we upgraded Sage 2016 to Sage 2021.2 Premium and now the BOI script is failing. First, we had an issue with Tax Schedule is required message and…
  • Adding a perform with two select statements in Sage 100 Visual Integrator

    Client running Sage 100 v2018. Trying to export purchase order information based on two select criteria that is outside standard fields. I'm able to create a Perform for the individual selections and when I add one of the two perform functions to the…
  • VI Import Vendor Number

    I am working on an import that is related to the following thread; https://www.sagecity.com/us/sage100_erp/f/sage-100-business-object-interface/177980/how-to-run-visual-integrator-from-bat-file . When I go to test the PO_Header import I keep getting…