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…
  • Connect multiple UDFs so selecting one will display extra info to be used in Crystal Reports

    I added a tab to my Invoice Data Entry panel with UDFs I want to be able to select an option in "SCAC Code" which will then display the proper name of the carrier outside of the SCAC Code dropdown. I want the SCAC Code and CARRIER NAME to be separate…
  • SQL Expression to query Optional Field value from APIBDO Table

    Hello all, I'm trying to create a SQL expression to view the value from an optional field in the APIBDO table. The report being used is a GL Transaction Detail report with the following source container join: ((([GLPOST] INNER JOIN [GLAMF] ON [GLPOST…
  • You are a genius if you can answer this one. How do I add the prior retainer balance to a bill cover sheet?

    Sounds simple right? I dragged every possible database field over and none gives this balance. This number is available in a funds balance report so it doesn't make sense that I can't add it to a cover sheet. Here is what I want on my cover sheet …
  • Inventory Script for Sage 100 ERP 2015 Premium SQL

    Hi, I am trying to update a Script that worked in MAS 200 Version 4.5 (NON SQL). We've upgrade to Sage 100 ERP 2015 Premium (SQL) and now it does not work. Here is a copy of the script that worked when a button was clicked in Inventory Maintenance.…
  • Setting up a second company

    I have been using Timeslips for a couples of years for a law firm. Now one attorney is retiring and billing separately. I need to set up a separate billing for that attorney. Can I run 2 companies/law firms at the same time?
  • How To track Lost Sales?

    Would someone be able to tell how I would go about setting up a way to track lost sales? We are using Sage 100 Advanced ERP, Version 5.00.1.0...
  • Still Having VI Importing Issue

    Hello, I am still having an issue with imported product item numbers being skipped. I do not know what could be causing this as I have successfully imported 250,000+ items with the same number scenarios. Has anyone else had this issue and if so, how…