Inventory Reconciliation of Sage ACCPAC ERP

Do you know that inspite of Physical Inventory stock equals with the Count in Inventory module, the GL value of Inventory does not match with Inventory Movement Report Value? The answer is “Yes it is true” and the common reason it can happen provided someone has posted entries directly through GL. There is another reason… Read More »

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 »

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 »

Flexible Purchase Order (PO) Invoicing Options in Sage ACCPAC ERP

There are times when vendor doesn’t follow standard invoicing procedures which becomes very difficult for your Account Payable department to handle accounting entries. You might have heard and taken care of single Purchase Receipts against multiple Purchase order and 1 single PO invoice against multiple PO receipts. What do you do when the vendor gives… Read More »

Combine Multiple Purchase Orders into One in Sage 300 (formerly Sage Accpac)

Often people ask for functionality where they can combine multiple PO’s into one so that they can maintain a single document for all open Items against a particular vendor and have single PO Receipt, plus sometimes enjoy reduced Freight obligations. Considering the need for this feature we have introduced a very simple and easy to… Read More »

Sage ACCPAC ERP for Apparel Industry (Apparel, Shoes and Accesories) integrated with Excise feature.

Greytrix launched a complete 360 degree solution for the Retail Industry comprising of Sage ACCPAC ERP with Greytrix add-on GreyMatrix along with seamlessly integrated Tally Shopper POS. Read More Greytrix extends the functionality of the solution by integrating one more Greytrix- Add on , Excise Module (Manufacturing Excise Module for Sage ACCPAC ERP). Now retail… Read More »

Location Wise I/C Item Details

Using I/C Location Details in Sage Accpac we are able to view list of locations in which a particular Item is stocked and other details (like Quantity on Hand, On SO, On PO, Standard Cost, Most Recent Cost, Average Cost etc…) of that item for each locations in Grid List. Vice-a-versa what if someone wants… Read More »