x Want to participate? Join the group to interact

  • Positive Pay and Report Designer

    Hi, I wondered if I could tap in to sage city for some advice, as I am frustrated with support.na.sage The whole reason I am here, is that when I search the support site, I get to a issue, on the topic I want to learn about, and the article has a an…

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

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

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

  • Is there any way to show the Invoice #, Inv. Date, Check # and Check date on one row in a JC Commitment Item report?

    Trying to customize the "Commitment Cost Status with Full Detail report to show invoices and check numbers on one row, instead of listing in separate rows. Not sure if this can be done.

  • Sage Custom Report viewing via Asp.Net MVC Application

    My company is looking into the possibility of developing an ASP.Net MVC application to view custom reports that are designed & created by our users through Sage 300 ERP Suite. I believe there is the .Net library to integrate with Sage. Can we develop…

  • Wildcard in the first section of GL code

    Dear Friend, My company are using a several-section numbering for GL code and i would like to know how to wildcard the first part of GL code? For example, GL code, 100-02-03,101-02-04,102-02-05, 102-03-01 etc. if i like to use wildcard in the first…

  • Sage 300 2014 Intelligence Report getting an sa login failure

    Sage 300 2014 Intelligence Report getting an sa login failure when attempting to run a report with terminal server. Any ideas? Everything else appears to be working.

  • Adding an Inventory Custom Field to the picking ticket

    How do I add an Custom Field from an inventory item to the picking ticket? I actually want to a 10 custom fields the report

  • Invoices not showing discount date if no discount is available

    It there a way to not show the discount date and discount amount when the discount amount is zero?

  • ..\a4wdp.c

    Datapipe report runs well in Crystal Reports preview, but when placed on desktop this error is received "..\a4wdp.c line 372". Copied datapipe.ini file for ICSLOW and commented out stock report and entered my report name and parameter. Copied same…

  • OE custom invoice printing in a different Font-face than used in report

    We have just upgraded a client from Sage 300 5.6 to 6.2. We had customized the OE invoices on 5.6 to print in draft on pre-printed stationery using dot matrix printers (Epson LX-350, Epson FX-2190 and OKI ML280). After the upgrade, the forms still work…

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

    Hi, 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."…

  • Unposted Voucher and Debit Memo Report

    Hi, Recently, our company moved from Sage PFW to Sage 300. One of the reports that was available Sage PFW was "Unposted Voucher and Debit Memo Report". Is there a way to generate a similar report in Sage 300? if not, what are the main tables that I…

*Community Hub is the new name for Sage City