Urgent – Mass update de-linked bills and payments
I ran a mass update on Friday to update a custom ‘Created By’ field with the existing value for audit purposes. However, I was told today by finance that the action has somehow de-linked all the existing bills with their payment records. I have raised this with support but they are saying that it happened due to the update but the mass update only had 2-3 fields available to update and none of them could have done this.
Can anybody please advise in this situation? I have declared business down to netsuite but they are still refusing to help
I feel like this question needs a bit more information. However, as a first step, you could check one of the affected records’ “system notes” and see what fields were updated on the date you ran your mass update.
My question is why would you need Created by custom field for audit – just use a systemnotes search with your criteria for audit.
Try looking at my Suiteworld presentation for Audit – it has quite few similar transaction audit search templates
https://static.rainfocus.com/oracle/sw19/sess/1546631310573001gv1X/PDFPF%20/FIN1526SES_THURS_1553185241855001B1fO.pdf
Vishal,
Before accepting someone else’s point of view about what happened i.e. ‘de-linked all the existing bills’ you need to assess several records that changed due to the mass update, and establish exactly what changed with those records and when.
Then, from what you discover, investigate if it is possible for a de-linking to occur. If it is not, and you are clear, then investigate records that were de-linked and see if there is any correlation e.g., dates/times, or was it something else.
System notes is your friend.
