Author Archives: sage300

OE Sales Register Report for Sage 300 ERP

In our previous blog, we discussed about AP Vendor Ledger Report for Sage 300 ERP which is a part Greytrix Extended report Pack for Sage 300 ERP. Related Post: Greytrix Extended Report Pack for Sage 300 ERP In this blog we will take a detail view on OE Sales Register Report. The name Sales Register itself indicates… Read More: OE Sales Register Report for Sage 300 ERP »

How to Search on Multiple Fields in Sage 300 ERP

Sage 300 ERP has a flexible mechanism for searching the records on the basis of multiple filters; it provides a finder tool for looking up the data in Sage 300 ERP. This is a fairly important activity as it becomes easy for the end user to fetch the data easily. Using the finder tool, it… Read More: How to Search on Multiple Fields in Sage 300 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: Table Does Not Exist Error while importing data into Sage… »

AP Vendor Ledger Report for Sage 300 ERP

In our previous blog, we discussed about Greytrix Extended report Pack for Sage 300 ERP, which gives an overview of 7 forms (Reports). Greytrix Extended Report Pack for Sage 300 ERP Now we’ll discuss each report in detail. In this blog we are going to discuss AP Vendor ledger/ Transaction Report. Standard AP Vendor Transaction… Read More: AP Vendor Ledger Report for Sage 300 ERP »

Item Master Auto Synchronization between Two Systems

Consider a business where an actual inventory data is collected through web /ecommerce system which as a different ERP integrated with it other than Sage. How difficult it would be to keep the Inventory Masters of these 2 different ERPs synchronized when they are not integrated with each other. Users will have to manually maintain… Read More: Item Master Auto Synchronization between Two Systems »

Provide Minimize/Maximize Buttons in VBA Forms (Macro)

Most of the developers came across this particular limitation i.e. minimize and maximize buttons in VBA forms. These buttons are by default available in Visual Basic forms i.e.; in design view of form we can locate appropriate properties for these buttons.  But while designing VBA forms these properties are not available and the buttons doesn’t… Read More: Provide Minimize/Maximize Buttons in VBA Forms (Macro) »

Configuring Greytrix TDS in Sage 300 ERP – III

In our last blogs we have discussed about the Party Details and DT Options that need to be setup properly before starting up for Greytrix TDS module. In this blog we will discuss on TDS sections and role of State codes in Greytrix TDS for Sage 300 ERP. For Part I: Configuring Greytrix TDS in… Read More: Configuring Greytrix TDS in Sage 300 ERP – III »

How to set default reserved quantity in Sage 300 ERP

Sage 300 ERP allow user to commit/reserve quantity for a particular item in order. While creating an Order if user commits/ reserve it then, it simply means that quantity is guaranteed to be available unless you allow negative inventory quantities. You can commit/reserve quantity for a particular order manually while doing transactions. In case you… Read More: How to set default reserved quantity in Sage 300 ERP »