• Crystal Report 2011 install on Server 2016 terminal server

    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 Purchase Order customization to consolidate items after generating POs from SOs

    I need to be able to consolidate inventory items on the printed purchase order after generating multiple Purchase Orders from multiple Sales Orders. The system can consolidate the vendor POs automatically by selecting it in the PO setup options but it…
  • Inventory Explorer including lots

    I have a customer that has a very large number of items with lot numbers. Their products are lumber of various dimensions. 2 x 4 x 10 or 1 x 10 x 12 etc. We want to add a UDF or possibly an alias that will allow a lookup of a all "2 x 4"'s or all…
  • Creating a custom report incorporating Customer Maintenance and Item Maintenance info

    Hello, I am trying to create a custom report that would show customer details relating to items sold. I am looking to include: Customer Name and associated purchase history of a given item #, item description, standard cost, standard price,…
  • How to write User Defined Script to calculate Discount?

    I need to let the system to calculate a discount based on Sales Order Header - 4. Totals -Order Total. The formula will be 5% * Order Total . I need to create a UDF, UDF_DISCOUNT, under Sales Order Header - 4. Totals Tab to show this amount. I don…
  • RE: How to Add UDF to PO Detail Table from PO Header Table

    Thank you very much. It works. However, how to get value from different module? For example, I want to get value from PO header to add to open sales order table. Also, what are all abbreviation of different type of tables, such as header table, wrk…
  • Crystal Reports for Sage 100 2013 does not print the MICR font

    I just upgraded a client from 4.3 to 2013 and their AP Checks print correctly with the MICR font in 4.3, but the MICR font does not print in 2013. I checked the form to make sure the MICR font is selected (even tried the MICR Std font) and it won't print…