cancel
Showing results for 
Search instead for 
Did you mean: 

All open sales order line

amit_jha1
Explorer
0 Kudos

Hi All,

Is there a query to find out All open Sales Order Line totals due for delivery in Current Month?

Kind Regards

Accepted Solutions (0)

Answers (4)

Answers (4)

msundararaja_perumal
Active Contributor
0 Kudos

Hello,

Have you tried the default Backorder Report from Sales->Sales Reports

Thanks.

former_member225732
Contributor
0 Kudos

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

former_member197302
Participant
0 Kudos

You can create custom one

former_member197302
Participant
0 Kudos

You can create custom one