I would guess that your organization has blocked permissions for you on the Invoice tab...perhaps that is supposed to be filled out by a different group?
That sounds like you need a better performing query. You could create an IAL (which can use tables) to pull in the contributions if you actually need to run that query as-is. Otherwise, you could try to refactor the query to get better performance. Either way the UI will time out if your data takes minutes to return.
How long does your query take to run?
What does it say when you hover over the X?
I am part of a company that has implemented sites in the US, UK, multiple EU countries (with Italy still to do), China, Japan, Korea, and soon to be Brazil.
Use ORDER_NO, LINE_NO, RELEASE_NO from purchase order line and ORDER_NO, ASSG_LINE_NO, ASSG_RELEASE_NO from purchase req line nopart.
Hello Brendan, If I remember correctly there should be a reference to the PO number inside the purchase_req_line views that you can use to get a better join condition. Try looking for fields pertaining to order_no and line_no/release_no. Brendan,Below is an example of what I mean by do a correct join…in sql syntax. There are order_no and line no columns in purchase req line nopart views to give yourself a better join. These tie directly to the purchase order order no and line no and come about from when the req is converted to a PO. select prl.ORDER_NO, prl.ASSG_LINE_NO, pol.ORDER_NO, pol.LINE_NO from purchase_req_line_nopart prljoin purchase_order_line_nopart pol on prl.REQUISITION_NO = pol.REQUISITION_NOand prl.ORDER_NO = pol.ORDER_NO and prl.ASSG_LINE_NO = pol.LINE_NO
Brendan,A strong link would be using multiple shared columns between different views as part of the join condition. The more columns that you use that are shared, the more correct the join will be. I recommend doing some research on database joins and database relationships as some further reading. This will help you fill in the blanks a bit. For SQL Syntax you can use SQL Query Tool but the above will still apply. Its better performance and usually better data if you use a correctly written join condition as opposed to relying on DISTINCT.
Brendan,My answer was how you prevent duplicate records, but I will generalize this a little. In order to eliminate the chances of duplicates you have to have a strong join condition defined. This is due to the lack of a “DISTINCT” keyword as you are not writing out a query using SQL syntax. In my experience this means that a little research has to be done in order to discover that strong link.
Hello Brendan,If I remember correctly there should be a reference to the PO number inside the purchase_req_line views that you can use to get a better join condition. Try looking for fields pertaining to order_no and line_no/release_no.
If using custom RMBs that open links you can always preface the url with microsoft-edge. This will open the link in a new edge window. An example link might bemicrosoft-edge:http://google.com
Hi Sven,For the Korean reporting of invoices to the government we are actually now writing an interface to send the invoice data to a Korean company called Linkhub (product name is Popbill) that acts as an intermediary and then sends those transactions through to the government on your subsidiaries behalf. The send could probably be done through IFS directly via IFS Connect but we decided to write our own middleware for this.
These permissions can be found under the “Presentation Objects by Component” tab on the Permission Set screen. Expand “IFS Base Functionality” and uncheck GUI Settings - Behavior Configurations in properties dialog and GUI Settings - Contextmenu configurations in properties dialog. Note that this appears to still leave the tabs visible but makes them read only. I am unsure if hiding completely is an option.
Hi Maja,Apparently customers can go here and access/sign up. IFS Academy | IFS
Hi brantMB,I too have the same issue coming from a shop order. I keep wondering if the SO is tied to a case but so far no luck and no insight.
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.