Skip to Content
Former Member
Apr 25, 2014 at 07:18 AM

Sales back Order Query


Hi All

I am having an issue with a query im doing for a customer for sales back orders.

The customer does not want to use the current back order report in Business one.

What they essentially want is to see only the items on back order where that sales order already has a delivery to it.

They do not want to see sales order that havent been delivered at all.

This is what i have so far.

it does pick up items where there is a balance to be delivered...however, it does not pick up the lines that have not been delivered at all

select T0.Docnum as "Sales Order Num", CAST(T0.DocDate as DATE) as "Sales Order Date", T1.ItemCode, T1.Dscription, T1.Quantity, T1.OpenQty from ORDR T0 inner join RDR1 T1 on T0.DocEntry = T1.DocEntry

where T1.TargetType <> '-1' and T1.LineStatus <> 'C'

Not to sure what I am missing.

Your help will be appreciated.

Thank you