Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by Bob Harrison

823

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

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

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..

Was this reply helpful? Yes No
Bob Harrison 823 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

David Musgrave MVP ... 14,065 Most Valuable Professional on at

Like (1)

Report

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.

https://winthropdc.wordpress.com/2010/05/19/recurring-transactions-and-record-notes/

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

Was this reply helpful? Yes No

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Mansi Soni – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Mansi Soni – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates