Sage 100

Is anyone aware of a mod that makes the Gross Profit Warning calculation in Sales Order Entry smarter? (entry, not the update) Sales Order Options help for 3. Line Entry tab says: **Profit Margin Percent to Display Warning** **...This feature calculates a profit percentage based on the price entered for the line and the_ last cost of the item_, regardless of the inventory valuation method....** In other words, maybe there is a way to use the warehouse last cost instead of the item last cost? Or something more accurate.

If you're referring to the warning message box for the profit pct, a mod is needed to override SO_CommonEntryDetail.pvc and change the calc. If you're referring to the message bar at bottom left that says ""Profit Margin % = x"" your programmer (forgot his name) or @DanBurleson could potentially write a script for you. It involves changing the value of a control (ML_STATUS field) so script should be doable. The hardest part would be coming up with how to determine the warehouse last cost perhaps.

Thanks @AlnoorCassim to answer your questions as to which part - all of the above! Sounds like I need to talk to ""my programmer"", Jon Reiter. IM_ItemWarehouse.AverageCost will work for this client, but it does need to work in both places, on the bottom of the screen as a reference and as in the popup when GP is below the defined minimum.

@GregStiles Why not turn off the standard Display Profit Margin Percent and display your own text on the panel or put up a message? I overwrite the User Login display (below the Copy from... button) to display subtle information.

That would work as well. Let's discuss on Monday @DanBurleson