Sorry for the repost, but this didn't get much attention in the import/export section:
I have a cloud computing business which sells customers production (business) computing by the hour, eliminating the need for them to have an IT department or own servers. The way we do billing is much like a cell phone or electrical company, which is usage-based. I'd like to simplify the billing by sending an invoice with totals, and have the details available online to the customer in their Customer Center.
Our usage metering system can generate detail data for customers to my specification. However, I need an architecture do import and display this data in netSuite. I'd like to start small and grow the customization, so I thought I'd start with a custom record structure for the data and import it by CSV import, then display it with a custom search in the Customer Center. I have run into the following problems I need help with:
1) The usage data is in the form of: Customer (as a list/record type), date, usage type (text), amount of usage (number). How do I import customer-related data by CSV? My trials so far don't work because NetSuite isn't recognizing the customers as a valid customer. How would I use internal IDs to get the data in and link the records to the customer record? Is this possible only with Web Services?
2) Once the data is in Netsuite - which I have prototyped with some sample data - how do I display it in the customer center such that the customer only sees their own data? I have a working search link in the customer center, but it shows the data for all customers, even though the usage records actually have a customer field in them that is linked to the customer record. I tried to make the usage data a child record of the customer record, but this did not help. Is this a permissions problem? It works just fine for a case search so why not for the usage data?
3) I'd like the search to display on a new tab in the customer center, but can't seem to get that to happen - only on the home page. This is not as important as 1 or 2 above.
Any help would be very much appreciated!
Thanks,
-Eric