LineLoop in HANA

Answered

Balakumar Viswanathan

• January 22, 2018 13:06
• Edited

Hello Experts,

My requirement is to find the itemgroup of the Sales Order item which is having the maximum of line discounts.

For example, if a sales order has 10 line items out of which item-A and item-C have 35% and 25% discounts, respectively. I like to retrieve the item group of item-A since it has the maximum discount.

Note: Above requirement is for Sales Order in ADD mode.

Regards,

Bala

Vote

0

• Official comment

  

  Yaremi Miranda Lopez

  • January 22, 2018 18:42

  Hello Balakumar,

  Yes, this is an scenario that you can create with B1 Usability Package using a Universal Function called LineLoop. The configuration in SQL is the same than in HANA, the only thing that changes is in the SQL condition use HANA syntax.

  This is an example of how to create a LineLoop validation: https://support.boyum-it.com/hc/en-us/articles/229941408-Sample-Line-Loop-Automatically-Check-if-Unit-Price-is-Less-than-Item-Cost

  For more asistance please contact your local Partner.

Please sign in to leave a comment.