SAP B1 HOW TO QUERY ON FLOAT AR RESERVE INVOICES WHICH ARE NOT YET POSTED IN DELIVERY

[Former Member]

Hi Experts.

I'm trying to query alert message which can alert the user all AR Reserve Invoice transaction floated and not yet posted in delivery.

Thank you & best regards.

[frank_wang6 · Accepted solution]

SELECT T0.DocEntry, T0.DocNum

FROM OINV T0

WHERE T0.CANCELED = 'N'

AND T0.InvntSttus = 'O' -- delivered or not, O means not delivered

AND T0.isIns = 'Y' -- reserved invoice flag.

Hope this help.

[Former Member · Accepted solution]

Hi sir,

i have another question regarding with my concern how can i range the date in a week (monday-Saturday) that every Saturday the alert message will show.

Thank you & best regards

[frank_wang6 · Accepted solution]

Alert will allow u to do so.

Frank

[Former Member · Accepted solution]

Thank you sir Frank

[KennedyT21]

Hi

Try this

SELECT T0.DocNum,T0.CardCode ,T0.CardName ,T1.ItemCode,T1.Dscription ,T1.Quantity ,T1.Price,T1.OpenQty , T0.DocTotal  

FROM OPCH T0 INNER JOIN PCH1 T1 on T0.DocEntry=T1.DocEntry

WHERE T0.DocStatus='O' and T0.InvntSttus='O'