Constraints and Conditions for Capacity Reporting
I have a table of information to where I want to sort based on some conditions and constraints. I want to sort by Earliest Due Date but I have constraints to where I can only have one part number run on a given day and I have only a daily capacity of 100 hours. I want the table of information sorted quickly based on those conditions to where it sorts the information based on Earliest Due Date in blocks of 100 hours and the part numbers only show up once per 100 hour block. If a part number has two work orders with early due dates, I want it only to keep the one with the earliest date and th...New Sales Territory
Hi Everyone -
I'm looking for suggestions regarding sales territories. In our
company, a sales representative may be assigned multiple sales
territories. To my understanding, MS CRM Territories are not able to
handle this type of relationship. So my thought was to create a new
entity - [company name] Sales Territory, then apply many to one
relationship with Users. Many [company name] Sales Territory: One CRM
USER. Unfortunately, this is not possible. Any thoughts or suggestions
would be greatly appreciated.
...Sales Tax Tracking?
What is the best/easiest way to track sales tax in Money 2005?
Categorize your transactions with splits that include a Taxes:Sales Tax or
similar element. This is just one example of something that downloaded data
CANNOT do by itself.
"Laurie" <Laurie@discussions.microsoft.com> wrote in message
> What is the best/easiest way to track sales tax in Money 2005?
Don't you find it tedious to track sales tax? I would only see value in
tracking it for a business, but Money will do that automatially there.
Gr...Installation Fails on Reporting services
I am installing CRM 3.0. During the install process when I get to the MSCRM
Environment Diagnostic Review I get the follwoing error message:
"Specified SQL Server Reporting Services Server website
http://severname:8081/reportserver is not running."
Reporting services is however running and if I plug this URL into a browesr
it will bring up the reportserver. The Reports Manager is running and
accessible as well. They are on port 8081 and this does not conflict with
any other website.
I am installing on Windows Server 2003 Enterprise with SP2 and using SQL
2005 SP2 (with t...Exporting Reports to Text
I'm trying to export the detailed historical aged trial balance in Payables
to a comma-delimited file for use in Excel. Unfortunately, the numbers are
shifting to the left.
Does anybody have a solution to this?
I think I remember something like this once before. Don't recall the
have you midified the report?
Are the fields all sized the same?
You may have to put in a dummy text field to overcome alignment errors.
"Charles Allen" <firstname.lastname@example.org> wrote in message
> ...Adding various logos to Sales Statement
We are currently running GP 8.0. There are currently 44 different companies
each on its own database. EAch is a different managed property
Each one wants its own logo on the sales statement. I am only a little
familar with Report Writer, but when I have gone in to change or modify a
report it has not been company specific.
The logo can be as simple as the company name in a nicer font style. But,
some will prefer a picture logo.
This statement is needed to mail out monthly and going in changing each
picture would be time consuming.
What is the best way to create a different sta...Crystal Reports Problem 04-16-04
Everytime we attempt to run a report in MSCRM we are received an "Invalid
job number. File ." error. The system was running fine, and just
spontaneously began doing this. There were no changes to the server that
should have impacted CRM at all. Any ideas would be great.
This is a multi-part message in MIME format.
Yes. Rebooted the server (several times), and the domain controllers =
just to be sure.
&q...Sales line totals not adding up
Have a weird situation. We have a sales invoice that has an incorrect total.
I added the totals of the line items and I am off. Has anyone seen this
While entering the transaction, something would have happened to this
transaction. Just get the users log out, run check links on Sales Transaction
Work Tables. Then, Go to the transaction,see if it's corrected, if not, you
can delete the transaction and re-enter the same.
> Have a weird situation. We have a sale...reports.xla
Can someone tell me where I can get the add-inn 'Reports.xla', i have now
tried several times to download the RPTMGR.EXE from the microsoft site, but
i can get it installed! Reading the web, this file seems to cause more
...System Attendant NDR #3
Hello. I recieve this message below. I upgrade our exchange server from
5.5 to 2003 and since then i receive this message. I have a number of pocket
pc users in our organization and when they make any calendar changes and
sync to the server, they receive the same ammount of NDR's as they made
changes in their calendar. A user today made nearly 100 changes on his
pocket pc and upon syncing, he recieved almost 100 NDR's. I've been trying
to fix this for months with no luck. Someone please, please help.
Your message did not reach some or all of the intended recip...CArray #3
I have 2 classes in my Model.dll project. I have simplified my Class names
are for this quesion. I have a Category class and an Object class. My
Category class needs to hold an array of Objects, so in my Category class
header file I #include "ProductionArtifactFast.h" and I have a member
CArray <Object, Object> m_ObjectArray;
My Object class needs to have a pointer to its parent category, so my Object
class forward declares the Category class in the header file and #includes
Category.h in the .cpp file. There is a member variable: Category
On p...nothing being generated in ISA reports..
We have a Windows 2000 Small Business Server. We currently have a Watchguard
Firebox 700 in our environment and because of this have not used the ISA
server portion of SBS. However, I have recently been asked to begin
providing internet traffic documentation, visited sites etc.... Watchguard's
reporting is not nearly as good as ISA's and so I have tried to turn "on"
ISA so all web requests are logged and reporting can be done using ISA.
I have configured what I thought I needed to but when I generate the report,
no data is present. I am logged on the SBS as myself (I am the ...email@example.com <firstname.lastname@example.org>
hi i m enterest on the computer desk that you posted on craglist please give
min a call on 617 650 3246 i wanted to bye it thank you bye.
...tax software report disappeared
My Tax Software Report has disappeared. I went to Tax
Reports. When I select Tax Software Report then select Go
To Report/Chart it says it is loading but nothing
happens. This happens every year when I try to use Tax
Report Software. I thought there might not be enough
memory for my computer, but even when I closed all
programs it still didn't work.
I also went to Reports Gallery and selected Taxes. I had
exported to excel from Tax-Related Transactions. Could
this have done something.
I am hoping someone can help since Microsoft will not.
...How to report for 50 counties?
Hi -- How can I report the county 1,2,..10,11,19 in the first quarter but in
the second quarter they have only county1, and 3 third Q. they have county
5,10,15,20 then 4th Q they have nothing. How can i design in the report?
Thank you for any reply.
You aren't giving us much to go on. We don't have a clue regarding your table
structures, data, or desired display in your report.
A vague question like this suggests your tables are not structured
correctly. I could be wrong but really can't tell anything from the
information you have provided.
Mi...Non-taxable sales vs. tax-exempt sales
Can anyone tell me how the system differentiates between what come sout on
the Sales Tax Analysis Report as "Tax-Exempt" vs. ""Non-Taxable"??? As far
as I know all the itemjs in my database all have the SAME "tax" property
selected or left as "NONE" in the General properties set-up screen.
When I print a Sales Tax Analysis report some sales show as non-taxable and
a different amount as tax-exempt. How can I find out what determines how
what type of sale is recorded?
[For the record, we sell non-taxable food items as well as items which a...Updating Sales Order total
I'm integrating UPS shipping system with GP 9.0. I have developed an
application that writes the freight and tracking data back to an order. I
write the freight total to SOP10100.FRTAMNT. I'm quite green with GP 9.0 and
discovered that indeed the freight on the order is updated but the order
total doesn't get updated.
What's the best way to get the order's bottom line updated? Is there some
stored procedure or something that handles this logic?
Thanks in advance,
I have tested you scenario as stated by you, the choice is yours if you ...Sales missing after upgrade from CRM 1.2 to 3.0
I did the upgrade from CRM 1.2 to 3.0. No errors occured, but when I load CRM
3.0 I don't have SALES Module anymore. I need some help !
if you are logged on as an admin go to your user record and make sure the
restricted access mode checkbox is unchecked
Microsoft CRM MVP
"Andrea" <Andrea@discussions.microsoft.com> wrote in message
>I did the upgrade from CRM 1.2 to 3.0. No errors occured, but when I load
> 3.0 I...Outlook offline reports not available
I have setup most of my CRM 4 users with the Outlook client, which seems to
work considerably better than that in CRM 3. However, when the clients are
traveling and unable to attach to the Internet, the reports are not
available. Is there any way to make the CRM reports available offline. The
SQL database is loaded on each of the user PCs and everything else seems to
be working just fine. Any assistance will be appreciated.
It is working on our end ok.
I would try the following:
1. Setup a test client with a CRM Administrator login and install the 4.0
CRM Outlook ...How Register the add-in DLL on each sales register
Hello, I have developpé a component on my test pc.
That this works well, I would like to add it on one of my sales register.
But I do not know how Register the add-in DLL on each sales register.
It depends on your development environment, but all versions of Visual
Studio that I have used have had some facility for creating an installer
package. The installer should take care installing dependencies and
registering components/assemblies as long as you have selected the
correct project properties.
Tiber Creek Consulting
glenn@tiber...Report layout problem
I have a database with two fields in it. One is numeric the other is text.
There are 1000 records in the database.
I created a column report with the two fields in it - ie - field1 and
field2; however, the report is too long.
I would like to create a new report that has six columns on each page so
that information in fields 1-2 initially goes into columns 1-2 then
continues on to columns 3-4 and columns 5- 6. Thus the report would contain
three times as much information on each page.
The report would look like this:
...Nested If Functions #3
First of all forget the tax calulations, I can take care of that.
Employee's wages are listed in columns. One column is the total of th
first two quarters, the second column lists the third quarter.
If the first two quarter's wages are less than $8500 then part or al
of the third quarter' wages must be used to calculated the base. Fo
instance, quarters 1 & 2 wages for an employee are $4000 and the thir
quarter is $9000 then an additional tax must be paid on the additiona
$4500. (tax was allready paid on the $4000. There also could be a cas
where an employee was pai...Error Total sales report hour sales
Got a hourly sales report from the microsoft customer source which gives a
wrong total sales because it is selecting more items than sold during a
certain time. Can anybody tell me what needs to be change in the qrp. report
//--- Report Summary --- //
ReportType = reporttypeSales
ReportTitle = "Detailed Sales Report by hour"
PageOrientation = pageorientationLandscape
WordWrap = False
ShowDateTimePicker = False
OutLineMode = True
Groups = 2
GroupDescription = ""
DisplayLogo = True
LogoFileName = &q...old sales reps
I know this has been discussed before but I can't seem to find an answer to
it. I had an employee quit that was a sales rep, now she still shows up in
the login screen. Is there any ramifications to deleting her. There's no way
to make it inactive and it's annoying having her show up on all the reports
and the login screen. Am I stuck having her show up everywhere until the end
I think it is a glaring omission to not be able to inactivate employees, so
you can keep thier records, but not have to wade through them on a day to
day basis. My solution ...Bar chart for product sales
I have an excel sheet with 3 columns
order number, quantity, order date
I would like to see a bar or line chart that shows the sales trend.
The order date column contains duplicates since there are often many orders
of the same thing on the same day. The date format is MM/DD/YYYY
The date range spans 3 years so I was thinking it would be cool to see a bar
per month that represents the quantity ordered of that month. I don't really
care about the order number appearing in the chart, I simply had to use it
when I exported the query from access.
using excel 2002