Customer Maintenance / Customer Inquiry

 Show/Hide All

Customer No.

Enter the customer number representing the customer to add or maintain, or click the Lookup button to list all customer numbers.

Alternately, start typing a customer name to locate a record. As you type, a list of records matching your entry appears. You can then select a record from the list, and the customer number will appear in the field.

• If divisions are set up in Accounts Receivable Options, the first two characters of the customer number must represent a division number.

• If the Accounts Receivable Divisions check box is selected in Account Receivable Options, you can enter up to nine characters.

     Example - Entering Customer Numbers with a Division Number

Enter....	If....
0212345	the division number is 02 and the customer number is 12345. When this customer number is entered, it appears as 02-0012345.
02ACMEAIR	the division number is 02 and the customer number is ACMEAIR. When this customer number is entered, it appears as 02-ACMEAIR.

Note: If divisions are not set up and you enter ALL as the customer number, you will not be able to enter a record for this customer in Line Item Commission Maintenance.

If the customer is on credit hold or has exceeded the credit limit established, the Customer Credit History window appears automatically. If this task is accessed from the Customer Maintenance button in Sage CRM, the customer number can only be viewed.

Click the Next Customer Number button to automatically increment the customer number for a new customer. The Next Customer Number button is available only if the Auto Increment Customer Number check box is selected in Accounts Receivable Options. If divisions are enabled, the Division No. for Next Customer No. window appears after clicking the Next Customer Number button.

Click the Memo button to view, create, or maintain memos. The Memo button is available only if the appropriate memo type has been set up in Memo Manager Maintenance for this task. If a memo already exists for this task, the Memo button appears yellow. If a memo does not exist, the Memo button appears blue. For more information, see Memo Maintenance.

 

Name

Type the customer's name. You can type up to 30 characters.

You must enter a name in this field before selecting the Relate to Sage CRM check box. If you have customer records with a blank Name field when the Relationship Management Wizard is run, and you elect to create new records when no match is found, you may have duplicate records created.  

If the Sage CRM Prospects customer number is entered in the Customer No. field, this field can only be viewed. In Customer Inquiry, this field can only be viewed.

 

1. Main

 

 

Country

Enter the country code, or click the Lookup button to list all country codes.

A country code is needed to ensure that the correct city and state or province are entered based on the ZIP or postal code.

The default country code entered on the Preferences tab in Company Maintenance is entered in this field by default, but you can change it.

If you enter a country code that's not on file, a message asks if it's a new one. Click Yes to open the Country Code Maintenance (On the Fly) window to add the country code.

 

Residential

Select this check box if this customer's address is a residence. Clear this check box if this customer's address is not a residence.

In Customer Inquiry, this field can only be viewed.

 

Address

Enter the customer's address. Click the Map button to view a map of the location in your Web browser.

In Customer Inquiry, this field can only be viewed.

 

Zip/Postal Code

Enter the ZIP or postal code.

If you enter a ZIP or postal code that's not on file, a message asks if it's a new one. Click Yes to open the ZIP/Postal Code Maintenance window and add a new code.

In Customer Inquiry, this field can only be viewed.

 

City

Enter the name of the city. If a known ZIP Code or postal code is entered, the city name automatically appears.

In Customer Inquiry, this field can only be viewed.

 

State/Province

Enter the state or province abbreviation. If a known ZIP Code or postal code is entered, the state or province abbreviation automatically appears.

In Customer Inquiry, this field can only be viewed.

 

Telephone

Enter the customers telephone number starting with the area code. Select the type of phone number in the field to the right.

For countries other than Canada and the United States, the telephone country code is automatically added to the beginning of the phone number based on the country code.

In Customer Inquiry, this field can only be viewed.

 

Ext

Type the customer's extension number. In Customer Inquiry, this field can only be viewed.

 

Fax

Type the customers fax number starting with the area code. The fax number entered defaults to data entry windows, such as Invoice Data Entry. Invoice History Inquiry displays the fax number if it existed on the original invoice before the update.

In Customer Inquiry, this field can only be viewed.

Note The fax number must include the area code to process a fax.

For countries other than Canada and the United States, the telephone country code is automatically added to the beginning of the fax number based on the country code.

 

E-mail Address

Type the customer's e-mail address. Use a semicolon ( ; ) to separate multiple e-mail addresses. Click the E-mail button to launch your e-mail application. The e-mail address entered defaults to the To section of the e-mail.

In Customer Inquiry, this field can only be viewed.

To define electronic delivery options for invoices, statements, sales orders, and RMAs, click the arrow in the top-right corner of the window, and then select Paperless Delivery Options.

 

URL Address

Type the customer's URL address. Click the Web Site button to view the Web site in your Web browser.

In Customer Inquiry, this field can only be viewed.

 

Terms Code

Enter a terms code for the customer, or click the Lookup button to list all terms codes. An entry in this field is required. The default terms code is 00 for no terms.

Type a new terms code to add a term using Terms Code Maintenance (On the Fly).

Click the field hyperlink to launch this field's associated maintenance task. If a value is entered in this field, the associated data is displayed in the maintenance window. The maintenance task can be accessed only with the appropriate security setup.

In Customer Inquiry, this field can only be viewed.

 

Primary Contact

Enter the name of the person to contact regarding billing or invoice payment, or click the Lookup button to list all contact codes for this customer.

Type a new contact to add a contact using Customer Contact Maintenance (On the Fly).

Click the field hyperlink to launch this field's associated maintenance task. If a value is entered in this field, the associated data is displayed in the maintenance window. The maintenance task can be accessed only with the appropriate security setup.

In Customer Inquiry, this field can only be viewed.

 

Ship Code

Enter the shipping method to use (UPS or air freight). If the Sales Order module is integrated with Accounts Receivable, click the Lookup button to list all shipping codes.

Click the field hyperlink to launch this field's associated maintenance task. If a value is entered in this field, the associated data is displayed in the maintenance window. The maintenance task can be accessed only with the appropriate security setup.

For more information, see Shipping Rate Maintenance.

In Customer Inquiry, this field can only be viewed.

 

Primary Ship To

Enter the location code to use as the primary ship-to address for the customer. If the Sales Order module is integrated with Accounts Receivable, click the Lookup button to list all ship-to codes for the customer.

In Customer Inquiry, this field can only be viewed.

 

Salesperson

Enter the salesperson number for the salesperson who regularly sells to this customer, or click the Lookup button to list all salesperson numbers. The salesperson number entered appears when you enter data for this customer, and can be overridden.

• If the Accounts Receivable Divisions check box is selected in Accounts Receivable Options, the division prefix of the salesperson defaults to the division prefix of the customer. This field appears only if the Salesperson Commission Reporting check box is selected in Accounts Receivable Options.

• If divisions are not set up and you enter ALL as a salesperson number to create a salesperson on the fly, you will not be able to enter a record for that salesperson in Line Item Commission Maintenance.

Type a new salesperson code to add a salesperson using Salesperson Maintenance (On the Fly).

Click Split Comm to access the Customer Split Commission Maintenance window, which allows you to enter percentages used to distribute sales order and Sales Order invoice commissions for up to five salespersons.

Click the field hyperlink to launch this field's associated maintenance task. If a value is entered in this field, the associated data is displayed in the maintenance window. The maintenance task can be accessed only with the appropriate security setup.

In Customer Inquiry, this field can only be viewed.

 

Tax Schedule

Enter the tax schedule to use for the customer selected, or click the Lookup button to list all schedules. The sales tax information should be entered for each customer, even if the customer has a tax exemption number, so that nontaxable sales can be reported.

Type a new tax schedule code to add a tax schedule using Sales Tax Schedule Maintenance (On the Fly).

Click Exemptions to open the Tax Exemptions Maintenance window. This task is available only if a tax schedule is defined.

Click the field hyperlink to launch this field's associated maintenance task. If a value is entered in this field, the associated data is displayed in the maintenance window. The maintenance task can be accessed only with the appropriate security setup.

In Customer Inquiry, this field can only be viewed.

 

Tax Exemption No.

Type the tax exemption number. This field is available only if the Sales Tax Reporting check box is cleared in Accounts Receivable Options.

 

Credit Hold

Select this check box if the customer is on credit hold. When the customer number is entered during Invoice Data Entry, the Customer Credit History window appears, along with a CUSTOMER ON CREDIT HOLD message. The ON CREDIT HOLD message appears on the Aged Invoice Report, Cash Expectation Report, Customer Sales Analysis, and Trial Balance Report. Clear this check box if the customer is not on credit hold.

In Customer Inquiry, this field can only be viewed.

 

Credit Limit

Enter the credit limit amount to assign to this customer, or click the Calculator button to enter an amount using the calculator. If no credit limit is assigned, enter zero. You are alerted during Invoice Data Entry when a customer's balance exceeds the credit limit established in this field. This option is available only if Customer's Credit Limit Only, Aging Category Only, or Both is selected in the Credit Limit Checking field in Accounts Receivable Options.

In Customer Inquiry, this field can only be viewed.

2. Additional

 

Comment

Type a comment regarding this customer. You can type up to 30 characters. In Customer Inquiry, this field can only be viewed.

 

Open Item Customer

In Accounts Receivable Options:

• If Mixed is selected in the Open Item or Balance Forward field, select this check box to use the Open Item billing method for this customer. Clear this check box to use the Balance Forward billing method.

• If Open Item is selected in the Open Item or Balance Forward field, this check box appears selected and is skipped.

• If Balance Forward is selected in the Open Item or Balance Forward field, this check box appears cleared and is skipped.

Note You cannot change the status of an open item customer if open invoices exist for the customer. Balance forward customers cannot be changed to open item customers if there are open invoices for the customer. If a customer is changed from an open item customer to a balance forward customer, during period-end processing all invoices for the customer become balance forward in that period.

In Customer Inquiry, this field can only be viewed.

 

Internet Enabled

Select this check box to enable the current customer for processing with the eBusiness Manager module. Selecting this check box classifies the customer as a .order customer. Clear this check box if you do not want to enable the current customer for processing with the eBusiness Manager module. This field is available only if Active is selected in the Customer Status field and the eBusiness Manager module is installed.

In Customer Inquiry, this field can only be viewed.

 

Customer Status

Select a customer status.

• Select Active to indicate this customer is active.

• Select Inactive to indicate this customer is inactive.

Inactive customers are those customers that have stopped placing orders or who are seasonal customers, but for whom you want to keep the customer's information and history. When attempting to inactivate a customer that cannot be changed to Inactive, a message appears. Clicking Details will open the Inactive Status Exception List window with a list of reasons.

Customers cannot be changed to Inactive for the following reasons:

• If repetitive invoices, finance charges, invoices, and cash receipts exist for the customer.

• If the customer is a bill-to customer for a sold-to customer.

• If Accounts Payable from Accounts Receivable clearing entries exist for the customer.

• If the customer is Internet enabled for eBusiness Manager.

• If jobs, billings, and estimates exist for the customer in Job Cost.

• If projected demands exists for the customer in Material Requirements Planning.

• If receipts and returns exist for the customer in Return Merchandise Authorization.

• If sales orders and invoices exist for the customer in Sales Order.

An inactive customer cannot be used in some data entry windows. A message appears stating that the customer is inactive and cannot be used. For a list of data entry windows, see the Display Inactive Customers in ALE Lookups field in Company Maintenance.

• Select Temporary to indicate a temporary customer.

Temporary customers are those with whom you do not expect to do repeat business. During period-end processing, temporary customers with a zero balance are removed from the Customer file based on settings in Accounts Receivable Options. If the Retain Temporary Customers with Paid Invoices check box is selected, and the paid invoices for the customer are older than the value in the Days to Retain Paid Invoices field in Accounts Receivable Options, the paid invoices and temporary customer are purged during period-end processing. If the Retain Temporary Customers with Paid Invoices check box is cleared for a zero-balance temporary customer, the invoices and customer are purged regardless of the number of days to retain paid invoices.

This feature is designed to help preserve file space by eliminating unnecessary records. Temporary customers are retained in the Customer file if a balance remains, or if there are any repetitive invoice entries or open sales orders on file. All permanent customers are retained until intentionally deleted, regardless of the account balance. This option is available only if the Internet Enabled check box is cleared.

In Customer Inquiry, this field can only be viewed.

Click the Encrypt Customer Personally Identifiable Information button to encrypt personally-identifiable information (PII) that is on file for this customer. Once encrypted, the information no longer appears in any Sage 100 windows or reports.

You can encrypt PII only if the customer's status is set to Inactive. If an inactive customer's PII is encrypted, and you change the status to Active or Temporary, the PII is unencrypted and will again appear in Sage 100 windows and reports.

Note When a customer's PII is encrypted, the data entry fields that contain PII are unavailable. However, you can still add new related records, such as contacts and ship-to addresses, for the customer.

For more information, see Encryption for Customer's Information.

 

PII Encrypted

This field displays the date that the customer's personally-identifiable information (PII) was encrypted and can only be viewed. If you unencrypt the PII by changing the customer's status to Active or Temporary, this field is cleared.

This field appears only if the PII is encrypted.

 

Inactive Reason

Enter an inactive reason code or click the Lookup button to list all inactive reason codes. This field is available only if Inactive is selected in the Customer Status field.

Type a new inactive reason code to add an inactive reason using Inactive Reason Code Maintenance (On the Fly).

Click the field hyperlink to launch this field's associated maintenance task. If a value is entered in this field, the associated data is displayed in the maintenance window. The maintenance task can be accessed only with the appropriate security setup.

In Customer Inquiry, this field can only be viewed.

 

Price Level

Enter a price level code to use to establish quantity level discounts. This field can only be viewed, unless the Sales Order module is integrated with Accounts Receivable.

The price level entered in this field will be the default price level used in sales orders and Sales Order Invoice Data Entrywhen price levels set up in Price Level by Customer Maintenance do not apply.

In Customer Inquiry, this field can only be viewed.

 

Default Payment Type

Select the payment type to use as the default choice for sales orders and invoices. Before selecting Credit Card or ACH, you must enter a credit card or ACH account as the primary payment method.

In Customer Inquiry, this field can only be viewed.

 

Discount Rate

Enter the discount rate to establish different discount schedules. This field is for reference purposes only, unless the Sales Order module is integrated with Accounts Receivable. If the Sales Order module is integrated, this field is used to default the discount rate into data entry windows if a customer is selected in the Customer No. field.

In Customer Inquiry, this field can only be viewed.

 

Finance Charge Rate

Enter a finance charge/rate for this customer. If Fixed is selected in the Computation Method field in Accounts Receivable Options, the standard fixed amount previously entered appears. If Percent is selected in the Computation Method field, the standard percentage rate previously entered appears. This field is available only if Fixed or Percent is selected in the Computation Method field in Accounts Receivable Options.

In Customer Inquiry, this field can only be viewed.

 

Item Code

Enter the item code to which this customer's invoices will be automatically distributed, or click the Lookup button to list all item codes.

Alternately, start typing an item description to locate an item. As you type, a list of records matching your entry appears. You can then select an item from the list, and the item code will appear in the field.

The item code entered is used as the default when invoices for this customer are recorded using Invoice Data Entry.

Only items with the Allow Use in Accounts Receivable check box selected in Miscellaneous Item Maintenance can be entered in this field. Type M to enter a charge item if there is no item code set up for this item, or to distribute the sale directly to a general ledger account. Type C to enter a comment line. The comment prints on the customer invoice.

Type a new item code to add an item using Miscellaneous Item Maintenance (On the Fly).

Click the field hyperlink to launch this field's associated maintenance task. If a value is entered in this field, the associated data is displayed in the maintenance window. The maintenance task can be accessed only with the appropriate security setup.

In Customer Inquiry, this field can only be viewed.

 

Default Cost Code

Enter a default cost code for the first data entry line in Sales Order Entry and Sales Order Invoice Data Entry, or click the Lookup button to list all cost codes. After selecting a cost code, the description will appear next to this field.

This field is available only if the Sales Order module is integrated with Job Cost.

In Customer Inquiry, this field can only be viewed.

 

Default Cost Type

Select a default cost type for the first data entry line in Sales Order Entry and Sales Order Invoice Data Entry. The available options are defined in the Valid Cost Types field in Sales Order Options.

This field is available only if the Sales Order module is integrated with Job Cost.

In Customer Inquiry, this field can only be viewed.

 

eInvoice Payments

Select this check box to enable eInvoicing for this customer. eInvoicing is a service that works through Paya Connect to e-mail invoices to your customers. For more information, see eInvoicing.

Clear this check box if you don't want to enable eInvoicing for this customer.

If this check box is selected, the eInvoice Payments check box in A/R and S/O Invoice Data Entry is available and selected by default, but it can be cleared.

If you're using the National Accounts feature, the check box in A/R and S/O Invoice Data Entry is selected based on whether this check box is selected for the bill-to customer. The eInvoices for sold-to customers will be sent to the email address on file for the bill-to customer.

This field is available if the Enable Payments for eInvoices check box is selected in Company Maintenance.

 

Sort

Type the information for sorting reports. This field provides an additional method of sorting customer information on reports. For example, enter an abbreviation of the customer name in this field for alphabetical sorting, or enter an abbreviation of the customers industry to sort reports by similar types of businesses.

In Customer Inquiry, this field can only be viewed.

 

Customer Type

Enter a code to identify the customer type. Use customer type codes to group similar types of customers. For example, if you assign the same code to customers who receive catalogs at the same time, you can specify the customer type for printing the mailing labels. Many reports can also be sorted by customer type.

In Customer Inquiry, this field can only be viewed.

 

Statement Cycle

Enter the code to use in Statement Printing to specify the group of customers for whom statements will be printed. For example, statement cycle M might be used for monthly statements and B for bimonthly statements. Alternately, you could set up a plan where a quarter of the total statements are printed each week. In this case, all customers beginning with the letters A-F could be cycle A (or 1); G-L could be cycle B (or 2); M-R could be cycle C (or 3); and S-Z could be cycle D (or 4).

This field is available only if the Print Customer Statements check box is selected in Accounts Receivable Options.

In Customer Inquiry, this field can only be viewed.

 

Print Dunning Message

Select this check box to print a dunning message (a reminder message for past due balances) on the customer's statement. The actual message to print on the statement is entered in Statement Printing. Clear this check box if you do not want to print a dunning message.

This field is available only if the Print Customer Statements check box is selected in Accounts Receivable Options.

In Customer Inquiry, this field can only be viewed.

 

Batch Fax

Select this check box to include the document in batch faxing. Clear this check box if you do not want to include the document in batch faxing. The setting for this field (whether cleared or selected) defaults to data entry windows. This check box is available only if a fax number is entered in the Fax field.

In Customer Inquiry, this field can only be viewed.

Note The fax number must include the area code to process a fax.

 

Payment ID

Enter a payment ID or click the Lookup button to view all payment IDs on file for this customer. Payment IDs are used to distinguish between multiple credit cards and ACH accounts on file for a customer.

Type a new payment ID to add a new credit card or ACH account using Customer Credit Card and ACH Payment Maintenance (On the Fly).

If a customer has multiple credit cards or ACH payment accounts on file, the payment IDs must be unique; however, two different customers can have credit card or ACH account records that use the same payment ID.

In Customer Inquiry, this field can only be viewed.

 

Payment Type

This field displays the payment type for the selected payment ID and can only be viewed.

 

Name

If an ACH payment ID is entered in the Payment ID field, this field displays the bank name associated with the ACH payment account. If a credit card payment ID is entered in the Payment ID field, this field displays the card holder name. This field can only be viewed.

 

Last Four Routing

This field displays the last four digits of the bank account routing number if an ACH payment method is entered in the Payment ID field. This field can only be viewed.

 

Last Four Digits

This field displays the last four digits of the customer's bank account number if an ACH payment ID is entered in the Payment ID field. The last four digits of the credit card number appear if a credit card payment ID is entered in the Payment ID field. This field can only be viewed.

 

Expiration Date

This field displays the credit card expiration date entered in Paya Exchange if a credit card is entered in the Primary ID field. An expiration warning message may appear, depending on the value entered in the Days Before Credit Card Expiration field in Accounts Receivable Options. A card expired message appears when the credit card expires.

This field can only be viewed.

Click Credit Cards/ACH to add a new credit card or ACH account or edit information for an existing account.

 

Relate to Sage CRM

Select this check box to create a relationship between the selected customer and a Sage CRM company. Clear this check box to delete a relationship between this customer and the Sage CRM company displayed in the Sage CRM Company Name field. Deleting a relationship does not delete the company or customer records; however, it does delete all relationships between related contacts and ship-to addresses for the company and customer.

If the Automatically Create Sage CRM Records When Adding New Customers and Primary Contact check box is selected in CRM Company Options, this check box is selected automatically when a new customer is created. This check box can be cleared only if there are no open sales orders, quotes, or invoices for the related records, and it is not available for the Sage CRM Prospects customer in Sage 100.

 

Sage CRM Company

Enter the company to relate to the selected customer, or click the Lookup button to list all Sage CRM companies without relationships. Click the Suggest Relationship button to view suggested matches in the Suggested Relationships for Customers window.

Click the Next Sage CRM Company button to create a new Sage CRM company and automatically relate it to the selected customer. After the Next Sage CRM Company button is clicked, this field displays *ASSIGN to indicate that the Sage CRM company name will be assigned when the customer information is saved. If you are creating a new customer, and the Automatically Create Sage CRM Records When Adding New Customers and Primary Contact check box is selected in CRM Company Options, this field displays *ASSIGN by default.

This field is available only if the Relate to Sage CRM check box is selected, and no relationship exists for the customer. If a relationship exists for the customer, this field displays the name of the Sage CRM company related to the customer and can only be viewed.

 

3. Statistics

 

Last Payment Date

This field displays the date of the last payment from the customer. You can type a date in this field only with the appropriate security setup. In Customer Inquiry, this field can only be viewed.

 

Last Statement Date

This field displays the date of the last statement issued to the customer. You can type a date in this field only with the appropriate security setup. In Customer Inquiry, this field can only be viewed.

 

Last Finance Charge Date

This field displays the date of the last finance charge to the customer. You can type a date in this field only with the appropriate security setup. In Customer Inquiry, this field can only be viewed.

 

Last Payment Amount

This field displays the dollar amount of the last payment issued to the customer. You can type a payment amount at this field only with the appropriate security setup. In Customer Inquiry, this field can only be viewed.

 

Highest Balance

This field displays the dollar amount of the highest balance to the customer. You can type a balance amount in this field only with the appropriate security setup. In Customer Inquiry, this field can only be viewed.

 

Unpaid Finance Charges

This field displays the dollar amount of the unpaid finance charges. You can type an unpaid finance charge amount at this field only with the appropriate security setup. In Customer Inquiry, this field can only be viewed.

 

Average Days to Pay

This field displays the number of average days to pay and can only be viewed.

 

Average Days Overdue

This field displays the number of average days overdue and can only be viewed.

 

Date Established

This field displays the date the customer was established and can only be viewed.

 

Date of Last Activity

This field displays the date of the last activity and can only be viewed.

 

Credit Hold

This check box is selected if the customer is on credit hold and can only be viewed.

 

Credit Limit

This field displays the credit limit dollar amount and can only be viewed.

 

Aging as Of

These fields display the default aging information based on the system date and can only be viewed. The information in these fields can be different from the aging information on the Invoices tab, because the information on the Invoices tab can be changed based on the invoice date or invoice due date.

4. Summary

 

Fiscal Period

Select a fiscal period from the periods specified in Fiscal Year Maintenance. This field defaults to the current period defined in Accounts Receivable Options.

 

Fiscal Year

Select a fiscal year from the years specified in Fiscal Year Maintenance. This field defaults to the current fiscal year defined in Accounts Receivable Options.

 

Sales

This field displays the sales for the period to date, year to date, and last year based on the period and year selected in the Fiscal Period and Fiscal Year fields. This field can only be viewed.

 

Cost of Goods Sold

This field displays the cost of goods sold for the period to date, year to date, and last year based on the period and year selected in the Fiscal Period and Fiscal Year fields. This field can only be viewed.

 

Percent Profit

This field displays the calculated percent of profit for the period to date, year to date, and last year based on the period and year selected in the Fiscal Period and Fiscal Year fields. This field can only be viewed.

The percentage of profit is calculated as [(Sales - Cost of Goods Sold) / Sales x 100].

 

Cash Received

This field displays the cash received for the period to date, year to date, and last year based on the period and year selected in the Fiscal Period and Fiscal Year fields. This field can only be viewed.

 

No. of Invoices

This field displays the number of invoices for the period to date, year to date, and last year based on the period and year selected in the Fiscal Period and Fiscal Year fields. This field can only be viewed.

 

Finance Charges

This field displays the finance charges for the period to date, year to date, and last year based on the period and year selected in the Fiscal Period and Fiscal Year fields. This field can only be viewed.

 

No. of Finance Charges

This field displays the number of finance charges for the period to date, year to date, and last year based on the period and year selected in the Fiscal Period and Fiscal Year fields. This field can only be viewed.

 

5. History

 

This tab displays sales, cost of sales, profit, amount of cash, payments received, and the number of invoices for the customer for the selected fiscal year and period. Click the Fix button to change the information. The Fix button is available only with the appropriate security setup. Click the Switch View button to view the sales and payment information for the fiscal year selected and for the prior year.

The fiscal years available are defined in Fiscal Year Maintenance.

 

Fiscal Year

Select the fiscal year to view history information for.

 

6. Invoices

 

Invoices List Boxes

The primary list box on the Invoices tab displays all open invoices for the customer. The secondary list box on this tab displays all transactions for the invoice highlighted in the primary list box.

If you've imported payments toward eInvoices from Paya Connect, the last four digits of the credit card or ACH account appear in the Payment Ref column.

Use the buttons located to the right of the list box to search for open invoices, drill down to invoice history inquiry information, and access Aged Invoice Report, Payment Information (Inquiry), and Statement Printing.

For more information, see:

Search for Open Invoices

Invoice History Inquiry

Select a row and click the Export to Excel button to export the contents of the list box to Microsoft Excel. The button is available if Excel is installed on your computer and you have the appropriate security setup.

The aging information located at the bottom of this tab can be recalculated. For more information, see Recalculate Aging.

In Accounts Receivable Options, you can select whether or not to display invoices with zero balances by selecting or clearing the Display Invoices with Zero Balances check box.

 

7. Transactions

 

Transactions List Box

This list box displays all transaction history for the customer for all open invoices.

If you've imported payments toward eInvoices from Paya Connect, the last four digits of the credit card or ACH account appear in the Payment Ref column.

The buttons located to the right of the list box to search for transactions, drill down to invoice history inquiry information, and access Aged Invoice Report, Payment Information (Inquiry), and Statement Printing.

For more information, see:

Search for Transactions

Invoice History Inquiry

Select a row and click the Export to Excel button to export the contents of the list box to Microsoft Excel. The button is available if Excel is installed on your computer and you have the appropriate security setup.

Note In Accounts Receivable Options, you can select whether or not to display invoices with zero balances in the Display Invoices with Zero Balances field.

 

8. S/Os

 

S/Os List Box

Note This tab is available only if the Sales Order module is installed.

This list box displays all open orders (standard and back orders) for the customer. All open orders are displayed sequentially by order number. The order number and date, customer order number, and order amount are shown for each open order. The total amount of open orders for the selected customer also appears.

Use the buttons located to the right of the list box to search for open orders by order number, customer order number, or ship-to location for specific order types, and to access Sales Order Entry.

For more information, see Search for Open Orders.

Select a row and click the Export to Excel button to export the contents of the list box to Microsoft Excel. The button is available if Excel is installed on your computer and you have the appropriate security setup.