Macro Syntax for insert line.

unknown

Hello, 

I am trying to write a 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 be able to create a macro that inserts 1 to n lines, each with a specific value for the GL_ACCOUNT_ID.  

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)

VALUES (

               '123_ABC',

               '456_DEF',

               '789_GHI',

               '246_KLM',

              )

 

Thanks, any help will be greatly appreciated

unknown

This doesn't sound like an IPA related question. Perhaps post in the Infor Developers community?