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 available option. ·          Browser Mode - any app you launch will be opened inside a webpage. ·          Windows Mode
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

Sage 100 ERP Customization: Automatically Change Order Status Based on Customer Credit Hold

-
Image
  llbpartner.net info@llbgroup.com 267-614-6148 Standard Sage 100 can be set to prevent new orders from being created if a customer is over their credit limit or on credit hold, but what about existing sales orders?  This simple customization ensures that open sales order reflect your customers current credit hold status. By clicking on the credit hold button in Customer Maintenance the system checks to see if there are any open sales orders for the customer. If there are, their order status will instantly be updated to reflect the customers credit hold status.  If they are put on credit hold any open order will be placed on hold as well. If the customer is taken off credit hold their orders are changed back to an open status.
Read more