Importing Budgets by Period

I wrote a similar SC workflow to do this. I¹d be willing to send mine
along, as I assume that if you have the (free) SC run time license you can
import existing workflows but just can¹t edit/create your own.


On 11/26/08 11:19 AM, "Craig Weiss" <cweiss@...> wrote:

>
>
>
> I just wrote a script to do this using Service Connect. I don't
> suppose you have Service Connect do you? If not, I don't know of
> another way to accomplish this.
> Craig
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "kerry_inps" <kerrytravis@...> wrote:
>> >
>> > Good morning all,
>> >
>> > I am working on our annual budget and want to export from Excel. I
>> > see where I can copy and paste it by period, but only if the
> budgeted
>> > amount per period is the same. It then multiples the amount by 12
> to
>> > get the annual budget amount. However, with sales spiking in
> certain
>> > periods, we have different budgeted amounts per period. The only
> way
>> > that you can do it is to copy and paste the Excel amounts, and then
> go
>> > in and edit the individual period amounts. That is a lot of work!
>> > Does anyone have a work around to get the desired result? We are
> on
>> > version 8.03.305.
>> >
>> > Thanks a lot for any help.
>> >
>> > Kerry Travis
>> > Controller
>> > International Name Plate Supplies Ltd.
>> >
>
>
>



[Non-text portions of this message have been removed]
Good morning all,

I am working on our annual budget and want to export from Excel. I
see where I can copy and paste it by period, but only if the budgeted
amount per period is the same. It then multiples the amount by 12 to
get the annual budget amount. However, with sales spiking in certain
periods, we have different budgeted amounts per period. The only way
that you can do it is to copy and paste the Excel amounts, and then go
in and edit the individual period amounts. That is a lot of work!
Does anyone have a work around to get the desired result? We are on
version 8.03.305.

Thanks a lot for any help.

Kerry Travis
Controller
International Name Plate Supplies Ltd.
Good morning all,

I am working on our annual budget and want to export from Excel. I
see where I can copy and paste it by period, but only if the budgeted
amount per period is the same. It then multiples the amount by 12 to
get the annual budget amount. However, with sales spiking in certain
periods, we have different budgeted amounts per period. The only way
that you can do it is to copy and paste the Excel amounts, and then go
in and edit the individual period amounts. That is a lot of work!
Does anyone have a work around to get the desired result? We are on
version 8.03.305.

Thanks a lot for any help.

Kerry Travis
Controller
International Name Plate Supplies Ltd.
I just wrote a script to do this using Service Connect. I don't
suppose you have Service Connect do you? If not, I don't know of
another way to accomplish this.
Craig

--- In vantage@yahoogroups.com, "kerry_inps" <kerrytravis@...> wrote:
>
> Good morning all,
>
> I am working on our annual budget and want to export from Excel. I
> see where I can copy and paste it by period, but only if the
budgeted
> amount per period is the same. It then multiples the amount by 12
to
> get the annual budget amount. However, with sales spiking in
certain
> periods, we have different budgeted amounts per period. The only
way
> that you can do it is to copy and paste the Excel amounts, and then
go
> in and edit the individual period amounts. That is a lot of work!
> Does anyone have a work around to get the desired result? We are
on
> version 8.03.305.
>
> Thanks a lot for any help.
>
> Kerry Travis
> Controller
> International Name Plate Supplies Ltd.
>