+ Reply to Thread
Results 1 to 3 of 3

Stock Inventory

  1. #1
    larry_saudi
    Guest

    Stock Inventory

    Dear Sir,

    Is it possible in Excel that by just encoding the data in receive and issue
    voucher it will automatically post in STOCK CARD worksheet and then
    automatically update in the MATERIALS INVENTORY worksheet: See my sample
    below.

    Thanks for help


    RECEIVE VOUCHER
    DATE VOUCHER# CODE# DESCRIPTION QTY
    6-Jul 1550 987 Sticker 200
    6-Jul 1550 988 Masking Tape 2" 500

    ISSUE VOUCHER
    DATE VOUCHER# CODE# DESCRIPTION QTY
    6-Jul 1234 987 Sticker 75
    6-Jul 1234 988 Masking Tape 2" 50

    STOCK CARD

    CODE # 987
    DESCRIPTION STICKER

    DATE VOUCHER IN OUT BALANCE
    5-Jul 3000
    6-Jul RV#1550 200 3200
    6-Jul IV# 1234 75 3125

    CODE # 988
    DESCRIPTION MASKING TAPE
    DATE VOUCHER IN OUT BALANCE
    5-Jul 4500
    6-Jul RV#1550 500 5000
    6-Jul IV# 1234 50 4950

    MATERIALS INVENTORY



    CODE # DESCRIPTION BEGIN IN OUT END

    987 STICKER 3000 200 75 3125
    988 MASKING TAPE 4500 500 50 4950










  2. #2
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    put a sample excel file.

  3. #3
    larry_saudi
    Guest

    Re: Stock Inventory

    Sir,

    Please find the web page C:\Documents and Settings\admin\My
    Documents\Page.htm. I dont know how to make a screen shot of thesample
    spreadsheet. Thanks for the reply.
    Best regards

    "starguy" wrote:

    >
    > put a sample excel file.
    >
    >
    > --
    > starguy
    > ------------------------------------------------------------------------
    > starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
    > View this thread: http://www.excelforum.com/showthread...hreadid=562147
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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