You’re offline. This is a read only version of the page.
3,225
I am trying to add our tracking numbers to our invoices when printed. We keep our tracking numbers in the User Defined: Sales User defined entry window in the SOP. I am having a hard time figuring out what field that is called when in report writer.
Thanks in advanced.
Katie
*This post is locked for comments
Thank you!
I will try that and let you know.
Katie
I don't know how much you are used to of Report writer and working with Calculated fields. I am sharing screen shots to show how to select fields which creating Calculated fields. May be this helps you or anyone else.
You have to go to calculated field definition window, name your calculated filed with type string. Select User Defined radio button and core sales and select the Function, press OK button will show this in Expression field.
After that you have to select sop number and sop type fields. Now select fields menu and find Sales Transaction Amount Works table, select it, and then in fields drop down find sop number field.
Hit Add button, Similarly add sop type field. Press OK and drag and drop your field to report.
no bill it's not like that to log off GP and login again to get ride of Calculated field error. :)
In the article the function should have spaces like this:
FUNCTION_SCRIPT(rw_CreateSOPTrackingNumberString SOP_HDR_WORK.SOP Number SOP_HDR_WORK.SOP Type )
Others in the community have had success:
community.dynamics.com/.../281799
Tim
The function creates a string containing the tracking number.
Tim
Katie if you are getting that error it is possible that you will need to log off of GP and back in again to allow the modified report to be recognized by the system.
Good on the tracking number as well.
I did the trick, but when I went to print the invoice it gave me an error stating the calculated field was not valid. I double checked and it shows exactly what was shown. Bill - I do not need to create a tracking number, I just need to pull what is automatically put into the User Defined field by VShip. Thanks
Tim, I like the Tip and Trick - but does that function create a tracking number or pull the tracking number that the users enter in a User Defined field that is attached to the SOP document?
Katie, if I missed what you are doing, and this is what you need - great and sorry for poking my nose into this.
Hope to hear more.
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 (