Level 2 Sprint 3

Hi All,

I was facing trouble importing Weekly Order Schedule csv to INV01 Inventory Ordering module. Can somebody please help with the correct mapping. I tried to manipulate the csv file too later on but still did not import (Exhausted all combinations but no luck)

Mapping options attached as screenshots

@Misbah @JaredDolich

@Abhishek

12_118566.JPG

11_118566.JPG

Comments

Misbah

@dhananjay1797

Prior to this screen you would have been greeted with other screen. On that screen you will have to choose Data Header as row 3 and First data row as row 2

Misbah

dhananjay1797

Hi @Misbah

Seems Data Header as row 3 and First data row as row 2 is not possible as both these are interlinked ie If Data Header = 3, it will automatically put First data row = row 4. If I try to change First data row = 2 then Data Header becomes = 1.

I was able to get around this by removing Submit Purchase Order Request in the csv file and putting at as the last column (Next to Week52 FY 21) hence all headers in the same row and it worked.

Screenshot attached for people who might run into the same problem!

You just need to manipulate the excel sheet a little bit

INV01_Inventory_Ordering_from_Weekly+Order+Schedule_118594.JPG

Misbah

@dhananjay1797

Absolutely NOT!

You should not change the source file. The whole point is to make you understand what should you do when the data row is not the first row in the source file.

Answer lies in how you set up an import and NOT how you change the source file because in the actual projects that is not even an option. SO, You will have to change the Data Header to 2 , automatically first row changes to 3. And the you can start an import .

Hope that helps

Misbah

Quick Links

Recent release news

May 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our May 2025 official release notes. The information below offers supplemental information to that post. Integrations and extensibility Preview dataset when mapping to model or selecting for transformation view in ADO When selecting a dataset to map to a…
April 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our April 2025 official release notes. The information below offers supplemental information to that post. UX New UX for Models section in Administration The Models section in Administration has been redesigned with a more intuitive interface. Tenant…