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.

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…

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…

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…

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.

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

Scheduled regular sage 100 rpts work well in task scheduler. Is there a documented way to schedule a custom crystal report. Posts I see are many years old so hoping there's an easier solution now. Have a involved rpt that takes a while to run while…

I need to create a sales order form for KnowledgeSync. I can't get the lines to print in the correct order. The standard sales order form created from the sales order work table has a "Group" that I'm assuming is what gets order lines to print as displayed…

I created a Sales Report in Crystal Reports 2016 that has 20 columns of Summary and then those 20 columns have sub-reports that I have linked to provide the Details by simply clicking on the hyper-link of the Sub_Report name. I added the Sales Report…

I seem to recall a Sage KB that indicated there were only 3 Join Types supported by Sage (MAS, back in the day). Inner Join, Left Outer and something else. I don't recall hearing about the "Enforced" setting. I ask because we have a client who are very…

I'd like to edit the Picking Sheet printing Crystal report to only print orders containing a specific item. So if it contains that item, it prints a picking sheet with that item and any additional items ordered. Does anyone have a formula for that?…

I've created a UDT with 2 fields, ItemNumber (The key) and Description (A multiline text field). I want to link the ItemNumber to the ItemBillNumber of a work order and display the Description on the Work Order Traveler. I've added the UDT table in…

Is there a way with Crystal Reports to string together 3 different sales order form codes to print at once? either for a single order of for multiple orders?

I am passing a value from a subreport to main report and in the main report this is the formula: WhilePrintingRecords; shared numbervar Cafe; Cafe If there is not a match between the main report and subreport, Then it prints the value from the previous…

Hello New to Sage. Creating a Job Cost report. I want to key the listing on JC_JobBillingHistory to pull all the open and closed records. Using JC_Job for Open and JC_JobBilling for Closed. I can't get both of the tables to link to key table. It will…

Would anyone have a label template for a shelf tag that can be used in a Zebra label printer, continuous? I would like to be able to modify a label that would print Item code, description, bin location and sell price. I am also willing to pay for any…

Currently A/P info on the Job Transaction Detail Report is showing Vendor number and invoice number. We would like it to show the Vendor name. In previous versions we had an extended solution that we purchased to accomplish this but they told us that…

** Support advised that we should post here too We have about 30 machines (only 5-10 use Sage 2019 concurrently) on our network and upgraded from MAS 200 v4.3 >> Sage 2017 >> Sage 2019. Select users are having an issue where launching PREVIEW of reports…

I have been trying to figure out the best way to get a report that would describe something like Item “Usage” by Customer. The trick with the report is that not only do we have to recognize items that are SOLD to specific customers, but we must contemplate…

I've been working with creating new income statement reports. I have 100+ departments and when I print out the income statement, each department is printing individually. I would like to have all 100+ departments print in one PDF?? is that possible?

Using Sage 100 Premium 2017 Using Crystal Reports 2011 I have six production SQL databases, all structured identically (for regional purposes). I have created a Crystal Report using a Connection based on OLEDB using one of the 6 databases. It uses…

I'm trying to modify the PO's to include the Vendor's item #, which I put on there as a formula field under a new Details section: if {PO_PurchaseOrderWrk.VendorNo} = {IM_ItemVendor.VendorNo} then {IM_ItemVendor.VendorAliasItemNo} As soon as I added…