Aarto
Reputable Poster
Hi all!
I am tring to find a way to import or maintain prices for multiple items (either to base prices by item number / customer group or as override adjustments by item number / customer group
Basically, i would like to see a grid like this (all items by customer group)
Item 1, customer group A, price 100
Item 2, customer group A, price 110
Item 3, customer group A, price 200
etc (with effective dates and other fields)
I've looked at price matrix but can not see how i could use this as it requires two groups and at least one of them has to be a complex group. So i can not use this if i want to define prices by item number, only if i do it by item group/customer group
Then i looked at mass maintenance, P45550, and here the problem is the opposite.. I can set it up by item number but can not use customer group as criteria since the "basic" customer group is no lonager available in F4072, only the complex price group ID exists in F4072
So this would show all prices for all items without being able to limit the results to a certain customer group
Seems like Oracle has very carefully avoided giving ua a solution to the one requirement i have seen since 1997. (Ability to upload/Mass update prices on item number/customer group level) or i'm just too daft to see the obvious way of achieving this?
Maybe there is a way of doing this? Any pointers would be greatly appreciated.
The real requirement is to be able to calculate markup/discounts from the suppliers price list and we want to be able to import this list from Excel directly into base price table or as an override price adjustment. It would be great if there was support to pick up a supplier price directly from F41061 but i don't think that is possible
We're on 9.0 with all the latest ESU:s installed (starting configuration phase with clean install)
/Aarto
I am tring to find a way to import or maintain prices for multiple items (either to base prices by item number / customer group or as override adjustments by item number / customer group
Basically, i would like to see a grid like this (all items by customer group)
Item 1, customer group A, price 100
Item 2, customer group A, price 110
Item 3, customer group A, price 200
etc (with effective dates and other fields)
I've looked at price matrix but can not see how i could use this as it requires two groups and at least one of them has to be a complex group. So i can not use this if i want to define prices by item number, only if i do it by item group/customer group
Then i looked at mass maintenance, P45550, and here the problem is the opposite.. I can set it up by item number but can not use customer group as criteria since the "basic" customer group is no lonager available in F4072, only the complex price group ID exists in F4072
So this would show all prices for all items without being able to limit the results to a certain customer group
Seems like Oracle has very carefully avoided giving ua a solution to the one requirement i have seen since 1997. (Ability to upload/Mass update prices on item number/customer group level) or i'm just too daft to see the obvious way of achieving this?
Maybe there is a way of doing this? Any pointers would be greatly appreciated.
The real requirement is to be able to calculate markup/discounts from the suppliers price list and we want to be able to import this list from Excel directly into base price table or as an override price adjustment. It would be great if there was support to pick up a supplier price directly from F41061 but i don't think that is possible
We're on 9.0 with all the latest ESU:s installed (starting configuration phase with clean install)
/Aarto