Access DB Mod/Improve

Completed Posted May 2, 2006 Paid on delivery
Completed Paid on delivery

I have a Microsot Access DB that controls the operations of a small container terminal facility. I need a new module to handle invoicing of operations. This module will get data from the operations tables and output customized reports for clients based on some parameters and specifications for each one. I'd need some way to input the parameters for the clients and manage those parameters. Also, I'll need historical reports and the actual invoice to be printed from the DB. Also, I will need two or three other modules, so it's ok to work on a per-hour basis. The DB is shared by 10 users on a LAN.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

4) Derivables would be in microsoft access format, ready to be inserted in the working DB.

* * *This broadcast message was sent to all bidders on Tuesday May 2, 2006 3:00:34 PM:

This is the same project as last month's. I think I told you about working in this invoicing/billing project by the hour.

Regards.

Mario Payán

* * *This broadcast message was sent to all bidders on Wednesday May 3, 2006 12:14:09 PM:

Thanks for bidding in.

This is a brief desccription of the project:

The DB is a system to control the operations of a shipping container terminal. It registers the needs from customers and all the info for the Event once is carried on.

For example, one user receives a request from a customer to load one container onto a certain truck. The user makes the "reservation" (which creates a record on a table). Then, when the actual load is carried on, someone from yard operations "Validates" the "Event" by checking a field in another form and adding day, time and some other info.

I have many customers with different types of requests and different prices and billing policies apply to those customers. Some customers need the invoice right away, some need it on a weekly basis and others on a monthly basis. Some customers get a basic price, some others get a discounted price, etc.

I have a matrix/table with all the different parameters for all my customers. I will need the billing/invoicing app to access that table to get the parameters every time.

There are two possible scenarios for billing:

a) When a customer needs the bill right away. I need to go to a form, select the Event(s) to bill and generate a report with a list of the Event(s) and finally print the report and the invoice (here I will make the final adjustments to fine tune the printing process on the numbered paper forms). Maybe, if there is only one Event to bill, I can just click a button in my existing "Events form" and go to the billing process for that Event. This last thing I'll implement.

b) When we make the weekly or monthly billing. I need to go to a form, select the customer (maybe also a date range), get a form with a list of the Events to bill, select the Events to bill (maybe I don't want to bill something yet) and then get a re port (Support) with the final list. Finally, print the report (Support) and the Invoice.

Other forms would be:

a) A form to view and edit the "customer parameters".

b) A form to know what has been billed and what hasn't, with dates, customer, amounts (and possibly other parameters) to choose from. And to print a report of it.

c) A way to keep track of all the invoices with a numbered folio (control number). Maybe we can enter this number manually on every invoice because we already have the numbered paper forms. But anyway, I'd like a control number for the DB use.

It's important to know the BillingStatus of an Event (or group of Events). For example, I'd like to know if the Event is already Supported (which means that a list of events/supporting report has been printed) or if the Event is already PaidFor. The following would be the BillingStatuses available: 1) Not supported; 2) Supported; 3) Invoice Printed; 4) PaidFor.

## Platform

Microsoft Access 2000

Engineering Microsoft Access MySQL PHP Software Architecture Software Testing

Project ID: #3474595

About the project

16 proposals Remote project Active May 11, 2006

Awarded to:

schandraram

See private message.

$93.5 USD in 23 days
(155 Reviews)
6.9

16 freelancers are bidding on average $104 for this job

Premshanks

See private message.

$100.3 USD in 23 days
(349 Reviews)
6.5
unimaxsystems

See private message.

$97.75 USD in 23 days
(179 Reviews)
6.0
mailparikshit

See private message.

$90.1 USD in 23 days
(29 Reviews)
4.9
zaj575

See private message.

$85 USD in 23 days
(61 Reviews)
4.7
dpune

See private message.

$102 USD in 23 days
(37 Reviews)
4.6
logixsolutionssl

See private message.

$127.5 USD in 23 days
(10 Reviews)
4.3
stevef199

See private message.

$127.5 USD in 23 days
(19 Reviews)
3.8
oruckenaneu

See private message.

$114.75 USD in 23 days
(4 Reviews)
2.5
rinkuvadera

See private message.

$85.85 USD in 23 days
(5 Reviews)
2.2
jcbrooksbs

See private message.

$127.5 USD in 23 days
(2 Reviews)
1.3
harfang

See private message.

$127.5 USD in 23 days
(1 Review)
0.5
pcgarg

See private message.

$127.5 USD in 23 days
(0 Reviews)
0.0
spyryl

See private message.

$85 USD in 23 days
(0 Reviews)
1.3
mitzu

See private message.

$93.5 USD in 23 days
(0 Reviews)
0.0
bfitzmaurice

See private message.

$106.25 USD in 23 days
(0 Reviews)
0.0
haseebuddinvw

See private message.

$85 USD in 23 days
(0 Reviews)
0.0
Xan8ter

See private message.

$119 USD in 23 days
(1 Review)
0.0