mtbinpa
Active Member
I have about 800 items that I would like to get the unit price for each price group. We have 6 regions with price groups attached to each one and there are problems with some of the prices being incorrect. I would like to create a query that allows me to view the ITEM, PRICE GROUP, UNIT PRICE, EFFECTIVE DATES. The PRGP field is not stored in the F4106 and was wondering where JDE stores the customer price group. Currently, I am using the F4201, F4211, and F4106 and using the PRGP from the F4201, but I know there must be a faster way to do this. Thanks!!