ARSLMMNT Accounts Receivable Salesman File Maintenance

Salesman File Maintenance

Application Overview

 

You will use the Salesman File to keep a file of all of the salespersons you employ.  There are many places in the Accounts Receiv­able package where this file is very useful.  Here are a few of them.

 

When sales transactions are processed, the amount of the commission to be paid to the salesperson is recorded in the Commissions Due file.  Later on, you can print the Commissions Due Report which details what commissions are due each salesperson.  To make this type of reporting possible, it is necessary for you to enter during Sales & CR/DR Memo Processing the number of the salesperson responsible for the sale.  The Salesman record will then be obtained from the Salesman file and the salesperson's name will be displayed so you can ensure that you have entered the correct salesperson number.

 

The Salesman file will also be used in the Customer Order Processing package.  When customer orders are entered, you also enter the number of the salesperson responsible for the sale.  The Customer Order Processing programs can calculate the commission due the salesperson, using the table of customer types and commission percents that you enter as part of the data for each salesperson. This is done by looking through the table for a customer type which matches the type of the customer whose order you are processing.  If a matching customer type is found, the corresponding commission percent is used to calculate the amount of commission the salesperson is to receive. This information is then passed from the Customer Order Processing package to the Accounts Receivable package. Customer Order Processing has the ability to calculate commission by item based on data in Customer Order Processing Setup and the Inventory Maintenance Item file.

 

The amount of sales that the salesperson is responsible for is stored in each Salesman record, so that the Sales Analysis by Salesman Report can be produced.  This report will allow you to see what percen­tage of total sales is being contributed by each salesperson.

 

When you are entering customers into Elliott, you will be requested to enter the number of the salesperson most usually associated with each customer.  This entry will be the default salesperson used by other applications.  That is, when other programs ask you to enter a salesperson number, those programs will know who the usual salesman is and will be able to show you that salesperson number and allow you to select it easily.  You will also be able to enter some other salesperson number in place of the default salesperson number, if you should wish.


Run Instructions

 

Select Salesman File from the pull down A/R Maintenance window.  The following screen will then be displayed:

 


 

Maintenance Entry Screen

 

 

 

The following options are available:

  • Add new salesmen
  • Change existing salesmen
  • Delete existing salesmen
  • Print a salesman listing with commission percentages and YTD, PTD figures

 

To return to the menu bar, press the ALT or F10 key.  To leave this application, press ESC or X for EXIT when positioned at the menu bar.


Entry Field Descriptions

 

First Screen

 

Name

Type and Description

1.  Salesman No

3 alphanumeric characters.

Enter the number you want to represent the salesperson.  This salesperson number can contain alphanumeric characters as well as purely numeric digits.

For example, you might make your salesperson numbers something easy to remember, like Bob or Jan.  Or, you might use the salesperson's initials as the salesperson's number.  On the other hand, you might just want to use numeric salesperson numbers like100 or 250.  In the change or delete mode, press the F7 key to search by the salesman number.

2.  Name

30 alphanumeric characters.  Lower case letters are allowed.

Enter the salesperson's name.

3.  Initials

3 alphanumeric characters.

Enter the salesperson's initials.

4.  Address

30 alphanumeric characters.  Lower case letters are allowed.

Two lines of 30 alphanumeric characters are allowed for entry of the salesperson's address.

5.  Phone No

12 alphanumeric characters.

Enter the salesperson's phone number.  Twelve characters are provided so that you can enter hyphens into the number if you wish.  For example, 614‑382‑5999.

6.  Territory

30 alphanumeric characters.

Lower case letters are allowed.     Enter the territory that the salesperson is responsible for.

7. E-Mail

Enter an e-mail address, if applicable.


Neither the salesperson's initials nor his territory are used by any programs in the Accounts Receivable package at this time, but if you want to put them to some use they will be available to you in the file. These fields do appear on the Salesman File List for your reference.

 

The next several fields on the screen are a table of customer types and commission percentages.  These fields are used in the Customer Order Processing package to calculate the amount of commission that is due a salesperson as the result of a sale.  The programs look through this table of customer types for a matching customer type of the customer whose order is being processed.  If a matching type is found, the corresponding commission percent is used to calculate the commission amount.  You will still be given the opportunity to override this commission percentage and enter some other value, if you should desire to do so.

 

Name

Type and Description

8. – 17.  Cust Type

5 alphanumeric characters.

Enter the customer type to be used in calculating a salesperson’s commission as explained above.  Any blank customer types that you enter will be removed from the table of customer types before the record is stored in the Salesman file.  So, if you are changing a Salesman record and want to remove an entry from the table of customer types, just change the customer type to blank.

Comm Pct

5 numeric digits with 3 decimal places (99.999).

Enter the commission percent, which corresponds to the customer type on the left, to be used in calculating the commission amount as explained above.

 

Second Screen

 

Name

Type and Description

1.  Sales Ptd

11 numeric digits with 2 decimal places and an optional minus sign (999,999,999.99-).

Enter the amount of the sales­person's sales so far this period.

2.  Sales Ytd

11 numeric digits with 2 decimal places and an optional minus sign (999,999,999.99-).

Enter the amount of the salesperson's sales so far this year.

3.  Sales Last Yr

11 numeric digits with 2 decimal places and an optional minus sign (999,999,999.99-).

Enter the amount of the salesperson's sales for last year.

4.  Cost Ptd

11 numeric digits with 2 decimal places and an optional minus sign (999,999,999.99-).

Enter the cost of the sales the salesperson has made so far this period.

5.  Cost Ytd

11 numeric digits with 2 decimal places and an optional minus sign (999,999,999.99-).

Enter the cost of the sales the salesperson has made so far this year.

6.  Fin Chg Ytd

11 numeric digits with 2 decimal places and an optional minus sign (999,999,999.99-).

Enter the amount of finance charges the salesperson has incurred so far this year.

7.  Comm Ptd

9 numeric digits with 2 decimal places and an optional minus sign (9,999,999.99

-). 

Enter the amount of commissions the salesperson has earned so far this period.

8.  Comm Ytd

9 numeric digits with 2 decimal places and an optional minus sign (9,999,999.99

-).              

Enter the amount of commissions the salesperson has earned so far this year.

 

 

The fields entered on screen 2 of Salesman File Maintenance are updated every time sales transactions are processed.  They can be cleared to zero using the Clear A/R Accumulators application.  For this reason, the operator will ordinarily not be able to change these fields in change mode.  When these fields are displayed, this message will also be displayed.

 

Changes To These Fields Not Allowed Press "Return"

 

However, if you do find it necessary to make corrections to data that was entered in error, there is a way to do it.  When the above message is displayed, press Control-O to overwrite the value.  You will then be able to make changes to these fields in the same way as any other fields are changed, provided you have answered the change protected fields question in A/R Setup as Y.

 

 

 

Salesman File Maintenance – Screen 2

 

  

 

Elliott V7.3 Salesman Security

 

To enable Salesman Security in Elliott, you need to perform the following setup:

 

1.       Identify the user as a salesman in Password Setup for that user.  If you leave the Salesman No blank, then it implies this person is not subject to salesman security.  (For example, this maybe an accounting person who needs to access all salesman records).


 


2.       Determine whether there should be house account that all Salesmen can access in Global Setup for eContact Manager.  A house account is usually a customer that doesn’t have a specific salesman and any salesman can go after the house account.  As of this writing (05/12/05), the house account logic only applies to eContact Manager, eContact Processor and Export Processor.  We plan to apply the House Account logic to A/R and COP as well.


 

3.       The following flag is for Global eContact Manager.  You need to determine if a particular salesman is subject to the Salesman Security in eContact manager.


 

4.       The following flag “Disable Salesman View Other’s Customer in A/R” is used for

  • A/R Customer File Maintenance
  • A/R Customer File Inquiry
  • A/R Account Inquiry
  • A/R Summary Account Inquiry
  • eContact Processor (AR Files & Ship to)
  • Export Processor (AR Files & Ship to)

You need to determine if a particular salesman is subject to the salesman security in the above areas.


 

5.       The following flag “Disable Salesman Inquiry For Other’s in COP” is used in

  • COP Order Inquiry
  • COP Invoice History Inquiry
  • COP Stock Status Inquiry
  • COP Recurring Order Inquiry
  • COP Freight Calculation Inquiry
  • eContact Processor
  • Export Processor (COP Files, except Ship-To). 

You need to determine whether the salesman is subject to salesman security in the above areas.


 

6.       You also want to limit the activities that a salesman can do in Elliott.  The following are areas in Elliott that salesman security is implemented:

            A/R Customer File Maintenance

            A/R Customer Inquiry

            A/R Customer Account Inquiry

            A/R Summary Account Inquiry

            COP Order Inquiry

            COP Invoice History Inquiry

            COP Recurring Order Inquiry

            COP Stock Status Inquiry

            COP Freight Calculation Inquiry

            COP Order Entry

            COP Sales Desk (Add Other’s Orders, No Control on Change Quote)

            COP Order Edit List (VA,46)

            COP Order Acknowledgement/Email (not Laser Form) (VA,46)

            COP Order Quote/Email (not Laser Form) (VA,46)

            COP Open Order by Salesman (VA,46)

            eContact Manager

            eContact Processor

            Export Processor

We suggest you restrict the Salesman beyond these menu items.  For example, if you wish to let Salesmen print reports for their own customers, you do not want to give them the “Order Status Reports” menu item since there is no salesman security in that area.  Instead, you might consider giving your salesmen access to “Export Processor” where salesman security is implemented.

 

The following flags determine whether the user can use eContact/Export Processor


 

There is a separate flag for “Disable Interaction w/ eContact & Export Proc” because you may want certain people to use the “eContact/Export Processor” in batch mode without allowing them to use the interaction mode, where they can access more information.

 

Before you decide a user’s security for eContact, customers and sales orders, you should consider the following factors:

  • Is this user a salesman?  Do you want to limit this user to access only those eContacts that he/she is a salesman?
  • Do you have a house account?  Do you allow house account information to be accessed by all salesmen if the previous answer is “yes.”
  • Will this user use Global eContact?  Global eContact is like a Rolodex where you can have a list of contacts with information for their phone number, email, fax number, etc.  Do you want this user to see all Contact information in Global eContact or would you like to limit the salesman to see only his/her contacts in Global eContact? 
  • Do you want to let this user view eContact information only without the ability to edit it?
  • Do you want to let this user add and edit credit cards or view the credit card number?  Typically, you may allow collecting of credit card information, but once the credit card is collected you do not want users to see the credit card number for security reasons.
  • Do you allow this user to access eContact/Export Processor?  eContact/Export Processor is like a report writer where the user can access a lot of information in the Elliott system.  You may consider giving the user access to pre-written reports without the ability to change it.  This lowers the security concern.  If you wish to implement this, then you will give users access to eContact/Export Processor, but disable the “Interaction” with eContact/Export Processor.
  • If you decide to give users the ability to Interact with eContact/Export Processor, you need to decide whether this user use and view other people’s templates or not.  If a user is allowed to Interact with eContact/Export processor, even though they may be prevented from using other’s templates, they can still create new templates or change their own template criteria.
  • Once you allow a user to “Interact” with eContact/Export Processor, you should consider the Elliott menu security.  For example, if you allow this user to access customer file maintenance, then they can access all information in the Customer Category.  Another example is if you allow this user to access order entry, then this user will be able to access all information in the Order Category.  This may be subject to the Salesman Security, depending on how you set the following flags:
    • Disable Salesman from Viewing Other’s Customer in A/R
    • Disable Salesman from Inquiring Other’s in COP
  • If this user is a supervisor (IT) and develops a template (pre-written report) for other users, you need to give this user the ability to change the template for other users.
  • The following areas in Elliott are also related to Salesman Security.  It shows how the security is controlled:
    • A/R Customer File Maintenance
      • Elliott Menu Security
      • Global Security: “Disable Salesman from Viewing Other Customers in A/R”.
      • Global Security: “Disable Change Customer”
      • Global Security: “Disable Delete Customer”
      • Global Security: “Disable Print Customer List/Label”
    • A/R Customer Inquiry
      • Elliott Menu Security
      • Global Security “Disable Salesman from Viewing Other Customers in A/R”
    • A/R Customer Account Inquiry
      • Elliott Menu Security
      • Global Security: “Disable Salesman from Viewing Other Customers in A/R”.
    • A/R Summary Account Inquiry
      • Elliott Menu Security
      • Global Security: “Disable Salesman from Viewing Other Customers in A/R”.
    • COP Order Inquiry
      • Elliott Menu Security
      • Global Security: “Disable Salesman Inquiry for Other’s in COP”
    • COP Invoice History Inquiry
      • Elliott Menu Security
      • Global Security: “Disable Salesman Inquiry for Other’s in COP”
    • COP Recurring Order Inquiry
      • Elliott Menu Security
      • Global Security: “Disable Salesman Inquiry for Other’s in COP”
    • COP Stock Status Inquiry
      • Elliott Menu Security
      • Global Security: “Disable Salesman Inquiry for Other’s in COP”
    • COP Freight Calculation Inquiry
      • Elliott Menu Security
      • Global Security: “Disable Salesman Inquiry for Other’s in COP”
    • COP Order Entry
      • Elliott Menu Security
      • Global Security: “Disable User from Adding Orders in Order Entry”
      • Global Security: “Create Credit Memo in Order Entry”
      • Global Security: “Create COP Credit Memo from Invoice History”
      • Global Security: “Allow User Enter Negative Qty in Order Entry”
      • Global Security: “Change COP Orders After Pick Ticket Printed”
      • Global Security: “Allow to Delete COP Orders”
      • Global Security: “Allow to Override Terms in Order Entry”
      • Global Security: “Allow to Override Salesman in Order Entry”
      • Global Security: “Allow to Override Disc Pct in Order Entry”
      • Global Security: “Allow to Override Line Item Unit Cost”
      • Global Security: “Allow to Override Order Commission Field”
      • Global Security: “Change COP Pre-Paid Info”
      • Global Security: “Disable User from Printing Order Edit List”
      • Global Security: “Disable Salesman Add Other’s COP Orders”.
      • Global Security: “Disable Salesman Change Other’s COP Orders”.
      • Global Security: “Disable Salesman Printing Other’s COP Orders”.

 

Accounts Receivable

  1. ARMENU Accounts Receivable Package Overview
  2. Feature - Elliott AR ACH Processing
  3. How to Automatically Credit Check an Order After Filling Back Order
  4. Fine-Tuning Customer File Maintenance Security
  5. I Receive "No Open Item on File" Message When I Try to Reapply Open Credit or Payment in AR
  6. Can I Reapply a Payment to a Different Customer in AR?
  7. AR Aging Report - What's the Difference Between Py and Px Payment Type ?
  8. Avg Days Pay YTD in Customer File Calculation Issue
  9. Opn Ord Pick/Inv Amt Calculation Issue
  10. Auto Assigned Sales Tax Code by State and County
  11. How to Handle Sales Tax for Single Item with Caps Amount
  12. How to Subscribe a Customer Event by Salesman?
  13. Arizona Cities Not in Elliott for Sales Tax Code Auto Assign
  14. AR0111 Accounts Receivable Carrier File Maintenance
  15. AR0112 Accounts Receivable Carrier Mode Maintenance
  16. AR0113 Accounts Receivable Freight Rate File Maintenance
  17. AR0114 Accounts Receivable Freight Zone File Maintenance
  18. AR0120 Accounts Receivable State Table File Maintenance
  19. ARACTINQ Accounts Receivable Customer Account Inquiry
  20. ARACTMNT Accounts Receivable Account File Maintenance
  21. ARACTSUM Accounts Receivable Customer Account Summary Inquiry
  22. ARADJAUD Accounts Receivable Adjustment Auditing Inquiry
  23. ARADJSCN Accounts Receivable Adjustment Auditing Report
  24. ARAGEBAL Accounts Receivable Age Customer Accounts
  25. ARAGEMNU Accounts Receivable Aging Reports
  26. ARAPLYCR Accounts Receivable Re-Apply CR/DR Memos
  27. ARCALFCH Accounts Receivable Finance Charges Processing
  28. ARCNTMNT Accounts Receivable County Tax Code File Maintenance
  29. ARCRCMNT Accounts Receivable Credit Card Transacting Handling
  30. ARCRDSCN Accounts Receivable Credit Card Log Report
  31. ARCSHENT Accounts Receivable Cash Receipts Processing
  32. ARCSHSCN Accounts Receivable Cash Projection Report
  33. ARCTLMNT Accounts Receivable A/R Setup
  34. ARDBEXPS Accounts Receivable Export D&B Customer File
  35. ARDISSCN Accounts Receivable A/R Distribution to G/L Report
  36. ARECIMNT Accounts Receivable Customers and Contacts Import Utility
  37. ARHSTMNU Accounts Receivable A/R History Report
  38. ARINVSCN Accounts Receivable Print Service Invoices
  39. ARJBASCN Accounts Receivable Job Analysis Report
  40. ARJOBMNT Accounts Receivable Job Code File Maintenance
  41. I Can Only Enter A/R Cash Receipt for Cash or Check
  42. ARCUSMNT Accounts Receivable Customer File Maintenance
  43. ARLTRMNT Accounts Receivable Customer Mail Merge
  44. Feature - ACH Deposit Effective Date
  45. AROLOAD Accounts Receivable A/R Open Item File Maintenance
  46. ARPRDEND Accounts Receivable Clear A/R Accumulators
  47. ARPRGSCN Accounts Receivable Purge Closed Open Items
  48. ARRECENT Accounts Receivable Recurring Sales Processing
  49. ARSAMENU Accounts Receivable Sales Analysis Report
  50. ARSETBAL Accounts Receivable Set Customer Account Balances
  51. ARSHPMNT Accounts Receivable Ship Via Code File Maintenance
  52. ARSLMMNT Accounts Receivable Salesman File Maintenance
  53. ARSLSENT Accounts Receivable Sales and CR/DR Memo Processing
  54. ARSRCMNT Accounts Receivable Payment Source File
  55. ARSRVENT Accounts Receivable Service Invoice Processing
  56. ARSRVMNT Accounts Receivable Service File Maintenance
  57. ARSTMSCN Accounts Receivable Print Statements
  58. ARTAXMNT Accounts Receivable Tax Code File Maintenance
  59. ARTRMMNT Accounts Receivable Terms Code File Maintenance
  60. ARTYPMNT Accounts Receivable Customer Type File Maintenance
  61. ARSTLSCN Accounts Receivable Sales Tax Liability Report
  62. Incorrect Opn Ord Pick/Inv Amount in Customer File
  63. Feature - Customer Account Inquiry Reference Search
  64. Feature - Tax Freight Setup User Messages in COP Setup and Tax Code Maintenance
  65. ARFRMMNT Accounts Receivable Invoice Form Setup
  66. Feature - Customer Highest Balance YTD, Last Year, and Year Before Last Year
  67. Feature - Ship Via Group Support
  68. Feature - Scheduling ACH Payments
  69. How to Print A/R Aging Report by Salesman
  70. Feature - A/R Expanded Aging Report - Add "Show Open Items Only" Option
  71. Refund customer open credit / overpaid
  72. Feature - Add Acct Name to ACH Account Detail Screen
  73. Feature - ACH Add and Change Event
  74. Feature - Import A/R Cash Receipt Detail -- Add Ability to Process Multiple Customers for One Check
  75. Feature - A/R Commissions Due Reports - Additional Fields and CSV Support
  76. Feature - Age Customer Accounts When Cash Receipts Are Posted
  77. Feature - Validate Collector Against Salesman File
  78. NSCTLMN2 Accounts Receivable Global Setup 1
  79. NSCTLMN2 Accounts Receivable Global Setup 2
  80. NSCTLMN2 Accounts Receivable Global Setup 3
  81. NSCTLMN2 Accounts Payable Global Setup 1
  82. NSCTLMN2 Accounts Payable Global Setup 2
  83. NSCTLMN2 Accounts Payable Global Setup 3
  84. NSCTLMN2 Accounts Payable Global Setup 4
  85. NSCTLMN2 Accounts Payable Global Setup 5
  86. NSCTLMN2 Accounts Payable Global Setup 6
  87. NSCTLMN2 Accounting Global Setup: Index
  88. Accounts Receivable Cash Receipts Reports That Show Check Deposits for a Period of Time
  89. What Does the Asterisk Mean in A/R Account Inquiry?
  90. Refund Customer for Open Credit or Over Payment
  91. Feature - Defer Cash Receipts with Wildcard Batch Entry
  92. Feature - Exclude Debit Memos from Updating Customer Sales Ptd/Ytd
  93. Change - Sync Order Addresses in Customer Change Program
  94. Feature - Append Re-Apply Cr/Dr Memos Info To Log File
  95. Feature - Zone Breakdown Method by Freight Pay Code and State
  96. Feature - Enter Customer in Maintenance and Inquiry Event
  97. Feature - Added Phantom Locking to Customer File Maintenance

Feedback and Knowledge Base