Sage 300

Hello, I am very new to development with Sage 300 and using the SDK -- in fact I have not started yet, but before I get started I would like to ask a question. First off, I need to clarify that I'm talking about a version of Sage 300 installed on a server…

I have a single user with an issue in a single company (all other users and all other companies for affected user are OK). The user opens the Vendor lookup and then users the search for a vendor - the subsequent search window with the expected list of…

Is that possible to add CS0120 data to accpac finder in COM API, after browse the sql statement. mDBLinkCmpRW.OpenView("CS0120", out csQry); sSQL = "Select Name, Description from MYDB.dbo.Table"; csQry.RecordClear(); csQry.Browse(sSQL, true); …

Hi, I need to do filtering using the "NOT IN" just like in SQL SERVER, but with Browse() function in ACCPAC library. I try using NOT IN with browse but got error, I guess its not supported. Is there other way to filter similar to "NOT IN"? Thank you.

I was recently asked if there was a way that one could change the default sorting method for the selection of documents in an A/R Receipt Entry. It defaults to "Order By: PO Number" however, it was requested that I change this to default to "Order By…

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

Hello, We have an internal app to read the Sage tables to display invoice and order related data. There are times that the query returns empty result. but after a while, it works fine. I wonder if it is normal Sage behavior? Is it because a Sage user…

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…