Browse By Tags

  • 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…

  • 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…

  • Did you know that we have a library of reports that were not originally included with Sage BusinessWorks?

    Reports have been customized by Sage Customer Support Analysts and available to download and import into your software.  There is a list of available reports in our Customized User Reports Library. This article has links for our customized reports for General…

  • AP Payment History Report with GL Account

    Our customer wants to see the GL Account(s) and the respective dollar(s) for the invoices that appear on the Payment History Report and also to have the report sort by GL account. I haven't had great success using the AP_TransactionPaymentHistory and…

  • Crystal Report Page Layout not previewing any width greater than 8.5"

    I created a Sales Report in Crystal Reports 2016 that has 20 columns of Summary and then those 20 columns have sub-reports that I have linked to provide the Details by simply clicking on the hyper-link of the Sub_Report name.  I added the Sales Report…

  • Table for "Promoted to Order On", VI and Making Excel Reports

    I am trying to make an excel sheet (ideally a custom report), which shows the amount we invoiced every day, and the amount that was promoted from quote to sales order every day. Grouped bar graphs is what I'm trying to achieve. 

    I figure the easiest…

  • Is an "Enforced Both Inner Join" type supported by the SOTAMAS90 ODBC DSN?

    I seem to recall a Sage KB that indicated there were only 3 Join Types supported by Sage (MAS, back in the day). Inner Join, Left Outer and something else. I don't recall hearing about the "Enforced" setting. I ask because we have a client who are very…

  • Custom Crystal Report gives incorrect entries for Invoice Credits

    Hi,

    I'm using SAGE 300 Premium (Version 2018) and SAP Crystal Reports 2013. I'm working on a Crystal report and using the following table linkings:

     OEAUDH linking to OEINVH (Linking field- ORDNUMBER, Join- Inner Join)

     OEAUDH linking to OECRDH…

  • custom report for web screens

    Hi, we have a customized order confirmation form. i added to the webscreens reports. it prints fine but the parameter prompt does not allow you to search or select options such as check delivery method.  values must be entered. any help resolving this would…

  • GL Transaction Listing Table Details

    GL Transaction Listing Report looks like a dll type report. Can someone tell me from which tables it takes the data, we require this to make  our own customized report. 

  • No currency format in Maintain O/E forms

    Under the Order Entry Module I was redesigning a sales order to use for a commercial invoice.

    After creating a db calculation it would only display the number with no decimal places unless there happened to be cents in the calculated answer.  I wanted…

  • Reporting upgrades made to newer version of Business works

    My company is currently running BW 2013.  We are upgrading our operating systems and a number of other customer databases that we use and we want to do the same with business works. Our biggest issue with the current version is its inability to drill down…

  • Report Designer - custom date formula

    Hi there,

    This is my first post in Sage 300 online Community, woohoo. I find myself in uncharted waters.

    I am putting together a custom date formula, where the date has DDD field, which means 3 digits for "day in year".

    Example would be that…

  • Previous Year's Employee Hours Missing

    Hello, I've been working on a custom export where I need a list of employees that have worked over 500 hours for 2019. While testing, I run the report in my current year company and everything is great. I go back to my 2019 company file to run the custom…

  • Formula to Suppress the footer option

    I have modified the original invoice footer with 2 format options by parameter field on Bill Type for user to select the format when printing.

    Example 
    Footer A for Standing Billing
    Footer B for Tenant Billing

    Below is the formula from the existing sage invoice…

  • Sage 300 with SSRS

    Hi All,

    I was trying to print the SSRS report from sage. If anyone have tried this please help me with this.

  • AR Aging Report with Description in Crystal Reports

    Hi,

    I wanted to add "invoice transaction description" into it original report file ARTBAL.RPT using Crystal Reports.

    But there is no description field found from it existing table in this report.

    The field that I want to add is in table AROBL…

  • I will build custom report AR aging with addtional descripstion and project in crystal report. what table will be used ?

    [sage300erp 2018]

    I will build custom report AR aging with addtional  descripstion and project in crystal report. what table will be used ? 

  • Custom Reporting 13-3 Screen Help

    I am a novice when it comes to custom report programming.  I hope that someone can help me with a formula in the custom report 13-3 screen in Sage 100.  This is the only tool we have to do the custom reports.  I want to combine the original budget from table…

  • Crystal Reports that output to Printboss

    I took over a client who created a number of crystal reports that output to printboss. Very nice, but they do something strange with the crystal variable that evaluates to the trigger string

     

    'PB#INFO '+Chr (247)+{@PrintBossForm}+Chr (247)+', '+…

  • Custom Report Printing

    Apologies if this is not the correct category.  From time to time we receive the following error when attempting to do custom report printing.  The temp file is there.  The only fix seems to be rebooting the server and deleting the file.  Sage 100 will then…

  • Reporting for the CARES Act (H.R. 748) Paycheck Protection Plan

    The Paycheck Protection Plan from the CARES Act authorizes up to $349 billion in forgivable loans to small businesses to pay their employees during the COVID-19 crisis. All loan terms will be the same for everyone. For additional information, including…
  • Creating Custom ASP Reports in Sage CRM.

    The image below shows that I have just run a custom ASP report called 'TestReport' from within the general category. The report has popped up and has displayed the graph and the panel I wanted.

    There are 2 main things to be aware of when creating…

  • How to change the lower case to upper case in headers in custom reports.

    Hi all,

    We created a custom report using views.We used alias names in the view as"Quantity" ,but the alias name displayed in the report is apperaring to be all small letters "quantity".Is there any way to change the starting letter to upper case.…

  • Did you know that we have a library of reports that were not originally included with Sage BusinessWorks?

    Reports have been customized by Sage Customer Support Analysts and available to download and import into your software.  If you visit our Sage KnowledgeBase article 74699 Customized User Reports Library it will show a listing of the reports that are available…