Finance | Project Operations, Human Resources, ...

Fixed Asset Groups Data Entity import failed

(0) Share

Report

Posted on by Phyllis Pang

Hi All,

Currently, there are some fixed asset groups exist in system already ;

then I do want to import some other new fixed asset groups by using the Data management - import through the data entity "Fixed Asset Groups"

However, when import, error prompt as follow:

The column FIXEDASSETGROUPID in entity Fixed asset groups has incorrect data. Please correct the data and try the import again.
'0' 'Fixed asset groups' record(s) inserted in staging

Seems NOT allow to insert the Fixed Asset Groups record....anyone know what settings I should fix in order to able to import the Fixed Assets group records ? thanks

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Sukrut Parab 71,741 Moderator on at

Like (0)

Report
Copy link

Link copied!

Looks like fixed Asset Group id you are using in your template does not exist in F&O. Can you check if the value is present in Fixed asset > set up > fixed asset group form ?

Was this reply helpful? Yes No
Suggested answer

BillurSamdancioglu 20,827 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hi,

Open your excel and delete all the lines after your data finishes which look like blank lines and retry to import after you attach your new file.

Was this reply helpful? Yes No
Phyllis Pang 44 on at

Like (0)

Report
Copy link

Link copied!

Hi Sukrut,

do you mean, i need to create the Fixed Asset groups one by one manually in system first, then use the Data Entity to update the information ?

But I do want to make use of the data entity to create those new Fixed Asset groups in system....

Was this reply helpful? Yes No
Suggested answer

Phyllis Pang 44 on at

Like (0)

Report
Copy link

Link copied!

Hi Billur,

many thanks for your information, i've tried again follow your instruction, and it works finally....

so, it should be the excel file problems only....

Thanks

Phyllis

Was this reply helpful? Yes No
BillurSamdancioglu 20,827 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Yes, I thought so because , it happened to me lots of times even in former versions :) Happy that it helped. Please do not forget to verify the answer :)

Was this reply helpful? Yes No