Solved

FA object import excel template

  • 9 August 2021
  • 5 replies
  • 437 views
L
Rank
Userlevel 6
Badge +7

Hello, 

 

I’m trying to import fixed assets using the ExtFAObjectImport template, however there’s no column to accumulated depreciation. 

Since my fixed assets already have some depreciation, how to import those?

 

Thanks.

icon

Best answer by Sugandi Nadeeshika 9 August 2021, 13:41

View original
This topic has been closed for comments

5 replies

D
Rank
Userlevel 4
Badge +7

Hi, I believe you need to import it separately.

#ProudlyIFS #forthechallengers
Malgorzata Palatynska
Rank
Userlevel 5
Badge +10

Hi,

 

for such purpose you can use line type N from the ExtFAObjectImport template.

It looks like:

 

N,    company,      object_id,     BOOK,    Year,    Period,    Amount (there you enter an accumulated depretation value) ,       Transaction type, ex. OTHERS

 

Best regards,

Malgorzata

S
Rank
Userlevel 6
Badge +10

Hi @Luiz R ,

In ‘External File Template’, there is a field representing depreciation as highlighted below,

You can include accumulated depreciation under this and it will then load under ‘Accumulated Depreciation’ column.

Additionally, you could use ‘RMB > Import Object’ function as well. 

You can manually enter accumulated depreciation and all the values of the object in this ‘import object’ window. However, under this function you could import the details of one object each time only. 

 

Hope this would be helpful.

Best Regards

Sugandi

L
Rank
Userlevel 6
Badge +7

Thank you so much, @Sugandi Nadeeshika 

 

So, I just have to input the information at row 4, right? And then upload through the External File Assistant, right?

 

 

Thanks once again.

 

Best regards!

S
Rank
Userlevel 6
Badge +10

Hi @Luiz R ,

Yes, you are correct and welcome :slight_smile:

Best Regards

Sugandi

Terms & ConditionsCookie settings