Technical and Installation Discussions

[lramirez]

MAS 200 V4.4

I am having difficulty updating the DiscountMarkup1 field in the IM_PriceCode table using visual integrator. 

Here is the job definition:

Field Name	Type	Oper	Col/Pos	Len	Msk/Val
PriceCodeRecord	S	REPL	1	1
PriceCode	S	REPL	2	4
CustomerPriceLevel	S	REPL	3	1
PricingMethod	S	ASSn		1	O
DiscountMarkup1	N	REPL	4	16

And here is a sample import file:

0

0001

D

200

Also, here is the Record tab definition:

Description	Col/Pos	Start	Length	Relation	Value
Standard Record	1	00001	1	=	0

When I execute the job, it gives me the following error:

 "Cannot set DiscountMarkup1 until break quantity is set." 

Next, I modified the job to set the field BreakQuantity1 to the value of "1" and it gave me the following error when I executed the job:

"Cannot set BreakQuantity1 until previous break quantity is set".

Then, I modified the job to set all BreakQuantity fields to their current value and it kept giving me the same error "Cannot Set BreakQuantity until previous break quantity is set"

Any help would be vey much appreciated. Thank you.

[lramirez]

Anyone have any idea of why it's not letting me update the DiscountMarkup fields in the IM_PriceCode table?

It would be a nightmare having to update all the price codes manually. Any help would be highly appreciated.

[Gator]

I believe the last BreakQuantity has to be "999999".

[lramirez]

thanks for the reply. 

I set the last BreakQuantity to 999999 and it gave the same error message, "Cannot set break quantity until previous BreakQuantity is set".

I've tried setting all 5 BreakQuantities and it gives the same error message. I really don't know why it's not letting me import.

[DFeller]

Did you put the break qty field BEFORE the discount field in your import job?

Dawn

[lramirez]

Yes I did.

I am able to import new Price Code records, but not able modify existing ones.