Different Number Sequence for Different Vendor/Customer Group

Hello Dynamics Lover,

In this blog, I will articulate the business scenario where many of the times, we are asked to create different sets of number sequence for vendors and customers based on the vendor/Cudtomer type/groups.  

Below the customer requirement (I have shared steps with vendors, however the same steps are applicable for customer as well)

1.    Scenario 1: Local vendors format will be LOCV-*******1

2.    Scenario 2: Foreign vendors format will be FRV-******1

3.    Scenario 3: Employee Vendors format will be EMV-******1

4.    Scenario 4: All other vendors will be OTHRV-******1

The end result is below we have got from the requirement gathering session. 

Name

Vendor Group

Number Sequence Requirement

Local vendors

V10

LOCV-000000001

Foreign vendors

V20

FRV-000000001

Employee Vendors

E10

EMV-000000001

All Other vendors

Rest All

OTHRV-000000001


Once you defined the requirement gathering, you need to follow the below steps

  1.   Create the number sequence as per the standard way by given format by customer


2: Now you add the newly created number sequence into the Vendor group – Default number sequence-> add the newly created sequence for respective vendor groups

3. 3  Now you add the OTHER vendors number sequence into Accounts payable parameter for rest of the vendor groups, this will work like a global sequence and whenever any other vendor group)apart from the requirement) is selected, it will come up.

 

 

 

4.    Now lets create individual vendors for each group to check the vendor numbers are auto populating with our criteria

I have created vendors for each group and it worked as expected, all the number sequence is different as per the requirement given by customer, thus it met the requirement.


I hope you have enjoyed this blog, any query you have, kindly feel free to connect with me at  LinkedIn https://www.linkedin.com/in/ramitpaulinnovation/

Comments

Post a Comment

Popular posts from this blog

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

Image
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-> S
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