Requirement 

The client requirement is to update the due date in the invoice record according to the uploading date and the customer’s terms of billing.

Our Solution

Implement a script in the invoice record and script will be updating the due date according to the value selected in the fields “uploading date” and “customer terms”

• We will be using the custom record “Customers__payment_terms” for calculating the customer payment terms. We will be adding one more field in the custom record for “No of days” to enter the days corresponding to each term.
• While doing a CSV import, the  “uploading date” should be populated through the import and the script will be updating the due date(field id: “duedate”) accordingly
  

Assumptions

• While uploading the file, the user will map the custom field ‘Uploading Date’
• User will enter the customer terms field value through UI or CSV import
• We will not be considering the user editing the uploading date field value for due date calculations

Time

Description	Time Required
Analysis,Scripting,Testing, Documentation and deployment	7h