Hi everyone,
How do I join this note back to the PO Receipts header where it is attached? Our partner does not know how to either....
Thank you,
Donnette
*This post is locked for comments
Hehe, I happen to have the answer, because I asked this very same question of MBS support recently.
Here is a copy/paste of the example they gave, which I was able to use to get my desired outcome. Once you review this, if you have questions, just post back and I'll try to help!
-----
Below, I've outlined a simple example that I believe should help with what you're looking to do.
What needs to be changed is line 2 (This is where we need to select the NOTEINDEX). For notes, the BUSKEY begins with '0\System\Notes\'
Next, it adds the hexadecimal value of the noteindex. We needed to convert the noteindex to hex and from hex to string. Here is a sample statement to do so:
select '0\System\Notes\'+CONVERT(varchar(max),CONVERT(VARBINARY(8),
(Select NOTEINDX From GL20000 where JRNENTRY=1234)
),2)
You would want to change Line 2 of the above to the correct JRNENTY for the JE to change which noteindex it's using to get the proper buskey,
In order to get the above into a SmartList, you would want to create a view using an equation like the above - this should assist in obtaining the end result.
Hi Donnette,
You should be able to join these using the note index in the SY03900.
select POP10300.POPRCTNM, SY03900.TXTFIELD from POP10300 join SY03900 on POP10300.RCPTNOTE_1 = SY03900.NOTEINDX
Hope this helps!
Isaac Olson
Microsoft Support
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
