Category Archives: Sage 300

How to use CSQRY using .NetAPI in C#

CSQRY CSQRY is the View CS0120. It basically takes 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 use an alternate… Read More »

Validate Sage 300 user Credentials

In this blog, we are to see how we can validate the Sage user credentials applied for login into the Sage 300 using Advantage API without creating session. This would be a useful thing for the purpose of the organizational security purpose. Below are the steps which will guide through how we can check the… Read More »

Payment applied against credit note in Sage 50 is migrated as Debit Note in migration process

GUMU™ for Sage 100 ERP to Sage 300 ERP is a Sage certified Migration solution. Greytrix is a pioneer in providing migration services at its Sage Migration Centre and catering end-users business requirements. Data migration is always a challenging task to perform. We migrate data with the help of our Sage certified migration utility in accordance to our… Read More »

Sage 300c Web Screen Supported Regional Language

Sage 300 web screens support multiple regional languages. It is utilizing the resource files (Resx files) to maintain localize setting like strings, text, captions, messages etc. These resource files (Resx files) are supported by Microsoft’s Resource manager class which is present in the Sage 300 web screen. New Stuff:- Sage 300C Grid filtration for Transaction… Read More »

Sage 300C Grid filtration for Transaction Screens

There was a very unique but interesting requirement from one of our clients. The requirement was to provide filter on Item description column on the detail level order entry grid to modify only those records which are getting matched with item description filter. Once we remove the filter, all the records should be display into… Read More »