Allocate Qty from Bin to PickList (1 Viewer)

ayersh

New member
Local time
Today, 07:03
Joined
Jan 10, 2017
Messages
3
Hi,
I want some help to create picklist database against customer order.

My project sample attached for reference.

I have created table Stock_By_Bin.all current stock are stored in this main table.
second i have created order line table.
Third created Pick list.

I want to created picklist based on order qty from Stock_By_Bin table using Create Picklist button.

Pls help.
 

Attachments

  • Order_Entry.mdb
    864 KB · Views: 1,216

Ranman256

Well-known member
Local time
Today, 10:03
Joined
Apr 9, 2015
Messages
4,339
you mean something like this?...
pick list states -lbls.png
 

ayersh

New member
Local time
Today, 07:03
Joined
Jan 10, 2017
Messages
3
Please see my attached database. You will understand what i need.

Sorry for my poor English..
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 22:03
Joined
May 7, 2009
Messages
19,175
Check out your pick list
 

Attachments

  • Order_Entry.zip
    35.7 KB · Views: 34

ayersh

New member
Local time
Today, 07:03
Joined
Jan 10, 2017
Messages
3
Dear arnelgp Sir,

Thanks a lot for your reply, it's almost close that what i need.
its possible to allocate Qty to pick automatic by clicking create picklist as per Production date priority?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 22:03
Joined
May 7, 2009
Messages
19,175
Here is ur auti allocate pick list
 

Attachments

  • Order_Entry.zip
    38.7 KB · Views: 30

Users who are viewing this thread

Top Bottom