[Axapta-Knowledge-Village] Urgent!!!strange behaviour in AX 2009 for printing a report in batch process

[giridharraj]

Hi,

I have designed a batch job where it prints a report as a pdf file to the file 
system and then mails it.
Initially because of the company logo in the report i was getting empty report 
then When I removed it then still Sometimes I am getting empty reports which of 
650 bytes but for that it has data in the database.
Has anybody come across with such a problem. If so or if anybody knows any 
reason for this behaviour then please help me.

Thanks and regards
Giridhar Raj.

[Axapta-Knowledge-Village] Urgent!!!!!Invoice Address for a Sales order.

[giridharraj]

Hi,

What address will a sales order consider from a customer during invoicing.

I think, Initially It will check its invoice address and if it is not filled in 
then it will consider its primary address.
Am I correct or am i missing anything

Please give me a reply. Its urgent

Regards,
giridhar Raj.

[Axapta-Knowledge-Village] get back order lines for a customer through code(sql statement)(inventtrans tabl

[giridharraj]

hi, 

Can anyone help me in getting back order sales lines for a customer through 
codei.e., from inventtrans table i guess

A simple sql statement is enough. Its urgent Please help me...

Thanks and Regards,
Giridhar Raj.

[Axapta-Knowledge-Village] strange behaviour in AX 2009 for printing a report in batch process

[giridharraj]

Hi,

I have done a batch job to print a report as a pdf file and then email it. 

It has worked on my server.

But when I have tried to do at the customer place, I have observed a strange 
behaviour, Even though the data exists, it is printing a empty report when it 
through a batch process  which is a 660 bytes reportand when I run it from the 
client I am getting the report for the same data which is of 63kb. 

I have checked the whole configuration but still couldn't get what the problem 
is..

Has anyone faced the same problem... If so Please provide me a solution 
immediately...Its Urgent

Thanks and Regards
Giridhar Raj.

[Axapta-Knowledge-Village] Re: pack and unpack a query object

[giridharraj]

Thanks alot for ur help HarryI got it.:)
--- In Axapta-Knowledge-Village@yahoogroups.com, Harry Deshpande  
wrote:
>
> public boolean unpack(container packedClass)
> {
> Integer version= conpeek(packedClass,1);
> container   packedQuery;
> container   base;
> 
> switch (version)
> {
> case #CurrentVersion:
> [version,base,packedQuery] = packedClass;
> super(base);
> if (packedQuery && conlen(packedQuery) == 1)
> {
> query = new QueryRun(packedQuery);
> }
> break;
> default:
> return false;
> }
> return true;
> }
> 
> From: Axapta-Knowledge-Village@yahoogroups.com 
> [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of giridharraj
> Sent: Tuesday, February 09, 2010 11:13 PM
> To: Axapta-Knowledge-Village@yahoogroups.com
> Subject: [Axapta-Knowledge-Village] pack and unpack a query object
> 
> 
> 
> Hi,
> 
> I have seen a method query.pack() which returns a container. Is there any 
> method which unpacks it i.e., converts back to a query object because i 
> didn't find query.unpack().
> 
> Simply I want a method which converts a query object to a container and that 
> container to be converted into a query object.
> 
> Can anybody help me in this...
> 
> Regards,
> giridhar Raj.
>

[Axapta-Knowledge-Village] pack and unpack a query object

[giridharraj]

Hi,

I have seen a method query.pack() which returns a container. Is there any 
method which unpacks it i.e., converts back to a query object because i didn't 
find query.unpack().

Simply I want a method which converts a query object to a container and that 
container to be converted into a query object.

Can anybody help me in this...

Regards,
giridhar Raj. 

[Axapta-Knowledge-Village] Urgent: Batch Job Scheduling error.....

[giridharraj]

Hi,

I am getting an error. I want a job to be executed periodically. So I have 
created a new class and extended it to runbasebatch. In the main method i have 
called classname = new classname() and then called run method of that class.

Then the run method calls my method. 

I have given cangoBatchJournal as true,runasimpersonated as true and kept pack 
and unpack methods. I don't get any when I execute that class directly and it 
perfectly executed But when I have assigned it to a batch job.I am getting 
error.

Can anyone of you, tell me y I am getting that error...

Regards,
Giridhar Raj.

[Axapta-Knowledge-Village] composite query in AX through code

[giridharraj]

Hi,
How to implement a composite query in AX through code

Regards,
giridhar Raj.

[Axapta-Knowledge-Village] how to add same field into qbds by getting AND condition instead of OR in debugg

[giridharraj]

Hi,

I have a problem..

I take salestable in qbds
and add range as delivery date with value in between 19/12/2008 to 20/12/2009
and again when i add the same range with a value equal to 15/12/2009 then the 
query is changing.

Like i need the query as 
select * from salestable where ((DeliveryDate >=19/12/2008) && (DeliveryDate 
<=20/12/2009)) AND DeliveryDate== 15/12/2009

but in the debugger when i check the qbds it is showing as follows :
select * from salestable where ((DeliveryDate >=19/12/2008) && (DeliveryDate 
<=20/12/2009)) OR DeliveryDate== 15/12/2009

So, Please help me in solving this. What do i need to give at qbds or qbr to 
get AND condition instead of OR.

Thanks and regards,
giridhar Raj.

[Axapta-Knowledge-Village] phonetic and fuzzy search in AX through code

[giridharraj]

Hi,

Can anyone give me an idea on how can i do phonetic and fuzzy search through 
code in AX. For Ex> If i get  an input string as bimal, i need to get the 
records like vimal,kimal,bical etc.,it must work like google search, the way it 
shows the records when we type.

Regards,
Giridhar Raj. 

[Axapta-Knowledge-Village] Re: regarding multilanguage capabilities of a label file for errors through code

[giridharraj]

Hi guyz,

I got it. for this we can use syslabel class and perform the fuctionality.
Regards,
giridhar raj.

--- In Axapta-Knowledge-Village@yahoogroups.com, "giridharraj" 
 wrote:
>
> Hi,
> 
> I want to put few error messages in label file and access those error 
> messages wrt the language that i give through code but not as of AX user 
> language. For ex: If i get a language id as EN-US as my input. and if there 
> is any error then I need to send back the error message in English, Can 
> anyone help me in how to proceed for this type of functionality...
> 
> thanks and regards,
> Giridhar Raj.
>

[Axapta-Knowledge-Village] regarding multilanguage capabilities of a label file for errors through code

[giridharraj]

Hi,

I want to put few error messages in label file and access those error messages 
wrt the language that i give through code but not as of AX user language. For 
ex: If i get a language id as EN-US as my input. and if there is any error then 
I need to send back the error message in English, Can anyone help me in how to 
proceed for this type of functionality...

thanks and regards,
Giridhar Raj.

[Axapta-Knowledge-Village] Re: generate sales invoice report through code and save as pdf file in file system.

[giridharraj]

Thanks alot Michael. You have helped me alot.

--- In Axapta-Knowledge-Village@yahoogroups.com,  wrote:
>
> Hi,
> 
> try CustInvoiceJour.printJournal()
> 
> static void printInvoice(Args _args)
> {
> SalesFormletter SalesFormletter;
> printJobSettingsprintJobSettings;
> CustInvoiceJour CustInvoiceJour;
> ;
> SalesFormletter = 
> SalesFormletter::construct(DocumentStatus::Invoice,false);
> 
> printJobSettings = new printJobSettings();
> printJobSettings.setTarget(PrintMedium::File);
> printJobSettings.format(PrintFormat::PDF);
> printJobSettings.fileName(@'H:\Temp\Test.pdf');
> 
> 
> SalesFormletter.updatePrinterSettingsFormLetter(printJobSettings.packPrintJobSettings());
> 
> Select CustInvoiceJour Where CustInvoiceJour.SalesId == 'SO-101247';
> 
>     CustInvoiceJour.printJournal(SalesFormletter);
> }
> 
> Best regards
> Michael
> 
> 
> From: giridharraj 
> Sent: Thursday, December 03, 2009 11:36 AM
> To: Axapta-Knowledge-Village@yahoogroups.com 
> Subject: [Axapta-Knowledge-Village] generate sales invoice report through 
> code and save as pdf file in file system.
> 
> 
>   
> Hi,
> 
> I have written the following code to generate a sales invoice report and save 
> as a pdf file in the file system. But this code is not saving the report as 
> pdf instead it is displaying the report on the screen. can anyone correct 
> this code..
> 
> CustInvoiceJour InvJTbl;
> SalesId Id;
> ReportRun report;
> SalesFormLetter_Invoice SalesFormLetter = new SalesFormLetter_Invoice(false);
> RecordSortedList List = new RecordSortedList(62);
> 
> Id = "SO-123";
> 
> Select InvJTbl Where InvJTbl.SalesId == Id;
> List.ins(InvJTbl);
> report = new ReportRun(new Args(ReportStr(SalesInvoice)));
> report.args().caller(SalesFormLetter);
> report.args().parmEnum(1);
> report.args().parmEnumType(920);
> report.args().object(List);
> report.args().name("KeepSettings");
> report.printJobSettings().setTarget(PrintMedium::File);
> report.printJobSettings().format(PrintFormat::PDF);
> report.printJobSettings().fileName("C:\\Temp\\Test.pdf");
> report.prompt();
> SalesFormLetter.updatePrinterSettingsFormLetter(report.packPrintJobSettings());
> report.run();
>

[Axapta-Knowledge-Village] generate sales invoice report through code and save as pdf file in file system.

[giridharraj]

Hi,

I have written the following code to generate a sales invoice report and save 
as a pdf file in the file system. But this code is not saving the report as pdf 
instead it is displaying the report on the screen. can anyone correct this 
code..

CustInvoiceJour InvJTbl;
SalesId Id;
ReportRun report;
SalesFormLetter_Invoice SalesFormLetter = new SalesFormLetter_Invoice(false);
RecordSortedList List = new RecordSortedList(62);

Id = "SO-123";

Select InvJTbl Where InvJTbl.SalesId == Id;
List.ins(InvJTbl);
report = new ReportRun(new Args(ReportStr(SalesInvoice)));
report.args().caller(SalesFormLetter);
report.args().parmEnum(1);
report.args().parmEnumType(920);
report.args().object(List);
report.args().name("KeepSettings");
report.printJobSettings().setTarget(PrintMedium::File);
report.printJobSettings().format(PrintFormat::PDF);
report.printJobSettings().fileName("C:\\Temp\\Test.pdf");
report.prompt();
SalesFormLetter.updatePrinterSettingsFormLetter(report.packPrintJobSettings());
report.run();

[Axapta-Knowledge-Village] regarding number sequence group

[giridharraj]

Hi,

I have attached a number sequence group to a customer id. I have also specified 
the number sequences for sales order for those number sequence groups. But when 
I raise a sales order for a particular customer. The sales order number is 
different from the sequence group i attached to the customer.

How can I solve this? I have attached the number sequence for sales order for 
both the groups. Now,which number sequence do i need to attach in the 
parameters of accounts receivable for the sales order.

thanks and regards,
giridhar raj.

[Axapta-Knowledge-Village] Re: dynamically insert the data into table

[giridharraj]

Hi anil,

If I want to dynamically update a table. Can u suggest me anyway to approach it 
like as u did for insert using 
CommonTable = dictTable.makeRecord();

Thanks and regards,
giridhar Raj.

--- In Axapta-Knowledge-Village@yahoogroups.com, "axaptadeveloper" 
 wrote:
>
> Hi Giridhar,
> 
> You can use anytype for reflection. This is the best approach. I'm happy for 
> save your time.
> 
> DictTable   DictTable;
> Common  CommonTable;
> 
> TableName tablename = "AddressCountryRegion";
> 
> FieldName fieldname = "CountryRegionId";
> fieldName fieldName2 = "Type";
> 
> Anytype countryname = "A Country";
> AnyType countryType = CountryRegionType::EU;
> ;
> 
> DictTable = new DictTable(tablename2id(tablename));
> CommonTable = dictTable.makeRecord();
> CommonTable.(fieldname2id(DictTable.id(),fieldname)) = countryname;
> CommonTable.(fieldname2id(DictTable.id(),fieldname2)) = countryType;
>     
> CommonTable.insert();
> 
> Best Regards,
> 
> Anil OZAY
> 
>  
> 
> --- In Axapta-Knowledge-Village@yahoogroups.com, "giridharraj"  
> wrote:
> >
> > Hi Anil,
> > 
> > Thanks alot.It has worked and you have saved my time by replying promptly. 
> > I have one more doubt, as I am inserting the data dynamically, how can i 
> > change the value's datatype dynamically. i.e.,
> > If we take the below example and the if the field type is a date,int or 
> > real datatype then is there any possibility to convert the datatype of the 
> > value which is a string type dynamically according to the datatype of the 
> > field.
> > 
> > Regards,
> > Giridhar raj. 
> > 
> > --- In Axapta-Knowledge-Village@yahoogroups.com, "axaptadeveloper" 
> >  wrote:
> > >
> > > Hi,
> > > 
> > > This is the sample code :
> > > 
> > > DictTable   DictTable;
> > > Common  CommonTable;
> > > TableName tablename = "AddressCountryRegion";
> > > FieldName fieldname = "CountryRegionId";
> > > str value = "Turkey";
> > > ;
> > > DictTable = new DictTable(tablename2id(tablename));
> > > CommonTable = dictTable.makeRecord();
> > > CommonTable.(fieldname2id(DictTable.id(),fieldName)) = value;
> > > CommonTable.insert();
> > > 
> > > Regards,
> > > 
> > > Anil OZAY
> > > 
> > > --- In Axapta-Knowledge-Village@yahoogroups.com, "giridharraj" 
> > >  wrote:
> > > >
> > > > Hi,
> > > > 
> > > > I want to dynamically insert the data into a table through code by 
> > > > getting the table name, fieldnames and its values to be inserted.
> > > > 
> > > > For ex :
> > > > 
> > > > tablename.field = value;
> > > > tablename.insert();
> > > > 
> > > > Here the tablename,field and value are variables.all the variables 
> > > > takes the values dynamically.
> > > > 
> > > > Is the above thing possible in X++.
> > > > 
> > > > Thanks and Regards,
> > > > Giridhar Raj.
> > > >
> > >
> >
>

[Axapta-Knowledge-Village] calc sales Line Amount including Sales Tax ,Discounts and Misc. charges

[giridharraj]

Hi,

Can anyone help me in calculating the Line amount of a sales line which 
includes net amount+SalesTax+Discounts+Misc. Charges through code else tell me 
where can i get this on sales order form.

Regards,
Giridhar raj.

[Axapta-Knowledge-Village] Re: Number series

[giridharraj]

thanx alot Manish, It has worked.

--- In Axapta-Knowledge-Village@yahoogroups.com, manish saxena 
 wrote:
>
> Hi GirigharRaj,
>  
> If u go to number sequence form, there is a group button, select sales id and 
> click group, there u can define group, and related to each group, you can 
> define different number sequence.
> On sales order> setup tab, there u can define number sequence group, so 
> whatever, you have choosen the number sequence group, on the basis of that, 
> system will generate the sales order id.
> Hope, it helps...
>  
> Regards
> Manish
> 
> --- On Thu, 19/11/09, giridharraj  wrote:
> 
> 
> From: giridharraj 
> Subject: [Axapta-Knowledge-Village] Re: Number series
> To: Axapta-Knowledge-Village@yahoogroups.com
> Date: Thursday, 19 November, 2009, 3:17 PM
> 
> 
>   
> 
> 
> 
> 
> Hi Manish,
> 
> How can we give attach two number sequences to a sales id in the same 
> company? 
> 
> Thanks and regards,
> Giridhar raj.
> --- In Axapta-Knowledge- vill...@yahoogro ups.com, manish saxena 
>  wrote:
> >
> > Hi Giridhar,
> > You can use the functionality of Number Sequence group, create 2 number 
> > sequnece group, one for Ax and one for web.
> > In their corresponding number sequnec group, attach the number sequence, 
> > you want, like for numbersequnece group for Ax, attach the numbersequence 
> > for Ax and for web, attach number sequence of web for NumberSequence group.
> >  
> > When you are creating sales order, pass the appropraite numbersequence 
> > group to the sales table.
> > 
> > 
> > --- On Tue, 17/11/09, giridharraj  wrote:
> > 
> > 
> > From: giridharraj 
> > Subject: [Axapta-Knowledge- Village] Number series
> > To: Axapta-Knowledge- vill...@yahoogro ups.com
> > Date: Tuesday, 17 November, 2009, 11:21 AM
> > 
> > 
> >   
> > 
> > 
> > 
> > Hi,
> > 
> > Do we have any option in Ax to give different number series for the sales 
> > order id in a single company.For Ex: I want to give SO_X as sales order 
> > id if the sales order is raised from AX client and WSO_ if the sales 
> > order is raised from Web for the same company(DAT) . If there is any, 
> > please let me know the process.
> > 
> > Thanks and Regards,
> > Giridhar Raj.
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. 
> > http://in.yahoo. com/
> >
> 
> 
> 
> 
> 
> 
> 
> 
> 
>   The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. 
> http://in.yahoo.com/
>

[Axapta-Knowledge-Village] VAT for a sales Order(Calculation of sales price of an item with VAT)

[giridharraj]

Hi,

Can anyone tell me where can i see the VAT for a sales order and can anyone 
tell me where can i get a method in sales line from which i can get the sales 
price of an item with VAT and for the whole sales order.

Thanks and regards,
giridhar raj

[Axapta-Knowledge-Village] Re: how to represent not equal to symbol in query build

[giridharraj]

Hi,

ya, that is ok if not empty string but wat if i want to put for not equal to a 
value.Bcoz query build is not considering != symbol.i.e.,

str test;
test ='1100';
qbr.value(strfmt('%1 != %2',contact.custaccount,test)

Regards,
Giridhar Raj.

--- In Axapta-Knowledge-Village@yahoogroups.com, Anitha S  
wrote:
>
> Hi,
> 
> Check if it works..
> 
> try with SysQuery in Value.
> for eg.,
> Qbr.value(SysQuery::valueNotEmptyString()); -- this checks value is not
> equal to null.
> 
> Hope it helps.
> 
> Regards,
> Anitha
> On Fri, Nov 20, 2009 at 2:59 PM, giridharraj  wrote:
> 
> >
> >
> > Hi,
> >
> > Can anyone tell me how to put NOT EQUAL TO symbol in query build. Because
> > the below query is not working for me.
> >
> > str test;
> > test ='';
> > qbr.value(strfmt('%1 != %2',contact.custaccount,test)
> >
> > Regards,
> > Giridhar Raj.
> >
> > 
> >
>

[Axapta-Knowledge-Village] how to represent not equal to symbol in query build

[giridharraj]

Hi,

Can anyone tell me how to put NOT EQUAL TO symbol in query build. Because the 
below query is not working for me. 

str test;
test ='';
qbr.value(strfmt('%1 != %2',contact.custaccount,test)

Regards,
Giridhar Raj.

[Axapta-Knowledge-Village] retrieving records by paging

[giridharraj]

Hi,

Is there any possibility in Ax to get the records from a table set by set 
i.e.,first 15 records one time, next 15 records other time and so on..

Regards,
Giridhar Raj.

[Axapta-Knowledge-Village] Re: Number series

[giridharraj]

Hi Manish,

How can we give attach two number sequences to a sales id in the same company? 

Thanks and regards,
Giridhar raj.
--- In Axapta-Knowledge-Village@yahoogroups.com, manish saxena 
 wrote:
>
> Hi Giridhar,
> You can use the functionality of Number Sequence group, create 2 number 
> sequnece group, one for Ax and one for web.
> In their corresponding number sequnec group, attach the number sequence, you 
> want, like for numbersequnece group for Ax, attach the numbersequence for Ax 
> and for web, attach number sequence of web for NumberSequence group.
>  
> When you are creating sales order, pass the appropraite numbersequence group 
> to the sales table.
> 
> 
> --- On Tue, 17/11/09, giridharraj  wrote:
> 
> 
> From: giridharraj 
> Subject: [Axapta-Knowledge-Village] Number series
> To: Axapta-Knowledge-Village@yahoogroups.com
> Date: Tuesday, 17 November, 2009, 11:21 AM
> 
> 
>   
> 
> 
> 
> Hi,
> 
> Do we have any option in Ax to give different number series for the sales 
> order id in a single company.For Ex: I want to give SO_X as sales order 
> id if the sales order is raised from AX client and WSO_ if the sales 
> order is raised from Web for the same company(DAT) . If there is any, please 
> let me know the process.
> 
> Thanks and Regards,
> Giridhar Raj.
> 
> 
> 
> 
> 
> 
> 
> 
> 
>   The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. 
> http://in.yahoo.com/
>

[Axapta-Knowledge-Village] convert sales quotation to sales order through code

[giridharraj]

Hi,

Can anyone give me a solution on converting a sales quotation to sales order 
through code?

Thanks and regards,
Giridhar Raj.

[Axapta-Knowledge-Village] Number series

[giridharraj]

Hi,

Do we have any option in Ax to give different number series for the sales order 
id in a single company.For Ex: I want to give SO_X as sales order id if the 
sales order is raised from AX client and WSO_ if the sales order is raised 
from Web for the same company(DAT). If there is any, please let me know the 
process.

Thanks and Regards,
Giridhar Raj.

[Axapta-Knowledge-Village] Difference between salesbasket, salesquotationbasket and salesorder

[giridharraj]

Hi,

can anyone tell me the concept and difference between 
Salesbasket,salesquotationbasket,salesorder,salesbasketline,salesquotationbasketline,salesline,salesquotationline
 tables in Axapta? If I place some qty for an item, the inventory availability 
must reduce, in which table will this happen (either salesbasketline or 
salesquotationbasketline or salesquotationline)? Please give me a solution for 
this problem.

Thanks and Regards,
Giridhar Raj.

[Axapta-Knowledge-Village] Re: put enum value into qbds dynamically

[giridharraj]

Thanks alot anitha, it has suited my requirement.
--- In Axapta-Knowledge-Village@yahoogroups.com, Anitha S  
wrote:
>
> Hi,
> 
> Chk if this suits ur requirement.
> 
> QueryBuildDataSource qbds;
> QueryBuildRange qbr;
> str   fieldEnum ;
> 
> qbds =  this.query().datasourcetable(TABLENAME);
> qbr   =  qbds.addrange(fieldnum(TABLENAME,FIELDNAME) ;// Assume this field
> is ENUM
> 
> fieldEnum = FormStrContrl..valuestr(); // Get the value for the Enum field
> from form @ runtime
> qbr.value(fieldEnum);  // Assign the runtime value
> 
> 
> hope this helps..
> 
> Regards,
> Anitha
> 
> 
> 
> On Tue, Nov 10, 2009 at 11:10 PM, giridharraj  wrote:
> 
> >
> >
> > Hi,
> >
> > I would like to get the enum value which is actually in a string into query
> > build value dynamically.i.e.,for ex:
> > str value;
> > value = 'Delivered'
> > fieldName = 'Salesstatus'
> >
> > These are the values that i get during the process.I came to know that to
> > put enum values in querybuild value we need to write like this:
> >
> > queryBuildRange.value(strFmt('(ItemType == %1)',
> > any2int(ItemType::Service)));
> >
> > But in my case as I get the fieldname and value at runtime, i cannot write
> > like the above one. So, please suggest me a solution to assign enum value
> > dynamically into qbds and also to get enum type wrt the field name in a
> > table.
> >
> > Thanks and Regards,
> > Giridhar raj.
> >
> > 
> >
>

[Axapta-Knowledge-Village] put enum value into qbds dynamically

[giridharraj]

Hi,

I would like to get the enum value which is actually in a string into query 
build value dynamically.i.e.,for ex:
str value;
value = 'Delivered'
fieldName = 'Salesstatus'

These are the values that i get during the process.I came to know that to put 
enum values in querybuild value we need to write like this:

queryBuildRange.value(strFmt('(ItemType == %1)', any2int(ItemType::Service)));

But in my case as I get the fieldname and value at runtime, i cannot write like 
the above one. So, please suggest me a solution to assign enum value 
dynamically into qbds and also to get enum type wrt the field name in a table.

Thanks and Regards,
Giridhar raj.

[Axapta-Knowledge-Village] create a customer in custtable through code and create a record in global addres

[giridharraj]

Hi,

I need to create a record in customer table through code. Please tell me the 
necessary steps to be taken to do that before insertion like what methods do i 
need to call before insertion? How to create a address,contact person details, 
etc., for the customer in global address book and generate party id during 
inserting a record for a customer. Please tell me a complete solution during 
creation of a customer record through code.

Thanks and regards,
Giridhar Raj.

[Axapta-Knowledge-Village] Re: conversion of xml object

[giridharraj]

Hi sumit, 

I am using System.Xml.XmlDocument, still I am getting that error. I dont want 
to convert into string and exchange because it will decrease the performance. I 
directly want to exchange the xml objects.

Thanks and regards,
Giridhar Raj 

--- In Axapta-Knowledge-Village@yahoogroups.com, Sumit Loya  
wrote:
>
> Hi,
> 
> If it is a dot net method that you are accessing, it is highly probable that
> the method takes an object of type System.Xml.XmlDocument as input and is
> also returning System.Xml.XmlDocument as output.
> 
> Try passing / receiving an object of type System.Xml.XmlDocument.
> 
> Note: Ax's XmlDocument class is a different object that
> System.Xml.XmlDocument.
> 
> Regards,
> Sumit Loya
> 
> On Mon, Nov 9, 2009 at 12:44 PM, giridharraj  wrote:
> 
> >
> >
> > Hi,
> > I am accessing a method in a AX class from dot net directly which takes an
> > xml document object as a parameter and it should also return xml document
> > object. I have done that but the problem is the dot net couldn't recognize
> > AX xml object and even AX couldn't read dot net XML object. It gives me some
> > xml object cast error. Please tell me how to convert an Ax xml object into
> > dot net xml object and vice versa. Please give me some solution.
> >
> > Thanks and Regards,
> > Giridhar Raj.
> >
> > 
> >
>

[Axapta-Knowledge-Village] conversion of xml object

[giridharraj]

Hi,
I am accessing a method in a AX class from dot net directly which takes an xml 
document object as a parameter and it should also return xml document object. I 
have done that but the problem is the dot net couldn't recognize AX xml object 
and even AX couldn't read dot net XML object. It gives me some xml object cast 
error. Please tell me how to convert an Ax xml object into dot net xml object 
and vice versa. Please give me some solution.

Thanks and Regards,
Giridhar Raj.

[Axapta-Knowledge-Village] Re: dynamically insert the data into table

[giridharraj]

Hi Anil,

Thanks alot again

Regards,
giridhar raj.

--- In Axapta-Knowledge-Village@yahoogroups.com, "axaptadeveloper" 
 wrote:
>
> Hi Giridhar,
> 
> You can use anytype for reflection. This is the best approach. I'm happy for 
> save your time.
> 
> DictTable   DictTable;
> Common  CommonTable;
> 
> TableName tablename = "AddressCountryRegion";
> 
> FieldName fieldname = "CountryRegionId";
> fieldName fieldName2 = "Type";
> 
> Anytype countryname = "A Country";
> AnyType countryType = CountryRegionType::EU;
> ;
> 
> DictTable = new DictTable(tablename2id(tablename));
> CommonTable = dictTable.makeRecord();
> CommonTable.(fieldname2id(DictTable.id(),fieldname)) = countryname;
> CommonTable.(fieldname2id(DictTable.id(),fieldname2)) = countryType;
>     
> CommonTable.insert();
> 
> Best Regards,
> 
> Anil OZAY
> 
>  
> 
> --- In Axapta-Knowledge-Village@yahoogroups.com, "giridharraj"  
> wrote:
> >
> > Hi Anil,
> > 
> > Thanks alot.It has worked and you have saved my time by replying promptly. 
> > I have one more doubt, as I am inserting the data dynamically, how can i 
> > change the value's datatype dynamically. i.e.,
> > If we take the below example and the if the field type is a date,int or 
> > real datatype then is there any possibility to convert the datatype of the 
> > value which is a string type dynamically according to the datatype of the 
> > field.
> > 
> > Regards,
> > Giridhar raj. 
> > 
> > --- In Axapta-Knowledge-Village@yahoogroups.com, "axaptadeveloper" 
> >  wrote:
> > >
> > > Hi,
> > > 
> > > This is the sample code :
> > > 
> > > DictTable   DictTable;
> > > Common  CommonTable;
> > > TableName tablename = "AddressCountryRegion";
> > > FieldName fieldname = "CountryRegionId";
> > > str value = "Turkey";
> > > ;
> > > DictTable = new DictTable(tablename2id(tablename));
> > > CommonTable = dictTable.makeRecord();
> > > CommonTable.(fieldname2id(DictTable.id(),fieldName)) = value;
> > > CommonTable.insert();
> > > 
> > > Regards,
> > > 
> > > Anil OZAY
> > > 
> > > --- In Axapta-Knowledge-Village@yahoogroups.com, "giridharraj" 
> > >  wrote:
> > > >
> > > > Hi,
> > > > 
> > > > I want to dynamically insert the data into a table through code by 
> > > > getting the table name, fieldnames and its values to be inserted.
> > > > 
> > > > For ex :
> > > > 
> > > > tablename.field = value;
> > > > tablename.insert();
> > > > 
> > > > Here the tablename,field and value are variables.all the variables 
> > > > takes the values dynamically.
> > > > 
> > > > Is the above thing possible in X++.
> > > > 
> > > > Thanks and Regards,
> > > > Giridhar Raj.
> > > >
> > >
> >
>

[Axapta-Knowledge-Village] string to real conversion in x++

[giridharraj]

Hi,

Can anyone give me an idea on how to convert a value in string datatype to a 
real in x++?

Thanks and Regards,
Giridhar Raj.

[Axapta-Knowledge-Village] Re: AIF File system adapter Inbound Error

[giridharraj]

Hi Santosh,

I tried your suggestion but still I am getting the same error.

Regards,
Giridhar raj.
--- In Axapta-Knowledge-Village@yahoogroups.com, "r_ssh" 
 wrote:
>
> Hi,
> 
> Do the following:
> 
> Right-clicking the folder and selecting Properties. Please add your user with 
> "Full Control" and click Apply.
> 
> Restart your AX Service. Try to perform Inbound operation now and let me know 
> the result.
> 
> Thanks
> Santosh.R
> 
> --- In Axapta-Knowledge-Village@yahoogroups.com, "giridharraj"  
> wrote:
> >
> > Hi,
> > 
> > I am getting an error for AIF Inbound, I have done all the settings still I 
> > am getting the same Error: Cannot be read because the submitting user could 
> > not be determined. The default owner for objects created by members of the 
> > Administrators group must be set to the object creator. 
> > 
> > To avoid the above error I have done the following steps for file system 
> > adapters still I am getting that error.
> > 
> > Before you create the folder for the inbound file system adapter on the 
> > server, complete the following: 
> > 
> > 1.Click Start > Programs > Administrative Tools > Local Security Policy. 
> > 
> > 2.On the Local Security Settings menu, navigate to Security Settings > 
> > Local Policies > Security Options. 
> > 
> > 3.Change the Security Settings for the System Objects: Default owner for 
> > objects created by members of the administrator's group from Adminstrator's 
> > group to Object creator. 
> > 
> > 4.Log off and log back on to the computer. 
> > 
> > 5.Create the folder for the inbound file system transfer. 
> > 
> > 6.Verify that the owner of the folder is the user sending the document to 
> > Microsoft Dynamics AX (the submitting user) by: 
> > 
> > a.Right-clicking the folder and selecting Properties, and then 
> > 
> > b.Clicking Advanced on the Security tab to view the Advanced Security 
> > Settings. 
> > 
> > The owner of the folder is shown on the Owner tab. 
> > 
> >   
> > 
> > Please suggest me solution to avoid that error.
> > 
> > Regards,
> > Giridhar Raj.
> >
>

[Axapta-Knowledge-Village] AIF File system adapter Inbound Error

[giridharraj]

Hi,

I am getting an error for AIF Inbound, I have done all the settings still I am 
getting the same Error: Cannot be read because the submitting user could not be 
determined. The default owner for objects created by members of the 
Administrators group must be set to the object creator. 

To avoid the above error I have done the following steps for file system 
adapters still I am getting that error.

Before you create the folder for the inbound file system adapter on the server, 
complete the following: 

1.Click Start > Programs > Administrative Tools > Local Security Policy. 

2.On the Local Security Settings menu, navigate to Security Settings > Local 
Policies > Security Options. 

3.Change the Security Settings for the System Objects: Default owner for 
objects created by members of the administrator's group from Adminstrator's 
group to Object creator. 

4.Log off and log back on to the computer. 

5.Create the folder for the inbound file system transfer. 

6.Verify that the owner of the folder is the user sending the document to 
Microsoft Dynamics AX (the submitting user) by: 

a.Right-clicking the folder and selecting Properties, and then 

b.Clicking Advanced on the Security tab to view the Advanced Security Settings. 

The owner of the folder is shown on the Owner tab. 

  

Please suggest me solution to avoid that error.

Regards,
Giridhar Raj.

[Axapta-Knowledge-Village] Re: need materials for AX 2009 AIF Integration with external applications

[giridharraj]

Thanx alot anitha it has helped me alot.

Regards,
Giridhar Raj

--- In Axapta-Knowledge-Village@yahoogroups.com, Anitha S  
wrote:
>
> Hi,
> 
> Pls refer to the below link.
> http://sangi1983.spaces.live.com/blog/cns!264A0056CBCBB1D3!345.entry
> 
> It is *Santosh`s Blog* in which he has mentioned about AIF setup.
> The entry is quite informative for beginners..
> 
> More entries about AIF are listed in his blog.
> 
> Hope it helps
> 
> Regards,
> Anitha
> 
> On Tue, Oct 27, 2009 at 5:19 PM, giridharraj  wrote:
> 
> >
> >
> > Hi,
> >
> > Can anybody provide me some kind of material or e-books  for the topics
> > listed in the below link:
> >
> > http://www.microsoft.com/learning/en/us/Course.aspx?ID=50192A&Locale=en-us
> >
> >  or a walkthrough for AIF integration with external applications
> >
> > Regards,
> >
> > Giridhar Raj
> >
> > 
> >
>

[Axapta-Knowledge-Village] import and export data in XML format using AIF framework in AX 2009

[giridharraj]

Hi,

I have got this link on How to  import and export data in XML format
using AIF framework in AX 4.0 http://daxfaq.studioerudit.com/#post6
 .

Can somebody tell me the same in AX 2009 because I couldn't find batch
journal names and batch journal types forms in AX 2009.

Also can anyone tell me on how to call a method in a AX class from an
external application using AIF?

Regards,

Raj.

[Axapta-Knowledge-Village] need materials for AX 2009 AIF Integration with external applications

[giridharraj]

Hi,

Can anybody provide me some kind of material or e-books  for the topics
listed in the below link:

http://www.microsoft.com/learning/en/us/Course.aspx?ID=50192A&Locale=en-\
us


  or a walkthrough for AIF integration with external applications

Regards,

Giridhar Raj

[Axapta-Knowledge-Village] export table structure to XML using AIF

[giridharraj]

Hi,

I need to do a short proto type in which Ax will receive an xml file containing 
a table name and based on that info. the Ax application must send the table 
structure in XML format. This has to be saved in file system. Please help in 
doing this using AIF. I have been trying using AIF but its not working. Please 
help me.

Regards,
Raj