Customer Discounts: To Create an AR Invoice with a Manual Discount

In this activity, you will create and release two invoices: one with a manual line discount, and the other with a manual document discount.

Story

Suppose that the SweetLife Fruits & Jams company has offered five days of the offline training course at a 15% discount to one of its customers, Thai Food Restaurant (TOMYUM), which wants to purchase the offline training course.

Another customer, GoodFood One Restaurant (GOODFOOD), also wants to purchase three days of the online training course, and the SweetLife sales personnel agreed to give the customer a $10 discount.

Acting as the SweetLife accountant, you need to enter invoices for these customers and manually enter these discounts.

Configuration Overview

In the U100 dataset, the following tasks have been performed for the purposes of this activity:

• On the Enable/Disable Features (CS100000) form, the Customer Discounts feature has been disabled to support the manual discount functionality.
• On the Non-Stock Items (IN202000) form, the OFLCOURSE and ONLCOURSE non-stock items have been created.
• On the Customers (AR303000) form, the TOMYUM and GOODFOOD customers have been created.

Process Overview

You specify a manual line discount or a manual document discount on the Invoices and Memos (AR301000) form.

To specify a manual line discount, on the Details tab, you enter either a Discount Amount or a Discount Percent for the line.

To specify a manual document discount, you enter the amount in the Discount Total box in the Summary area.

System Preparation

To prepare the system, do the following:

1. Launch the MYOB Advanced website with the U100 dataset preloaded, and sign in as an accountant by using the following credentials:
   • Username: johnson
   • Password: 123
2. In the info area, in the upper-right corner of the top pane of the MYOB Advanced screen, make sure that the business date in your system is set to 1/30/2023. If a different date is displayed, click the Business Date menu button and select 1/30/2023. For simplicity, in this lesson, you will create and process all documents in the system on this business date.
3. On the Company and Branch Selection menu, which is also on the top pane of the MYOB Advanced screen, make sure that the SweetLife Head Office and Wholesale Center branch is selected. If it is not selected, click the Company and Branch Selection menu to view the list of branches that you have access to, and then click SweetLife Head Office and Wholesale Center.

Step 1: Creating the AR Invoice with a Manual Line Discount

To create the AR invoice for Thai Food Restaurant and apply a manual line discount in it, do the following:

1. Open the Invoices and Memos (AR301000) form.
2. On the form toolbar, click Add New Record, and specify the following settings in the Summary area:
   • Type: Invoice
   • Customer: TOMYUM
   • Date: 1/30/2023
   • Post Period: 01-2023
   • Description: Offline training
3. On the Details tab, click Add Row on the table toolbar, and specify the following settings in the new invoice line:
   • Branch: HEADOFFICE
   • Inventory ID: OFLCOURSE
   • Quantity: 5
   • UOM: DAY
   • Unit Price: 45
   • Discount Percent: 15
4. Save the invoice.

   The system has calculated the 15% manual discount and applied it to the invoice line. The line amount is $191.25 ($225 - $33.75).

   For a manual line discount, you can specify either a discount percent or a discount amount. Just as in this example, the system calculated the discount amount based on the discount percent you entered for the line, if you enter a discount amount, the system automatically calculates the corresponding discount percent.

5. On the form toolbar, click Remove Hold and then click Release to release the invoice.
6. On the Financial tab, click the link in the Batch Nbr. box to review the generated GL batch, which the system opens on the Journal Transactions (GL301000) form.

   The 11000 - Accounts Receivable account has been debited with the amount of $191.25, which is the invoice amount less the manual line discount you applied to the invoice.

Step 2: Creating the AR Invoice with a Manual Document Discount

To create the AR invoice for GoodFood One Restaurant with a manual document discount, do the following:

1. While you are still on the Invoices and Memos (AR301000) form, click Add New Record on the form toolbar, and specify the following settings in the Summary area:
   • Type: Invoice
   • Customer: GOODFOOD
   • Date: 1/30/2023
   • Post Period: 01-2023
   • Description: Online course 3 days
2. On the Details tab, click Add Row on the table toolbar, and specify the following settings in the new invoice line:
   • Branch: HEADOFFICE
   • Inventory ID: ONLCOURSE
   • Quantity: 3
   • UOM: DAY
   • Unit Price: 14.50
3. On the form toolbar, click Save to save the invoice.
4. In the Discount Total box in the Summary area, enter 10.

   This is the $10 manual discount you have agreed to give your customer. The total amount of the invoice before the discount is displayed in the Detail Total box ($43.50), and the amount due (with the manual document discount applied) is displayed in the Balance box ($33.50), as shown in the screenshot below.

   
   
   

5. On the form toolbar, click Remove Hold and then click Release to release the invoice.
6. On the Financial tab, click the link in the Batch Nbr. box to review the generated GL batch, which the system opens on the Journal Transactions (GL301000) form.

   The 53000 - Discount Given account has been debited in the amount of the document discount you specified for this invoice ($10).