D365 Accounts Payable: Generate Vendor Retention for Project based Purchases

-


Generate Vendor Retention


In previous blog, we setup a vendor retention term over a Project. Now in this blog we will see how that setup will work in order to generate vendor retentions, so we are continuing the same scenario.


First, I would like to tell you how vender retention solution schema works. 

When we create a Purchase order for a Project, on purchase order lines 'vendor retention term' appear (as we have set it up over project for vendor same as PO's vendor). So when we generate invoice after receipt the retention account that has been setup over 'Accounts for automatic transactions' form gets hit with the retained amount.

In normal scenario following are the transactions those take place over invoicing.

 Development work in progress  Db
 Vendor Cr

However, for vendor retention following financial transaction should take place on generating invoice.

Development work in progress  Db
Vendor Cr
Vendor retention Cr

Let's verify it.

I have created a purchase order for a project with vendor retention term with an item quantity of 100 and unit price 250.


First, I generated receipt of 50 quantity and invoiced it. Following is the invoice voucher



It can be seen here that as per associated vendor term, on 50% receipt 10% amount got retained separately in the vendor retention amount. 
Development work in progress  12500 (Db)
Vendor 11250 (Cr) 
Vendor retention 1250 (Cr)
Next, I generated receipt of remaining 50 quantity and invoiced it. Following is the invoice voucher of second invoice. As per setup vendor retention term, this time 20% retention amount got retained.



Development work in progress  12500 (Db)
Vendor 10000 (Cr) 
Vendor retention 2500 (Cr)
Now, through payment journal above mentioned invoices can be settled. The important point to make here when you will select these invoices to settle over payment journal lines it will bring only Vendor balance amount.

Comments

  1. Anonymous27 March 2020 at 21:16

    Hey I’m Martin Reed,if you are ready to get a loan contact.Mr Benjamin via email: lfdsloans@lemeridianfds.com,WhatsApp:+1 989-394-3740 I’m giving credit to Le_Meridian Funding Service .They grant me the sum 2,000,000.00 Euro. within 5 working days. Le_Meridian Funding Service  is a  group investors into pure loan and debt financing at the  returns of 1.9% to pay off your bills or buy a home Or Increase your Business. please I advise everyone out there who are in need of loan and can be reliable, trusted and capable of repaying back at the due time of funds.

    ReplyDelete

Post a Comment

Popular posts from this blog

D365 Accounts Payable: Settle Vendor Retention for Project based Purchases

-
Image
Settle Vendor Retention In previous blogs, I worked on vendor retention setups and discussed how vendor retention gets generated on invoicing a purchase order. Now, in this blog I will show how vendor retention can be  settled at the end when an organization wants to pay off all retained amount for the purchase order which has been already invoiced completely. Let's start... Navigate to Accounts Payable > Invoices > Pending Vendor Invoices  Click From Purchase Order Following query form will appear Make sure all filter should clear except the Purchase order which must have the Purchase order number specified for which retention has been deducted and fully invoiced so has the status as 'Invoiced'. Click OK A row will appear in the following grid. Enter Invoice number Set Default quantity for  lines = Ordered quantity ( Because the mentioned order is fully invoiced, the system does not show the invoice line with other available
Read more

D365 Security Role: Create New Security Role

-
Image
In Microsoft Dynamics 365 for Finance and Operations, role-based security is aligned with the structure of the business. Users are assigned to security roles based on their responsibilities in the organization and their participation in business processes. The administrator grants access to the duties that users in a role perform, not to the program elements that users must use. In role-based security, access is not granted to individual users, only to security roles. Users are assigned to roles. A user who is assigned to a security role has access to the set of privileges that is associated with that role. A user who is not assigned to any role has no privileges. There are existing privileges, duties and roles for each functionality available out of the box in Dynamics 365. Nevertheless, to meet specific requirements new roles can be created easily.   In order to fabricate a new security role in D365, following steps need to be pondered. 1.       Create a ‘Privilege’
Read more

D365/PowerBI: Power BI OData Connection (Part I)

-
Image
Microsoft  Power BI  is a cloud based data and analytics reporting tool that helps organizations bring together disparate data sets into reporting dashboards.   D365 Finance and Operations users can also use Power BI: T o design visual reports and dashboards from D365 data-sets   To embed these dashboards  to D365. In this blog series, we will see how D365 user can work with Power BI. I am going to divide this topic in four parts. Part I: Create OData connections to access D365 data to design visuals in Power BI Part II: Design a visual from D365 dataset Part III:  Configure Power BI to pin dashboards in D365 Part IV: Pin Power BI dashboards to D365 In first part, we will connect the Power BI with D365F&O through OData connections to access dataset so that it can be utilized to design visuals. Pre-Requisites: You should have a Power BI  account with your work domain and Power BI desktop app installed. Steps: We will start by accessing Power BI desk
Read more