Skip to Content

Can Sales Backlog be run for an older date

I have been asked if a sales backlog report can be run for a specific date in the past. We have the existing query:

SELECT t0.Cardcode as "Customer#", t0.Cardname as "Customer Name", t0.DocNum as "SO #", t1.ItemCode, t0.DocDate, t0.DocDueDate, t1.OpenQty, t1.OpenQty*T1.price AS 'Open Value'

FROM dbo.ORDR t0 INNER JOIN dbo.RDR1 t1 on t1.docentry = t0.docentry

WHERE t1.LineStatus = 'O' AND t1.OpenQty > 0

Basically they want to see a snapshot of the backlog on specific dates.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 20, 2017 at 08:02 AM

    Hi Keith, changed primary tag to SAP Business One. Please use the most relevant primary tag that reflects your working area best. Without the proper tag, the right people will not see your question and you will get hardly any answer or even a solution. You can find the list of primary tags here: http://sapassets.edgesuite.net/tools/SAP-Community-Tags.xlsx

    Add comment
    10|10000 characters needed characters exceeded