In Module 7 of Level 1 Model building, we are asked to import product data into the Product Details module and map to the source. However, my mapping does not seem to be accurate, and I cannot figure out the issue. I've attached screenshots of what my mapping looks like, as well as what it results in. Any and all help would be much appreciated!
resultsoriginal mappingManually mapping some itemserror message
@Belson97
Take a look at grid view on the list. Make sure your Product Family codes are loaded. You may need to reload it.
If that looks good lets take a look at the details of the errors as @rob_marshall suggests.
Oh, so so close.
Make sure you Product Family Line item is formatted as a list "P1 Product Family". Looks like its formatted as a number. Try it again.
You got this!
@JaredDolich Thanks for the quick reply! I changed the format to List P1 Product Family, but now I am getting an error that says the items are not located in the list. I've attached screenshots of the error and my P1 list.
To get a better idea of what is going on, after you run the action and get the error screen, click on the Details tab and it will give you more granular information on the errors.
Rob
@JaredDolich Product List was the issue. This is how my content returns now which I believe is correct yes? Thanks for all your help Jared!
I am trying to create a Net Debt / EBITDA formula at the bottom of one of our P&L income statements where, i have tried the MOVINGSUM function. However this does not work for summary line items which EBITDA is. What i would like is to be able to sum the previous 12 months EBITDA (Including the current period) numbers in a…
Hi I'm looking to speak to people who have used/are using the Docusign integration in their business. We are exploring the possibility, but we find the current setup quite limiting in terms of how an end user would interact with the integration, but also issues with concurrency and number field formats. Would appreciate…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
