• CS0120 data to accpac finder in COM API

    Is that possible to add CS0120 data to accpac finder in COM API, after browse the sql statement. mDBLinkCmpRW.OpenView("CS0120", out csQry); sSQL = "Select Name, Description from MYDB.dbo.Table"; csQry.RecordClear(); csQry.Browse(sSQL, true); …
  • 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 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…
  • 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…