Requested Delivery Dates for individual PO line items

SUGGESTED

Hi all,

I am trying to estimate stock levels for critical products over time by using the current stock level, planned consumption rate and the requested delivery date and quantity for each item. I want to pull this information out of Sage to process it further in Excel.

I am having difficulty extracting to Excel the 'Requested Delivery Date' for each line item on the Purchase Order. I can get the requested delivery date assigned to the PO as a whole but this isn't very useful as the delivery time for each line item can vary significantly. Does anyone know how to get this?

Thanks in advance :)

Joe.