Is there any way to get an XMLPort to bypass table triggers

Binky

Hi,
Am new to all this so bare with me if this is a stupid question.

Have an XMLPort import that creates sales invoices (the CSV file is generated from another system).
One of the requirements is to have a different bill-to on the invoice i.e. if the field is populated use the supplied customer code, if blank use the default on the customer card.
Have the code working, the only trouble is that there is some code on the table so when a bill-to is changed in RTC it displays a dialog prompting the user to confirm that they want to change the bill-to, so, when the XMLport is imported the dialog is triggered for each line in the import file, some on the files have a hundred lines or more.....

Is there any way to bypass the trigger on the table or tell the table to not run the code to display the confirmation dialog when the XMLPort is run but leave it to display when the field is modified in RTC :?:

Rob_Hansen

You don't want to bypass the trigger logic...you'll be bypassing important updates of related fields. You need to add a line of code early in the process for:

SetHideValidationDialog(TRUE);

That is a function in the sales header table that, once set to TRUE, will eliminate the confirm prompts (assume the user had confirmed them and execute the respective logic).