In this blog I will discuss how we can get the vendor retention percentage by having project order id and vendor account. I have created a job to get the vendor retention percentage. Please see below image.
- PSAVendorRetentionTermsLine table contains retainage schedules for project purchases.
- ProjPWPVendorRetentionSetting table contains information about project-vendor PWP (Pay when paid) and vendor retention setting.
- Get vendor retention settings by passing arguments.
- Project Order Id
- Vendor account
- Account Code
- Get retention term as per rule id got from vendor retention settings.
That is all, If you have any questions or queries do comment in the comment section below.