D
Debbie
Hi:
I am attempting to create a Back Order Fill Query.
I have a table of back orders containing SKU, Customer, Invoice Number, Sale
Date, Time and qty ordered.
I want to look at the inventory file and determine which orders can be
filled, the sequence is by sale date and time (first come, first served).
I'm at a loss on how to view/match to the inventory file but only print
those for which there is enough inventory to fill and leave the others on
back order. If I link the two tables together the OnHand Qty, and On Order
qty is repeated for each sku found in the sales table.
Example:
Sales Table Inventory Table
SKU=123 SKU=123
OrdQty= 4 OnHand=3
OrdNum: 2001 OnOrder=10
Orddate: 7/21/2006
OrdTime:11:56
SKU=123
Ordqty=1
OrdNum: 2002
OrdDate: 7/21/2006
OrdTime:12:23
3 of SKU 123 need to go to order 2001, leaving 1 on backorder. Order 2002
remains back ordered.
The query should only display order 2001 for 3, leaving 1 on back order.
I hope I'm explaining this properly.
Any ideas - help please!
Thank you!
Deb
I am attempting to create a Back Order Fill Query.
I have a table of back orders containing SKU, Customer, Invoice Number, Sale
Date, Time and qty ordered.
I want to look at the inventory file and determine which orders can be
filled, the sequence is by sale date and time (first come, first served).
I'm at a loss on how to view/match to the inventory file but only print
those for which there is enough inventory to fill and leave the others on
back order. If I link the two tables together the OnHand Qty, and On Order
qty is repeated for each sku found in the sales table.
Example:
Sales Table Inventory Table
SKU=123 SKU=123
OrdQty= 4 OnHand=3
OrdNum: 2001 OnOrder=10
Orddate: 7/21/2006
OrdTime:11:56
SKU=123
Ordqty=1
OrdNum: 2002
OrdDate: 7/21/2006
OrdTime:12:23
3 of SKU 123 need to go to order 2001, leaving 1 on backorder. Order 2002
remains back ordered.
The query should only display order 2001 for 3, leaving 1 on back order.
I hope I'm explaining this properly.
Any ideas - help please!
Thank you!
Deb