Tracking items sold under a sale or return scenario.

  • Thread starter Thread starter Nicholas James Pitt
  • Start date Start date
N

Nicholas James Pitt

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
 
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 :-) ).

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
 
Back
Top