select sum(CostAmountAdjustment) from inventsettlement
// join tmp
*This post is locked for comments
select sum(CostAmountAdjustment) from inventsettlement
// join tmp
*This post is locked for comments
You can use the SQL profiler SQL server management studio to see where this query needs to have some improvements. Possibly an index is missing.
Is this coding based on standard with a small modification on the Voucher field or is it completely custom?
I tried to write sql sub query but at where exists am getting error in x++ nested or subqueries not support
DATEDIFF is not supported as command in x++. Can you explain what you want to achieve? I'm still not able to understand your question.
nested condition as if sql i trying to do like this
SELECT CustomerNAme
FROM Customers c
WHERE EXISTS (SELECT 0
FROM Order o WHERE c.customer_id = o.customer_id
AND DATEDIFF(yr, Orderdate, GetDate()) < 1
InventTrans tmp
InventTrans is a table
If you are talking about exist join then it is supported. Syntax looks like below.
while select * from salesTable
exists join salesLine where salesTable.SalesId == salesLine.SalesId
where condition
Hi Venu123,
What is your question here? What is "tmp"?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,214 Most Valuable Professional
nmaenpaa 101,156