• Linked UDF Description Field

    How would I go about adding a description field that displays the corresponding description record for a UDF? Does this require scripting or can these be linked in Custom office? I dont want someone to be able to select available descriptions from the…
  • How to obtain Quantity of Items Sold and Issued with Custom Date Range

    I am trying to export a report, by vendor (or product line), of the quantity of items sold AND issued for the last 12 months. We would like to be able to export it using any custom date range that we want. What is the best way of getting this data? I…
  • 2016 - 2020 First oScript.SetError Method doesn't trigger an error message in Lot/Serial Number Distribution

    This UDS is a Column Pre-Validate on QuantityShipped against the SO Sales Order Tier Distribution table at version 2016 Std through 2020 Advanced. The SetError doesn't always trigger the error message, but it does fail (i.e. clear) the distribution number…
  • How to get Child or sub file (table) level data from Sage VB Script

    Hi All, I need to display a message box on Shipping Data Entry interface. I can get data from "SO Sales Order Header" and "SO Shipping Data Entry" and "Customer....". On Custom Office using trigger of " "SO Shipping Data Entry" " and Pre-Write. …
  • Remove "Delete Customizer Modifications" for assigned panels?

    Hello, We are trying to set up our customer maintenance screen to look identical to customer inquiry, except for one tab so that a certain department can access just that one tab. To do this, I am creating a custom panel which locks all fields except…
  • Visual Process Flow: Open file instead of download.

    Hello, I'm curious if it is possible to have a visual process flow button simply open a file instead of download it? I have a button set up linked to an excel document and another linked to a crystal report, but clicking these buttons causes an internet…
  • Button Script to open Sales Order UI with parameter.

    Hello, I have been struggling to get this to work for quite some time and am starting to go crazy! I have created a button on the Invoice History Inquiry which opens up the Sales Order UI, but I want to pass through a parameter so that the Sales Order…
  • Customer Specific Lookup in Sales Order/Sales Order Invoice Data Entry

    I am stuck and I think the following cannot be done so consider it a challenge to everyone to see if someone can come up with an answer that is not crazy complex. I have an end user that would like to track who picks up Sales Orders...picture a field…