Customer Maintenance / Customer Inquiry

 

Window Details

 

Navigation

 

Overview

 

Fields

 

 

How Do I

 

 

Recalculate Aging

Recalculate High Balances

Create a Relationship between a Customer and a Sage CRM Company

Delete a Relationship between a Customer and a Sage CRM Company

Set Up Paperless Office

 

 

 

Related Topics

 

 

Customer Numbering Methods

Customer Relationship Management FAQs

Sales Tax FAQs

 

 

 

Navigation

To access Customer Maintenance, select Accounts Receivable Main menu > Customer Maintenance.

To access Customer Inquiry, select Accounts Receivable Main menu > Customer Inquiry.

Customer Inquiry fields can only be viewed.

Note When this task is accessed from Sage CRM, the system date is automatically used as the accounting date.

Overview

Use Customer Maintenance to create and maintain detailed records for each of your customers. This task provides several major functions that allow you to set up, maintain, and inquire about customers, including:

If the Customer Relationship Management module is set up, you can create and maintain relationships between customers and Sage CRM companies. You can also maintain the Sage CRM Prospects customer, which is a single shared customer record in Accounts Receivable that allows you to define default information for all Sage CRM prospect companies that are not related to Accounts Receivable customers. The Sage CRM Prospects information is then defaulted into all prospect quotes.

The Sage CRM Prospects customer record in Sage 100 represents multiple prospect companies in the Sage CRM system; therefore, do not enter specific information for this customer record unless it can be used for all prospect quotes.

If a relationship is created between a customer and Sage CRM company, relationships for customer contacts and ship-to addresses can be created separately in Customer Contact Maintenance and Customer Ship-To Address Maintenance. Deleting a relationship between a customer and Sage CRM company automatically deletes the customer contact and ship-to address relationships for that customer and company.

Customer records can be deleted only if there is no outstanding activity for that customer. If there is activity, such as pending orders or e-mails for the customer, you must wait until all open invoices for the customer are paid and purged before you proceed with the record deletion, or use the Delete and Change Customers utility.

Note If a customer with a Sage CRM relationship is deleted, the relationship with the Sage CRM company is deleted, but the Sage CRM company record itself is not deleted from the Sage CRM system. The Sage CRM Prospects customer in Sage 100 cannot be deleted, copied, or renumbered in Customer Maintenance.

Fields

 

Customer No.

Name

   

1. Main

 

Address

E-mail Address

ZIP Code

E-mail Statements

City

URL Address

State

Terms Code

Country

Salesperson

Residential Addr

Ship Code

Primary Contact

Primary Ship To

Telephone

Tax Schedule / Tax Exemption No.

Ext

Credit Hold

Fax

Credit Limit

   

2. Additional

 

Comment

Customer Type

Open Item Customer

Statement Cycle

Internet Enabled

Print Dun Message

Customer Status

Use Sage Data Cloud for Invoice Printing

Inactive Reason

Batch Fax

Price Level

Card ID

Dflt Pymt Type

Payment Type

Discount Rate

Cardholder Name

Fin Charge Rate

Last Four Digits

Item Code

Expiration Date

Default Cost Code

Relate to Sage CRM

Default Cost Type

Sage CRM Company

Sort

 

 

 

3. Statistics

 

Last Payment Date

Average Days Overdue

Last Statement Date

Date Established

Last Finance Charge Date

Date of Last Activity

Last Payment Amount

Credit Hold

Highest Balance

Credit Limit

Unpaid Finance Charges

Aging as Of

Average Days to Pay

 

 

 

4. Summary

 

Fiscal Period

Cash Received

Fiscal Year

No. of Invoices

Sales

Finance Charge

Cost of Goods Sold

No. of Finance Charges

Percent Profit

 

 

 

5. History

 

Sales and Payment History

Fiscal Year

 

 

6. Invoices

 

Invoices List Boxes

 

   

7. Transactions

 

Transactions List Box

 

   

8. S/Os

 

S/Os List Box

 

 

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks