Netsuite data integration

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.

Project Goal:

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.


Lihat lagi: netsuite import xls, small business assistant, on web development format in html, formats in excel, eg web development, assistant for windows, affordable website development, csv import invoices netsuite, netsuite freelance, forum web developer netsuite integration, system integration, plus size, netsuite, make integration, Data Integration, csv data, data integration excel, transaction report, map csv fields, redesign report, simple purchase system, user integration, excel required csv, web based purchase order system, small business application

Tentang Majikan:
( 121 ulasan ) Belfast, Ireland

ID Projek: #357943