1. Home
  2. Point-Of-Sale Software
  3. Items>Quantity Report field questions

Items>Quantity Report field questions

I need to know how I can insert numbers in one of the filelds that will show in a Reports>Items>Quantity list report. I upload this report to my online store provider and need a way to include a number that will result in items NOT showing on my website. I need a field that will usually be a zero, but where I can change the number to a high positive to keep the item from showing on the site. (This is a situation where this number acts as a threshhold and is compared with the on hand number to let items show or not show on the site)

The problem I'm having is that I can't seem to figure out where the fields that are optional in the report are coming from. The fields that seem useable AND filter are Hi Bound, Low Bound, ReOrder Point, Restock Level, Committed, and Quantity to Order. What I need is to be able to select an item and change what is normally a zero in that field to a number like 100. I don't use the Purchase Order functions of RMS, so I don't think I'd be interfering with anything by using it this way. I want tp produce a report that will list all active items and produce a zero for all items (in some field) except will show a number like 100 (in that same field) for the ones I change manually.

I'd be happy to explain further as this is sounding pretty rambling, I know.

Reply to
PRJ
Loading thread data ...

Browse to your reports directory - by default it is : C:\Program Files\Microsoft Retail Management System\Store Operations\Reports

Copy the file "Items - Item Quantity List.qrp" Rename the new file some thing like "Custom - Web Item List.qrp" Right click the new file and select properties. Un-check the "Real Only" box and click OK. Open the new file in your favorite text editor (or Notepad)

Find the following column definition ( Search for the string "webitem")

Begin Column FieldName = "Item.WebItem" DrillDownFieldName = "" DrillDownReportName = "" Title = "Web Item" VBDataType = vbBoolean Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 1000 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column

Make the following changes: FieldName = "" VBDataType = vbLong Formula = "CASE WHEN Item.WebItem = 0 THEN 100 ELSE 0 END"

Save the file Reopen SO Manager and the new report will be available under Reports/Custom

open Item Properties for the items that you want to make available on the web. Go to the Special Tab and mark the "Show on Web" check Box.

Where this box is marked, the Item.WebItem field will be set to 1. The report will give these items a value of 0 and all others a value of 100.

Glenn Adams Tiber Creek C> I need to know how I can insert numbers in one of the filelds that will

Reply to
Glenn Adams [MVP - Retail Mgmt

OK. i'm not the most savvy guy on the block, but I think I did as your instructions said.

Issues:

  1. The .qrp file would not copy within the reports folder, so I copied it to the desktop, made the changes, re-named it and put it in the reports folder.

  1. I had not had SO Mgr closed (didn't see that comment until the end. I closed it and opened it again. Went to Reports and the "custom" item is greyed out. Could not find the new report anywhere.

  2. FYI- In my items>properties window, the 'special' tab does NOT have a box for "Show on Web". The Options tab has one called "item is available on website", which I had checked for certain items, some time ago, when I was going to use a webstore that uploaded items directly from RMS.

Any thoughts?

Reply to
PRJ

Not sure why you couldn't copy within the folder; Windows usually just appends "Copy of" to the file name so that it doesn't conflict. As long as the edited file ended up in the reports folder it shouldn't matter how it got there.

The file name itself is extremely important. It must begin with: "Custom - ". The spaces before and after the "-" are important. If this convention is not followed, the report will not appear in the custom menu.

Regarding the Item Properties, the check box you found was the one I was referring to. My memory isn't what it used to be :)

Glenn Adams Tiber Creek C> OK. i'm not the most savvy guy on the block, but I think I did as your

Reply to
Glenn Adams [MVP - Retail Mgmt

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.