Sage 100

It takes longer than I consider normal to run the GLDR, print to PDF, and export to .xls. Does everyone have a slow export? I miss my last job's accounting software that had instant GL downloads (smart lists in Great Plains). Is there a way to speed it…

Hello fellow Sagers! Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…

We have several individual companies in SAGE. I would like to export the general ledger detail from each company, at once, into one large excel file. Currently, I go into each company and export the data manually and it is very time consuming. Is…

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…

Can't find this having been discussed anywhere, although I thought I had. I am assuming I can use a Temp field and either assign "<CompanyCode>" or Calculate it somehow. So far, nothing that I have tried has worked.

I suppose this could be for almost any table with a DateCreated or DateUpdated field, but in this case I'm trying to create an export for CI_Item what includes only those records with a DateUpldated of today. Based on 3 different posts here on Sage City…

Haven't found this posted before, although it may have been and my searching skills are diminished. I also understand that this might be something that I can pull into Access or Excel, or even write a Crystal Report, to accomplish. But for the moment…

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…

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…

Hi. Okay..... A prepayment was applied to the wromg customer in Sage and has been reconciled since December 2021. I was told to issue a debit memo for the amount that was misapplied. My big question is.... is it possible to apply prepayments to…

Hello all, SAGE 100 Could Advanced 2020 (V6.20.1.0) I have a VI (Visual Integrator) export job that pulls fields from CI_Items out of SAGE and into a .CSV file. I use Task Manager to automate this export and then another software reads the .CSV files…

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…

When exporting payment history for AP I am only getting a few years information. If I run a report I can see the system has 20 years worth of data but its only giving me 2+ years which is more like just the time frame for viewing in the system. I tried…

Hi Everyone, I am trying to export the AP_CheckDetail and CheckHeader information but I need to have a counter on the invoices. There is a field NumberOfDetailLines but if the Check has 5 invoices this field shows 5 but I need to have each invoice…

Hi all, I'm new to Sage 100 and trying to become more efficient at my job. I learned recently that it is possible to import a bank statement onto Sage 100 and automatically create invoice entries for them. After doing some preliminary research, there…

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…

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…

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

We are trying to print a group of financial statements into only one Excel Workbook. Each statement should appear as an individual worksheet with in the workbook.

Hi everyone, I'm using Sage 100 ERP 2013 and I'd like to remove the price overrides for about 10 specific customers. The customers have customer numbers that aren't sequential, but are scattered, in case that matters. I want to do this in a safe,…

I'm working on some VI export jobs in Sage 100 v2019. I'm noticing that when I run the jobs, v2019 is adding an extra delimiter to the end of each row. v2017 doesn't do this. Is there a way to prevent this?

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…

Sage 100 - P/R 2.20 After reviewing the Loan Forgiveness Application and Instructions, I am finding I need data which should be in P/R but am unable to locate. It appears all of the Reports are for quarter summaries and I need to access data from…

Hello, I am having difficulty getting some code to work. I have found examples, but translating it to C# is making it harder to solve the problem. I am trying to export a sales order through the SO_SalesOrderPrinting_UI BOI. the following settings…

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