You’re offline. This is a read only version of the page.
65
Hi,
I need to display the value of ‘Item Note’ field with each record in the OrderLine section on the 'POP Purchase Order Blank form'. For this, I added a new relationship between Item Master’s NoteIndex to SY03900 NoteIndex and then put the TXTFIELD in the report in the Orderline section but report does NOT display its value at runtime.
I have made the change using 'Modify' button available on the toolbar on the Report. I do not have prior experience of modifying existing GP report.
Below is my analysis ---- OrderLine fields (like Item Number, Description etc) are from table ‘popPOLineRollupTemp’ (Purchase Order Line Rollup Temp) which is a TEMPORARY table. I think that a field must be present in this table if it is to be printed. To verify this, I added column ‘PO Line Status’ from table ‘popPOLineRollupTemp’ and ‘PO Type’ from table POP_POLine_Temp (Purchase Order Line Temp) in the OrderLine section. On running the modified report, PO Line Status appeared as ‘Released’ whereas PO Type did not appear. So, I think we need to add ‘TXTFIELD’ column of SY03900 table in the Temp table ‘popPOLineRollupTemp’ but I could not find the way to do it from GP help or any internet forum on GP.
I am using Version 10.0 of Dynamics.
Please let me know if my understanding is correct and the resolution or workaround for this problem.
Awaiting your reply,
Thanks in Advance,
Somesh
*This post is locked for comments
Hi Sagi,
At last I am succeeded in displaying the Item Note with each OrderLine record in the report.
I added 'Item Note' using the relationship ‘Purchase Order Line Rollup Temp (‘popPOLineRollupTemp’) > Item Master > Records Note Master’. I was earlier making mistake by using table POP_POLine_Temp (Purchase Order Line Temp) in creating relationship so the value was not displaying.
I am putting my steps for reference if some one else needs -
1. Open the report in modify mode
2. Go to Tables > Tables
3. Select popPOLineRollupTemp. click Open button.
4. Create Relationship with Item Master on ItemNumber.
5. Similarly created relationship between IV_Item_MSTR and Records Notes MAster on NoteIndex.
6. Add table ItemMaster in the related tables linked to popPOLineRollupTemp. Also add Records Notes MAster in the related tables.
7. From the toolbox, Drag and Drop the TextField in the OrderLine section.
I will also do it following your suggestion and will let you.
Thanks a lot for your suggestions and time,
Somesh
Hi Somesh.
The field should be placed in the H3 section of the report. Once there ddouble click the field and make sure it is set to data.
Also, try placing the NOTEINDX field on the report and validate that the field value is not zero. If it is it may be that the link between the Purchase ORder Line Temp and the Item Master is not correct.
Using Tools - Customize - Customization Status you can export the report into a ppackage. Feel free to email me this file and I can better see what the problem.
I will send you a sample of mine that displays the note
Hi Sagi,
Thanks once again for the reply.
I did the same as per your above suggestion and added a calculated field for 'Item Note' using same function RW_GetNoteText'( 'IV_Item_MSTR'.'Note Index'30 1 ). But still its value is not displaying. I tried by putting the new field in the different sections like H3- ItemHeader1, H4 -Comment3 Header, Item Tax, Body. I also tried by adding a new section based on Report table 'POP_POLine_Temp (Purchase Order Line Temp) '.
Can you please let me know in which section I need to put this field or on which table new section needs to be created.
Sorry, I am asking you simple questions as I am novice to GP report writer.
Please reply at your earliest convenience as I have to deliver the solution to client urgently.
Thanks a lot once again for your time and effort.
Somesh
You may want to try the RW_GetNote Text function that GP supplies.
You will find this in the user-defined functions under system when creating a calcualted field.
To use select the function and the select the note index field from the item master followed by a number for haow many caharacters and then a line number usually 1.
It should look like this:
CalculatedField "Item Note"
'RW_GetNoteText'( 'IV_Item_MSTR'.'Note Index'30 1 )
ResultType "String"
Hi Sagi,
Thanks for the reply.
I verified that radio button beside the modified version is selected in Purchase section.
I am running the modified report as I can see other changes in the report. But, Item Note is NOT displaying the value.
Have you ever made such change in the Purchase Order or Sales Order Blank Form report?
If Yes, then please let me know the solution.
Thanks,
Somesh
Hi Somesh.
Verify that you have access to the modified version of the report.
In the Administration Pane, under System you will see alternate windows and modified reports.
Choose the profile and the reports.
In the Purchases section you should see your report.
Make sure the radio button beside the modified version is selected.
Hope this helps
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...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (