Skip to main content

We have an existing migration job that worked until Update 20 was applied. The job adds lines to a sales quotation. Now the lines are added successfully only for rows where the customers price list has a value in the Discount Type field for the part in question. The job looks like this:

The error returned is “Field lDISCOUNT_TYPE] is mandatory for Order Quote Line Discount and requires a value.”. The migration job doesn’t currently include a method list entry for the Order Quote Line Discount view so it isn’t possible to add a default value for this field:

 What we would like is to be able to add a default value if there isn’t one on the price list. Is there a way of doing this?

Hi,

Sorry I don’t have a suggestion for your problem but I hope you maybe help me.  

I found your post when researching a problem I am having with creating an Excel Migration for Sales Quotation Lines.  When I create the job, IFS is requiring a lot more mandatory fields in the migration job than through the user interface.  For example, if I leave “cost” out of the migration job I receive an error that it is required. This shouldn’t be required as it should get added to the quote automatically after the line is saved.  The job is also requiring “Probability 😵 as a required field which doesn’t seem correct. These are just two example but there are many more.

 

Would you be wiling to share what your current job has for “Source Mapping” and if you had to make any changes to the Method List attributes.  We don’t have any custom fields so we are only using view ORDER_QUOTATION_LINE.  

 

Thank you


Reply