on 04-18-2019 3:01 PM
Hi All,
Is there a query to find out All open Sales Order Line totals due for delivery in Current Month?
Kind Regards
Hello,
Have you tried the default Backorder Report from Sales->Sales Reports
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Amit Jha,
Hope below query will help you:
SELECT T0.DocEntry, T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[OpenQty], T1.[Price],T1.[OpenQty]* T1.[Price] as 'OpenAmt' FROM ORDR T0 INNER JOIN RDR1 T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE T1.[LineStatus] ='O' and T0.[DocDate] >=[%0] and T0.[DocDate] <=[%1]
Best Regards,
Sandesh Shinde
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can create custom one
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can create custom one
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.