Em Andamento

VB6 Create Purhcase Order in SQL & PDF

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 .pdfs of each PO to be faxed. 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 a PDF file. The filename should take the format {orderid}-{vendorid}.pdf.

## Deliverables

Screen captures showing the various table structures are included in the attatched zip file.

* * *This broadcast message was sent to all bidders on Wednesday Nov 18, 2009 12:15:16 AM:

To all bidders. The .pdf file seems to be a bit of an issue. We knew this when we posted. I dont really want to use a printer driver to create the .pdf. In order to make things easier for everyone, we can accept the Purchase Order being created as an HTML file instead of a .pdf. That will be acceptable. We can still email the html file or print it. So, the .pdf requirement has now been dropped from this project.

* * *This broadcast message was sent to all bidders on Wednesday Nov 18, 2009 7:32:48 AM:

Please make sure you post your bids shortly if you are interested. We are going to make our selectionina few hours.

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: vb6 0, sql pdf file, sql database program, requirement application format, how to create database using php, how to create database program, access vendor database, all po, visual basic vb6, purchase order, Printer driver, po file, database html sql, create pdf file, purchase order vb6, create purchase order, php sql pdf, php database project pdf, order field, basic order taking, sql created, php table pdf, create file table access, access order, application written visual basic

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

ID do Projeto: #2972850

Premiar a:

illuminesoft

See private message.

$123.25 USD em 14 dias
(323 Avaliações)
7.4

9 freelancers estão ofertando em média $152 para este trabalho

weng0000

See private message.

$212.5 USD in 14 dias
(783 Comentários)
7.0
kevneth

See private message.

$106.25 USD in 14 dias
(38 Comentários)
5.6
lvdt

See private message.

$102 USD in 14 dias
(101 Comentários)
5.1
Altantsetseg

See private message.

$297.5 USD in 14 dias
(18 Comentários)
5.0
rcnvw

See private message.

$212.5 USD in 14 dias
(14 Comentários)
4.6
LigaSoft

See private message.

$102 USD in 14 dias
(0 Comentários)
0.0
jasonwelbourne

See private message.

$85 USD in 14 dias
(0 Comentários)
1.3
ieetechnologies

See private message.

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