• Users and User Authorizations Report

    Customer wants a report to be run from Sage which gives the following 5 columns . Currently they export users and they print user authorizations report and then mix and match data but since its a bank involved in Identity access management and they want…
  • 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…
  • SQL Expression to query Optional Field value from APIBDO Table

    Hello all, I'm trying to create a SQL expression to view the value from an optional field in the APIBDO table. The report being used is a GL Transaction Detail report with the following source container join: ((([GLPOST] INNER JOIN [GLAMF] ON [GLPOST…
  • 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…