Good Morning

I imported some price increases into one of my alternate price lists. I originally had three discounts but I was eliminating the last one. I imported the changes (there were about a hundred items) with no errors.

When I was invoicing today I noticed that the price wasn't changing when the quantity was entered. I checked using Alt 'P' and it looked good. When I looked at the price list I noticed the quantity was still in for the third discount. I must have missed it when I did my check. Normally when entering discounts in manually a warning pops up that the quantity must be greater than the previous value. Importing seems to bypass this check. Just thought I'd let you know.

Thanks

Hi Mike,

Thanks for letting us know. I suspect that having 2 different discount settings for the same quantity is getting the entry procedure confused, and fixing up the Alternate Price List discounts makes everything work again.

Just for reference, how did you set up the import in order to remove one of the discounts? Were you changing just the 3rd discount amount to 0.00, or the 3rd discount quantity as well? The correct end result should have been nothing for the 3rd discount - as for the 4th and 5th rows - so we'd first need to determine if the import process worked as the template and file were defined, or if there was deviation from the expectations.

Hi Support

I went back and checked my import file. The third discount amount was set to zero but I didn't remove the discount quantity. I think I may have had that column, along with some others, hidden while working on the other discount amounts; so when I was done I just unhid all but forgot to check everything before importing.

The reason the two discount quantities are the same is that we had a spring special for three months. The normal discount for 240 is $0.44 but during the special it was $0.50. I thought it would be easier to add a discount level 240 @ 0.50 and change the normal discount to one less - 239 @ 0.44. That quantity would never be entered, and it still allowed us to see what the normal discount was.

Whenever I do an import, I always do an export first so I know that fields will match. With inventory, there are required fields which I always forget, so it's just easier to do a full export then import.

Thanks