Can someone point me to the correct Schema/XML node to enter data to the
Transaction Entry screen found in the path Transactions, Financial, Batches,
Transaction button ?
I believe that would be <taGLTransactionLineInsert>....
Microsoft Certified Business Management Solutions Specialist, GP 9.0
Currently supporting: GP 9.0, SP2
> Can someone point me to the correct Schema/XML node to enter data to the
> Transaction Entry screen found in the path Transactions, Financial, Batches,
> Transaction button ?
> ...GridviewRow cell reference
I have a page that populates a gridview, the gridview has a select button
column enabled. When the users pushes the button to select a column
on the Gridview1_SelectedIndexChanged event I have
GridviewRow selectedRow = Gridview1.SelectedRow;
Session["SelectedEvent"] = selectedRow;
I do a page redirect and on the new page I want to fill a text box with one
of the cells in the GridviewRow.
So on the new pages onload event I have
GridviewRow selectedEventRow = (GridviewRow)Session["SelectedEvent"] ;
Now if I put:
txtBox1.Text = selectedE...Project table schema changes in 9.0
I upgraded a server from GP 8.0 sp5 to GP 9.0 sp2 last weekend. All seems to
work fine so far.
I have some Crystal Reports that were in the process of being developed and
I have questions about 3 Project tables. These tables each have had fields
My question is...Where has the data these fields represented been relocated?
Has the upgrade taken data from these tables and moved it to other tables?
*** Lists the fields added and removed in Project tables ***
C:\Program Files\Microsoft Dynamics\GP 9.0
SDK\Content\8.0to9.0\PaTableDetailed_...How do I correct a range 'reference'?
Using Excel XP.
I've had a frustrating time with DSUM on a workbook I'm building from
someone else's model - I keep getting #VALUE! errors. After lots of looking
"underneath the hood" I think I see the problem, but don't know how to fix
One of the formulas is: =DSUM(Revenue,'Revenue Projects'!$D$3,B1:B3)
The problem comes up with "Revenue". When I use the Evaluate Formula tool,
it italicizes "Revenue", and when I click on Evaluate, I see 'Revenue
Projects'$A$1:$J$14 in it's place - italicized....xsd.exe errors with schemas importing other schemas
I am working with XSD.exe vs.net command line util. I have an XSD that I am trying to use to generate classes with. However, the XSD references another schema and the XSD.exe is having trouble finding the referenced schema. Does anyone have an example of what the command line params would be so that the tool is aware of all schemas? Does the tool have trouble with the XSD lines:
<xs:import schemaLocation=".\referencedxsd.xsd" namespace="somewhere.files.referencedxsd" />
<xs:element ref="r:ReferencedRo...Circular References #2
I have an error that tells me I have a circular reference
and that it cannot tell me where the circular reference
is. I checked my worksheets and the linked workbooks, I
can't find it. Does anyone know where or why this error
I don't know if this will help or not, but Excel XP does have a circular
reference toolbar. Select View, Toolbars, circular reference. If you don't
see the toolbar, seelct View, Toolbars, Customize, Circular Reference. My
experience with circular references has been that usually the cell in which
you want to put the calcul...xml schema: elements with unique attribute values.
I�m a bit newbie writing xml schemas.
Is it possible to define xml element that must have unique attribute
values in same level. For example if i have a xml - document:
<!-- subsection contents -->
<subsection name="first"> <!-- ERRROR!!! -->
<!-- subsection contents -->
<!-- subsection contents -->
<xs:complexType n...Reference Problem w/ inserting rows
I need to find the average of a range of cells, A7:A11. However, I wil
insert a row in front of A7, causing the original A7 to become A8.
still want the formula to refernce A7:A11, and just drop the cell tha
got pushed out. However...
Regardless of the static symbol($), my reference is still moving t
A8:A12, following the original group of numbers.
I thought the static should stop this, but it doesn't.
Thanks for any help
Paul987's Profile: http://www.excelforum.com/member.php?action=getinf...Adding a new record with a reference to another table
Not sure if this is a 'Query' question or a database design question but
hopefully someone will be able to point me in the right direction.
I have a database with 3 tables, Roles, Targets and Actions, defined as
TargetID (AutoNum, PK)
RoleID (AutoNum, PK)
RoleText (Text, unique index)
ActionID (AutoNum, PK)
TargetID+RoleID = Unique index
For each Target there may be several combinations of Roles/Actions.
I'd like to be able to crea...return cell reference
I am using the DMAX function to find the maximum data value within a
certain range of dates. I
now need to find the date associated with that maximum value. I am
dealing with streamflow data
in 5-minute intervals, so there are many peaks in the data. I am looking
at specific events by
specifying a time range to search in. I have two columns, one column of
dates and times
(mm/dd/yy hh:mm) and one column of water depth.
I have tried DGET (e.g., DGET(R104:T65000, "datetime",R2:U3)) to return
the date assocuated with
the maxium found by DMAX, but the maximum value may be found...Compatibility Checker dialog box needs to state workbook referred
The Excel Compatibility Checker dialog box in Excel 2007 (which warns of
features in a workbook which aren't supported by earlier versions of Excel
which may be lost if the file is saved in an earlier format, e.g. Excel 2003)
currently doesn't say which workbook it is referring to.
This is a problem when using a .net or VBA program from Excel to manipulate
other Excel files. In our case we have a custom toolbar that reads in data
from another Excel file of the user's choice, and writes to this file, the
Excel Compatibility Checker dialog box pops up to warn "minor loss...How to view a complete schema when using schema includes/imports?
I've got a parent schema file that references complex element types
that are defined in several "child" schema files and I used the schema
imports statement to include them into the parent schema's default
namespace. I would like to generate a complete/single-file instance of
the schema to simplify things but I can't figure out how to do it.
Each schema seems to live in it's respective memory space inside the
SchemaIncludesCollection. Any idea how I could traverse all of the
"virtual" nodes in the parent schema to create a physical
representation of what t...Changing the row reference in a link
I would like to be able to change the row that a cell references by entering a number in a cell. I have a sheet that automatically updates various data (such as stock prices). I then have another sheet that has a standardized report format. I would like to have a cell linked to the stock price (such as =Data!F19) but have a cell so that I could change the row link from 19 to another number by just entering that number in a cell on the standardized report sheet (something like =Data!F(A2)). I would like to avoid a macro if possible..
...Cross Reference Error
I have a Word 2003 document that contains cross references. I've discovered
that sometimes when I print the document a random cross reference will give
the following error message:
Error! Reference source not found.
Other times it prints just fine. Any Thoughts?
When you get that error message, you need to delete and re-build the
The information that is "read" by the cross-reference is stored in the
paragraph marker of the target paragraph. If, during your editing, you add or
delete paragraph markers or split a paragraph, you can lose the...Getpivot data dynamic reference
I am using the getpivotdata to retrieve data from a pivot table,
the formula contains references to cells $C$4,$D$4 for different items
of the fields of the pivot table, where the user can choose via a
dropdown menu the values.
=GETPIVOTDATA("Sum of Volume 1",'Summary 1'!$A$4,"Month",$C
Would it be possible to do the same for the data field "Sum of Volume
1" and the pivot table name 'Summary 1'!$A$4 as I have different
I tried the following formula for the pivot table name:
I have a couple of questions on Schema Mappings...
I've setup CRM so that when an account is made the user has the option
of choosing what added extras the client has. Examples of this are:
Anti Virus, Anti Spam etc. I've set this up as a simple drop down menu
on the account General tab.
I want this drop down menu to link with another similar menu I've
created under the case (incident) General tab.
I'd like to set it up so that when you change one it effects the other
(ie change accounts and it changes the case drop down.
I tried mapping the schema fields to achiev...XML validate by XSD schema with C#
I am validating XML files on a server which has no internet access and
the validadation in C# does not work. Schema with which I am validating
has namespaces like: xmlns:ds="http://www.w3.org/2000/09/xmldsig#"
I have these schemas all locally on the disk, but it does not work. If
I try on a computer with internet access then it works just fine. Does
someone know what to do. Function with which I validate looks like
private bool ValidXml(string XmlFile, string XSDLoc, string tns)
// . . .
string targetNamespaceU...Schema Question
I am fairly new to XML schemas and why to use them. I am integrating with
another application via xml. My questions are schemas only good to validate
the XML documents or can I use the schema to help me parse the xml document?
Well, following link will be useful to you.
> I am fairly new to XML schemas and why to use them. I am integrating with
> another application via xml. My questions are schemas only goo...Solver Reference to Add-in
I have an add-in that contains a time series forecasting routine in VBA that
requires the use of the Solver add-in. I want to use VBA to establish a
reference to the Solver add-in for the forecasting add-in. I have attempted
the following with limited success. Any suggestions would be much
Private Sub Workbook_Open()
'Install the custom menu
'Check to make sure that Solver add-in is installed
'Check the version of Excel and warn the user if an older version.
...Where do I put my schema?
I'm developing a internet site for a customer. The customer is supposed to
upload XML documents to the site and the documents shall be validated
against a xsd schema.
How do I publish the schema so that my customer may use it for namespace
validation on their side? The site is an aspx site that has forms
authentication. We do not want to put the schema on the site without any
It can go anywhere your client has the ability to find it. If you want them
to authenticate, then put it behind that authentication. It's just a file,
like an image ...How to get cell references
I have a value in a particular cell and I need to return the cell reference
of that particular cell eg. "A23". What is the function for getting it.
Thanks in advance
If cell A23 has a value that you want to use elsewhere then use
But if A23 has a text string in it like "Z99" that you want, then use
> I have a value in a particular cell and I need to return the cell reference
> of that particular cell eg. "A23". What is the function for getting it.
> Thanks in ad...Setting a reference to a schema doesn't work?
Using the System.Xml.XmlDocument I want to create such a xml-file:
<?xml version="1.0" encoding="utf-8"?>
(That's what XMLSpy generates when assigning a schema to an xml-file.)
pDoc = New System.Xml.XmlDocument
pDoc.AppendChild(pDoc.CreateXmlDeclaration("1.0", "utf-8", ""))
pRoot = pDoc.AppendChild(pDoc.CreateElement("RootElement"))
...System Folders: Schema and schema-root
I have migrated from Exchange 2000 to Exchange 2003 (native Win 2000
Comparing PF -> System Folders with a clean Exchange 2003 Installation
(native Win 2003 AD) I notice some differences in the System Folders;
On the clean Exchange 2003:
No 'Schema' system folder
I renamed the Schema folder on the migrated servers and so far
no problems. Is this folder still of any use in a Exchange
On the clean Exchange 2003:
No 'schema-root\microsof\exchangeV1\exchweb and further.
Because of earlier problems (There were 2 schema-root folders)
I r...How to create DB schema from XML schema
We have XSD file with XML schema and want to generate database or SQL
from it. Visual studio reads XSD file and shows everything graphically
fine. Is there anyway, we could actually transfer the graphical
information to database?
...Relative Sheet References
I have 50 worksheets with data, that I want to summarize
on a sumary sheet. I have created the link to the cell
on the first worksheet. I when I copy and paste the
link, the cell reference changes relative to the row
below, etc. I also want the sheet to change from the
Sheet 1 to Sheet 2, etc.
Can I do this? Please say yes. And then give me a
little diretion on how.
I don't use newsgroups very often, so if anyone knows the
answer, could you email me at
do the worksheet names follow a logig. e.h.
If yes you may pos...