 |
 |
Consolidated Accounts View - Details Page
When you click on the View Record Details icon 
for a specific record on the Consolidated Accounts View Search Criteria/Results Grid page, the Consolidated Accounts View Detail page opens for that record. The information contained on the Detail page includes many more fields than those displayed on the Search Results/Criteria Grid page.
The information on the Details page displays as entered in the Customer Master view (Customer Master or Customer Master-Quick Entry) or Lead Master (Complete or Quick Entry) view.
There are many sections on the Detail page of the Consolidated Account View. The following list defines every field in each section:
Note: The information in the Consolidated Account View is view only and cannot be modified. If you want to edit a field, you must to recall the Customer/Prospect record in the Customer Master (SU13) or the Lead record in the Lead Master and then make the change(s).
- In the Main Context section, the Company, Account ID and Account Type display as reference information for the record you are viewing.
- In the Header Info section:
- Account Name - displays the Account Name associated with the Account ID for the current record.
- Address 1 - displays the first line of the accounts address.
- Address 2 - displays any additional Address information such as Rural Route or Unit/Suite number.
- City - displays the City or town.
- Province/State - displays the Province or State.
- Postal/Zip - displays the Postal Code or Zip Code.
- Country - displays the Country in which the account is located.
- Account Name - displays the Account Name associated with the Account ID for the current record.
- In the Additional Info section:
- Account Status - displays the Accounts Receivable status code for the current record. Valid options include:
- A - Current and Active
- H - Customer On Hold; Orders are taken for this Customer, but are placed on Credit Hold. A warning message displays in OE30/IN41 stating: "Customer status is "H". This Order will go on credit hold". In RS41, the message states, "Customer status is "H". Cash transactions only".
- D - Ready to Delete; the Customer is flagged for deletion. The Customer cannot be deleted from Enterprise in Delete Inactive Customers (SU16) until the Customer is completely inactive, i.e. no Sales Orders or Invoices exist.
- P - Pending Credit Status; Orders are taken for this Customer, but are placed on Credit Hold. A warning message displays in OE30 stating: "Customer status is "P" (Pending). Order will be held." In IN41 and RS41, the message advises that the "Customer status is "P" (Pending)"; you can continue to Invoice the customer.
Note: This field is blank for Prospect and Lead account types.
- A - Current and Active
- Prospect Status
- this field is only available when the CRM module is active. This field represents the status associated with the Prospect. Valid options include:
- Q - Qualified; The prospect is qualified and can now receive Quotes from OE30 and Photo Quotes from IM81.
- A - Archived; The prospect record stays in the system. The SU16 program will not delete prospect records flagged as 'Archived'. This status code allows you to keep the prospect on file for future reference.
- D - Ready to Delete; Flags the prospect for deletion. The next time SU16 runs, the all prospects flagged 'Ready to Delete' will be removed from the system. Caution: SU16 will delete a prospect flagged for deletion even if the prospect has open Quotes in OE30.
Note: This field is blank for Customer and Lead account types.
- Q - Qualified; The prospect is qualified and can now receive Quotes from OE30 and Photo Quotes from IM81.
- Telephone Number - the Phone Number appears exactly as entered in the Customer Master or the Lead Master.
- Fax - the Fax number appears exactly as entered in the Customer Master or the Lead Master.
- Customer Date Opened - the date on which the Customer record is initially created. If the CRM module is activated, this field is also updated when a Prospect is converted to a Customer.
- Prospect Date Opened - this field is only used when the CRM module is active. The Prospect Date Opened is the date on which the Prospect record is initially created. This field is also updated when a Lead is converted to a Prospect in the Lead Master.
- Lead Date Opened - this field is only used when the CRM module is active. The Lead Date Opened is the date on which the Lead record was initially created in the Lead Master. Note: This information is brought into the Customer Master when the Lead is converted to a Prospect, and stays with the record when the Prospect becomes a Customer.
- Account Status - displays the Accounts Receivable status code for the current record. Valid options include:
- In the Accounts Receivable section:
- Paying Office - the Paying Office represents the Customer Code to which Invoices are posted.
- When 'Head Office' pays the Invoices for all stores in a chain, the Head Office is set up as a Customer and the Head Office Customer code is assigned as the Paying Office for each store in the chain.
- The Paying Office field (and not the Customer Code) is used for Credit Limit and Delinquency checks.
- The Paying Office field (and not the Customer Code) is used for the following Accounts Receivable functions: Account Inquiry, Statement of Account and Aging Report.
- Sales statistics are updated using the 'Sold To' Customer Code on the Invoice, not the Paying Office Customer Code for all sales files except Record of Collections (ARRC), where sales are updated per the Paying Office. Sales stored in this file are displayed in Customer Inquiries (SU45/Account Summary) and can be optionally printed on the Overdue Analysis Report (AR83) and the Aging Report (AR84).
- The pricing routing considers the Paying Office when assigning Special Prices. For more information on Price List rules, click here .
Note: The Paying Office is blank for Lead account types.
- When 'Head Office' pays the Invoices for all stores in a chain, the Head Office is set up as a Customer and the Head Office Customer code is assigned as the Paying Office for each store in the chain.
- AR Terms - the standard Invoice (Accounts Receivable) terms. The Terms codes are defined in Maintain A/R Terms (AR03). The standard Terms code is assigned to all Orders and Invoices for the Customer.
- Bank - the Accounts Receivable Bank code.
- The Customer is linked to a Bank code in AR02. The Bank Code identifies the GL Accounts to be updated for domestic and foreign Invoicing and cash receipts. If the Currency Type for the Bank Code is 'Foreign', special processing rules in the Invoicing cycle are executed for exchange purposes. For more information on Foreign Currency Invoicing, click here.
- Credit Limit - the maximum Credit Limit for the Customer.
- When processing Sales Orders, the Credit Limit is compared to the Customer's AR balance PLUS all outstanding orders. If this value is greater than the Credit Limit, the order is placed On Hold and no shipping document is produced until the order is released from the Hold.
- The Paying Office field (and not the Customer Code) is used for Credit Limit and Delinquency Checks.
- When processing Sales Orders, the Credit Limit is compared to the Customer's AR balance PLUS all outstanding orders. If this value is greater than the Credit Limit, the order is placed On Hold and no shipping document is produced until the order is released from the Hold.
- Delinquent Days - the Delinquency Days represent the maximum number of days that an Invoice can be overdue before new Orders or released Back Orders are placed On Hold. The maximum number of Delinquency Days is 999. Note: If you have Invoices that are greater than or equal to 999 days delinquent, Orders will still be put on Delinquency Hold.
- The Invoice Terms are examined to determine the first day of delinquency for an Invoice. For example, an Invoice with Terms=Net 30 days is one day delinquent when the Invoice is 31 days old. If you set the Delinquency Days to 15, you are granting 15 days grace before this account is considered delinquent.
- Delinq. Days = 0 means that Invoices and new Orders are expected to be paid the same day they are processed.
- The Invoice Terms are examined to determine the first day of delinquency for an Invoice. For example, an Invoice with Terms=Net 30 days is one day delinquent when the Invoice is 31 days old. If you set the Delinquency Days to 15, you are granting 15 days grace before this account is considered delinquent.
- Charge Interest - The Interest Code defines the type of Interest charge applied to overdue Invoices. The following are valid codes:
- M - Memo on Statement; Interest is calculated and printed as a memo line on the Statement from Print Statements (AR85). No open item record is generated.
- N - No Interest; No interest is calculated for this customer.
- I - Produce Interest Invoice; Interest is calculated, an open item record is generated, the calculated Interest charge is printed on the Statement (AR85) and a supporting Invoice is printed.
For more information on the calculation of Memo Interest vs Generated Interest Invoices, click here .
- Vendor Code the Vendor Code that the Customer uses to refer to your company, if required. Vendor Codes are maintained in Maintain Vendors (AP13). AR staff can assist the Customer's AP staff in locating the Vendor Code used to pay your Invoices.
- Paying Office - the Paying Office represents the Customer Code to which Invoices are posted.
- In the Order Entry section:
- PO Required - this field indicates whether or not a Customer Purchase Order (PO) number is required during Order/Invoice entry in OE30/IN41 or Enter Cash Counter Invoices (RS41).
- When Yes is displayed, the 'Customer PO' field is mandatory in OE30, IN41, and RS41.
- When No is displayed, the 'Customer PO' field is optional in OE30, IN41 and RS41.
- When Yes is displayed, the 'Customer PO' field is mandatory in OE30, IN41, and RS41.
- Blanket PO Number - the Blanket PO Number is a 'default' or standard Customer PO. When a Blanket PO Number is entered, this number automatically displays in the Customer PO field for every Order and Invoice generated.
- Backorder Acceptance - this field indicates whether or not Back Orders are accepted by the Customer.
- When Yes is displayed, the Customer accepts Back Orders.
- When No is displayed, the Customer does not accept Back Orders. This sets the default for the 'Accept B/O' field in OE30, IN41 and RS41, but you can override the default as required.
- When an Order is entered that includes Back Orders for a Customer that does not accept Back Orders, the back order quantity is still set in the order detail line. When the Invoice is printed and the program detects that this customer does not accept back orders, "B/O" is printed in the Extension column and the following note prints on the bottom of the Invoice: "***Any back ordered product has been cancelled. Please reorder.***". The back order line is automatically cancelled in Schedule Invoices/Credits (IN43).
- When Yes is displayed, the Customer accepts Back Orders.
- BO Release Priority - the Back Order Release Priority field determines the priority for releasing Back Orders. Valid priorities are 0 to 9; the higher the priority code, the higher the priority when Back Orders are released by Release Backorders (OE61) for non-Order Management Customers.
- For Customers running Order Management, releasing Back Orders is incorporated into the Stock Allocation function within Order Management.
- For Customers with the same priority code, OE61 releases Back Orders in date sequence (oldest Back Orders are filled and released first).
- Note: B/O Release Priority is available only when 'Stock Control Method' and 'Backorder Control Method' are set to 'Internal' in CC00/Order Entry.
- For Customers running Order Management, releasing Back Orders is incorporated into the Stock Allocation function within Order Management.
- Order Type - the Order Type set in the Customer or Lead Master and determines the default Order Type that displays in OE30, IN41 and RS41. Valid values include:
- R-Regular
- S-Sample
- F-FOB
- Order Confirmation Required
- this field determines whether or not an Order confirmation is required by the customer.
- When Yes is displayed, an Order Confirmation is required by the customer. Clicking on New in OE30 opens the Print Selection screen allowing you to select the Order Confirmation destination.
- When No is displayed, an Order Confirmation is not required.
- When Yes is displayed, an Order Confirmation is required by the customer. Clicking on New in OE30 opens the Print Selection screen allowing you to select the Order Confirmation destination.
- PO Required - this field indicates whether or not a Customer Purchase Order (PO) number is required during Order/Invoice entry in OE30/IN41 or Enter Cash Counter Invoices (RS41).
- In the Taxes section:
- Tax Group - the Tax Group assigned to this Account. The Tax Group is used by the tax routine to calculate the appropriate Taxes for the Account's Order. Tax Groups are maintained in Maintain Tax Groups (IN06).
- The Tax Group assigned to the Account’s the Customer or Lead Master becomes the default Tax Group used on the Sales Order in OE30/IN41/RS41.
- For an overview of the Tax Set Up, click here.
- The Tax Group assigned to the Account’s the Customer or Lead Master becomes the default Tax Group used on the Sales Order in OE30/IN41/RS41.
- Tax License 1 - the Tax License 1 field is typically used to display the Customer's Goods & Services Tax (GST) License number. Enter an alpha-numeric value in this field to a maximum of 15 characters. The Tax Lic. 1 prints on Customer Invoices.
- Tax License 2 - the Tax License 2 field is typically used to enter the customer's Provincial Sales Tax (PST) License Number. Enter an alpha-numeric value in this field to a maximum of 21 characters. The Tax Lic. 2 prints on Customer Invoices.
- Tax Group - the Tax Group assigned to this Account. The Tax Group is used by the tax routine to calculate the appropriate Taxes for the Account's Order. Tax Groups are maintained in Maintain Tax Groups (IN06).
- In the Statements section:
- Send Statements - the method by which Statements are sent Valid options include:
- F - Fax Statement; this is available when the Fax option within Forms eXpress is available at your site.
- N - Do Not Send Statement; no statements are printed by AR85.
- P - Print Statement; statements are printed in AR85.
- E - E-mail Statement; this is available when the E-mail option within Forms eXpress is available at your site.
- F - Fax Statement; this is available when the Fax option within Forms eXpress is available at your site.
- E-mail Account's Statements to Contact - this field only displays an e-mail contact when Send Statements is set to 'E'.
- Print Message on Statements - this field is set to Yes to have the messages created in Collection/General Messages (AR01) print on the Customer's Statement (AR85). When this field is set to No and the message(s) do not print on the statement.
- Send Statements - the method by which Statements are sent Valid options include:
- In the Invoicing section:
- Send Invoice - identifies the method by which the Invoices are sent. Valid options include:
- S - Send Invoice with Goods; Print Invoices/Credit Notes (IN42) prints an "S" following the Invoice number.
- M - Mail the Invoice Separately; IN42 prints an "M" following the Invoice number.
- H - Hold the Invoice; IN42 prints an "H" following the Invoice number. An example is an Invoice that is only required internally, such as a Cash Sales Invoice.
- F - Fax the Invoice; this option is valid when the Fax option of Forms eXpress is available and when Company Control Initialization (CC00/Forms eXpress) is set up with IN42 as a 'Batch Fax Program'. The Invoice is automatically faxed to the Customer when a fax destination is displayed on the E-mail/Fax/Printer Selection screen in IN42.
- E - E-mail the Invoice; this option is valid when the E-mail option of Forms eXpress is available and when CC00/Forms eXpress is set up with IN42 as an 'E-mail Program'. An E-mail of the Invoice is then automatically sent to the Customer when an e-mail destination is displayed on the E-mail/Fax/Printer Selection screen in IN42.
- S - Send Invoice with Goods; Print Invoices/Credit Notes (IN42) prints an "S" following the Invoice number.
- E-mail Invoice to Contact - the E-mail Contact field is available only when Send Invoice field is set to 'E'.
- Invoice To - identifies the address that prints in the 'Sold To' section on the Order Confirmation and Invoice. Valid options include:
- S - Same as Customer; the Address from the Customer Master (SU13) view. This is the default option.
- P - Paying Office; the Address for the Paying Office associated with the Customer.
- R - Receiving Location; the Ship To Address from the Sales Order for the Customer.
For examples of how the setting of the 'Invoice To' field affects the address printed in the Sold To and Ship To fields on the Shipping Document and Sales Invoice, click here.
Note: The 'Invoice To' field in OE30, IN41 and RS41 automatically displays the value from SU13. You can change the 'Invoice To' field in OE30/IN41/RS41.
- S - Same as Customer; the Address from the Customer Master (SU13) view. This is the default option.
- Number of Invoices to Print - multiple copies of the Invoice can be printed and mailed or sent with the goods. You can print a maximum of 9 copies. The number entered here applies to all Invoices generated through IN42 for this customer.
- If the Send Invoice field is set to 'F' (Fax) or 'E' (E-mail), only one copy of the Invoice is sent regardless of the number of copies entered in this field.
- Note: When a Customer is set up with a Paying Office that is different from itself, the 'Number of Invoices to Print' is taken from the Customer Master record for the Paying Office.
- If the Send Invoice field is set to 'F' (Fax) or 'E' (E-mail), only one copy of the Invoice is sent regardless of the number of copies entered in this field.
- Freight Terms - the Freight terms for the customer. The Freight Terms print on the Invoice. Valid options are:
- PR - Prepaid
- CO - Collect
- PC - Prepaid & Charge
- Commission Rate - the Commission Rate Code for the Customer. Commission Rate Codes are defined in Maintain Commission Groups (SA01). This code represents one of the criteria used in Maintain Commission Rates (SA02). For more information on Commission set up, click here
.
- Ship Via - the Ship Via code for the Customer. Ship Via codes are defined in Ship Via Codes (SU09).
Note: The Ship Via field in OE30/IN41/RS41 automatically displays the value from SU13. You can change the Ship Via option in OE30/IN41/RS41.
- Print Discount on Invoice - this field determines if the discount will print on the Invoice.
- When Yes is displayed, the Discount prints on the Invoice.
- When No is displayed, the Discount does not print on the Invoice.
Note: The calculation for the line discount will be different depending the setting of the Print Discount field. For more details on the Print Discount calculation, click here.
- Send Invoice - identifies the method by which the Invoices are sent. Valid options include:
- In the Payment Processing section:
- Payment Method - when you select a Payment Method in this field, the Payment Method for the 'First Payment' field in OE30/Total, IN41/Total and RS41/Total defaults to that selection. If this field is blank, there is no default setting in OE30, IN41 or RS41 and the operator is required to manually select the Payment Method for the 'First Payment' field.
- EFT (Electronic Funds Transfer) via a credit card - Payment Methods are set up in Maintain Payment Methods (IN08). When you select an EFT option, the credit card associated with the selection displays in the First Payment field in OE30/Total, IN41/Total and RS41/Total.
- On Account - when you select an on account option, 'ON ACCT' displays in the First Payment field in OE30/Total, IN41/Total.
- EFT (Electronic Funds Transfer) via a credit card - Payment Methods are set up in Maintain Payment Methods (IN08). When you select an EFT option, the credit card associated with the selection displays in the First Payment field in OE30/Total, IN41/Total and RS41/Total.
- Level 3 Reporting - when you select 'No', Level 3 Reporting is not invoked for the customer. When you select 'Yes', the Level 3 Reporting tracks the customers that have Procurement Cards and receive Level 3 Reporting. You can also use this field to track customers that have expressed an interest in Procurement Cards and Level 3 Reporting.
- Note: This field does not enable Level 3 Reporting for customers with an automated gateway license.
- Payment Method - when you select a Payment Method in this field, the Payment Method for the 'First Payment' field in OE30/Total, IN41/Total and RS41/Total defaults to that selection. If this field is blank, there is no default setting in OE30, IN41 or RS41 and the operator is required to manually select the Payment Method for the 'First Payment' field.
- The Summary Invoicing module is an optional module in PointForce Enterprise. The following fields are available in the Summary Invoicing section:
- Summary Invoicing - when 'Yes' is displayed, Summary Invoicing is available for the customer; when 'No' is displayed, Summary Invoicing is NOT available.
- The Summary Invoicing option is available in OE30, IN41 and RS41. For an overview of Summary Invoicing, click here.
- Note: Summary Invoicing must also be set up in CC00/Summary Invoicing.
- The Summary Invoicing option is available in OE30, IN41 and RS41. For an overview of Summary Invoicing, click here.
- Summary Invoicing-Avail to Retail Sales
- when 'Yes' is displayed, the Summary Invoice option is active in RS41 for the customer. When 'No' is displayed, the Summary Invoice option is not active in RS41 for the customer.
- This field is only available when the 'Available to Retail Sales' in CC00/Summary Invoicing is NOT selected, indicating that Summary Invoicing is not available to Retail Sales (globally). The Customer Master setting provides an override to the global setting established in CC00.
- When the 'Available to Retail Sales' field in CC00/Summary Invoicing is selected, then Summary Invoicing is already available to Retail Sales (globally). The option to activate Summary Invoicing at the customer level is not required.
- This field is only available when the 'Available to Retail Sales' in CC00/Summary Invoicing is NOT selected, indicating that Summary Invoicing is not available to Retail Sales (globally). The Customer Master setting provides an override to the global setting established in CC00.
- Summary Invoicing-Print Invoices - when 'Yes' is displayed, then Accrual Invoices print for this customer IF the global 'Print Accrual Invoices' flag is set in CC00/Summary Invoicing. When 'No' is displayed, then Accrual Invoices do not print for this customer.
- Note: The Summary Invoicing-Print Invoices field is only available in SU13 when the global 'Print Accrual Invoices' flag in CC00/SI is selected.
- Note: If the global flag is selected but the Customer Master flag is not selected, then Accrual Invoices will NOT print for this customer. If the global flag is NOT selected, Accrual Invoices will never print.
- Accrual Invoices for Pre-Bill Sales Offices always print.
- Note: The Summary Invoicing-Print Invoices field is only available in SU13 when the global 'Print Accrual Invoices' flag in CC00/SI is selected.
- Summary Invoicing - when 'Yes' is displayed, Summary Invoicing is available for the customer; when 'No' is displayed, Summary Invoicing is NOT available.
- In the General Information section:
- Customer Type - Valid options are 0 to 9. This field allows you to separate the GL Accounts for up to 9 different types of Customers.
- The Customer Type is used in combination with the Sales Office and the Product GL Code to determine the specific GL Control Accounts for Sales, Cost of Sales, Inventory and Ticketing Recovery for all Invoices processed through the Invoicing module.
- In CC00/Invoicing/General Ledger, the GL Control Accounts are defined for each combination of the Sales Office (from the Sales Order), the GL code (for the Product), and the Customer Type code. This is also known as the Inventory Sales GL Table or the GL Relating Table.
- Note: When a Customer Master record represents a Warehouse or Store Location to process Warehouse transfers, the Customer Type code must be set to '9'.
- The Customer Type is used in combination with the Sales Office and the Product GL Code to determine the specific GL Control Accounts for Sales, Cost of Sales, Inventory and Ticketing Recovery for all Invoices processed through the Invoicing module.
- Language - the Language code for Sales Order/Invoice headings and Product descriptions. Valid options are:
- E - English
- F - French
- Mailing Label - when 'Yes' is displayed, Mailing Labels for this customer can be printed via Print Customer Listings (SU15). When 'No' is displayed, then Mailing Labels for this customer cannot be printed via SU15.
The Mailing Labels are based on the following information:
- In the Header Info section of the Customer or Lead Master/Details page.
and
- The Attention information from Maintain Customer Attn Master (SU18).
- In the Header Info section of the Customer or Lead Master/Details page.
- Number of Employees - this field is optional. This field displays the number of people employed by the customer. This information can be exported to Excel and used in comparative reporting, or you can use this information for comparative reporting with Crystal Reports. (If you want to export the information in this field to Excel, you will have to personalize the Search Results page to display this field. For more information on personalizing, click here).
- Order Stream Client - when 'Yes' is displayed, this Customer is included in the Inventory update created from Build Customer/Inventory Export Files (ES50). This option is only available to Customers with Order Stream installed.
- Customer Type - Valid options are 0 to 9. This field allows you to separate the GL Accounts for up to 9 different types of Customers.
- In the Sales Grouping section:
- Class of Trade - the Class of Trade (COT) appropriate for the customer. COT codes are defined in the Class of Trade (SU09) view. The COT code categorizes Customers into different market types, for example Wholesale, Manufacturing, major Department Store chains, and Independent Retailers.
The following COT codes have special features within Enterprise:
- CSH - when assigned to the Customer, the COT is associated to the Cash Sale account and is used in processing transactions via RS41. This class of trade will disallow a 'charge' payment type in RS41, thereby forcing payment types of 'cash', 'check' or 'credit card'. No Invoice is posted to the AR sub-ledger for 'CSH' transactions.
- STO - when assigned to the Customer, the COT defines individual locations (Store or Warehouse) and is used to facilitate stock transfers via the Direct Inventory Transfer method in OE30.
- WHS - when assigned to the Customer, the COT defines individual locations (Store or Warehouse) and is used to facilitate stock transfers via the In-Transit Inventory Transfer method in OE30.
- CSH - when assigned to the Customer, the COT is associated to the Cash Sale account and is used in processing transactions via RS41. This class of trade will disallow a 'charge' payment type in RS41, thereby forcing payment types of 'cash', 'check' or 'credit card'. No Invoice is posted to the AR sub-ledger for 'CSH' transactions.
- Territory - the Territory code for this Customer. Territory codes are defined in Territories (SU09). Territory codes are used to categorize Customers into various Sales territories for reporting purposes.
- Sales Group - the Sales Group code for the Customer. Sales Group codes are defined in Sales Groups (SU09). Sales group codes are used to categorize customers into various market groups, such as Eastern States, Central States, etc. for Sales analysis.
- Sales Rep-SU - the Sales Rep code associated with this Customer. Sales Rep codes are defined in Sales Reps (SU09) . The Sales Rep code is used by OE30, IN41 and RS41 to calculate commissions and to capture commission statistics for reporting purposes.
- Sales Office - the Sales Office code for this Customer. Sales Office codes are defined in Maintain Sales Office/Warehouse Numbers
(CC96).
- A Sales Office/Customer Master cross-reference is maintained within PointForce Enterprise (iTopia). This cross-reference enables Customer Sales reports to be printed in Sales Office/Customer sequence. Customers from All or only specific Sales Offices may be selected for reporting.
- The Sales Office is used in combination with the Customer Type code and the Product GL Code to determine the specific GL Control Accounts for Sales and Cost of Sales for all Invoices processed through the Invoicing module. Note: The Invoice's Warehouse assignment is used to determine the Inventory and Ticketing Recovery GL Accounts.
- In CC00/Invoicing/General Ledger the GL Control Accounts are defined for each combination of the Sales Office (from the Sales Order), the GL code (for the Product), and the Customer Type code. This is also known as the Inventory Sales GL Table or the GL Relating Table. For more information on Invoicing and the GL Interface, click here.
- A Sales Office/Customer Master cross-reference is maintained within PointForce Enterprise (iTopia). This cross-reference enables Customer Sales reports to be printed in Sales Office/Customer sequence. Customers from All or only specific Sales Offices may be selected for reporting.
- Class of Trade - the Class of Trade (COT) appropriate for the customer. COT codes are defined in the Class of Trade (SU09) view. The COT code categorizes Customers into different market types, for example Wholesale, Manufacturing, major Department Store chains, and Independent Retailers.
- In the EDI Info section:
- EDI Qualifier - this field is for display purposes only.
- EDI ID Description - this field is for display purposes only.
- Department Code - the Department number for the Customer, if applicable. The department number prints on Sales Orders and Invoices.
- If the Department number is variable, Y displays in this field to indicate that OE30, IN41 and RS41 are to stop for entry in the Department field.
- If this Customer does not use Department numbers, N is displayed in this field. The default is N.
- If the Department number is variable, Y displays in this field to indicate that OE30, IN41 and RS41 are to stop for entry in the Department field.
- Store Code - the store number of the Customer. The store number prints on Sales Orders and Invoices.
- If the Store number is variable, Y displays in this field to indicate that OE30, IN41 and RS41 are to stop for entry in the Store field.
- If this Customer does not use Store numbers , N is displayed in this field. The default is N.
- If the Store number is variable, Y displays in this field to indicate that OE30, IN41 and RS41 are to stop for entry in the Store field.
- EDI Qualifier - this field is for display purposes only.
- In the Internet & Intranet Addresses section:
- Web Address - the Internet Address web page from an external web server for this customer. Click on
to open the web browser and view the page.
- UNC to Client Document Folder - the path to a customer related directory where files pertaining to this customer may exist on your network. Note: A UNC Path is constructed from the name of the server, the name of the share on that server and is followed by any additional subdirectories within the share. For example, \\Server\Share\SubDirectory1\SubDirectory2. The path provided in a UNC type field is not validated by iTopia.
- Intranet - the contact related web page from an internal web server (Intranet) or from a web page stored on your regular server. Click on
to open the web browser and view the page.
- Web Address - the Internet Address web page from an external web server for this customer. Click on
- The Order Management Controls section is only available when Order Management is activated in CC00/Order Entry/Order Management. If Order Management is not activated, these fields are gray.
The fields under the Order Management Controls (except Zone) are used to define the priority assigned to the current Customer's Sales Order. For details on how Order Priority is determined, click here.
The following fields are available in the Order Management Controls section:
- Stock Allocation Priority - the Stock Allocation Priority. Valid options include:
- High
- Medium
- Low
- Apply Credit Weighting - when 'Yes' is displayed, a Credit Limit check is invoked for this customer. If the customer is over their Credit Limit, the appropriate weighting from CC00/Order Entry/Order Management/Priority Weightings is applied. When 'No' is displayed, the Credit Limit check is not invoked.
- Apply Delinquency Weighting - when 'Yes' is displayed, a delinquency check is invoked. If the Customer's account is delinquent, the appropriate weighting from CC00/Order Entry/Order Management/Priority Weightings is applied. When 'No' is displayed, the delinquency check is not invoked.
- Zone - the Zone that represents the location of the customer. Zones are defined in Zones (SU09).
- Stock Allocation Priority - the Stock Allocation Priority. Valid options include:
- In the Pricing section:
- Master Price List - displays the Master Price List for the Customer. Price Lists are defined in Maintain Price Lists (IM18). The Price List must correspond with the Currency associated with the Customer. The Currency field is displayed in the Main Context section of the Details page.
- Pricing Level - the Pricing Level field refers to the Quantity Break Level. The pricing routine uses the Quantity Break Level in conjunction with the Pricing Level entered to determine the base price that is then compared to other possible prices (Specials, Flyers, etc.) in order to calculate the best price for the Sales Order.
- Pricing Level Type - this field and the 'Pricing Level' field (the following field) are used by the pricing routine.
- The pricing routine uses the Pricing Level Type in conjunction with the Pricing Level (Quantity Break Level) entered to determine the base price that is then compared to other possible prices (Specials, Flyers, etc.) in order to calculate the best price for the Sales Order.
Note: The Pricing Level Type is applied to the Master Price List entered for the customer.
The following list defines the valid Pricing Level Type options; you will notice that within each Pricing Level Type, reference is made to the Pricing Level field:
- + Min Level - the Customer receives the Quantity Break Level price indicated and all levels above. For example, you enter a Minimum Level of 2
. The Customer orders a Product that has 3 Quantity Break Levels. Level 1 starts at a quantity of 1 for $17.01, Level 2 starts at a quantity of 12 for $15.00, and Level 3 starts at a quantity of 144 for $14.00. When this Customer orders a quantity between 1 and 143, the Quantity Break Level 2 price is automatically selected. When an order of 144 or greater is entered, the Quantity Break Level 3 price is used. This Customer never receives the Quantity Break Level 1 price.
- - Max Level - the Customer receives the Quantity Break Level price indicated and all levels below. For example, you enter a Maximum Level of 2. The customer orders a Product that has 3 Quantity Break Levels. Level 1 starts at a quantity of 1 for $17.01, Level 2 starts at a quantity of 12 for $15.00, and Level 3 starts at a quantity of 144 for $14.00. When this Customer orders a quantity of 12 or greater, the Quantity Break Level 2 price is automatically selected. When an order of 1 to 11 is entered, the Quantity Break Level 1 price is used. This Customer never receives the Quantity Break Level 3 price.
- # Only Level - the Customer ALWAYS receives the price associated with the Quantity Break Level entered, regardless of the quantity ordered. For example, you enter an Only Level of 2. The customer orders a Product that has 3 Quantity Break Levels. Level 1 starts at a quantity of 1 for $17.01, Level 2 starts at a quantity of 12 for $15.00, and Level 3 starts at a quantity of 144 for $14.00. When this Customer orders any quantity, the Quantity Break Level 2 price is automatically selected. This Customer never receives the Quantity Break Level 1 or 3 price.
Note: For more information on Price List Rules as they relate to Pricing Levels, see point #9 in IM18 Product & Price List Rules.
- Flyers Eligible - when 'Yes' is displayed, the customer is eligible to receive Flyer prices. Flyers are set up in IM8. When 'No' is displayed, the customer is not eligible to receive Flyer pricing.
- Common Quote Eligible - when 'Yes' is displayed, the customer is eligible for Common Quotes. Common Quotes are set up in IM18. When 'No' is displayed, the customer is not eligible to receive Common Quote pricing.
- Master Price List - displays the Master Price List for the Customer. Price Lists are defined in Maintain Price Lists (IM18). The Price List must correspond with the Currency associated with the Customer. The Currency field is displayed in the Main Context section of the Details page.
- In the Best Price Controls-Contracts and Best Price Controls-Specials sections are only available when you are set up for Best Price Controls in CC00/Support. If you are set up for Hierarchy Price Controls in CC00/Support, these sections are not available i.e. these sections are hidden from your view.
iTopia applies 'best price' logic to price Orders. A search through the Pricing module is performed to find the best price available for this Customer. The Best Price Control sections list the type of prices checked during the best price search.
How does Best Price Control work? Here are two examples that illustrate Best Price Control:
- When Best Price Contracts
are in effect, and Customer ABC has a Contract to buy Product 1001 for $5.50/ea as defined in IM18, the system can search through Common Quote pricing, Special pricing, Flyer pricing and Quantity Break Level pricing to find a better price, if all of the selections in the Best Price Controls-Contracts section are set to 'Yes'.
- When Best Price Specials are in effect, and Customer ABC has a special quoted price to buy Product 2001 for $4.25/ea as defined in IM18, the system can search through Common Quote pricing, Special pricing, Flyer pricing and Quantity Break Level pricing to find a better price, if of the seletions in the Best Price Controls-Specials section are set to 'Yes'.
The following fields are available in the Best Price Controls-Contracts section and when set to 'Yes', are included in the best price search:
- Check Contract Price-Contracts - if the Customer has a Contract price for the current Product on the Sales Order, the system searches to see whether a better price exists for the Product on another Contract.
- Check Special Price-Contracts - if the Customer has a Contract price for the current Product on the Sales Order, the system searches to see whether a better price exists for the Product on a Special price list.
- Check Common Quote Price-Contracts - if the Customer has a Contract price for the current Product on the Sales Order, the system searches to see whether the Common Quote price for the Product is a better price.
- Check Flyer Price- Contracts - if the Customer has a Contract price for the current Product on the Sales Order, the system searches to see whether the Flyer price for the Product is a better price.
- Check Master QB Price-Contracts - if the Customer has a Contract price for the current Product on the Sales Order, the system searches to see if there is a better Quantity Break Level price (from the Master Price List) for the Product.
The following fields are available in the Best Price Controls-Specials section and when set to 'Yes', are included in the best price search:
- Check Contract Price-Specials - if the Customer has a Special price for the current Product on the Sales Order, the system searches to see whether a better Contract price exist for the Product.
- Check Special Price-Specials - if the Customer has a Special price for the current Product on the Sales Order, the system searches to see whether a better price exists for the Product on another Special price list.
- Check Common Quote Price-Specials - if the Customer has a Special price for the current Product on the Sales Order, the system searches to see whether the Common Quote price for the Product is a better price.
- Check Flyer Price-Specials - if the Customer has a Special price for the current Product on the Sales Order, the system searches to see if there is a better Flyer price for the Product.
- Check Master QB Price-Specials - if the Customer has a Special price for the current Product on the Sales Order, the system searches to see if there is a better Quantity Break Level price (from the Master Price List) for the Product.
- When Best Price Contracts
are in effect, and Customer ABC has a Contract to buy Product 1001 for $5.50/ea as defined in IM18, the system can search through Common Quote pricing, Special pricing, Flyer pricing and Quantity Break Level pricing to find a better price, if all of the selections in the Best Price Controls-Contracts section are set to 'Yes'.
- The CRM section is only available when the CRM module is active in PointForce iTopia. If CRM is not active, these fields are unavailable. The following fields are available in the CRM section:
- Account Manager - the CRM Account Manager for this Prospect or Customer. If this field was completed in the Lead Account Master view prior to the Lead becoming a Prospect or Customer, this information automatically moves over to the Customer Master.
- The Account Manager information is maintained in the CRM Account Manager table, in the CRM module.
- CRM Teams - the CRM Team for this Prospect or Customer. CRM Teams can be based on regional divisions or territories as an example. If this field was completed in the Lead Account Master view prior to the Lead becoming a Prospect or Customer, this information automatically moves over to the Customer Master.
- The CRM Teams information is maintained in the CRM Teams table, in the CRM module.
- Projected Close Date - the calendar the date on which the Customer/Prospect is anticipated to close. If this field was completed in the Lead Account Master view prior to the Lead becoming a Prospect or Customer, this information automatically moves over to the Customer Master.
Note: The Projected Close Date along with the 'Probability %-Account' and 'Potential Sales $' fields are used to produce Account Pipeline statistics views that can be found under the Customer Relationship Management/CRM Report Views folder.
- Probability % - Account - the percentage likelihood that this Prospect will become a Customer with an active account. If this field was completed in the Lead Account Master view prior to the Lead becoming a Prospect or Customer, this information automatically moves over to the Customer Master. Valid values include:
- 0%
- 10%
- 25%
- 50%
- 75%
- 90%
- 100%
Note: The Probability %-Account along with the 'Projected Close Date' and 'Potential Sales $' fields are used to produce Account Pipeline statistics views that can be found under the Customer Relationship Management/CRM Report Views folder.
- Potential Sales $ - the potential dollar value associated with the initial sale that converts the Prospect to a Customer. If this field was completed in the Lead Account Master view prior to the Lead becoming a Prospect or Customer, this information automatically moves over to the Customer Master.
Note: The Potential Sales $ along with the 'Projected Close Date' and 'Probability %-Account' fields are used to produce Account Pipeline statistics views that can be found under the Customer Relationship Management/CRM Report Views folder.
- Initial Campaign
- the initial campaign that initiated the sale for the Prospect or Customer. If this field was completed in the Lead Account Master view prior to the Lead becoming a Prospect or Customer, this information automatically moves over to the Customer Master.
- The Campaign codes are maintained in the CRM Campaign table, in the CRM module.
- Initial Trade Show - the initial Trade Show Code that kicked off the sale for the Prospect or Customer. If this field was completed in the Lead Account Master view prior to the Lead becoming a Prospect or Customer, this information automatically moves over to the Customer Master.
- Initial Trade Show codes are maintained in the CRM Trade Show table in the CRM module.
- Sales Source - the sales source, for example a trade show, campaign, employee, website, etc. that was the source for the initial sale. If this field was completed in the Lead Account Master view prior to the Lead becoming a Prospect or Customer, this information automatically moves over to the Customer Master.
- The Sales Source codes are maintained in the CRM Sales Source table, in the CRM module.
- Sales Stage - the Stage within the sales cycle the Prospect/Customer is in. For example the customer may be a 'New' prospect, a 'Converted' prospect or 'Assigned' to a customer service rep. If this field was completed in the Lead Account Master view prior to the Lead becoming a Prospect or Customer, this information automatically moves over to the Customer Master
- Sales Stage codes are maintained in the CRM Sales Stage table, in the CRM module.
- Sales Status - the Status in the sales cycle that the Prospect/Customer is in. For example, the Sales Status for a Prospect may be 'In Process', or a 'New Sales Deal', or a 'Closed Deal'. If this field was completed in the Lead Account Master view prior to the Lead becoming a Prospect or Customer, this information automatically moves over to the Customer Master.
- Sales Status codes are maintained in the CRM Sales Status table, in the CRM module.
- Contact Method Preferred - the method by which the Prospect or Customer prefers to be contacted. For example, the Prospect or Customer may prefer to be contacted by e-mail or telephone. If this field was completed in the Lead Account Master view prior to the Lead becoming a Prospect or Customer, this information automatically moves over to the Customer Master.
- Contact Method Preferred codes are maintained in the CRM Contact Method table, in the CRM module.
- NAICS Code - the NAICS code for this Customer. NAICS is the North American Industry Classification System. If this field was completed in the Lead Account Master view prior to the Lead becoming a Prospect or Customer, this information automatically moves over to the Customer Master.
-
NAICS is used by business and government to classify and measure economic activity in Canada, Mexico and the United States.
- The NAICS numbering system is a 6-digit code that is maintained in the CRM NAICS Code table, in the CRM module.
-
NAICS is used by business and government to classify and measure economic activity in Canada, Mexico and the United States.
- SICS - the SIC code for the Customer. SIC is the Standard Industrial Classification code or system which is used by the US government for classifying industries with a 4-digit code. If this field was completed in the Lead Account Master view prior to the Lead becoming a Prospect or Customer, this information automatically moves over to the Customer Master.
- SIC was replaced by the NAICS system in 1997, but some US government agencies still use SIC codes.
- The SIC codes are maintained in the CRM SIC Code table, in the CRM module.
- SIC was replaced by the NAICS system in 1997, but some US government agencies still use SIC codes.
- Account Manager - the CRM Account Manager for this Prospect or Customer. If this field was completed in the Lead Account Master view prior to the Lead becoming a Prospect or Customer, this information automatically moves over to the Customer Master.
- In the System section, the fields are available for information purposes only and cannot be edit:
- Creator - displays the user id of the user logged into the system when the Customer Master record was created.
- Date/Time Created - displays the date and time at which the Customer Master record was created.
- Modifier - displays the user id of the user logged into the system when this Customer Master record was last updated.
- Last Change - displays the date and time at which the Customer Master record was last updated.
- Creator - displays the user id of the user logged into the system when the Customer Master record was created.
For information on the functionality of each button on the Consolidated Accounts View Details page, click here.
