I would like to import a future dated price file where where the supplier part number is referenced and checked for for matches.
- New items are flagged for addition
- Multi Level purchase pricing (Quantity Breaks) go active for purchases on that date
Our Item Supplier Item Cost RRP Break 1 Price 1 Break 2 Price 2
ABC123 123 $10 $20 100 $7 500 $6.50
We also have multiple suppliers for item ABC123. We would purchase based on price and availability.