Thread Rating:
  • 1 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
ARB IT Project
01-08-2016, 03:53 PM
#
ARB IT Project
I need the following program developed. Attached and below are the requirements and supporting documents.

Developing a single program or couple of programs (this is your
choice) to Create & Maintain a Debtors Master File, Stock Master File and produce an invoice. Note that the data files, fields and input requirements for this program are pretty basic and only a small sub set of a fully blown system. The idea is just to get some insight into your understanding of the concepts.
DATA FILES
1. DEBTORS MASTER
Account Code
Name
Address 1
Address 2
Address 3
Balance
Sales Year To Date
Cost Year to Date

2. DEBTORS TRANSACTION FILE
Account Code
Date
Transaction Type
Document No
Gross Transaction Value
Vat Value

3. STOCK MASTER FILE
Stock Code
Stock Description
Cost
Selling Price
Total Purchases Excl Vat
Total Sales Excl Vat
Qty Purchased
Qty Sold
Stock On Hand

4. STOCK TRANSACTION FILE
Stock Code
Date
Transaction Type
Document No
Qty
Unit Cost
Unit Sell

5. INVOICE HEADER
Invoice No (Auto Increment on create)
Account Code
Date
Total Sell Amount Excl VAT
Vat
Total Cost

6. INVOICE DETAIL
Invoice No
Item No
Stock Code
Unit Cost
Unit Sell
Disc
Total

INPUT PROGRAMS

1. MAINTAIN DEBTORS MASTER FILE
Input program to Create & Amend Debtors Master File Details

2. MAINTAIN STOCK MASTER FILE
Input program to Create & Amend Stock Master File Details

3. DEBTORS ENQUIRY
Enquiry screen to allow viewing of Debtors details including static details and
balances. From this screen it should also be possible to view a list of transactions for the Debtor.

4. STOCK ENQUIRY
Enquiry screen to allow viewing of Stock Items details including static details and
balances. From this screen it should also be possible to view a list of transactions for the Stock Code.

5. STOCK ADJUSTMENTS
For this exercise a simple input screen will suffice to record transaction for receiving qty’s into stock.

6. INVOICING
Input screen to allow the creation of an invoice.

GENERAL FUNCTIONALITY

1. All input screens must allow the user to Lookup a list of master file records for
selection. For example in the Debtors Enquiry screen the user must be able to type
part of the code or name and list must take user to the closest code.

2. Data Aware Controls and/or objects should not be used. All data manipulation should be achieved with code.

3. As for the rest, the developer has creative license to implement any functionality and features he feels are required
 


Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  internship project platform for college student jainmonula 0 28 12-07-2017
Last Post: jainmonula
  cinema booking System project using GUI nd inputs in java aliya32 0 39 12-03-2017
Last Post: aliya32
  JAVA PROJECT imykhanna 0 75 11-01-2017
Last Post: imykhanna
  Please help me I need a classifieds project ishaq 0 54 10-26-2017
Last Post: ishaq
  i need project for online production system in my project shashikalakotha 1 377 09-18-2017
Last Post: Jayaprakash
  HOW i use downloaded project moonje2017 1 313 09-12-2017
Last Post: Jayaprakash
  asp.net project websites data analysis vicky bhai 0 174 08-19-2017
Last Post: vicky bhai
  need a project for my last sem . iamanupriyas 2 822 07-22-2017
Last Post: Ankita mittal
  Url tracking project in java Akanksha 0 261 03-17-2017
Last Post: Akanksha
  android project Pamit Singh 0 390 02-03-2017
Last Post: Pamit Singh

Forum Jump:


User(s) browsing this thread:
1 Guest(s)

Return to TopReturn to Content