locked
How to allocate Warehouse Rack with pallet volume? RRS feed

  • Question

  • User-1640542475 posted
    Hi Sir
    
    I have no idea how to fit the pallet into fixed Rack
    
    scenario
    
    1. Receiving  pallet, we can calculate volume (H x W x L) 
    2. We have fixed Metal Rack, we also know volume ((H x W x L) each and every Rack.
    3. Rack Example: Row A1 has 6 Rack which we know the volume.
    4. We have fixed each Rack with code. Example: A1-01,A1-02 etc...
    5. Each pallet has the barcode and also volume which we upload excel file into MSSQl 2017
    6. Once scan barcode, system will display volume of the pallet.
    
    Here is my requirements
    
    Once user scans the barcode, application has to tell the user that this Rack(Exp:A1-02) can be fit
    Example. Rack A1-02 has volume 50000. and pallet (barcode 1245782) has volume 10000
    so Rack A1-02 has fit multiple pallets (with different barcode).
    So application have to tell user when scan first pallet (volume 10000), A1-02 is available, then balance volume 40000
    if scan the second pallet (volume 25000) , A1-02 is available, then balance volume 15000 in A1-02.
    if scan the third pallet (volume 20000) , A2-01 is available, and so on. because A1-02 has balance volume 15000 only
    after few pallet, one pallet (volume 15000), application has to tell the A1-02 is available,then A1-02 is full.
    
    We are developing in ASP.Net web application. 
    I have done only upload excel file with Pallet details and volume into database and generate the Pallet Bar code 
    with Combination of date+location code+serial No.
    After that I could not move Further.
    Please advice, how to do it. Thank you Maideen

    Friday, June 14, 2019 3:54 AM

All replies

  • User61956409 posted

    Hi Maideen,

    Once user scans the barcode, application has to tell the user that this Rack(Exp:A1-02) can be fit
    Example. Rack A1-02 has volume 50000. and pallet (barcode 1245782) has volume 10000
    so Rack A1-02 has fit multiple pallets (with different barcode).
    So application have to tell user when scan first pallet (volume 10000), A1-02 is available, then balance volume 40000

    According to your requirement description, to implement the code logic, you may need to write a function to check the matched Rack and available volume, then update available volume of Rack after Rack is fit with pallet, so that you can call that function after user scanned a specific pallet.  

    With Regards,

    Fei Han

    Monday, June 17, 2019 2:46 AM