Hi @hansend, @Thomas Langenberg found out that my problem easily could by resolved by peforming the following steps:In Aurena - API Explorer - find the Projection "QuickReports" Select "Remove from Compatibility Application Type" Select "Include in Compatibility Application Type"Apparently the report-specific functions are rebuilt by Including the Projection in Compatibility Application Type. After this, things work fine for me.
Hi @Charana Udugama Thanks for your quick reply.I was aware that this private function cannot be used frou outside the package.The question than remains: why is this REST api (used for adding a new record) requiring a value it should internally create? Well, my first try was to do it without any configuration, but I'm afraid I have to go to the custom method option you mention. So thanks for your suggestion!Regards, Reinier
Thanks, @hansend, but this is a brand new quickreport which I tested before. online and gives correct results. A simple SQL query like “select PART_NO from IFSAPP.INVENTORY_PART” isn't that complex, but does not appear in the Quickreports.svc and - via Postman- gives the mentioned error. So the issue remains open for us. I raised a ticket at IFS, hope they will respond soon.
Exactly the same problem here. Some quick reports show up and create results, others are not accessible with the error you mentioned. No idea where to look further.
Source mapping - sorry, had to remove it from my original post
Hi Adresh, what error message do you get? Reinier
Great, that works:The imported CSV file is in the table IC_A10_ROUTING_OPER_FILE_TAB and contains all necessary values to identify unique lines. Entering the Migration Job attributes: on the Formatting tabSource Name : IC_A10_ROUTING_OPER_FILE_TAB A, IFSAPP.ROUTING_OPERATION BWhere : b.CONTRACT=a.CONTRACT AND b.PART_NO=a.PART_NO AND b.ROUTING_REVISION=a.ROUTING_REVISION AND b.BOM_TYPE_DB=a.BOM_TYPE_DB AND b.OPERATION_NO=a.OPERATION_NO On the Method tab Adding ROUTING_OPERATION_API.Remove__ as method and on the Source Mapping tab: METHOD10_OBJID = B.OBJID METHOD10_OBJVERSION = B.OBJVERSION METHOD10_ACTION = 'DO' OBJID = B.ROWID does the job. Thanks a lot.
Hi Togar, You are right that Excel is also following the Regional Settings. Other applications, like Microsoft (!) Word however show a dot when using the numeric keypad. It seems that other systems like our former Baan ERP, and even webpages, show a behavior depending on the type of field the numeric dot is used in. In an alphanumeric field, a dot is shown, and in a numeric field it is showing the decimal sign as defined in the Regional Settings. So the question remains whether there is a workaround for this. Reinier
Hi @NickPorter , thanks for replying. We set in IFS the Regional settings Language to English, IFS Currency Format to 0.00 (tried several options) and restarted IFS after every change. Windows settings have been set to default keyboard layout nl-US(international). Regional settings are set to Dutch. And, of course, restarted Windows several times. I think this is an IFS issue, because every other application shows a dot. Reinier
Already have an account? Login
No account yet? Create an account
Enter your 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.