Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

Print Item Comments in Sales Reports

Posted on by 325

Is there any method for printing item comments on the sales reports. If a comment has been entered for an item at the POS, I want to be able to see the comment in the sales reports in addition to the normal item description.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Print Item Comments in Sales Reports

    Hello,

    I just tried this suggestion but the report only displays blanks.  I know that some transaction have comments because when I drill down into a transaction and print the sales receipt, the comment appears between the Item # and Amount on the second page.

    For what it's worth, I am on version 2.0.0155 of HQ Manager.

    Any thoughts?  Thanks in advance.

  • Jenee Profile Picture
    Jenee 325 on at
    RE: Print Item Comments in Sales Reports

    Thanks Antonijo. Once again, your answer is spot on and very helpful.

  • Verified answer
    Antonijo Todorovik Profile Picture
    Antonijo Todorovik 4,025 on at
    RE: Print Item Comments in Sales Reports

    Hi Jenee.

    Just do this next:

    1º) make a copy of the "Sales - Detailed Sales Report"

    2º) Change the name of the copied file by adding "Custom - Jenee - " in the begining of the name of the file

    3º) Edit the copied file and add a new column at the end of the file :

    Begin Column

      FieldName = "TransactionEntry.Comment"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Comment"

      VBDataType = vbString

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 2000

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    4º) restart the HQ / Manager

    If you did everything fine, in the reports menu, in the Personalized reports You should be able to see this new personalized report, with a new column of Item comment at the moment of sale...

    Kind regards, A.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,297 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans