MB-310: Microsoft Dynamics 365 Financial Consultant

Change Record

VersionDateChange
1.013 Sep 2024Initial release

Objective

Breakdown of voucher is the process you follow to break an invoice line into multiple tax lines. It is not possible to use two tax rates in one journal line. By using breakdown of voucher, it will be possible to use multiple tax codes with different rates.

Use the USMF company for the exercises in this lab.

Exercise 1 Break down a voucher

During this lab, you will enter a vendor invoice journal by using multiple tax rates.

Scenario

The accounts payable clerk at Contoso, Ltd. receives a vendor invoice with two tax lines and one net amount. The clerk plans to break down the voucher so the tax posts correctly. The total net amount is $10,000, with 7.25 percent charged on $7,000 and 8.25 percent on $3,000.

  1. Navigate to Accounts payable > Invoices > Invoice journal.

  2. Select the New button to create a new journal. The Invoice journal page is open. New is selected to create a new journal.

  3. In the Name field, select APInvoice. The Invoice journal page is open. The APInvoice journal is selected.

  4. Select the Lines button in the Action Pane. The Invoice journal page with Lines selected in the Action Pane.

  5. In the Date field, select today for the date.

  6. In the Account field, enter US-111.

  7. In the Invoice date field, enter 7/10/2024.

  8. In the Invoice field, enter 125.

  9. In the Description field, enter Office supplies.

  10. In the Credit field, enter $10,000.

  11. Note that Offset account was filled automatically with main account 606300.

  12. Select Functions > Breakdown of voucher from the lines header, not the Action pane. The Vendor invoice journal page is open with a line selected. Breakdown of voucher is selected in the Functions list.

  13. In the Sales tax group field, select CA. The Breakdown of voucher page is open. Under the Sales tax group column, CA is selected in the field.

  14. In the Item sales tax group field, select AU/VI.

    Note that the amount in the Amounts include sales tax column and the amount in the Sales tax amount column are changed. The Breakdown of voucher page is open. The amounts in the Amounts include sales tax column and the Sales tax amount column are highlighted.

  15. In the Amount excl. sales tax field, enter 7,000. The Breakdown of voucher page is open. The amount in the Amount excl. sales tax column is highlighted.

  16. Navigate to the lower part of the page. In the Debit field, enter 7,000. The Breakdown of voucher page is open. The amount in the Debit column in the lower part of the page is adjusted to $7,000.

  17. Select New in the Action Pane to create a new line in the upper part of the page. The Breakdown of voucher page is open. New is selected in the Action pane.

  18. In the Sales tax group field, select CALA. The Breakdown of voucher page is open. The sales tax group CALA is selected in the Sales tax group field.

  19. In the Item sales tax group field, select AU/VI.

  20. Navigate to the lower part of the page and select Add to add a line in the lower part. The Breakdown of voucher page is open. Add is selected in the lower part of the page.

  21. In the Ledger account field, enter 606300-001—-. The Breakdown of voucher page is open. Ledger account 606300 is added in the lower part of the page.

  22. Select Save in the Action Pane. The Breakdown of voucher page is open. Save is selected in the Action Pane.

  23. The Update button is available after saving the data. Select Update in the Action Pane. The Breakdown of voucher page is open. Update is selected in the Action Pane.

Note that the original line is reversed and two new lines are created according to the breakdown of the voucher. The Vendor invoice journal page is open to display the created lines.

  1. Scroll to the right to review the Sales tax groups. The Vendor invoice journal page is open to display the created lines.

  2. Select Post in the Action Pane. The Vendor invoice journal is open. Post is selected in the Action Pane.

  3. After the message “Operation completed” appears, close the form. The Vendor invoice journal page is open. The message Operation completed appears in the message bar.