General Ledger Default Information Fields

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

Filename: GENERAL_GL.DAT

The GENERAL.DAT file contains default information about your Sage 50 company. It contains rows, but each row is very different in layout from the other rows. GENERAL_GL.DAT is the general ledger (G/L) defaults (Module 4) view of Sage 50's GENERAL.DAT file. Most of the field information for GENERAL_GL.DAT view is recorded behind the scenes for all G/L transactions, including account period and fiscal year setup, journal totals, and various other G/L defaults established by Sage 50.

  • To add Sage 50 general ledger default fields to your Crystal reports, select GENERAL_GL.DAT.

Note: GENERAL.DAT tables cannot be linked to other Sage 50 data tables, but they can be used individually to extract various default information in your Crystal reports.

Indexes and Their Uses

This file has only two keys:

0 = ByModule

1 = By GUID

Fields

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

Field Name

Type

Size

Comment

AcctgModule

Integer

For general ledger defaults, you must specify that Module == 4.

GUID

UBinary

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

LastUpdateCounter

Integer

This increases incrementally when the record is changed.

Version

Integer

Identifies the current version format of your company database.

For Release 8.1, this should be in the range of “15.00” to “11.12."

CurrentPeriod

Integer

Identifies your company's current (internal) accounting period number. Valid values include

15 to 41, where 15 is the first period of this fiscal year, while 29 is the first period of next fiscal year.

Note: Sage 50 internal accounting period numbers differ from what is visible to the user in the application. Also, Sage 50's internal accounting periods include a thirteenth period, which many companies may not use.

NumMonthInYr

Integer

Indentifies the number of accounting periods in a single fiscal year. This is usually 12 or 13.

LastActRecAcctRecNum

Integer

Tells the account number that was used most recently in the Account Reconciliation window.

Unposted_Jrnl1

Integer

Identifies how many unposted transactions are in Journal 1 (Cash Receipts Journal).

Unposted_Jrnl2

Integer

Identifies how many unposted transactions are in Journal 2 (Cash Disbursements Journal).

Unposted_Jrnl3

Integer

Identifies how many unposted transactions are in Journal 3 (Sales Journal).

Unposted_Jrnl4

Integer

Identifies how many unposted transactions are in Journal 4 (Purchase Journal).

Unposted_Jrnl5

Integer

Identifies how many unposted transactions are in Journal 5 (Payroll Journal).

Unposted_Jrnl6

Integer

Identifies how many unposted transactions are in Journal 6 (Cost of Goods Sold Journal).

Unposted_Jrnl7

Integer

Identifies how many unposted transactions are in Journal 7 (Inventory Adjustments Journal).

Unposted_Jrnl8

Integer

Identifies how many unposted transactions are in Journal 8 (Assemblies Journal).

Unposted_Jrnl9

Integer

Identifies how many unposted transactions are in Journal 9 (TempBelowInvAdj Journal). This is a system-generated inventory costing journal that is not seen by the Sage 50 user.

Unposted_Jrnl10

Integer

Identifies how many unposted transactions are in Journal 10 (Purchase Orders Journal).

Unposted_Jrnl11

Integer

Identifies how many unposted transactions are in Journal 11 (Sales Orders Journal).

Unposted_Jrnl12

Integer

Identifies how many unposted transactions are in Journal 12 (Quotes Journal).

Unposted_Jrnl13

Integer

Identifies how many unposted transactions are in Journal 13.

Unposted_Jrnl14

Integer

Identifies how many unposted transactions are in Journal 14.

Unposted_Jrnl15

Integer

Identifies how many unposted transactions are in Journal 15.

YrlyGLPrintedThsYr

Logical

Do not select or use this field.

YrlyGLPrintedNxtYr

Logical

Do not select or use this field.

Unused31 [1-15]

Binary

2

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

Unused_BalPeriod

Integer

2

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

UnusedPriorPeriod

Integer

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

CalendarYear

Integer

Tells the current calendar (payroll) year as in four-digit (YYYY) format.

W2UnprintedThsYr

Logical

TRUE if employee W-2 forms have NOT been printed for the current calendar (payroll) year yet.

W2UnprintedNxtYr

Logical

TRUE if employee W-2 forms have NOT been printed for second open calendar (payroll) year yet.

Ten99UnprntedThsYr

Logical

TRUE if vendor 1099 forms have NOT been printed for the current calendar (payroll) year yet.

Ten99UnprntedNxtYr

Logical

TRUE if vendor 1099 forms have NOT been printed for second open calendar (payroll) year yet.

JournalNeedPost

UBinary

Indicates that journal has not yet been posted.

JrnlsPreserved

Logical

Do not select or use this field.

Periods0FrmDate

Date

4

Beginning date covered by the journal.

Periods0ToDate

Date

4

End date covered by the journal.

Periods1FrmDate [1-41]

Date

4

Start date of Accounting Period [1-41] of the last closed fiscal year.
Don't use Periods14FrmDate or Periods28FrmDate.

Periods1ToDate

[1-41]

Date

End date of Accounting Period [1-41] of the last closed fiscal year.
Don't use Periods14ToDate or Periods28ToDate.

JrnlNeedsPrint1...15

UBinary

Journal (1-15) needs to be printed.

GLNeedsPrint1

UBinary

RoundAcctRecNum

Integer

The G/L rounding account set up the General Ledger Defaults window. This account is used when rounding financial statements to whole dollars to collect rounding errors.

LastRecurNum

Integer

OldestUnPostedTrx

Date

Oldest unposted transaction reference. This is called during Sage 50's purge process.

OldestQuote

Date

Oldest quote date.

OldestPO

Date

Oldest open purchase order date.

LastPostOrderNumber

Integer

Last purchase order number used in the print sequence (currently unused).

RunBatchCosting

Logical

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

BankRecAcntRecNum

Integer

Current default account reconciliation account.

RunBatchCosting

Integer

1

BankRecAcntRecNum

Integer

Current default account reconciliation account.

ContainsInvCostItems

Integer

1

DateLastPurge

Date

Date of the last purge process.

BBEquityAcctRecNum

Integer

The account used to plug general ledger beginning balance entries.

CashAcnt

Integer

RegisterFilter

Integer

SortType

Integer

LastAcntCashAcntReg

SegLength1

Integer

Length of account segment No. 1 set up General Ledger Defaults.

SegmentName1

ZString

10

Name (description) of account segment No. 1 set up General Ledger Defaults.

SegmentSeparator1

ZString

1

Separator used in account segment No. 1 set up General Ledger Defaults.

SegLength1

Integer

Length of account segment No. 2 set up General Ledger Defaults .

SegmentName2

ZString

10

Name (description) of account segment No. 2 set up General Ledger Defaults.

SegmentSeparator2

ZString

1

Separator used in account segment No. 2 set up General Ledger Defaults.

SegLength3

Integer

Length of account segment No. 3 set up General Ledger Defaults.

SegmentName3

ZString

10

Name (description) of account segment No. 3 set up General Ledger Defaults.

SegmentSeparator3

ZString

1

Separator used in account segment No. 3 set up General Ledger Defaults.

SegLength4

Integer

Length of account segment No. 4 set up General Ledger Defaults.

SegmentName4

ZString

10

Name (description) of account segment No. 4 set up General Ledger Defaults.

SegmentSeparator4

ZString

1

Separator used in account segment No. 4 set up General Ledger Defaults.

SegLength5

Integer

Length of account segment No. 5 set up General Ledger Defaults.

SegmentName5

ZString

10

Name (description) of account segment No. 5 set up General Ledger Defaults.

SegmentSeparator5

ZString

1

Separator used in account segment No. 5 set up General Ledger Defaults.

HasPurgedTrx

Ubinary

Indicates if transactions have been purged for each period in the last year
True=transactions have been purged in the period

ArchDateLastPurge

Date

Archives the last purge date

Filler

Binary

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

PR_Filler

Binary

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

W2_Filler

Binary

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

AP_Filler

Binary

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

AR_Filler

Binary

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

Jobs_Filler

Binary

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

Inv_Filler

Binary

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

What do you want to do next?