Custom Event based on two tabs

Hello;

It is very easy if it is IFS Cloud, but I think you can do it by creating a trigger in PLSQ. Or you can edit the procedure that performs the operation in the relevant API.

@IFSAD since you are monitoring the VAT Code in Invoice Item, I think you could easily throw an error message by creating a Custom Event on INVOICE_ITEM_TAB and monitoring the VAT Code columns for the incorrect values.

BEGIN

     Error_SYS.Record_General('InvoiceItem','WrongVATCode: You are not allowed to create an invoice item with this VAT Code.' );

END;

However, I guess this would mean that the Invoice header will be created anyways and then what you are stopping is the invoice line creation. Then if needed and no other invoice lines exist I guess you could call invoice_api.remove_ function to delete the already created invoice header.

@Marcel.Ausan Hi Marcel, 

Thanks for your reply, indeed this works but in my case i would like to add a second condition when the flag “Advance Invoice” is flagged in the header of the supplier invoice (TAB “INVOICE_TAB”). 

@IFSAD then before throwing the error message you should define a cursor that would be a select from invoice_tab checking for the advance invoice flag. Then you would open the cursor and if the advance_invoice flag = true then trigger the error, else null.