Vantage 8.03.405a PO Lines Paste Insert

Here is what worked for me - in case sometime in the future someone
else has the same question:
Column A: 0
Column B: PUR-STK
Column C: the part number
Column D: the rev
Column E: the description
Column F: our qty
Column G: supplier qty
Column H: unit price

Steps taken, Create new PO, enter supplier and buyer data. Click on
lines tab, then lines list tab. Copied Columns A-H from Excel and
right clicked on list grid and did Paste Insert. 164 lines in under 3
minutes.

bw

--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> I want to copy Excel data and paste into POEntry to create lines,
in
> case I confused anyone about what I want to accomplish.
>
> --- In vantage@yahoogroups.com, "Linda Lowney" <llowney@> wrote:
> >
> > Just open any purchase order and go to the line list tab. Right
> click
> > in the header area and select copy all, then past this into
Excel.
> The
> > field headings won't copy, but you can key them into Excel
> manually.
> >
> >
> >
> > Linda
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > Of bw2868bond
> > Sent: Tuesday, December 16, 2008 8:01 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Vantage 8.03.405a PO Lines Paste Insert
> >
> >
> >
> > Can anyone tell me the required columns of data for a Excel
> spreadsheet
> > to be used to paset insert a hundred or so PO Lines?
> >
> > Thanks
> > And Happy Holidays to all :o)
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
Can anyone tell me the required columns of data for a Excel spreadsheet
to be used to paset insert a hundred or so PO Lines?

Thanks
And Happy Holidays to all :o)
Just open any purchase order and go to the line list tab. Right click
in the header area and select copy all, then past this into Excel. The
field headings won't copy, but you can key them into Excel manually.



Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bw2868bond
Sent: Tuesday, December 16, 2008 8:01 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 8.03.405a PO Lines Paste Insert



Can anyone tell me the required columns of data for a Excel spreadsheet
to be used to paset insert a hundred or so PO Lines?

Thanks
And Happy Holidays to all :o)





[Non-text portions of this message have been removed]
I want to copy Excel data and paste into POEntry to create lines, in
case I confused anyone about what I want to accomplish.

--- In vantage@yahoogroups.com, "Linda Lowney" <llowney@...> wrote:
>
> Just open any purchase order and go to the line list tab. Right
click
> in the header area and select copy all, then past this into Excel.
The
> field headings won't copy, but you can key them into Excel
manually.
>
>
>
> Linda
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of bw2868bond
> Sent: Tuesday, December 16, 2008 8:01 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Vantage 8.03.405a PO Lines Paste Insert
>
>
>
> Can anyone tell me the required columns of data for a Excel
spreadsheet
> to be used to paset insert a hundred or so PO Lines?
>
> Thanks
> And Happy Holidays to all :o)
>
>
>
>
>
> [Non-text portions of this message have been removed]
>