06/08/2017, 6:09 PM
Still working on a project to have NS calculate Service Level, want to bounce an idea of the community, and see if anyone has any thoughts. I'd like to add a custom column to sales orders that uses the logic, is quantity available >= quantity ordered, if yes, then a 1 is entered in the column, if no then a 0 is entered. Separately, I would have a custom field on the SO that takes the sum of those values, divided by number of lines, giving me the service level for the order. This would also allow for a search to calculate the service level at an item level. Thoughts?