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

Extract Cost Center from "Code Combination Description" field - (Procurement - Spend Real Time) subj

Received Response
62
Views
5
Comments
edited Dec 14, 2017 5:01AM in Reporting and Analytics for ERP 5 comments

Summary

Extract Cost Center from "Code Combination Descpription" field

Content

I am using "Code Combination Description" field as one of my select columns from (Procurement - Spend Real Time) subject area. It is available under Procurement - Spend Real Time >> Invoice details >> Distribution Combination >> Code Combination Description.   

Primarily I would like to check the No.Of Invoices entered and No. of Invoices Paid under a specific Cost Center.  

Currently, the value under "Code Combination Description Field" appears like  HOV.LOB.POP CENTER.EXPENSE-VISION.DEFAULT.DEFAULT.DEFAULT.DEFAULT).  Now, I would like to extract only "POP CENTER" which is the 3rd Segment in Code Combination Description field separated by "."

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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