Færdiggjort

Find and Replace program to update PO ID and Vendor-ID's

This project consist of changing the PO-ID’s and Vendor Id’s of a group of records that were incorrectly entered into an inventory system. The problem is that each vendor who is also a customer should have his vendor id created from the prefix “CP-“ and his actual customer number. The CP means customer Purchase Order. By accident the user created normal vendor id’s for all the customers who were also vendors. We need a program created to make, find and replace the bad PO-ID’s and Vendor ID’s with new ones properly [url removed, login to view] vendor number consist of : [CP-] + [customer #]

Example: CP-12345

The PO-ID consist of: [CP-] + [customer #] + [-] + [the actual PO #] Example: CP-12345-1234

Once these vendors ID and po-id’s are created then your program needs to find each instance of the old vendor ID and old po-id and replace it with the properly formatted new ones.

There are multiple tables that contain these po-ids and vendor-ids and your program should search for them and replace each and every instance of these codes with the proper ones. The data you have to work with is only a small sampling of the actual data to be updated but if your program works on the sampling it will work on the real stuff.

**_Actually we have already identified each customer and made the new po_id for these customers. So the vendor table actually has the old vendor id and the new vendor id that are to be used. So that part is very easy.._**

See attachment for mdb and table breakdown:

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Write in Visual basic and in a way so that larger tables can be used after the program is completed.

Evner: Ingeniørarbejde, Microsoft Access, MySQL, PHP, Software Arkitektur, Software Testning, Visual Basic

Se mere: purchase order number example, program to make a site, prefix search, prefix problem, is in a prefix, hire search group, hire a vendor seller, find your coder, find works, find package, find hire, find coder for hire, find a program, find a prefix, find and search in php code, buyer find, all po, find seller, find a seller, visual c software code update

Om arbejdsgiveren:
( 335 bedømmelser ) Lumberton, United States

Projekt ID: #3328046

Tildelt til:

DigitalDreamz

See private message.

$18.7 USD in 5 dage
(34 bedømmelser)
4.5

11 freelancere byder i gennemsnit $51 på dette job

Steel9561

See private message.

$12.75 USD in 5 dage
(197 bedømmelser)
6.7
Premshanks

See private message.

$17 USD in 5 dage
(351 bedømmelser)
6.5
netcruiser

See private message.

$84.15 USD in 5 dage
(102 bedømmelser)
5.4
costincalnuschi

See private message.

$17 USD in 5 dage
(18 bedømmelser)
4.6
daveclarkco

See private message.

$85 USD in 5 dage
(30 bedømmelser)
4.2
ukin

See private message.

$8.5 USD in 5 dage
(29 bedømmelser)
2.8
raojune

See private message.

$67.15 USD in 5 dage
(7 bedømmelser)
2.4
verymasters

See private message.

$85 USD in 5 dage
(1 bedømmelse)
0.0
ready2goarg

See private message.

$80.75 USD in 5 dage
(0 bedømmelser)
0.0
jbanxvw

See private message.

$63.75 USD in 5 dage
(1 bedømmelse)
0.8
blackringvw

See private message.

$42.5 USD in 5 dage
(0 bedømmelser)
0.0