Tag Archives: accpac views

HOW TO APPLY FILTER ON VIEWS IN SAGE 300 .NET API

Sage 300 ERP web screens functionalities are being improved with every new release. Sage300c provides various ways to read records of ACCPAC views by opening and composing the business views in .net API. Sometimes we need to set filter on view records for that purpose Sage300c .net API provides us view’s ‘browse’ method. New Stuff:-… Read More »

How to use CSQRY using COMAPI in C#

CSQRY is the standard Sage 300 View CS0120. It basically takes the SQL Query as the parameter to its Browse method and then returns the records via calls to Fetch. CSQRY is easy to execute general SQL statements through the Sage 300 API. This way we don’t need additional database credentials and don’t need to… Read More »

Use SQL Queries through Accpac view

There are few situations that almost every Accpac Developers face while working with Accpac Views, like… PERFORMANCE, when you have to browse/read a filtered piece of information from an Accpac table/view that has a huge size of Data, yes! Accpac certainly allows us to filter the Data on the fields that are exposed by the… Read More »