I'm looking for a report that would show all of the layaways closed in a certain period of time. Anyone know if there is such a report out there or a way I can get this data using an ODBC connection?
Layaway Report
Dec 20, 2007
1 Replies
Hi Krista - the last updated column (field) in the order table will reference the day that the layaway is closed, so you could in theory track it via the last updated date field - you'll need to edit the layaway summary report
- find the report in the reports directory (C:\Program Files\Microsoft Retail Management System\Store Operations\Reports)
- right click Layaway Summary report and select properties
- uncheck "read only" click OK
- right click the report again and select open - use NOTEPAD to open the report
- at the bottom of the report, paste the following verbiage Begin Column FieldName = "[Order].Lastupdated" DrillDownFieldName = "" DrillDownReportName = "" Title = "Last Updated" VBDataType = vbDate Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 825 GroupMethod = groupmethodNone ColFormat = "ddddd" ColAlignment = flexAlignRightCenter End Column
- Save the report; open SO manager and run the report (reports - layaway - layaway summary
- filter the report for status = closed AND lastupdated = your date range
The report should show you closed layaways, last updated should be the date the layaway was closed - hope this helps......
"Krista" wrote:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required