AnsweredAssumed Answered

Multiple prices each product

Question asked by micky888 on Jun 12, 2017
Latest reply on Jun 13, 2017 by micky888

Part#1

now i have these following tables:

•Product

•Price

•Customer

•Sale

•Sale line item

*i'm not sure that all tables i have are all necessary or not

-each product has many unit of measure (UOM).

-each UOM has its own price

-i would like to have many prices on each UOM (retail, wholesale,...)

For example

•ProductA

Unit: piece

-----------------------

UOM: 1piece = 1piece

retail price: $10

whole sale: $8

special price: $6

-----------------------

UOM: 1pack = 6pieces

retail price: $50

whole sale: $48

special price: $46

-----------------------

UOM: 1dozen = 12pieces

retail price: $90

whole sale: $88

special price: $86

-----------------------


Part#2

I would like to assign types of price to each customer

 

I tried many ways to relate my tables together but i found nothing work

 

Any helps or suggestions would be appropriate

Thanks

Outcomes