List of Available Fields (Write Letters)

You can view a list of Write Letters fields for each category listed below and see where these fields are coming from within Sage 50.

Company Fields

Basic Customer Fields

Customer History Fields

Customer Aging Fields

Customer Sales Fields

Customer Shipping Fields

Basic Vendor Fields

Vendor History Fields

Vendor Purchases Fields

Vendor Remit To Address Fields

Employee Fields

Company Fields (Maintain Company Information window)

Field Title	Maps To
Company Name	Company Name
Company Address Line 1	Address Line 1
Company Address Line 2	Address Line 2
Company City	City
Company State	State
Company Zip	Zip code
Company Country	Country
Company Full Address	Lists the company's full address including street address, city, state, zip, and country.
Company Telephone Number	Telephone Number
Company Fax Number	Fax Number
Company Web Site	Web site address
Company Email	Email
Short (m/d/yy)	Sage 50 System Date in the short format: m/d/yy
Long (Month Day, Year)	Sage 50 System Date in the long format Month Day, Year

Basic Customer Fields (Maintain Customers/Prospects window)

Field Title	Maps To
Customer Name	Name
Customer Contact	Bill to Contact--in the form "Title. First MI. Last, Suffix"
Customer Address Line 1	Address line 1 (address taken from bill-to contact)
Customer Address Line 2	Address line 2
Customer City	City
Customer State	State
Customer Zip Code	Zip
Customer Country	Country
Customer Full Address	Lists the customer's full address including street address, city, state, zip, and country.
Customer Telephone Number 1	Telephone 1
Customer Telephone Number 2	Telephone 2
Customer Fax Number	Fax
Customer Email	Email
Customer Web Site	Web Site
Customer Sales Rep Name	Sales Rep Name
Customer Terms	Terms
Customer Credit Limit	Credit Limit
Customer Customizable Field 1	Custom Field #1
Customer Customizable Field 2	Custom Field #2
Customer Customizable Field 3	Custom Field #3
Customer Customizable Field 4	Custom Field #4
Customer Customizable Field 5	Custom Field #5

Customer History Fields (Maintain Customers/Prospects window, History Tab)

Field Title	Maps To
Customer Since	Customer Since date
Customer Last Invoice Date	Last Invoice Date
Customer Last Invoice Amount	Last Invoice Amt.
Customer Last Payment Date	Last Payment Date
Customer Last Payment Amount	Last Payment Amt.
Customer Last Statement Date	Last Statement Date

Customer Aging Fields (Calculated fields, no direct mapping)

Field Title	Description
Customer Balance	Totals everything owed as of the date selected. In batch or SmartPosting mode only posted items will be included in the balance.
Customer YTD Sales Amount	For the current fiscal year, totals all transactions from the sales column on the History tab
Customer Aging Category 1 Summary	Displays the outstanding balance for the first aging period based on settings on the Customer Defaults Account Aging tab and the Write Letters filter "as of" date.
Customer Aging Category 2 Summary	Displays the outstanding balance for the second aging period based on settings on the Customer Defaults Account Aging tab and the Write Letters "as of" date.
Customer Aging Category 3 Summary	Displays the outstanding balance for the third aging period based on settings on the Customer Defaults Account Aging tab and the Write Letters filter "as of" date.
Customer Aging Category 4 Summary	Displays the outstanding balance for the fourth aging period based on settings on the Customer Defaults Account Aging tab and the Write Letters filter "as of" date.
Customer Aging Category 1 Detail	Displays the outstanding open transactions (unpaid and partially paid) for aging period 1 based on settings on the Customer Defaults Account Aging tab and the Write Letters filter "as of" date. The detail field displays Date, Transaction Number, Transaction Amount and Days Overdue.
Customer Aging Category 2 Detail	Displays the outstanding open transactions (unpaid and partially paid) for aging period 2 based on settings on the Customer Defaults Account Aging tab and the Write Letters filter "as of" date. The detail field displays Date, Transaction Number, Transaction Amount and Days Overdue.
Customer Aging Category 3 Detail	Displays the outstanding open transactions (unpaid and partially paid) for aging period 3 based on settings on the Customer Defaults Account Aging tab and the Write Letters filter "as of" date. The detail field displays Date, Transaction Number, Transaction Amount and Days Overdue.
Customer Aging Category 4 Detail	Displays the outstanding open transactions (unpaid and partially paid) for aging period 4 based on settings on the Customer Defaults Account Aging tab and the Write Letters filter "as of" date. The detail field displays Date, Transaction Number, Transaction Amount and Days Overdue.
Customer Aging Balance All Detail	Displays the outstanding open transactions for all outstanding invoices based on settings on the Customer Defaults Account Aging tab and the Write Letters filter "as of" date. The detail field displays Date, Transaction Number, Transaction Amount and Days Overdue.
Customer Total Outstanding Invoices	Total number of outstanding invoices prior to and including the "as of date." Displayed as a single number.

Customer Sales Fields (Maintain Customers/Prospects window)

Field Title	Maps To
Customer Open PO Number	The Open P.O. # field on the Sales Info tab
Customer Ship Via	The Ship Via field on the Sales Info tab
Customer Resale Number	The Resale # field on the Sales Info tab
Customer Credit Card Name	Cardholder's Name from the Payment & Credit tab
Customer Credit Card Address	Cardholder's Address fields from the Payment & Credit tab
Customer Credit Card Number	The Credit Card Number shown on the Payment & Credit tab
Customer Credit Card Expiration Date	The Credit Card expiration date shown on the Payment & Credit tab
Customer Sold Items	Not from specific window; Lists items purchased by the customer during the specified time period. Lists Transaction Date, Transaction Number, Item ID, Short Item description. This field will only show above data if a range of items are selected for Sold Items on the Write Letters filter.

Customer Shipping Fields (Maintain Customers/Prospects window, General/Contacts tabs)

Field Title	Maps To
Customer Ship Name #	Customer Name field on customer record
Customer Ship X Address Line 1	Shipping address for Ship to address number X, line 1
Customer Ship X, Address Line 2	Shipping address line 2
Customer Ship X City	Shipping City for Ship to address number X
Customer Ship X State	Shipping State for Ship to address number X
Customer Ship X ZIP	Shipping ZIP for Ship to address number X
Customer Ship X Country	Shipping Country for Ship to address number X
Customer Ship X Full Address	Combines the shipping address fields for Ship address number X.

Basic Vendor Fields (Maintain Vendors window)

Field Title	Maps To
Vendor Name	Name
Vendor Contact	Contact
Vendor Account Number	Account #
Vendor Address Line 1	Address line 1
Vendor Address Line 2	Address line 2
Vendor City	City
Vendor State	State
Vendor Zip Code	ZIP Code
Vendor Country	Country
Vendor Full Address	Full Vendor Address
Vendor 1099 Type	1099 Type
Vendor Telephone Number 1	Telephone 1
Vendor Telephone Number 2	Telephone 2
Vendor Fax Number	Fax
Vendor Email	Email
Vendor Web Site	Web Site
Vendor Purchase Rep Name	Purchase Rep
Vendor Tax ID Number	Tax ID #
Vendor Terms	Terms
Vendor Customizable Field 1	Custom Field 1
Vendor Customizable Field 2	Custom Field 2
Vendor Customizable Field 3	Custom Field 3
Vendor Customizable Field 4	Custom Field 4
Vendor Customizable Field 5	Custom Field 5

Vendor History Fields (Maintain Vendors, History tab)

Field Title	Maps To
Vendor Since	Vendor Since
Vendor Last Invoice Date	Last Invoice Date
Vendor Last Invoice Amount	Last Invoice Amt
Vendor Last Payment Date	Last Payment Date
Vendor Last Payment Amount	Last Payment Amt

Vendor Purchases Fields

Field Title	Maps To
Vendor Ship Via	Ship Via from Maintain Vendors, Purchase Info tab
Vendor Balance	No direct mapping; the balance calculates based on the date selected in the "as of date" field on the filter options window and is a summary amount totaling everything owed as of the date selected. In batch or SmartPosting mode only posted items will be included in the balance.
Vendor YTD Purchase Amount	No direct mapping; total of all transactions that impact the purchase column on the history tab, based on the "as of date."

Vendor Remit To Address Fields

Field Title	Maps To
Vendor Remit to Address	Remit to Address from Maintain Vendors, Addresses tab

Employee Fields (Maintain Employees/Sales Reps)

Field Title	Maps To
Employee Name	Employee Name
Employee First Name	First Name
Employee Middle Initial	Middle Initial
Employee Last Name	Last Name
Employee Suffix	Suffix
Employee Address Line 1	Address line 1
Employee Address Line 2	Address line 2
Employee City	City
Employee State	State
Employee Zip Code	ZIP
Employee Country	Country
Employee Full Address	Full Employee Address displays
Employee Home Phone	Home phone
Employee Social Security Number	Social Security #
Employee Hire Date	Hired
Employee Email	Email
Employee Custom Field 1	Custom Field 1
Employee Custom Field 2	Custom Field 2
Employee Custom Field 3	Custom Field 3
Employee Custom Field 4	Custom Field 4
Employee Custom Field 5	Custom Field 5
Employee Last Raise Date	In Sage 50 Pro Accounting and Sage 50 Premium Accounting, maps to Last Raise Date field on the General tab. In Sage 50 Premium Accounting and Sage 50 Quantum Accounting, maps to the latest raise date in the Raise History window.
Employee Nickname	Nickname
Employee Work Phone	Work phone
Employee Mobile Phone	Mobile phone
Employee Email 2	Email 2
Employee Division (Sage 50 Premium Accounting and higher)	Division
Employee Location (Sage 50 Premium Accounting and higher)	Location
Employee Department (Sage 50 Premium Accounting and higher)	Department
Employee Most Recent Review Date (Sage 50 Premium Accounting and higher)	Date of the most recent review record from the Performance Reviews window
Employee Next Review Date (Sage 50 Premium Accounting and higher)	Next review date from the Performance Reviews window