iFreelance

Order Processing database
Estimated Budget:
Not sure / Determined by bids
Category:
Programming / Database Development
Subcategory:
Database Programming
Description:
We are a large company that fulfills orders to the nuclear industry throughout the world.  We are part of a much larger construction company that has a large and detailed accounting software system.  However, although we use that system for accounting purposes, our division is different enough from the parent company that we need something more, and small enough that it’s not worth developing a complete module into the larger system.  The nuclear industry, and our procedures, have some very specific QA documentation requirements that are not easily found in any standard system.  For our purposes, we are looking for an order processing database with various tables including but not limited to:
• Material cost and pricing (default but may be different for some customers)
• Customers with multiple ship to locations and contacts
• Orders w/multiple items
• Vendors w/multiple locations, contacts and products
• Standard conditions and comments (to be added to purchase orders or documents by checkbox but also default by vendor, customer or material type)
• Quote register
• Sales register
• PO register
• Estimator table
Database will be 90% designed, just looking for someone to add efficiencies and write the program.  Prefer Microsoft Access because we are familiar and we want to easily add reports, etc. ourselves as needed.  Our basic order process is:
• Customer asks for quote for various materials and quantities
• We generate quote including various conditions (the quote process is often omitted but we want to track data when it is used)
• Receive order from customer
• Generate “Traveler” document to follow order through completion that contains all pertinent info including items ordered, cost & pricing, customer info, shipping info, drop ship vs. in-house fabrication, etc.
• If drop ship items, we generate a vendor PO to purchase items. If in-house fabrication, we may or may not need to generate PO to purchase raw materials.  We often generate POs for multiple orders or just for inventory.  At this point we are not looking to track inventory in this application.  We have stringent QA requirements so all POs may require various purchasing conditions depending on the vendor, customer, material, etc.  Need a list of standard conditions that could be “checked” to include on PO, with some checked by default (possibly by vendor)
• Need to track all in-house orders against a required ship date (total outstanding, due within 5 days, due within 2 days, past due, actual shipped vs required)
• There are various shipping documents that are required that should be generated by the program (5-6 documents)
Up until now we have been using a series of unlinked Excel spreadsheets and Word templates.  That system is not efficient, we have to input data multiple times and we don’t have the analytics that we need. I have designed systems and worked with programmers in the past as well as developed my own databases in Access.  I just don’t have the time to do this one and am looking for something easy to use with a summary dashboard with analytics that a user can easily click on a tab or ribbon bar icon to either generate new records or see existing records at the various stages of the process.
Announcements:
Work Onsite:
No
Bidder Location:
**No Preference**

Bidding Details

Ends:
12/10/17 9:13 PM PDT
Remaining:
0 minutes
Began:
11/20/17 5:58 AM PDT
Bids:
Sealed:
Yes
Awards:
None Issued
Bid #
Status

Project Employer

mduncan1

Location:
Texas, United States
Rating:
   
0
Projects Posted:
1

Public Project Discussion

This project has not been discussed.
Discussion Not Permitted
To participate in this discussion, you must be logged in.
The freelancer has not yet submitted a review of the employer.
Reviews can only be submitted after project work has been completed.
The employer has not yet submitted a review of the freelancer.
Reviews can only be submitted after project work has been completed.
View Timing & Location
These charts allow you to visualize how often and from within what countries this project has been viewed during this project's bidding phase.
Bid Timing & Location
These charts allow you to visualize the timing and country of origin of all bids submitted for this project.
Project Match
These charts allow you to visualize how well the bids submitted for this project match the preferences defined by the employer.

iFreelance is a great way to hire Freelancers, find work and get your goals accomplished.

iFreelance is the premier place for independent professionals looking for freelance work. Whether you have experience in proofreading, art jobs or data entry, iFreelance is the hub where you can meet entrepreneurs and sell your freelancing skills.