Hi,I don’t think there is an option to change that. Let’s wait for any other expert ideas on this. If non of the above did work for you, I suggest you to raise this with IFS.
Hi,Try to edit the statement like this >> sma.order_no LIKE '&[-C--L]order_no' (take out ‘sma’ after the flags). So the query would like belowand sma.order_no LIKE '&[-C--L]order_no'Also when prompting for the parameters try and see by entering the values without quotes and use ‘;’ to separate the values.Like in below example;
Hi, can you add the full sql query you are using here.
Hi,It looks like the issue is with missing query flags. In IFSAPP9 and IFSAPP10, you could specify Query Flags for the quick report parameters to search for multiple values.Please edit your query as below and try executing the report and see if it does the job for you.sma.order_no LIKE '&[-C--L]sma.order_no '>>Below are the list of flags you could use;M=Mandatory C=Custom (simplified or 'values only') S=Single flag B=Allow Between expressions L=Allow wildcards ('%' and '_')You may refer below link for more on query flags :https://docs.ifs.com/techdocs/foundation1/050_development/026_br_and_a/005_adhoc_reporting/070_dev_qrep/default.htm
Hi Thushitha,ASC is the IFS Industry Extension for Automotive Supply Chain and it is specially designed to address the needs of the automotive industry.
This could be due to the missing of the respective periods in periods tab line when purchase order lines exists (except for the cancel state). The user may have deleted the period since the agreement may not be valid for the given period anymore. But still if any POs pending for matching, it should not allow the user to delete the respective periods.If that’s the scenario here, yes a bug has been created by RnD to prevent deletion of the records in periods tab line when purchase order lines exists.
Hi Mattias,Could you please briefly explain the exact steps you followed to observe this error. It would be easy to figure out the issue.
Hi @johnw66 A data repair would be possible. But there are few tables you might need to consider like INVENTORY_PART_IN_STOCK_TAB, LOT_BATCH_MASTER_TAB etc.It would be better if you could dispatch an investigation task for IFS consultingfor further investigations in order to look in to the possibility of a Data repair.
Hi Vimukthi,Yes, that's right. This happens because in 'Mpccom_Accounting_API.Transfer_To_Finance___' method, the applied_date is getting truncated. Please refer the below cursor which fetches the Accountings. You will notice that the 'date applied' returns a truncated value with the TRUNC() function - trunc(date_applied_). CURSOR get_accountings (contract_ IN VARCHAR2, date_applied_ IN DATE ) IS SELECT DISTINCT acc1.date_applied, acc1.accounting_id FROM MPCCOM_ACCOUNTING_TAB acc1 WHERE acc1.date_applied <= trunc(date_applied_) AND acc1.contract = contract_ AND acc1.booking_source = booking_source_ AND acc1.status_code = '2' AND NOT EXISTS (SELECT 1 FROM MPCCOM_ACCOUNTING_TAB acc2 WHERE acc2.accounting_id = acc1.accounting_id AND acc2.status_code = '99') ORDER BY acc1.date_applied, acc1.ac
There is no specific rule, but it will check whether there areany conditions defined for parameters when executing the event action. (Ex - REPORT_TITLE)
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.
