Avatar of niccross
niccross
Flag for United States of America asked on

DYNAMICS GREAT PLAINS - Mass Price Update Problem

Just ATTEMPTED a massive price update and change in Great Plains Dynamics. Ran into a HUGE problem is the price level setup. While we have updated the IV00108 table with the new price levels and prices, since the PRICE LEVEL setup is based on the old schema:

1-9
10-49
50-100
OVER 100

if I change the PRCLEVEL field in the IV00108 table to the new schema:
1-10
11-50
51-100
OVER 101

Great Plains will show a price of $0.00 but if I change it back to the old price level it will show the UOMPRICE field.

Anyone have ideas? URGENT
Microsoft SQL ServerMicrosoft DynamicsDatabases

Avatar of undefined
Last Comment
Mlanda T

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Victoria Yudin

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Mlanda T

(shivering) niccross... that might mean going back to the drawing board on this one?
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes