Build a report for a dashboard which takes each account and gives the last 6 month sales history. Right now we don't enter sales data in SalesForce. This is in our proprietary web based system. We input our unique account number in sales force, so this number could be used to grab sales data from our system.
What would be the best way to push our sales data into some custom data types (whatever those types are), so I can create a datasource on the custom data types to pull 6 months worth of data? Figure the custom data type would contain (account number, sales date (Y-m-d), and sales amount).
Any help here would be grately appreciated.