milesmfe / kec.ILEConfigExcel

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

Check adjustment line logic #8

Open milesmfe opened 2 months ago

milesmfe commented 2 months ago

Original Code:

try {
                String adjustmentType = "Positive";
                float quantityFloat = Float.parseFloat(quantity);
                float invoicedQuantityFloat = Float.parseFloat(invoicedQuantity);
                float ileQuantityFloat = Float.parseFloat(ileQuantity);
                float costAmtActualFloat = Float.parseFloat(output[i][costAmtActualIdx]);
                float costAmtExptFloat = Float.parseFloat(output[i][costAmtExptIdx]);
                float costAmtActACYFloat = Float.parseFloat(output[i][costAmtActACYIdx]);
                float costAmtActExpACYFloat = Float.parseFloat(output[i][costAmtActExpACYIdx]);
                if (quantityFloat >= 0) {
                    adjustmentType = "Negative";
                }
                output[i][costAmtActualIdx] = String.valueOf(costAmtActualFloat * -1);
                output[i][costAmtExptIdx] = String.valueOf(costAmtExptFloat * -1);
                output[i][costAmtActACYIdx] = String.valueOf(costAmtActACYFloat * -1);
                output[i][costAmtActExpACYIdx] = String.valueOf(costAmtActExpACYFloat * -1);
                output[i][ileTypeIDX] = adjustmentType + " Adjmt.";
                output[i][valuedQuantityIdx] = String.valueOf(quantityFloat * -1);
                output[i][invoicedQuantityIdx] = String.valueOf(invoicedQuantityFloat * -1);
                output[i][ileQuantityIdx] = String.valueOf(ileQuantityFloat * -1);
                output[i][veILEEntryNoIdx] = String.valueOf(veILEEntryNo);
                output[i][entryNoIdx] = String.valueOf(entryNo);
                addEntryNoToSet(entryNo.toString());
                output[i][salesAmtActualIdx] = "0"; // Zero sales amount
                output[i][salesAmtExptIdx] = "0"; // Zero sales amount
    }
milesmfe commented 2 months ago

Original specification for this: