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?
Page 1 / 1
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
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
Hi @saab_cjones
I’ve only just spotted your reply as i’m still researching issues we’re having with this job and my old question was in the search results. We are now on Cloud but still have access to Apps 10 for reference. This is what is in the source mapping for the job in question:
This job never worked for us in Apps 10 so its not an example I would sell on for a profit ;-)
Some of the mandatory fields seem to pick up a default value but any that don’t you can add one in.
as a required field which doesn’t seem correct. These are just two example but there are many more.