Does anyone know how to tell where the due at dock value come from on the Purchase order lines in cloud.
in Apps 10 we could check the system information and see the SQL column, but would like to know how to get the same information (system info panel) in Cloud.
thanks
Page 1 / 1
“Enable debug console” will get you to the debug window ...
There’s an Aurena Insight extension available - debug info is fairly detailed.
Not entirely sure where the exact equivalent is...
@smelanson
If Debug > Enable Debug Console is not available, and instead you have Debug > Enable devtools link, you will need to:
Install the IFS Cloud Web Dev Tools extension from the Add-Ons section of the Landing Page
In the application select the command Debug > Enable devtools link
In Chrome, in the menu shown select More tools > Developer tools to access the information
@matt.watters thanks Matt, I did install the IFS Cloud Web DevTools and used it when we were building/creating the permissions but am not comfortable with understanding how to interpret the information. I created a purchase order line and can see that the DueAtDoc field is populated.
Can you provide some details about how we use the IFS Cloud Web DevTools to determine how the DueAtDock field is getting populated.
@smelanson I do not know how to use or interpret any of the information available in the DevTools, only how to access the feature. I leave that for those with a technical background like the tech consultants, developers, or software engineers.
Hi @smelanson
Please refer to the SQL statements available in the Trace tab. Please refer to screenshot below.
Hope this helps.
Regards
Abdul Rehman
@Abdul Thanks for the information. I think I’m getting close to what I’m looking for but, when I go to the Trace tab, I’m not seeing any sql type information. I only see Framework.
To get the information above, I added a new line to a po and saved it. Should I be doing something else?
I am not a developer but we have a new developer who is not familiar with IFS but needs this type of information so I’m trying to understand so I can guide her.
Thanks in advance.
@smelanson in the end I think you’ll find it to be something along the lines of
Due at Dock = Purchase Line Qty - (∑Qty Received or Approved + ∑Qty Scrapped + ∑Qty Returned for Credit)
@matt.watters yes, I understand that the ‘due at dock’ is a calculation and in Apps 10 it was easy to make that determination.
What I’m trying to understand is how does someone go about determining where the field is or comes from, in Cloud. It’s not straight forward and I’d like to be able to give our developer some guidance.
My last snippet shows the same information that @Abdul showed in his snippet except my trace tab isn’t showing me the sql details so I’m missing something. Once I can get the trace tab to show the sql. I can explain it to our developer so she’ll be able to see where the ‘due at dock’ field originates. The due at dock field is a specific example. Or developers are not users of IFS so it’s helpful if they know where to look for information.
Hi @smelanson,
You are almost there. Please refer to the screenshots below.
First, click on the Filter funnel option.
Select sql option, click anywhere on blank space.
All sql statements would filter out for the selected Projection call. You can scroll down to review all select statements.
Additional to this, you can share link below to understand IFS Cloud debugging in details.