Return Refund Authorization to Bulk Credit Memo generation

Overview

About the Client

Our client is an innovative Insurtech Company focused on simplifying life insurance through advanced technology. They offer a variety of insurance products, including term life, mortgage protection, and retirement solutions, designed to be accessible and straightforward. Customers can easily apply for policies online or receive personalized guidance from a network of licensed agents. The company emphasizes community outreach and continuous innovation, aiming to make life insurance more approachable for all. Their commitment to technology and customer service sets them apart in the insurance industry.

The Challenge       

• The client used the standard process for handling Refund Return records to generate corresponding Credit Memos within the NetSuite environment.
• However, the standard process only allowed the processing of one Refund Return record at a time, restricting their ability to process multiple records simultaneously.
• Additionally, the client faced the challenge of manually applying Invoices that shared the same PO number as the generated Credit Memo’s PO number, which made the procedure time-consuming and labor-intensive.

Our Solution 

• To address the issue, we developed a user interface resembling the standard process for processing Return Refunds, featuring a list of open Return Refunds with checkboxes, along with “Mark All” and “Unmark All” buttons for easily selecting or deselecting all records at once.
• When the Submit button is clicked, a scheduler initiates to process of all selected Refund Return records and generates the corresponding Credit Memos.
• Before saving each Credit Memo, the script matches the PO numbers of the Credit Memos with those of available Invoices.
• If the PO numbers match, the invoices are automatically applied, streamlining the entire process.
• Additionally, we have also provided an interface that displays the processing percentage of the records upon submission, while the credit memos are being generated in the backend, and upon completion it automatically redirects to the list of newly created credit memos.

Technology & tools used

• Suitelet Script
• Scheduled Script
• User Event Script
• Client Script
• Saved Search

Results

The Impact            

• The client can now efficiently process multiple Return Refund records at once to generate the corresponding Credit Memos.
• The efficiency of Bulk processing is achieved by allowing users to simply select the desired records, eliminating the previously time-consuming one-at-a-time process.
• The automated application of Credit Memos to Invoices with matching PO numbers reduces manual effort and significantly enhances efficiency by eliminating the need for manual intervention to process each Return Refund individually.
• The process is now fully automated, ensuring a smoother and faster application of Credit Memos to Invoices.