Mark C
08/15/2022, 8:55 PMvar marginDelta = (parseFloat(fbaContributionMarginAmt) - parseFloat(fbmContributionMarginAmt)).toFixed(2);
logModule.debug({title: 'Margin Delta', details: marginDelta});
logModule.debug({title: 'FBM Margin', details: fbmContributionMarginAmt});
logModule.debug({title: 'FBA Margin', details: fbaContributionMarginAmt});
if (fbaContributionMarginAmt > fbmContributionMarginAmt) { //in example if 5.73 > 10.02 which... it's not.
rec.setValue({fieldId: 'custrecord_br_cst1_margin_review', value: true}); //box is being checked
rec.setValue({fieldId: 'custrecord_br_cst1_memo', value: 'Difference of: ' + marginDelta}); //gives a negative value
}
Log:
Title Details
FBA Margin 5.73
FBM Margin 10.02
Margin Delta -4.29
But it's filling the fields with:Mark C
08/15/2022, 8:57 PMbattk
08/15/2022, 9:17 PMbattk
08/15/2022, 9:17 PMMark C
08/15/2022, 9:19 PMbattk
08/15/2022, 9:22 PMvar fbaContributionMarginAmt = 5.73;
var fbmContributionMarginAmt = 10.02;
var marginDelta = (fbaContributionMarginAmt - fbmContributionMarginAmt).toFixed(2);
logModule.debug({title: 'Margin Delta', details: marginDelta});
logModule.debug({title: 'FBM Margin', details: fbmContributionMarginAmt});
logModule.debug({title: 'FBA Margin', details: fbaContributionMarginAmt});
if (fbaContributionMarginAmt > fbmContributionMarginAmt) { //in example if 5.73 > 10.02 which... it's not.
rec.setValue({fieldId: 'custrecord_br_cst1_margin_review', value: true}); //box is being checked
rec.setValue({fieldId: 'custrecord_br_cst1_memo', value: 'Difference of: ' + marginDelta}); //gives a negative value
}
Mark C
08/15/2022, 9:23 PMSandii
08/15/2022, 9:23 PMMark C
08/15/2022, 9:24 PMbattk
08/15/2022, 9:25 PMMark C
08/15/2022, 9:26 PMbattk
08/15/2022, 9:26 PMMark C
08/15/2022, 9:26 PMbattk
08/15/2022, 9:26 PMMark C
08/15/2022, 9:27 PMMark C
08/15/2022, 9:27 PMbattk
08/15/2022, 9:28 PMbattk
08/15/2022, 9:29 PMMark C
08/15/2022, 9:30 PMMark C
08/15/2022, 9:30 PMMark C
08/15/2022, 9:30 PM