{"id":9009,"date":"2014-10-13T06:20:34","date_gmt":"2014-10-13T06:20:34","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=9009"},"modified":"2022-04-29T11:22:31","modified_gmt":"2022-04-29T11:22:31","slug":"customer-wise-item-filter-on-order-entry-screen-in-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/10\/13\/customer-wise-item-filter-on-order-entry-screen-in-sage-300-erp\/","title":{"rendered":"Customer Wise Item filter on Order Entry screen in Sage 300 ERP"},"content":{"rendered":"

In this post, we will discuss about a component that we have developed to restrict selection of Item numbers available for the user while creating transactions in Sage 300 ERP.
\nNew Stuff:<\/strong><\/span> Setting up Database in Sage 300 <\/a>
\n<\/a>
\nIn the Manufacturing and Trading industry, there are scenarios where a Company may have variety of products that the company deals with in the Procurement and Sales department.
\nAlso there are scenarios in some industries where you sell or purchase Inventory only for a particular Customer\/Vendor. So at the time of transaction, user always has to search from a vast Inventory list for the items, which is cumbersome. To handle this situation, we have developed a simple yet effective modification. To allow user to view only the Items assigned to a particular Customer\/Vendor.
\nTo achieve the above business criteria, we have taken example of the Sales Order entry screen. With the customization, now the user will be able to view only limited Item numbers based on the customer selected in the data entry screen.
\nIn the customization, we have made use of the standard I\/C Customer Details setting present in the Inventory control module. User will need to setup the Item wise customer details in the standard Customer detail screen, which will be used by our customization in Sales order entry screen to filter Item numbers based on the customer selected on the Sales order entry screen.<\/p>\n