Category Archives: Sage 300

Sage 300c 2020 PU2 release fixes issue related to Order Entry screen

It was a bug due to which, alert message getting appeared while searching the item related to the text typed into the Item Number / Miscellaneous Charge field in the detail line. Kindly refer screen below for your reference: New Stuff: Sage 300 view to read data using Advantage API in C# In order entry screen… Read More: Sage 300c 2020 PU2 release fixes issue related to Order… »

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: How to use CSQRY using COMAPI in C# »

Maintaining Images for IC Items – Ops Inquiry Feature

As the pictures are more descriptive than that of an appropriate name for a thing, same goes with inventory items also. Many company follows certain nomenclature or terminologies e.g. in Sage 300’s terms we use “Item Structure codes” to number the item so that this number itself will well describe the inventory item. But there… Read More: Maintaining Images for IC Items – Ops Inquiry Feature »

Project Job Costing – Project Style option in Contract Maintenance

As per industry practices, different organizations follow different procedures related to project costing. These procedures are based on certain rules and the types of project and contract norms. In this blog we are going to discuss about one of the option provided in Sage 300 by using which organization will be able to get the… Read More: Project Job Costing – Project Style option in Contract Maintenance »

Cannot access database (error=49153) in Sage 300 while accessing the Company

While trying to login to Sage 300 ERP application or accessing any Sage 300 Company, users may encounter an error such as “Cannot access database (error=49153). See Help for more information” New Stuff: – Project Job Costing – Project Style option in Contract Maintenance In this blog we are going to discuss about the solution… Read More: Cannot access database (error=49153) in Sage 300 while accessing the… »

Attempted to read or write protected memory

The use of Sage 300 Advantage API is increasing day by day and there is an ample requirement of the integrations, import, export that uses it. Developers are now making maximum use of Advantage API compared to COMAPI and XAPI for external programs. XAPI requires separate licenses so end user tries to avoid an additional… Read More: Attempted to read or write protected memory »

Provision to view Tax information from GL Journal Entries on GL Posting Journals Report

In our recent blog regarding Sage 300 v2020 PU2 release, we have demonstrated how to set the tax information on GL journal entry screen. In this blog we are going to discuss about the provision made to view tax information on G/L Posting Journals report. New stuff: Provision to view Tax information from GL Journal… Read More: Provision to view Tax information from GL Journal Entries on… »

Provision to view Tax information from GL Journal Entries on GL Batch Listing Report

In our recent blog regarding Sage 300 v2020 PU2 release we have discussed related to GL Integration with Tax Services. We have demonstrated how to install this feature and how to save the tax information. In this blog we are going to discuss about the provision made to view this information on G/L Batch List… Read More: Provision to view Tax information from GL Journal Entries on… »