Browse By Tags

  • Can you add a url to products so the crystal reports will export hyperlinks to our website?

    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.
  • Getting total pieces ordered on a SO to print on the SO

    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…
  • Supressed Entries leave large blank spaces on Picking Sheets after Sage 2021 update

    Ever since we update to Sage 2021, the suppression in on our forms doesn't work correctly. It will leave large blank areas for al the supressed values. Supress blank sections is already selected in the group and details. It was working perfectly before…
  • AR Aging Report with Description in Crystal Reports

    Hi, I wanted to add "invoice transaction description" into it original report file ARTBAL.RPT using Crystal Reports. But there is no description field found from it existing table in this report. The field that I want to add is in table AROBL.DESCINVC…
  • Sage 100 Advanced 2018 - Crystal 2016 New Payroll Check Alignment - assistance needed

    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…
  • Print Crystal Parameters on Reports

    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…
  • QR Barcodes

    Does anyone know if there is a Crystal font available for a QR barcode? We are using Sage 100 v 2015 Thanks
  • OE Confirmation Crystal Report Line Number Issue

    Hello all, We have a custom crystal report for Order Entry order confirmations. We have been printing Line Numbers on the report by using the special field "Record Number". However, we can no longer use this because if someone inserts a comment and…
  • Crystal Reports Quotes Appear in Export

    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…
  • New to Sage 100, need to customize some defaults and to access Crystal Reports

    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…
  • Can I print multiple forms when printing invoices from sales order?

    I have setup paperless office and it is working great, thank you all for your help. Is there anyway to also send the other forms requested by certain customers with the invoices such as the C of C's, BOL's or Packers? I'm not sure if there is a way to…
  • Crystal 2011 report slow after Windows Update on Server 2012 R2

    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…
  • Cost Based invoice

    How do I invoice a contract that is time & material by line item - each line item will be linked to an extra and need each line to show the labor detail by cert. class detail.
  • Crystal Report 2011 - Need to install full version?

    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…
  • Customized AR invoice showing a zero balance

    I have a client who needs an AR invoice form that shows a zero balance if paid in full. It is a request of one of their large customers. Has anybody created this form or would be interested in doing the customization?
  • Crystal - template expert

    Template expert is grayed out. How can it be accessed to apply/change a template?
  • Custom Crystal Reports Sales Order Report

    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…