• Using Crystal Reports to customize Ardinvo, how do I add database tables and fields from those tables?

    I'm customizing the Ardinvo report in crystal reports. I took a copy of the report, saved it as a different file name. Now I want to add some fields to it that are not in the set of data tables already in the report. In the "Field Explorer" I right…
  • 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 today…
  • 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…
  • 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 ?
  • 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…
  • Sage 300 2017.3. Crystal Reports 2011

    Hi, My report opens in Crystal but not in Sage - it tries to open, there is a quick glimpse (flashes on the screen) of it opening and then nothing. No error message. I tried creating reports from different tables - all with the same result. Any…
  • how to modify Crystal Sage 300 AP Ch advise to be similar to the 2 column 36 entryadvise from Sage 50.

    Client wants the cheque advise to have 2 columns on the cheque advise in Sage 300, as Sage 50 gave him 36 items on the remittance stub. (Just Doc # and Amount paid) How do i setup the sub report to do this? Sam