Thanks for reading! I'm trying to find a way to make this query work with variables to list documents where the item price was within a range and the document date is later then something.
It seems to be working fine as long as I have defined dates...
Hi,
we have a scenario where a Sales BOM item is sold from two warehouses (the components are also sold as separate products). The desired process is that the child items are consumed from the warehouse where the parent item was sold. Instead, they...
Hi Team,
I'm trying to identify customers who purchased from one warehouse but not from the other and I have this query, which is working and giving the correct answer but takes nearly 3 minutes to run, even though the timeframe is very short (only...
Hi Everyone,
this has been asked earlier by someone else but I don't think there was a solution at the time.
I have the query below running fine in Query manager with less then 10 rows, as expected and each row displaying unique results.Once I ha...
Hi Everyone!I have a query running fine in SSMS and it has no variables. When I try to run the same in B1, it's asking for the ItemCode to be chosen by the user..? Any ideas on what I'm doing wrong?Thanks!
SELECT distinct T1.ItemCode
, (SELECT SUM(...
Hi Claudio,how about this one?SELECT T0.[CardCode], T0.[CardName], O.DOCDATE as 'Last Invoice Date', O.DocNum as 'Last Doc Num'
FROM OCRD T0
INNER JOIN OINV O ON O.CARDCODE = T0.CARDCODE
WHERE T0.[CardType] = 'C' and T0.[validFor] = 'Y'
AND O.D...
Hi Claudio,how about this?SELECT T0.[CardCode]
, MAX(T0.[DocNum]) as 'Last Invoice Number'<br>, MAX(T0.[DocDate]) as 'Last Invoice Date' <br>FROM OINV T0 <br>GROUP BY T0.[CardCode]Since you are using an aggregate function (MAX), you would need to put...
Hi Lothar,I spent the entire morning reading comments (often yours, hehe) answering this same question over and over again. And your solution seemed to have worked for everyone else!I did, in the end, figure out the mistakes you mention; however, in ...
And then it didn't work again in a slightly different scenario... For the benefit of those who have gone near mad spending hours trying to find a solution (I've now seen dozens of questions along the same subject line "must specify table from select...
That's fantastic, it works with the quotation marks - didn't think about that!I wish SAP was giving more helpful error messages - I know SQL Server does, but when it comes to variables, you're on your own... Thanks again!
