Hi
I am a new User to the forum, we have just recently gone live withh Netsuite &, I am looking for some advice.
We have noticed that on our Support Tickets & Opportunities, when we import the closed ones from our legcay Systems, the Standard Netsuite Field 'Actual Closed Date' is populated not with the date that the Support case or the Opportunity was Actually closed ie, the same date as that field in our Legacy System(s), it is populated with the Date you Imported the Data from the legacy System. This makes analysis such as this Month vs January Last year impossible as, we have many thousands of records that should be spread out over last year 2015 when they were really closed but, on analysis it looks like we closed all these many thousand Opportunities & Support Tickets on one day n October 2015 which, ws the day we did the import.
We have had many a discussion with Netsuite PS & technical Support &, via our Account Managers but apprently, there is nothing that can be done to address this meaning we are being forced to not only put garbage into our new system but actually, leave it there as well. The only thing that can be done is an enhancement request which, we have ibviously voted for quite vociferously!
We have got round it by adding a Custom Field (basically called Actual Actual Closed Date) which holds the real closed date from the legacy system but this has an undesired "disbenefit" in that we cannot now analyse the data properly for KPI's. Reports etc etc. We are being offered two alternatives to this by our account managers & apparently other Customers, hence why I am on here, have done one of the two methods: - [LIST=1]
[*]Keep to the standard KPIs, but create an interim one for historical transactions.
[*]Create new KPIs/reports using the new custom field for actual close date, make sure that the new custom field will inherit the actual close date of new transactions created in NS
[/LIST] I have asked our Account Manager to put us in Contact with 2 of their existing Customers so we can have a chat with them to find out which of the two options they took when they went live with a view to getting advice on the best option to take & why but apparently they "don't do that due to Confidentiality & Privacy constraints"
Would anybody on here be aware of this situation, faced when they went live with their Netsuite instance & be prepared to share their experience with us?
Many thanks
Scott Bennion
Project Manager
NT CadCam
United Kingdom