Lab - Configure customer posting profiles and create a new customer

  • 40 minutes

Read this first - before you start the lab!

Important

For this lab, you CANNOT sign in with your own credentials. Use the following steps to sign in to your lab environment with the correct credentials.

  1. Ensure that you are signed in to Microsoft Learn.

  2. Select Launch VM mode or Sign in to launch VM mode in this unit.

  3. In the Resources tab on the lab side bar, select the T icon next to Password in the MININT box, to have the administrator password for the Virtual Machine entered for you.

    Screenshot of the administrator password.

  4. Select Enter.

  5. Microsoft Edge will open. Wait for it to navigate to the Sign in page for finance and operations.

  6. On the Microsoft Sign in page in finance and operations, place your mouse cursor into the Username field.

  7. On the Resources tab of the lab side bar, below the Azure portal heading, select the T icon next to Username, then press Enter.

    Screenshot of the Username field and the Sign in dialog box that appears.

  8. Your mouse cursor will now be in the Password page.

  9. On the Resources tab of the lab side bar, below the Azure portal heading, select the T icon next to select Password, then press Enter.

    Screenshot of the Password field the Enter password dialog box that appears.

  10. Don't stay signed in or store the password on the virtual machine.

  11. Select Accept in the Permissions requested page.

    Screenshot of the Permissions requested page.

  12. To see the lab instructions, select the Instructions tab on the lab side bar.

You can now begin your work on this lab.

In this lab you will practice configuring customer posting profiles, and creating a new customer.

Scenario - Configure customer posting profiles

The Accounting Manager at Contoso has asked the Accounts receivable clerk to set up a new posting profile for a group of retail customers.

Select the appropriate options to ensure the following:

  • Entries will be created using this profile for automatic settlement.
  • The application will calculate interest on outstanding balances for customers who have this profile.
  • A collection letter might be issued for customers who have this profile.
  • When transactions are settled in full, the transactions should not change to another posting profile.
  • Transactions for the retail customers group will post to summary account 130100 and settle account 110110.

Set up a customer posting profile

To set up a customer posting profile, follow these steps.

  1. In the USMF company, go to Accounts receivable > Setup > Customer posting profiles.
  2. Select New.
  3. In the Posting Profile field, type Prom.
  4. In the Description field, type Promotion.
  5. On the Table restrictions FastTab, make sure that the following option has Allow automatic settlement set to Yes.
  6. Set the Interest and Collection letter options to Yes.
  7. Verify that the Close field is blank.
  8. In the Setup FastTab, select Add to create and set up a new Account.
  9. In the Account code field, select Group.
  10. In the Account/Group Number field, select 30 Retail customers.
  11. In the Summary account field, select 130100.
  12. In the Liquidity account for payments field, select 110110.
  13. In the Collection letter sequence field, select High.
  14. Select Save.
  15. Close the page.

Establish customer payment terms

To establish customer payment terms, follow these steps.

  1. In USMF, go to Accounts receivable > Payments setup > Payment days.
  2. Select New.
  3. In the Payment day field, enter 17.
  4. In the Description field, enter 17th of the month.
  5. In the Week/Month field, select Month.
  6. In the Day of month field, enter 17.
  7. Select Save.
  8. Close the page.
  9. Go to Accounts receivable > Payments setup > Terms of payment.
  10. Select New.
  11. In the Terms of payment field, enter GTL-45.
  12. In the Description field, enter Net 45 days.
  13. In the Payment method field, select Current month.
  14. In the Payment day field, enter 17.
  15. Select Save.
  16. Close the page.
  17. Go to Accounts receivable > Payments setup > Cash discounts.
  18. Select New.
  19. In the Cash discount field, enter GLS-15D5%.
  20. In the Description field, enter Offer 5% if paid within 15 days.
  21. Enter the number of days used to calculate the cash discount date. In the Days field, enter 15.
  22. In the Discount percentage field, enter 5.
  23. In the Main account for customer discounts field, select 403300.
  24. In the Discount offset accounts field, select Use main account for Vendor discounts.
  25. In the Main account for vendor discounts, select 212160.
  26. Select Save.
  27. Close the page.

Create a method of payment for customer payments

To create a method of payment for customer payments, follow these steps.

  1. Open Accounts receivable > Payments setup > Methods of payment.
  2. Select New.
  3. In the Method of payment field, enter GTL-EP. The Method of payment ID is shown on invoices and payments, so make it descriptive enough to understand what type of payment is being recorded and for what bank account.
  4. In the Description field, enter Electronic payments.
  5. In the Payment status field, select Approved.
  6. In the Period field, select Total.
  7. In the Payment type field, select the type of payment as Electronic payment.
  8. In the Account type field, select Bank.
  9. In the Payment account field, select USMF OPER.
  10. In the Bank transaction type field, select Deposit.
  11. Selecting this payment will temporarily post to a bridging account. Set the Bridging posting option to Yes.
  12. In the Bridging account field, select 130730. This is the main account to which the payment will temporarily post if you are using bridging.
  13. Use the File formats Fast tab to define the setting for electronic payments.
  14. Select the Setup button.
  15. On the Export tab, in the AVAILABLE list, select NACHA (US) and use the arrow to move it to the SELECTED group.
  16. On the Import tab, select JBA(JP)- Format A and move it to the SELECTED group.
  17. On the Return tab, in the AVAILABLE list, select the Configurable layout file and move it to the SELECTED group.
  18. Select Save.
  19. Close the page.
  20. On the File formats Fast tab in the INVOICE UPDATE group, set the slider to Yes for Create and post draw journal automatically when posting invoices.
  21. In the Name field, select CustPay.
  22. In the FILE FORMATS group, for Export format select NACHA (US)
  23. In the Import format, select JBA(JP) – Format A.
  24. In the Return format, select Configurable layout file.
  25. Use the Payment control Fast tab to define mandatory fields. Select all fields in the Enabled column.
  26. Use the Payment attributes Fast tab to define which payment attributes you want to use for this method of payment. Select Payment account and Payment ID in the Enabled column.
  27. Select Save.
  28. Close the page.

Create payment fees for customer payments.

To create payment fees for customer payments, follow these steps.

  1. In USMF, go to Accounts receivable > Payments setup > Payment fee.
  2. Select New.
  3. In the Fee ID field, enter W01. The Fee ID displays on payment journals, so make it descriptive enough to understand what fee is being assessed.
  4. In the Name field, enter Wire.
  5. In the Fee description field, enter Bank fee for wire transfer.
  6. In the Charge field, select Customer.
  7. In the Journal type field, select Customer payment.
  8. Select Save.
  9. Select Payment fee setup. The Payment fee setup is used to define the criteria for when the payment fee will be assessed. For example, you can define that the fee will be calculated if the bank account is USMF OPER, and the method of payment is check.
  10. In the Groupings field, select Table.
  11. In the Bank relation field, select USMF OPER.
  12. In the Method of payment field, select GTL-EP Electronic payments.
  13. In the Payment currency field, enter USD.
  14. In the Percentage/Amount field select Percent.
  15. In the Fee currency field, select USD.
  16. Select Save.
  17. Close all pages.

Scenario - Create a new customer

The USMF company has started to work with a new customer, Fourth Coffee. The Accounts receivable clerk must set up this new customer.

  1. Go to Accounts receivable > Customers > All customers.
  2. Select New
  3. In the Customer account field, enter US-069
  4. In the Type field, select Organization.
  5. In the Name field, type Fourth Coffee.
  6. Select Use match when the Match found dialog box opens.
  7. In the Customer group field, select customer group 20.
  8. Select Save.
  9. Select the Credit and collections FastTab.
  10. In the Credit limit field, enter 10000.
  11. Select the Invoice and delivery FastTab.
  12. In the Mode of delivery field, select 20, Air.
  13. In the Sales tax group field, select CA.
  14. Select the Payment defaults FastTab.
  15. In the Terms of payment field, select Net10.
  16. In the Method of payment field, select CHECK.
  17. Select Save.
  18. Close the pages.

Close the lab environment

  1. Select Done in the Instructions pane in the lab side bar.
  2. In the Lab is complete window, select Continue, and then select Leave to return to the next unit in the module.