Sage 100

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 are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI. We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…

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…

I just upgraded from Sage 2020 to Sage 2023 and can't get any of my existing (or new) VI Import Jobs to work. When I try to actually run the job and test them, I get the message: "VI JOB_NAME Unable to open [wdx][odb]<dsn_name>" I don't get this message…

Has anyone run into an issue with a general journal posting that occurred months earlier now showing a different result if you were to run the report today? In January we had one entry, and if we run the report today, it shows 3 of the same entry. For…

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…

Hi All, Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script. I right clicked on the…

Hi, I want to read and write data in sage100 database, so after some research I found out this course for reference. But just need to validate that is this course really guides on how to read and write back data to Sage100 database or not? This…

Hi, I am new to Sage100 and customer is using Sage100 advanced which comes with ProvideX ODBC driver which only allows to read data from Sage100. I did some research on the functionality to write back the data in Sage100 but was not able to find any…

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…

Version: Sage 100cloud Premium 2020 (Version 6.20.0.01) Additional software: Scanco Operations Management & Multi-bin, Some custom DSD programming Hello all! First post here. Looking for some assistance when it comes to replicating data for reporting…

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 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 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

Hello, There is error message on the Sage100 as shown below. How to fix the error? Thank you in advance for your help!

Hello All, We are using SAGE 100. Somehow On PO qty coming in Stock status report is not Open PO Qty. SAGE is pulling a open PO qty from somewhere - SAGE ppl kindly share your thoughts In the below example, in main I m seeing a open PO qty but in…

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?

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…

For some reporting purposes I need to normalize the bill of materials exactly how it shows in the BM_SummarizedReportWRK report into a SQL table. How do I do this? I've been attempting to backwards engineer from the regular and accessible Bill Of Materials…

I am not sure why when I run the VI export job, the tax amount from SO_InvoiceDetail appears to be 0 in the exported result file. All other values are being exported correctly. I have also check ed manually in the sales orders and invoices that the tax…

Able to export and save the positive pay file to the Application Server or the Terminal Server, but unable to save the file to another location on the local network or tsclient. We can export other files and even the ACH file to a local network or tsclient…

Hello, I am trying to do a SQL query to see which users have had activity on a specific company ABC by doing a SQL query on the SY_ActivityLog table. When I do a query where CompanyCode = 'ABC', I get MOST of the users that have had activity on ABC…

I recently found a discrepancy in values between the quantities tab and the cost detail tab within Item inquiry on a few items. After researching in the Knowledge Base, I came across the following steps to clear out the issue: Update all transactions…