Alpha Video Training
Results 1 to 4 of 4

Thread: Stock Transfer

  1. #1
    Member
    Real Name
    Jack Lim
    Join Date
    Jun 2005
    Posts
    218

    Default Stock Transfer

    Hi

    I have Item Issue Form and Item Receipt Form

    Item Issue - Basically issue stock out
    Item Receipt - Basically receipt stock in

    Now, I need to combine both Item Transfer.

    Item Transfer Form should have 2 porption - Item Issue and Item Receipt in the Header Page and the Detail just show the product item.

    User will enter the inform of Item Issue and Item Receipt and go to the Detail page to enter the product, it should process 2 section, create a row data for Item Issue and row data for Item Receipts, both of them has difference reference number.

    Any one can advice how to do it? Should I need to create Dialog to write the script?
    Many Thanks.

    Jack Lim

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Stock Transfer

    I think you need a new table for product. Then you need to create a set with product as the parent and Item Issue and Item Receipt as children.

    Instead of entering

    enter the inform of Item Issue and Item Receipt and go to the Detail page to enter the product
    The logical flow should be to enter (or find) a product. Then enter issue or receipt information.

  3. #3
    Member
    Real Name
    Jack Lim
    Join Date
    Jun 2005
    Posts
    218

    Default Re: Stock Transfer

    Hi

    The Item Transfer in the Header Page has two column, one column is Item Issue and another is Item Receipts.

    Item Issue -> Stock Qty Reduce for Location A
    Item Receipt -> Stock Qty Increase for Location B

    After the user has enter the info in each of the column, the user go to the detail page to select the product which want to issue for Location A. When Click Save, need to update the Item Receipts for Location B.

    The Impact is: the Stk Qty for Location A -> say Product XYZ reduce 10 qty;
    the stock qty for Location B -> same product XYZ increase 10 qty.

    Both of them has independent Refer number such as ISS-0024 ; REC-0012; and the Transfer Reference Number is TRN-0012.

    All the transaction still update with the same table.

    How do I do in the form? Any advice.
    Many Thanks.

    Jack Lim

  4. #4
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Stock Transfer

    You probably need to post a sample of what you have so far.

    The Item Transfer in the Header Page has two column, one column is Item Issue and another is Item Receipts.
    Alpha doesn't have "header pages" or even "pages" nor "columns". You may be speaking of forms and fields but I can't be sure.


    After the user has enter the info in each of the column, the user go to the detail page to select the product which want to issue for Location A. When Click Save, need to update the Item Receipts for Location B.
    This doesn't make sense. Why not select a product first, then enter the quantities to be transferred from issue to receipts and enter the transaction numbers.

    It would be much easier for us to look at your database and offer advice than to try to guess what you are describing.

Similar Threads

  1. minimum stock calculation
    By Ian_Edwards in forum Alpha Five Version 6
    Replies: 1
    Last Post: 10-07-2004, 08:20 AM
  2. STOCK CONTROL TEMPLATE
    By Nev Kent in forum Alpha Five Version 5
    Replies: 2
    Last Post: 09-29-2004, 04:48 PM
  3. Help with stock ordering rule
    By Chris.Tanti in forum Alpha Five Version 5
    Replies: 0
    Last Post: 08-02-2004, 08:17 AM
  4. Stock movements
    By Arthur Armour in forum Alpha Five Version 4
    Replies: 1
    Last Post: 08-17-2001, 02:56 AM
  5. Stock Charting/Graphing?
    By Matthew Crider in forum Alpha Five Version 4
    Replies: 4
    Last Post: 06-06-2000, 08:02 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
  •