Adding an item on the sales order based on previous items on that sales order with Line Looping

Kate L. Barron

• 25 de marzo de 2026 19:24

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. 

 

 

 

 

Vote

0

• 

  Dave Gutman

  • 26 de marzo de 2026 12:38

  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

Iniciar sesión para dejar un comentario.