Item Added Using Check Links

(0) Share

Report

Posted on by Community Member

We have a few items that have been added due to check links. How do I determine what purpose they serve and are they OK to delete?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

This is the normal behavior of Check links. Don't get anything deleted, they have been created for a purpose and you can track it back by looking at the inventory transaction versus item cards.

Allow me to shed a light on the check links process in Dynamics GP which is different than the reconciliation, its main purpose is to check data integrity. For that, transactional and master records are matched according to a predefined logic. In your case, there must have been a transaction for an item number (AA) for instance, when the check links checked the item master for such item, it was not there. The normal behavior of check links is to create an item with this code and leave a trace in the description field (Added during check links )

Now what is the main reason behind having a transaction for an item that doesn't initially exist ? well, in few words, there are various reasons such as: back end integration, back end deletion ...etc.

In this essence, you can manually check this item (which is added during check links) versus the item transactions, there must have been a lack of integrity and that is why Check links got things back on track again.

Let us know if you have any further concerns,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I don't see where these items have been used when I look under inquiry Item Transaction. Is there somewhere else I should be looking?

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

Go to Smart list and check the Inventory Purchase Receipt.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

No luck there either. I also checked the Inventory Transactions Smart list.

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report
Okay then, here comes my favorite part. There is a stored procedure which searches all database for any specific value. All you need to do is to run the script provided on spSearchOnAllDB: SQL Stored Procedure to Search an Entire Database

Then, run the below query

exec spSearchOnAllDB 'ItemNumber%'

You may post the result here,

Was this reply helpful? Yes No
Thomas Newcomb 1,810 on at

Like (0)

Report

Hi Katie!

I am just following up to see if this issue is still active or has it been resolved.

Please let us know!

~Thomas Newcomb

------------------------

Dynamics GP Support

------------------------

This posting is provided "AS IS" with no warranties, and confers no rights

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Sorry this issue is resolved.

Thanks!

Was this reply helpful? Yes No