Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
ERP project needed
01-10-2016, 02:12 AM
#
ERP project needed
I need a System developed, below are the specs also attached.

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.

DATA FILES

1. DEBTORS MASTER
Account Code
Name
Add1
Add2
Add3
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


Attached File(s)
.pdf  ARBITTestProgram.pdf (Size: 63.02 KB / Downloads: 5)
 


Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  BCA PROJECT bca2018 0 36 04-13-2018
Last Post: bca2018
  I WANT CODE FOR THIS PROJECT. abburishiva5@gmail.com 0 69 03-23-2018
Last Post: abburishiva5@gmail.com
  Exam Hall Arrangement project Yash Shah 0 53 03-21-2018
Last Post: Yash Shah
  final year project chakradhar 0 111 02-16-2018
Last Post: chakradhar
  java project ABHI2137 0 101 02-14-2018
Last Post: ABHI2137
  android project on news app Srishti Chauhan 1 723 02-11-2018
Last Post: Castillo
  B.tech IT final year project Jayashreeb 0 145 12-31-2017
Last Post: Jayashreeb
  Project in GPF management system Manavi 0 97 12-19-2017
Last Post: Manavi
  FREE PHP Project html5 css for digital printing business dblangagec 0 88 12-09-2017
Last Post: dblangagec
  project Zubair altaf 0 109 11-30-2017
Last Post: Zubair altaf

Forum Jump:


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

Return to TopReturn to Content