Zydeceltico
Registered User.
- Local time
- Yesterday, 20:55
- Joined
- Dec 5, 2017
- Messages
- 843
Hi all -
Without going into a long drawn out story - the powers that be at work love what I am doing with my QC db.....so much so that I've been tasked to develop another one that initially was to record inspections of hardware: incoming, purchased on a PO and later shipped out with a job.
This opens a broad horizon in front of me. Our purchasing department struggles mightily with our ERP primarily because the ERP was outsourced and we have no control over form or query design - and are not nearly big enough to swallow the cost of DB ongoing development - especially when our industry is a niche market at best.
I took a look at the Northwind sample db and - from the outside - it looks like it would fit the bill easily (although I would nix the PO submittal and approval part of it.
So I started trying to figure out the workflow of it - and was instantly stymied. I can't figure out how to approve a PO. I can't create a new PO. etc. etc.
What I was hoping to explore - and is my only question - is how does Northwind handle receiving partial purchase orders - meaning a purchase order is submitted for purchase of one item, quantity = 10K but only 2000 can be shipped at a time.
I wanted to see what that might look like on the back end of things - particularly table design and any calculated fields.
But Northwind doesn't seem to actually work.
So - -- - does anyone know of a sample database that is similar to Northwind that actually works?
I'm kinda bummed because if Northwind actually worked I can immediately see how I could change table and field names and truly be 70% of the way down the road.
Thanks,
Tim
Without going into a long drawn out story - the powers that be at work love what I am doing with my QC db.....so much so that I've been tasked to develop another one that initially was to record inspections of hardware: incoming, purchased on a PO and later shipped out with a job.
This opens a broad horizon in front of me. Our purchasing department struggles mightily with our ERP primarily because the ERP was outsourced and we have no control over form or query design - and are not nearly big enough to swallow the cost of DB ongoing development - especially when our industry is a niche market at best.
I took a look at the Northwind sample db and - from the outside - it looks like it would fit the bill easily (although I would nix the PO submittal and approval part of it.
So I started trying to figure out the workflow of it - and was instantly stymied. I can't figure out how to approve a PO. I can't create a new PO. etc. etc.
What I was hoping to explore - and is my only question - is how does Northwind handle receiving partial purchase orders - meaning a purchase order is submitted for purchase of one item, quantity = 10K but only 2000 can be shipped at a time.
I wanted to see what that might look like on the back end of things - particularly table design and any calculated fields.
But Northwind doesn't seem to actually work.
So - -- - does anyone know of a sample database that is similar to Northwind that actually works?
I'm kinda bummed because if Northwind actually worked I can immediately see how I could change table and field names and truly be 70% of the way down the road.
Thanks,
Tim