Browse By Tags

  • 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…
  • Credit Card Receipt Confirmation Report Customization

    Hi, We're running Sage 300 2022. We just got Paya installed and did our first Credit Card transaction. I'm still fairly new to the usage of Sage and Crystal Reports. How do I customize our receipt confirmation report to include Order Number or an Invoice…
  • User Defined Fields Data

    We use UDFs on our Invoices to populate fields with both product codes and lot numbers. If those items are already part of the products invoiced, all is good. If we have to manually enter product codes or lot numbers, we have a weird issue. I'll try to…
  • Business Insights List Query

    Hello! I am trying to find a way to automatically export sales order data (specifically ship date) from business insights sales order view into a locked excel document provided by my customer. It would be nice if i could filter a whole list of orders…
  • Crystal report Issue

    Created a custom crystal report for client with Date from and Date to and customer number as parameters in order for sending all invoices to a particular customer for a specific month or range of dates. The custom crystal report on the sage server…
  • Blended Billing-Flat Rate Task & Hourly Billing Task

    FormerMember
    FormerMember
    Trying to figure out how to invoice clients who have flat rate task and hourly task on one bill Example file application- flat $1400 report application as filed $18/ hrly can I invoice a flat rate task and an hourly task? Can I invoice a flat rate…
  • Pass user's default facility through Landing Page to linked report (x3v11)

    I've created a number of reports intended for Facility Managers to access through a link I made on their Landing Page. What I would like to do is pass their default facility through to the report to restrict the data they can retrieve to just that which…
  • 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…
  • Crystal reports inserting duplicate unwanted field - what am I doing wrong?

    I know there's still some fellow "old school" CR users here ... I am updating our check form - simply making a couple of minor alterations to PAYRLCHQ.rpt I want to replace 47/100 with 47 Cents The form has no 'Page Header' when I begin. I click somewhere…