BeyondERP.Newsletter
Menu

Job page · Sales and marketing

Settle approved deductions

A periodic task that automatically matches deductions with credits that have the same Deduction ID and amount, for deductions created with New deduction.

Business process
Manage customer deductions on payments in Dynamics 365 Finance
Menu item
action:TAMDeductionMassMatch
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA periodic task that automatically matches deductions with credits that have the same Deduction ID and amount, for deductions created with New deduction.
What you do hereUse it to settle approved deductions against their invoiced credits on a schedule instead of matching them one by one on the deduction workbench.
ExampleFor example, BEAT approves deduction DED-000321 of 1,500.00 for customer BEAT-000123; the free text credit note of 1,500.00 with the same Deduction ID is posted, and the nightly run of the task settles the two.
Settle approved deductions page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itAfter deductions are approved and their credits are invoiced, so that deductions and credits with matching Deduction ID values and amounts are settled without manual matching.
How oftenOn a recurring schedule while you process deductions, at an interval that suits your deduction volume.
Batch settingsSchedule it as a recurring periodic task so approved deductions are matched without someone selecting Match on the workbench.
What the output showsDeductions settled against their credits where the Deduction ID and amount match. A deduction left open usually has no invoiced credit yet, a different amount, or wasn't created with New deduction.

Source: Microsoft Learn

Setup steps on this page

Schedule Settle approved deductions

Match approved deductions to their credits automatically.

Steps from Microsoft

  1. Go to Sales and marketing > Periodic tasks > Settle approved deductions.
  2. Make sure the deductions were created with New deduction and have a Claim status of Accepted, and that their credits are invoiced; the job only matches deductions and credits with the same Deduction ID and amount.
  3. Check Automatic settlement on the Settlement tab of Accounts receivable parameters; when it's Yes, credits are settled automatically and this job does nothing.
  4. Set the options and filters for the deductions to settle, and set up a schedule as for other periodic tasks.
  5. Afterwards, open the Deduction workbench and check that the matched deductions no longer have open credits in the Open transactions section.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Records to includeThe filter that selects the deductions to settle.Checked in Dynamics 365
Run in the backgroundRuns the task as a batch job on a schedule.Microsoft Learn

Common errors and fixes

MessageWhat to do
The task runs but no deduction is settled.If Automatic settlement is Yes on the Settlement tab of Accounts receivable parameters, the credit is settled automatically and the task does nothing. Microsoft Learn
A deduction stays open after the run.The credit must be invoiced and have the same Deduction ID and amount; check it in the Open transactions section of the deduction workbench, or match it there with Match. Microsoft Learn

Test checklist

  1. Deductions with a matching invoiced credit are settled.
  2. Deductions without a matching credit are still open on the Deduction workbench.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Schedule Settle approved deductionsSchedule it as a recurring task while Automatic settlement on Accounts receivable parameters is No; filter it to the deductions your team handles.It matches deductions and credits with the same Deduction ID and amount; with Automatic settlement = Yes the credits settle themselves and the task does nothing.Settle credits with this task or with Automatic settlement?Expecting it to settle deductions entered in the payment journal: it covers deductions created with New deduction whose credit is invoiced.Test: Approved deduction settled

Feature management and licence

Licence or add-inOn the live system, Collections manager runs this task. No feature in Feature management is needed.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyDeductions created with New deduction whose credits have the same Deduction ID and amount. Microsoft Learn
Can it be undoneNo: The settlements are made on the customer account. If a match was wrong, undo the settlement on the customer's transactions. Microsoft Learn
If you change it laterSettles approved deductions against their credit transactions on the customer account. The deduction workbench is part of Sales and marketing trade allowances and also works with Rebate management. Microsoft Learn
Technical architect

6Technical

Menu itemaction:TAMDeductionMassMatch Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itCollections manager CollectionLetterCollectionsManagerGive people one of these roles. On this system, 1 role can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=action:TAMDeductionMassMatch
Data migrationLoad order: Settle approved deductions has no data entity in Data management. It settles existing transactions; there is nothing to migrate.Checked in Dynamics 365
Everyone

8Sources