Unable to Truncate Custom Field-Based Formulas

Hi there,

I have a seemingly easy formula that I cannot get to truncate to two decimals to the right of the decimal (dollar amounts).

Context: EDI  transmission of document custom fields – setup for calculating the correct dynamic totals for transmission on the 810 (Invoice)

I have two fields that are calculating correctly but sometimes go beyond the hundredth cent decima fields causing transmission errors.

I have attempted both rounding up and truncation formulas but unable to get the nesting to work without errors.

Seems simple so what am I missing?

Are their formula limitations for custom fields in Netsuite or is it a matter of TRUNC formatting?

See formulas below that requires truncation to dollar amounts: $xxx.xx

TermsDiscAmount_Calc

({custbody_sps_termsdiscountpercent} x .01) x {subtotal}

TermsDeferredAmountDue
{total}-{custbody7}

NOTE: (format performed due to best results for invoice fields – discount percent is a dynamic % by Trading Partner)

Any help on this would be greatly appreciated!

Rookie Asked on February 24, 2023 in How To's.
Add Comment
1 Answer(s)

What type of formula field are you using?

Formula (Currency) will limit the decimal places but happy to help wit the formula if you need.

Intermediate Answered on February 24, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor