Proposal Summary
This proposal outlines the approach to extracting all data from NetSuite efficiently and securely at Mohideen Retail (hereafter referred as client) by Jobin&Jismi (hereafter referred as Implementer).
Requirement from Mohideen Retail
The requirement is to extract data from the NetSuite platform to the target system, ensuring data accuracy, integrity, and compliance with all relevant regulations. This section outlines the specific requirements that will guide the data extraction process.
Deliverables
The deliverables include fetching the master data, transaction data and entity data from NetSuite.
The implementer has reviewed the requirement thoroughly and find below the deliverables the implementer propose.
Master Data
These are foundational data elements that must be extracted first:
Customer Data:
Customers
Customer Addresses
Lead details
Vendor Data:
Vendors
Vendor Contacts
Vendor Addresses
Employee Data:
Employees
Item/Inventory Data: The stock and available quantity of the items will be added in the file.
Item Master (e.g., Inventory Items, Payment, Service and subtotal Items)
Units of Measure
Transactional Data
Transactional records may need to be extracted for operational continuity, auditing, or compliance purposes. The transactions will be extracted based on the locations. The following transactions will be considered for the extraction.
· Bill
· Bill Credit
· Bill Payment
· Cash Refund
· Cash Sale
· Credit Memo
· Customer Refund
· Deposit
· Inventory Adjustment
· Inventory Transfer
· Invoice
· Item fulfilment
· Item Receipt
· Journal
· Payment
· Purchase Order
· Return Authorization
· Sales Order
· Transfer
· Vendor Return Authorization
Classification:
· Subsidiary
· Department
· Locations
· Class
Reports:
The following reports will be extracted on a yearly basis.
· Trial balance
· General Ledger
· Profit and loss
· Balance sheet
Chart of accounts
The chart of accounts will be fetched from NetSuite.
Assumption:
· All the data in the Excel file will follow a consistent date format.
Risk
· Excel treats long numeric sequences as numbers and displays them using scientific notation
Notes
The scope and the provided estimate are based on the anticipation, expectation, and understanding through our discussions and email. If the scope change/additional feature development identified during actual development will be treated as change request.