Get Started with Redwood: Oracle Cloud SCM and Purchasing
BPA with several lines and different prices per line
in Purchasing
Hi, is it possible to create/maintain a BPA with several lines (different items) and define historical prices on each line?
For example, see below two lines, having different prices based on different periods. Item A suffered an increment of 10% since April, and another increment of 10% since June. Item B suffered an increment of 20% in Feb 16:
Line | Item | Price | From_Date | Thru_Date |
|---|---|---|---|---|
1 | A | 4.20 | 1/1/25 | 3/31/25 |
1 | A | 4.62 | 4/1/25 | 5/31/25 |
1 | A | 5.08 | 6/1/25 | |
2 | B | 14.10 | 1/1/25 | 2/15/25 |
2 | B | 16.92 | 2/16/25 |
They have BPAs with 50 lines or more, so it would be very cumbersome generating new lines for the same item on each price change.
Thanks.
Tagged:
0