Get if salesTable has open lines ax 2009

Finance and Operations/AX Developer Forum
1

Hello,

how to get by code if the SalesTable has unpicked, undelivered and uninvoiced lines?

How to get all lines having qty in this status?

thx

2

Hello,

select sum(RemainSalesFinancial) from salesline → to get total qty from all the salesline.

if you want to find based on the sales id then give the sales id in the where condition like

select sum(RemainSalesFinancial) from salesline where salesline.salesid == ‘XXXXXX’

use RemainSalesPhysical to calculate the undelivered quantities for the sales order

Regards,

Muthukumaran

3

Thx but it considers even the picked qty not yet registrated?