Hi, I have an issue with the formulae : Is Project and Is Vendor, the column project code and vendor ID are not existing in the table. can you please help me ?
Thank you for your question. I have researched a possible answer that one of my colleagues posted a while concerning the formulas, Is Project and Is Vendor. I have copied the answer below and i hope it will resolve your problem.
we've identified a typo in the guide:
An additional update we will add to the update list is that on page 22 the formula for Is Project should actually read
When writing this formula, we should be looking for Project Code instead of Project ID. The formula is looking for a value in the Project ID column to determine if this line item in our data is a project or not. The problem is that our data has that information labeled as Project Code.
I hope this helps. If not, feel free to respond with a link to your project and one of us will review it. No need to send your password, we all have permission to view the student projects.
Hi ABDEL BOUAKLINE, Just adding one more thing to address the Is Vendor formula you also mentioned.... go ahead and create the Is Vendor formula too. It won't return values because you don't have a vendor ID but you'll configure the Vendors object later in the project and that will sort itself out.
For the latest question per your Lab Assist visit today here is an answer: Your project looks GREAT! The only thing wrong is you missed the very last step on page 47. #7 at the top of the page has you map Acme Cap EX Budget to the Cost Source Master Data.
This is how I tracked down the issue with dollars not flowing to Projects in your CapEx Budget model.
First, I noticed that the Project Keys which create the relationship between Cost Source and Projects in the CapEx Budget model metric do not match.
Source is generating CS_Project
Destination is generating CS_Project with a project number following it.
So that told me that Project Code was missing from the Cost Source Master if you filter the Cost Source master table by =CapEx Budget you realize there is no data. Why? Not appended yet.
Solution: Complete Step #7 page 47
When you do that, the key the is being created on the Cost Source Master data side will be able to access the project code and it will create matches with the destination data.
For more info on the default allocations, check out this blog post: https://tbmcouncil.jiveon.com/blogs/jgoodwin/2017/11/29/understanding-the-default-allocations-in-ct-r12
When you take the Data, Model and Report Validation course, you will learn how to track down issues like this. So don't worry, there's more learning to come! :-)
Retrieving data ...