Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
linking tables in access ItemInventoryAssembly, Item, and Sales Order Line |
Author |
Message |
|
Posted : 2006-08-09 07:23:52 |
I am trying to link tables with in Access - ItemInventoryAssembly, Item, and Sales Order line. It appears that they are connecting but my query will not run. I tried linking the SalesOrderLine with the others witht Salesorderlineitemreflistid. Is this possible? I need to compare my data that is on hand and on sales order --then it must be filtered by ship date.
Amy |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-08-09 11:15:42 |
Try the following:
FOR INVENTORY ASSEMBLIES: Select SalesOrderLine.ShipDate, SalesOrderLine.CustomerRefFullName, SalesOrderLine.RefNumber, SalesOrderLine.SalesOrderLineItemRefFullName, SalesOrderLine.SalesOrderLineQuantity, ItemInventoryAssemblyLine.QuantityOnHand, ItemInventoryAssemblyLine.ItemInventoryAssemblyLnItemInventoryRefFullName, ItemInventoryAssemblyLine.ItemInventoryAssemblyLnQuantity from SalesOrderLine, ItemInventoryAssemblyLine Where SalesOrderLine.SalesOrderLineItemRefListID = ItemInventoryAssemblyLine.ListID and SalesOrderLine.ShipDate >= {d'2006-08-01'}
FOR INVENTORY PARTS: Select SalesOrderLine.ShipDate, SalesOrderLine.CustomerRefFullName, SalesOrderLine.RefNumber, SalesOrderLine.SalesOrderLineItemRefFullName, SalesOrderLine.SalesOrderLineQuantity, ItemInventory.QuantityOnHand, ItemInventory.FullName, ItemInventory.QuantityOnOrder from SalesOrderLine, ItemInventory Where SalesOrderLine.SalesOrderLineItemRefListID = ItemInventory.ListID and SalesOrderLine.ShipDate >= {d'2006-08-01'}
|
|
|
|
|
Posted : 2007-10-17 07:04:05 |
I am trying to find the inventory on hand that corresponds with the Inventory Stock Status Report. Which table do I get this from? When I used the suggested query above, it gives me what has been allocated to the sales orders.
Thank you for your help on this.
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-10-17 08:16:27 |
|
|
|
|