• A/R Receipt Batch List -> Default Ordering

    I was recently asked if there was a way that one could change the default sorting method for the selection of documents in an A/R Receipt Entry. It defaults to "Order By: PO Number" however, it was requested that I change this to default to "Order By…
  • Custom Crystal 11 Parameters

    We have a number of Custom reports that require some user paramaters to be inputted for selection criteria. these reports was originaly written in crystal 8 and accpac 5.4 over the years the reports has been updated without an issue and even the change…
  • Custom report

    Customer is running Sage 300 2014, Update 2. They also use GIMS. We customized a GIMS report for them a while back and it worked fine for all users until the upgrade. Part of the customization is that we added a criteria for Style - and Style is defined…
  • 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…