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

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

"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

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