Adding an item on the sales order based on previous items on that sales order with Line Looping
Dear Boyum,
I'm not sure I'm approaching my task correctly. I'm trying to auto populate a line on the sales order with a particular item code based on other item codes previously selected on the sales order. I started by creating a B1 Validation using a Case SQL Statement listing the items that need to be present for adding another line on the sales order based on those items previously selected on the sales order. See my B1 Validation screen below.
Then I created a line loop for a SQL condition. See this screenshot below.
Here's my second UF within the Line Loop UF for my set command.
Can you help me resolve this issue or should I be taking a different approach?
Thank you,
Kate
But I'm getting a syntax error when testing it on a sales order. I created the sales order, select just one of the items and get this error message see this screenshot below as well.
Comments
1 comment
Hi Kate,
Regarding the syntax error, it looks like the closing parentheses ')' needs to be at the end of the evaluation. For example:
IF ('S052-01-0000' <> 'HAZ-20-0000')
You can get ideas on how to approach this from Boyum's page with B1UP examples: https://support.boyum-it.com/hc/en-us/sections/115002378047-Samples
This one looks similar to what you're trying to do:
https://support.boyum-it.com/hc/en-us/articles/360004540097--Line-Loop-Macro-Automatic-outgoing-payment
Hope this helps,
Dave Gutman
Please sign in to leave a comment.