Import fixed assets in APP9

  • 19 May 2021
  • 5 replies
  • 386 views
D
Rank
Userlevel 4
Badge +3

What is the recommended way to handle bulk importation of fixed assets in APP9? If I have many assets to import and manual importation is time consuming. Did not find any external templates to import like in APP10.

This topic has been closed for comments

5 replies

MadushaDissanayake
Rank
Userlevel 7
Badge +17

Hi,

 

Please check the below post

Thanks and Best Regards

Madusha

MadushaDissanayake
Rank
Userlevel 7
Badge +17

Hi,

Sorry, you have asked for App9. 

I have checked in CORE, Seems like there’s no System Defined File Type for Component -FIXASS. 

D
Rank
Userlevel 4
Badge +3

Hi Madusha,

There is no external template for object imports in APP9.

Kalhari Dissanayake
Rank
Userlevel 6
Badge +11

Hi @DINRLK ,

 

You can create migration job for this purpose and it facilitate bulk importation of Fixed assets.

What you have to do is create separate migration jobs according to your requirement and recommended the below jobs with the level of details.

FA_OBJECT,

FA_BOOK_PER_OBJECT,

FA_USRDEFINED_BASE

FA_OBJECT_TRANS

Refer the solution ID 277966 Test plan for more detail set up.

 

Best regards,

kalhari.

Malgorzata Palatynska
Rank
Userlevel 5
Badge +10

Hi,

 

In the older versions you can use the Data Management module.
Define new jobs for views:
FA_OBJECT
FA_BOOK_PER_OBJECT
FA_USRDEFINED_BASE
FA_OBJECT_TRANS
And prepare data in excel sheet to import them.
Additionally in the excel you should fill in the following columns:
1) FA_OBJECT_TRANSACTION_TYPE_ID: 1 for acquisition value, 3 for accumulated depretation.
2) transaction id starting from 1000 value

After migration must be performed additionally:
1) change the sequencer for transactions id
OBJECT_TRANSACTION_SEQ;

3) posting of objects
update ifsapp.fa_object_tab
set rowstate = 'Active'
where company = '&company'
and rowstate like 'SystemStart'

I used it very often, when I worked at the Consulting dep.
It allows to import a huge number of objects :)
This import could be used only by consultants. It's too complicated for customers.

 

Best regards,

Małgorzata

Terms & ConditionsCookie settings