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

Beginner Asked on January 17, 2022 in Accounting.
Add Comment
3 Answer(s)

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.

Rookie Answered on January 18, 2022.
Add Comment

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 

Advanced Answered on January 18, 2022.
Add Comment

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.

Rookie Answered on January 24, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor