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.SELECTContract,part_no,max(REAL_SHIP_DATE)FROM CUSTOMER_ORDER_JOINGROUP BYContract,part_no Kind regards,Andy
Thank you both for your suggestions.Thomas, I had already tried connect the charge line to the CO line as you had suggested in your screenshot, and that does not pull through, so I will raise a case.IRituma, I think that solution may work in several instances, and is something we have investigated thanks to you suggestion, however it is not appropriate in my particular need, as that causes downstream implications on depreciation etc. The solution I have settled on for now; based on the fact that this is also a supplier directly delivered part/object, is to update the object acquisition cost based on part inventory valuation when using weighted average per lot/batch. The charges on the PO will pull through to inventory valuation, will also allow for invoice variance, and using a configuration we will copy that to the acquisition cost.
As an update for those who are trying to do a similar thing the workaround I have done is to create a migration job that reads mrp_part_supply_demand (via an IAL to aggregate per period) for these component items and insert the demand it into the forecast_day_import table.You can then run the DP server job External ImportThis will then update the demand plan for the component partSo that when IPR is refreshed it will create a more accurate safety stock plan This method involves a lot of scheduled jobs to accomplish something quite simple, so if anyone has an easier method to do this it would still be good to know.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.