Inventory/Distribution system

Software application, preferably written in C# 2.0 (Visual Studio .NET 2005). If you wish, you may use .NET 3.0 (workflows, etc) although this would be exceed my expectations. The database must be MS SQL 2005 Express Edition.

Code will be reviewed for performance and potential to be scaled. An API should be exposed, and use of a simple middle-tier library for data persistence is expected.

You may use third party products and applications, so long as the costs either fall within the estimate or are otherwise approved by myself. This may prove to be a good idea - anything that would make the project simple and quick would be preferred. The use of freely available and popular libraries and frameworks is suggested.

I was personally not able to find a reasonably-priced software package that does the following with in an intuitive user interface:

(In my opinion, this should be fairly straightforward and inexpensive to develop)

1. An application (exe) with no user interface that, when run, will process the text file(s) in a directory specified as a command line argument or config setting. The files will be processed in order of date modified, and each will be an EDI/CSV text file containing a batch of orders to be fulfilled (we will provide you with the text file's layout/schema).

1.1 Each file contains any number of orders. An order will contain a customer's name and address, shipping method and any number of line items that should correspond by UPC to an item in the inventory (stored in a table in the database).

1.2 Each order is saved to a record in a database with an OrderState field.

1.3 There are two cases:

1.3.1 For any order that can be fulfilled immediately (where the actual product stock level minus the reserved level is greater than 0 for all ordered products), the order state should be marked as being in the "picking" state, the reserve level should be increased by one and a pick ticket should automatically be printed in real-time. The pick ticket (aka packing slip) is simply the order details (what was ordered, by whom, etc) with a barcode for the order number. All orders should be held until they are ready to ship complete.

1.3.2 If for any product in the order the actual stock level minus reserved level is 0 or less, the backorder count will be increased. A corresponding purchase order (PO) record will be created, or if one already exists it will be updated to reflect the backorder.

1.4 The application should summarize it's actions, any errors, etc to a log file that is stored on disk and emailed

2. A purchase order generator, which compiles a list of items on backorder grouped by item and vendor. A user can select a vendor and generate/print the corresponding PO, which is simply a a human readable report. There should also be the ability to have a plugin (or be able to call out to another application) to do additional work with the PO data (e.g., generate and transmit CSV file).

3. (This application can be saved for a 2nd release and possibly in separate work order) An application that regularly monitors backorders and uses an intelligent algorithm that uses common practices of supply chain management to suggest intelligent purchase orders (POs) based on historical order volumes and other factors. You must be able to define and change the characteristics that are used to determine when a PO is automatically generated (min/max levels, supplier volume discounts, etc.). I am not very familiar with distribution systems and everything that this entails, so I'd appreciate if the person working on this project could provide some guidance in this area.

4. A front end to

4.1 Import products in batch via CSV files to a database table. This CSV will be provided. There are approximately 500,000 items to be imported.

4.2 Allow user entry of a new product using a form

4.3 Search. Any field should be searchable, however, there will be a combination of several specific fields that will almost always be used to find products. We will explain how these fields combine to give the product ID that the products table is keyed on. Search results should display matching products as well as their inventory counts and a link to any open orders that are requesting the searched item.

4.4 Receiving screen, which adds items to inventory by physically scanning UPC barcodes. This operates in one of two modes:

4.4.1 One-by-one (each item scanned increases stock level by one)

4.4.2 Barcode scan followed by quantity entering (e.g., item is scanned, user enters 25 [Enter] and stock level is increased by 25).

4.4.3 The mode could be toggled to allow for removing items from inventory rather than adding

4.4.5 You should be able to optionally select a purchase order. Once a load of items have been scanned, you would be shown the products that did not match the PO.

5. Shipping application. We would like to use the application remotely, away from a computer screen by using a cordless barcode scanner (therefore, there should be no prompts or dialog boxes during the shipping process). We would take a printed pick ticket, scan it's pick ticket barcode, then scan the UPCs of the ordered products from the inventory in any order. If a product was scanned that was not in the pick ticket or too many items were scanned, an error beep should occur. If all items were successfully scanned, there should be a confirmation sound and the order should be marked as complete and archived in the system. The actual and reserved stock counts should be decreased accordingly. When done, the user will return to the computer and click a "Finish" button that will create a CSV file (sample will be given) and optionally run a specified program.

*I would expect that there is already software that does the above but unfortunately I was unable to find an application that did exactly what I wanted. If you are familiar with a program that meets all my requirements or can be made to meet them, I will be more than happy to pay a fee for the configuration. If you will be configuring existing software versus creating a custom piece, please factor that into your bid. If you create the software, I would be purchasing the rights to the code and the ability to resell it.

Thank you!

Evner: .NET

Se mere: what's an algorithm, what's algorithm, what levels, what is picking and packing, what is express, what is algorithm in computer, what is a data entry form in a database, what is a computer algorithm, what does algorithm, what does a data entry person do, what algorithm, wanted one piece generator, upc barcode scanner, text search algorithm, text matching algorithm, take away layout, table customer, system one, straightforward algorithm, stored program computer, sql inventory system, simply well, simple search algorithm, search algorithm in c, schema form

Om arbejdsgiveren:
( 0 bedømmelser ) RICHMOND HILL, Canada

Projekt ID: #106680

59 freelancere byder i gennemsnit $1214 på dette job


plz checl my PMB

$1500 USD in 30 dage
(71 bedømmelser)

hi plz see pm

$1400 USD in 30 dage
(62 bedømmelser)

Please see PMB for detail. Thanks.

$1500 USD in 35 dage
(2 bedømmelser)

pl check pmb.

$1250 USD in 30 dage
(20 bedømmelser)

We are really confident to do that.. Please check our PMB for portfolio

$1500 USD in 35 dage
(6 bedømmelser)

Please check PMB.

$1250 USD in 30 dage
(6 bedømmelser)

Dear Sir / Madam, We would like to do this project. Please see PMB for Details. Thanks and regards, Team - Kumaran HI

$1200 USD in 20 dage
(10 bedømmelser)

Dear Sir , We have all necessary skills in this area. We use most advanced technologies and offer qualified technical assistance. Quality and satisfaction are guaranteed. If there are any questions, we have 24x7 su Flere

$1450 USD in 33 dage
(1 bedømmelse)

Dear Sir, In last 4 months we have developed 14 Dynamic Php projects and 25-30 .NET Projects for Clients in US, UK, Italy, Netherlands, Denmark, [login to view URL] Includes sites like Real Estate, Dating, Content Managem Flere

$1495 USD in 28 dage
(5 bedømmelser)

Contact me in PMB.

$1000 USD in 25 dage
(2 bedømmelser)

Looking Forward To Work With You. Thanks & Regards, WebDezers Inc.

$1200 USD in 60 dage
(2 bedømmelser)

We have something similar ready and working for several clients but written in VB6.0. If VB6.0 is acceptable to you, we can give you a tried and tested software. Let me know through PMB. Regards

$1350 USD in 10 dage
(1 bedømmelse)

Please check PMB.

$1500 USD på 1 dag
(2 bedømmelser)

Dear Sir/Madam Thank you for allowing us to bid your project. We are a Professional Web Development Company having experience in Web Design and Development. We also do software development an Flere

$1300 USD in 32 dage
(1 bedømmelse)

Please check your PMB! Regards, ZedEx Inc.

$1500 USD in 59 dage
(1 bedømmelse)

I am working as Software Developer in a USA based company used to develop software for USA Counties. At present working for Mecklenburg county. I am well expertise in ASP.Net and C#.Net. My skills also contributes to V Flere

$1200 USD in 30 dage
(0 bedømmelser)

Hi Iam sarbjeet singh running a website and s/w development company at chandigarh.i am interested in your [login to view URL] u are interested in our bid then plzz CONTACT US AND THEN WE WILL PROVIDE U OUR COMPLETE DETAILS THA Flere

$1200 USD in 30 dage
(0 bedømmelser)

Hi, We are a small team having rich experience on windows and web application in .Net since last 2 years. We have developed certain projects whose complexity ranges to architectural and database design. We as Flere

$1400 USD in 30 dage
(0 bedømmelser)

Hello, We are very much interested to work for you. Please send the specifications in brief, so that we can send you the time estimation of the workflow. I don't wish f Flere

$1500 USD in 20 dage
(0 bedømmelser)

check your pmb.

$1000 USD in 15 dage
(0 bedømmelser)