[login to view URL] Customer
ALL THE FIELDS IN THE CUSTOMER TABLE WITH LOOKUP
IN ROWWISE [login to view URL] CUSTOMER IN SINGLE
EACH SHOULD CONTAIN TWO LINKS:
[login to view URL] MESS REPORT
[login to view URL] ACCOUNTS
ONCLICK THE PAGE SHOULD OPEN IN NEW PAGE WITH FOLLOWING
SHOULD BE WITH PAGINATION 15 RECORDS PER PAGE
[login to view URL] MESS REPORT
CUSTOMER TABLE : CUSTOMERS
CUSTOMERID,FIRSTNAME ,LASTNAME,MOBILE,COMPANYNAME
NESSLOG TABLE :
ALL THE FIELDS AND RECORD IN THE MESSLOG TABLE SHOULD BE WITH LOOKUP TABLE
[login to view URL] ACCOUNTS TABLE MessAccounts
CUSTOMER TABLE :
CUSTOMERID,FIRSTNAME,LASTNAME,MOBILE,COMPANYNAME
MESSACCOUNTS :
ALL THE FIELDS WITH LOOKUP
OUTSTANDING AMOUNT SHOULD BE IN THE TOP
[login to view URL] PURCHASE REPORT
USER WILL SELECT MORE THAN 3 LABEL
THE REPORT SHOULD BE TWO DATES
TABLE TO USE : CREDITPURCHASE
THERE SHOULD BE A FORM FOR
[login to view URL] DATE
[login to view URL] DATE
[login to view URL] OF LABELS FROM LABELS TABLE
A)MORE THAN ONE LABEL SHOULD BE SELECTED AND UPTO 4 LABELS ALLOWED.
B)ON SELECT AND SUBMIT BUTTON REPORT SHOULD OPEN IN SEPARATE PAGE AS BELOW
DATE OPENINGBALANCE CLOSINGBALANCE SALES
1/1/2010 1000 200 50
1/2/2010 2533 563 25
2/2/2010 56 656 65
AT BOTTOM THERE SHOULD BE SUBTOTAL FOR EARCH COLOUMN
REFER LABEL TABLE
[login to view URL] TABLE
DATA ENTRY PAGE FOR MESSACCOUNTS TABLE
[login to view URL] SHOULD BE SELECT FIRST FROM A DROPDOWN BOX WITH CUSTOMER LIST (FIRSTNAME AND LAST) AND SUBMIT
[login to view URL] SELECTING THE CUSTOMER'S CURRENT BALANCE SHOULD BE SHOWN IN A LABEL
(CAN BE CALCULATED FROM MESSACCOUNTS TABLE)
[login to view URL] SAME PAGE A FORM WITH ALL THE FIELD MESSACOUNTS TABLE SHOULD BE DISPLAYED
MESSMONTH SHOULD HAVE JAVASCRIPT CALENDAR
DEBITORCREDIT FIELD SHOULD BE OPTION BUTTON WITH DEBIT CHECKED BY DEFAULT
REPORTRUNON FIELD SHOULD DATE SAVED.
LABEL SHOULD BE TEXT FIELD - ITS A COMMENTS
AMOUNT
CUSTOMERID
USERID WHO SAVED THE [login to view URL] CAN PUT 1
JAVASCRIPT VALIDATION SHOULD BE THERE AMOUNT SHOULD BE VALID
SHOULD USE THE TEMPLATES FOR THE HEADER AND [login to view URL] BE PROVIEDED AFTER WINNING THE PROJECT
REFER THE [login to view URL] FILE ATTACHED