Level 2 Sprint 3

Options
dhananjay1797
dhananjay1797 Member, ALL USERS Posts: 4 Occasional Contributor

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 

Comments

  • dhananjay1797
    dhananjay1797 Member, ALL USERS Posts: 4 Occasional Contributor

    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