• How do I hide one or more Tabs on a panel?

    I am trying to hide tabs 3, 4, and 5 for Customer Maintenance for a specific user. I know I could set the fields on the tabs to hidden, but the user wants the entire tab to be unseen when looking at Customer Maintenance/Inquiry. I cannot delete the tabs…
  • Visual Integrator Import Sales Orders Referencing a Master Order

    I use VI to regularly import sales orders. In this case, I would like to reference an existing master order, as the only data that needs to change per order is the header comment. As I have several master orders to reference, it would be nice to populate…
  • Crystal Report Page Layout not previewing any width greater than 8.5"

    I created a Sales Report in Crystal Reports 2016 that has 20 columns of Summary and then those 20 columns have sub-reports that I have linked to provide the Details by simply clicking on the hyper-link of the Sub_Report name. I added the Sales Report…
  • Print to Tray 1 or 2 Based on Criteria in Order

    Hi, I found a thread about a somewhat related customization, but it wasn't quite similar enough and I wasn't able to learn enough to be able to use the information there. I'm trying to setup my sales orders to print to different trays based on criteria…
  • Can I combine data from SAGE 100 Job Cost's JobTransactionDetail table and data from Job Cost's JobHistory TransDetail table on the same Crystal Report?

    I would like to combine data from SAGE 100 Job Cost's JobTransactionDetail table and Job Cost's JobHistoryTransDetail table on the same Crystal Report. I need to create a summary report that includes data from both tables. I'm hoping that someone has…
  • How to add Quantity Ordered and Back Order to Additional Packing List

    Is there a way to add the Quantity Ordered and Back Ordered fields from either the SO_InvoiceDetail or SO_PackingListWrk tables to the SO_AdditionalPackingListWrk table? I've tried creating an UDF via CM under SO Additional Picking List Work, but I…
  • 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…
  • Generate PDF from UDF and create save/email functions from Sales Order/Invoice Data Entry custom tab

    Hello everyone, I created an extra tab in Sales Order/Invoice Data Entry and I have a few questions: Most importantly, how can I use the data that's selected and inputted here to generate a PDF or other type of document? Each of these fields is built…
  • Need help deciphering Activity Log

    Hello, We went live with a new project yesterday and are having some issues. I spoke with support, but because we have so many modifications they said they were unable to help. I found the two below entries in the activity log that I believe may be…
  • Does this default setting delete temp. customers upon period end? AR Options "Retain Temporary Customers with Paid Invoices" (Sage 100 2017)

    Good day, Could someone please verify: There is a setting, a check box, in Accounts Receivable Options called "Retain Temporary Customers with Paid Invoices" (please see attached image) Question: From what I see, the default value is unchecked.…
  • Add a Spell Check to Extended Description, Memo's, Notes, UDF and other Text Box Fields - PLEASE VOTE!

    It would be great to have a Spell Check to find common spelling errors in Sage 100! This would eliminate embarrassing misspelling on invoices and other documents that go to customers and/or vendors. • Have the ability to turn the Spell Check on/off in…
  • Using General Ledger Exchange

    I have gone through the set up wizard for the General Ledger Exchange to import a journal entry from a CSV vile and got all of the way through to the GL Exchange window to import the file. When I click on the Proceed file I get an error that says, "Source…