Sage 100 ERP: How To Create a Custom Lookup In Sage 100 ERP

-

info@llbgroup.com
267-614-6148

Almost all data entry screens in Sage 100 ERP contain a lookup. For example, Customer Maintenance contains a lookup for the customer number. If you press the lookup icon (magnifying glass), you are able to view a listing of all your customers. The standard lookup contains the customer number, customer name, zip code and phone number. 

You can customize this lookup panel meet your needs. You can change the fields that are displayed, and you can even add calculated data fields to the lookup. By customizing the displayed data, you can create “mini” reports to give you information almost instantly. 

You can also export your customized lookup list to Excel. 

How To Video Here

Steps to customize a look up: 

1. Open the task that contains the lookup you wish to customize. Click on the magnifying glass icon for the lookup. This will bring up the standard lookup. 









2. Press the custom button. The lookup customization wizard will be displayed.



3. Enter a description for your customized look up, be sure to check ‘default’ if you would like this to be the first view that is displayed. A dialog then displays all available fields for the lookup. 










4. Select the fields you want in your customized lookup by choosing from the available fields and moving them to the selected columns by double clicking or by highlighting and pressing the arrow which points to the right.










5. A filter can be set as a default for a custom lookup as well. For example, you could select to see only customers that have zip codes that start with “53”. 










You will now notice that there is a ‘view’ drop-down on your list screen. This enables you to change back to the ‘standard’ view or any of your custom lookups with ease. To export the lookup listing to Excel, press the Excel icon in the lower right corner.










For more information or assistance with modifying the lookup window in Sage 100 ERP please reach out!


Comments

Post a Comment

Popular posts from this blog

Sage 100: Sage Cloud Portal Tips and Tricks

-
Image
LLBPartners.net info@llbgroup.com 215-654-0800 To access the Sage 100 Cloud Portal, use the following address: https://sage100na.sagepartnercloud.com There you will be promoted to enter the username and password you used to sign up for the Sage Cloud. Once logged in you will have access to standard published apps, as well as any custom apps for your system. ·          Sage 100 – Launches just Sage 100. ·          Data Drive – A windows explorer giving you access to the Sage 100 folders. ·          Virtual Machine Access – Launches a complete remote desktop, giving you access to Sage 100, data drives, and any other programs installed on your cloud. If you are using Microsoft Edge to access the portal you will have the option to chose Windows Mode, or Browser mode for your apps. If you use other browsers such as Chrome or Firefox then Browser mode will be the only a...
Read more

Enhancement: Automatically Create Cash Receipt for Sales Order Deposit

-
Image
  LLBPartners.net info@llbgroup.com 215-654-0800 Enhancement: Automatically Create Cash Receipt for Sales Order Deposit Sage 100 out-of-the-box requires a cash receipt to be manually entered when a deposit is recorded in a Sales Order. This customization automates this process, creating a new deposit in cash receipts for a GL distribution against the customer deposit account listed in S/O Options. When a deposit amount is entered, the user is prompted asking if a cash receipt should be created.    If they click yes, a deposit is created in the batch SODEP (if enabled). Each sales order deposit goes into its own AR Cash Receipt Batch. The batch information is brought back to the sales order. If the sales order has a deposit number associated with it already then, the user will not be prompted to create a cash receipt if the deposit information on the sales order is changed. Note: Any changes to the sales order deposit will need to be manually changed to the cash receipt ...
Read more

Visual Cut by Millet Software: Streamlining Operations, Boosting Productivity, and Gathering Insights for Sage 100 Cloud Users

-
Image
LLBPartners.net info@llbgroup.com 215-654-0800 In today's fast-paced corporate climate, staying ahead of the competition requires effective operations, increased efficiency, and precise business analytics. That's where Visual Cut by Millet Software comes in as a game-changer for businesses using Sage 100 Cloud as their ERP solution. This robust reporting and document management solution offers a range of features that can significantly improve Productivity, efficiency, and well-informed decision-making within your company. How Visual Cut Enables Businesses Utilizing Sage 100 Cloud: 1. Streamlined Reporting: Visual Cut streamlines and automates the reporting process, saving your team time and effort. I t offers a user-friendly interface for creating, customizing, and scheduling reports, ensuring timely and accurate information for important stakeholders. With Visual Cut, you can easily develop and publish comprehensive financial reports, sales analytics, inventory summaries, ...
Read more