Skip to Content
0
Former Member
Aug 29, 2007 at 09:25 AM

How to set condition scale according to accumulated purchasing quantity?

42 Views

Hi,

I want to set different condition scale for a material according to the accumulated purchase quantity against a vendor (includeing historical purchase order), just like follows:

Accumulated purchasing qty (including hostorical PO): 100 pcs ---> 1.5$/pc

Accumulated purchasing qty (including hostorical PO): 200 pcs ---> 1.4$/pc

Accumulated purchasing qty (including hostorical PO): 300 pcs ---> 1.3$/pc

Accumulated purchasing qty (including hostorical PO): 400 pcs ---> 1.2$/pc

Accumulated purchasing qty (including hostorical PO): 400 pcs ---> 1.1$/pc

... ...

So, how to realize this by standard functions?

Please kindly advise.

Thanks and best regards.