Warn Users When Entering COP Orders for Items Below a Certain Margin
A - We don't have an exact function like this. But we have something similar for this purpose. It is called "Item Minimum Price," which is in Item File Maintenance in the second field of "16. Sell/Min Prc." See sample screen below:
Mass Update Minimum Price
You can Mass Update this field through I/M -> Util-Setup -> Change Existing Item Import. As you can see from the sample screen below, the Minimum Price is the last column of the Item Change CSV layout. You can export your Item Master out to CSV and bring up your spreadsheet. Decide what minimum margin you would like to have and calculate the minimum price for all applicable items. Once you are done, the final CSV file should have only two columns where column A is item number and column B is the minimum price. Then you can choose to import and change the minimum price for items in Mass Update. Since your minimum price is based on margin, and your cost changes constantly, you may need to have a procedure to update the minimum price field periodically (like weekly or monthly).
Receive Warning Message in Order Entry or Sales Desk
Once the Minimum Price field is set up, then during Order Entry or in Sales Desk when the line item price falls below the minimum price, a message will pop up to warn the user that the "Unit Price Below Minimum Price - Is This OK ?"
Price Below Minimum Price Event
If the user chooses "Y" and enters a line item unit price below the minimum price, the system will also trigger an event where the manager can subscribe and be notified when this happens. See sample screen below:
Related Articles
Feature - Allow Over Allocation for Certain Locations and Users
Release Date: 2/27/24 Version: 8.5 and Above A new option is available in Global Setup-> COP-Func-> Order Line Item Screen-> 12. Allow Qty-To-Ship > Excess Qty (OH-Alloc+BO) that allows over allocation to occur for specific locations for specific ...Feature - Sales Order Import To Warn If Sales or Weight Greater Than Certain Value
Release Date: 8/23/2016 This feature gives the ability to print a warning message on the Sales Order Import Pre-Interface List or Interface List if the Order Total Sales Amount is greater than a certain value or if the Order Total Weight is greater ...Multiple Users Entering Physical Count Tag at the Same Time Issue
Q - We think we have found a scenario where two different users could enter and use the same physical tag number with Auto Entry Mode. When both users used the F1 key to get the next tag number, as each tags are added, system automatically assign the ...How to Skip Range of Orders in COP Order Inquiry
Release Date: 09/20/2018 Q - Currently, the COP Sales Order Inquiry screen is designed to show the last order number first. My COP sales order is approaching 999999. I intend to reset it to 1000 through COP setup before it rolls back to zero or ...How to Skip Range of Orders in COP Order Inquiry
Release Date: 09/20/2018 Q - Currently, the COP Sales Order Inquiry screen is designed to show the last order number first. My COP sales order is approaching 999999. I intend to reset it to 1000 through COP setup before it rolls back to zero or ...