Report Desk: Column Formatting
Changing Column Format
Column Format Types
|
Format |
Description |
|
AcctNo |
Display a 24-digit account number based on Company setup. For example, if the company uses 4-digit main account and 2-digit profit center, then the value 000012340000005600000000 would be displayed as 1234-56. |
|
AcctMain |
Display just the main part of the account number, based on Company setup. |
|
Accum |
Display in default number format, with thousands separator and the number of decimals specified in the Company record for accumulated totals. |
|
AccumZ |
Display in default number format, with thousands separator and the number of decimals specified in the Company record for accumulated totals, except that a value of zero will not display. |
|
C |
Display using default currency format; negative numbers in parentheses. Also see explanation with D. |
|
C0 to C6 |
Display in currency format with the specified number of decimals, negative numbers in parentheses. Also see explanation with N0 to N6. |
|
Cost |
Display in default number format, with thousands separator and the number of decimals specified in the Company record for cost fields. |
|
CostZ |
Display in default number format, with thousands separator and the number of decimals specified in the Company record for cost fields, except that a value of zero will not display. |
|
CustNo |
Display as a customer number – right-justified and zero filled if numeric; otherwise left-justified. |
|
Bool |
Display as Y or N, depending on whether the value is True or False |
|
D |
Display in default digits format, using numeric digits only. It is used to represent integers with a specified number of characters, providing leading zeroes if needed. See further explanation of D1 to D9 below. You can also reference the following link for more details https://learn.microsoft.com/en-us/dotnet/standard/base-types/standard-numeric-format-strings#DFormatString |
|
D1 to D9 |
Display in digits format, showing the specified number of digits. E.g. "00001234" formatted as D6 would result in "001234". "00001234.123" formatted as D6 would cause an exception because it does not know how to handle the decimal points. So it is used to represent integers with a specified number of characters, providing leading zeroes if needed. If you are not sure if the value will have a decimal point, you should use N0 to N6 to avoid potential error. |
|
Date-6 |
Display a date in MM/DD/YY format. |
|
Date-8 |
Display a date in MM/DD/YYYY format. |
|
DocNo |
Display as a document number – right-justified and zero filled if numeric; otherwise left-justified. |
|
|
Display left justified, removing any left- or right-brackets ( [ or ] ). |
|
FedID |
Display in federal identification number format: nn-nnnnnnn. |
|
File |
Display without any formatting. |
|
GLEntity |
Display the last two parts of an account number, separated by a dash. |
|
GLEntityZ |
Display the last two parts of an account number, separated by a dash, except that nothing is displayed if the last two parts of the account number are zeroes or spaces. |
|
ItemNo |
Display as an item number – left-justified. |
|
N |
Display in default number format, using thousands separator and decimal point. See further explanation in N0 to N6 below. |
|
N0 to N6 |
Display in number format, using thousands separator and decimal point, with the specified number of decimals. E.g. "00001234.123" formatted as N2 will result in "1,234.12". |
|
PONo |
Display as a two-part purchase order number, separated by a dash. |
|
PO25 |
Display left-justified with no additional formatting. |
|
Price |
Display in default number format, with thousands separator and the number of decimals specified in the Company record for price fields. |
|
PriceZ |
Display in default number format, with thousands separator and the number of decimals specified in the Company record for price fields, except that a value of zero will not display. |
|
Quantity or Qty |
Display in default number format, with thousands separator and the number of decimals specified in the Company record for quantity fields. |
|
QuantityZ or QtyZ |
Display in default number format, with thousands separator and the number of decimals specified in the Company record for quantity fields, except that a value of zero will not display. |
|
SlmNo |
Display as a salesperson number – right-justified and zero filled if numeric; otherwise left-justified. |
|
SSN |
Display in Social Security number format: nn-nn-nnnn. |
|
String |
Display without any formatting. |
|
Time-4 |
Display the hours and minutes as HH:MM. |
|
Time-6 |
Display the hours, minutes and seconds as HH:MM:SS. |
|
TrackNo |
Display as a tracking number – left-justified. |
|
UDR |
Display without any formatting. |
|
UPC |
Display as a UPC number – left-justified. |
|
VendNo |
Display as a vendor number – right-justified and zero filled if numeric; otherwise left-justified. |
|
Z |
Display in default number format, with thousands separator and decimal point, except that a value of zero will not display. |
|
Z0 to Z6 |
Display in number format, with thousands separator and the specified number of decimals, except that a value of zero will not display. |
|
ZipCd |
Display left-justified, removing any left- or right-brackets ( [ or ] ). |
|
$ |
Display in default currency format, except that a value of zero will not display ; negative numbers in parentheses. |
|
$0 to $6 |
Display in currency format, showing the specified number of decimals, except that a value of zero will not display ; negative numbers in parentheses . |
Additional Properties (Detail Lines)
- Suppress Duplicates: If the previous row contains the same value as the current row, it will not be printed.
- Preserve format for CSV/XLSX output: Sometimes a numeric number, like "000000" will become simply "0" when exported to XLSX or CSV format. Checking this box ensures that the value will be exported as a string instead, preserving the original value.
- Special formatting for negative numbers: For some reports, typically related to General Ledger, negative numbers, like "-123.45", should be displayed as "123.45 CR". Selecting "CR for Credits" accomplishes this.
- Use bold font: Display the value using a bold font.
- Font size adjustment: This allows the value to be displayed in a larger or smaller font (in 0.25 point increments) than the detail amounts.
- Special formatting for negative numbers: Negative numbers, like "-123.45", can be displayed as "123.45 CR" by selecting "CR for Credits" here.