Download as:
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Language:EN
Pages: 1
Words: 1219

These users are the ones that can enter the sales data the end the day

  1. Login to the system using a Unique User ID & password for each employee. These users are the ones that can enter the sales data at the end of the day. Please assume these User IDs were already setup correctly.

  2. Data entry fields/screens to :

  1. On each file from the Best Sell stores, the Mainframe System needs to accept & create a sales report based on :

File from the OLD Best Sell Store System and/or from New Java Web system:

Plus totals for Departments and Stores/Branches and the Whole Best Sell Company !

Q: How many salespeople in each store/Branch ?

The LastName field is 15 characters

Q: Integrate Old Best Sell and New Best Sell Data Entry "environments"???

Q: For that Days Sales $ amounts. How many products and price for each Product?

A: NO ... just the Sales $ amounts ...

Note: The report program that runs daily will calculate in the BEST Sell report, these values :

- Gross_sales_Year_to_Date

Store/Branch # is 3 digits numeric (positive and non-zero).

Q: Do we need to calculate sales totals on the sales report for historically Google products (Self driving cars) vs historically Best Buy products ??

Q: Should there be a maximum Commission % ???

A: Great question - YES this is a good idea to prevent invalid data since the business folks believe the commission rate % will never be higher than

Commission_Amount = Net_Sales_Year_to_Date * Commission%

So for example if an individual Salesperson (Say sales person # 60510 ) has

Then after today their

Gross_Sales_Year_To_Date = $570,000 (50K + 520K )

Their Commission Paid $ will be $540,000 * 0.0010 = $ 540.00

Q: Do we need to test Login to mainframe ??

A: NO we don't need this function, but great Q... maybe in future...

Q: Should we create output file of Sales Report data for Store managers to read into Excel / etc. for creating graphs/etc. that more clearly show performance ??

1-5 Transaction #: Used for audit trail purposes

6 Transaction type : corresponds with the type of transaction

C for Change Salesperson

07-11 Transaction Salesperson #: 5 digit Salesperson# for this transaction

00001S19304151001062187020100

00002S92493151001065327502510

00007S26913151004019872002020

00008S84932151005028981902020

00013D44931151005

00014S16825151006072454303010

00019S54931151007036909805525

00020S26881151007045018702025

00025A46827151012Newman Sid 200300300

00026S44931151016098663204530

00031C10559151018McGannon Margaret 300300400

00032C17402151018Obradovic Rita 200300200

26002Hau Jayne 7089627001329100100239

01061Ade Julie 7087223211871300100338

Where:

01-05 is the Salesperson ID#

45-47 is the Salesperson Store/Branch #

48-49 is the Salesperson Department #

Copyright © 2009-2023 UrgentHomework.com, All right reserved.