x Want to participate? Join the group to interact

  • Sage 300 - Import items to populate quote

    I want to import items into an O/E quotation. I have attempted to export an existing "QTxxxxx" to use as a template, but I get an error message "Can't Append Table. Error: Too many fields defined." even when I limit the requested fields to those in…

  • Intermittent Dropping of Distribution Instructions

    We have created a Financial Statements SAGE Intelligence Report Template that has default Distribution Instructions attached to it. For one particular user, it seems that these Distribution Instructions intermittently do not load with the template for…

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

  • Re: Remove 0 in the report

    Hello All, My Financial Report that exported from system by using template include a lot of 0, the cells without any number. The template is wrote by myself. I was wondering if somebody can advise how to remove 0 and just show clean cell? I mean how…

  • in $000

    Hello Guys, i am designing a highlight report and need to use (in $000), anybody know how to create it ? Thanks in Advance, Frank

  • unable to export to excel

    Hi, I have ERP 2012 SP and I cannot export to Excel.When I do so I have this error message" Method not found: CrystalDecision.ReportAppServer.DataDefModel.Propertyflag..." Repaired Sage, Renamed BusinessObject folder and SAp folder and it was not…

  • Inserting a running total from a Formula field to OE Invoice report

    To all Sage300 Report and/or Crystal Report gurus: I have an item optional field that holds a number value that I need to use to compute a quantity for each line item for which I need a running total in the footer in the OE invoice report (OEINV01.rpt…

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

  • Not a valid Crystal Report

    After upgrading to Version 14.1, some of our systems will not print Crystal Reports. When attempting to print we get the following error message. We have attempted to perform the suggested Resolution on KB 55371 with no results. Anyone have any ideas…

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

  • Invoice Template - Reduce Unit Price decimals

    Hello, I am trying to reduce the number of decimal places shown in the Unit Price field on my invoice template generated in Crystal Reports (a custom made OEINV.rpt) The field is currently showing six decimal places on items related to labour (i.e…

  • Crystal Reports: Editing Decimal Places in Invoice Quantity Fields

    Hello, I am trying to reduce the number of decimal places shown in the Quantity ordered, quantity shipped, and quantity backordered fields on my invoice template generated in Crystal Reports (a custom made OEINV.rpt) Each field is currently showing…

  • SAGE 300 - HOW THE REPORT STORE CAN HELP YOU!

    Whether you are new at creating Reports, Templates, Macros, Dashboards, Financials, or someone with years of experience, the emphasis I’m sure you have is what is best for the customer, because that’s who’s paying your bills. That’s who calls you at the…

*Community Hub is the new name for Sage City