web
You’re offline. This is a read only version of the page.
close
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 / Microsoft Dynamics GP (Archived) / Sales Line Comment Wor...
Microsoft Dynamics GP (Archived)

Sales Line Comment Work and History Table- Check Links

(0) ShareShare
ReportReport
Posted on by dmacintosh 1,145

Hello Everyone,

I posted a few weeks ago regarding a Sales Line Item Comment being removed randomly and without cause. This is in Microsoft GP 9. Recently, I was skimming through the Check links log and found this:

"A record for Order ORDXXX was removed from the Sales Line Comment Work and History table; no corresponding record was found in the Sales Transaction Amounts History table."

I then get a helpdesk ticket this morning asking why the Sales Line Comment on ORDXXX has been removed.

I am wondering why this occurs and how I can prevent it.

*This post is locked for comments

I have the same question (0)
  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at

    Did the line item for the order get deleted?   Check links will only remove affiliated information if the header or detail record does not exist.    

    Dan Liebl, CMA CPIM | Senior Consultant | OTT, Inc.| DLiebl@OTT-inc.com

  • Verified answer
    soma Profile Picture
    soma 24,410 on at

    If any line of the order deleted or header not matched with line items, Check links will delete the unmatched/unwanted records from the orders.

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    While Soma is correct as to why check links removed the data, the real question is why did the comments become disconnected.

    1.  Do you have any third party products installed?  If so, please tell us which ones.

    2.  Has anyone done any custom programming on your site?

    3.  Has anyone been tinkering in the database?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans