Sage 100

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…

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…

We'd like our quotes to display the product codes hyperlinked to their associated webpage on our website. Is there a way to do this with sage 100 and crystal reports? Seems like a very basic thing that should be doable.

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…

Hello Everyone, Looking for a little help on how to print the sales order line number on Packing Slips & Invoices. We are finding every time a partial order is shipped the line numbers are renumbered starting at one based on the remaining lines…

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, I'm looking to re-create a Crystal report so that it can be run by Knowledge Sync. I initially wanted to just use the report provided by SAGE, but it looks like I can't use this report as the information the SAGE report pulls is only generated…

I have reports that when I go into designer I see the ODBC connection and it not using the SOTAMAS90 ODBC connector, it has some other type of connection. I do not think it is correct and if someone can explain the connector and how to fix it I would…

I need to be able to review invoice line history for specific customers for a period in time(AR INIVOICEC HISTORY) Detail and Header). From that data I want to exclude specific items sold during specific date ranges(Sale items). Once I have gotten the…

I have written a report in Crystal utilizing dynamic parameters. When I run the report outside of Sage, it works fine and all of the parameters work as they should. If I add the report to Sage 100, the parameters no longer function properly. There is…

I have created a Custom General Ledger Detail By Source Report under the General Ledger Reports. I would like to print the parameters that have been selected on the Report but I do not see under special fields or under the database work table any fields…