Export data showing incorrect

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-17-2024 10:40 PM
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
Below screenshot show wrong values in Excel
Can you please help me, Why in some records getting pervious values for "ongoing cost".
Thank you
Siva

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-17-2024 11:46 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2024 04:42 AM
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]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2024 01:14 AM - edited 04-18-2024 01:15 AM
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....