You’re offline. This is a read only version of the page.
Announcements
508
Hi DAXers,
I am here again for one more related question.
In this request, from the ReqTransPo form, I want to take InventDim.ConfigId that available in tab "General" and ReqTransSettled.RefId that available in the grid under tab page "begging" to be shown in the Grid in ReqTransPOListPage to show either Sales Order or Purchase Order # "Reference Number" not only Planned Production Order #.
Both ReqTrans and InventDim tables are related to ReqPO which is the main table in the form's query. but when I am trying to add RefId from other tables, it shows only the same ReqPO.RefId.
Here also it is possible to create a display method to show these fields, but I need to be able to filter and search using any of them.
Regards,
Hi Mahmoud, Many thanks for the solution it is working fine and below is formatted code to get Planned Production order pegging records in D365 F&O.
Share
Report
All responses (
Answers (
public display InventTransRefId cplRefID()
{
ReqTrans reqTrans,reqTransSettled;
ReqTransCov reqTransCov;
select reqTrans
where reqTrans.RefId == this.RefId
&& ReqTrans.RefType == this.RefType
&& reqTrans.PlanVersion == this.PlanVersion
join reqTransCov
where reqTransCov.ReceiptRecId == reqTrans.RecId
join reqTransSettled
where reqTransSettled.RecId == reqTransCov.IssueRecId;
if (reqTrans.RefId != '')
{
return reqTransSettled.RefId;
}
}
Many Thanks, Atul Kumar
REQPO.PLANVERSION = REQTRANS.PLANVERSION AND REQPO.REFTYPE = REQTRANS.REFTYPE AND REQPO.REFID = REQTRANS.REFID
then
REQTRANS.RECID = REQTRANSCOV.RECEIPTRECID where direction = 1
then REQTRANSCOV.ISSUERECID = REQTRANS.RECID
you should join reqtrans Twice
Anyone can help me here?
Hi Andre,
The datasource is already available in the query under different name "ReqTrans" that sourced from ReqTrans Table, which also is the source of the targeted ReqtransSittled datasource that fet the SO number that I need, but when I am trying to use the same field it shows Production order number.
I do not know what is the different between ReqTrans and ReqTransSittled datasources??
If possible, would you mind providing me more explanation. Please?
Regards,
Thanks Zain,
For "why not convince users to use a report? Why do they want to see it in the form?" It is very Important to control the priority of Planned production Orders to firm the required lines based on SO or manual Planned Production Order.
As for your suggested solution, the matter is ReqTransSettled datasource sourced from ReqTrans table which already available in the ReqTrans datasource in ReqTransPOListPage. I do not know where is the problem!!
What do you mean by "with relative constraints" this may add more light to see the road.
Regards,
You're welcome Ahmed,
By the way, if they just need to see a list, why not convince users to use a report? Why do they want to see it in the form? It will not be a good solution design.
About the query: You can add datasource(ReqTransSettled as on details page) for Pegging lines to your Query for listpage and with relative constraints then you'll be able to show data from both, PR and pegging lines. You can compare both Queries from the Listpage(ReqTransPOListPage) and the details page.
Hi Zain,
Thanks for your response.
I know Pegging can have multiple records and that what I am talking about. I need to show the Reference Number even if it will come in deferent lines with exact quantity for each line.
So, the question now is; how to extend the query used on the list page with related datasources?
and Pegging can have multiple records correct? if so, then you cannot show one PRE line with all numbers from Pegging. You will have to follow Andre's suggestion for that, and if I'm not wrong, it will cause you to see multiple lines with same PRE number if there are multiple lines in Pegging for it.
Hi,
To view the values from dimensions (InventDim) you just need to enable them like this.
HI Ahmed,
If you need to be able to filter on the fields, you need to extend the query used on the list page with related datasources .
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,186
Super User 2024 Season 2
#2
Martin Dráb
227,996
Super User 2024 Season 2
#3
nmaenpaa
101,148