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

All responses (7)

Answers (0)

Community Member on at

Like (0)

Report

RE: Item Added Using Check Links

Sorry this issue is resolved.

Thanks!
Thomas Newcomb 1,810 on at

Like (0)

Report

RE: Item Added Using Check Links

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
Mahmoud Saadi 32,738 on at

Like (0)

Report
RE: Item Added Using Check Links

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,
Community Member on at

Like (0)

Report

RE: Item Added Using Check Links

No luck there either. I also checked the Inventory Transactions Smart list.
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Item Added Using Check Links

Go to Smart list and check the Inventory Purchase Receipt.
Community Member on at

Like (0)

Report

RE: Item Added Using Check Links

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?
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Item Added Using Check Links

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,