Sage 100

We have a client that receives this message when trying to run ANY visual integrator jobs. VI had worked fine in the past. The only new addition has been Scanco Multi-bin. We have tried creating new VI jobs and get the same message. The User has full…

Have the following source file (CSV) 2 questions: 1 - I want to import the Invoice No and append "-CM". Is this possible? 2 - Importing the lines Distribution Amount from the Credit Column. How do I reverse the sign so it comes in as a negative…

Running Sage 100 Premium 2021: need to reduce the size of the AR Invoice History tables. The purge invoice history utility is good as far as it goes, but I need to remove invoices for only one division that creates thousands of repetitive invoices monthly…

Client is running Sage 100 v2018 and have asked for a VI import of cash receipts. They scan in information and save it as a csv. However, the information does not include Customer Number...only Invoice Number. Within the Sage 100 Company where the data…

We have the MAS 90 4.0 ODBC Driver installed and I've setup a system DSN connection that we link to an Access DB. The DB is saved on the Sage server, on our network I have an excel spreadsheet that is pulling data from a query in that DB, it refreshes…

I have an excel spreadsheet that uses the SOTAMAS90 ODBC 64 Bit System DSN to update some data from our AP tables. When I open this spreadsheet on the server with Sage 100 advanced installed the query completes and data is updated is less than 5 seconds…

I've connected a single table from Sage 100c 2021 to Excel (data model) via a silent ODBC connection with saved username/password. All works great for me, but if anyone else uses this excel workbook and tries to refresh the data it makes them log in a…

Trying to do a VI import into IM_ItemVendor but in my import file I don't have the vendor number only the vendor name so I file assigned the vendor number on a conditional statement if the temp field (pointing to the vendor name in import file) equals…

I have a client using Sage 100 Premium for core accounting for 200 companies installed in the default instance. I need to upgrade for 2019 to 2021, what is the procedure to keep using the default instance on a single server? Ideas? There are multiple…

I have seen some similar threads but none of them seem to work. Here is my situation, and bear with me I am very green with ODBC connections: I am wanting to connect to SOTAMAS90 through PowerBI gateway to get my data on a constant refresh. This would…

I am hoping to streamline my VI script designed to import AR credit memos. If entered manually I only enter CM <Next Invoice>, Customer Number, Apply To Invoice. I am then asked "Do you want to copy invoice information from history?" Clicking Yes allows…

We were needing to have Microsoft reporting services (SSRS) on the same server as Sage 100, but as sage uses the sql database, and has (I believe?) Crystal Reports built in, would there be any issue installing the SQL Server Reporting Services onto the…

I'm doing an import job maintenance. Our PO has the field L.QuantityOrdered as 12 and L.UnitOfMeasure as "EA". In Sage, the Item has a Sales UOM of "CS6", which translates to 6. So when we import the order, the PO means 12 total, but the system…

Had an upgrade from v2016 to v2021 Advanced. Migration/conversion went well with no errors. However forms, reports, bie within sage 100 doesn't display data and even trying to do a crystal report outside of sage doesn't display data. I could see that…

I have a client that has been sold. We are going to create a new company and copy accounts, vendors, customers, etc. but not the history. I also need to copy all of the active employees. Has anyone done in the new payroll with PII? Thanks, Suzanne…

Our client has a system in place that kicks out a dept code. This department code has been directly linked to a G/L account by utilizing the AP Expense Distribution Table (Code 5 on the Distribution Table is equivalent to the G/L account we want to import…

I'm confused about the relationship between Sage data files and the SQL database. If a server dies, or gets ransomed, my first step will obviously be to reload the application server from backup, then the SQL backups. There is potential for different…

I see this on two new upgrades to v2021.1 Standard (both on SPC, but that may just be a co-incidence). Edit a Role and I get this prompt when saving: (SY_RoleApply.Y2) But this is what I "should" see: Similarly, with the Document Date warning…

In MS Access we have used ODBC to connect to the Sage 100 ver 2019 data files. We get an ODBC error when accessing the AP_InvoiceHistoryDetail table (a very large file). In MS Access we see the linked file. I open it and go to the last record. It works…

Client is running Sage 100 v2018. Tried PRC(AP_InvoiceHeader04.DiscountAmt,2) in the numeric field - Calculation but that doesn't seem to change anything. The numeric mask is ###,###,###.00- but if the DiscountAmt being exported is 0, it's not showing…

Running SAGE 100 v2018 and trying to import a file on a daily basis that will contain a data stamp on it. What I'm trying to do is automate the process by creating a scheduled task in Windows that opens a batch file that runs the VI program. The only…

I feel like I should know this, but for some reason I'm struggling with this VI job. I am importing into AR Invoice Data Entry. My file has over 400 lines in it. What I want to happen is have the import assign the Next new invoice number, once. However…

PR header and detail are chained. Same problem with each.

I'm attempting to create an import job that will either create a new employee record if it does not already exist or update an existing employee if it's already present. I'm running into an issue where existing employees are not updating and am not sure…

Sage Premium version 2020 Reinitialize Datafiles utility I get the above message/problem when trying to reinitialize any AP or AR data files. I don't get the message when reinitializing IM, PO and SO files. So when this message pops up I have to…