Sales Planning Model: A2 List

Hi, I'm having trouble when trying to import into the Sales Planning Model: A2 List in the Sales Planning Model. I created the necessary System Module in the Data Hub in order to use to populate the A2 List. I also filtered the module so only the valid Account>Product combos show and saved as a view. I then imported this saved module view into the Sales Planning A2 list and there are missing items. Perhaps my import mapping is wrong? Any guidance would be greatly appreciated! Please see the below screenshots for your reference.

(Saved Module view in the Data Hub used for import)

(Import mapping for A2 list in Sales Planning model)

(Result of import - missing items from the saved view import)

Comments

Misbah

@jjconn13

Your Import mapping looks perfect and your saved view too looks ok to me. Double check if you are importing it from the correct saved view. Here is one hint for you

Hint: Your item count should be 4511

jjconn13

Thanks for the response. I double-checked the saved view and it appears to be ok. Below is the number of items being imported which does not match the 4511. For some reason it is skipping some of the items in the saved view. For example, the Candyate account - it appears to be imported every other line almost.

(Import result)

(Import Saved view in Data Hub)

(Resulting A2 list in Sales Planning model) - Missing P001, P003, P005 etc.

jakesachs

Did you ever figure this out? I'm also getting the 4358, but I am seeing those candyrate list members...

jjconn13

I ended up deleting and creating the list again in the Sales Planning model and imported the data from the datahub again. It seemed to solve the issue but I'm not exactly sure why. Maybe it's just me, but the import screens seem to act a bit weird sometimes.

jjconn13

To clarify, I meant it fixed the missing list items that were not importing but my total was still the 4358.

jakesachs

Am I right to assume that this didn't lead to any issues down the line?

ssicefox

Hi @jjconn13 @Misbah @jakesachs

I imported 7950 rows.

BruceSonos

I got 4509 totally, before you import , the list itself had 151 items, after you imported, add 4358, totally is 4509, almost 4511, but I still have no idea how to get 4511.

Ghita

I also managed to import 4358, but I'm not sure why, the system is generating new code instead of using the mapped codes, I'm struggling with this so bad !!

here is my mapping, does anyone see what is wrong here ?

BruceSonos

What's your code look like? This code should come from datahub module.

Quick Links

Recent release news

June 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our June 2025 official release notes. The information below offers supplemental information to that post. Security and administration New 'Application Owner' security role Tenant administrations can assign the Application Owner role to users in their tenant.…
Register for our July 30 platform release webinar!
Anaplan's next quarterly platform release webinar will be held July 30, 2025 at 8 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience. Our expert-led session will equip you with a practical guide and live demonstrations to help you get the most out of new…