3PL Billing Script - Round the Extended Charge Field in Backup Files to 2 Decimal Places

3PL Billing Script - Round the Extended Charge Field in Backup Files to 2 Decimal Places

As explained in our Using an Infoplus Script to Customize 3PL Billing Invoice Worksheets article, Infoplus scripts can be used to customize 3PL Billing Invoice worksheets.  Please refer to that article for the general variables and objects that are available when creating this script type.  


The content that follows in this article is an example script that looks at every input row that would go into an Invoice Worksheet & corresponding backup file then rounds each Extended Charge field to 2 decimal places.  


The script starts by using a for loop to loop through all input rows and rounds the extendedCharge field to 2 decimal places.  After the loop is finished, these changes are applied to the invoice worksheet by using utils.setOutputLines();

For more information about 3PL Billing scripts and how to apply them to Customer Invoice templates, see this article.