Import Excel Sheet into Epicor

We're doing a very similar thing.

You should be able to "reveal" a UD table as a menu item. Then you can copy/paste the data into it from Excel. Once its in the UD table you can BAQ/Dashboard it.

To add the UD Table:
1.System Management\Utilities\Menu Maintenance
2.Navigate to where you would like the UD table to be
3.New Menu
4.Choose the Program for your UD Table, e.g. Table UD14 is:
Epicor.Mfg.UI.UD14Entry.dll
5.The table will now appear and you can open it, list view, and copy/paste.

Good luck!

--- In vantage@yahoogroups.com, "anithayedavalli" <anithayedavalli@...> wrote:
>
> Hi,
> I have an excel sheet which has last year sales data.They users want to see this data in dashboard.How can I import this static data into epicor.
> Please help.
>
> Regards,
> Anitha
>
Hi,
I have an excel sheet which has last year sales data.They users want to see this data in dashboard.How can I import this static data into epicor.
Please help.

Regards,
Anitha
One of the more simpler methods would be to set yourself up a UD table,
then list paste the information into the table. There are cooler more
automated (more complicated ways), but this is down and dirty.



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of anithayedavalli
Sent: Thursday, October 15, 2009 1:39 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Import Excel Sheet into Epicor





Hi,
I have an excel sheet which has last year sales data.They users want to
see this data in dashboard.How can I import this static data into
epicor.
Please help.

Regards,
Anitha





[Non-text portions of this message have been removed]