Solved

Customer price list per price group

  • 30 September 2019
  • 1 reply
  • 1049 views

Userlevel 5
Badge +10
In the customer window price list per price group tab, it is possible to add several price lists in different currencies. And if the Preferred Price List tick box is selected, it says the ticked price list would always be fetched into the Customer Order Line. But it was noted in some scenarios even though a preferred price list tick box is selected COL picks up a different price list. What is the reason behind this?
icon

Best answer by Rasika Lakmal 30 September 2019, 23:02

View original

1 reply

Userlevel 7
Badge +17
When a Sales Part is entered on the Customer Order line, the system checks for a Price per Part on the Customer Agreement connected to the ordering Customer. If no valid price is found, the system starts searching for a valid Agreement within the Customer Hierarchy. If no price is found on any Agreement, the search continues with the Price List on the Customer. If no Price List is connected to the Customer, the program checks to see if the next Customer in the Hierarchy has a connected Price List. If not, the program checks the Price List per Customer Group. If no Price List is connected to the Customer, the price specified on the Sales Part will be a valid price.

Furthermore, the COL is searching for a valid price list, it follows a certain priority order.
1. Search the Customer/Order/Price list per Price Group tab for a connected price list in a currency matching the order currency.
2. Search the Customer/Order/Price list per Price Group tab for a connected preferred price list in a currency other than the order currency.
3. Search the Customer Price Group window for a connected price list in a currency matching the order currency.
4. Search the Customer Price Group window for a connected preferred price list in a currency other than the order currency.

As above mentioned, the preferred price list has the second priority and it’s not fetching every time. For example, let’s review the below scenario.

  1. Sale price list A – Currency – "USD"– Preferred price list
  2. Sales price list B – Currency – "EUR"
  3. Create a customer order – Currency – "EUR"
  4. Priority 1 implies here and check the customer order header currency and price list currency. Then Price list B would be selected.

Reply