OT: Santa's TOP TEN Picks for Christmas 2003,

Yahoo Archive
1
' 10. Fashion Body Armor

' 9. TRAIN!! Tickets

' 8. A Life time prescription of Cipro (from Canada)

' 7. A "DO NOT CALL" list THAT WORKS!!

' 6. Missile defenses on Santa's Sleigh

' 5. Coal for all the Spammers

' 4. Looking forward to moving from that IT position to that exciting
FOOD SERVICE job

' 3. Another really BIG Power blackout so I can try out those nice
scented Candles

' 2. Hope that Saddam has a really really really nice Christmas with
our boys in Iraq

' 1. Screw the puppy kid, We're getting the bomb sniffing Dog!!!



Gone for the rest of the week everybody, Have a nice holiday.


Shirley :}

Tracking #: DA7CCD7EDAB29A4E94379C512CA5B41BFE7482B3


[Non-text portions of this message have been removed]
2
Has anyone done an import from text files (.CSV) to create Vantage
Sales Orders?

We set up a small website so that one corporate customer can use to
order frequently used parts. They have locations in 30 states, and
wanted to short circut the ordering system. Long story short we are
currently entering the orders directly in vantage sales order entry
and need to cut down entry time. The web host can give us a CSV
with all the particulars in it, and even segment the orders
into 'head' and 'detail'records with relational keys. I am just
starting to use the ProVision+ AppBuilder interface so I'm pretty
green at it so far. My big worry is "Which tables are hit when you
do a sales order, and which data items are written there. Obviously
OrderHed and OrderDtl, but when do allocations go in, and which
other files?

Any and all help is appreciated.

James
3
The EDI module does this.

Patrick Winter


-----Original Message-----
From: jcmorton1 [mailto:james.morton@...]
Sent: Monday, December 22, 2003 4:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] create sales-orders from text file


Has anyone done an import from text files (.CSV) to create Vantage
Sales Orders?

We set up a small website so that one corporate customer can use to
order frequently used parts. They have locations in 30 states, and
wanted to short circut the ordering system. Long story short we are
currently entering the orders directly in vantage sales order entry
and need to cut down entry time. The web host can give us a CSV
with all the particulars in it, and even segment the orders
into 'head' and 'detail'records with relational keys. I am just
starting to use the ProVision+ AppBuilder interface so I'm pretty
green at it so far. My big worry is "Which tables are hit when you
do a sales order, and which data items are written there. Obviously
OrderHed and OrderDtl, but when do allocations go in, and which
other files?

Any and all help is appreciated.

James


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
4
I know but this is a little tiny piece of EDI, only one customer,
and the margin on these parts is very low. So the CFO won't spring
for an EDI module license.

--- In vantage@yahoogroups.com, pjw@s... wrote:
> The EDI module does this.
>
> Patrick Winter
>
>
> -----Original Message-----
> From: jcmorton1 [mailto:james.morton@b...]
> Sent: Monday, December 22, 2003 4:30 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] create sales-orders from text file
>
>
> Has anyone done an import from text files (.CSV) to create Vantage
> Sales Orders?
>
> We set up a small website so that one corporate customer can use
to
> order frequently used parts. They have locations in 30 states,
and
> wanted to short circut the ordering system. Long story short we
are
> currently entering the orders directly in vantage sales order
entry
> and need to cut down entry time. The web host can give us a CSV
> with all the particulars in it, and even segment the orders
> into 'head' and 'detail'records with relational keys. I am just
> starting to use the ProVision+ AppBuilder interface so I'm pretty
> green at it so far. My big worry is "Which tables are hit when
you
> do a sales order, and which data items are written there.
Obviously
> OrderHed and OrderDtl, but when do allocations go in, and which
> other files?
>
> Any and all help is appreciated.
>
> James
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
5
Try Ground Control or look into other windows macro utilities. Ground
Control can read a text file, when tweaked it can speed up repetitive data
entry functions.

Patrick Winter


-----Original Message-----
From: jcmorton1 [mailto:james.morton@...]
Sent: Monday, December 22, 2003 4:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: create sales-orders from text file


I know but this is a little tiny piece of EDI, only one customer,
and the margin on these parts is very low. So the CFO won't spring
for an EDI module license.

--- In vantage@yahoogroups.com, pjw@s... wrote:
> The EDI module does this.
>
> Patrick Winter
>
>
> -----Original Message-----
> From: jcmorton1 [mailto:james.morton@b...]
> Sent: Monday, December 22, 2003 4:30 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] create sales-orders from text file
>
>
> Has anyone done an import from text files (.CSV) to create Vantage
> Sales Orders?
>
> We set up a small website so that one corporate customer can use
to
> order frequently used parts. They have locations in 30 states,
and
> wanted to short circut the ordering system. Long story short we
are
> currently entering the orders directly in vantage sales order
entry
> and need to cut down entry time. The web host can give us a CSV
> with all the particulars in it, and even segment the orders
> into 'head' and 'detail'records with relational keys. I am just
> starting to use the ProVision+ AppBuilder interface so I'm pretty
> green at it so far. My big worry is "Which tables are hit when
you
> do a sales order, and which data items are written there.
Obviously
> OrderHed and OrderDtl, but when do allocations go in, and which
> other files?
>
> Any and all help is appreciated.
>
> James
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer
at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/PhFolB/TM
---------------------------------------------------------------------~->

Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
6
If you decide for EDI, I have an access database that connects to Vantage
using ODBC to verify customer (only on 5.1), part, ship to, ship via, etc
needed to create an 850 (invoice). I also had good experience with ground
control.

Mario Aguirre
Lakin General

-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Tuesday, December 23, 2003 7:07 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: create sales-orders from text file

Try Ground Control or look into other windows macro utilities. Ground
Control can read a text file, when tweaked it can speed up repetitive data
entry functions.

Patrick Winter


-----Original Message-----
From: jcmorton1 [mailto:james.morton@...]
Sent: Monday, December 22, 2003 4:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: create sales-orders from text file


I know but this is a little tiny piece of EDI, only one customer,
and the margin on these parts is very low. So the CFO won't spring
for an EDI module license.

--- In vantage@yahoogroups.com, pjw@s... wrote:
> The EDI module does this.
>
> Patrick Winter
>
>
> -----Original Message-----
> From: jcmorton1 [mailto:james.morton@b...]
> Sent: Monday, December 22, 2003 4:30 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] create sales-orders from text file
>
>
> Has anyone done an import from text files (.CSV) to create Vantage
> Sales Orders?
>
> We set up a small website so that one corporate customer can use
to
> order frequently used parts. They have locations in 30 states,
and
> wanted to short circut the ordering system. Long story short we
are
> currently entering the orders directly in vantage sales order
entry
> and need to cut down entry time. The web host can give us a CSV
> with all the particulars in it, and even segment the orders
> into 'head' and 'detail'records with relational keys. I am just
> starting to use the ProVision+ AppBuilder interface so I'm pretty
> green at it so far. My big worry is "Which tables are hit when
you
> do a sales order, and which data items are written there.
Obviously
> OrderHed and OrderDtl, but when do allocations go in, and which
> other files?
>
> Any and all help is appreciated.
>
> James
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/>


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer
at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
<http://www.c1tracking.com/l.asp?cid=5511>
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/PhFolB/TM
<http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/PhFolB/TM>
---------------------------------------------------------------------~->

Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/SIG=12c10p8qb/M=266841.4316200.5507732.1261774/D=egroup
web/S=1705007183:HM/EXP=1072271219/A=1911856/R=0/*http:/www.lifescapeinc.com
/picasa/landing.php?capid=222&caId=1985> click here


<http://us.adserver.yahoo.com/l?M=266841.4316200.5507732.1261774/D=egroupmai
l/S=:HM/A=1911856/rand=281750226>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.


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