AnsweredAssumed Answered

Variations between pricelists, product codes and prices.

Question asked by RafaelRomano on Mar 31, 2011
Latest reply on Mar 31, 2011 by RafaelRomano

Title

Variations between pricelists, product codes and prices.

Post

Hi guys,

I'm working on a table that should bring PRICES according to the CODES of the product and I also have 6 DIFERENT PRICELISTS for the same CODES (products), according to diferent costumers and the price variation hasn't a logic for discount, for ex.

I have a file a database called PRODUCTS where the itens are all listed with their codes, descriptions and their 6 diferent prices; then I have the database SALES where I import each product detail from it's CODE and where I have a Field with names for each PRICELIST.

I'm working on a Case description, but the problem is that in the end it doesn't link to the CODE anymore to set the right PRICELIST value based on the product.

Case (

FIELD pricelist name = "A" ; INVENTORY::PRICES A ;
FIELD pricelist name = "B" ; INVENTORY::PRICES B ;
FIELD pricelist name = "C" ; INVENTORY::PRICES C ;
FIELD pricelist name = "D" ; INVENTORY::PRICES D ;
FIELD pricelist name = "E" ; INVENTORY::PRICES E ;
FIELD pricelist name = "F" ; INVENTORY::PRICES F ;
"" )

Would you have a better idea?

thx!

Rafael

Outcomes