8.5.3 Activity: Import Data into Volume Inputs Module

alancheah · November 2020

Dear all,

I am having trouble importing data with selecting the source for Target No.4 which is REV02 Volume Inputs Line Items.

I have tried all options on the drop down menu on the left (refer attachment).

Pls advise or comment. Thanks.

GONI · November 2020

Hi Alancheah,

You have to choose as 'Fixed line item' under target 4, and under 5th tab select as 'Volumes' from drop-down.

The main reason selecting volumes here is that, data belongs to Volumes and same thing you can verify from first row in excel data.

Hope it helps.

Regards,

Basavaraj

alancheah · November 2020

Hi Basavaraj,

I have tried fixed line item as suggested by you and selecting volumes but I have this error (refer attachment).

Thanks for your help.

And I am open for others to advise/assist me if any of had this problem.

Alan Cheah

GONI · November 2020

Hi Alan,

The error is because wrong formatting of date/period.

On the same mapping window, select time tab and mention as YYYYMM, This is because we have data in this format 201901, 201902..so on.

Stay Safe,

Basavaraj

alancheah · November 2020

TQ so much. Problem solved.

Chmacpherson · November 2020

Thank you! Super helpful

pravin_prabhu · November 2020

Hi Basavaraj,

I am getting an error '

Invalid period for format YYYYMM'

Updated - 26076

Failed - 52152

I followed all of the instructions in this thread.

GONI · November 2020

Hi Pravin,

Could you share the Mapping screen. Also what is period format in your data?

Regards,

Basavaraj Goni

pravin_prabhu · November 2020

Hi Basavaraj - please find attached. Please download the attachment files and open it.

ckongpanickul · March 2021

I am running into the same issue. Did you solve this?

Details show Invalid format with YYYYMM and 202001. This seems strange to me. Does anyone know what I'm missing here?

olgaitskova · April 2021

I had the same issue, and for me the problem was that Current Fiscal Year in Time settings changed to FY21 for some reason (it was supposed to be 2020). Since the number of past years is 1, the data for 2019 couldn't be imported.

Tanok · May 2021

Thank you for the details. I was stuck on this part for so long.

jdatz86 · July 2021

I think I did this correctly but I technically got a different success import back. I ignored a few instances in my

Capture 4.PNG

Capture 5.PNG

Capture 3.PNG

I think the red line is supposed to incorporate the "Time YYYYMM". I manually inserted them to get the correct answer. How do I ignore the volume line and move the red down to the YYYYMM second column?