1. Click Sales Orders>Inquiries> Customer Inquiry.
2. Specify the customer for which you want to view information in the Customer field.
Optionally, click Change Filters if you want to limit the records that display by warehouse, item type, ship-to or customer return.
Optionally, click Search. You can use the Starts With field to enter the beginning characters for the customer code. If the Start From field in the lower portion of the screen, you can select to display documents by document number or reference number.
3. Select a view.
Select a view from the side bar.
View descriptions
Quotes |
Displays quote information including quote number, quote date, expiration date, warehouse, sales order number (if converted to a sale), the customer for whom the quote was made, who gave the quote and the quote total. Getting more information on a quote: In the view area, select the line and click Line Detail or double click on the icon at the beginning of that line.
|
Sales |
Displays sales order information including document number, document type (work order, invoice, credit memo, counter sale, etc.), document status (work order entered but not printed, work order printed, confirmed invoice, receipted invoice, deleted sales order, voided invoice), document origin, invoice date, warehouse, amount, ship-to and reference number. Sorting open sales orders: Orders sort by document number by default. Click on the Reference number column header to sort by reference number. Click on the Document number column header to sort by document number. You can also click on any other column header to sort by that information.
If the document is on hold, *HOLD* is displayed in the column after the reference number. Documents on hold cannot be printed or confirmed. Any non-deleted or non-voided document may be selected for detail inquiry. Getting more information on an order: In the view area, select the line and click: Status Changes to view the status change log entries for the highlighted document.
|
Past Invoices |
Displays past invoices including SO document number, AR invoice number, document type (work order, invoice, credit memo, counter sale, etc.), document origin, invoice date, warehouse, amount, ship-to and reference number. Sorting past invoices: Click on the Invoice column header to sort by past invoice number or click on the Reference number column header to sort by reference number. You can also click on any of the other column headers to sort by that information.
Getting more information on a past invoice: In the view area, select the line and click: Status Changes to view the status change log entries for the highlighted document.
|
Past Sales |
Displays past sales information for each item number and description. Listed information consists of invoice number and date, document origin, quantity sold and the corresponding unit of measure, price and the pricing unit of measure. Filtering past sales information by item type: Click Options>Filter Views from the menu bar.
|
Pricing |
Displays customer pricing information on items. Listed information consists of item number, item description, the customer’s default price, pricing unit of measure and item type. Highlight aline and click: Orders to display the on order information for existing purchase orders, warehouse transfers or manufacturing tickets for the selected customer and item. Specify the display code: S-sales orders, T-warehouse transfers, M-manufacturing tickets. The display for each document includes: order number, type, status, ordered quantity, received quantity, back-ordered quantity, unit of measure for the quantities, cost and its corresponding unit of measure, the promised date and vendor number for all warehouses. Whse Qtys to display the warehouse quantity information. For the specified item, you can view the available, on-hand, and on-order quantities as well as long- and sort-term surplus and average lead time, in each warehouse. Line Detail to access level pricing, contracts, and past sales information for the customer/item combination. |
Ship-to |
Displays alternate ship-to information from the created in the Ship-To F/M for this customer. This view lists the alternate ship-to numbers, location names, contact 1, and phone number 1. Getting more information on alternate ship-to addresses: In the view area, select the line and click Line Detail or double click on the icon at the beginning of that line. The detail window displays the alternate location’s mailing address, both phone numbers and contact names if provided, salesperson/territory, default ship via code, UPS zone, route code if routes are used in your system, tax code and tax rate as well as any user defined fields entered on the User Defined tab of Ship-To F/M (ARF920).
Press Enter to view detail on the next alternate ship-to for the customer selected. Press F4 to backup to the main inquiry screen. |
CustomerReturns | Displays information on the returns documents for the selected customer.
Use the Change Filters button to select: All Returns, Open Returns, Completed Returns, Returns Waiting on Vendor Action, or Returns Waiting on the Goods for the display. You can also narrow the display by warehouse, item type and ship-to location. |
Blanket Sales Orders |
Displays information on blanket sales orders including document number, hold status, warehouse, entry date, expiration date, completion date, ship-to number and reference number. Sorting blanket sales orders: Orders sort by document number by default. Click on the Reference number column header to resort by reference number. Click on the Document number column header to resort by document number. You can also click on any other column header to sort by that information. If the document is on hold, *HOLD* is displayed to the right of the reference number. Documents on hold cannot be released or distributed. Getting more information on blanket sales orders: In the view area, select the line and click Line Detail or double click on the icon at the beginning of that line.
|
MSDS |
Displays information on Material Safety Data Sheets (MSDS) that were sent to this customer. The information in the view consists of the MSDS ID and ID description, ship-to, date last sent, MSDS revision date and the invoice numbers with which the MSDS sheets were sent. Filtering MSDS information by ship-to addresses: Click Options>Filter Views from the menu. Press F2 to search existing ship-to addresses. Press F3 to select all ship-to addresses for this customer. |
Customer Notes |
Displays customer notes information. |
Lost Sales | Displays lost sales information for each item for the specified customer. Listed information consists of item number and description, Ship-to locations, salesperson information, order entry date and user, and edit date and user. |
Proposals | Displays service proposals entered in the Service & Repair module for the specified customer. Information in the browser includes the proposal number, effective and expiration dates, contact, total amount and reference information. The Line Detail button displays the Service Proposal Inquiry with details for the highlighted line item. |
Contracts | Displays service contracts entered in the Service and Repair module for the specified customer. Information in the browser includes the contract number, effective and expiration dates, contact, total amount and reference information. The Line Detail button displays the Service Contract Inquiry with details for the highlighted line item. |
Doc Routing | Displays routing information for documents entered in the Service and Repair module for the specified customer. Information in the browser includes the account number, document type, doc description, routes, fax number, and email address. |
User-Defined |
The data that is displayed on the User-Defined view of Customer Inquiry comes from the User-Defined view of Customer F/M (ARF910). Many users have a few pieces of information about customers, vendors, and items that are unique to their business that they would like to enter into FACTS for reference purposes. The User-Defined view displays user-defined fields entered the major file maintenances and makes them available in FACTS Inquiry programs for information only. There are 5 user-defined fields that can be entered on the User-Defined screen of Customer F/M). There user-defined field must first be configured by a user that has administrator privileges for User-defined Fields setting on the Security tab of User Code F/M (SMF410).
|
Credit History | Displays tabs for Aging, Payment history and Sales history. • Payment history includes last payment date and grace period. Information also includes both invoices and weighted dollars. Invoice Payment Statistics include the total number of invoices paid, the average number of days to pay, the dollars paid, and the weighted average days to pay are also displayed in accumulated periods. The accumulation of data into periods displays the “Last 03 Periods” , the “Last 06 Periods” and “Last 12 Periods” as the accumulation of data from the current period through the specified periods back from the current period. • Sales history includes the account opening date, last sale date, highest balance date and highest balance. Information also includes sales, cost and gross margin percentage for month-to-date, year-to-date, and prior year. • Aging displays credit history in three categories: the Current date for balances due, Total aging and Disputed. |
Check History | Displays accounts receivable document information by check number. The number of periods check history is kept is dependent on the Check History setting on in AR Static F/M. The Check History view displays check numbers for the highlighted customer along with the check date, check amount, and check memo. |
Ledgercards | Displays all ledgercard information for the selected customer from newest to oldest by default. Information displayed includes entry date, debit amount, credit amount, balance, transaction (register) type, document number and register number of each ledgercard on file for this customer. Click View Doc at the bottom of the screen to display additional document detail information. The system checks to see if detail info exists for currently highlighted ledgercard line for its transaction type. |
Open docs | Displays the open documents for the customer including the document number, type, ship-to number, register number, entry period, date entered, due date, the original amount and the current amount. If the open document was created from SO, the SO document number that the open document applies to is also displayed. |
Paid Doc History | Displays document number, reference number, ship-to number, original amount, original discount amount, entry period, entry register number and removal register number. The documents initially appear in document number order. |
Standard Order | Displays ship-to locations that have standard orders for the specified customer. Highlight a line and click Line Detail to access standard order lines for the specified ship-to/customer combination. |
4. When you are finished reviewing information for customers, close the Customer Inquiry program.