Web-based inventory management system w/ accounting features

Closed

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: [url removed, login to view], and PHP version: 5.2.14.

Skills: AJAX, CSS, Javascript, MySQL, PHP

See more: features web based inventory management system, your other warehouse, web application inventory, transfer methods, time tracking project management, out of office message, office web accounting, need web administrator, need of cost accounting, need for international accounting, mysql inventory management, management accounting web, limited company accounting requirements, levels system, how to work out cost price in accounting, how to keep track of customers, how much for a web administrator, how much cost a web page, financial plus, cost accounting 2, after effects works, accounting see, a.b.c. warehouse, financial web based inventory system, web based accounting system features

Project ID: #943223

28 freelancers are bidding on average $1782 for this job

krishdts

Please check PMB for details.

$1500 USD in 30 days
(66 Reviews)
8.0
Indexpage

Hi, We aim to provide you the best quality work. See more detail in PMB-Thanks

$2000 USD in 45 days
(54 Reviews)
8.0
varun8211

Hi there, Please see PMB. Thanks

$2500 USD in 30 days
(18 Reviews)
7.8
rockerstech

CHECK OUT MY REVIEW AND MY WORK IN PM

$2100 USD in 40 days
(82 Reviews)
7.7
WSTIBS

we can provide quality solution with time base completion. ******* Check PM ******** Thanks

$1500 USD in 30 days
(92 Reviews)
7.3
samsakthi

HI Check Pm

$2200 USD in 27 days
(20 Reviews)
6.7
gsala81

Hello, 10+ years exp freelancer here, can deliver a quality & professional work in the timeframe posted. Please contact me via PM for any question, Thanks

$2000 USD in 30 days
(50 Reviews)
6.4
agstech123

Hi, please check PMB to know more about our technical expertise and capabilities. Regards, Ricku Lohar

$1050 USD in 20 days
(14 Reviews)
6.1
smartgest

I can do that in the best professional mode. Please check PM.

$1500 USD in 30 days
(31 Reviews)
5.6
silv3rm00n

Hello, Check PMB.

$2000 USD in 40 days
(36 Reviews)
5.5
souvikghosh

Sir, I think I stand a chance here! Please view PM for details!

$1547 USD in 35 days
(23 Reviews)
5.6
rgasch

Please see PM.

$1750 USD in 20 days
(10 Reviews)
4.9
anjeko

Hello Please read my PM Regards Jerry

$1750 USD in 15 days
(3 Reviews)
4.5
hgtechsolutions

Hi please check pmb

$2000 USD in 30 days
(11 Reviews)
4.1
amsak

Pls see PM

$1200 USD in 60 days
(8 Reviews)
3.7
vermacreation

Hello, Please check PM.

$1351 USD in 30 days
(3 Reviews)
3.1
muskanrkm

DEAR SIR, WE ARE PROFESSIONAL WEBDEVELOPMENT TEAM.WE ARE DOING PROJECTS WITH GREAT CARE AND GREATEST EFFORT IN ABSOLUTELY RIGHT WAY.PLEASE,SIR,CONTACT US FOR MORE INFORAMTION THANKS AND REGARDS RK INFOT More

$1500 USD in 30 days
(1 Review)
2.9
icubelab

Dear Sir, Hello! We have gone through your requirements, all ready we have done such type of work. If you have any questions feel free to get in touch us for more clarifications. Please visit PMB for more infor More

$2000 USD in 28 days
(1 Review)
2.0
simplylp

Hi, Please check PMB. Cheers, Priya

$2000 USD in 20 days
(0 Reviews)
0.0
triowebsoft001

Please Check PMB.

$1400 USD in 30 days
(0 Reviews)
0.0