Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Deleting a record from a batch deletes all scans attached to previous invoices.

Posted on by 807
We have a recurring AP batch with transactions in it. When we update the transactions each month, we scan in supporting documentation. We rename the scans since all of the scans show together on the scan screen. 
When we view transaction by vendor it also ahows all of the scans. Today I deleted the unposted transaction from the batch. It deleted all of the scanned documents. So when I look at transaction by vendor there is no scanned documents attached to the posted invoices.
Why would it delete scans of documents that were already posted? How are we supposed to be using the scan feature if they get deleted when you delete an unposted invoice?
Very frustrating! 
 
Categories:
  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,019 Moderator on at
    Deleting a record from a batch deletes all scans attached to previous invoices.
    Hi Bob,
    The only options that's likely going to help your recover your attachements will be to restore under a different name the DYNAMICS & Company DB prior to the moment the attachments were removed.. locate them in the tables and try to copy the data back.. 
    Tools like Data Compare from APEX could help make this easier.. 
  • Bob Harrison Profile Picture
    Bob Harrison 807 on at
    Deleting a record from a batch deletes all scans attached to previous invoices.
    Thanks David,
     
    If I understand you correctly, if the trigger was not in place, then those scans are gone. Is that correct? If that is true, that is terrible programming. There was no warning.
     
    Fortunately, this happened on information that when can get in a different way. Do you know of anyway to recover this information?
     
     
  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,799 Moderator on at
    Deleting a record from a batch deletes all scans attached to previous invoices.
    Hi there
     
    This sounds very much like the situation covered in this blog post. The fix can be created with GP Power Tools which replaced the Support Debugging Tool mentioned in the article.
     
     
    The issue is that the notes/attachments are all sharing the same index value, so removing the original transaction will remove the notes from all posted transactions as well.
     
    Kind regards
     
    David

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,326 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,166 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans