Author Archives: Greytrix

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 »

GL Export utility

A General Ledger batch generated in Sage 300 ERP is group of many journal entries, each of the journal entry contains atleast two transaction details. One detail line is the debit amount and another is for the credit amount. These such entries and batches will not affect G/L account balances until we post the batches… 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 »