BeyondERP.Newsletter
Menu

Setup step on the Bill back workbench page · Sales and marketing

Cumulate, approve and process bill-back claims

Use this page to turn trade allowance bill-back claims into deductions or regular payments for the customer.

Used by
Marketing manager, Accounts receivable clerk, Sales manager
Business process
Manage trade allowances
Menu item
TAMBillBackListPage
Main table
PdsRebateTable
Data entity
SalesRebateEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA workbench page where trade allowance bill-back claims are reviewed, recalculated, approved and processed.
What you do hereUse this page to turn approved claims into deductions or regular payments for the customer.
ExampleFor example, at month end the promotion owner at BEAT finds 18 bill-back claims of TA-000045 in To be recalculated, runs Cumulate for each chain, approves the adjusted claims and processes them, so 2,400.00 becomes a deduction on the chains' balances.
Bill back workbench 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.

Setup steps on this page

Cumulate, approve and process bill-back claims

Use this page to turn trade allowance bill-back claims into deductions or regular payments for the customer.

Steps from Microsoft

  1. Go to Sales and marketing > Trade allowances > Bill back workbench.
  2. Review the claim lines generated from posted sales invoices.
  3. For claims in To be recalculated, select Cumulate and select the customer; adjustment claims are added and the status changes to Calculated.
  4. Select Approve for the calculated claims.
  5. Select Process; the claims change to Mark and the Rebate accrual journal is posted.
  6. On the customer, select Collect > Settle transactions > Functions > Bill back program, mark the lines and create the credit note.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
StatusWhere the claim is in the process: To be recalculated (needs Cumulate), Calculated, Mark (processed: the Rebate accrual journal is posted) and Completed once the deduction is matched.Microsoft Learn To be recalculated

Common errors and fixes

MessageWhat to do
Claims in To be recalculated can't be approved.Select Cumulate for the customer first; after recalculation the claims are Calculated and can be approved. Microsoft Learn

Test checklist

  1. Post invoices under a confirmed trade allowance agreement and open the Bill back workbench.
  2. For claims in To be recalculated, select Cumulate for the customer and check adjustment claims are created and the status is Calculated.
  3. Select Approve, then Process, and check the status changes to Mark and the rebate accrual journal is posted.
  4. On the customer, select Collect > Settle transactions > Functions > Bill back program, mark the lines and create the credit note; check the customer balance is credited.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Cumulate, approve and process bill-back claimsReview the claims each period, Cumulate claims in To be recalculated per customer, then Approve and Process them, and let accounts receivable create the credit note from Settle transactions.Processing posts the Rebate accrual journal set in Accounts receivable parameters; creating the credit note posts the AR consumption journal, which credits the customer and debits the rebate accrual account.Processing claims before they are recalculated for the cumulative effect, so the customer is accrued at the wrong rate.Test: A processed bill back becomes a customer credit

Feature management and licence

Licence or add-inOn the live system, Sales manager, Marketing manager and Accounts receivable clerk use this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneHard to reverse: Process and the credit note post journals; corrections need new entries.
If you change it laterProcessing claims posts the rebate accrual journal, which records the future amount owed to the customer. Microsoft Learn
Technical architect

6Technical

Menu itemTAMBillBackListPage Checked in Dynamics 365
FormPdsRebateTableListPage Checked in Dynamics 365
TablePdsRebateTableShown as “Rebate” in Record infoChecked in Dynamics 365
Data entitiesSalesRebateEntityCustomer rebates Microsoft data model
Who can open itPrivilegesMaintain bill back rebate lists TAMBillBackListPageMaintainDutiesMaintain trade allowances TAMMaintain
3 security rolesMarketing manager CRMMarketingManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkSales manager TradeSalesManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itSales manager TradeSalesManagerMarketing manager CRMMarketingManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkGive people one of these roles. On this system, 3 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=TAMBillBackListPage
Integrate withSalesRebateEntity data entity Microsoft data model
Data migrationSalesRebateEntity (Customer rebates): loaded for each company; the bill-back claims share the table of the Rebates page.Load order: No default configuration template places this entity. Claims are created by invoicing under confirmed agreements; load open claims only after those agreements.Load first: Trade allowance agreements, CustomersMicrosoft Learn
Table definitionPdsRebateTable columns and relations Microsoft data model
Everyone

8Sources

To cite this step: SM-TRD-110, Cumulate, approve and process bill-back claims. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/SM-TRD-110