• Custom Crystal Report - IC. Sage 300 2014 PU4

    I designed a report based on ICITEM,ICREORD and ICILOC that gives reorder quantities and some calculated columns for a parameterized input of location and item segment (from segment and to segment). These are dynamic parameters. The report DOES NOT…
  • Two invoices in a Crystal report to print on a legal size paper

    Hi, I am trying to design a report form that prints two copies of an invoice on the same legal size paper. Trying to use two sub reports. Not very successful. Any suggestions would be welcome. Thanks,
  • Reprinting Order Confirmation

    Dear All, I would like to reprint order confirmation with different completed status in OEORDH & OEORDD. So I edited the selection formula in crystal report (oeconf01) like that. ( ({OEORDH.COMPLETE} = 1 or {OEORDH.COMPLETE} = 2) or // order header is…
  • Sage dates in Crystal Reports

    I am doing pwFormatDate(ORDDATE) = CurrentDate -1 to obtain yesterdays date and then trying to filter on this date for yesterdays orders. But I need to convert this date back to a Sage date to do the filter. Is there a function that converts back to Sage…
  • Crystal Reports

    I picked a report from my clients Sage 300 2012 system and transferred it to my local machine for modifications. I have Sage 300 2014 and Crystal Reports 11. The report renders blank when I want to test it. Does anybody have an idea why this happens…