To generate a number sequence in the OIC integration

Summary

While doing grouping of orderlines using OIC integration, would like to generate numbers for the line numbers.

Content

Hi,

 

Implementing the grouping concept, need to generate number for the line number.

 

Requestt:

 

 "InvoiceLine":[ {

"LineNumber": 1,

         "ItemNumber": "68765",

         "Description": "Item1",

         "TaxClassificationCode": "STANDARD",

         "Quantity": "2",

         "UnitSellingPrice": "20",

         "Manufacturer": "100101",

         "BusinessArea": "494500",

         "Art": "11010",

         "ProductService": "110000",

         "TotalAmount":"40"

      },

      {

         "LineNumber": 2,

         "ItemNumber": "68765",

         "Description": "Item1",

         "TaxClassificationCode": "STANDARD",

         "Quantity": "3",

         "UnitSellingPrice": "20",

         "Manufacturer": "100101",

         "BusinessArea": "494500",

         "Art": "11010",

         "ProductService": "110000",

         "TotalAmount":"60"

      },

      {

         "LineNumber": 3,

         "ItemNumber": "68765",

         "Description": "Item2",

         "TaxClassificationCode": "STANDARD",

         "Quantity": "4",

         "UnitSellingPrice": "20",

         "Manufacturer": "100101",

         "BusinessArea": "494500",

         "Art": "11010",

         "ProductService": "110000",

         "TotalAmount":"80"

      }  

      ] 

 

Response:

Grouped based on the Manufacturer and BusinessArea

then result should be as below,

"InvoiceLine":[ {

"LineNumber": 1,

         "ItemNumber": "68765",

         "Description": "Item1",

         "TaxClassificationCode": "STANDARD",

         "Quantity": "5",

         "UnitSellingPrice": "20",

         "Manufacturer": "100101",

         "BusinessArea": "494500",

         "Art": "11010",

         "ProductService": "110000",