Difference Between A Back Order & Open Order

[Former Member]

I am using Query to produce custom reports and need some help. I have linked the tables ORDR & RDR1 and I cant tell how to code the report to tell me if it is a backorder or just an open order. Any help would be greatly appreciated.

Thanks Jim Dyer

[Former Member · Accepted solution]

Hi,

Backorder mean if any item has been partially delieverd from the sales order. Open order means that

the documents is not fully delivered may be some rows are not delievered at all.

So a backorder doucment is alwaus a open order but not viceversa.

You can also check [Backorder|https://css.wdf.sap.corp/sap/support/notes/0000941631] for more information.

Regards

VIkas

SAP business One Forums Team.

[Former Member]

Jim,

An open order row (no backorder) will have the 'quantity' field equal the 'open quantity' field. If the row is backordered, then these 2 fields will NOT be equal. You could also look at the 'delivered quantity'. If there is a qty in the 'delivered quantity' and the row is open then it is a backorder.