Discount all items in a department?
Is it possible to discount all the items in a department (or other specified
group) in one go?
E.g. I want to discount all our 'media' department by 10%
SO Manager --> Wizards menu --> Inventory Wizard --> Task 110 Change Item
Price --> Press Next --> Choose the Department --> Press Next, this is where
we need to figure out if you are doing a permanent mark down or a sale for a
specific period of time.
For a Permanent Mark Down:
Price change method = Discount from Regular price
Percentage = 10%
Price to be changed = Regular
Sale for a spe...Report Writer Text Spacing Problems While Modifying a PO form
Due to Report Writer static text field size limitations, I am forced to try
to use two adjacent text fields to complete a sentence. I am having an
inordinate amout of problems trying to get words to align in sentences with
the correct amount of character spacing between words that span the text
field boundaries. And, the process of toggling between Report Writer and
Dyamics to get the Purchase Order form to reprint is time consuming. What am
I missing (besides patience)?
1) Setup a calculated field for your static text. Set the result type to
String, and use the Constant...Upgrade companies not showing
Im installing a GP9 instance , I restoe my 7.5 Databses to this instance , I
then run gp9 Utilities.
This checks and tells me dynamics is ok, it then checks for companies but
doesnt find any of the companies I have restored to GP9?
Any ideas or help welcome
Have you restored all of the databases including hte DYNAMICS database?
Be sure to change the ownership of the databases to DYNSA after you have
> Im installing a GP9 instance , I restoe my 7.5 Databses to this instance , I
> then run gp9 Utilities.
> This checks and t...Show a date 30 days out
I have a feild that I would like to show what the date would be in 30 days
for a feild with a date in it [Sold Date].
Sold Date feild would be 1 Jan 07 so the feild would show 30 Days later 31
I did =[Sold date]+30 and it did not work
how about dateadd:
dateadd("d", 30, [Sold Date])
"KAnoe" <KAnoe@discussions.microsoft.com> wrote in message
>I have a feild that I would like to show what the date would be in 30 days
> for a feild with a date in it [Sold Date].
...Dates in fomula showing as whole number
I have a fomula in a cell that takes the name of a person (from cell 2B),
their License number (from another cell 2C)and the Date that License Expires
(From cell 2D). The expire date in "2D" is either the word "none" or a date
that that persons license needs to be renewed.
Those instructors with "None" come out in the calculated field fine, however
the ones with dates come back as whole numbers, Example 8/6/10 shows 40396.
any help will be appreciated
You need to change the format of that cell or column, highlight the cell or
the column, right click o...Safe Pay Check Amount Problem
I am trying to setup Safe Pay. Everything seems to be working fine except
for one annoying quirk. Our bank's Positive Pay data format gives us 12
characters for check amounts ($$$$$$$$$$¢¢). The file that Safe Pay
generates is working perfectly except for those checks that are greater than
$9,999,999.99 (9 characters). If the check amount is greater than that (say
$10,000,000.00), the value that the Safe Pay file shows for that check is
002147483647. And, even if none of the individual checks exceed
$9,999,999.99, if the total of the checks in the batch exceeds that a...How to create an "and" rule in Query Based Distribution Groups
With Exchange 2003 Query Based Distribution groups, is it possible to create
an "and" rule? ie, all users who are based in "London" "and" have the first
Please reply to news group only. Thank you.
"Curtis Fray" <email@example.com> wrote in message
Env: CRM 3, VS 2003, remote connect to CRM server.
I've created a QUOTE in VS2003 and when viewed using PREVIEW from within the
VS environment it produces a beautiful QUOTE (at least in my opinion). When
printed, again from the VS environment, it is perfect. When I upload the RDL
file to the CRM server, create an new REPORT using this RDL then produce a
REPORT, the formatting is all over the place. When I inspect the source (in
VS) there are no fields that extend past the defined size. It appers that the
CRM report engine randomly adds CRLFs all thru the report ... ???
...Delivery Options Does Not Show Up.
I need to setup an alternative recipient to one of my mailboxes but I can't
seem to find the Delivery Options Button under "Exchange Advanced" tab of
I can only see three options:
What am I missing. It should be there.
Thanks for your time
it's on the Exchange General tab...
Susan Conkey [MVP]
"Percy" <Percy@discussions.microsoft.com> wrote in message
>I need to setup an alternative recipient to one of my mailboxes but ...Cannot delete report
I have install the report manager sometime ago, it is working fine.
Until recently we found that when i click the action menu, nothing is come
out. I can't delete or rename the report. But I can add new report.
Do anyone encouter this before?
...Log ON Report Manager
Install Report Manger in the Server CRM Satisfactorily, but I have problems
when I do log on to Crystal APS, I am using an account of domain
administrator and it does not allow me to accesar to the APS.
APS User Name: CCSGR3000\crmadmin
APS password: *********
I need Help,
The problem is with the login. Use the following:
APS User Name: administrator
Password: (should be blank)
APS server: localhost (if it's local)
I did run into a problem that Report Manager couldn't be accessed from
anywhere on the network. It was an IIS configuration problem.
&q...Inserting Excel into Access Reports
Have a great Access application that produces a nice template (headers &
footers) report into which I'd like a spreadsheet inserted before going to
the printer. In the past, I'd just print the Access reports, then reload
them into the inkjet printer and run the Excel spreadsheets as needed. The
heat of the new color laserjet turns the paper grey if it runs through too
often, so it's time to get the reports printing on one pass.
Any suggestions would be welcome. I've of course also got Word XP, MS
Publisher XP, as well as Adobe Acrobat, if anyone thinks it m...Payables Trial Balance Report with Options
I am trying to run an A/P Trial Balance Report today that will give me the
A/P balance at January 31, 2007. I keep getting the balance as as February
28, 2007. I've run the same report for A/R and am able to get the balance as
at January 31, 2007. Currently using GP 9.0. With my previous employer who
was also using GP 9.0, I sure that we were able to run an A/P Trial Balance
report for a previous period. Does anyone have any suggestions as to what I
my be missing or what may be set up incorrectly?
The only date that you can spcify on the Aged Trial Balance With
Options, ...Display Report Header/Footer
Can somebody please give me the telephone number of the smartass MS VP who
came up with the bright idea for the Ribbon so that I can call her and have
her tell me how to display the Report Header & Footer in a report?
Obviously, I must be an idiot because I can't figure out how to do it with
this simplied, intuitive, help-ya out m***** fu***** ribbon.
Oh stupid me, its under 'ARRANGE'. How idiotic of me to think that it'd
under 'DESIGN' since I'm 'designing' a report as opposed to 'arrangeing' a
"microsoft"...Crystal Report not found on File Repository Server
I recently upgraded our MSCRM server to a new server. We don't typically use
the internal CRM reports, we have some custom ones created with PowerTrack
that we primarily use. The CEO tried today though to open one of the canned
MSCRM reports and got this error message. I tried the others and I get it on
all of them.
File frs://Input/a_063/021/000/5439/6ac34043c58b1112.rpt not found on File
I checked the input folder in c:\program files\crystal ent 9\filestore\input
and it is empty. I would have copied them from the old server, but it is ...Enter "1", cell show ".01". Why?
Any number typed into a cell is divided by 100.
If proceded by "=" the number is correct.
What caused this and how can I fix it?
Try this ..
Click Tools > Options > Edit tab
Uncheck "Fixed decimal" > OK
Things should be back to normal now ..
(it's a fixed decimal setting !)
"Yonian" <Yonian@discussions.microsoft.com> wrote in message
> Any number typed into a cell is divided by 100.
> If p...Copy Matrix Items
I am afraid I know the answer to this already but here goes-
I have a prospective shoe store customer who receives as many as 500 pairs
of shoes in a lot. Most of the time 50% or more of these shoes have not
been stocked before and they don't know what the shoes will be until they
get the lot. Because of the nature of shoes they need the ability to
quickly enter in the assorted sizes and colors in a run of Men's, Women's,
Children's etc. While the New Item Wizard for a Matrix Item works well the
customer would like to not have to enter in the size runs each time since
they a...eXtender and Crystal Reports
I've created a Crystal Report to print eOne solutions eXtender fields. They
store inaformation in 4 different tables: EXT00101 (String),
EXT00102(Numbers), EXT00103(Date),EXT00104(Time).. I have created a View
that unions all these tables - and convert them into a Varchar.. Once that
is done, I've created a function called GetExtFieldValue where i pass the
extender window id and field number and it returns the value for that
This report was working fine and all of a sudden it became so slow that now
it takes 7 minutes to get one record. If I delete all the data from EXT...How do I expand Y-axis title so it shows all the words?
the title says it all
Version: Office 2003, Student Edition
...Calculate Subreport totals in a main report Group footer
Apologies if this has been answered before but I can’t find it.
I have a main Report with a Group called “Product_Category” which lists a
number of “Products” in the Detail
I have a Subreport named “product_costs” which has a record for each date
and Text Boxes named “materials” and “fuel” (there are more but I’ll keep it
The Subreport sums all costs and has Text Boxes named “summaterials” and
“sumfuel” in the footer (all with a height of 0.1cm)
The Subreport is embedded in the Detail of the Categories and linked by
In the Detail of the Main Rep..."Can't copy the items. You don't have permission ..."
I use OL 2003, latest service pack,etc. My PST file is about 1.2 GB
and is Unicode-compatible.
Lately Outlook shuts down suddenly without warning, and I have left
checked the box to restart Outlook automatically. This is a big
annoyance. However, in the last 2-3 days, I'm seeing a new kind of
problem. I can't delete or move messages from mail folders.
I get the message that is in the subject line, and the balance of this
... to create an entry in this folder. Right-click the folder and then
click Properties to check your permissions for the folder. See the
folder o...Can I show server name instead of drive letter?
When using the =Cell("filename") function, I would like to show the actual
server instead of a drive letter because the letter is dependent on where the
server is mapped and not all users have the same mapping. Is this possible?
where ServerName is the name of the server and drive is the appropriate
drive, and then find the file on the drive from that point.
> When using the =Cell("filename") function, I would like to show the actual
> server instead of a drive letter because the letter is dependent on...Highlight color for selected items
How can I find out what color is used for highlighting
selected items (for example in Windows Explorer)on a users
Normally it is a blue color, but a user can change that.
"Urban Olars" <firstname.lastname@example.org> wrote in message
> How can I find out what color is used for highlighting
> selected items (for example in Windows Explorer)on a users
> Normally it is a blue color, but a user can change that.
See if it's GetSysColor/COLOR_HIGHLIGHT.
Jeff Partch [VC++ MVP]
Take a ...EDC Reports
Is there a way to gain access to the EDC report(s) in SO Manager without
having to configure it for EDC? I need the accounting department and back
office mangers to be able to look at and print these reports without them
actually having to or needing to do any EDC processing.
You could use the Tender Summary report (Reports | Misc | Tender Summary) to
get credit card totals by type & register.
"Alex" <Alex@no.com> wrote in message
> Is there a way to gain access to the EDC report(s) in SO Manager without
>...Need Help With GP Item Pricing
GP ITEM PRICING
I need to use “Bucket Pricing” for items in GP. For example below is the
pricing schedule that I need to use.
First 20 …………….$ 1.75
Next 280 ……………… 1.36
Next 700 ……………… 1.23
Next 2,000 ……………… 1.09
Over 3,000 ……………… .82
So if I had a Qty. of 350 it would be as follows
20 * 1.75 = 35
280 * 1.36 = 380.80
50 * 1.23 = 61.50
Total : $477.30
In GP I can only set it up to do a “Quantity Range” in the Item Price List
Maintenance window. Problem is if I set it up that way and enter a quantity
of 350 it will default to the $1.23 ...