Browse By Tags

  • Filter by comparing 2 columns value error

    Hi all, I have this SQL query where I have a whereclause l.LineQuantity>six.TriggerQty select c.CustomerAccountNumber, c.CustomerAccountName, h.DocumentNo, si.Code as ItemCode, si.[Name] as ItemName, pg.Code as ProductGroupCode, six.TriggerQty…
  • Link Sync Date Filters on Dashboard. Filter at Dashboard Header

    When multiple tiles exist on any dashboard, each tile is generally related to the others by way of being Cutomer, Vendor, Inventory etc. However, each tile still operates separately from the others while the user is likely to be looking at the same…
  • Webinar - Filters and search - Recording now available

    In this webinar we looked at how to use the filter and search options to help you analyse your data. This webinar has now taken place but a recording is available. Open the webinar recordings article Sage 50 Accounts - Filter and Search - 202211 …
  • Filtering in Mobile v7 coding

    Hi all, I'm trying to use the "AQUERY_CRITERIA_AFTER" event, in a mobile representation. My only problem here is that the property "THIS" is not available, and because of that i can't use values from the main screen. Do you know how can i solve…