Migrating Amount Format

Owned by Ravikumar Babu CTOO (Unlicensed)
Last updated: Sept 12, 2019


The information on this page is for the implementation teams who are using the old version of Canvas Technology platform, i.e. CT 14.1 version or lower. For the 14.1 and older versions of the Canvas Technology platform, the AMOUNTMASTER table was used for the Amount format configuration. The AMOUNTMASTER table is deprecated from Canvas Technology 15.1 onwards.

AMOUNTMASTER
AMOUNT_IDAMOUNT_FORMAT
#,###,###.####,###,###.###
#,###.###,###,###.##
###,###,###,###,###.####,##,###.##
###,###,###,###,###.####,###,###.##
##,##,##,##,##,##,###.####,###,###.##
##,##,##,##,##,##,###.######,###,###.##

From CT 15.1 onwards, the following Amount IDs are used instead of '#':

  • INDIA
  • USA
  • EURO
  • UK

The implementation teams that are using CT 14.1 or lower versions and want to migrate to the latest, are instructed to perform any ONE of the following tasks:

  • Migrate your preferences tables, etc. to use the new format IDs that Canvas provides.

OR

  • Disable the new IDs and recreate the old ones as needed.


<?xml version="1.0" encoding="UTF-8"?>
<canvas-formats type = "amount" >
	<format 
		Id = "INDIA" 
		description = "Indian Currency Format" 
		canOverride = "true" 
		isEnabled = "false"
	/>

	<format 
		Id = "USA" 
		description = "US Currency Format" 
		canOverride = "true" 
		isEnabled = "false"
	/>

	<format 
		Id = "EURO" 
		description = "EUR Currency Format" 
		canOverride = "true" 
		isEnabled = "false"
	/>

	<format 
		Id = "#,##,###.##" 
		description = "##,##,###.##" 
		negativeSignPosition = "PREFIX"
		groupSeparator = "," 
		decimalSeparator = "." 
		groupSize = "3" 
		leadingGroupSize = "2" 
		formatter-class = "" 
		client-formatter-class = "" 
		canOverride = "true" 
		isEnabled = "true"
	/>

	<format 
		Id = "#,###.##" 
		description = "#,###,###.##" 
		negativeSignPosition = "PREFIX"
		groupSeparator = "," 
		decimalSeparator = "." 
		groupSize = "3" 
		leadingGroupSize = "3" 
		formatter-class = "" 
		client-formatter-class = "" 
		canOverride = "true" 
		isEnabled = "true"
	/>

	<format 
		Id = "###,###,###,###,###.##" 
		description = "##,##,###.##" 
		negativeSignPosition = "PREFIX"
		groupSeparator = "," 
		decimalSeparator = "." 
		groupSize = "3" 
		leadingGroupSize = "2" 
		formatter-class = "" 
		client-formatter-class = "" 
		canOverride = "true" 
		isEnabled = "true"
	/>

	<format 
		Id = "###,###,###,###,###.###" 
		description = "#,###,###.##" 
		negativeSignPosition = "PREFIX"
		groupSeparator = "," 
		decimalSeparator = "." 
		groupSize = "3" 
		leadingGroupSize = "3" 
		formatter-class = "" 
		client-formatter-class = "" 
		canOverride = "true" 
		isEnabled = "true"
	/>

	<format 
		Id = "##,##,##,##,##,##,###.##" 
		description = "##,###,###.##" 
		negativeSignPosition = "PREFIX"
		groupSeparator = "," 
		decimalSeparator = "." 
		groupSize = "3" 
		leadingGroupSize = "3" 
		formatter-class = "" 
		client-formatter-class = "" 
		canOverride = "true" 
		isEnabled = "true"
	/>

	<format 
		Id = "##,##,##,##,##,##,###.###" 
		description = "###,###,###.##" 
		negativeSignPosition = "PREFIX"
		groupSeparator = "," 
		decimalSeparator = "." 
		groupSize = "3" 
		leadingGroupSize = "3" 
		formatter-class = "" 
		client-formatter-class = "" 
		canOverride = "true" 
		isEnabled = "true"
	/>

</canvas-formats>