If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Tracking items sold under a sale or return scenario.
Hi there.
A friend of mine runs a business that sells panoramic pictures. A number of galleries/shops stock these pictures on a sale or return basis. My friend requires a system that will track the items that a gallery should have in stock together with what they have sold. i.e. each month the gallery should provide a completed form detailing their current stock. This should then be compared with the data stored in the database to indicate the difference between what the gallery has in stock and what items the gallery has been supplied with. A bill can then be produced to charge the gallery for those items that have been sold based on that difference. Hopefully I have described that clearly. Can anyone suggest a suitable table setup that would allow for this scenario please? Regards. Nicholas James Pitt |
#2
|
|||
|
|||
Tracking items sold under a sale or return scenario.
Anybody? Please!!!!
Hi there. A friend of mine runs a business that sells panoramic pictures. A number of galleries/shops stock these pictures on a sale or return basis. My friend requires a system that will track the items that a gallery should have in stock together with what they have sold. i.e. each month the gallery should provide a completed form detailing their current stock. This should then be compared with the data stored in the database to indicate the difference between what the gallery has in stock and what items the gallery has been supplied with. A bill can then be produced to charge the gallery for those items that have been sold based on that difference. Hopefully I have described that clearly. Can anyone suggest a suitable table setup that would allow for this scenario please? Regards. Nicholas James Pitt --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.710 / Virus Database: 466 - Release Date: 23/06/2004 |
#3
|
|||
|
|||
Tracking items sold under a sale or return scenario.
"Nicholas James Pitt" wrote in
: Hopefully I have described that clearly. Well: for the first round in a consultancy it's not an awful start, but there is a heap more information needed. Incidentally, if this is your business, do you really want to run it on a database hacked together by people who don't know what you are talking about? It might just pay you to get some (paid) professional advice (and no I'm not offering :-) ). Can anyone suggest a suitable table setup that would allow for this scenario please? From the description, you are probably looking at tables like this: Pictures (PictureID, Title, Description, PaintedBy, HeadlineValue) Artists (Initials, FullName, Address, LinkToCV) Galleries (GalleryCode, FullName, Address, OwnerName, CreditLimit) Placings (PictureID, GalleryCode, SentOutDate, ReturnedOrSoldDate) Sales (PictureID, SoldTo, InvoiceNumber, AgreedPrice) Invoices (InvoiceNumber, GalleryCode, DateSent, FirstReminder) Payments (InvoiceNumber, DateRcvd, Amount) but bear in mind that I don't know what you are talking about either! B Wishes Tim F |
#4
|
|||
|
|||
Tracking items sold under a sale or return scenario.
Thanks, that gives me something to work from.
Regards. Nick --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.710 / Virus Database: 466 - Release Date: 23/06/2004 |
Thread Tools | |
Display Modes | |
|
|