x Want to participate? Join the group to interact

  • Add a Custom UDF for Inventory Price Change

    Does anyone know if you can add a UDF field in Inventory Maintenance that shows the date of the last price change?

  • ROG - Answering Yes to "Do you want to receive the complete purchase order?" blanks out Item Code with UDFs

    I have 20+ UDFs in ROG entry and they have been working fine over the past 2 years. Now managers want some of these UDF to be required. When I mark just 1 or several or all of the UDFs in ROG as Required, no Item code appears when I select 'Yes' to "Do…

  • Can't figure out Event hook

    I have a script for Item Maintenance that is connecting to Item Warehouse, summing up QtyOnHand and then writing it to a UDF on the Main Panel. The script works when I can get it to run, but I am having trouble figuring out which Event I can associate…

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

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

  • Multiple table writes requires multiple Objects? (Audit Script)

    Hello, I am in the process of building a "Change Tracking" system for Sales orders which tracks any changes to a specified list of fields. To do this, on a Table Pre-Write script I simply gather the information from the So History record and compare…

  • Editing Paperless office printing output via Script

    Hello, I am having some issues with making a script to change the output setting for paperless office inside of sales order printing. I have some code below that I found searching the forum. The way it is now I do not get an error message and nothing…

*Community Hub is the new name for Sage City