Netsuite, Consolidated Invoicing & OOP integration for financial operations

Project goals:

- Implement consolidated invoicing functionality within Netsuite.

- Integrate Netsuite with an Online Payment Platform (OOP) for streamlined financial operations.

Accomplishments:

- A robust consolidated invoicing system has been implemented in Netsuite. This allows the client to send a single invoice for multiple orders.

- Several improvements have been developed in order to handle both CBS Manual and CBS Automation Creation with a grouping of invoices based on merchant_id, queue creation for processing, failure email sent, and the ability to maintain logs for failed records and reprocess them.

- The interface has been changed in order to provide more flexibility and make it more user-friendly.

- Several custom scripts and workflows have been tweaked to improve the process of generating consolidated invoices.

- Integration between Netsuite and OOP has been accomplished.

- An efficient mechanism has been designed for real-time synchronization of financial data between Netsuite and the OOP.

- Map/reduce script to batch process the payment data from the OOP to Netsuite has been tweaked.

- Existing invoice and payment records within Netsuite have been successfully updated to comply with the new consolidated invoicing and OOP integration setup.

- An alerts system has been implemented to track and report any delayed payments or invoices to the relevant team.  

Project Team:

1 Senior Netsuite Developer

Client:

e-Commerce Company with 100+ employees

Outcome:

Cut the expenses of the company by automating financial processes