Reports.Dic upgrade failed
I'm attempting to upgrade from GP Version 8.0 to Version 9.0
When I attempt to use 'Update modified forms and reports' in the Utilities I
get the following error in the resulting LOG file.
Error on line 1295: Unknown field: 'Source Receipt SQL Number'(Command 21).
The resulting REPORTS.DIC file fails to open under GP90.
How can you tell which report this field is used in? How can I see line 1295?
Bottom line... how do you fix this?
Thanks so much for any help you can provide.
Try this if you still have access to you GP80, go to Tools - Cus...Sum of each grouped item in a report
I have a form that logs time spent on auditing activities for the Internal
Auditors in my company. Each time the auditor performs an audit related
task, they enter a new record under their name. This means they could have
many occurences of the same function. I then created a query/report that
breaks down the different auditing activities for each internal auditor.
Management has now asked for a report that gives a total for each activity
for each internal auditor (example - John Smith: Audit Prep - 2.25, Follow-up
- 3.75, Audit - 7.50). I want to figure out how to do this on a rep...Exporting Daily Z-reports from MRS to Quickbooks
Basicly im trying to figure out how to export the daily Z-reports from
Microsoft Retail Systems 1.2 to Quickbooks (I believe 2005) in 3 steps or
fewer. Ideally, there should be a way to do this without exporting the data
to a file, but rather do it directly from MRS after posting the z-report.
If anyone can help please let me know
if you are using the US version of Quickbooks, the ability to post
directly from RMS to QB is built in - you just need to set it up and
assign your accounts. Ask your RMS reseller and Accountant/Bookkeeper
for help - usually takes about 2 hours t...win7; money plus deluxe; monthly report failures
When using Microsoft Windows 7 and Money Plus Deluxe v184.108.40.2065. I'm
trying to prepare my monthly reports. I get the error,
"Money requires Internet Explorer 6 to function properly. Please reinstall
Internet Explorer 6 so these components can be added".
Win7 has IE8. IE8 > IE6. Shouldn't this work? I searched for this error
elsewhere and couldn't find it, or its resolution. Any tips/tricks would be
P.S: I know Win7 is Beta and that with Beta's come issues like this...
I have the same problem and I wish there was a fix for it. Does anyo...Track registered products and trigger event
I have a very simple spreadsheet that has a column of serial numbers
and next to it a column with a yes/no tracking whether a serial number
has been registered or not. I want my sales team calling into an
account once 50% of the serials are registered so I created a pivot
table that simply has the yes/no field on the top and a count of each
in the data. Then I created a pivot chart with the yes and no next to
each other and the data labels displayed. So far so good and this
does accomplish what I want at it's most simple level.
What I would love to do though is:
1) change the count (a...Changing field settings on multiple columns in pivot report...How
You have brought up a pivot report but it defeaults to count for all columns.
Can you change all to max with one operation?
You can't manually change all the calculations to MAX with one step.
You can change each field individually, by double-clicking on it, and
changing the summary function.
Or, you can use programming to change all the data fields. For example:
'changes data fields to MAX
Dim pt As PivotTable
Dim pf As PivotField
For Each pt In ActiveSheet.PivotTables
For Each pf In pt.DataFields
pf.Function = xlMax
Next...Money 2005 Flyer Report bug
I just found a bug in the "Frequent Flyer Point or Miles" report. The
sorting of "Total miles/points available" is incorrect. It does not sort by
value but by characters. For example, it gives me a sorted list of:
Will Microsoft fix that and give us an update? I just bought Money 2005 for
not long and don't want to spend another three hundreds on 2006 now.
MS almost never issue patches during the life of the product/year. M2005 has
been out since mid-2004 so is getting on for 18 months old. Similar...HELP! Seeking Instructions to Create Report of POS (NOT RMS) Discounts Applied
I really need a solution to this problem...
We really need to run ongoing reports to determine how many of our different
Discounts are claimed/used and the proceeds not tendered. We have offered a
number of discounts to customers and employees as incentives and cannot find
a method to track how each discount is applied.
The built-in reports within POS (not RMS) are not nearly as robust as we
wish/require. Is there a query we can run on
a transaction table to reveal the discounts applied to those transactions?
In the POS Query Tool, running the query "select * from [Transaction]"...Check for Values
I have 2 tables, requirements and stock on hand. In the requirement
table, I have a part number, qty and due date and a related record in
the stock on hand table using part number showing current stock. My
question is can I use a query (and how!) to tell me
a) I have enough stock to fulfil the requirements and
b) If not at what date will I not be able to fulfil the requirements
and by how many?
Have been working on this for a while, and cant work it out
You are there, we are not ... the following may not fit your situation ...
If you have a [Par...Payroll deduction reports
I can't seem to find a report option or a Smartlist that will provide
information on detailed deduction amounts for employees. Specifically we are
looking for a report that would list the 401K deduction and 401K match per
employee for a date range or YTD - can't seem to find any appropriate fields
in Smartlist either.
...Error 0x80040155 interface not registered
I installed Microsoft office professional 2003 Academic Edition and have
Office outlook as a default email program.
I was using it without any problems, but suddenly when I try to use outlook
to send email I…
a) Can not send email directly from word or excel
b) If I try to copy and paste a word document into a new message, or attach
it, I receive an error stating “Word unspecified error” or “interface not
registered error 0x80040155”
and finally, I cannot send the email.
I have tried finding info in this error in Microsoft office help with o
I tried to repair the office...Check if data has already been formatted.
I have a sub() as part of a larger set of macros.
This particular sub() will take the raw data pulled from an in-house
reporting system and format it to suit our needs (adding a couple of columns
with formulas to facilitate pivot table creation).
This is the code as I have it so far:
Application.ScreenUpdating = False
ActiveWindow.DisplayGridlines = False
Dim DataWks As Worksheet
Dim LastRow As Long
Dim LastCol As Long
' Set the DataWks variable
Set DataWks = Worksheets("Data")
...How to register a service process in win2000?
My PC's OS is win2000,and I want to register my current process into
service process.How to do?Thank you.
You don't. You are working in a Unix model where any application could be a service. In
WIndows, a service must be created as a service, and there Is No Substitute. Also, your
service must not have a GUI, or attempt to communicate via a GUI.
On Sun, 2 Jul 2006 10:16:39 +0800, "Lee Tow" <email@example.com> wrote:
> My PC's OS is win2000,and I want to register my current process into
>service process.H...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...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?
...Vendor transactions and checks
I'm trying to create a vendor payment report from my program. From which
tables I can get the vendor payable transaction information??? I also need
to know whether there is a check aleady issue to a transaction.
...Keeping a table in a form editable and checking that fields are filled in before allowing a save
Firstly apologies if this is the incorrect forum but I was looking for
a general word forum and could not find one. Please point me to one if
I am trying to create a form where I want to specify what items need
to be filled in. (Review minutes from design reviews). I want to make
certain fields mandatory like the date, attendees and check list used
and want to block saving of the document with a warning until they are
filled in. Is there a way of doing this?
Also as a part of the review actions are filled in to a table.
depending on how many actions there are the table...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 ...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"...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, ...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...Vendor/Customer Secondar Address
Hi I have written small program in C# by using Econnect 10 I updating
Customer and Vendor it works fine but I cannot update the Secondary address
for both Customer/Vendor can any body tell me which Econnect schema I have
to use to update the Secondary address.
...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...Report Format
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 ... ???
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