We are a netsuite small business user. I am interested in an automatic import of vendor invoices and transactions into Netsuite. We have our own order site which produces customer order data, plus vendor purchase data (ie, purchases that we make from hundreds of vendors).
Currently we are able to use the CSV import for *customer* invoices, but netsuite doesn't seem to support imports of other transaction subtypes such as *vendor* invoices and vendor transactions (at least not with the CSV Import Assistant). So we'd like to create a way to import vendor transactions automatically into netsuite.
1) Configure our current (proprietary web-based) transaction reports, for both customer transactions + vendor transactions, to a format and map which will allow easy import into netsuite. Write a simple script (or whatever solution is required) to import these data reports into netsuite.
Background: Our Current Web environment & Report format:
Our proprietary web-based order system runs on Windows/ in ASP. This system currently produces report formats in both HTML and XLS (Excel) format. Typical report size is relatively small; several hundred records per week. Order data is currently formatted into columns and fields: eg, OrderDate, OrderID, VendorID, ServiceRequested, AmountDue, etc. These are the typical fields that must be mapped for import into netsuite.
This is a small, immediate need project. If this project is affordable and efficiently developed, we will have other web application development needs that follow, including a full redesign/ redevelopment of our web-based order system and website.