PT Sterling Tulus Cemerlang
www.sterling-team.com

Phone
+62-877-8655-5055
+62 (21) 580-6055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower 18th
Jl Jend. Sudirman kav 45-46
Jakarta 12930 - Indonesia

350+ FREE Tips for you from Sterling Tulus Cemerlang (STEM) - SAP Indonesia Gold Partner, and Become SAP B1 Super User

How To Set Dynamic Numeric Decimal Point In Crystal Report For SAP Business One

How To Set Dynamic Numeric Decimal Point In Crystal Report For SAP Business One - SAP Business One Tips

In Crystal Report For SAP Business One, we can set how numeric field value displayed according to the number value itself.
For example:
1. 1250.00 → will be displayed as 1250 (No decimal point)
2. 1250.65 → will be displayed as 1250.65

Step by step:

  1. In Crystal Report Designer, right click on numeric field, for example DocTotal
    • SAP Business One Indonesia/dynamicdecimalRPT1
  2. In the Format Editor dialog box, click “Customize” button
    • SAP Business One Indonesia/dynamicdecimalRPT2
  3. In “Custom Style” dialog box, choose “Number”:
    • Click formula button beside “Decimals” setting, and insert formula below.
    • Do the same for “Rounding” setting formula.
    • SAP Business One Indonesia/dynamicdecimalRPT3
  4. Result will be displayed like this:
    • SAP Business One Indonesia/dynamicdecimalRPT4
Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang, SAP Business One GOLD Partner in Indonesia.
More details about SAP Business One,
email to: sales-enquiry@sterling-team.com or call +6221-5806336 or wa +6287786555055