Em Andamento

VB6 Create SQL based Purchase Order & write html file

We require a Visual Basic application which will run through a SQL table of orders and create one or more purchase orders for the items ordered. Additionallly, it must create? an html of each PO to be faxed, printed or emailed. This application MUST BE written in Visual Basic 6.

We wil provide access to our development SQL database to the chosen bidder.

The program needs to look through tblOrderDetails where the filed LinePurchased = 0. Zero indicates the line has not been pruchased yet, 1 means it has & can be skipped.

For each item found, where Line Purchased =0, the item must be looked up in tblProducts, via the prodSKU field to check the StockItem field. If StockItem = 1, i is a stock item and does not need to be purchased. If StockItem=0, the PrimarySupplier field must be taken and matched in tblVendors to determine the appropriate vendor to purchase the item from.

Costs for each of the items can be found in tblProdcosts by match on the VendorID & prodSKU fields.

The shipping information (where the items will be delivered to) is retrieved by taking the OrderID on the specific line being purchased, atching it in tblOrders.

Each individual OrderID must have it's own purchase order created.

Depending how many items are on an order, which are not stock items, on order may equal two or more purchase orders.

The purchase orders must be created using the SQL tables tblPoHead & tblPoDetails.

In addition, after the PO has been created & inserted into the table, a Purchase Order must be created suitable for faxing or emailing as an attachemnt. This PO must take the form of an? HTML file. The filename should take the format {orderid}-{vendorid}.html.

## Deliverables

SQL table structures as well as a sample Purchase Order layout are included in the attached file.

Habilidades: Engenharia, Microsoft, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, SQL, Visual Basic, Área de trabalho do Windows

Ver mais: sql database program, access vendor database, visual basic vb6, sql based, purchase, purchase order, po file, database html sql, purchase order vb6, create purchase order, order field, basic order taking, sql created, create file table access, access order, application written visual basic, can match order, vb6 sample, amp visual basic, write file vb6, html layout sample, format html table, html shipping, sample visual basic database application, html create table

Acerca do Empregador:
( 38 comentários ) United States

ID do Projeto: #3006304

Premiar a:

alekhine1962

See private message.

$127.5 USD em 14 dias
(24 Avaliações)
4.6

14 freelancers estão ofertando em média $225 para este trabalho

ngscoder

See private message.

$764.15 USD in 14 dias
(172 Comentários)
7.5
pShankar2

See private message.

$255 USD in 14 dias
(404 Comentários)
7.1
abvdb

See private message.

$153 USD in 14 dias
(97 Comentários)
6.0
mrrcomputers

See private message.

$212.5 USD in 14 dias
(29 Comentários)
5.3
magentoguy

See private message.

$212.5 USD in 14 dias
(7 Comentários)
5.1
codedeveloperin

See private message.

$153 USD in 14 dias
(43 Comentários)
5.6
showm3urluvvw

See private message.

$212.5 USD in 14 dias
(23 Comentários)
4.2
rperaza26vw

See private message.

$119 USD in 14 dias
(6 Comentários)
2.7
aruzvw

See private message.

$425 USD in 14 dias
(2 Comentários)
2.9
hymag

See private message.

$156.4 USD in 14 dias
(2 Comentários)
1.9
vw6985564vw

See private message.

$85 USD in 14 dias
(0 Comentários)
0.0
Lullly

See private message.

$85 USD in 14 dias
(0 Comentários)
0.0
frosensl

See private message.

$191.25 USD in 14 dias
(0 Comentários)
3.5