Sage 300 provides a functionality where user can find the field (column) name used in the database to store the values. Usually, developers have the Sage 300 SDK where details about the database is specified which is used for the select/update purpose. We have another workaround using which the user can have the database column… Read More »
You may receive inventory items and assets that you intend to use within your own company. You use the Internal Usage screen to record your company’s use of inventory items and when you specify the quantity for a serialized item in detail and then tab out of the quantity field, the respective Serial/Lot Numbers Allocation… Read More »
The Finder tool in Sage 300 ERP is used for the selection of the Key value for which the finder is specified. Finder tool can be launched by clicking the magnifier icon on the Sage 300 screen and also can be opened by selecting the control and pressing hotkey “F5”. New Stuff: How Are Sage 300… Read More »
In our previous blog, on Optional field we had discussed about the feature ‘Validate’ and ‘Allow blank’. https://www.greytrix.com/blogs/sageaccpacerp/2014/04/26/validate-optional-field-in-sage-300-erp/ In this blog, we will discuss about ability of the finder to filter based on the optional field data. The New Stuff : Print picking slip after creation of OE Invoice in Sage 300 Sage 300 ERP… Read More »
Searching Fields in Finders are very helpful to search any record by applying a filter. But all the fields are not displayed when you drill down Find By option. Let’s take an example of Customers finder. Here, we want to filter by Territory, but there is no Territory field when we drill down Find By… Read More »