Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Deleting a record from...
Finance | Project Operations, Human Resources, ...
Suggested answer

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

(0) ShareShare
ReportReport
Posted on by Bob Harrison 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:
Microsoft Dynamics GP
  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,054 Super User 2024 Season 1 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,959 Most Valuable Professional 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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,904 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans