Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Defaulting expenditure Item date based on Promised delivery date — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Defaulting expenditure Item date based on Promised delivery date

Accepted answer
32
Views
1
Comments

Summary: Feasbility on defaulting the expenditure Item date in the PO Line/Schedule from the Promised delivery date captured at the PO Line/Schedule level.

Content (required):

requirement to default the expenditure item date in the PO Line/Schedule from the Promised delivery date captured at the PO Line/Schedule level. This is to make sure that the Project/Task date has not passed, when the goods against the PO are delivered. We are trying to modify the Project Standard Cost Collection Flexfield, EXPENDITURE_ITEM_DATE segment using a SQLto achieve this.

We are trying to default expenditure item date value using the "Initial Default" feature with the default type as SQL. We do not see any value in the derivation value LOV which will help us to uniquely identify the PO line or PO Schedule in order to fetch the promised delivery date. Is there a way to achieve this requirement?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!