Microsoft Dynamics RMS (Archived)

Sell-Thru report! ON HAND QTY and SOLD QTY can be in same report?

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

I've been trying to create a Sell-Thru report and I can't make ON Hand QTY and Sold Qty on same report.

Is there any way for me to add those two columns in a same report?

*This post is locked for comments

All responses (20)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Sell-Thru report! ON HAND QTY and SOLD QTY can be in same report?

Look at the RMS version and the SQL version as both need upgrading to something that can be used for the rest of this century. Reporting changed after SP 2 2.0.1000 which I imagine you are on and likely higher Archelle. SQL 2005 is end of life, Windows XP is end of life and neither is supported or PCI compliant. I imagine that may be why it works for you and fails for them? Perhaps I am mistaken.
Suggested answer

archelle16 1,735 on at

Like (0)

Report

RE: Sell-Thru report! ON HAND QTY and SOLD QTY can be in same report?

Oh yes, it is! :D
Community Member Microsoft Employee on at

Like (0)

Report

RE: Sell-Thru report! ON HAND QTY and SOLD QTY can be in same report?

Thank you so much Archelle! You da best!

Upendra, you will need to delete SelCritetia data so that you will see the result.

<END>

SelCriteria = "(SUBSTRING(Department.Name, 1, 2) IN ( 'OR', 'OB', 'CS', 'CC' ))"

GroupBy = ""

SortOrder = "dbo.Department.Name , Supplier.SupplierName , tblStore.StoreCode , tblheader.PONumber ,tblitem.ItemLookupCode"

End ReportSummary
Community Member Microsoft Employee on at

Like (0)

Report

RE: Sell-Thru report! ON HAND QTY and SOLD QTY can be in same report?

If your using anything in your testing Archelle of this report and options newer than RMS build and version 2.0.0110 (which is feature pack 1) released in 2007. You're likely going to see different results. The coding after feature pack 2, I believe has some impact on how reporting, forms and receipts work or don't work. Just a thought.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Sell-Thru report! ON HAND QTY and SOLD QTY can be in same report?

Hi Archelle,

I tried without filters too, no luck.

Thanks & Regards,

Upendra Nath M.
Suggested answer

archelle16 1,735 on at

Like (0)

Report

RE: Sell-Thru report! ON HAND QTY and SOLD QTY can be in same report?

Hmm.. its working on me.

The report is about to give us the sell thru of approved POs.

Try again without filters.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Sell-Thru report! ON HAND QTY and SOLD QTY can be in same report?

Hi Archelle,

I did this, report comes empty. No results.

We are using RMS 2.0.0110 Version.

Thanks & Regards,

Upendra Nath M.
Suggested answer

archelle16 1,735 on at

Like (0)

Report

RE: Sell-Thru report! ON HAND QTY and SOLD QTY can be in same report?

Omit these series of text:

Begin Column

FieldName = "SubSup.SupplierName"

DrillDownFieldName = ""

DrillDownReportName = ""

StoreIDFieldName = ""

Title = "Sub Supplier"

VBDataType = vbString

Formula = ""

ColHidden = False

ColNotDisplayable = False

FilterDisabled = False

ColWidth = 1400

GroupMethod = groupmethodNone

ColFormat = ""

End Column
Community Member Microsoft Employee on at

Like (0)

Report

RE: Sell-Thru report! ON HAND QTY and SOLD QTY can be in same report?

Hi Archelle,

Thank you for the update. I have changed the Data Type to Datetime and now this comes up.
Community Member Microsoft Employee on at

Like (1)

Report

RE: Sell-Thru report! ON HAND QTY and SOLD QTY can be in same report?

I like your style, I was trying to help you though since you did all that work :)