Web-based inventory management system w/ accounting features

CLOSED
Bids
29
Avg Bid (USD)
$1796
Project Budget (USD)
$750 - $1500

Project Description:
Please see attachment for full descriptions and requirements of this project. This is a time-senstive project, please do NOT bid unless you can work closely with us. Thank you.

We are an international trading company with multiple office/warehouse locations. We are looking for an inventory control system with basic accounting features.

• User-friendly nice looking interface is necessary. Minimizing page refresh with dynamic page loading is a plus.
• Keep tracking unlimited number of items at unlimited warehouse locations.
• Generate item reports with all purchases and sales records in given period of time frame.
• Generate Inventory reports by date, location, and/or item.
• Generate Financial reports (Profit / Lose) by date, location, customer, and/or item.
• Inventory may be purchased, transferred, sold, returned, charged back from or to locations.
• Use FIFO for all inventory management. For example, at transfer / sale, always transfer out or sale the inventory acquire earliest at this location.
• Record item transfers from location to location. At each location, for each item, keep track item cost up till this location. At original location the item was purchased, the cost of this item is the purchase price. After transfers, the item cost is the purchase price plus all transfer costs occurred till current location.
• There are two transfer cost methods. One is by item weight. User inputs total transfer cost for the transfer, system will use items’ unit weight to calculate how much is the transfer cost for each item. For example, a transfer for 100 pieces A (unit weight = 2) and 200 pieces B (unit weight = 3). Total transfer cost is 400. For this transfer, transfer cost of A would be 2* 400 / (100*2 + 200*3) =1, and 1.5 for B. The other one is taking unit cost directly from user, and calculating total transfer cost for this transfer. For the same transfer in previous example, user inputs transfer cost for A=1 and B=2, system should calculate the total transfer cost is 500, regardless the item unit weight. User sets which method for each individual transfer.
• Sale may happen at any location. There is a shipping cost and shipping charge for each sale. Use by unit weight method to calculate both unit shipping cost (shipping we paid out, add to cost of good sold) and unit shipping charge (shipping customers paid us, add to unit sale price), for the profit/lose calculation.
• If any transaction makes a location with negative inventory qty, prompt an error message without process the transaction.
• Make sure when edit / remove any transaction all effects made by this transaction must be reversed. For example, if a Transfer is removed, all inventory location and cost will be adjusted. If a Transfer Cost is modified, cost of corresponding inventory must be adjusted as well. In addition, returns (refund with merchandise back in inventory) and charge backs (refund with no inventory) needs to be handled.
• Two user levels: Administrator can do everything. Staff sees inventory status in some selected locations but limited to make inventory change on a particular location(s). In addition, the homepage of this application should be an inventory status report for selected locations.
• All tables need to be printable with printer-friendly versions.
• Please code with PHP + MySQL, and make sure your code works on: Operating system: Linux, MySQL version: 5.0.91, and PHP version: 5.2.14.

Skills required:
AJAX, CSS, Javascript, MySQL, PHP
Additional Files: ERP.pdf
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 1500
in 30 days
$ 2000
in 45 days
$ 2500
in 30 days
Hire rockerstech
$ 2100
in 40 days
$ 1500
in 30 days
$ 2200
in 27 days
$ 2000
in 30 days
$ 1050
in 20 days
Hire smartgest
$ 1500
in 30 days
Hire silv3rm00n
$ 2000
in 40 days