• Copying an Employee's Report Setting

    Hello, I have been asked to copy the Report Setting that a specific employee that is no longer with the company had created and to bring it to the main company's account. The reason for this being is that the company's account, for some reason, is printing…
  • Export Invoices From Prior Day and Where Sales Order Begins With J

    I need to export invoices that are from yesterday's date and the related Sales Order begins with a J. I am a novice at using Sage Intelligence, but I have some SQL experience. I understand that it's not actually SQL. I'm able to get the below SQL…
  • SAGE random pdf export cannot be opened

    Hello, We are having an issue with exporting reports to a pdf file. Random reports will not open and acrobat gives the message "Adobe Acrobat could not open 'name_of_file.pdf' because it is either not a supported file type or because the file has…
  • Intermittent "[ProvideX][ODBC Driver]Internal error"

    I am encountering an intermittent "[ProvideX][ODBC Driver]Internal error" within an Excel workbook containing several worksheets, each of which contains a Microsoft Query (MSQuery) to various Sage 100 Advanced v. 2019 PU 2 files/tables. The query results…
  • VI Export Job - Conditional export of two data fields into one column

    I want to export SO_InvoiceDetail data. In one of the columns, I need the value to be the ItemCode, unless there is an AliasItem, in which case I want the AliasItem to be exported in the column. My export currently looks like: InvoiceNo - Col 1 ItemCode…
  • Visual Integrator - Export Job - Error 12

    Running Sage 100c 2018 I had a job get stuck and attempted to unlock. In doing so, it now gives me the error that a file could not be found and an error #12 File VIWDEF.LIB Is this an easy fix? Thanks, Ryan
  • MAS200 Version 4.40 Export to Excel in Vendor Inquiry (and others) grayed out or unavailable

    We are running an old version of MAS200, version 4.40. I had to upgrade my laptop due to it's untimely death. I am currently on Windows 10, Office 2019 (32-bit). For some reason, the Export to Excel button that was available on my old laptop is "grayed…
  • Can you use Task Scheduler to Export to a File

    Does anyone know if you can use Task Scheduler to export a Standard Report to Excel in place of printing? I don't see any way of picking anything but a printer. Thanks
  • Export to Excel Table - Unformatted

    I'm looking for pointers on exporting data from Sage 100 into an Excel table with no page formatting. I can build queries to populate the required columns of information, but clicking the export button always renders a file with page header rows, page…
  • Visual Integrator Export by Date

    Is it possible to subtract days from the current date? I'm trying to do an export from the AR_InvoiceHistoryHeader table, and I want this to be automated, and I don't want to export the entire table every time. I've tried things against the TransactionDate…
  • Crystal 2011 Export Error to tab-separated text file

    Crystal Reports 2011 Export Error - Sage 100 Advanced V2016 PU5. Running custom Indented Bill of Material Report with subreports, and then exporting to tab-separated text (.ttx) file. This works fine on Windows 7 and Windows 8.1 workstations. New Windows…
  • "index was outside the bounds array" error

    i got this error when i was trying to import from sage to excel "index was outside the bounds array" any help? thanks
  • Fed Ex Data Integration - for Return labels when using RMA

    During our RMA process we like to have FED produce a FED EX return label and email it to the customer. I have the data integration established with FEDEX Ship manager software and i am able to create the Shipping / Return label from Shipmanager. I would…
  • How to change file type in EXPORT JOB MAINTENANCE,

    How to change file type in EXPORT JOB MAINTENANCE, For me it is showing FILE TYPE: Delimited, and that drop down box is disable (grayed) so I can not change file type. Tried checking / unchecking ASCII
  • Question about Bill of Materials and Crystal reports

    My client is on Sage 100, 2014 Product update 7. Currently, I am trying to write a Crystal report for Bill of Materials. I need to have a field brought n that is the current bill or default bill for the bill of materials. I can pull the bill of materials…
  • AR TRANSACTION TYPES

    Hi, I'm writing a query of my Version 4.5, I need a listing of TransactionType used in AR_TransactionPaymentHistory and what mathematical sign should be used with each in creating a report in Excel. I know about the following Transaction Types: I, P…
  • Need to get Invoices/Contacts data from sage 100 directly in website

    Hi, I am developing website using Laravel frame work (PHP) which is invoice management system and we are giving facility to our customers to fetch Invoices/Contacts from their ERP. For sage, I have setup API based import system for Xero, Sage and Quick…
  • UDF field Missing Leading zeroes in Crystal

    we are on MAS100 5.1 using crystal reports 2011 for Sage. I have created a UDF field in Sales Order Detail called UDF_Customer_Item_No , i made this 15 char long as a String, control type multi line. we are using visual integrator to import orders…
  • Looking for Data Migrator Tool to migrate 'Netsuite' historical data to Sage 100 ver 2013?

    Any suggestions?
  • IM_PriceCode issues with Visual Integrator

    Hello! I am having a problem importing records with Visual Integrator using the IM_PriceCode table. HELP! In the past, we have used this table to manually import customer pricing, basically uploading the CustomerNo, ItemCode, & Price directly into…
  • VI Perform Logic for AP Invoice Duplicates - Sage100 Business Framework (v2014)

    Hello - I am looking for someone to be so kind as to post the syntax for Perform Logic to look for already posted duplicate A/P invoices during VI. I used perform logic in the past (non-framework) but do not know what the current syntax should be. …
  • Visual Integrator Issue

    After importing Excel database files through the "job Select" option, I run the TEST option and it is starting to "Ignore" all the imported files, which it has never done that before. Does anyone have an idea why this would happen and more importantly…
  • Excel Export Interpretation Issue

    I would like to know if there is a way to change the default "General" cell formatting to "Text" in Sage 100 ERP (MAS90). The issue I am having is that when I use Item Maintenance to list a product line, we have many items that have leading zeros. These…
  • Transfer of company in Sage MAS 90 ERP v 4.4 to another instance of the same MAS 90?

    Our company uses MAS 90 and we have inherited a company across town and I just need to go and export the company on their instance of MAS 90 and import it into ours. (both same version) Is there and export/import function for this? Thank you for your…
  • Exporting GL Transaction detail with VI in 4.3

    Tried to create export with VI for GL Transaction detail and it pulls 0 records. Need it to pull for a whole month. and currently using the GL_TransactionJournalHeader. Want it to pull SourceJournal, EntryNo, PostingDate, JournalComment, and JournalTotal…