Skip to content


add note during transaction creation

Boris asked 2 years ago
I want to add a note to an inventory transfer I’m importing. I don’t see anything in the map to do this but figured there should be some way, whether using node builder, or a post document sql script. Please advise the best way.
Lorren Zemke Staff answered 2 years ago
Since Microsoft didn’t provide a method to write to the Inventory Transaction Notes, you have the two methods you mentioned.
1. create a node using Node builder that updates the correct GP SQL tables with the note
2. Create a SQL stored procedure to create the note with a post document task or you could just write the whole thing using a SQL Command task or Script Task depending on your experience with SQL and/or .NET

If you would like to submit an answer or comment, please sign in to the eOne portal.