Closed

Warehouse management in html with macro

I need a full WMS or warehouse management system written by HTML and database can be text file.

the WMS should be able o import and export any activity (adding Item or remove item, or update all database ) trough inbox and outbox share folder.

main database should have column below:

S Article number

L Lift number

F Compartment number

T Shelf number

B Inventory at storage location

I FIFO identifier

G Container size x

R Minimum inventory x

O Compartment depth number x

H01 Borrower

H02 Tool class

H09 Lending status

H10 Lending date

H11 Lending time

H12 Available inventory

H13 Reserved quantity

H14 Reserver

User should be able to record Item information even if it is not in stock as zero quantity.

user should able to add 30 more column as custom field into database H15 to H45

user should be able to delete or edit the records.

user should be able to add one picture for each item in the WMS.

user should able to create a picking list with priority number to pick for each picking list. priority start from 0 to 200 , 100 is normal priority less than 100 is lower and over 100 is higher priority to pick.

there is a primary key item number and secondary key batch number. they can be mixture of numbers and letters.

when the minimum stock is higher than actual quantity user should be able to create a report.

Job database can be text file and should have column below with additional 25 costume field for user to choose title later:

K Job

p Priority x

w Status x

d Datum x

u Time x

Cxx Special data field C01 - C25

S Article number

V Operation

Q Nominal quantity

G Container size x

M Actual quantity x

W Status x

e Property x

Uxx Special data field U01 - U25

user should be able to edit or delete the jobs.

when the job created it should send a copy to outbox folder as a CSV text file with comma separator.

Opration can be "-" for picking and "+" to add to the WMS.

when the job finish a text file will appear inbox folder as [login to view URL]

it has contain the job number had been progressed so WMS will reduce the quantity of items or add additional of the item to main database.

also another file will appear in inbox called [login to view URL]

opjournal file contains also some picking or putting which may be it is not in the job list and WMS should change the quantity of item in main database.

Opjournal file contains below column:

S Article number

V Operation

Q Quantity (actual stored/retrieved quantity)

Inventory difference quantity (for IF in OJ) optional

G Container size

W Status

U01 Job/requisition

U02 Datum

U03 Time

U04 Cost centre

U05 User field

U06 Operator

U07 Storage location (LLTTTFFFOO)

Lift number (LL)

Shelf number (TTT)

Compartment number (FFF)

Compartment depth number (OO)

Uxx Special data field U08 - U25

Skills: HTML5, HTML, Website Design

See more: restaurant inventory management excel, how to make inventory in excel, warehouse inventory management excel, qr code inventory management excel, simple stock management software free download, stock in & out format, pharmacy stock management excel, stock maintenance, warehouse management web, warehouse management ajax, sugarcrm warehouse management, magento warehouse management sugarcrm, data management excel macro, warehouse management system companies india, escorts website content management html, warehouse management software using microsoft net, php script warehouse management, arrow electronics warehouse management system, php warehouse management, source code warehouse management

About the Employer:
( 0 reviews ) Mernda, Australia

Project ID: #25851239

9 freelancers are bidding on average $530 for this job

caroldata

UNLIMITED REVISIONS UNTIL YOU ARE 100% SATISFIED I can do the project as you require. I can provide you with the bespoke design and development. Let me know if we can connect to discuss more. I believe that I would More

$500 AUD in 7 days
(50 Reviews)
6.9
TechnotechIND

please check these url..... [login to view URL] [login to view URL] [login to view URL] [login to view URL] I HAVE UNDERSTAND YOUR PROJECT BUT More

$300 AUD in 6 days
(19 Reviews)
5.4
webdroid

Hi, Hope you are doing well, We are a team expert website developer and designer. We have 6 years experience on PHP, MYSQL HTML, CSS and Graphic Designing. We assure you this website will be responsive to all devices. More

$490 AUD in 7 days
(25 Reviews)
5.2
Raptorak

I checked your project details carefully, Dear hiring manager. As a senior HTML with macro expert, I am very interested in your task. I am good at B2B & B2C website development which I have been already tried. I hav More

$500 AUD in 7 days
(6 Reviews)
4.0
filipmihailde

Hi, how are you? Thanks for reading me. I have checked your description carefully. As I am a senior web developer so I am very interested and confident on your project. I have rich experienced in almost web languages ​ More

$500 AUD in 3 days
(4 Reviews)
3.2
nemanjadj20

Hi, there? Are you okay with covid-19? I have been working for 5yrs+ in this field. I can provide great result that you are asking for. Please send me a message if you are interesting me. Thanks.

$250 AUD in 5 days
(2 Reviews)
3.2
parekhvivek

I have read your job description. As I am well rounded with all aspects of web development & API development/ integration. so I can start your work immediately You can check my employment history and ratings My Skil More

$750 AUD in 30 days
(3 Reviews)
2.2
GeorgiyAbramenko

Hi Nice to meet you. As an experienced developer, the posting for your job piqued my interest. When reviewing the job requirements, I was excited to see that my qualifications and personal traits align with your needs More

$700 AUD in 7 days
(2 Reviews)
1.3
Triptitva

Expect world class delivery !

$778 AUD in 20 days
(0 Reviews)
0.0