Check numbers with thousand format

Follow

Brianc

• April 05, 2018 17:35

Hi, I notice that check numbers have a thousand separator (comma every three zeros eg 1,000,000- why is this? Shouldn't the field be formatted as text or something without a thousand separator - it doesn't make sense for this number.

0

• 

  Ryan Faulkingham

  • April 05, 2018 17:57

  Hi Brian,

  This is because the underlying field type is "number" and a number type has thousand separators. The check print will not include the comma. 

  If you would like to change this, a formula field can be added to the cash disbursement object with a type of Text and the following formula: 

  Text(AcctSeed__Check_Number__c )

  Thank you,

  Ryan

  0

  Comment actions Permalink
• 

  Brianc

  • April 05, 2018 21:17

  Hi Ryan, does the formatting affect the ability to search. Example if I use the salesforce universal search for cheque number 1234 will it find it? Or can we not search for cheques that way? If not, would be a nice add.

  0

  Comment actions Permalink
• 

  Ryan Faulkingham

  • April 06, 2018 16:24

  Hi Brian,

  I added a field to your cash disbursement so that you can now search for the check number and you don't have to use any commas. Let me know if you have any questions. 

  Thank you,

  Ryan

  0

  Comment actions Permalink
• 

  Jessica Rodriguez

  • February 12, 2020 14:34

  I know this is an older post -- can someone help with this?

  How do I do these check # updates? When I go into the Check # field, I'm unable to change the type to Text or to add a formula to convert it to text. 

  Also, what can I do to make the check number searchable? 

  Thanks!

  0

  Comment actions Permalink
• 

  Halsey Sawyer

  • February 12, 2020 17:54

  Hi Jessica,

   

  Thank you for the question! Please create a case in our Support Portal and our Product Consultants will be able to assist you.

   

  Thank you,

  Halsey

  0

  Comment actions Permalink

Please sign in to leave a comment.