Skip to content
+1-888-319-3663

COMMUNITY FORUM

add note during transaction creation

Boris asked 8 months 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.
Answers
Lorren Zemke Staff answered 7 months ago
Boris,
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
 
Lorren

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