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
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
MSDN Community Support
Please remember to "Mark as Answer" the responses that resolved your issue.
Member
58 Points
184 Posts
How to allocate Warehouse Rack with pallet volume?
Jun 14, 2019 03:54 AM|maideen5|LINK
All-Star
40485 Points
6233 Posts
Microsoft
Re: How to allocate Warehouse Rack with pallet volume?
Jun 17, 2019 02:46 AM|Fei Han - MSFT|LINK
Hi Maideen,
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
MSDN Community Support
Please remember to "Mark as Answer" the responses that resolved your issue.