In Progress

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 ) Parma, Italy

Project ID: #17459326

Awarded to:

aggarwalgautam

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
(1 Review)
0.8

23 freelancers are bidding on average €192 for this job

€155 EUR in 3 days
(58 Reviews)
7.6
widadsaghir1993

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
(59 Reviews)
6.5
webXpart

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
(58 Reviews)
6.8
suju8811

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
(47 Reviews)
7.0
CodingExpertz

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)
6.6
wontonesaju

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
(187 Reviews)
6.7
shiningdevelopor

⭐⭐⭐⭐⭐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
(36 Reviews)
5.7
akwebtechnology

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)
4.6
nigamkumar09

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
(30 Reviews)
4.0
Lultu

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

€188 EUR in 15 days
(14 Reviews)
3.9
webinvoidia

Our company develops mobile applications for clients all over the world. And we would like to offer our services to you. Our team houses 15 professional mobile developers that concentrate on delivering high quality More

€55 EUR in 3 days
(14 Reviews)
3.8
midas0925

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
(10 Reviews)
3.4
gliesefire

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
(2 Reviews)
3.0
Aalsaqqa

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
(5 Reviews)
2.6
digitalads786

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
(6 Reviews)
2.3
suncitytechno

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)
1.9
pranjalinir

I have experience of website and windows applications development. From last 6 years I have been working in this field. I have also completed couple of project on my own from start to end. Always been able to deliver p More

€155 EUR in 5 days
(0 Reviews)
0.0
dhruvivora11

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
(0 Reviews)
0.0
kingsleyasifor

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)
0.0
€30 EUR in 1 day
(0 Reviews)
0.0