+ Reply to Thread
Results 1 to 2 of 2

Gift card inventory & invoicing

  1. #1
    Registered User
    Join Date
    03-26-2014
    Location
    NY
    MS-Off Ver
    EXCEL 2010
    Posts
    1

    Gift card inventory & invoicing

    Hello - I am new to this forum so I apologize if my question is not clear or in the incorrect area.

    I am trying to find out if Excel will allow me to track gift cards that we receive from our home office and then transfer to our individual stores. When we sends cards to our stores they are for particular organizations and I would like to create an invoice for each order that will provide the card #'s we should be pulling and in turn reflect a new inventory.

    We do not track the balance on the cards....when they were used, by whom or anything to do with the actual card usage itself. All we do is create invoices for the customers purchasing the cards and update our inventory, however keeping track of the card #'s themselves.

    For example:

    Monday: We receive 50 gift cards with a denomination of $100. The gift card #'s range from 100-149.

    Tuesday: We issue 25 of these $100 gift cards to store 123 for organization ABC. The invoice will show card #'s 100-124 being issued to ABC Organization. Our new inventory will show 25 remaining cards with the #'s 125-149.

    Is this something possible in Excel or Access?

    Thanks to anyone who may be able to help me.

  2. #2
    Valued Forum Contributor adyteo's Avatar
    Join Date
    01-10-2013
    Location
    Calgary
    MS-Off Ver
    Excel 2010
    Posts
    540

    Re: Gift card inventory & invoicing

    better off to use Access. You can use Excel however you will need Macros (VBA) to update your inventory.
    Click on the star if you think I helped you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conjoint Market Simulator - $10 Amazon gift card
    By abduljaleel.mca in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2013, 11:25 AM
  2. Macro to hide rows - Amazon gift card to whoever can help!
    By reubank in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-22-2013, 06:29 AM
  3. [SOLVED] Credit card type based on card number
    By wlsnoops in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-26-2013, 10:25 AM
  4. Inventory and invoicing
    By PMA in forum Excel General
    Replies: 4
    Last Post: 03-02-2010, 05:24 AM
  5. how do I setup invoicing to deduct from inventory?
    By Splash in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-17-2005, 12:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1