Sage 100

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.

is there a way to get a sum total of all the pieces ordered to calculate and print on the SO, Packing list or bill of lading. I am looking for the grand total of all the items. Having a grand total of the items shipped would also be helpful. Than…

I added a tab to my Invoice Data Entry panel with UDFs I want to be able to select an option in "SCAC Code" which will then display the proper name of the carrier outside of the SCAC Code dropdown. I want the SCAC Code and CARRIER NAME to be separate…

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…

Trying to install Crystal Reports 2011 on a Server 2016 with terminal services enabled. I have A: UAC disabled B: Changed user status to "install" and C: Disabled the antivirus. It appears to install and gets to the point of clicking on "Finish" at…

Sage 100 Advanced 2018 - Crystal 2016 - New payroll check alignment using Stub, Check Stub format - The "file", "page setup" allows the increase of the top margin without causing it to go to a second page (at least from my testing so far). I've been able…

I am looking to see if anyone has sucessfully integrated a signature capture pad, i.e a Topaz Model T-S460-HSB-R, into Sage 100 Sales Order. We are looking to get signature pads for our customers to sign before printing in Invoice Data Entry, that…

Hi all, I hope you are up for some puzzles, I've spent 2 hours and I'm now lost. The version is Sage 100 Advanced 2015, 5.20.1 We have a UDF in SO_InvoiceWrk. The purpose of it is to grab the invoice number to which a credit memo will apply and shows…

Does anyone know if there is a Crystal font available for a QR barcode? We are using Sage 100 v 2015 Thanks

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

We export a bunch of reports in CSV format using Crystal Reports. I just updated to Sage 100 2016 from MAS 200 4.4 and something weird is going on. When we try and export a report to CSV format on the Server/Remote Desktop, the Delimiter and Separator…

I won't go into great detail but I am not getting the training I need from my employer and joined here to find answers to questions that I should be able to find myself in a normal working environment. I would like to fix the alignment for check printing…

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…

Windows updates installed on 2/25/16 Server 2012 R2. Remote desktop sessions are used for our Sage 2015 version with Crystal 2011. User experienced crystal reports running extremely slow. When running these same reports from Crystal and not from Sage…

I recently upgrade from MAS200 4.4 to MAS200 2014. the version of Crystal reports for 4.4 will not work when creating custom reports in the NEW MAS200 2014. I need to install a full version of crystal reports 2011, it usually is on the MAS200 CD or…

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…

Template expert is grayed out. How can it be accessed to apply/change a template?

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…

We have a custom Crystal report that we run every morning that shows sales based on divisions. We can input a custom date / division / etc. I have recently discovered that the report shows sales that have not been invoiced yet. For instance, I can run…

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 a Crystal Report that is linking CI_Item, to IM_ItemWarehouse and also linking to IM_TransactionHistory all with Inner Joins. The criteria are the following: {IM_ItemWarehouse.WarehouseCode} = "003" and {IM_ItemTransactionHistory.TransactionDate…

I am wanting to make small changes to the Trial Balance Report and run it outside of Sage 100. I went into trial balance designer and "Save as" to make a copy of the crystal report however when I refresh the data it never prompts me for parameters and…

I have a parameter field link to the CI_Item for Value Field, I would like to have only the Type 1 item show up in the drom down, what is the best way to manage the parameter field in crystal reports? or can I do something like this?