Results 1 to 3 of 3
  1. #1
    bhamhawker is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2012
    Posts
    1

    Can anyone help point me in the right direction?

    I'm a relative n00b to Access (I'm on Access 2010 via Win7). I run inventory management (as well as ticket\sales management) for a furniture store with 2 employees and 1 owner. The owner is supposedly moving toward using PeachTree Accounting Software (can't remember its new name) in the future, but we've seen little progress in that regard.



    I have a fairly advanced spreadsheet setup in Excel to track plenty of statistics about our sales and traffic figures, but I feel like I could utilize Access to cover both that (though maybe not traffic, necessarily) AND my inventory.

    I've brute-forced my way into the Microsoft Inventory template, making it work...sort of. I've got a few issues specific to my situation that I need to figure out how to adapt, if anyone is willing to explain how or help me out in some regard.

    The main issue I have is that, as with most furniture stores, I deal quite a bit in "Layaway". What that means for my inventory management is that I have pieces of inventory that are "tagged" by me when a customer has a ticket written up. Where this becomes an issue is writing multiple tickets for multiple customers for the same particular set of furniture....say 7 tickets, 7 customers, but only 4 immediately available sets. The pickup dates of each customer are important, too, in that I can "shuffle" things around in order to constantly move furniture to customers that come in needing stuff instantly, while not compromising my ability to fulfill the layaway tickets.

    What I need from an Access database is everything the Microsoft template offers, but with some tweaks:

    1. I need to be able to have "negative" inventory. What this means is that I need to be able to put in "tickets" that "tag" furniture, even if that furniture is not in my particular inventory.That way, I have instant access to what pieces I need to bring in on my next truck. This is probably the biggest issues I need fixed.
    2. I need to be able to print off an "available inventory" report, showing what products are in my building at the time of printing.
    3. (Less important) I would like the ability to make a purchase order that comes from one company, but includes pieces from multiple companies. This isn't terribly necessary, but it would eliminate the need for multiple purchase orders for the same truck. (I basically have a "corporate" warehouse that I pull stuff from, but some of it overlaps things I can bring in straight from the actual manufacturer, if that makes sense).
    4. I need the ability to somehow track customer's potential pickup\delivery dates as they get closer. This is also less important, as it's something we're on top off with our physical tickets. But, it would be nice if this is something that doesn't take a ridiculous amount of coding\editing to do.



    So, is there anyone here that can offer me some help or point me somewhere that can?

    Much obliged!

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2002
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    I am working on a database myself with similar structure. I am not sure without seeing your db but you can enter a negative amount in your form and have it calculate out for you. Have you given any thought to transferring your excel spreadsheet into Access? As for the need of multiple companies for each PO, this is easily accomplished. You setup on your customers form a subform, let's call it companies and link the forms together and then use a lookup function on your PO form showing all companies for each customer.

    You wont find much help on this forum with db design, only with specific code requests.

    Hope I have been of some help. Let me know if I can help in any way. I have an old db that somewhat fits what you want and probably could be adapted to what you want.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I am not in the furniture business, but it seems that the 2 of you (posters) have a similar enough situation to carry on discussions re design and implementation.
    I would encourage and recommend that, since you have "common interests" (at least from a business/database view).

    When you talk layaway and don't have all the "laid away inventory" in stock, it seems very like a back order situation.
    There are existing data models at http://www.databaseanswers.org that may provide info to help you "flesh out" your current structures.

    Good luck with your projects.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Beginner needs a point in the right direction!
    By Gapco1 in forum Database Design
    Replies: 7
    Last Post: 07-30-2012, 07:13 PM
  2. Need direction and help
    By em815 in forum Access
    Replies: 9
    Last Post: 07-17-2012, 04:13 PM
  3. New and need some help and Direction!
    By OlneyFD in forum Access
    Replies: 0
    Last Post: 12-02-2011, 07:08 PM
  4. Replies: 86
    Last Post: 10-07-2011, 06:06 AM
  5. Need Direction
    By sabrish72 in forum Programming
    Replies: 5
    Last Post: 06-08-2011, 09:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums