Accounts Receivable Default Information Fields

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

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_AR.DAT is the accounts receivable (customer) defaults (Module 1) view of Sage 50's GENERAL.DAT file. Most of the field information for GENERAL_AR.DAT view is entered or displayed in Sage 50's Customer Defaults and Statement/InvoicesDefaults window.

  • To add Sage 50 accounts receivable (customer) default fields to your Crystal reports, select GENERAL_AR.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_AR.DAT file and includes the type and size in number of bytes of each field.

Field Name

Type

Size

Comment

AcctgModule

Integer

For customer defaults, you must specify that Module == 1.

GUID

UBinary

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

LastUpdateCounter

Integer

This increases incrementally when the record is changed.

GL_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.

ARAcctRecordNumber

Integer

Current default A/R account that is used in the Quotes, Sales Orders, Sales/Invoicing, and Receive Money window.

CashAcntRecordNumber

Integer

Current default cash account that is used in the Receive Money window.

DiscAcntRecordNumber

Integer

Discount G/L account set up in Customer Defaults window and used in the Receive Money window when applying receipts to invoices and taking discounts.

TaxAcntRecordNumber

Integer

Current default sales tax G/L account. These accounts are established in the Maintain Sales Tax Authorities window.

NumDaysInBracket0

Integer

Number of days for first aging bracket (column) in aged receivable views and reports.

Note: Aging brackets (categories) for accounts receivable are entered on the Account Aging tab of the Customer Defaults window.

LabelForBracket0

ZString

15

Label for first bracket (column) in aged receivable views and reports.

NumDaysInBracket1

Integer

Number of days for second aging bracket (column) in aged receivable views and reports.

LabelForBracket1

ZString

15

Label for second bracket (column) in aged receivable views and reports.

NumDaysInBracket2

Integer

Number of days for third aging bracket (column) in aged receivable views and reports.

LabelForBracket2

ZString

15

Label for third bracket (column) in aged receivable views and reports.

NumDaysInBracket3

Integer

Number of days for last aging bracket (column) in aged receivable views and reports.

LabelForBracket3

ZString

15

Label for last bracket (column) in aged receivable views and reports.

AgeByDueDate

Integer

1

Aging Invoices By option set up on the Aging tab of the Customer Defaults window

1 (TRUE) => all aging based on invoice due date

0 (FALSE) => all aging based on invoice date.

NextInvoice

ZString

20

The currently next available sales invoice number in the print sequence.

Unused

ZString

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

DunnForBracket0

Integer

Dunning message text for first aging bracket (column) of past due sales balances that prints on customer statements.

Note: Dunning text messages and number of days (brackets) are entered in the Statements/Invoices Defaults window.

DunnAgeBracket0

ZString

79

Number of days for first dunning message bracket of past due sales balances that prints on customer statements.

DunnForBracket1

Integer

Dunning message text for second aging bracket (column) of past due sales balances that prints on customer statements.

DunnAgeBracket1

ZString

79

Number of days for second dunning message bracket of past due sales balances that prints on customer statements.

DunnForBracket2

Integer

Dunning message text for third aging bracket (column) of past due sales balances that prints on customer statements.

DunnAgeBracket2

ZString

79

Number of days for third dunning message bracket of past due sales balances that prints on customer statements.

DunnForBracket3

Integer

Dunning message text for last aging bracket (column) of past due sales balances that prints on customer statements.

DunnAgeBracket3

ZString

79

Number of days for last dunning message bracket of past due sales balances that prints on customer statements.

PrintStmntZero

UBinary

Zero statement balance and print options set up in the Statement/Invoices Defaults window.

78 (ASCII “N”) – Never print zero balance customers.

79 (ASCII “O”) - Only print if other options allow.

65 (ASCII “A”) - Always print zero balance customers.

StmntMinus

UBinary

Negative statement balance and print options set up in the Statement/Invoices Defaults window.

78 (ASCII “N”) – Never print negative balance customers.

79 (ASCII “O”) – Only print if other options allow.

65 (ASCII “A”) - Always print negative balance customers.

StmntPlus

Integer

Positive statement balance and print option set up in the Statement/Invoices Defaults window.

TRUE => Print statements for customers with a balance of at least StmntMin.

StmntOld

Integer

TRUE => Print Statements for customers with invoices at least StmntAge days old.

StmntMin

Float

The minimum balance needed for printing if StmntPlus is TRUE.

StmntAge

Integer

Statement aging requirement for printing for Stmntold

StmntForAnyAct

Integer

Activity option set up in the Statement/Invoices Defaults window.

1 (TRUE) => Print statements for customers with ANY activity.

PrtCompName

Integer

Print option set up in the Statement/Invoices Defaults window.

1 (TRUE) => Print company name and address on invoices and statements.

Terms_DueDays

Integer

Number of days before the invoice becomes past due. This is set up on the Terms and Credit tab of Customer Defaults.

Terms_DiscDays

Integer

Number of days beyond invoice date when discount is still good. This is set up on the Terms and Credit tab of Customer Defaults.

Terms_DiscountPcnt

Float

Percent of total invoice allowed as discount. This is set up on the Terms and Credit tab of Customer Defaults.

Terms_CreditLimit

Float

Total amount of credit extended to customer. This is set up on the Terms and Credit tab of Customer Defaults.

Terms_ChgInterest

Integer

Setting of Charge Finance Charges checkbox on the Terms and Credit tab of Customer Defaults. True => finance charges can be calculated for customer.

Terms_COD

Integer

Setting of COD option on the Terms and Credit tab of Customer Defaults. True => COD allowed for customer.

Terms_Prepay

Integer

Setting of Prepaid option on the Terms and Credit tab of Customer Defaults. True => customer must prepay invoice.

TermDaysAreActual

Integer

TermsDueAtMonthEnd

Integer

Setting of due at end of month option on the Terms and Credit tab of Customer Defaults. True => customer payment due at month's end.

Terms_Unused

ZString

6

IntRevenuePostAcnt

Integer

4

IntOverdueDays

Integer

2

IntonInt

Integer

1

BracketInterestRate1

Decimal

12

BalanceInterestRate1

Decimal

12

IntMinimumCharge

Decimal

12

PrtIntWarn

Integer

1

DontUse1

UBinary

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

FinChargeMessage

ZString

79

Finance charge warning message entered in the Customer Defaults window and printed on sales invoices, if the option is selected.

DefTaxCode

ZString

8

SalesTypeName1[1-27]

ZString

20

Taxable1 [1-27]

Integer

1

TaxableIn1 [1-27]

Integer

1

CustomField_Label1

[1-5]

ZString

16

Text label for customer custom fields.

Note: Labels for customer custom fields are set up on the Custom Fields tab of the Customer Defaults window.

To get the custom field names, you must use a custom formula. Tell me more about this.

CustomField_Enabled1 [1-5]

Integer

1

1=True, 0=False

NextQuote

ZString

20

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

DefSalesAcctRecNum

Integer

4

Default sales account record number entered in Maintain Employees/Prospects, the Sales Defaults tab.

PayMethodDesc1 [1-10]

ZString

20

Payment Method Description, entered on Pay Methods tab of Customer Defaults.

RecentMethodDesc

ZString

20

NextSO

ZString

20

Next Sales Order

szFInChrgShowAs

ZString

20

MerchantKmsKeyId

Integer

4

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

MerchantIdLength

UTinyInt

1

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

MerchantId

Binary

32

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

MerchantKeyLength

UTinyInt

1

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

MerchantKey

Binary

32

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

DepositDateOptions

Integer

4

LastAccountUsed

Integer

4

NextCCM

ZString

20

NextEmailInvoice

ZString

20

NextEmailCCM

ZString

20

NextEmailQuote

ZString

20

CreditStatus

Integer

Setting of the Credit Status option on the Terms and Credit tab of Maintain Customers/Prospects.

DefPrtStatementType

Integer

4

NextProposal

ZString

20

CreditStatusMsg

ZString

250

Credit Status Message entered in the Message field on the Payment/Credit tab of the Maintain Customers/Prospects window.

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?