Browse By Tags

  • report error "invalid object name mscfld

    I am running a report and get report error "invalid object name mscfld. I have changed the report form to the system report, no change, and searched the code for the word invalid, none was there.
  • Script to print crystal report to designated printer

    Everything works on the script except for the line that calls for the print oRpt.Printout (I tried oRpt.Printout(FALSE) but then nothing happens at all) The line actually technically works, but instead of just printing the the default printer, the…
  • I need a report to show me any AR that was billed but not paid

    I need a report to show me any AR that was billed prior to 7-1-2017, but NOT paid as of 12/31/2018. Is there a report in TS that will give me this info? Or a combo of a couple reports that I can then put the info together in Excel? I use TS Premium …
  • AP Historical Aging

    Does anyone have an AP historical aging report they would be willing to share? Either in report designer or office connector. Thanks in advance, Amanda
  • Sage 2017c web screen printing

    We have Sage 300c installed and the Web Screens are accessible. However, none of the standard reports display on the web screen if accessing them from a workstation that doesn't have Sage workstation installed on it already. Is there a fix for this…
  • Crystal Report Invoice Report field with No data

    I did the following to the YSBONFAC Report. When I print the report, the report does not break. But it does not out put the lot number either. Any recommendation. The lot number is on the delivery.
  • Free Professional Invoices For Sage X3

    Tired of your current boring Invoice templates and wish you could spruce them up a little bit? Well, now you can. Download these crystal reports and make sure the last impression you leave is a lasting one. Download Now These set of templates have…
  • Custom report: G/L Account and Date Last Used?

    Is there a specific field and/or table to use within Crystal Reports to determine when a G/L account was last used? This would be for the purpose of delete the obsolete account. Please advise and thanks! T. Helm
  • Crystal Report: HELP! (Item Sales History report)

    To anyone out there who can help with this...I would be most grateful! Our boss needs a very specific Item Sales History report for Fiscal Year '2016' that should include the following as COLUMNS ( if possible ): Item Code, Item Description, Qty Sold…
  • Report for Expired Credit Card Authorizations on Sales Orders

    I've searched through various posts and cannot seem to find an answer to a simple, specific question. Hopefully, someone can provide some input. I have created a very simple Crystal report, using the SO_SalesOrderPayment table. I want the report to…
  • Crystal report datapipe connector fix from years ago does not work for Sage 300 2016

    Crystal report datapipe connector fix from years ago does not work for Sage 300 2016. Will Sage release another fix?
  • Business Insights Reporter Wizard Payroll Hang

    I am trying to create a new report through the reporter. When I give the report a name and choose where it will be in the reports it puts me to the next screen where I should select a template (Landscape, Portrait, Shipping Label.) At this point no matter…
  • Reports

    Good morning. I have two visas set up in my accounting and made some simple errors that i then fixed (ex: using wrong card for transaction). that has been fixed. But now when i print out my transactions by account report for each card... the wrong vendor…