Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Customer Aging Report ...
Finance forum
Unanswered

Customer Aging Report - Exclude VAT/Sales Tax

Posted on by 95
Hi Community-members!

For our monthly-closing, we need to calculate a Doubtful Debt-provision. 
We do this based on the Aging of our Customers, by making use of the Customer Aging Report with our defined Aging Period Definitions.
Example:
- 10% for Customer-balances >60days
- 25% for Customer-balances >90days
 
Issue
The Customer Aging Report is including the VAT/Sales Tax.
While, as per GAAP, our Doubtful Debt-provision needs to be based on Net-amounts = excluding vat.
 
Question
Is there an option to generate a Customer Aging Report without VAT/Sales Tax?
 
The workarounds I see is: manual data extract from CustTrans and TaxTrans, and do a vlookup. Or generate a PowerBI-report.
But if a standard report is available, I prefer using that!
 
Thanks in advance,
Patrick 
 
 

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans