accounting assingment on SAP (ERP)
DEPARTMENT OF ACCOUNTING, FINANCE & ECONOMICS
7
1
5
0AFE Business Information Systems
SAP PROJECT
2
This project requires you to demonstrate your knowledge of the SAP ERP System. It covers the General Ledger, Accounts Receivable and Accounts Payable
PREPARATION
Review SAP lectures and workshop materials (weeks
4
–
8
) and complete any outstanding workshop activities prior to commencing with this project. Also review all supplementary SAP readings and/or documents (these documents are available in the Course Activity Centre).
ASSIGNMENT PART 1
Task |
Details |
1 |
In SAP, create a company code G### where ### is your number given to you Menu Path: Tools > Customising > IMG > Execute Project When window opens, click: SAP Reference IMG Select: Enterprise Structure > Definition > Financial Accounting Now execute by double-clicking on Execute by double-clicking Now select Organizational object > Copy org. Object When dialogue box appears, enter the following From Company code: GU01 To Company code: G### (### is your no.) Press ENTER When dialogue boxes appear, click the following responses Disregard warning messages Press ENTER Press ENTER Click BACK Change the definitions of your company code G###: Select Edit company code data Use Position to locate G### Double-click on your company code G### When window opens, change the following fields: Company name: Griffith ### Ltd Check the following fields are correct: City: Brisbane Country: Australia Currency: Australian dollar Language: English Click SAVE |
2 |
Create a new GL master record for Special Equity (71###) for company code 10 00) (the ### is your number). Note: you will have to delete the Alternative Account No. in the Control Data
Tab (currently 71000). This is because multiple accounts can’t share the same alternative account no. from another chart of accounts Create another GL master record for Authorised Expenses (47 6 ###) for company code G### using a reference master record (476 9 00). (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 Record a journal entry for the receipt of cash of AUD$700,000 GL account 11 3100 is the relevant Bank account Record the document number . |
4 |
Create a new customer 9###1 in account group CUST – ‘Customers’ in company code G###. Use Reconciliation acct. 14 0000, 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###1 Use 10 days ago as the posting date and document date. Record the document number. |
6 |
Record an incoming payment from your customer 9###1 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,340 Record the document number |
7 |
Check your customer Account Balances and verify that they are correct. |
8 |
Post an invoice for AUD$11,000, including GST, to customer 9###2 Use 20 days ago as the posting date and document date. Record the document number |
9 |
Record an incoming payment from your customer 9###2 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 Name: Vendor ### Search term: ### Postal code: 4000 City: Brisbane Country: Australia Enter the following in Reconciliation acct.: 160000 Cash Managt. group: A4 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 posting date and document date. Enter the following Line Item (Debit) Account: 476### (Authorised expenses) Amount: AUD$10,000 Text: Stationary Record the document number. Check your posting. |
12 |
Record an outgoing payment to vendor 9###1 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: 1 13 100 Amount: discount Value date: today’s 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. Use the following information: Company Code: G### Fiscal Year: Current fiscal year Posting Date: From beginning of semester to Today’s date Now, extract a copy of your line item journal in HTML format. Name the output file 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. Return to the main menu. |
ASSIGNMENT PART 2
Write a concise report (350-400 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?”
Reference you report appropriately. References are not part of the word count.
Create a PDF file of your report. Name it
lastname_student_id_project_2_report
SUBMISSION REQUIREMENTS
SUBMIT
1. Copy of your Line Items Journal, saved as a HTML file.
2. Copy of your answer to Part 2, saved as a PDF file.
3. Assignment cover sheet.
END OF PROJECT
1
5