Import fixed assets in APP9

Hi,

Please check the below post

Thanks and Best Regards

Madusha

Hi,

Sorry, you have asked for App9. 

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

Hi Madusha,

There is no external template for object imports in APP9.

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.

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