Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2007
    Posts
    2

    Smile Unanswered: Stock Control Sample

    Hello!

    I'm new user here, and i would appreciate if anybody can show me a good example of Stock Control in MS Access. I'm specially interested to see in practice FIFO/LIFO methods.

    Thanks in andvance.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Inventory control, by its very nature, is a commercial venture, and as such the number of cost free templates available are very small. The complexity of this type of system means that many, many, many man hours have been invested in their development, and few developers are willing to part with their work gratis. You don't ay what version of Access you're using, but I believe some of the later verions (2002 onward, I think) actually ship with some templates. I'm sure I've seen that Access 2003 does.

    The link below has a couple of templates, from the horse's mouth (or was it the other end???) for this type of thing.

    http://office.microsoft.com/en-us/te...ates&av=TPL000

    Good Luck!

    Linq
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Aug 2007
    Posts
    2

    Question Hi Linq

    Allready I've got some solution for stock control ( purchasing and sales), but when it comes to calculate the price then i got the problem, because my chief wants everything to be sold with purchasing price + profit. So I'm not interested on full solution but only sugestions how to calculate the sale price for each product by method (FIFO or LIFO):

    Example for goods in stock:
    PrID PurchaseDate Quantity Price
    001 01/01/2007 50 1
    001 01/02/2007 150 2

    If we are going to sale the 100 pieces of product 001 on date 02/02/2007 than price should be calculated in this way:

    PrID SaleDate Quantity Price Profit Value
    001 02/02/2007 50 1 10 60
    001 02/02/2007 50 2 10 110
    --------------------------------------------------------
    001 02/02/2007 100 1.5 20 170


    Hope anyone can help me!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •