SIMPLE JOB IF U KNOW HOW :)
I have this order management system that needs a few more pages added
See it here [login to view URL]
firstly i need it to be made password protected with 2 levels
Level 1 – all area access
Level 2 – No access to staff details and stats reports
NEW PAGE NOTES PAGE
A list in date order of all notes – these fields
Date – company – notes –
Click notes to view notes,
Can close notes from appearing on this list once dealt with
SETTING COMMISION LEVEL
Set Commission Per Unit When Entering staff details (only salespeople)
ENTERING UNIT VALUE
When entering order in (fronts veries) there is another field (unit value) a drop down list
Each line of product will be either ½, 1, 1 ½, 2, 2 ½, 3, 3 ½, 4, 5,6,7,8, 9 or 10 units
NEW PAGE – MONTHLY SALES See [login to view URL]
Sales listed by week, 4 weeks to a page
Data listed underneath by sales person
Make this page downloadable into excel
on any orders with a note on them
NEW PAGE –STATS
Statistics – with amount of monthly sales by salesperson
Amount of orders sent
ORDER EDIT
Make it possible to easily edit item just put into order (front verifications) ie amounts product
When an order is added make company details from last order disappear (address telephone number etc) ready for input of next order
OPEN ORDERS PAGE should look like [login to view URL]
I want to see these details of orders that haven't been sent yet,
I e each line or product on one line
Colour coded by order i.e each new order is in the other colour
I can also edit supplier for product from here
The “details” can be shown in small text at the top of the page if require
Please also add a flag on any orders with notes on them
NEW PAGE SUPPLIERS PAGE
Each supplier )entered while entering products) will have its own page,
When I click “send” on open orders page that line is added to that suppliers page
I can then go to that suppliers and email the page as the order to my supplier
I can then press ordered on the supplier page and it will go into archive of past orders
There will be a number in brackets next to supplier link if there is an order pending
NEW PAGE GIFT PAGE
Every time an order is added, the gift goes on to a page similar to open orders but just with
Order date - Company name – gift – supplier – details – send
And when you send it goes into that suppliers order page just like open orders
NEW PAGE INVOICE PAGE see [login to view URL]
When orders are “ordered” from suppliers page, all sent orders appear on this page,
This page then lists the invoices created in any one week
We can add sent item lines into an invoice
NEW PAGE PRINTED INVOICE PAGE
Please also add a flag on any orders with notes on them
When the print invoice button is pressed (in invoices) invoice amounts are added to a list of invoices starting from say invoice number 1500 the list will have these fields
INVOICE NUMBER COMPANY AMOUNT VAT AMOUNT+VAT DUE/PAID
NEW PAGE PAID INVOICE PAGE
When the paid button is pressed all paid invoices are added to a list ( a paid date and cheque number must be added)
The page will have these fields
PAID DATE - DATE OF INVOICE – COMPANY NAME - AMOUNT – CHEQUE NUMBER – TOTAL PAID THAT DAY
The paid amount can be edited to this leaving an entry on the printed invoice page with due a mount
Invoices disappear from printed invoice page when totally paid