Integrate a small web application for purchase management

Integrate a small web application for purchase management

Application must be developed in plain Php on MySql DB

Table User (User Name, Password, Company, VATno, Adress) Existing Table to modify with company each user has 1 company

Table Bank (Bank code -3digit-, Bank Name, Bank Adress, IBAN, BIC)

Joint Table (Company, Bank Code) a company may have more banks

Table PurchasingDocument (PD_code, Date Of Invoice, TypeOfDocument,JobCode, Company, Tot, Vat, Net -currency amount)

Joint Table Reconciliation (PD_code,FT_code, status)

TypeOfDocument (Expense, PurchasingInvoice, Troll, Fake)

Table FinancialTransaction (FT_code, Date Of Bank Movement, Bank Code, FullDescription, Amount -currency amount)

1. At the end of each month we download statement from Banks in csv or xls (please find enclosed examples of format) and upload them to the application:

2. The application must

- generate unique FT_code as concatenation of yymmddssbbb (year, month,day, serial, bank code) primary key

- populate FinancialTrasaction table

- sytem must be able to check for duplicate records (a statement could not be enetered twice)

3. During the month we enter in the application Purchasing Documents trough a dedicated mask or upload an xls (please find enclosed examples of format)

4. The application must

- generate a unique PD_code as concatenation of yymmddssccty (year, month,day, serial, company, typeofdocument) primary key

- populate purchasing document table

5. At the end of the month after all docs (banks statement and purchasing documents) are uploaded the user can go trough the reconciliation process

st1 select bank

st2 for each FinancialTransaction line search into PurchasingDocument table to look its (but may be multiple) correspondent record

to simplify this search sys must:

look into Joint Table Reconciliation where satus=open -only open record (not yet mached or not paid in full)

- first look with record in Purchasing document with same amaount of money and within a +- 3 days range and propose it

- then propose all open record from previous period

NOTE: Each user has one company Each company may have more banks

NOTE: A Create, read, update and delete CURD framework use would be greatly appreciated for further developemnt of the opearting framework

Check the existing application on

[login to view URL]

user admin psw 123456

DOCS will be updated after first screening for privacy reasons

Skills: Javascript, MySQL, PHP, Software Architecture, SQL

See more: inventory management system project in php source code free download, purchase order software for small business, php inventory management system template, php inventory management system open source, free php inventory management system, simple inventory system using php/mysql, simple purchase order software, php inventory management system demo, web based file management application, small web application, web application courier management system, integrate sms web application, web application users management freeradius ldap, web design purchase loan application code, web school management application, integrate sms web application java, integrate aspnet web application dot nuke, small web application company, web application client management online, complete java web application hospital management syste

About the Employer:
( 25 reviews ) London, Italy

Project ID: #17459326

Awarded to:


I have been doing web development using PHP/ Symfony and JavaScript/ React for last 3 years and have developed some of the very complex projects from scratch. I am confident that I will be able to help you achieve you More

€166 EUR in 3 days
(5 Reviews)

22 freelancers are bidding on average €198 for this job

€155 EUR in 3 days
(70 Reviews)

Dear Client! I read your project carefully so I am intereted in your project. I know what you really want. its very clear to me. I am 1000% confident for the project. I am a senior web site designer and developer More

€300 EUR in 3 days
(63 Reviews)

Hello sir. Nice to meet you. As a senior web developer, i can help you well. I have rich experiences in web dev. Please contact me for you job. Thank you. Regard.

€400 EUR in 3 days
(103 Reviews)

⭐⭐⭐⭐⭐Hello, I can finish your project in short time⭐⭐⭐⭐⭐ Look my profile My speed is rocket speed. I have good team on field web development. if you see my profile, you will be amazing.. :) Because We have finish More

€155 EUR in 3 days
(82 Reviews)

Hi, I checked your existing application [login to view URL] and I have more than 5-6 years experience on PHP,MYSQL web application. I already done similar application previously for this company More

€244 EUR in 14 days
(69 Reviews)

Hi, I am an Independent Software professional providing a range of IT services and would love to work on your project. Question: I looked at the [login to view URL] and confused why do you ne More

€400 EUR in 15 days
(127 Reviews)

Hi Thanks for posting this job. i am having 8 plus years of experience in web design and development. Based on your specification, will it include the admin back end to control and handle the records enter by the More

€277 EUR in 3 days
(189 Reviews)

Dear Sir, I am an independent freelancer having experience of more than 8 years. I am highly experienced in php, html, css, javascript, jQuery, Ajax, Codeigniter, bootstrap etc. I can fulfill your requirement with gua More

€222 EUR in 10 days
(33 Reviews)

Hello, I have experience and skills to complete this jobs, I am the suitable person for this task, I have read your description. I can do this task. Please open your chat box for more discussion. Area of Interest: PH More

€155 EUR in 3 days
(35 Reviews)

Hello Sir, I am a full stack developer from Poland. I have gone through the details you have provided and would be pleased to work on this with you to deliver the results that you have expected and I am experien More

€133 EUR in 4 days
(2 Reviews)

all the functionalities can be integrated in the current application pls message me for further discussion

€188 EUR in 15 days
(14 Reviews)

I have read your description carefully and I think i can help you to build purchase management system. I have tons of experiences in web building with php and CRUD operation in sql. I expect to discuss with you ASAP. More

€155 EUR in 3 days
(13 Reviews)

Hello, From my understanding, you need mySQL database per your given schema with the following functionality essentially. 1. Generate Unique codes and store it. 2. Export / Import xls / xlsx / csv file 3. Some re More

€100 EUR in 3 days
(4 Reviews)

Hi i can do this script i a record time i have very good experience in pure PHP programming i have 6 years experience as a software developer at university of palestine

€120 EUR in 3 days
(9 Reviews)

I am a professional web developer with major expertise in PHP development, including all its major frameworks CakePHP, Laravel, Codeignitor and others. I have also vast proficiency in WordPress development including it More

€222 EUR in 3 days
(9 Reviews)

Greeting!! Hope you are doing well!!! Currently, We are doing work on latest technology with 4+ years experience. We do work in HTML5, CSS3, W3 CSS, Media CSS, Bootstrap3, Boostrap4, Laravel, Codeigniter, Ca More

€220 EUR in 10 days
(4 Reviews)

Hi.. I have worked in past with sql and php and have 6 years of industry experience. Hope to connect with you and discuss further details for the project.

€123 EUR in 15 days
(1 Review)

Hi, lets discuss more on your project, I've built tons of web app from scratch. You can check out some of my web app products here, below: -- [login to view URL] -- I am a very experienced PHP programme More

€111 EUR in 2 days
(0 Reviews)
€30 EUR in 1 day
(0 Reviews)

Hi, I am Arup from Smart Software. I have 9yrs of exp in Graphic Design, Website Design and Development, Mobile App Development and Custom Web Application with the good reputation and client satisfaction. I read yo More

€332 EUR in 12 days
(0 Reviews)