Register

10.2.2 Import Data into Non Employee Expenses Module

aevmajor
Occasional Contributor

10.2.2 Import Data into Non Employee Expenses Module

hey guys what date format do you do I am at my wits end lol

 

HELPPP

 

aevmajor_0-1599702201418.png

 

aevmajor_1-1599702247429.png

 

aevmajor_2-1599702292293.png

 

6 REPLIES 6
SrikanthKamath07
Contributor

Re: 10.2.2 Import Data into Non Employee Expenses Module

Hi @aevmajor 

 

Check YYYYMM.

 

Regards,

Srikanth

Zhanat
Occasional Contributor

Re: 10.2.2 Import Data into Non Employee Expenses Module

Good evening! 

Could you please advise what should I do further as my figures seems too high after import of 10.2.2 activity Import data for Non-employee modules. 

first pic is my newly created and working module and the second is kind of my target module data. Could you please advise further actions?

Thank you in advance!

Zhanat_0-1613914923890.png

Zhanat_1-1613914942594.png

 

JaredDolich
Moderator

Re: 10.2.2 Import Data into Non Employee Expenses Module

@Zhanat 

Looks like you're really close. The RENT value is correct. So, my hunch is that you loaded the other three expenses more than once. What I would suggest is that you go to blueprint mode, put a "0" as a formula in all the line items. Then remove the zero formula. This will zero out your values. Then reload the data. See if that helps.


Jared Dolich
Zhanat
Occasional Contributor

Re: 10.2.2 Import Data into Non Employee Expenses Module

Thank you Jared for your advice and quick response!

 

I zeroed previuosly imported data by changing formula. After importing, results are still the same - in millions which are 10 times higher than they supposed to be.

Tried to zero and import the data many times, but unfortunately, no changes. The only thing I've noticed is that Target model has some references while mine doesn't have. Profit and Loss topic is in my next 11 Lesson. Could it be the reason of difference? Screenshots are attached for your reference.

 

Thank you in advance!

Zhanat_0-1614065408572.pngZhanat_1-1614065427768.png

Zhanat_2-1614065441560.png

Zhanat_3-1614065453615.png

Zhanat_4-1614065458733.png

 

JaredDolich
Moderator

Re: 10.2.2 Import Data into Non Employee Expenses Module

@Zhanat 

Aha! I figured it out. 

So, first of all your import is perfect. No change is needed there. If you change the number format to 4 decimal places, you'll notice RENT does not have any decimals and not-coincidentally that is the one that is importing correctly. So the issue must be that you've set your number format to expect 1000's using the decimal place. Make sure each of your number formats look like this:

OTH001.png


Jared Dolich
Zhanat
Occasional Contributor

Re: 10.2.2 Import Data into Non Employee Expenses Module

Thank you so much for your help! Very much appreciated!