I am trying to write a manuel macro in the General Journal Entry module of Visual Manufacturing, details bellow. I was assuming adding a line item would be pretty straingt forward but this is the part that is ginving me the most troubble. I would like to use a macro that inserts 1 to n lines, each with a specific value for the GL_ACCOUNT_ID to create a few General Journal Entry templates.
Program: VFGLTENT - General Journal Entry
System Version: 7.1.2 Service Pack 1
Program Version: 7.1.2.029
Database & Patch Level: Sql Server 712.16
Clearly incorrect syntax bellow but hopefully it describes what I am trying to do well enough,
INSERT INTO VFGLTENT.Line (GL_ACCOUNT_ID)
Thanks, any help will be greatly appreciated