Out of stock items
When we try to ring in an item that is unavailable RMS shows a screen with 3
The 'Accept Requested' button shows up disabled. Does anyone know how to
enable it? Ours used to be enabled, I do not even know what made it disabled
to be honest...
In Store Operations Manager do the following.
File, Configuration, Options tab, Item Options
Check to see if "Do not allow sale of items when out of stock" is ticked
then the accept requested will be greyed out.
"...how to show another column when hovering on a point in a chart?
Is it possible to show info from another column when you hover on a point in
I have 3 columns, A, B, and C for a scatter plot
I have B and C as x and y coordinates of a point,
and I'd like to have Excel show A when I hover on the point in the little
Showing custom data when hovering over a chart point requires VBA
support -- and even then is reasonably complicated and less than
elegant. For one possible solution see
Hover Chart Label
My spread sheet has several colums using COUNTA. For example:
=COUNTA(A3:A105). Each week I might insert 30 or more rows that I want
included in the count. Is there an expression in the COUNTA formula that I
can use to "float" the formulas to a row just below the last row containing
data so I do not have to modify the ending row number (A105 in this example)
when new rows are inserted?
Assuming your formula will be in A106 to start and you always want to start
with the 3rd row:
"Bob in Granger" wrote:
> My spr...Row, Column measurement?
What are the units? Why aren't they the same? If the row is 20 tall & the
column 20 wide, why don't I have a square cell? How do I get one?
Thanks in advance... Bob
Format,raw height 11.25
Format,column width 1.43
"Bob Newman" wrote:
> Excel 2000.
> What are the units? Why aren't they the same? If the row is 20 tall & the
> column 20 wide, why don't I have a square cell? How do I get one?
> Thanks in advance... Bob
"Sakai" <Sakai@discussions.microsoft.com...Deleting unused pivot table field item names
After deleting pivot table fields items from the data
source, the field item name continues to appear in the
pivot table field drop down even after refreshing the
table. How do I delete pivot table field item names from
the field drop down?
whenever you have questions about pivottable, blindly go over to debra'
site... its the panacea for all pivottable nuisance...
icestationzbra's Profile: http://www.excelforum.com/member.php?action=ge...Committeed items
I have found items committed in the ILC that have no reason to be. They are
not on a work order or layaway. How does that happen, and how can i identify
how many there are in my system?
Committed can be caused either by: Work Order, Layaway or BackOrder. Since
you have checked the 1st two checked the backorder.
Afshin Alikhani - [ firstname.lastname@example.org ]
CEO - Retail Realm
= = = = = = = = = =
"Joel Richman" <email@example.com> wrote in message
>I have found items committed in the ILC ...Column Re-order In SQL2005
I am using SQL Express 2005, which has been working fine (when I connect to
it using Management Studio Express 2005).
I have upgraded the Management Studio to 2008, but I now cannot reorder
colums in my tables. If I connect to the same database using MSE2005, then I
can reorder them.
Has this feature been removed from MSE2008?
How do you re-order them? I tried to drag and dropin table design window the
columns and it worked just fine?
If you do SELECT <columns> does the order matter for you?
"Hiwj" <Hiwj@discussions.microsoft.com> wrote in message
...Resetting the window size & returning to the inbox
I just received Outlook Express at work and I have two
queries. First, how do I change the size of the window to
maximum when I open, forward, reply or send a message? The
window size now is small and I always have to maximize it.
Second, how do I make the system return to my inbox after
opening an email? After reading an email and closing it my
system automatically opens the next email, and I do not
want that. Any help is appreciated!
This newsgroup is for support of Outlook 97-2003 from the Office
family for Windows PCs. For Outlook Express (OE) support try posting in one
these ...Trouble Importing Vendors into Items in a New Database
We are using a Microsoft SQL database import utility and have successfully
imported all items into their respective departsment with the correct tax IDs
ect. We cannot import the supplier choices into each item. What would be the
quickest way to set each item up with their appropriate supplier choice? This
customer has almost 1500 items and he doesn't look forward to enter each item
by hand with its supplier setting.
Hi Big Dave - where you able to import the suppliers into the supplier table
? - items are then linked to suppliers in the supplierlist table on item.id =
supplierlist...Convert list of pairs [a(i),b(i)] to table that shows # of occurrences of each pair
Given something like this:
I'd like to create a table that has three rows (the fruits) and three
columns (the months). At the intersection of each row and column I'd
like the number of occurrences of that particular fruit-month pair.
Thanks for your time.
Assume your data is in the range A1:A14, and you have a
grid starting in cell C1 that looks like:
C D E F
1 jan feb mar
Column 1 contains a product ID and could contain just one entry or several
entries depending upon how many reels of that product ID we have in
inventory. Column 2 has the reel quantity in feet. I need to get a total
quantity in feet for each product ID.
Column 1 Column 2
Prod ID Feet
I need the total product, in this example ABC = 450 ft and XYZ = 100 ft. I
have over 3000 lines and over 600 products I can't do it manually. I think a
pivot table would do it but I'm not sure...
st...Different counts on same query
I need help on finding out how to run three different counts on one query. I
have a table set up to show Date
Within this query I have the following fields:
Date | Method | AgedDays ... taken from TotalInventoryTable
my goal is to say the following in one query.
Date Method CountofAge CountofAge>30
Date Calls ## ##
Date Corr ## ##
All on one query... Is this possible.
Thank you everyone.
Message posted via http://www.accessmonster.c...Counting a count
How do I count a count??
This is what im trying to do:
I have a database with a table named tblMain and has incorporated everything
within that table but contains info from about 8 other tables. I have not
doesigned this database and it appears to have a very poor structure...anyway
There are three fields involved in this process...'Request' (either
'dispensation', 'waiver' or 'dispensation and waiver'), 'Department' (which
consists of 7 other drop down menu options) and 'RequestStatus' which
contains the status of each request by another...flagged items
How do I view all items (e-mails and contacts) which are
flagged on my outlook today page?
...Modifying Calender Item from a window service
I want to modify the Item.Start value of a calender item of a particular
day from a component which is running as a window service...
Is is the particular .eml file to be modified,
Where can i find the file regarding the calender item in exchange server...
thanks in advance for any sort of help
I have a table with four columns and 3000 distinct records.
One of the aforementioned columns is named case_number with many
duplicates in that column.
I created a query to count the number of distinct case_numbers within
the column (something that I do all the time w/ SQL in ORACLE).
Access, however, returns a count of all case_numbers, including
I created this workaround:
SELECT Count(case_number) AS COUNT
FROM [select distinct case_number
FROM table_1]. AS [table_1];
I'm wondering why Access won&...Blank entry in an IF statement returns FALSE. I want it to be blank
When I have no entry in a cell within an IF statement it returns as
"FALSE". I want it to be blank and have no value.
If I use if(ai="","") I still get FALSE unless the entry is done via
the spacebar and then I get a blank cell. How do I get a blank cell
when no entry is made?
You need to give the formula a FALSE option. Assuming that you want the
value in A1 use:
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com wi...Counting Records after filtering by feilds
I am working on a project that will create a report to count the
number of open work orders (records that have their opendate field
with in a date range given), close work orders (records that have
their closeddate field with in the same date range given earlier) and
pending work orders (records that do not have an entry in the closed
date field). I don't know how to (a) prompt the user for a given date
range, im thinking of maybe using a form interface? Is it possible
for me to have a calander button to click to select a date from there?
and (b) To count the what was previously describe...Want ship date to roll down to items
On the sales transaction entry window (transactions>sales>sales transaction
entry) when you change the requested ship date on the quote in the sales date
entry window the requested ship date does not roll down to the line items.
...Counting rows, then counting values.
I have a lot of spreadsheets with many rows and columns of numbers. I need
a way to find the highest value in each row, (mark it some how, bold the
number maybe), then count the number of "highest" values are in each
Is there an easy way to do this?
You can use this to get the value
and this to count
Regards Ron de Bruin
"Michael via OfficeKB.com" <forum@nospam.OfficeKB.com> wrote in message news:152907df2ac24b6ab6ee8d51d46958d9@OfficeKB.com...
I thought Excel used to display the number of pages with data on the bottom
status bar. I that option gone or is it only in Word?
Excel has never, in my memory, given that information on the status bar.
Perhaps you once had some code that gave you a page count.
Gord Dibben MS Excel MVP
On Wed, 11 Jan 2006 15:01:02 -0800, "pkferret"
>I thought Excel used to display the number of pages with data on the bottom
>status bar. I that option gone or is it only in Word?
I know that counting of nodes is not a big deal. But I
need to do something where I cant get any solution. Here
is how my xml looks like.
<?xml version="1.0" encoding="utf-8"?>
<Description>List of XML articles.</Description>
&...Missing Columns in Worksheet 308
I noticed that there are only 2 columns in worksheet 308, Items and
Description. Shouldn't there be at least 4 columns?
You need to update SnapshotReorderPoint and SnapshotRestockLevel in
ItemDynamic table for each selected item. Those fields are then sent to
desired stores by 308 worksheet.
"DanielSie" <firstname.lastname@example.org> wrote in message
>I noticed that there are only 2 columns in worksheet 308, Items and
> Description. Shouldn't there be at least 4 columns?
Thanks, ...Matching Multiple Columns Of Data, Some Colums Uneven
alrighty, i need basically match up three columns of data, but one o
them is uneven with the other two. Two of the columns contain "stoc
numbers" and the third is thier description. Column B has the stoc
numbers and column C has their descriptions in matching order - but
need these matched to the stock numbers in column A. There are actuall
more stock number in column A, so after the match is run there should b
no description or stock number next to some of the stock numbers i
column A. Because of the sheer size of this file I have shortened i
for an example - so if anyone could ex...item discription on reciept
on some of the items we carry we have long item discription which
the printer cuts when it generates the reciept for example if we have item
long pajamas blue color
it only shows
long pajamas b
and cuts the rest
does anybody know hoe i can change my XML reciept to maybe print discription
into two lines instead of just one so i can get the whole description