Chart of Accounts Fields

The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.

Filename: CHART.DAT

CHART.DAT is the chart of accounts file. It lists all account records listed in your company's chart of accounts and general ledger. Most of the information below is entered or displayed in Sage 50's Maintain Chart of Accounts window. Account debit and credit totals are used in many business reports and financial statements.

  • To add Sage 50 chart of account fields to your Crystal reports, select CHART.DAT.

Indexes and Their Uses

CHART.DAT has six keys, as follows:

0 = By AccountID. This index is most useful for sorting records by account ID.

1 = By Account Type and then by Description.

2 = By Description.

3 = By AccountRecordNumber. Use this key to link accounts with other tables.

4 = AccountIsInactive and then by AccountID.

5 = By GUID.

Fields

The following table shows the fields available in the CHART.DAT file and includes the type and size in number of bytes of each field.

Field Name

Type

Size

Comment

GLAcntNumber

Integer

4

Account number entered in the Maintain Chart of Accounts window. This field is an index and used to link other tables to the Chart of Accounts table. The field is unique and cannot change.

AccountID

ZString

15

Account ID entered in the Maintain Chart of Accounts window. Account IDs are listed in the company's chart of accounts and general Ledger and referenced in many Sage 50 records and transactions.

The Account ID data field is unique and cannot change.

AccountType

UBinary

Account type selected for each account ID entered in the Maintain Chart of Accounts window. This field is used for two main purposes:

  • If the account is an “income statement” type, then it is closed during posting.
  • If it is the one and only Retained Earnings account, it gets all the closing amounts.

Also, financial statements are usually designed to depend on account types to format properly.

Valid account types include:

0 => Cash

1 => Receivable (Accounts Receivable)

2 => Inventory

3 => Unused1 (Do not select) OR

3 => Receivables Retainage (Sage 50 Quantum Accounting)

4 => OthCurAsset (Other Current Assets)

5 => FixedAsset (Fixed Assets)

6 => AccumDepr (Accumulated Depreciation)

7 => Unused2 (Do not select)

8 => OtherAssets (Other Assets)

9 => Unused4 (Do not select)

10 => Payable (Accounts Payable)

11 => Unused5 (Do not select) OR

11 => Payables Retainage (Sage 50 Quantum Accounting)

12 => OthCurLiability (Other Current Liabilities)

13 => Unused6 (Do not select)

14 => OthLiability (Long Term Liabilities)

15 => Unused7 (Do not select)

16 => EquityNoClose (Equity - Doesn't Close),

17 => Unused8 (Do not select)

18 => RetEarn (Equity - Retained Earnings

19 => EquityClose (Equity - Gets Closed))

20 => Unused9 (Do not select)

21 => Income

22 => Unused10 (Do not select)

23 => CostSales (Cost of Sales)

24 => Expense

AccountDescription

ZString

30

Account description entered in the Maintain Chart of Accounts window.

AccountIsActive

Logical

The Inactive check box in the Maintain Chart of Accounts window. Valid choices include:

True = if the account record is inactive.

False = if the account record is active.

GUID

UBinary

16

GUID (Globally Unique Identifier) used for linking the Chart table.

Balance0Dr [0-41]

Decimal

12

G/L balance debit total for the selected period. Period 0 = Beginning Balances; Period 1=Last Year, first period; Period 14 = Last Year's balances; Period 15 = This year, period 1;Period 29 = Next Year, Period 1.

About Last Year (Closed) Period Debit/Credit Totals: Closed periods have amounts in them for income statement accounts and the one and only retained earnings account.

Balance0Cr [0-41]

Float

G/L credit balance for the selected period. Period 0 = Beginning Balances; Period 1=Last Year, first period; Period 13 = for companies with 13 fiscal periods; Period 14 = Last Year's balances; Period 15 = This year, period 1; Period 29 = Next Year, Period 1.

Balance0Net [0-41]

Float

G/L net total for the selected period. Period 0 = Beginning Balance; Period 1=Last Year, first period; Period 14 = Last Year's balances; Period 15 = This year, period 1; Period 29 = Next Year, Period 1.

TaxCode

Zstring

12

Do not select or use this field. It is used by Sage 50 for internal reasons.

NextCheckNumber

Zstring

20

The next check number to be used in a print cycle for the selected G/L account ID. This field is usually only relevant for cash accounts.

GL1099Index

UBinary

Tells which types of 1099 payment types are set up to draw cash payments for the current account. These payment types are reflected on the 1099 Settings tab of Vendor Defaults.

ReceiptNum

ZString

20

Next cash receipt number for this cash account.

LastDepositTicket

ZString

8

Last deposit ticket ID used for a deposit made in the Select for Deposit window.

NextEmailReceipt

ZString

20

Number of the next receipt emailed to a customer from the Sage 50 Receipts window.

LastUpdateCounter

UBinary

This increases incrementally when the record is changed.

What do you want to do next?