IT Computer accounting (SAGE-50)

ITComputeraccountingSAGE-50.xlsx

Home >Business & Finance homework help >Management homework help >IT Computer accounting (SAGE-50)

Sheet1

COMPUTERIZED ACCOUNTING SYSTEM
FOLLOW CAREFULLY THE INSTRUCTIONS
1	REPORT VERSION 1
		Prepare a "Customer List" report respecting the following order :
			Customer name
			Balance owing
		Generate the report and save in Excel as "V1"
		Modify the Excel report as shown in class
2	CREATE AN CONTRACT EX-1
		Using the 12th customer on the list
		Pick the 12th item on the list
		15 quantities
		NO tax
		Document number EX-1
		Save
		Close and go to the welcoming page (main screen)
		Retrieve the document and send me a printscreen
3	CONVERT CONTRACT EX-1 INTO INVOICE EX-2
		Received 13 quantities
		Close and go to the welcoming page (main screen)
		Retrieve the document and send me a printscreen
4	REPORT VERSION 2
		Prepare a "Customer List" report respecting the following order :
			Customer name
			Balance owing
		Generate the report and save in Excel as "V2"
		Modify the Excel report
		Combine V1 & V2 in the same Excel report
		Add a column "variance between V1-V2"
		Ensure the numbers shown make sense
4	CANCEL INVOICE EX-2
5	CREATE INVOICE EX-3
		Using the 11th customer on the list
		Pick the 11 item on the list
		10 quantities
		NO tax
		Document number EX-3
		Save
6	REPORT VERSION 3
		Prepare a "Customer List" report respecting the following order :
			Customer name
			Balance owing
		Generate the report and save in Excel as "V3"
		Modify the Excel report
		Combine V1 & V2 & V3 in the same Excel report
		Add a column "variance between V2-V3"
		Ensure the numbers shown make sense
7	MODIFY INVOICE EX-3
		Change the customer, pick the 2nd one on the list
		Save
		Close and go to the welcoming page (main screen)
		Retrieve the document and send me a printscreen
8	REPORT VERSION 4
		Prepare a "Customer List" report respecting the following order :
			Customer name
			Balance owing
		Generate the report and save in Excel as "V4"
		Modify the Excel report
		Combine V1 & V2 & V3 & V4 in the same Excel report
		Add a column "variance between V3-V4"
		Ensure the numbers shown make sense
9	CREATE A DEBIT NOTE
		Based on quantites received in invoice EX-3, return 1 quantites to the customer
		What shoud be the document number ?
		Save
		Close and go to the welcoming page (main screen)
		Retrieve the document and send me a printscreen
10	REPORT VERSION 5
		Prepare a "Customer List" report respecting the following order :
			Customer name
			Balance owing
		Generate the report and save in Excel as "V5"
		Combine V1 & V2 & V3 & V4 & V5 in the same Excel report
		Add a column "variance between V4-V5"
		Ensure the numbers shown make sense