• Received not Invoiced report?

    Is there a standard report that will show me POs received but for which an AP Vendor Invoice has not been entered into the system?
  • Print Error - Failed to load database information

    Any ideas how to fix? Partially fixed with backing down Crystal Reports to 32-bit after an upgrade to 64-bit got through, but still having problems.
  • Current Accounting Month

    Using MyAssistant, I am trying to create an excel doc that contains the "Current Month" in the top row. If I go into JC and select File > Company Settings > JC Settings, I can see in the Accounting Date section the Current Month is "September" (even though…
  • Sage300 PO Y/N optional field. Value not changing.

    Hey Everyone, I am new to Sage 300 and crystal reports but have a decent handle on both. We recently implemented a yes/no optional field for PO line details, everything tested fine for a few days but now it seems like the value remains as 1 no matter…
  • crystal report error

    Hello, I am using SAGE/ACCPAC on a local computer and trying to run a "A/R Aged Trial Balance Report" but I am getting the following error after clicking the print button. A window with the heading " Crystal REports Windows Forms Viewer" with the…
  • Custom Crystal Reports - Crystal Report Windows Form Viewer - Error : The remaining text does not appear to be part of formula. Details : errorKind

    Hi everyone, A customer change its PC - we have all programs ate server and we run workstation setup - and suddenly a custom crystal report we create from scratch doesn't work !!!! Error...."The remaining text doesn't not appear to be part of formula…
  • Problem in showing Arabic characters within the Reports Only

    Hi All We have Sage Line 500 Ver. 5.5 installed as xERP System for our company, and we have been requested to extract some reports for old data. I have created a new VMWare hosting Sage Line 500 Server and Client as well with MS SQL 2003. And since…
  • Report issue running a report from Sage 300 where the database is CRM

    Client is having an issue where a report inside of Sage 300 will not run. The screen below appears. The report was built using a DSN file. It worked before but this is a new workstation. Entering the password does not work and it complains the user…
  • Cost Code Report

    Does anyone know if there is a report I can run for the total amount paid per year for a specific cost code? I do not need it broken down by job. Just need a sum for all jobs combined for that year.
  • Need to update a crystal reports invoice with a specific field

    Hi - how do I find this in crystal reports to add it in: So, where do I find that "Item" in the field explorer in crystal reports so I can map it to the invoice Thanks! Dan
  • Limiting User Reports based on "Allowed" Locations

    We have multiple users across our branch network who can run different reports but I want to be able to limit their access based on "allowed" locations. For example, I want to limit a reorder report for a user so they can only run for their location and…
  • Credit Card Receipt Confirmation Report Customization

    Hi, We're running Sage 300 2022. We just got Paya installed and did our first Credit Card transaction. I'm still fairly new to the usage of Sage and Crystal Reports. How do I customize our receipt confirmation report to include Order Number or an Invoice…
  • PO Receipts blank when printed to preview (PORCP01.RPT ~ PORCP04.RPT)

    Using Sage 300 2014. After we post a PO Receipt, we select Print. All forms PORCP01.RPT, PORCP02.RPT, PORCP03.RPT, PORCP04.RPT just show an empty grey window in the SAP Crystal Reports preview.
  • Crystal Report Windows Forms Viewer. The remaining text does not appear to be part of the formula. Details. errorKind

    Hi, A customer has a custom report we create from scratch for AP transactions a long time ago. After they update workstations to Windows 10 in some of them that custom report doesn't work but in others its OK. So not sure what's the issue to fix. They…
  • sage 300 web screens and reporting

    Hi I would like some clear direction on where Sage 300 is headed for reporting for the Web screens. 1 GL Financial Reporter - Financial Reporter for Web UI - possibly on road map for August 22? Whereas previously this had been ruled out? 2 Sage…
  • Adding AR Invoice Number to E-mail Template

    Hi all, A client wants to add the A/R invoice number to the email template. I've tried to search from F1 Help -> E-mail Message Variables, but there's no such variables named AR Invoice Number. Does anyone has any idea? Thank you. Yours Faithfully…
  • ODBC Driver for Excel with xlsx files

    Using Sage 2021, seems the ODBC driver for excel only support .xls files. When attempting to connect to a .xlsx, get SqlState error S1000 that the table is not in the expected format Any way to use the driver with xlsx?
  • sales tax issue - Double counting items as two different classes

    2020 year's sales tax was easy. I just ran the tax tracking report for the relevant fiscal periods and sort by tax class, which for us is 1 for taxable items and 2 for non-taxable. But this year, the same report for both this year and last double counts…
  • Sage 300 Customers and Suppliers Daily Report With Opening Balances for any given date

    Good Day All, How can i get a report on Sage 300 Customers and Suppliers Daily Report With Opening Balances for any given date
  • Recommendation for ODBC consultant?

    Need recommendation for ODBC consultant.
  • Name of department and account group values of a department.

    I am new to Sage300 so i'll apologies in advance. I am trying 2 things to work on sage300 (2021). 1) I am trying to get department name on FR View dynamically. I have tried following but did not work for me. =IF(ISNA(IF(FR("ReportAs")="Separate",FRSDESC…
  • Custom Crystal Report not working in Sage 300 2019

    Have an Excel .xls spreadsheet with 4 columns of data Item, Description, Qty Sold and Date Sold. Also created a 2016 Crystal Report to generate a report sorted by item number. Works fine once run within the Crystal runtime where the report was created…
  • What is the syntax to add a budget column of a specific year?

    What is the syntax to add a budget colunm of a specific year? How to specify 2020 budget column to the report?
  • Selecting items with optional field

    Working on report that is selecting items with optional field value CS using ICILOC, ICITEM, ICITEMO tables. I tried several formulas including if{ICITEMO.OPTFIELD}<>"CASE" then "1" else "0" or if{ICITEMO.OPTFIELD}="CASE" then "1" else "0" and they all…
  • Using sub-report values in main-report

    I have sub-report: Shared stringvar O; if trim({ICITEMO.VALUE}) = "CS" then O := "B" Else O := " "; And formula in main- report: Shared stringvar O; O In main report I am trying to exclude all items with optional field value “B”. Sub- report…