Browse By Tags

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

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

    Footer A for Standing Billing
    Footer B for Tenant Billing

    Below is the formula from the existing sage invoice…

  • modify original

    HI I new in the Crystal report area and I would like to modify some standard reports that came out the box and when I do this, as soon I run the parameters input change complete, How I can maintain the same format.   for example: 
    this is the original report…

  • TsRange and SQL based reporting with Crystal reports

    Is there an alternate method to get the same functionality as TsRange when using Crystal reports against the SQL replicator? I was thinking I could use a from-to command but not exactly sure of the syntax.

  • Forms alignment out after upgrading to from Sage 300 2012 to 2018

    Before upgrade: Sage 300 v.2012; 2 pc with 2 printer (same model), User share the same OE invoice & cn/dn Pre-printed forms on dot matrix, no problem with alignment..

    After upgrade to V.2018 – Alignment is wrong for both pc. I changed the alignment…

  • Customer & Supplier Transactions Reports

    Hi Sage family

    I have done some simple customization and format in the existing Sage 300 Reports of Vendor Transactions Report (apvtrn01) and Customer Transactions Report (arvtrn01) and it works well.

    But I have an important information that i also need…

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

  • SQL Password Prompts in -some- custom reports and intermittently Sage Inteligence

    Hi Everyone,

    Our company has ~20 custom reports setup in Sage 300 as well as a handful of Sage Inteligence reports created by our finance team. Recently, 2 of the custom reports have started prompting for SQL login credentials at the same time Sage BI …

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

  • Can I add the user name who is printing the form on the form?


    Can I add the user name who is printing the form on the form?

    Thank you!

  • Error message when trying to edit Sage 300 Certified Payroll report

    I am using Crystal Reports 2008 to edit the Sage 300 Certified Payroll report (UP71A/ENG/upcprj1.rpt).  When I open the file in Crystal, it first gives the error message, "The saved data will be discarded since one or more formulas failed to compile."…