News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) Generate report that p...

Microsoft Dynamics RMS (Archived)

Generate report that provides list of newly created ILCs based on Date Ctreated field in RMS Store Operations

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Greetings -

I would like to let our customers know of all the new items we have in our store.

So, I would like a report that lists the ILCs created after a specified date (date Created).

Any help would be greatly appreciated.

Thanks in advance.

David Schueckler

The TreeHouse Toy Store

the_treehouse793@msn.com

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

Re: Generate report that provides list of newly created ILCs based on Date Ctreated field in RMS Store Operations

memorize a copy of one of the Item reports, like Item Quantity, then edit in notepad.
File location is C:\Program Files\Microsoft Retail Management System\Store Operations\Reports
Add the following column to the end of the report:

Begin Column
   FieldName = "Item.DateCreated"
   DrillDownFieldName = ""
   DrillDownReportName = ""
   StoreIDFieldName = ""
   Title = "Date Created"
   VBDataType = vbDate
   Formula = ""
   ColHidden = False
   ColNotDisplayable = False
   FilterDisabled = False
   ColWidth = 900
   GroupMethod = groupmethodNone
   ColFormat = ""
End Column

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,431 Super User 2024 Season 2

#2

Martin Dráb 230,503 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans