News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) Purchasing Reports for...

Microsoft Dynamics RMS (Archived)

Purchasing Reports for RMS POS

(0) Share

Report

Report

Posted on by K J

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

All responses Img

All responses (2)

Answers Img

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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

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