Hi

I know this is not a direct answer to your question. 

As a finance guy, latest ship date is not the only indicator of affected parts.  For example if a raw material is issued to a shop order, that part has no shipment yet it has been consumed.  Also, new parts will have no shipments, but would not be considered as slow. 

You may wish to look at the IFS slow moving inventory report it may help. 

Typically, when looking in IFS for the date you seek, we consider different types of parts, parts that have been created after a given date and refer to movements over the last X months (not going back to beginning of time).   These filters should make the search faster - especially transaction dates > X.  By looking at dates greater than X we assume if no shipment / issue then the part is slow. Also exclude parts that have 0 on hand. 

My experience has been to create a SQL statement designed to filter out the necessary records.

Best regards, 

Thomas

hi,

Further to above reply given by Thomas, if you are looking for non moving parts you may consider about ‘Last Activity Date’ of the inventory part in Stock window

However if you need to know about ‘ Latest Ship Date of a inventory part’ I guess it is better to take from ‘Inventory Transactions History’ window. You may get the inventory parts from ‘Inventory Value per Period’ window & then pass that value to transaction history window & get the latest ship date.

Best Regards

Narmada

Hi,

There is last actual ship date in customer order lines: 

meaning you can query for this in sql or you could simply do an advanced search in that screen and have it as a saved search:

If you were to query this you would use the field Real_ship date e.g.

SELECT
Contract,
part_no,
max(REAL_SHIP_DATE)

FROM CUSTOMER_ORDER_JOIN

GROUP BY
Contract,
part_no

Kind regards,

Andy