Export data showing incorrect

Community Alums
Not applicable

Hi Team,

 

I am exporting Bulk records data from "u_cmdb_ci_edms_access".

 

But after exporting in Excel it showed the wrong data for the "ongoing cost" field and its reference field.

 

"ongoing cost" field values show previous values instead of current values

 

Below screenshot ongoing cost current values in instances 

SivanandaReddy_0-1713417873156.png

Below screenshot show wrong values in Excel

SivanandaReddy_1-1713417977537.png

Can you please help me, Why in some records getting pervious  values for  "ongoing cost".

 

Thank you

Siva

3 REPLIES 3

Community Alums
Not applicable

Hi @Dr Atul G- LNG 

 

Can you please me with this issue

 

Thank you,

Siva

Hi @Community Alums 

 

Looks very wired , the cost should come same as in instance. It may be due to currency conversion but not exactly.

 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0788372

 

did you try to download data in PDI and check. Also are you referring to right columns in excel sheet.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Sohail Khilji
Kilo Patron
Kilo Patron

Hi @Community Alums ,

 

This may be because of some business rule or query business rule. you will need to disable it while exporting or you need to manually update the value in excel. I hope this helps...

 

check if there are any  query business rule on that field. that must be causing the issues.

 


☑️ Please mark responses as HELPFUL or ACCEPT SOLUTION to assist future users in finding the right solution....

LinkedIn - Lets Connect