Replies posted by carlosfmendes
You just need to disable the Scheduled System Task for the PSO job, which will be something like “PSO Integration [USERS]”. If it doesn’t run then it doesn’t matter what the routing rules etc are configured like (or not configured) Nick For some reason I wasn’t finding anything in the tasks with %PSO%, but now I have found it and disabled it.Hopefully after the weekend , we can already see some results, with very few errors!Thanks very much for you help!
Unless you use the PSO function of the system, this is not needed and can remain disabled. In recent IFS versions this seems to be enabled by default even when you don’t use it and haven’t configured it, which is the error you are seeing with the URL. Nick @NickPorter , thanks for the feedback. And how do I avoid error #2?What more do I need to disable, besides the Routing Rule?
Ok, was able to understand what IFS does.If the Instant Invoice Tax Liability is: Exempt Checks the taxable field of Sales Part Taxable (different from Tax Liability) Gets the Tax Code from Customer / Address / Delivery Tax Information / Supply Country / Taxes. Non Taxable (same as Tax Liability) Gets the Tax Code from the Sales Part. Tax Checks the taxable field of Sales Part Taxable (same as Tax Liability) Gets the Tax Code from the Sales Part. Non Taxable (different from Tax Liability) Gets the Tax Code from Customer / Address / Delivery Tax Information / Supply Country / Tax Free Tax Codes.
Thanks once again for your input @Adam Bereda and @cperdue. The last answer from Adam is what worked, as with a default value when no control type value exists, it uses the value from preposting, if it exists. If no value from preposting exists, and there is no match in the details of the posting, it uses the default value when no control type value exists. Thank you very much for your help!
Hi @cperdue and @Adam Bereda, Thanks for your input. I added that is was an non inventory part, because I could see that it could be relevant.We don’t always want to use preposting, it is only for specific cases of non inventory parts.Inventory Parts are all configured in Posting Control without preposting. What I don’t understand, and from what you wrote Adam, is that even though I put values in preposting, those values need to exist in the M30 posting rule? Did I understand correctly?If so, what is the purpose of having preposting, if you then need those values to exist in the posting rules anyway?I apologize if I misunderstood. Thanks in advance,Carlos Mendes
Yes, we have different sites in different countries, so I understand the concept of having different supply countries. What I don’t understand is, if we supply to one delivery address, is it possible for the tax number of the customer to change, depending on supply country?That for me doesn’t make sense, however that is what I assume the tab allows as a possibility? Or are you saying that the only example, is when the vat number is mandatory, or not, depending on the supply country and the delivery address?
Hi @Ralph Gericke, First of all, thanks for the explanation! I understand the logic you wrote, and can now see an example for having different delivery countries for the same address and therefore have different tax numbers, if we consider the document address is only to receive the document and the invoicing is to be done on the delivery country. However, I still don’t understand how we can have different supply countries for the same address and have the possibility to have different tax numbers? Are you able to think of an example? Thanks in advance,Carlos Mendes
Hi @carlosfmendes , Please try revoking the “GUI Settins - Theme configuration in options dialog” permission for this. You can find this permission under “IFS Base Functionality” node in Presentation Objects by Module tab, which can be found in New Permission set window. Hope this helps! Hi @Charith Epitawatta, Thanks for your help!Was exactly what was needed and even ended up changing some other accesses in the Options Tab. Cheers,Carlos Mendes
@Sajith D , thank you very much for your help and suggestion!I ended up doing what you said, only changing the background job that launches the event, as Heavy Cleanup runs 3 times a day in our case, so I ended up using a background job we created for a quick report, that runs daily. Just a question, will this action be a problem when we get updates or deliveries, considering it runs on a standard event, and not a custom event?Could it be deleted upon updates?
@carlosfmendes In your Payment Term (Com - PayTerm) window, to the right of the Saved Searches: can you see the Saved Search you created? In your screen-shot it’s currently showing “[Previous Search]” Ah yes... I wasn’t thinking that I had to create a saved search myself, for it to appear in the properties window.Created it, changed the where clause and its working like a charm, fantastic!Thanks for the help!Have a nice weekend!
Hi @Bhagya Wickramasinghe , I used a reference to create the Payment Term custom field (images below).The problem is, that this way I can’t filter payment terms by the company of the customer agreement, it shows all payment terms of all companies, and I would like to avoid this to prevent errors.
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
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.