Skip to main content

Notifications

Microsoft Dynamics RMS forum

Purchasing Reports for RMS POS

Posted on by 45

Hello I work for a small business. We use RMS for our registers and inventory.

There are several reports my boss would like but I dont know enough to make them and our RMS partners were over charging.

Many of the reports we need I'm sure are very generic and would not even need to be custom made.

Where are some sources I could buy premade packs of reports and/or pay a reasonable fee to have a report made.

These are simple reports such as including the day of the week in the existing daily sales by department report.

Any information I can jump from is greatly appreciated. Thank you

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Purchasing Reports for RMS POS

    and This one gives you monthly sales

    //--- Report Summary --- //

    Begin ReportSummary

      ReportType = reporttypeSales

      ReportTitle = "Detailed Sales Report"

      PageOrientation = pageorientationLandscape

      WordWrap = False

      ShowDateTimePicker = False

      OutLineMode = True

      Groups = 1

      GroupDescription = ""

      DisplayLogo = True

      LogoFileName = "MyLogo.bmp"

      ProcedureCall = ""

      PreQuery1 = ""

      PreQuery2 = ""

      TablesQueried = <BEGIN>

         FROM        TransactionEntry

         INNER JOIN  [Transaction] WITH(NOLOCK)

                     ON TransactionEntry.TransactionNumber = [Transaction].TransactionNumber AND TransactionEntry.StoreID = [Transaction].StoreID

         INNER JOIN  Batch WITH(NOLOCK)

                     ON [Transaction].BatchNumber = Batch.BatchNumber AND [Transaction].StoreID = Batch.StoreID

         LEFT JOIN   Item WITH(NOLOCK)

                     ON TransactionEntry.ItemID = Item.ID

         LEFT JOIN   Department WITH(NOLOCK)

                     ON Item.DepartmentID = Department.ID

         LEFT JOIN   Category WITH(NOLOCK)

                     ON Item.CategoryID = Category.ID

         LEFT JOIN   Supplier WITH(NOLOCK)

                     ON Item.SupplierID = Supplier.ID

         LEFT JOIN   ReasonCode AS ReasonCodeDiscount WITH(NOLOCK)

                     ON TransactionEntry.DiscountReasonCodeID = ReasonCodeDiscount.ID

         LEFT JOIN   ReasonCode AS ReasonCodeTaxChange WITH(NOLOCK)

                     ON TransactionEntry.TaxChangeReasonCodeID = ReasonCodeTaxChange.ID

         LEFT JOIN   ReasonCode AS ReasonCodeReturn WITH(NOLOCK)

                     ON TransactionEntry.ReturnReasonCodeID = ReasonCodeReturn.ID

         LEFT JOIN   Store ON [Transaction].StoreID = Store.ID

    <END>

      SelCriteria = ""

      GroupBy = ""

      SortOrder = ""

    End ReportSummary

    //--- Title Rows ---//

    Begin TitleRow

      Text = "<Store Name>"

      Font = "Arial"

      FontBold = True

      FontSize = 16

      Color = "Blue"

    End TitleRow

    Begin TitleRow

      Text = "<Report Title>"

      Font = "Arial"

      FontBold = True

      FontSize = 12

      Color = "Black"

    End TitleRow

    Begin TitleRow

      Text = "Generated On <Report Date>"

      Font = "Arial"

      FontBold = True

      FontSize = 10

      Color = "Black"

    End TitleRow

    //--- Filters ---//

    //--- Columns ---//

    Begin Column

      FieldName = "[Transaction].Time"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Monthly Sold"

      VBDataType = vbDate

      Formula = "CONVERT(VARCHAR(7),[Transaction].Time, 120)"

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 2000

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Store.ID"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Store ID"

      VBDataType = vbLong

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 870

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Store.Name"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Store Name"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 870

      GroupMethod = groupmethodMax

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Store.StoreCode"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Store Code"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1095

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Store.Region"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Store Region"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1335

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Store.City"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Store City"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1020

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Store.State"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Store State"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1155

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Store.Zip"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Store Zip"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 945

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Store.Country"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Store Country"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1560

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Department.Name"

      DrillDownFieldName = "Department.Name"

      DrillDownReportName = ""

      Title = "Department"

      VBDataType = vbString

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 2205

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignLeftCenter

    End Column

    Begin Column

      FieldName = "Category.Name"

      DrillDownFieldName = "Category.Name"

      DrillDownReportName = ""

      Title = "Category"

      VBDataType = vbString

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1515

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignLeftCenter

    End Column

    Begin Column

      FieldName = "Supplier.SupplierName"

      DrillDownFieldName = "Supplier.SupplierName"

      DrillDownReportName = ""

      Title = "Supplier"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 825

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignLeftCenter

    End Column

    Begin Column

      FieldName = "Item.ItemLookupCode"

      DrillDownFieldName = "Item.ItemLookupCode"

      DrillDownReportName = ""

      Title = "Item"

      VBDataType = vbString

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1380

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignLeftCenter

    End Column

    Begin Column

      FieldName = "Item.BinLocation"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Bin Location"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1140

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignLeftCenter

    End Column

    Begin Column

      FieldName = "Item.Description"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Description"

      VBDataType = vbString

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 2115

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignLeftCenter

    End Column

    Begin Column

      FieldName = "Item.Quantity"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "On Hand"

      VBDataType = vbDouble

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 810

      GroupMethod = groupmethodNone

      ColFormat = "#.#"

    End Column

    Begin Column

      FieldName = "Item.Price"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Price"

      VBDataType = vbCurrency

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 555

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Item.PriceA"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Price A"

      VBDataType = vbCurrency

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 720

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Item.PriceB"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "PriceB"

      VBDataType = vbCurrency

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 660

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Item.PriceC"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Price C"

      VBDataType = vbCurrency

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 720

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Item.SalePrice"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Sale Price"

      VBDataType = vbCurrency

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 945

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Item.SaleStartDate"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Sale Starts"

      VBDataType = vbDate

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1020

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Item.SaleEndDate"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Sale Ends"

      VBDataType = vbDate

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 930

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Item.MSRP"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "MSRP"

      VBDataType = vbCurrency

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 945

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Item.LastSold"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Last Sold"

      VBDataType = vbDate

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 900

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "TransactionEntry.Quantity"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Qty Sold"

      VBDataType = vbDouble

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1300

      GroupMethod = groupmethodSum

      ColFormat = "#.##"

    End Column

    Begin Column

      FieldName = "TransactionEntry.Price"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Sold Price"

      VBDataType = vbCurrency

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1250

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Total"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      Title = "Total Sales"

      VBDataType = vbCurrency

      Formula = "TransactionEntry.Price * TransactionEntry.Quantity"

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1600

      GroupMethod = groupmethodSum

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "[Transaction].TransactionNumber"

      DrillDownFieldName = "[Transaction].TransactionNumber"

      DrillDownReportName = ""

      Title = "Transaction"

      VBDataType = vbLong

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1245

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "ReasonCodeTaxChange.Description"

      DrillDownFieldName = "Reasoncode.Description"

      DrillDownReportName = ""

      Title = "Tax Change Reason Code"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 2280

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignLeftCenter

    End Column

    Begin Column

      FieldName = "ReasonCodeReturn.Description"

      DrillDownFieldName = "Reasoncode.Description"

      DrillDownReportName = ""

      Title = "Return Reason Code"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 2280

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignLeftCenter

    End Column

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Purchasing Reports for RMS POS

    This is a report that gives you daily sales

    //--- Report Summary --- //

    Begin ReportSummary

      ReportType = reporttypeSales

      ReportTitle = "Detailed Sales DAY BY DAY"

      PageOrientation = pageorientationLandscape

      WordWrap = False

      ShowDateTimePicker = False

      OutLineMode = True

      Groups = 2

      GroupDescription = ""

      DisplayLogo = True

      LogoFileName = "MyLogo.bmp"

      ProcedureCall = ""

      PreQuery1 = ""

      PreQuery2 = ""

      TablesQueried = <BEGIN>

         FROM        TransactionEntry

         INNER JOIN  [Transaction] WITH(NOLOCK)

                     ON TransactionEntry.TransactionNumber = [Transaction].TransactionNumber AND TransactionEntry.StoreID = [Transaction].StoreID

         INNER JOIN  Batch WITH(NOLOCK)

                     ON [Transaction].BatchNumber = Batch.BatchNumber AND [Transaction].StoreID = Batch.StoreID

         LEFT JOIN   Item WITH(NOLOCK)

                     ON TransactionEntry.ItemID = Item.ID

         LEFT JOIN   Department WITH(NOLOCK)

                     ON Item.DepartmentID = Department.ID

         LEFT JOIN   Category WITH(NOLOCK)

                     ON Item.CategoryID = Category.ID

         LEFT JOIN   Supplier WITH(NOLOCK)

                     ON Item.SupplierID = Supplier.ID

         LEFT JOIN   ReasonCode AS ReasonCodeDiscount WITH(NOLOCK)

                     ON TransactionEntry.DiscountReasonCodeID = ReasonCodeDiscount.ID

         LEFT JOIN   ReasonCode AS ReasonCodeTaxChange WITH(NOLOCK)

                     ON TransactionEntry.TaxChangeReasonCodeID = ReasonCodeTaxChange.ID

         LEFT JOIN   ReasonCode AS ReasonCodeReturn WITH(NOLOCK)

                     ON TransactionEntry.ReturnReasonCodeID = ReasonCodeReturn.ID

         LEFT JOIN   Store ON [Transaction].StoreID = Store.ID

    <END>

      SelCriteria = ""

      GroupBy = ""

      SortOrder = ""

    End ReportSummary

    //--- Title Rows ---//

    Begin TitleRow

      Text = "<Store Name>"

      Font = "Arial"

      FontBold = True

      FontSize = 16

      Color = "Blue"

    End TitleRow

    Begin TitleRow

      Text = "<Report Title>"

      Font = "Arial"

      FontBold = True

      FontSize = 12

      Color = "Black"

    End TitleRow

    Begin TitleRow

      Text = "Generated On <Report Date>"

      Font = "Arial"

      FontBold = True

      FontSize = 10

      Color = "Black"

    End TitleRow

    Begin TitleRow

      Text = "Designed and/or modified by Microsoft Corp. and/or Check Point Software"

      Font = "Arial"

      FontBold = False

      FontSize = 8

      Color = "Black"

    End TitleRow

    //--- Filters ---//

    //--- Columns ---//

    Begin Column

      FieldName = "TransactionTime"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Date Sold"

      VBDataType = vbDate

      Formula = "CONVERT(datetime, CONVERT(nvarchar, [Transaction].Time, 101), 101)"

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 2070

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Store.Name"

      DrillDownFieldName = "Store.Name"

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Store Name"

      VBDataType = vbString

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 2430

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignCenterCenter

    End Column

    Begin Column

      FieldName = "Item.ItemLookupCode"

      DrillDownFieldName = "Item.ItemLookupCode"

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "ILC"

      VBDataType = vbString

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1200

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignLeftCenter

    End Column

    Begin Column

      FieldName = "Item.Description"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Item Description"

      VBDataType = vbString

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 2490

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignLeftCenter

    End Column

    Begin Column

      FieldName = "TransactionEntry.Quantity"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Qty Sold"

      VBDataType = vbDouble

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 810

      GroupMethod = groupmethodSum

      ColFormat = "###"

    End Column

    Begin Column

      FieldName = "TransactionEntry.Price"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Sold Price"

      VBDataType = vbCurrency

      Formula = ""

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1245

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Total"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Total Sales"

      VBDataType = vbCurrency

      Formula = "TransactionEntry.Price * TransactionEntry.Quantity"

      ColHidden = False

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1605

      GroupMethod = groupmethodSum

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Department.Name"

      DrillDownFieldName = "Department.Name"

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Department"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 2205

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignLeftCenter

    End Column

    Begin Column

      FieldName = "Category.Name"

      DrillDownFieldName = "Category.Name"

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Category"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1515

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignLeftCenter

    End Column

    Begin Column

      FieldName = "Store.ID"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Store ID"

      VBDataType = vbLong

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 870

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignCenterCenter

    End Column

    Begin Column

      FieldName = "Store.StoreCode"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Store Code"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1095

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignCenterCenter

    End Column

    Begin Column

      FieldName = "Store.Region"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Store Region"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1335

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignCenterCenter

    End Column

    Begin Column

      FieldName = "Store.City"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Store City"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 2490

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignCenterCenter

    End Column

    Begin Column

      FieldName = "Store.State"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Store State"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1155

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignCenterCenter

    End Column

    Begin Column

      FieldName = "Store.Zip"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Store Zip"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 945

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignCenterCenter

    End Column

    Begin Column

      FieldName = "Store.Country"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Store Country"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1560

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignCenterCenter

    End Column

    Begin Column

      FieldName = "Supplier.SupplierName"

      DrillDownFieldName = "Supplier.SupplierName"

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Supplier"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 2490

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignLeftCenter

    End Column

    Begin Column

      FieldName = "Item.BinLocation"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Bin Location"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1140

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignLeftCenter

    End Column

    Begin Column

      FieldName = "Item.Quantity"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "On Hand"

      VBDataType = vbDouble

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 810

      GroupMethod = groupmethodNone

      ColFormat = "####"

    End Column

    Begin Column

      FieldName = "Item.Price"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Price"

      VBDataType = vbCurrency

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 900

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Item.PriceA"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Price A"

      VBDataType = vbCurrency

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 900

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Item.PriceB"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "PriceB"

      VBDataType = vbCurrency

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 900

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Item.PriceC"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Price C"

      VBDataType = vbCurrency

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 900

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Item.SalePrice"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Sale Price"

      VBDataType = vbCurrency

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1110

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Item.SaleStartDate"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Sale Starts"

      VBDataType = vbDate

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1110

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Item.SaleEndDate"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Sale Ends"

      VBDataType = vbDate

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1110

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Item.MSRP"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "MSRP"

      VBDataType = vbCurrency

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 990

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "Item.LastSold"

      DrillDownFieldName = ""

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Last Sold"

      VBDataType = vbDate

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 1110

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "[Transaction].TransactionNumber"

      DrillDownFieldName = "[Transaction].TransactionNumber"

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Trans #"

      VBDataType = vbLong

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 810

      GroupMethod = groupmethodNone

      ColFormat = ""

    End Column

    Begin Column

      FieldName = "ReasonCodeTaxChange.Description"

      DrillDownFieldName = "Reasoncode.Description"

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Tax Change Reason Code"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 2280

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignLeftCenter

    End Column

    Begin Column

      FieldName = "ReasonCodeReturn.Description"

      DrillDownFieldName = "Reasoncode.Description"

      DrillDownReportName = ""

      StoreIDFieldName = ""

      Title = "Return Reason Code"

      VBDataType = vbString

      Formula = ""

      ColHidden = True

      ColNotDisplayable = False

      FilterDisabled = False

      ColWidth = 2280

      GroupMethod = groupmethodNone

      ColFormat = ""

      ColAlignment = flexAlignLeftCenter

    End Column

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

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

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,782 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,067 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,150

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans