Skip to Content
0

Can Sales Backlog be run for an older date

Mar 09, 2017 at 12:04 PM

23

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Peter Hartwich
Apr 20, 2017 at 08:02 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded