Tag Archives: Sage Accpac ERP

Table Does Not Exist Error while importing data into Sage 300 ERP

While importing data into Sage 300 ERP using excel sheet file format you might encounter an error saying “Table/Records does not exist. Please specify an existing table.”   In this blog we will discover why this error occurs and steps to correct this error. Let’s take an example of importing customer records using excel file format.… Read More »

Integration of Infrasys POS with Sage 300 ERP

In our previous blog we explained how a typical POS-Sage 300 ERP integration works. https://www.greytrix.com/blogs/sageaccpacerp/2013/09/25/pos-sage-300-erp-integration/ https://www.greytrix.com/blogs/sageaccpacerp/2013/09/25/data-integration-utility-for-sage-300-erp/ Now we started getting calls on different POS available in the market with its integration with Sage 300 ERP; One of the most common inquiries being Infrasys. In the current blog, we have tried listing all the different features… Read More »

POS Sage 300 ERP Integration

In an organization, more than one software application often exists to support a particular aspect of operational requirements. The result is a heterogeneous set of software applications requiring data sharing and integration. An ERP system like Sage 300 ERP tries to solve this problem by offering one solution for every operational requirement. Sage 300 ERP maintains… Read More »

CRM for Starters in Sage 300 ERP

Is your business partially based on services you cater and partially on how you manage your relation with the customers? Or you have Sales Person/Account Managers who need constant reminders to call up your customers? At the same time, not being a complete service based industry you can’t afford to buy a full-fledged CRM but… Read More »

Manufacturers Item Number in Sage 300 ERP

In Sage 300 ERP, users can do inventory related transactions in Inventory Control, Order Entry, and Purchase Order by simply entering standard Sage 300 ERP item number in transaction screen. It allows user to define inventory item number in users own way by creating Manufacturers item.Manufacturer’s item numbers are automatically translated during data entry into… Read More »

GL Clearing Report in Sage 300 ERP

In our previous blog, we discuss about “Auto Generate Document Number in GL Clearing Module for Sage 300 ERP”. Now we will discuss about the reporting part in GL clearing, which shows GL reconciled data saved previously in GL clearing screen.Once GL Reconciliation is completed, user can print reports to know the reconciled document. Report… Read More »

Set Fractional Quantities in Sage 300 ERP

Many a times, companies purchase materials or sell their product in fractional Quantities. So, it becomes necessary for user to enter item Quantity as fractional value rather than an integer value.In Sage 300 ERP, user can enter Fractional Quantity in the transaction by taking care of minor settings.Hence follow below steps for the settings; Navigate… Read More »

Transactional Analysis And Optional Fields In Sage 300 ERP

In addition to numerous ways that Sage 300 ERP provides to customize your business solution, there is one more mechanism which contributes to its flexibility and that is through Optional Fields. And, this Optional field form will be available to you if you install Transaction Analysis and Optional Field module .This module allows a user… Read More »