Advance Payment Software

Personnel Advance Payments Manager for a small company (< 100 employees)

Along the month, each employee is allowed to ask for an advance payment.

The purpose of this SMALL piece of software is to manage those payments, issue payment tickets and summarize all payments fom date to date.r

## Deliverables

This is a small piece of software with the following requisite:

Language: Visual Basic Express 2008

Database: SQL Server Express 2008

SQL Tables:


? pCode varChar(12)

? pName varChar(40)

? pSalary Decimal(12,2)


? pCode varChar(12)

? paymentDate Date

? paymentAmount Decimal(12,2)


1 - Personnel Table Updating

We must read data from an external MS Access Personnel file

SELECT pCode, pName from Personnel

And compare the result against the SQL Server local Personnel table, in order to ADD the newly created records (Those that doesn't already exist in the SQL Server table).

2 - Personnel Table? Maintenance:

Edit, Delete and enter the monthly salary per person.

3 - Create Advance Payment records:

From a dedicated VB Form, display a list (non editable datagrid) of all persons (Less than 100) in a grid:

pCode? ? ? pName? ?

1234? Doe John? ? ?

When the user clicks on a Person, display the pCode, the Name and the Max Payment Allowed for that person on the right side of the form.

A secondary datagrid will also display the list of already paid amounts for that person within the same month, and the total below.

Rule: Anyone cannot obtain an Advance Payment greater then 80% of the due salary, calculated from the 1st day of the month to the present date.

Payments and max are rounded to the Euro.

Accept (enter) the required Advance Payment Amount. Check that it is allowed, display an error message if not.

Let the user click on a Validate button (or Cancel button to dismiss that person and get ready to click on another person's name.

Of course, while displaying one person, do not allow the user to click on another person's name in the datagrid, unless the user clicks Accept? ( with Amount > 0) or cancel.

Once validated, create a new AdvPayments record.

Once the new AdvPayments record saved, prepare and print an Advance Payment Ticket (We will use a 40 columns small printer)

With a Header:? The Name and Address of the company

? ? The Day Date abd Time

And the payment detail:

? ? The pCode and Name

? ? The Payment Amount?

Dismiss the person's details once done and re-allow clicking on another Name.

4 - AdvPayments listing

Prepare a list of all AdvPayments records for any given period, using 2 calendars: From Date and Until Date.

Print that list by pages on screen

Allow paper printing as well

Skills: .NET, Engineering, Microsoft, MySQL, PHP, Software Architecture, Software Testing, SQL, Visual Basic, Windows Desktop

See more: tickets for less, purpose of payment, payment purpose, issue payment, grid in php with add edit delete, express personnel, employee express, advance data grid, sql server max, sql r, sql less than, sql in r, r sql, max sql server, visual basic edit, salary software, R software, fom, express software, datagrid, cancel payment, summarize software, monthly salary php, software paper, visual basic delete access

About the Employer:
( 50 reviews ) France

Project ID: #3085488

8 freelancers are bidding on average $239 for this job


See private message.

$212.5 USD in 10 days
(76 Reviews)

See private message.

$255 USD in 10 days
(37 Reviews)

See private message.

$297.5 USD in 10 days
(15 Reviews)

See private message.

$170 USD in 10 days
(1 Review)

See private message.

$297.5 USD in 10 days
(1 Review)

See private message.

$255 USD in 10 days
(0 Reviews)

See private message.

$212.5 USD in 10 days
(0 Reviews)

See private message.

$212.5 USD in 10 days
(0 Reviews)