Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please someone help me with these on sage 300 7. Process the quick entries the 5 quick entries from the A/R Receipt entry(15 marks) 8.

image text in transcribedimage text in transcribedPlease someone help me with these on sage 300 image text in transcribed

7. Process the quick entries the 5 quick entries from the A/R Receipt entry(15 marks) 8. February 5, 2019. Durangos Electrics was awarded their outstanding amount from the previous invoice as goodwill. Create an adjustment transaction for the customer. (5 marks) 9. February 5, 2019. Sold inventory to Durango's Electrics , PO #123, Invoice #5555, Terms Code 30 (5 marks) Item Sold PR150 PN266 Quantity Sold 2. 3 Selling Price $5,250.00 / each $8,900.00 / each Sales Representative Sales Split 100% JS Item Sold PR150 PN266 Quantity Sold 2 3 Selling Price $5,250.00 / each $8,900.00 / each Sales Representative Sales Split 100% JS 10. February 18, 2017. Issue a Credit Note (Credit Note #CN 250) to Mr. John James, for returning damaged goods (1 unit of 52C1) against Invoice #1007. Print screen the A/R customer screen (activity folder) to show that you have applied the credit. (5 marks) 11. February 19, 2019. It was found that there was no inventory available for a prepayment previously made by Jane's book (Ck#2356 for $5000, PO#2222). The customer was notified that the prepayment would be refunded (use the default Refund Number) and cheque (Ck#2357). It is sent to the customer for the full amount. Do not print the cheque. Use (accept) the system generated Refund Number. (5 marks) 12. February 25, 2019. It was found that Union electric (Invoice# 1000) was overcharged by $230 excluding tax. Create the adjustment (5 marks) 13. February 28, 2019. Mr. John James notified the Omni Electrical supplies Itd that he did not receive the 10% discount that was promised on invoice #1007. Use customer inquiry to determine the amount and create the adjustment. (5 marks) 14. It was found that Invoice #1003 BC Electric was posted to the wrong account. The revenue account 4500-200 should have been used. All other info recorded previously is correct. (5 marks) 15. Setup a recurring charge using the recurring code MACHINE-RENTAL for the Vineyards, on the 19th of February, 2019 every month at a cost of $675 plus HST net 30 days. It should end on December 31, 2019. Create a new account 4504-100 (machine rental income, div, CR, income statement, 15, revenue), Total monthly amount $734.50 (including Ont-tax). Create the invoice. (5 marks) 16. A reminder list should appear for the administrator 3 days prior to the 31st of each month so that this recurring charge is not forgotten 2 17. Update the recurring charge for the Vineyards Their costs will now increase by 15%. Create the invoice in the same batch as previous recurring charge in question#15. (3 marks) 18. February 28, 2019. The bank statement, cancelled cheques, credit & debit memos, and other related information for the month ending February 28, 2019 arrived. (8 marks) The balance of the bank statement was: $33,061.34 Bank service charges were $80.51; determine the account to use to write off the charges. ONLY the following deposit cleared the bank: Customer Amount 1 $5000.00 ONLY the following cheque(s) cleared the bank: Payee Kramden Transit Kingsway Transit Kingsway Transit Cheque # 1248 1249 1259 Amount $1605.00 $1500.00 $8260.55 Prepare the bank reconciliation for the month ending February 28, 2019. Do a printscreen of the screen when you process the bank charges. . Post the reconciliation Print (Export) the Bank Reconciliation Report and the Bank Entries Posting journal. Rename the reports as Bank Reconciliation conort and Don Entries Rootinaioural 7. Process the quick entries the 5 quick entries from the A/R Receipt entry(15 marks) 8. February 5, 2019. Durangos Electrics was awarded their outstanding amount from the previous invoice as goodwill. Create an adjustment transaction for the customer. (5 marks) 9. February 5, 2019. Sold inventory to Durango's Electrics , PO #123, Invoice #5555, Terms Code 30 (5 marks) Item Sold PR150 PN266 Quantity Sold 2. 3 Selling Price $5,250.00 / each $8,900.00 / each Sales Representative Sales Split 100% JS Item Sold PR150 PN266 Quantity Sold 2 3 Selling Price $5,250.00 / each $8,900.00 / each Sales Representative Sales Split 100% JS 10. February 18, 2017. Issue a Credit Note (Credit Note #CN 250) to Mr. John James, for returning damaged goods (1 unit of 52C1) against Invoice #1007. Print screen the A/R customer screen (activity folder) to show that you have applied the credit. (5 marks) 11. February 19, 2019. It was found that there was no inventory available for a prepayment previously made by Jane's book (Ck#2356 for $5000, PO#2222). The customer was notified that the prepayment would be refunded (use the default Refund Number) and cheque (Ck#2357). It is sent to the customer for the full amount. Do not print the cheque. Use (accept) the system generated Refund Number. (5 marks) 12. February 25, 2019. It was found that Union electric (Invoice# 1000) was overcharged by $230 excluding tax. Create the adjustment (5 marks) 13. February 28, 2019. Mr. John James notified the Omni Electrical supplies Itd that he did not receive the 10% discount that was promised on invoice #1007. Use customer inquiry to determine the amount and create the adjustment. (5 marks) 14. It was found that Invoice #1003 BC Electric was posted to the wrong account. The revenue account 4500-200 should have been used. All other info recorded previously is correct. (5 marks) 15. Setup a recurring charge using the recurring code MACHINE-RENTAL for the Vineyards, on the 19th of February, 2019 every month at a cost of $675 plus HST net 30 days. It should end on December 31, 2019. Create a new account 4504-100 (machine rental income, div, CR, income statement, 15, revenue), Total monthly amount $734.50 (including Ont-tax). Create the invoice. (5 marks) 16. A reminder list should appear for the administrator 3 days prior to the 31st of each month so that this recurring charge is not forgotten 2 17. Update the recurring charge for the Vineyards Their costs will now increase by 15%. Create the invoice in the same batch as previous recurring charge in question#15. (3 marks) 18. February 28, 2019. The bank statement, cancelled cheques, credit & debit memos, and other related information for the month ending February 28, 2019 arrived. (8 marks) The balance of the bank statement was: $33,061.34 Bank service charges were $80.51; determine the account to use to write off the charges. ONLY the following deposit cleared the bank: Customer Amount 1 $5000.00 ONLY the following cheque(s) cleared the bank: Payee Kramden Transit Kingsway Transit Kingsway Transit Cheque # 1248 1249 1259 Amount $1605.00 $1500.00 $8260.55 Prepare the bank reconciliation for the month ending February 28, 2019. Do a printscreen of the screen when you process the bank charges. . Post the reconciliation Print (Export) the Bank Reconciliation Report and the Bank Entries Posting journal. Rename the reports as Bank Reconciliation conort and Don Entries Rootinaioural

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

QS 9000 Handbook A Guide To Registration And Audit

Authors: Jayanta Bandyopadhyay

1st Edition

157444011X, 978-1574440119

More Books

Students also viewed these Accounting questions