LineLoop in HANA Answered
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
Comments
1 comment
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.