MULTISET macro command

I am using MULTISET macro command to set a template for AP invoice. Item 39.1 is a GL code, item 39.1 is 'test2' string.

However it does not paste 'test2' into the first row, it skips to the row below, 2nd row.

It is ok when discount or price is populated.

MultiSetFromSql($[$39.2.0]|$[$39.1.0]|SELECT '114100','test2' from dummy);

MultiSetFromSql($[$39.2.FIRST]|$[$39.1.FIRST]|SELECT '114100','test2' from dummy);

Has anyone got the same problem?

Comments

1 comment

Rasmus Jensen

December 30, 2020 06:13
You will need to use the .row syntax (Seems you try that but got the syntax a bit wrong. This video explain how to proper use it: https://youtu.be/sQgN-qb-hvg

Please sign in to leave a comment.