Delete the duplicate record and 2016 invoice date record. (Keep one transaction for each of the transaction number).
accounting
Description
Please read! Hints and tips!
Part 1. C. - Delete
the duplicate record and 2016 invoice date record. (Keep one transaction for
each of the transaction number).
There are Transaction
Numbers in the Data set that are 2016 Invoices but they are the only one
transaction for the transaction Number. Should I delete because it is 2016? or
Keep because it is the only one for that Transaction number?
Yes!
Please drop 2016 data and duplicated data.
Part 2.
C. Summarize the total dollar amount by each of the customers. (5
points)
There is not a column
in the table for this value. - I can add a column if this is what you advise.
Yes!
Please add a column for the total amount.
Part 2. F. If the
total dollar amount of the orders for the customers used UPS Trade Direct is
larger than the other two methods. Otherwise, put “yes” into M column.
Otherwise, put “no” into the column.
The total Dollar
amount is higher than the other two methods... Combined? or individually?
Individually. The total
dollar is higher than both of the other two methods.
Last modified: Monday,
September 7, 2020, 9:03 AM
