Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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 809
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,058 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 809 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,965 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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,309 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