Disappearing vendors in AP_Vendor file

One client has been having a sporadic issue where a vendor is entered into Vendor Maintenance, invoices are processed, and later they are not able to find the vendor in Vendor Maintenance.  The client is not using temporary vendors.  In fact, even if they were using temporary vendors, the last time the problem happened was in the middle of the month.  A new vendor was added on 4/20, and now the vendor is missing.  We checked DFDM...not there.  The vendor master file has NOT been rebuilt; thus, no records should have been removed due to be corrupt, etc.

I opened a case with Sage support, and they were not able to find any evidence of the records being deleted.

In the past when this problem occurs, we have re-entered the vendor into Vendor Maintenance.  Once this has been completed, the open invoices show up on the Invoices tab, etc.

We have not re-entered the vendor for this last instance, but the vendor invoice can be opened in Invoice History Inquiry.

This has been an on-going problem and has happened in versions 2014, 2015, and now in 2016 as well.

Any thoughts would be greatly appreciated.

Parents
  • So this is always with a newly created vendor?

    Are they on the fly vendors?  or were they created first in vendor maintenance?

    In evidence of errors in the error log about the time they were created?

    This is totally a guess,  but have you tried rebuilding key files on the vendor master file (as a preventative - not an after the fact fix).

  • in reply to TomTarget
    Doesn't happened for every new vendor, but it does for some. The problem is very random. I tried duplicating the problem by creating an on-the-fly vendor from Invoice Data Entry (thinking that's probably how they created the vendor), but I was not able to duplicate the error. Client says they do not create vendors on the fly. To be sure, I disabled the feature last week.

    There is absolutely nothing in the activity log, vendor audit file, etc. regarding this issue.

    Have probably rebuilt the vendor master file at some point in the past, but the problem keeps happening.
Reply
  • in reply to TomTarget
    Doesn't happened for every new vendor, but it does for some. The problem is very random. I tried duplicating the problem by creating an on-the-fly vendor from Invoice Data Entry (thinking that's probably how they created the vendor), but I was not able to duplicate the error. Client says they do not create vendors on the fly. To be sure, I disabled the feature last week.

    There is absolutely nothing in the activity log, vendor audit file, etc. regarding this issue.

    Have probably rebuilt the vendor master file at some point in the past, but the problem keeps happening.
Children