Re: [Axapta-Knowledge-Village] AX 2009 reporting services error: AX_CompanyName
Hi , An incorrect Execution account has been specified in the Reporting Services Configuration Manager For SSRS 2008 the BC proxy is required to be the Execution account and for SSRS 2005 an Execution account should not be used. Also look at application event log for details on other issues. regards, Sreenath From: kardo_ax kardo...@yahoo.com To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, September 10, 2009 6:01:16 PM Subject: [Axapta-Knowledge-Village] AX 2009 reporting services error: AX_CompanyName When trying to run any report that uses reporting services (reports that are marked with *), Im getting the following error: AX_CompanyName (rsReportParameterP rocessingError) Can anyone help?
Re: [Axapta-Knowledge-Village] Displaying Records On Form From Query
Hi,
try using
qbds.addRange( fieldNum( PurchTable,
PurchStatus)).value(enum2str(purchstatus::BackOrder));
regards,
sreenath
--- On Tue, 8/25/09, girac127 girac...@yahoo.com wrote:
From: girac127 girac...@yahoo.com
Subject: [Axapta-Knowledge-Village] Displaying Records On Form From Query
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Tuesday, August 25, 2009, 12:07 AM
Good day all.
My requirement is to display only records where the PurchStatus =1 on
a new PO detail form which I have in place.
I have the following code in the init Datasource(Purchtab le) Method. What am I
missing to have this execute?
public void init()
{
Query q = new Query();
QueryBuildDataSourc eqbds;
;
super();
qbds = q.addDataSource( tableNum( PurchTable) );
qbds.addRange( fieldNum( PurchTable, PurchStatus) ).value(“1”);
info(qbDS.toString( ));
}
I have the info displaying my correct query, but I am returning
results other than the value of “1”
Re: [Axapta-Knowledge-Village] Compile error with XML Create Document
use xmlDoc.createTextNode( strfmt('%1',ReqTrans. Qty));
sreenath
--- On Thu, 8/13/09, giarc 127 girac...@yahoo.com wrote:
From: giarc 127 girac...@yahoo.com
Subject: Re: [Axapta-Knowledge-Village] Compile error with XML Create Document
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Thursday, August 13, 2009, 9:09 PM
prashan,
I tried the any2str and it compiles but I receive runtime error, Error
executing code: Wrong type of argument for conversion function.
Would I need to use variables for this?
Regards.
From: prashant verma prashant_axapta@ yahoo.co. in
To: Axapta-Knowledge- vill...@yahoogro ups.com
Sent: Wednesday, August 12, 2009 11:26:43 PM
Subject: Re: [Axapta-Knowledge- Village] Compile error with XML Create Document
Goodmorning Girac,
Your problem is solved.Actually createTextNode method accepts str argument.Just
write
any2str like this xmlText = xmlDoc.createTextNo de(any2str( ReqTrans. Qty));
And for integers or real value always use num2str.
Regards,
Prashant Verma
ILFS Technologies Limited.
--- On Wed, 12/8/09, Girac girac...@yahoo. com wrote:
From: Girac girac...@yahoo. com
Subject: [Axapta-Knowledge- Village] Compile error with XML Create Document
To: Axapta-Knowledge- vill...@yahoogro ups.com
Date: Wednesday, 12 August, 2009, 8:10 PM
Good day all,
I am getting an error when I compile this job,
Argument 'Text' is incompatible with the required type.
Here it the code I am using,
// Create a node for the Qty
xmlElement = xmlDoc.createElemen t(Qty);
NodeAddr = NodeEmpl.appendChil d(xmlElement) ;
xmlText = xmlDoc.createTextNo de(ReqTrans. Qty);
NodeAddr.appendChil d(xmlText) ;
Qty is an real number,
What arguments would I need to use for integers/numbers?
Here is my full code:
static void XMLitem(Args _args)
{
XMLDocument xmlDoc = XMLDocument: :newBlank( );
XMLNode rootNode;
XMLNode NodeEmpl, NodeName, NodeAddr;
XMLElement xmlElement;
XMLText xmlText;
//XMLreal xmlNumber;
ReqTrans ReqTrans;
int i;
;
// Create first line containing version info
rootNode = xmlDoc.documentElem ent();
xmlElement = xmlDoc.createElemen t(axItems );
rootNode = xmlDoc.appendChild( xmlElement)
;
while select ReqTrans
{
// Create a node for the Items record
xmlElement = xmlDoc.createElemen t(Items );
NodeEmpl = rootNode..appendChi l d(xmlElement) ;
// Create a node for the ItemID
xmlElement = xmlDoc.createElemen t(ItemID );
NodeName = NodeEmpl.appendChil d(xmlElement) ;
xmlText = xmlDoc.createTextNo de(ReqTrans. ItemID);
NodeName.appendChil d(xmlText) ;
// Create a node for the Qty
xmlElement = xmlDoc.createElemen t(Qty);
NodeAddr = NodeEmpl.appendChil d(xmlElement) ;
xmlText = xmlDoc.createTextNo de(ReqTrans. Qty);
NodeAddr.appendChil d(xmlText) ;
i++;
print i;
}
// Save the file
xmldoc.save( 'C:\\Temp\ \XML.xml' );
}
See the Web's breaking stories, chosen by people like you. Check out
Yahoo! Buzz.
Re: [Axapta-Knowledge-Village] Stop an item for transactions
Hi Go to Inventory management Items details form select an item click on select button select and click on default Order settings button.. you will find Purchase orders, sales orders tabs etc on that form . In the others field group you will find a checkbox called Stopped. If you check that checkbox, no further transations are allowed for that item. Thanks and regards, Sreenath Reddy --- On Tue, 7/28/09, Ax Consultant ax_consult...@yahoo.com wrote: From: Ax Consultant ax_consult...@yahoo.com Subject: [Axapta-Knowledge-Village] Stop an item for transactions To: Axapta-Knowledge-Village@yahoogroups.com Date: Tuesday, July 28, 2009, 10:29 AM Hi, how can we stop an item in AX 2009 for any further transactions ??
Re: [Axapta-Knowledge-Village] OutLook
Hi Go to Help System and Application Set up Sales and Marketing setup Integrating with Microsoft Office Outlook. Sreenath --- On Sat, 7/4/09, kishore k kishore_0...@yahoo.com wrote: From: kishore k kishore_0...@yahoo.com Subject: Re: [Axapta-Knowledge-Village] OutLook To: Axapta-Knowledge-Village@yahoogroups.com Date: Saturday, July 4, 2009, 2:42 PM There is no much diffrence from AX 4.0 to AX 2009... you can find better data in MSDN and partner source... BR, kik. From: Pooja . dyna.a...@yahoo. com To: development- axapta development- axa...@yahoogrou ps.com; groups dynamicsguru@ yahoogroups. com; groups microsoft_dynamics_ axa...@yahoogrou ps.com; groups SecretsofDynamicsSo ftwareAX@ yahoogroups. com; groups Axapta-Knowledge- vill...@yahoogro ups.com; groups MSDynamicsAXForum@ yahoogroups. com; groups Dynamics-Ax@ yahoogroups. com; groups dynamic...@yahoogro ups.com Sent: Tuesday, 16 June, 2009 9:39:05 AM Subject: [Axapta-Knowledge- Village] OutLook Do you know How to Integrate OutLook with Ax 2009 Yahoo! recommends that you upgrade to the new and safer Internet Explorer 8.
Re: [Axapta-Knowledge-Village] Issue with dateNull() function.
Hi,
Yes, AX returns empty value only when you try to print datenull().
we faced this problem earlier, even standard AX while generating XML using
axd's uses different approach to send datenull() as string.
It uses #axd macrolib and name of macro is #axdDateNullStr whose value is
'1900-01-0'.
For more information on this, you can see class AxdXmlWriter and method
writeValue()
Thanks,
Sreenath Reddy G
--- On Thu, 6/25/09, r_ssh ramamurthy.sant...@gmail.com wrote:
From: r_ssh ramamurthy.sant...@gmail.com
Subject: [Axapta-Knowledge-Village] Issue with dateNull() function.
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Thursday, June 25, 2009, 3:42 PM
Hi All,
Why is dateNull() returning no value. Is this the expected behaviour?
static void TestDateNull( Args _args)
{
;
print Global::dateNull( );
pause;
}
In Global class, dateNull() function returns 01\01\1900. But why it doesn't
print when the job is executed? We had also tried in the follwing ways but no
luck:(
print min(datenull( ),today() ); //not working
print mkdate(01,01, 1900); //not working
print num2date(0); //not working
print str2date(01- 01-1900, 123); //notworking
print systemdateset( datenull( )); //not working
print systemdateget( ); //not working
pause;
Heard that the same happens on AX3.0 and AX40??? Why is the behaviour like this.
Sumit/Sreenath any information available???
Thanks
Santosh.R
Re: [Axapta-Knowledge-Village] OutLook
Hi Pooja,
Here is the solution
static void Time_dialog(Args _args)
{
Dialog dialog = new Dialog(Schedule an Inteview);
dialogText text = dialog.addText( Please Enter the Interview scheduling
details);
DialogField DrNo = dialog.addField( typeid(dirpartyid),Doctor Registration
No);
DialogField DateInt = dialog.addField( typeid(Transdate ), Date of
Interview);
DialogField StTimeInt = dialog.addField( typeid(smmActivityStartTime) ,
Interview Start Time);
DialogField EnTimeInt = dialog.addField( typeid(smmActivityStartTime) ,
Interview End Time);
TimeOfDay stime, eTime;
str startTime, endTime;
;
if (dialog.run( ))
{
stime = StTimeInt.value();
etime = EnTimeInt.value();
starttime = time2str(stime, -1, -1);
endTime = time2str(etime, -1, -1);
box::info(strfmt( You will be sending an email to Doctor %4 with
Interview schedule details\n\nDate of Interview : %1,\nStart time: %2
\nEndTime: %3,DateInt. value(),starttime ,endtime,DrNo.value())) ;
}
}
Thanks,
Sreenath Reddy G
--- On Wed, 6/24/09, Pooja . dyna.a...@yahoo.com wrote:
From: Pooja . dyna.a...@yahoo.com
Subject: Re: [Axapta-Knowledge-Village] OutLook
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Wednesday, June 24, 2009, 6:45 AM
Hi Good morning,
time values are not giving out put what we enter into ..please execute this job
what would be the reason.
...
boolean myDialogjob( date FromChequeNum, date NumOfCheque)
{
Dialog dialog = new Dialog(Schedule an Inteview);
dialogText text = dialog.addText( Please Enter the Interview scheduling
details);
DialogField DrNo = dialog.addField( typeid(dirpartyi d),Doctor
Registration No);
DialogField DateInt = dialog.addField( typeid(Transdate ), Date of
Interview);
DialogField StTimeInt = dialog.addField( typeid(smmActivi tyStartTime) ,
Interview Start Time);
DialogField EnTimeInt = dialog.addField( typeid(smmActivi tyStartTime) ,
Interview End Time);
;
if (dialog.run( ))
{
box::info(strfmt( You will be sending an email to Doctor %4 with
Interview schedule details\n\nDate of Interview : %1,\nStart time: %2
\nEndTime: %3,DateInt. value(),StTimeIn t.value() ,EnTimeInt. value(),DrNo.
value())) ;
return true;
}
return false;
}
Re: [Axapta-Knowledge-Village] Calling SQL Statement thru Axapta
Hi,
Separate the logic of execution of the execute query in to a different method.
Your caller should run on server. For more examples,
you can look at releaseupdateDB classes.Here is the separate static method for
executing the query.
protected static ResultSet statementExeQuery(str _sql,
Connection _con = null)
{
ResultSet resultSet;
Statement statement;
;
try
{
if(!_con)
{
_con = new Connection();
}
statement = _con.createStatement();
// Do not call assert() here, do it in the caller
// BP deviation documented
resultSet = statement.executeQuery(_sql);
}
catch (Exception::Error)
{
throw error(@SYS99562);
}
return resultSet;
}
Thanks ,
Sreenath Reddy
--- On Wed, 3/4/09, Mukesh Kumar mukeshmutr...@gmail.com wrote:
From: Mukesh Kumar mukeshmutr...@gmail.com
Subject: Re: [Axapta-Knowledge-Village] Calling SQL Statement thru Axapta
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Wednesday, March 4, 2009, 1:00 PM
Hi Pankaj,
Try to do this by using a class and Set the runon property of the class
to Server.
Regards,
Mukesh
On Thu, Feb 19, 2009 at 5:44 PM, Pankaj Gupta pgupt...@gmail. com wrote:
Hi Guys!
There is one requirement where i need to call a stored procedure of SQL
Database (SQL Server 2005) from Ax2009. I have copied my requirment to simplest
example below: During the execution of code it throws these errors
Request for the permission of type 'SqlStatementExecute Permission' failed.
(S)\Classes\ SqlStatementExec utePermission\ demand
(S)\Classes\ Statement\ executeQuery
(C)\Jobs\StoredProc edure - line 33
Cannot select a record in ().The SQL database has issued an error.
_ _ _ _ _ _
_ _ _
userConnection = new Connection() ;
stmt = userConnection. createStatement( );
sql = select %1 from %2 where %3 = %4 and %5 = %6;//'SO-101245';
sql = strfmt(sql,
ReleaseUpdateDB: :backendFieldNam e(tablenum( SalesTable)
, fieldnum(SalesTable , custaccount) ),
ReleaseUpdateDB: :backendTableNam e(tablenum( SalesTable)
),
strfmt(nlslower, ReleaseUpdateDB: :backendFieldNam
e(tablenum( SalesTable) , fieldnum(SalesTable , SalesId))),
sqlSystem.sqlLitera l('SO-101245', true),
strfmt(nlslower, ReleaseUpdateDB: :backendFieldNam
e(tablenum( SalesTable) , fieldnum(SalesTable , DataAreaId)) ),
sqlSystem.sqlLitera l(Curext( ),true));
permission = new SqlStatementExecute Permission( sql);
permission.assert( );
sqlres = stmt.executeQuery( sql);
CodeAccessPermissio n::revertAssert( );
sqlres.next( );
info(sqlres. getString( 1));
_ _ _ _ _ _
_ _ ___
Guys I have tried using the LoginProperty class and ODBC connection but no
avail. Different error came at times but could not login thru Ax2009. My Sql
server is on another machine and m very much have access rights over that
machine and SQL Server.
Please help me out , wat m missing ?
Thnks in advance.
--
Pankaj Kumar Gupta
--
Software Developer | MBS Ax.
Tectura India. - +91 9953559549.
--
Mukesh Mutreja
# 09818421567
Re: [Axapta-Knowledge-Village] Report Path in Report print!
Hi Tushar,
I have written a job to get the report path based on the report name.
Here is the job.
Use the logic in the display method of your report in footer section.
static void Menu_search_Reportwithlabel(Args _args)
{
#define.Menu('Menus')
#define.Reports('Reports')
#AOT
Treenode treenode, child, itTree;
TreeNodeIterator iterator;
str exactPath;
str menuName;
str menuPath;
int menuLen;
Container con;
str ReportName = 'Vendor Aging Report';
// report label name as it appears in the Menus (Module) Reports in the
AOT
void checkReport(treenode _subNode)
{
Str path;
path = _subNode.treeNodePath();
_subNode = _subNode.AOTfindChild(ReportName);
if(_subNode)
{
exactPath =
strdel(strreplace(strdel(_subNode.treeNodePath(),1,1),Menus,''),1,1);
con = str2Con(exactPath,@'\');
menuLen = strlen(conpeek(con,1));
menuPath = #MenusPath + '\\' + conpeek(con,1);
menuName =
findProperty(infolog.findNode(menuPath).AOTgetProperties(),Label);
menuName = SysLabel::labelId2String(menuName,infolog.language());
info('Path - ' + StrReplace(menuName
+strdel(exactPath,1,menuLen),@\, ));
return ;
}
else if(infolog.findNode(path).AOTfirstChild())
{
checkReport(infolog.findNode(path).AOTfirstChild());
}
return;
}
boolean traverse(treenode _child)
{
Treenode tmpNode;
treeNodeIterator it;
tmpNode = _child.AOTfindChild(#Reports);
if(tmpNode)
it = tmpNode.AOTiterator();
while(tmpNode)
{
checkReport(tmpNode);
tmpNode = it.next();
}
return 0;
}
;
treenode = infolog.rootNode();
child = treenode.AOTfindChild(#Menu);
child = child.AOTfirstChild();
while(child)
{
if(traverse(child))
break;
child = child.AOTnextSibling();
}
}
regards,
Sreenath Reddy
--- On Fri, 9/26/08, Tushar Joshi [EMAIL PROTECTED] wrote:
From: Tushar Joshi [EMAIL PROTECTED]
Subject: [Axapta-Knowledge-Village] Report Path in Report print!
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Friday, September 26, 2008, 7:43 PM
All,
Is it possible to print the Report path in the print of the report?
E.g. - I have opened a report say GLReportsTransactionsPeriodicTrial
Balance, then on the report print is it possible to print it somewhere? say
header or footer? In one of the implementations it has came as a requirement
from Client :)
-Tushar
Unlimited freedom, unlimited storage. Get it now
Re: [Axapta-Knowledge-Village] Re: Stop GL posting using X++ Code
Hi Raj, As per my understanding, i think u have commented some code in ur ledgervoucher class method which will stop ledger transactions. But when u r running from ur class, it should execute the commented code as well - right? 1)Best way is to write a condition check in ur ledgervoucher class method, if its coming from ur class then only exceute it( u can use some boolean checks) 2)Another way to achieve this is through treenode.But i would always prefer the first case.u need to parse till that method uncomment the code, run ur class method, then recomment the code. Here is the solution treenode treenode; ; treenode = infolog.findNode(@'\ledgervoucher\post'); treenode.AOTsetSource(strreplace(treenode.AOTgetSource(),'//ledgervoucher.end()','ledgervoucher.end()')); treenode.AOTcompile(); treenode.AOTsave(); : : : :// ur actual posting code which will call the commeneted code : : : Now once you are done with ur posting .. u can re comment the code back by using the the approach above( u need to setsource back to commenetd code). Hope this might help u. i didnot test the code. You can tryout. But personally i wouldnot prefer this kinda logic. regards, sreenath Reddy RAJKUMAR [EMAIL PROTECTED] wrote: Hi Steeve, Actually I wanna try stopping GL posting from Class LedgerVoucher method Post. I have just commented a line for not posting.Actually I have written my own class for posting, wheneveer I call my custom class this line in post method(commented) should be called and I have copied the exact same line and pasted. Using a condition, I dont want to stop standard posting. But when I call from my class, it has to run the commented line in that method. I think you got my idea. Just clue me if you get any input on the same. Bye, Raj.. Steeve Gilbert [EMAIL PROTECTED] wrote: I'm not quite sure what you want to acheive here. Can you simple add throw error(posting stopped) code? Or do you want a multi- threading window that let you cancel the posting WHILE it is running? The last is quite a challenge in Axapta. regards, Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Rajkumar [EMAIL PROTECTED] wrote: Hi All, Can anybody tell me how to Stop GL posting using X++ Code. There is a way to comment the code in post method of LedgerVoucher Class. But I need that to be done in x++ code. Anybody suggest?? Regards, Rajkumar - Shape Yahoo! in your own image. Join our Network Research Panel today! [Non-text portions of this message have been removed] - TV dinner still cooling? Check out Tonight's Picks on Yahoo! TV. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Relation to a field
try using
changecompany(//ur company name)
{
//code u can get the data from the table specific to that company now.
}
regards,
sreenath
Vishala Hiremath [EMAIL PROTECTED] wrote:
Hi,
How to achieve working with more than one company?
sreenath reddy [EMAIL PROTECTED] wrote:
Hi,
use SysTableRelation class and in that u can find method findRelation() .
that will serve ur purpose.
Additonal Information
u can find the field properties by using macors.
#macrolib.dictfield
and use the methods of macros to get the properties of that field.
some methods are-
#DBF_VISIBLE
#DBF_CREATE
#DBF_CHANGE
#DBF_STORE
#DBF_REPORT
DBF_RELATIVE
#DBF_RIGHT
#DBF_SHADOW
#DBF_MANDATORY
regards,
sreenath Reddy G
V G [EMAIL PROTECTED] wrote:
Hello
I am trying to find the relationship on all the fields of a given table.
Relation to a field that have extended datatype can be found out but not the
other relations(by using datafield relationobject).
Please help me out.
Thanks
VM
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
-
Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
-
Yahoo! India Answers: Share what you know. Learn something new Click here
Send free SMS to your Friends on Mobile from your Yahoo! Messenger Download now
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course
Business to business finance
Small business finance
Business finance consultant
Business finance magazine
Business finance schools
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Re: Sex Video
hi, I request Knowledge group to check the mails before posting it to group..there should be some check by the knowledge group to post valid mails.. Dont accept any mails which are of such subject lines first.. try to delete carnivorous mails..which starts with subjects like that Please remove this person([EMAIL PROTECTED]) from the group who is sending such crap mails to the group. Thanks in advance sreenath Reddy Cyrus Bharda [EMAIL PROTECTED] wrote: Will someone please remove this person from the list, all he is doing is spamming it. Cy On 30 May 2006 22:24:30 -0700, mailtochenna_ax [EMAIL PROTECTED] wrote: - forwarded message - [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance coursehttp://groups.yahoo.com/gads?t=msk=Business+finance+coursew1=Business+finance+coursew2=Business+to+business+financew3=Small+business+financew4=Business+finance+consultantw5=Business+finance+magazinew6=Business+finance+schoolsc=6s=185.sig=I8jDsORmsaYn0BeqghcJ2w Business to business financehttp://groups.yahoo.com/gads?t=msk=Business+to+business+financew1=Business+finance+coursew2=Business+to+business+financew3=Small+business+financew4=Business+finance+consultantw5=Business+finance+magazinew6=Business+finance+schoolsc=6s=185.sig=fCzze7cxm1K7TVKkzAaOrA Small business financehttp://groups.yahoo.com/gads?t=msk=Small+business+financew1=Business+finance+coursew2=Business+to+business+financew3=Small+business+financew4=Business+finance+consultantw5=Business+finance+magazinew6=Business+finance+schoolsc=6s=185.sig=v9sWAno7Kz4WuL8Tadcdhw Business finance consultanthttp://groups.yahoo.com/gads?t=msk=Business+finance+consultantw1=Business+finance+coursew2=Business+to+business+financew3=Small+business+financew4=Business+finance+consultantw5=Business+finance+magazinew6=Business+finance+schoolsc=6s=185.sig=d1xwT3WL0E6XBf6cAV5BXA Business finance magazinehttp://groups.yahoo.com/gads?t=msk=Business+finance+magazinew1=Business+finance+coursew2=Business+to+business+financew3=Small+business+financew4=Business+finance+consultantw5=Business+finance+magazinew6=Business+finance+schoolsc=6s=185.sig=qphRINaNuVm_6bwoQxgUmg Business finance schoolshttp://groups.yahoo.com/gads?t=msk=Business+finance+schoolsw1=Business+finance+coursew2=Business+to+business+financew3=Small+business+financew4=Business+finance+consultantw5=Business+finance+magazinew6=Business+finance+schoolsc=6s=185.sig=1RfnhYZpV99RKWRZzSH4gA -- YAHOO! GROUPS LINKS - Visit your group Axapta-Knowledge-Villagehttp://groups.yahoo.com/group/Axapta-Knowledge-Village on the web. - To unsubscribe from this group, send an email to: [EMAIL PROTECTED][EMAIL PROTECTED] - Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/. -- [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Ring'em or ping'em. Make PC-to-phone calls as low as 1¢/min with Yahoo! Messenger with Voice. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Relation to a field
Hi, use SysTableRelation class and in that u can find method findRelation() . that will serve ur purpose. Additonal Information u can find the field properties by using macors. #macrolib.dictfield and use the methods of macros to get the properties of that field. some methods are- #DBF_VISIBLE #DBF_CREATE #DBF_CHANGE #DBF_STORE #DBF_REPORT DBF_RELATIVE #DBF_RIGHT #DBF_SHADOW #DBF_MANDATORY regards, sreenath Reddy G V G [EMAIL PROTECTED] wrote: Hello I am trying to find the relationship on all the fields of a given table. Relation to a field that have extended datatype can be found out but not the other relations(by using datafield relationobject). Please help me out. Thanks VM [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] store retrieve values in/from xml
Hi
use XMLDocument class in Axapta
if u know Xml format in advance , u can get the values of the tag by using
getElementByTagName
say for suppose XML is
say for suppose u have table with EmployeeTable with EmpId and Name as fields..
Data
EmpDetails
EmpId4063/EmpId
NameSreenath/Name
/EmpDetails
EmpDetails
EmpId4063/EmpId
NameSreenath/Name
/EmpDetails
/Data
code will ne similar to this
xmldocument xmldoc;
EmployeeTable emptable;
;
xmldoc = xmldocument();
u have to load xml
xmldoc.load(path);// from where u want to load xml
//now if u want to insert the XML data in to table..
emptable.EmpId = xmldoc.getElementByTagName(EmpId).item(0).text();
emptable.Name = xmldoc.getElementByTagName(Name).item(0).text();
empltable.insert();
i am not sure about the syntax as i am mailing from home..i am not infront of Axapta.
the tag name and the getelementbytagname shud be simliar and its case sensitive..
in tha above XML it has two records...
For Multiple Record insertion in the table.
inorder to do that u have to get the count of childs in the tagnames..
like..
int xmlchildrencount = xmldoc.getElementByTagName(EmpDetails).item(0).childnodes().count();//Not sure of the syntax..u can find it out
the u can loop thru as many records..
for(i = 0;i = xmlchildrencount ; i++)
{
emptable.EmpId = xmldoc.getElementByTagName(EmpId).item(0).text();
emptable.Name = xmldoc.getElementByTagName(Name).item(0).text();
empltable.insert();
}
if u want clear working ...in.out XML..i shall give u tomorrow ..
[EMAIL PROTECTED] wrote:
Hi,
i want to store some values in xml and retrieve it. how to do? provide the
solution. thank u.
regs,
Hema. S
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
-
Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1cent;/min.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course
Business to business finance
Small business finance
Business finance consultant
Business finance magazine
Business finance schools
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Please answer me...
true..u have to make the control auto decalraytion as Yes Mallikarjun Gudidevuni [EMAIL PROTECTED] wrote: hi, For any control, if u want to use in X++, u need to set the AutoDeclaration property to yes. 1. say the textfields are txt1 and txt2 and the button is button1 the code is like this if(txt1.text() txt2.text()) button1.enable(true); else button1.enable(false); Dipankar Paul [EMAIL PROTECTED] wrote: Hi all, I need your help for these queries,i have a table and a form with some control button in it.Now i want to access these button using X++ code.. Eg, 1) Suppose there are two text fields and a button.If i enter some text in the those fields then only the button should get activated. 2) Suppose, there are two tabs(Not two tab pages) in the single form i.e Login form for student administrator ,when the student text area is selected the administrator text area should be deactiveted vise versa. Student Admin Name:: Name:: Reg No:: Password:: | ok | | ok | Please,help me out how to define and declare a class and access the controls on the form .As i am very new to this field,your reply with some sample code will highly be appreciated. Thank Regards Dipankar, Bangalore,India +919886267931. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Yahoo! Mail goes everywhere you do. Get it on your phone. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Hide company
Try using xDataArea class. check the method hasaccess() check the functionality of that class..probably it will give u a soultion. Alfonso Collados Arroyo [EMAIL PROTECTED] wrote: Hi all, I want to create a company, but I want that this company doesn't appear to be chosen. How can I do this? Best regards, Alfonso -- This e-mail and any attachments are confidential. If you are not the named or intended recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose or store or copy the information in any medium. Any unauthorized disclosure, use or storage is prohibited and might be unlawful. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Get amazing travel prices for air and hotel in one click on Yahoo! FareChase [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Re: Changing Class Methods without opening class
Hi,
try using xppsource class, check editmethod() and editMethodWithClass() methods in that class..
Regards,
sreenath Reddy G
sreenath reddy
hoo.co.in cc:
Subject: Changing Class Methods without opening class
05/10/2006
06:54 PM
Hi,
use classBuild class
it will create a new class in axapta thru code.
u can try this.
static void createnewClass(Args _args)
{
ClassBuild newClassBuild;
ClassName className;
;
ClassName = MyNewClass;
newClassBuild = new ClassBuild(ClassName);
newClassBuild.addMethod(method1, void method1(){\n str hello;});
newClassBuild.addMethod(method2, void method2(){\n str helloworld;});
newClassBuild.classNode().AOTcompile(1);
}
NOW,IF U WANT TO CHANGE METHOD U CAN JUST CHANGE THE CODE like
newClassBuild.addMethod(method2, void method2(){\n str madam;});
now it will just overwrite the code existing in method2()..
sreenath Reddy
Sreenath Reddy G
System Analyst,
Sonata Software Ltd.
1/4, APS Trust Building,
N. R. Colony, Bull Temple Road,
Bangalore-560019.
Mobile-+9886331041
Yahoo! Mail goes everywhere you do. Get it on your phone.
-
Get amazing travel prices for air and hotel in one click on Yahoo! FareChase
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course
Business to business finance
Small business finance
Business finance consultant
Business finance magazine
Business finance schools
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] How to know current configuration
Hi, try this
static void currentConfiguartion(Args _args)
{
AOSSessionInfo info = new AOSSessionInfo();
SqlSystem SqlSystem = new SqlSystem();
;
print xinfo::componentName();
print xinfo::configuration();
print xinfo::dbName();
print xinfo::licenseName();
print xinfo::releaseVersion();
print info.clientMode();
print SqlSystem.loginConnectString();
pause;
}
regards,
sreenath Reddy
Sreenath Reddy G
System Analyst,
Sonata Software Ltd.
1/4, APS Trust Building,
N. R. Colony, Bull Temple Road,
Bangalore-560019.
Mobile-+9886331041
-
Blab-away for as little as 1¢/min. Make PC-to-Phone Calls using Yahoo! Messenger with Voice.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course
Business to business finance
Small business finance
Business finance consultant
Business finance magazine
Business finance schools
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] adding lines within the class method without opening the class
Hi,
use classBuild class
it will create a new class in axapta thru code.
u can try this.
static void createnewClass(Args _args)
{
ClassBuild newClassBuild;
ClassName className;
;
ClassName = MyNewClass;
newClassBuild = new ClassBuild(ClassName);
newClassBuild.addMethod(method1, void method1(){\n str hello;});
newClassBuild.addMethod(method2, void method2(){\n str helloworld;});
newClassBuild.classNode().AOTcompile(1);
}
NOW,IF U WANT TO CHANGE METHOD U CAN JUST CHANGE THE CODE like newClassBuild.addMethod(method2, void method2(){\n str madam;});
now it will just overwrite the code existing in method2()..
sreenath Reddy
[EMAIL PROTECTED] wrote:
Hi,
how to add lines within the class method in a particular line without
opening the class?
Ex:
-
i have a class called 'Class1'. it has more than one method like 'Method1',
'Method2', etc.
let us assume, Method2 has 5 lines of code. i want to add some lines before
the 4th line without opening the class method. through coding (ex: from
job), i want to add. How do i do this?
from job, i can open the specified line of code in the Method2 and i can
also change the source code of the Method2. but, entire existing code is
removed and new one is added. but. i want the specified line of code will
be appended with existing one.
pls. provide the solution. Thank u.
regs,
Hema. S
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
Sreenath Reddy G
System Analyst,
Sonata Software Ltd.
1/4, APS Trust Building,
N. R. Colony, Bull Temple Road,
Bangalore-560019.
Mobile-+9886331041
-
Yahoo! Mail goes everywhere you do. Get it on your phone.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course
Business to business finance
Small business finance
Business finance consultant
Business finance magazine
Business finance schools
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Re: Stored Procedure thru X++
Hi here is the code to implement stored procedure thru x++
static void storedProcedure(Args _args)
{
LogInProperty Lp = new LogInProperty();
OdbcConnection myConnection;
Statement myStatement;
ResultSet myResult;
;
LP.setServer(2020);//Set ur server
LP.setDatabase(MatrixSSI);//set ur database
Lp.setUsername(sa);//set user
Lp.setPassword(sa);//set password
try
{
myConnection = new OdbcConnection(LP);
}
catch
{
info(Check username/password.);
return;
}
myStatement = myConnection.createStatement();
myResult = myStatement.executeQuery('EXEC [your stored procedure]');
while (myResult.next())
{
print myResult.getString(1);
}
pause;
}
regards,
sreenath Reddy
Brandon George [EMAIL PROTECTED] wrote:
All,
Here is the blog entry for executing a Stored Procedure through X++:
http://dynamics-ax.blogspot.com/2006/01/execute-dts-package-from-x.html
thanks,
Brandon
-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of chuapatrickd
Sent: Tuesday, May 09, 2006 10:37 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: Stored Procedure
Hi Brandon,
I can't find it, can you just send me the direct link on the stored
procs routine ?
Thanks,
Patrick
--- In Axapta-Knowledge-Village@yahoogroups.com, Brandon George
[EMAIL PROTECTED] wrote:
Check out my blog: http://dynamics-ax.blogspot.com
I wrote a post on how to do this. If you can't find it let me know
and I can send you the direct link.
Thanks,
Brandon
-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-
[EMAIL PROTECTED] On Behalf Of chuapatrickd
Sent: Tuesday, May 09, 2006 8:32 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Stored Procedure
Hi to all,
I want to call an sql stored procedure in SQL
database FILE_SERVER1,
the name of the stored procedure is consolidate_invoice, is it
possible to call this from within x++ code ?
If it is, can anyone give me sample code ?
It is advisable to do this? or is there any other suggestion.
Thanks,
Patrick Chua
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools
-
YAHOO! GROUPS LINKS
Visit your group Axapta-Knowledge-Village on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
-
Sreenath Reddy G
System Analyst,
Sonata Software Ltd.
1/4, APS Trust Building,
N. R. Colony, Bull Temple Road,
Bangalore-560019.
Mobile-+9886331041
-
Blab-away for as little as 1¢/min. Make PC-to-Phone Calls using Yahoo! Messenger with Voice.
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
Business finance course
Business to business finance
Small business finance
Business finance consultant
Business finance magazine
Business finance schools
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Problem in Document Handling
Hi, u can refer these tables docuref,docuvalue ,docutype,docutable. we can do it programatically also..first try checking in these tables how records are getting inserted.u can check the file name,type ,in the docuvalue table.And for the particular document the value recid in the docuvale will be reffered in the docuref table.The record id what so ever while attaching a document will be the ref recid in the docuref table. The error what ur facing is due to initial setup for the document handling.u have to setup the paramaters and then u have to enable for which table in database u want document handling. if ur still facing the same problem..i shall help u how to do it programatically. sreenath Reddy compashi1 [EMAIL PROTECTED] wrote: Hi, I have a problem in attaching a document to a record in Axapta 3.0. I set Basic à Setup à Document Management à Document Types à General à Document Location to `Database'. But when I try to attach a document , it throws an error The file cannot be saved in the database as it is currently locked. But the `Attached' status is checked to true and I am able to open the file again but the location from which it loads seems to be C:\Documents Settings\...\ My question is why is that I am getting this error? If it is stored in database what's the table I should be looking for? What other tables need to be modified? Is there a way to do this programmatically? Any help or pointer to the above problem is highly appreciated. If you have any query or explanation please let me know. Thanks, ashish singh SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange - YAHOO! GROUPS LINKS Visit your group development-axapta on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Sreenath Reddy G System Analyst, Sonata Software Ltd. 1/4, APS Trust Building, N. R. Colony, Bull Temple Road, Bangalore-560019. Mobile-+9886331041 - Love cheap thrills? Enjoy PC-to-Phone calls to 30+ countries for just 2¢/min with Yahoo! Messenger with Voice. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Regarding Axapta Certification
Hello Guys, I want to take certification in Axapta.Can u guys help me out in the Faq's in Axapta Certification Thanx and regards sreeSreenath Reddy G System Analyst, Sonata Software Ltd. 1/4, APS Trust Building, N. R. Colony, Bull Temple Road, Bangalore-560019. Mobile-+9886331041 Yahoo! FareChase - Search multiple travel sites in one click. Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
