Item Sales Pricing Logic – What happens if the price is missing?
When adding an item to a sales order, I understand the logic NS uses to establish the pricing to be applied to the item follows a strict order starting from Customer Specific Pricing (from the customer ‘Financial’ tab) and onwards.
We currently utilise Price Levels, we do not use Price Groups.
If an item does not have a price in the customer specific price, and does not have a price set in the price level associated to the customer, does anyone know what the logic is that determines which price level will be selected when an item is added to a sales order?
We were led to believe that NS would loop through the price levels on the Sales/Pricing tab on the item record, but no-one seems to be able to define what logic determines the level that NS selects. Does NS choose the price level starting with the lowest Price Level ID or by alphabetical value in the list from the item, or how does this work?
Any help would be appreciated 🙂