Question

Latest Ship Date

  • 3 February 2022
  • 3 replies
  • 153 views
G
Rank
Userlevel 6
Badge +10

Hi,

We are trying to create a report for identifying the Latest Ship Date of a inventory part. This is to identify the parts that are not sold/shipped for certain time period and making allowance for those.

We try to get this from the Inventory Transaction History. But, due to volume of transactions this is very slow. Is there a any other way to identify the Latest Ship Date of a inventory part? may be a view or method call?

Thanks

Gayan

This topic has been closed for comments

3 replies

T
Rank
Userlevel 7
Badge +18

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

N
Rank
Userlevel 7
Badge +13

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

 

V
Rank
Userlevel 2
Badge +2

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

Terms & ConditionsCookie settings