Advance Payment Software

Cerrado Publicado Jan 12, 2010 Pagado a la entrega
Cerrado Pagado a la entrega

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:

Personnel

? pCode varChar(12)

? pName varChar(40)

? pSalary Decimal(12,2)

AdvPayments

? pCode varChar(12)

? paymentDate Date

? paymentAmount Decimal(12,2)

Features:

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

.NET Ingeniería Microsoft MySQL PHP Arquitectura de software Verificación de software SQL Visual Basic Windows Desktop

Nº del proyecto: #3085488

Sobre el proyecto

8 propuestas Proyecto remoto Activo Jan 24, 2010

8 freelancers están ofertando un promedio de $239 por este trabajo

eplanet

See private message.

$212.5 USD en 10 días
(76 comentarios)
6.4
intelviper

See private message.

$255 USD en 10 días
(37 comentarios)
4.6
Manid

See private message.

$297.5 USD en 10 días
(15 comentarios)
4.9
farhanshahid

See private message.

$170 USD en 10 días
(1 comentario)
0.5
kirandeepvw

See private message.

$297.5 USD en 10 días
(1 comentario)
0.0
pijushsk

See private message.

$255 USD en 10 días
(0 comentarios)
0.0
Lullly

See private message.

$212.5 USD en 10 días
(0 comentarios)
0.0
abhinavkris

See private message.

$212.5 USD en 10 días
(0 comentarios)
0.0