x Want to participate? Join the group to interact

  • How to do data filtering in macro VBA?

    Hi all, how do I do data filtering in macro? Lets say I want to filter by invoice number in OE0520

  • Sage 300 Web Screen Inquiry

    Hi, In older version I remember there is a possibility for us to custom and add more inquiry into the web screen. Now in 2019 is this features is still available? That we can add more data to be part of the standard Inquiry which is available. If yes…

  • CS0120 - reusing the view.

    Up until now I've been setting my CS0120 variable to Nothing and then opening it up again like this: Dim qry as AccpacComapi.AccpacView DBLink.OpenView "CS0120", qry qry.browse "UPDATE sometable ... blah" set qry = nothing DBLink.OpenView "CS0120…

  • CS0120 gotcha (well, it got me anyway)

    I just discovered that CS0120 has a limitation on the length of a given field name. In my query I had two formulas and I gave them friendly names: select idcust, (select xxxxxxxx) as CurrentPaymentNumber, (select yyyyyyy) as Current PaymentDate from…

*Community Hub is the new name for Sage City