Tag Archives: Views

Error: DLL AccpacGD1003ENG.dll specified in section [GD1003] is not valid

As Sage 300 provides functionality to create a custom view, here in this blog we will be discussing about the error “DLL AccpacGD1003ENG.dll specified in section [GD1003] is not valid.” while making the uis/resource. New Stuff:  Bulk Invoice Consolidate feature in Sage 300c Web Version 2021 Below is the screenshot of the error that may… Read More: Error: DLL AccpacGD1003ENG.dll specified in section [GD1003] is not valid »

Setting Private and Public access to Custom queries in Sage 300c v2019 using Inquiries

In our previous blog, we have discussed regarding the process to create ‘Custom Queries’. Continuing the same topic in this blog, we will discuss the feature, which will allow user to set access rights for created custom queries using “Authentication Type” i.e. Public/ Private. New Stuff:- Payment Banking Format To Navigate the screen you can… Read More: Setting Private and Public access to Custom queries in Sage… »

How to Calculate Current Quantity on Hand on Custom Reports in Sage Accpac ERP

We all know that certain fields that are available in Accpac Views are calculated fields and not stored physically in SQL table. So sometimes when we want these fields on our reports we don’t get them as reports directly access the SQL tables and not the views, so we have to write our own calculations… Read More: How to Calculate Current Quantity on Hand on Custom Reports… »