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…

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

  • Contract Billing Report Customization in Crystal

    I need to make a minor change to the L-PB Detail with Stored contract invoice format.  The CNAME in TS Billing Field Names is giving our group name instead of the Company name.  We have 5 companies and I need it to give the correct Company name based on…

  • Issue with Crystal reports prompting for SQL sa password.

    We are migrating Sage to a new server. When I move over the custom crystal forms, some of them are prompting for a sa password before running. I have checked all my database connections. There is one difference between the two database connections - when…

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

  • HELP! I have no idea how to build a report in Crystal and utilize it in Sage

    I am a complete newbie to Crystal Reporting and have watched several tutorials, but they are all for stand alone spreadsheets. I have no clue how to use information within Sage to create a custom Crystal report and how to connect the two of them.

  • Automatically run Crystal Report & email. Sage 300 2018.1 on Windows Server 2012 R2

    Hi,

    The requirement is to to be able to run the Crystal Report on a preset day and email it out - without manual intervention. The report is not parameterized. I have hard coded the dates.

    Is this possible using Windows Task Scheduler or is there an…

  • Reprinting Order Confirmation

    Dear All,
    I would like to reprint order confirmation with different completed status in OEORDH & OEORDD.
    So I edited the selection formula in crystal report (oeconf01) like that.

        (
          ({OEORDH.COMPLETE} = 1 or {OEORDH.COMPLETE} = 2) or
       // order header…

  • Bin/Shelf labels

    Greetings,

    I created a custom label report in Crystal using the Mailing Label and Report Wizard and it works well in Crystal. I saved it and am trying to open it from within Sage 300 2014 PU3 and I am getting the Error:LoadLibrary message.

    Has anyone…

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

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

  • Report print Macros

    i have the below Exception please any help ????