BeyondERP.Newsletter
Menu

Job page · Rebate management

Write off

A periodic task dialog that runs, or schedules as a batch job, the write-off calculation for several rebate management deals at once, creating transactions for the difference between the provision that was posted and the rebate that was posted for each source transaction in the period.

Business process
Manage approved rebates in Dynamics 365 Supply Chain Management
Menu item
TAMRebateCreateTransWriteOff
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA periodic task dialog that runs, or schedules as a batch job, the write-off calculation for several rebate management deals at once, creating transactions for the difference between the provision that was posted and the rebate that was posted for each source transaction in the period.
What you do hereUse this task after provisions and rebates have been posted to generate the write-off transactions that clear the variance between the accrued provision and the actual rebate, so the ledger accrual can be reversed; you can filter the deals and set a recurring schedule.
ExampleFor example, if $1,000 was provisioned for a customer's monthly rebate but the final rebate posted was $900, the write-off process creates a $100 transaction to clear the remaining accrual.
Write off 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 both the provision and the rebate for a period have been posted, to clear the difference between them.
How oftenOnce per rebate period, at the same frequency as the rebate.
Batch settingsSchedule it after Post > Rebate management for the same period, then Post > Write off.
What the output showsUnposted write-off transactions with the difference between the posted provision and the posted rebate for each source transaction. A large write-off usually means the provision rate on the deal differs from the actual rebate.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Rebate management > Periodic tasks > Process > Write off.
  2. In the Period section, set From date and To date to the period whose provisions and rebates are both posted.
  3. Set the Guarantee Period dates to the same range when royalty guarantees apply.
  4. Use Filter under Records to include to choose the deals; deals with Rebate output Item have no write-off.
  5. Review the write-off lines on the Rebate workbench (Show set to Not posted) before you run Post > Write off.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
From date / To date (Period)The date range of source transactions whose provision-versus-rebate variance is written off.Microsoft Learn
From date / To date (Guarantee Period)The date range used for royalty guarantees in the calculation.Microsoft Learn
Records to includeStandard batch filter to limit which deals are processed.Microsoft Learn
Run in the backgroundStandard batch processing and scheduling options.Microsoft Learn

Test checklist

  1. Write-off lines exist only for periods with posted provision and rebate.
  2. Each write-off equals posted provision minus posted rebate for the source transaction.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneYes, before posting: Purge unposted write-off lines on the Rebate workbench and process again. Microsoft Learn
If you change it laterThe write-off transactions created here have no ledger effect until they are posted; once posted, the difference between provision and rebate is written off to the main account set on the posting profile, using the write-off journal name. Microsoft Learn
Technical architect

5Technical

Menu itemTAMRebateCreateTransWriteOff Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itAccounts payable manager VendInvoiceAccountsPayableManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts payable clerk VendInvoiceAccountsPayableClerkGive people one of these roles. On this system, 4 roles can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=TAMRebateCreateTransWriteOff
Everyone

7Sources