• Crystal Report Feeding DM2 Returning Blank

    Hello, I am trying to write a crystal report formula that does the following: If an amended PO number exists in the UDF_AMENDED_PO field, then return UDF_AMENDED_PO, if not, return CustomerPONo When I test this, when UDF_PO_NO is NULL, it returns…
  • Order Total Showing up on Last 2 Pages of Purchase Order Form

    When printing a Purchase Order with multiple pages, it will print the order total (which is in page footer b) for the last 2 pages. It usually only happens when there is 1 line item or part of a line item on the second page. Right now under Suppress…
  • Creating Crystal Reports Interactive Dashboards for Sage 100

    I have several reports in Crystal 2016. Has anyone created interactive dashboards using crystal reports? The Business Insight Dashboard is canned and not really customizable. Sage Intelligence isn't all that friendly. Your still trapped in a little box…
  • VB/.Net (BOI syntax) to VBScript (UDS) syntax for calling Custom Report

    Hi everyone, I see many examples of processing a report in BOI, like this one . But all of them are VB/.NET or C#. Could someone please help me translate the syntax to UDS work with Events like Column_PostValidate? Below is Bret's example of Previewing…
  • 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…
  • Sizing Micr Font on AP check form

    Does anyone use Wells Fargo Bank for Sage 100 check printing. They require a specific font layout size and spacing that we are unable to get. If anyone has a check form for Wells Fargo I would love to get the crystal file. Any other suggestions on fitting…
  • 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…
  • RMA Report Including Open RMA & RMA receipt History

    Hi I was wondering if anyone can help me I need to create a report from all the RMA's that was entered for last Month ( for example) however mas 100 only gives you the option of open RMA report or RMA receipt History. what would be the easiest way for…
  • 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…
  • Company Information not using SYS_Company on PO Form

    I have created a new company in MAS 100 v4.4 I coppied all of the report files from our standard company to this new company. However when I look at the Purchase order form it is pulling information from a SYS_CompanyParameters table, which is not a…
  • move report in crystal to Sage100 as a report setting

    Looking for some guidance on this one...we have a custom report in Crystal that we use as a bill of lading. I would like to transfer this report into SAGE 100 into the Sales Order Module -Shipping - Packing List Printing - as one of the options under…