Purchase Order system

I have made a helpdesk for maintenance jobs, and breakdown job for mechanical and electrical work, It generates its own invoices, I can setup a demo for you, then you could adapt it to just produce purchase orders.

I have made a helpdesk for maintenance jobs, and breakdown job for mechanical and electrical work, It generates its own invoices, I can setup a demo for you, then you could adapt it to just produce purchase orders.

That would be much appreciated!

I'm also interested. Is that possible?
Gr Jafieb

Has anyone built a purchase order system in PHPR? Looking for tips on having the PO table (po number, date, ship to, terms, etc.) and PO Details table (line number, item description, item cost, etc.) integrated in a nice form - preferable on same screen (page).

Hello,

yes it's possible. I developed Repair Depot application with all processes and PO including Open Jobs, New Jobs, Closed Jobs and Dashboarding for data analysis. If interested please respond ( anjeko2 at yahoo dot com )
JK

No Probs, will try to get an online view this week for you to see.

I'm interested also.
Regards,

JP

Hi
Just seen your personal message but thought I would respond on the forum for ease...
The most important thing I have found from my experience is how to make sure 2 users are not editing the same records at the same time. All previous PO databases (not online) I have worked with get round this with database locking but with mysql this needs to be given careful consideration.
I have overcome this by having a 'locking' functionality in the coding that checks out the order if ammendments etc made. This does reply on the user checking it back in however to allow others to edit if required.
I am not sure this is the best approach but I did not know of another way.
Other than that having a supplier, po_header and po_details is quite simply to set up.
Are you looking to have booking-in and invoicing matching functinality? DO you need to import invoice (once match) into an accounting system? If this is the case you can easlily tailor your tables to suit. I sync my mysql with Sage50 for example.
Hope this gives you some thoughts - let me know if you need some help.
Gareth

Sorry for the delay, but I have been busy trying to get a PDA system to use with php pages.
I will get a link on Friday posted which will give access to a demo site for the Helpdesk system we use.

It generates its own unique purchase number which we use for Invoice to customers, The only extra thing it does is we also add labour content and material content.
I will have to copy the project I have in work and empty the MYSQL database from all our own records first.
Anybody who is intrested, can you please PM me and I will send you the URL for you to see how my system works. It was made with version 5.0, so I can send you the phpr file and an empty database to play around with if it help anybody.

Just incase I didnt PM anybody back Here is a copy of the pms
Here is the URL for the site. Its based on a breakdown and maintenance company. Everything is done by the edit button and the add new button.

If a customer rings up for a new breakdown fault, It is added to the system by using the Add New. Then when the details have been added you go back to the main list page. If you now press the edit button, you can see at the top there are links for Materials, Labour and Invoice.
Pressing these will open up a new page, You can add labour engineers, hourly rate, amount of ours, and on the material, you can add items that have been bought for the customer, you can put on an additional cost in a percentage format, say 20% and it will calculate the cost for you.

Once saved, you can click on Invoice, and it will open up the invoice for that particular item.
Any problems pm me back.
This is only part of the system, but its enough to see what it can do

Paul.
http://demo.asprunner.net/pggrimes_hotmail...st.php?a=return

By the way. I only setup a Login screen to stop it from getting spammed. You will need to use your correct email address to reg on the site.

Hi
I have tried to log in but my email address will not be accepted as it is too long. Any ideas - it is not a particularly long email address.
Thanks
Gareth

Hi

My worked fined, very nice swanside. How long did it take for you to accomplish this?

Very neat Swanside, no problems logging in. Thanks too for quick PM reply.
Given me plenty to think about and I can now see two things I'll have to achieve.

1. Clarity in layout and what you need to see at given stage.
   
2. Getting the relationship between the tables I'll need to create, right.
   Been reading the tutorials so plenty to at!
   Thanks, Peter.

The MYSQL Tables are really short, thats why if you have a large email address, it wont accept it. This is just because it is on a demo account.

Took about a year to make it and tailor it to our needs.
Alot of help from Jane and Sergey aswell.

Hey Swanside
I registered a new shorter email so have now managed to get in.
Thanks - all looks very neat.
Gareth

Hey Swanside

Cheers, It performs well for what we do. I am in the middle of integrating it with a PDA software app that will send information back into the tables once a job has been completed.