Hi @Narmada , We have no value in that tab for any address for this customer.We do have values in the Tax Free Tax Codes, however they are also not the ones that appear by default (attached image). So where exactly does IFS choose the Tax Code from?I tested removing the “Taxable” check box from the Sales Object, and with that, the tax code from the Sales Object is correctly selected. Now my doubt is, if not taxable, how exactly would that influence the calculations, if the tax code’s percentage is not Zero? Is this possible, for the Sales Object to be not taxable, but with a tax code having a percentage different from 0? Thanks in advance,Carlos Mendes
For some reason the creation of the post generated 161 attachments, when I only added 3…
Hi @carlosfmendes , You can make you sql into a string and the execute it as a background job. See this: https://community.ifs.com/framework-experience-infrastructure-cloud-integration-dev-tools-50/how-to-create-a-defered-job-to-execute-modify-1757 Hi @Hans Andersen,Thanks for the tip.It worked like a charm!
Hi @carlosfmendes , I believe the below post might contain the answer you are looking for: Can you try your custom event again by utilizing PRAGMA AUTONOMOUS_TRANSACTION; ? Regards, Malindu If I understand correctly, this makes an autonomous and asynchronous transaction, correct?I can see this might work, as the trigger is AFTER creation, and not on any CHANGE or REMOVAL.So I need the new row created, to then update the fields on this newly created row. However at the moment, I have the problem that I need to get the OBJID and OBJVERSION of the recently created row at the beginning of the custom event, however the SELECT statement returns no OBJID and OBJVERSION, so I assume it is not yet created, even though the custom event is for AFTER creation.Does this have anything to do with this change, to do put PRAGMA AUTONOMOUS_TRANSACTION?
Hi @carlosfmendes , I’m assuming by the mutating error you are referring to the ORA-04091 error. In that case, the possible cause would be that you are trying to both select and update the IFSAPP.PART_REVISION table in a row level trigger. You could maybe try using a compound DML trigger and see if it works.https://docs.oracle.com/database/121/LNPLS/triggers.htm#LNPLS99888 Hope this helps! Regards, Malindu Hi Malindu,Yes, you are correct, however the error is on top of a Custom Event in IFS, as I am not doing anything directly on the Oracle database.This is why I ask, if there is a workaround within IFS?Thanks,Mendes
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.