• From: USA, FL
  • Registered: 02/16/2018
  • Posts: 28

Topic: Incorrect display of sales_price

Using en_US-demo.sql as a reference for the 0_prices database table, the field sales_price indicates '100' which should display in FA as 1.00 if preferences Decimals->Prices/Amounts is set to 2.

Data that was uploaded to the 0_prices table such as 1495 displays as 1,495.00 with decimals set to 2 and 1,495 with decimals set to 0.

What is necessary for this to display as 14.95?

Information appreciated.

Thanks.

bholtz / neholtz

neholtz's Website

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,181

Re: Incorrect display of sales_price

it looks like the decimal format issue.
But in core there is no such a problem, I tested your input, it comes like 1,495.00. and if i remove decimals it becomes 1,495

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website