Item Due Date From Vendor

[Former Member]

Hi -

I am looking for the easiest way to find out when all open PO's for a specific item are due in. The only tool we are using now is the inventory status report then drilling down to the activity.

I need a quick way, that if our CS people are on the phone and customer wants to know when an item is due in, they can get it in a quick glance. Does it really have to be generated through a query or a crystal report? If so, how?

[Former Member]

Hai!

Drag and Relate also not showing DueDate.

Try this query, modify as per your need.

SELECT ShipDate as 'Due Date',* FROM POR1 T0 WHERE T0.ItemCode ='[%0]'

Regards,

Thanga Raj.K

[Former Member]

*Close the thread, if issue solved

Regards,

Thanga Raj.K

[Former Member]

not yet, will let you know

[Former Member]

Assign this FMS to Item Descrition then shift f2 or click the magnifying glass.

You have to modify it as we use UDF Fields for ETA Dates

IF (SELECT DISTINCT T0.Itemcode FROM POR1 T0 WHERE T0.ItemCode = $[$38.1.0] AND T0.Dscription = $[$38.3.0] AND T0.LineStatus != 'C')

IS NOT NULL

SELECT T1.DocNum AS 'Document',

T0.ItemCode AS 'Item Code',

T0.Dscription AS 'Description',

T0.Quantity AS 'Orig. Qty',

T0.OpenQty AS 'Open Qty.',

T0.LineStatus AS 'Status',

U_PORedDT AS 'E.T.A. COWPER'

FROM POR1 T0

INNER JOIN OPOR T1 ON T0.DocEntry = T1.DocEntry

WHERE T0.ItemCode = $[$38.1.0] AND T0.Dscription = $[$38.3.0] AND T0.LineStatus != 'C'

UNION

SELECT (SELECT MIN(DocNum) FROM OPOR), NULL, 'END OF REPORT', NULL, NULL, NULL , NULL

ORDER BY DocNum DESC

[former_member187989]

Use Purchase Analysis by Items,Will give u open items list clearly,Don't forget to assign

Shortcuts to get selection creteria of Purchase Analysis(Function Keys -F2 to F12)

[Former Member]

This is not what had in mind. Too many clicks for a customer service rep

[Former Member]

Hai!

Use Drag and Relate Report.

Drag the Particular item and put it on Purchase Order Details.

It will list the details of Po raised for that Item.

Regards,

Thanga Raj.K