商科essay/report/assignment/paper写作
DEPARTMENT OF ACCOUNTING, FINANCE & ECONOMICS
7150AFE Accounting Information Systems
PROJECT 2: SAP [Weight = 20%]
This project assesses your ability to use SAP (Accounting Information Systems software) to process and analyse business transactions.
Part A – Demonstrate Competency using SAP ERP [50%]
This task tests your understanding of ERP software and basic concepts for the use of SAP by a business organisation. It also tests your ability to use SAP to create a company code for a business, create general ledger, customer and vendor master records, process transactions, and extract data to MS Excel for auditing purposes
The tasks to be completed are listed in the table below.
Before you attempt this project, you need to have read and understood the concepts covered in the SAP Lectures and completed all of the associated SAP Workshops (1 5).
PLEASE READ THESE INSTRUCTIONS VERY CAREFULLY BEFORE YOU START THE PROJECT.
If you have any questions about this project, please post a question in the Discussion Forum for the Project. Dont leave this to the last week. But make sure you have read all the instructions a few times before you post your question.
Instructions In various parts of this project, you will have to identify your individual work using the ### allocated to you earlier in the semester.
This task requires you to demonstrate your knowledge of the SAP ERP System. It covers the General Ledger, Accounts Receivable, Accounts Payable and SAP Auditing.
Task Details
(^1) For this project all the activities below will be performed in company code G999. Ensure that you have chosen the correct company code before commencing the tasks (i.e. G999). Using any other company code will be deemed incorrect. 2 Create a new GL master record for Special Equity (71###) for company code G999 using a reference master record (71000) (the ### is your number). Note: you will have to delete the Alternative Account No. in the Control Data
Task Details
Tab (currently 71000). This is because multiple accounts cant share the same
alternative account no. from another chart of accounts.
Create another GL master record for Authorised Expenses (476###) for company
code G999 using a reference master record (476900).
(follow steps from the Note above to delete Alternative Account No. 476900)
Check these accounts are correctly classified as Balance Sheet vs Profit & Loss.
Expense accounts must have a Tax Category of Only Input Tax allowed.
3 Now post a general ledger document to your new Special Equity account in
company code G
Record a journal entry for the receipt of cash of AUD$700,
GL account 113100 is the relevant Bank account
Record the document number.
4 Create a new customer 9###1 in account group CUST - Customers in company
code G999.
Use Reconciliation acct. 140000, and Payment terms 0002 (3% in 14 days, 2% in
30 days, and no discount thereafter)
Create a second customer 9###2 in account group CUST in company code G
Use Reconciliation acct. 140000, and Payment terms 0006
5 You are going to post an invoice to each of your customers, then record their
incoming payments. You are to demonstrate your knowledge of payment terms by
setting the posting and document dates so the customers receive different discount
rates.
Post an invoice for AUD$22,000, including GST, to customer 9###
Use 10 days ago as the document date.
Record the document number.
6 Record an incoming payment from your customer 9###
Use today as the posting date and document date such that the customer is able
to take the 3% discount
The incoming payment amount is AUD$21,
Record the document number
7 Check your customer Account Balances and verify that they are correct.
Task Details
8 Post an invoice for AUD$11,000, including GST, to customer 9###
Use 20 days ago as the document date.
Record the document number
9 Record an incoming payment from your customer 9###
Use today as the posting date and document date such that the customer is able
to take the 2% discount
Adjust the incoming payment amount accordingly
Record the document number
10 Create a new vendor 9###1 in account group LIEF - Vendors in company code
G
Enter the following fields in Create Vendor: Address screen:
Name: Vendor ###
Search term: ###
Postal code: 4000
City: Brisbane
Country: Australia
Enter the following in Create Vendor: Accounting information Accounting screen
Reconciliation acct.: 160000
Cash Managt. group: A
Enter Payment terms: 0002
Click SAVE
11 Post a vendor invoice of AUD$10,000 including G.S.T. to vendor 9###1 for
expenses
Use 10 days ago as the document date.
Enter the following Line Item (Debit)
Account: 476### (Authorised expenses)
Amount: AUD$10,
Text: Stationery
Record the document number.
Check your posting.
12 Record an outgoing payment to vendor 9###
Task Details
Use today as the posting date and document date such that you are able to take the
3% discount
Use the following Bank Data
Account: 113100
Amount: Adjust the outgoing payment amount to take the 3%
discount
Value date: todays date
Check the discount calculation and automatic posting then POST your payment.
Record the document number
13 Check your vendor Account Balances and verify that they are correct.
14 Produce a Line Item Journal that summarises postings to the General Ledger, your
customers and your vendor. Ensure that you only extract your transactions using
your allocated SAP login id GUI1-###
Use the following information:
Company Code: G
Fiscal Year: Current fiscal year
Posting Date: From beginning of semester to Todays date
Now, extract a copy of your line item journal in HTML format.
Name the output file lastname_student_id _line_item_journal_###.html and save it
to your USB. (Note: replace lastname, student_id and ### in the filename with your
personal information)
Ensure the Line Item Journal is saved as a HTML file. Open it and verify that it
opens in your web browser. Check your results.
(NOTE: In order to upload this file to L@G, you will need to zip or pdf it before
uploading)
Return to the main menu.
15 Analyse accounting transactions and produce business reports using MS Excel
Export data from table BKPF for your company code
Import this data into an MS Excel spreadsheet, removing unwanted rows and columns
Save the MS Excel workbook as lastname_student_id _analysis_###.xls to your USB.
(Note: replace lastname, student_id and ### in the filename with your personal
information)
Name the first sheet BKPF
Produce a Pivot Table showing the number of each type of transaction (transaction
code) performed by each user
Save the workbook
Task Details
(^16) Perform a similar export of data from table BSEG for your company code (Follow Topic 10 SAP Auditing Study Guide slides to select fields for export. Additional research and your Accounting theory knowledge may be required to identify relevant fields). Include customer and vendor fields in the extracted data. Import this data into an MS Excel spreadsheet Remove unwanted rows and columns Copy and paste into a new sheet in the workbook you created in Task 15 (that will then contain two sheets) Name this sheet BSEG Produce a Pivot Table of your own design to summarise postings to General Ledger accounts, similar to a Trial Balance Save the workbook Part B Written Communication [50%] Write a concise report ( 500 – 550 words), addressing the following: What are the features of enterprise resource planning (ERP) software like SAP? What are the arguments for and against its use by a large organisation? Requirements
- Save you file as lastname_student_id_report
(NOTE: replace lastname and student id with your own information).
- Make use of correct referencing. Refer to the course profile and lecture 1 for further guidance.
References are not part of the word count.
- You will be assessed on your writing, grammar and communication skills. Ensure that you write
using a formal business tone. Avoid unnecessary colloquialisms.
SUBMISSION REQUIREMENTS
Procedures for submitting your assignment You are required to submit electronic copies ONLY of your files in the Project 2 dropbox. No paper
based assignments will be accepted.
Note:
Only zip or pdf the line items journal file
Make sure you keep a copy (many copies in different places) of each file.
Be sure to give yourself plenty of time to upload as files submitted after the due time will
incur a late penalty to the assignment as indicated in the course profile. See the course profile
for penalty rates.
Once uploaded, go back again and check that your submission has the files attached; if it
doesnt you will have to contact the course convenor by email to advise that you have sent
your assignment without attachment. Electronic assignment submissions without a file
attached or not submitted at all, will result in a penalty being awarded for the assignment, so
please double check your electronic submission BEFORE the due date and time.
If you have any questions in relation to the submission of this assignment please contact the Course Convenor.
Awarding of Marks Marks will be awarded based on the marking criteria available on L@G.
Other points to note
Ensure you have read and followed the administration notes in relation to assignments in the course profile.
Extensions WILL NOT be granted after the due date and time for the project has passed. All
requests for extension must be put to the Course Convenor at least 5 days before the due date with
supporting documentation (e.g. doctors certificate) and evidence (even if incomplete) to show that
you have attempted the project to a reasonable level. Extensions will only be granted in extenuating
circumstances. Crashing of computers, too busy with other assignments, heavy workload, and such reasons are not considered extenuating circumstances. Requests for extensions due to work
commitments will NOT be granted. You must organise your study time around these other
commitments.
It is up to you to ensure you have included all the correct requirements in your submission. Omitted and incorrect files or reports will result in lost marks.
FILES TO SUBMIT AND WHERE TO SUBMIT
It is important that you submit the correct files as indicated below.
ITEM / FILE WHERE TO SUBMIT
- Assignment cover sheet Project 2 Dropbox
- Copy of your Line Items Journal (.HTML), must be in zip or
pdf format to upload.
Project 2 Dropbox
-
Copy of your spreadsheet, (.XLS or .XLSX) file. Project 2 Dropbox
-
Copy of your written report (.DOC or .DOCX) Project 2 Dropbox
-
SAP Transactions (^) Entered directly in SAP ERP System