Category Archives: Sage 300

Specify BOM numbers on details for shipments, credit notes, and debit notes in Sage 300C v2021 Cloud

Sage 300 ERP web screens functionalities are being improved with every new release. With the launch of Sage 300 ERP version 2021, new functionality is provided so the user can specify a BOM number in the Kit/BOM field of the details for shipments entry, credit note and debit note. New Stuff:- Ops Inquiry – Setup Options for… Read More »

Ops Inquiry – Setup Options for Inventory Item Image

In our latest blog we have discussed about maintaining image for inventory item using Ops inquiry, in this blog we are going to discuss about the necessary settings that needs to be done to maintain image using Ops inquiry. New Stuff: Implement modern UI in child forms – new theme when customizing Sage 300 ERP… Read More »

Implement modern UI in child forms – new theme when customizing Sage 300 ERP OCX

We have seen that with the release of Sage 300 ERP version 2018(6.5) new theme has been introduced similar to Windows 10 theme. When we customize any standard Sage 300 screen/OCX, we do not get the new look and feel provided by the Sage 300 ERP in v2018 and above. It’s best that our customers/users… Read More »

Sage 300 view to read data using COMAPI in VB6.0

The customer base of Sage 300 ERP is increasing day by day with huge volume of data. Sage 300 has some fields that are calculated during runtime and are not physically available in SQL tables. Accessing the runtime fields becomes very important for some customization or export routine, Sage 300 business view provides the accessibility… Read More »

Sage 300 view to read data using COMAPI in C#

The customer base of Sage 300 ERP is increasing day by day with huge volume of data. Sage 300 has some fields that are calculated during runtime and are not physically available in SQL tables. Accessing the runtime fields becomes very important for some customization or export routine, Sage 300 business view provides the accessibility… Read More »

Sage 300 view to read data using Advantage API in C#

The customer base of Sage 300 ERP is increasing day by day with huge volume of data. Sage 300 has some fields that are calculated during runtime and are not physically available in SQL tables. Accessing the runtime fields becomes very important for some customization or export routine, Sage 300 business view provides the accessibility… Read More »

Sage 300c 2020 PU2 released has fixed the issue related to Order Entry screen – Finder in the Item Number / Miscellaneous Charge field in the detail for web 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 »

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 »

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 »

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 »