LineLoop in HANA

Respondida

Balakumar Viswanathan

• 22 de enero de 2018 13:06
• Editado

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

• Comentario oficial

  

  Yaremi Miranda Lopez

  • 22 de enero de 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.

Iniciar sesión para dejar un comentario.