milesmfe / kec.ILEConfigExcel

https://www.kecdynamics.com/
0 stars 0 forks source link

Check sales/cost actual/expected processing is included (VE) #6

Closed milesmfe closed 2 months ago

milesmfe commented 2 months ago

Processing rules:

milesmfe commented 2 months ago

Original code for this logic:

try {
                    // If the actual sales amount is 0 and the expected sales amount is not 0,
                    // update the actual sales amount to the expected sales amount and set the
                    // expected sales amount to 0
                    // controller.log("Updating sales and cost amount for row [" + rowIdx + "]");
                    if (Float.valueOf(salesAmountActual) == 0 && Float.valueOf(salesAmountExpt) != 0) {
                        salesAmountActual = salesAmountExpt;
                        salesAmountExpt = "0";
                    }
                    if (Float.valueOf(costAmountActual) == 0 && Float.valueOf(costAmountExpt) != 0) {
                        costAmountActual = costAmountExpt;
                        costAmountExpt = "0";
                    }
                    // Save the updated values to the output array
                    output[rowIdx][salesAmtActualIdx] = salesAmountActual;
                    output[rowIdx][salesAmtExptIdx] = salesAmountExpt;
                    output[rowIdx][costAmtActualIdx] = costAmountActual;
                    output[rowIdx][costAmtExptIdx] = costAmountExpt;
                    output[rowIdx][discountAmtIdx] = discountAmount;

      }
milesmfe commented 2 months ago

This feature is already implemented (NO FIX)