SYS04 Product Family Details import problems

I have rebuilt each module associated with sys04 multiple times, have changed the Region codes in the Excel file (as suggested by Vera), have added formulas in the rows for Code and Region, but something is wrong with Country. It keeps giving me the message shown. What have I done incorrectly?

Thanks

MPW

SYS04_2_148250.png

SYS04_1_148250.png

Comments

JaredDolich

@MPW280

Formulas look good, so there might be a problem with the lists. Here is SYS04 and a few shots of how the lists should look.

Lists

Grid View of the locations. Make sure you don't have orphans.

ChrisAHeathcote

Has the G3 parent been set up correctly by referencing the G2 list?

The PARENT(ITEM()) formula is correct but the error would suggest it is returning itself and therefore the parent relationship is incorrect!

Check that the G3 list has been allocated G2 as its parent as I suspect you have allocated other items in the G3 list as the parent items.

MPW280

I rebuilt the line items and the module and managed to get the correct configuration. It took a few attempts but in the end it came out right.

Thanks

MPW

Quick Links

Recent release news

August 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our August 2025 official release notes. The information below offers supplemental information to that post. Planning experience Multi-browser tab syncing When changing context or data on a UX page, you can now view real-time data updates across up to five…
July 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our July 2025 official release notes. The information below offers supplemental information to that post. Planning experience External URL navigation button Page builders can configure navigation action buttons to link to external URLs, including non-Anaplan…