Sage 100

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…

Is there a specific field and/or table to use within Crystal Reports to determine when a G/L account was last used? This would be for the purpose of delete the obsolete account. Please advise and thanks! T. Helm

Sage 2016 SP1 The Extended descriptions are fine. I need to write a crystal report that uses the Second line of the Extended description. I am trying to use the Split command and it works for spaces, but I have tried the chr(13)+chr(10) for line feed…

Just started with this error in December 2015. Users of both DC Reader and Acrobat Standard XI, Windows 7 ,Mas 4.2. Not sure if MS or Adobe update caused the issue. Any help is appreciated!

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…

So there is a feature that seems to be included in CR 2011 that was not available in CR XI. It appears that we now have the ability to change the XML Schema for exporting from Crystal. The problem is that I can't figure out how to utilize it. Before…

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…