Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Any1 Know of a SQL P.O. Program?

Author  Topic 

SubPar_Coder
Starting Member

23 Posts

Posted - 2005-06-01 : 11:34:20
I'm looking at building a purchase order program that is SQL base. Does anyone know of a program that uses SQL that I can model my program around?



Jack of all trades, Master of none!

MichaelP
Jedi Yak

2489 Posts

Posted - 2005-06-01 : 13:29:28
Great Plains

IMHO, I'd buy an accounting package. Rolling your own is an exercise in futility.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page

raclede
Posting Yak Master

180 Posts

Posted - 2005-06-02 : 00:51:01
well that takes lot of work.. on what I see you'll need to have Biztalk for Integration, .NET/COM+ for uploading/downloading of P.O. hmmm.. really lot of work.

"If the automobile had followed the same development cycle as the computer, a Rolls-Royce would today cost $100, get a million miles per gallon, and explode once a year, killing everyone inside. "

raclede
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-06-02 : 01:12:59
quote:
Originally posted by SubPar_Coder

I'm looking at building a purchase order program that is SQL base. Does anyone know of a program that uses SQL that I can model my program around?



search freshmeat.net or sourceforge.net to see if you can come up with something. You probably won't find anything SQL Server based, but there are plenty of MySQL and Postgres based accounting/ERP/purchasing etc. apps available. Most look like crap though..



-ec

Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-06-02 : 01:18:48
quote:
Originally posted by raclede

on what I see you'll need to have Biztalk for Integration


No you don't



Damian
Ita erat quando hic adveni.
Go to Top of Page

raclede
Posting Yak Master

180 Posts

Posted - 2005-06-02 : 02:52:16
why not use Biztalk. esp. when there are more suppliers that have different formats, how can you do the mapping without Biztalk?

"If the automobile had followed the same development cycle as the computer, a Rolls-Royce would today cost $100, get a million miles per gallon, and explode once a year, killing everyone inside. "

raclede
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-06-02 : 02:59:24
I'm not saying you can't, I'm just saying you don't have to.
People mapped data before biztalk, and people will map data without it for ever.



Damian
Ita erat quando hic adveni.
Go to Top of Page

raclede
Posting Yak Master

180 Posts

Posted - 2005-06-02 : 03:16:07
quote:
People mapped data before biztalk, and people will map data without it for ever.


Yes, People do that manually before but it was so painful, hard to program and its cost, that's why Biztalk 2004 was created and I tell you man its great using Biztalk. easy to manage ,create mappings, and clean the data before inserting in SQL. Actually it can be learn within 3 days.



"If the automobile had followed the same development cycle as the computer, a Rolls-Royce would today cost $100, get a million miles per gallon, and explode once a year, killing everyone inside. "

raclede
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-06-02 : 03:20:10
Maybe so, but you don't NEED it.

AT $50000 a processor (or however much it is) it's also overkill for what a lot of people need. This thread is about a purchase order system, and you're talking about biztalk. It's just misinformation.


Damian
Ita erat quando hic adveni.
Go to Top of Page

byrmol
Shed Building SQL Farmer

1591 Posts

Posted - 2005-06-02 : 19:43:04
Damian...

You can't do anything without BizTalk... It has replaced Vishnu at the center of the earth...

Apologise to the people of the Hindu faith...

DavidM

A front-end is something that tries to violate a back-end.
Go to Top of Page
   

- Advertisement -