• Invalid expression when in advanced logic filter

    I'm trying to create an advanced logic filter that will only capture a few specific customers. With the operand's available I've tried just about every way I can think of including all 20 of the companies. Does anyone have any examples for formatting…
  • Moving a BOM to History

    Is there a way to change an old REV of a BOM to history in order for the inactive REVs to not show on every inquiry? We have been using Sage for a long time and some of our BOMs are no longer active as we no longer build those items. We need to keep the…
  • 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…
  • Does SetBrowseIndex work without SetBrowseFilter?

    I would like to read through the lines of an invoice in ascending ItemCode order during a SO_InvoiceHeader Pre-Write script, but they seem to be unaffected by a SetBrowseFilter and appear in entry order. Any ideas? Here's my 5 line test case: sItemCode…
  • Question regarding Invoice Table relationships.

    Hello, I am trying to put together a report for tax purposes and am not confident I am pulling paid invoices correctly. My initial thought was that all invoices in the ar_invoicehistoryheader table were paid, but I was told that these invoices are…
  • Is there a way to pull data from a specific source code, like AP or AR?

    We are looking for a way to separate our YE AJE's. It was suggested to us to use a source code named AJ. We'd like to create a set of financials that shows the unadjusted trial balance, then the AJE's, and then the final balances. So, my question is…
  • Purchase History Button Purchase Order Entry

    Hi Guys I am trying to get a window to display on purchase order entry which will shows everything we purchased from the vendor in the past. On sales order you have the binoculars to do this but all you have on Purchase Order is Alias Item Lookup…