Amount in database functions and views are hardcoded to round to 2 decimal points

Description

The amount in the database functions and views should be rounded to currency precision instead of hard-coded to round to 2 decimal points.

Database functions:

  • invoiceopentodate

  • invoicepaid

  • invoicepaidtodate

  • paymentallocated

  • paymentavailable

  • paymenttermdiscount

Database views:

  • c_invoiceline_v

  • m_product_substituterelated_v

  • rv_c_invoice_customerprodqtr

  • rv_c_invoice_customervendqtr

  • rv_c_invoice_day

  • rv_c_invoice_month

  • rv_c_invoice_prodmonth

  • rv_c_invoice_productmonth

  • rv_c_invoice_productqtr

  • rv_c_invoice_prodweek

  • rv_c_invoice_vendormonth

  • rv_c_invoice_week

  • rv_c_invoiceline

  • rv_openitem

  • rv_openitemtodate

  • rv_orderdetail

Environment

None

Assignee

Elaine Tan

Reporter

Elaine Tan

Labels

None

Tested By

None

Priority

Major
Configure