Thank you so much again. For the record if someone else needs help, I run the SQL Profiler and these are the queries I got:
SELECT SUM("SUM$Quantity") as 'On Hand',
SUM("SUM$Invoiced Quantity") FROM dbo.[Buxton$Item Ledger Entry$VSIFT$2]
WITH(NOEXPAND) WHERE (([Item No_]='39316.BK.00'))
SELECT SUM("Quantity") as 'On Hand',
SUM("Invoiced Quantity") FROM dbo.[Buxton$Item Ledger Entry]
WHERE (([Item No_]='39316.BK.00'))
SELECT SUM([Outstanding Qty_ (Base)]) as 'Qty on PO' FROM dbo.[Buxton$Purchase Line]
WHERE (([Document Type]=1)) AND (([Type]=2)) AND (([No_]='39316.BK.00'))
SELECT SUM("Outstanding Qty_ (Base)") as 'On Sales Order' FROM dbo.[Buxton$Sales Line]
WHERE (([Document Type]=1)) AND ((Type=2)) AND (([No_]='39316.BK.00'))
SELECT SUM([Remaining Qty_ (Base)]) FROM dbo.[Buxton$Prod_ Order Line]
WHERE ((Status>=1 AND "Status"<=3)) AND (([Item No_]='39316.BK.00'))
SELECT SUM([Remaining Qty_ (Base)]) FROM dbo.[Buxton$Prod_ Order Component]
WHERE (([Status]>=1 AND [Status]<=3)) AND (([Item No_]='39316.BK.00'))
SELECT SUM([SUM$Outstanding Qty_ (Base)]) FROM dbo.[Buxton$Kit Sales Line$VSIFT$1]
WITH(NOEXPAND) WHERE (([Document Type]=1)) AND ((Type=1)) AND (([No_]='39316.BK.00'))
SELECT SUM([Quantity (Base)]) FROM dbo.[Buxton$Reservation Entry] WHERE (([Item No_]='39316.BK.00'))
AND (([Source Type]=32)) AND (([Source Subtype]=0)) AND (([Reservation Status]=0))
SELECT SUM("SUM$Intrans Qty") as 'In Transit' FROM dbo.[Buxton$Purchase Line$VSIFT$14] WITH(NOEXPAND)
WHERE (([Document Type]=1)) AND ((Type=2)) AND (([No_]='39316.BK.00')) AND
(([Outstanding Quantity]>0))
SELECT SUM([SUM$Quantity]) FROM dbo.[Buxton$Item Ledger Entry$VSIFT$2]
WITH(NOEXPAND) WHERE (([Item No_]='39316.BK.00')) AND (([Location Code]='RC'))
SELECT SUM("Quantity (Base)") FROM dbo.[Buxton$Package Line] WHERE
(([No_]='39316.BK.00')) AND (([Type]=2))
SELECT TOP 1 NULL FROM dbo.[Record Link] WHERE
(([Company]='Buxton')) AND (([Type]=0))
AND (([Record ID]=0x1B0000000089FF4F4D31303032322E424B2E4258000000))
Share
Report
85
All responses (
Answers (
