80
I have been trying to get the Buyer description data on PO form but I could not find it in the report writer.
I can get the Buyer ID but not Buyer Description.
Is anyway I can get this data and print out on the PO form?
Thanks for your help.
Toshi
*This post is locked for comments
Hi Toshi,
We can achieve the above process either by VBA , table relation & custum RW funtion.
Best way is creating custom RW function
1) Create a calculated String field
2) create a custom RW function as follows.
function returns string BuyerDesc;
in 'Buyer ID' BuyerID;
release table POP_Buyer;
range clear table POP_Buyer;
clear table POP_Buyer;
range table POP_Buyer where physicalname('Buyer ID' of table POP_Buyer) + " = '" + BuyerID + "'";
get first table POP_Buyer ;
if err(table POP_Buyer) = OKAY then
BuyerDesc = Description of table POP_Buyer;
end if;
3) Open the calculated field, choose our custom function under function tab
4) once the function is added assign the Buyer ID from the Purchase Order Work (header)
5) Drag the field to the report.
Note: Custom RW function is preferred more to avoid Table Hierarchy error(Setting Custom Relation ship)
Even though this is an old post, for the benefit of those like me that may search this, you don't need to use vba.
You can create a new table relationship between the POP Header Work and the Buyer Table.
The tables concerned:
POP10100 | POP_PO | Purchase Order Work
POP00101 | POP_Buyer | Buyer Master
Link on Buyer ID
This post has a great step by step from Leslie Vail on linking tables together (obviously, replace table names with details above): community.dynamics.com/.../123509.aspx
The description field can then be pulled onto the Purchase order.
Yes, it is possible BUT with a bit of VBA code on it.
The approach is like; you have to add a calculated field and then add this report to VBA, add the calculated field and then the Buyer ID to VBA. Then retrieve the Buyer Description from Buyers Table by passing the Buyer ID thru' either ADO SQL execution OR Continuum & Dex Table Buffer method.
Straightforward method other than the above; I seriously doubt.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (