How did Syteline get that Price?


Overview about SyteLine Pricing Hierarchy

Solution ID = KB-353

Goal : How did Syteline get that Price?

Version = All Version

Module : SLCOPO

Symptom 1 : How did Syteline get that Price?

Symptom 2 : What sort of routine does Syteline follow when getting the price for the CO Line Item?

Database : Progress, SQL

Fix

First, it looks for a Customer Item Cross Reference contract price...

It looks for a contract price and compares the contract effective dates on the contract price to the order date on the CO header. If the order date falls between the contract effective dates, the contract price is used. If no valid contract price is found, Syteline goes to step two.

Second, it looks for a Customer Item Cross Reference quantity break price...

If it has quantity break points covering the quantity of the line, then the quantity break points and their prices will be used. If no customer item cross reference is found, then Syteline goes to step three.

Third, it looks for a Price Matrix and Formula...

It looks for a customer price code and an item price code. The customer price code is on the order line. The item price code is on the item price record if one exists or, if not, then the product code for the item. If either price code is not found, then Syteline continues on to step four. If both a customer price code and an item price code are found, then it looks for a price matrix that references both to get the price formula. From the price formula, it uses the break quantities and their prices. If no break quantities are found, then the amount in the value field is used. If no price matrix and/or no price formula are found, Syteline goes to step four.

Fourth, it looks for an Item Pricing record...

It uses the break quantities if they are available and valid. If not, it uses the price in the unit price 1 field. If no item price record exists, then a message will be displayed that says the item in question has no price and Syteline goes to step five.

Fifth, if steps 1 - 4 fail to obtain a price, the user must manually enter a selling price.

After setting the price if the quantity is changed on a customer order line that has price breaks, a ? must be entered in the unit price field to recalculate the cost.
Print Email

Send KB to this email: