Sage 100

We have just upgraded to Sage 2023 Premium, the SQL version. We use a remote database to store metadata about our items. When we were on an older version of MAS 90, we copied the table data from the remote server to a SQL server on our LAN. And we…

How come when I add SY_State to get the state name it duplicates the InvoiceNo from AR_InvoicehistoryHeader. The only field I use is StateName from SY_State. And when I add AR_InvoiceHistoryDetail it freezes the report around 23,000 records.

I thought I read a post about this, but now I cannot locate one. When we have Vendors with SSNs, like in this ABC Vendor below, we expect the First Name and Last Name fields to be filled out, but they are not: Of course we get this message, which…

First time in 12 years that the report I maintain is getting an error. Failed to retrieve data from the database. Details: s0000:[ProvideX][ODBC Driver][PVKIO]Data page header contains invalid record offset information. [Database Vendor Code: 109…

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…

There are 2 buttons designated to printing the pick list and also the work ticket. When clicking on the Pick List print button it allows us to print the pick list with no issues. However, when trying to print the Work Ticket we are met with an error …

Hi all, We do most of our customer reports based off the GL_DetailPostings table. I have a few reports filtered to only show "SO" module transactions and I pull in some additional data from the InvoiceHistoryHeader table but now am being asked to…

Hi, My client wants to filter the transaction date range within a specific statement date on AR Statement Printing Report. I tried to filter the date range using 'select expert' which set the between from to transaction parameter. If I press F5…

Hello I'm upgrading from 2018 Advance to 2022 Premium. When on the server we can run canned reports within Sage 2022 without error. When we try and run reports from a client 2022 workstation we get "The database login failed. Error in File GL_ChartofAccountxxx…

Hello everyone, My company has been having an issue with a Sage 100 & StarShip interaction. Basically, when shipping items, the associated Sage documents are not printing. I've doubled checked multiple times to ensure the Form Code is correct and no…

Have a client that upgraded from Sage 100 2019 to Sage 100c Advanced 2023 PU1. They run several reports outside of Sage using Crystal Reports Writer version 2020. They can run these reports with no issues some of the time, but then later in the afternoon…

current work ticket printing includes header for each step. would like all the steps under one header. attach files?

Hi There, Is there a way to run a batch file to change all items entered into inventory with a none reorder method to reorderpoint? Thanks in advance, \\shane\

Has anyone had success in exporting a report from Crystal to Excel - Data Only format and have Excel format columns with string values as 'TEXT' and not 'GENERAL'? I can't seem to come up with a way to do this in Crystal. Thought I would check here before…

I would like to print the Report Selections Date Range in the Report Header.

Hi, Any way I can get the user ID / Logon name to print at the bottom of a work ticket? All i am able to find are fields for the user that created or updated the work ticket, but not the user who actively printed it. Thanks, Ryan

Trying not to duplicate a question that has already been asked. I have a crystal report that can be run from Sage and interactively that does not use any work tables, but when attempting to run it from a KnowledeSync report in 10.5 version I get a Database…

I am adding the Creator (2 or 3 initials of our team) of a Sales Order/Work Ticket on the WIP Report. It only comes up on part of the Work Tickets listed. I have tried to compare of what has hours applied, what has parts, etc. Is there utility I should…

I created a sales history report in Business Insights Report Wizard using Invoice History. Objective is a total invoice amount including invoice number, customer number, customer name, invoice date, transaction date. However, the report repeats invoice…

OK. My lack of knowledge is really going to show here. For reference, we use Sage 100 2019 Manufacturing . I have a highly customized Picking Ticket created in Crystal Reports. We are a manufacturer, and when a customer orders from us, the Picking Ticket…

Created a report comparing Revised Estimated Cost to Actual Cost. The "sum" of the Revised Estimated Cost is giving me problems. When I try to "Sum" that field, it totals by the number of times the cost code is used...therefore the "sum" becomes overstated…

What formula would be used in QuantityDecimal to set the number of decimals to 2? We need 4 decimals for qty for BOMS only, so would like all forms to only display 2 decimals. Thanks.

Hi, Hoping someone knows how to get the details sections of a crystal report to not repeat the same values as I can not have step instructions and signoff information repeat I moved things around in the PM WT Traveler report that came with the install…

Hello Everyone, Our CS dept have been reporting to use that they are receiving a popup message in SAGE when try to print a pick sheet from the Sales Order module. Please see below. I can't figure out what could be causing this. I have checked permissions…

Getting database connection error on all custom payroll rpts after upgrade to 2021. Other custom rpts fine.