Automated Customer Write off Transactions from D365 F&O (Step by Step Setup & Testing Scope)

Hello Microsoft Dynamics Lovers,

Today I will show, how the Automated Write Off function in D365 F&O is used and how the Configuration can be done to deploy the function for usage.

The Business scenario is- We sold product to customer, however due to some reason, the money can not be gained and that will be in Write-off Expense account (kind of bad debt).

Pre

After write off

The accounting entry will be below, however this will be auto created in GL journal



This setup is done with very basic configurations, Lets explore together.

1: Create a Journal Name and assign a voucher series by standard way.


2:Create a BAD debt loss in P&L expense account (If your business has a expense account for bad debt, you can use that)



3: Create reason code


4:Add the reason code & Main account for bad debt and make the same default in "Customer write-off reason codes" ( Credit & Collections->Setup->Customer write-off reason codes)


5: Configure Credit and Collection-> Setup-> Credit and Collection parameter

a) Add the journal name you created in "Write off journal" field

b) Add the Write off reason and main account in respective fields ( in most of the cases it auto populates after your have made account as default in step 4.

c) you can make "separate sales tax" to yes if your client wants this amount to be added to sales  tax settlement return or for legal requirement, by this the sales tax amount will be debited. 


Testing Scope

1: Select the customer which you want to make write off and then from "Collect", select the write off.


2: The window will pop up, select the write off date and ok




3: Now the automatic general journal has been created 

4: Check the journal and post the same



5: Check the balance and make sure it is now zero for this case



Thank you for going through, I hope it will add some value to you, any feedback is appreciated 


Comments

Post a Comment

Popular posts from this blog

Microsoft Edge :Web Browser can be installed as an application in your system

Image
Dear Innovation Lovers, Have you heard that, any web page you go through, can be installed as an application in your system by just a simple click? check this article for step by step setup. Pre-requisite - This feature available in Microsoft Edge version  85.0.564.51 1:First, open any web browser in Microsoft Edge( I have selected Microsoft Dynamics Community Page) 2: Select the 3 dots top of the right corner and options will come up 3: Select "Apps" option from the same form 4: One option will pop up "Install this site as an app" 5: Name it ( I have named as "D365 Community"), you can add any. 5: URA!!! The web browser is installed For more feature like this follow me on on LinkedIn  Ramit Paul Follow my Microsoft Community Blog  My Microsoft Dynamics Community Blog
Read more

Conditional Sales Tax Setup Guide for MSD365 Finance and Operations

Image
In this Blog, I will articulate how we can setup the Conditional Sales tax functionality  and how the same is paid to Govt/ statutory authority. For some of the countries, especially in Europe, the Sales tax authority allows for sales taxes and base amounts to be reported when the invoice is paid, not when that goods and service is received. Example~ On June 10 , you create an invoice of 10,000 plus 2,500 in sales tax. On July 10, you report taxes for June. The 2,500 is not included in the sales tax payment, because the invoice has not been paid. On July 15, the customer pays half of the invoice amount, 5,000, plus 1,250 in sales tax. On August 10, you report taxes for July. The 1,250 is included in the sales tax payment. When the customer settles the invoice with a second payment of 6,250, the remaining sales taxes are reported and paid. This setup will be done by~ 1.      Create separate main accounts for sales taxes on invoices that are awaiting settlement 2.     
Read more