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
  FREE PHP Project html5 css for digital printing business dblangagec 0 11 12-09-2017
Last Post: dblangagec
  project Zubair altaf 0 27 11-30-2017
Last Post: Zubair altaf
  Vehicle registration and traffic violation reporting online php Project David.o 0 56 11-08-2017
Last Post: David.o
  Financial project in VB.net trivendra 0 33 10-28-2017
Last Post: trivendra
  Staff Attendance & Leave Management System project raj gaikwad 0 97 09-19-2017
Last Post: raj gaikwad
  Student Feedback System Project in VB.net and MS Access dhammanand4u 0 96 08-12-2017
Last Post: dhammanand4u
  Computer science project Awasthi 0 140 07-18-2017
Last Post: Awasthi
Shocked Detection of Phishing WebPages Live Project in PHP kirtimaan01 0 125 07-03-2017
Last Post: kirtimaan01
  Fast nearest neighbour search project in dotnet or java mukund 0 180 04-09-2017
Last Post: mukund
  requesting for project source code Sujitha Sathya 1 396 03-16-2017
Last Post: IamAnum

Forum Jump:


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

Return to TopReturn to Content