Category Archives: Sage 300

Create new Items by copying existing items in Sage Accpac ERP

Few industries need creation on multiple items that use same set of information, this need to be done because there is slight variation in inventory that one needs to record and report separately. Few examples are (Apparel/footwear/Electronics /Furniture industries etc..). Though we have a GreymatriX (Apparel Integration for Sage Accpac ERP) Add-on as a solution… Read More: Create new Items by copying existing items in Sage Accpac… »

Adding columns to the detail grid of Transaction Screens in Sage 300

You must be wondering why one has to write a blog on this topic specifically when Sage has a powerful and easy to use Optional field’s module which not only captures custom information on Maintenance and Transaction Screen but also Tracks the information from Originating document through GL and not to forget the capability of… Read More: Adding columns to the detail grid of Transaction Screens in… »

Can’t Load DB on selecting different collation than Latin 1 General, due to duplicate UOM defined per Items

While browsing through the Accpac Forum today, we came across an interesting post regarding ACCPAC Collation Method. We had faced the same problem in our development projects and we are sure one of you must have too, so this blog. If you are trying to do a DbLoad from a Data Dump that used collation… Read More: Can’t Load DB on selecting different collation than Latin 1… »

How to programmatically get List of Companies from the Accpac system

Almost every integration that we do between Sage Accpac ERP and 3rd Party Product, on our setup screen we have to display the list of all Accpac companies so that our connector knows which Accpac companies data is getting integrated with the 3rd party Product. If you are also writing something like this and need… Read More: How to programmatically get List of Companies from the Accpac… »

Use SQL Queries through Accpac view

There are few situations that almost every Accpac Developers face while working with Accpac Views, like… PERFORMANCE, when you have to browse/read a filtered piece of information from an Accpac table/view that has a huge size of Data, yes! Accpac certainly allows us to filter the Data on the fields that are exposed by the… Read More: Use SQL Queries through Accpac view »

Tips and Tricks on Sage ACCPAC ERP's Views: 2. How to get data immediately displayed on the screen when updated in the views?

PROBLEM:I have a view which updates some set of fields in the process method but I need to display this updated data on my Screen instantly, but could find out the way out.SOLUTION:There is property “INSTANTVIEWUPDATE” in the datasource, which refreshes the datasource every time when any update is done. Below is the snippet of… Read More: Tips and Tricks on Sage ACCPAC ERP's Views: 2. How… »