PROPOSAL SUMMARY
This proposal is to apply a specific amount of vendor prepayment amounts on the purchase orders by creating a custom field in the item line level and this amount will be sourcing to the Bill record after being calculated as per the predefined percentage.
REQUIREMENT
Ten Acre Gift needs to apply a fixed percentage of the prepayment amount for the line item in the Bill record.
When the user is creating a vendor prepayment application record and the vendor prepayment amount will be applied to a purchase order record. The prepayment amount need not be fully applied to the bill but only as a fixed percentage of the vendor prepayment at the item line level.
It is based on the percentage defined in the custom field in the purchase order item line level.
OUR SOLUTION
We will be creating a custom field ‘Prepayment Percentage’ in the vendor record to store the required percentage of the Vendor prepayment that is required to apply to the bill. This will be sourced to the purchase order by creating a custom field named ‘Required prepayment Percentage’ in the item line level.
When a vendor prepayment Application is created, then the prepayment amount will be applied to multiple bills by splitting the amount based on the percentages mentioned in the purchase order.
This will prevent the full amount of the vendor prepayment application to be applied to a single bill record and thereby only a predefined percentage of the vendor prepayment amount will be applied in each item line level.
If the percentage amount of the bill is exceeding the available balance of the vendor prepayment amount, then the remaining prepayment amount will be applied to it.
We can use a user event script to accomplish this functionality. We will create a user event script and deploy it to the vendor prepayment Application. From the vendor prepayment application record, we will get the details of the prepayment record and the corresponding Purchase Order number. Also, from the vendor prepayment application record we will get the billed Purchase Order number. We will compare both the record and get the total amount from the item line and apply the Required prepayment Percentage in the vendor prepayment Application.
ASSUMPTIONS
- This solution will override the actual vendor prepayment amount to be applied.
- If the required percentage value is manually changed, it will not affect the already applied vendor prepayment amount.
- If the required percentage amount is not given, the full prepayment amount will be assigned to the bill in a standard way.
- If the item receipt is partially received, then the Bill amount percentage will be calculated.
- Whatever percentage is on the purchase order on the line level, for each of the bills, we will apply the required percentage of the bill amount as the applied amount in the vendor prepayment.
- If the percentage amount of the bill is exceeding the available balance in the vendor prepayment record, then the remaining amount will apply as the applied amount in the vendor prepayment application record.