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

2010-03-04 Thread 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

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

2010-02-19 Thread 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

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

2010-02-18 Thread 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

2010-02-17 Thread 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

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

2010-02-10 Thread giridharraj
); } 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

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

2010-02-09 Thread 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

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

2010-01-14 Thread 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

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

2009-12-16 Thread 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

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

2009-12-16 Thread giridharraj
Hi, How to implement a composite query in AX through code Regards, giridhar Raj.

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

2009-12-14 Thread 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] regarding multilanguage capabilities of a label file for errors through code

2009-12-07 Thread 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

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

2009-12-07 Thread 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 giridhar...@... wrote: Hi, I want to put few error messages in label file and access those error messages wrt

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

2009-12-03 Thread 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;

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

2009-12-03 Thread giridharraj
: 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

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

2009-11-27 Thread giridharraj
; CommonTable.insert(); Best Regards, Anil OZAY --- In Axapta-Knowledge-Village@yahoogroups.com, giridharraj 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

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

2009-11-24 Thread 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] VAT for a sales Order(Calculation of sales price of an item with VAT)

2009-11-23 Thread 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: Number series

2009-11-23 Thread giridharraj
, giridharraj giridhar...@... wrote: From: giridharraj giridhar...@... 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

[Axapta-Knowledge-Village] retrieving records by paging

2009-11-20 Thread 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] how to represent not equal to symbol in query build

2009-11-20 Thread 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] Re: how to represent not equal to symbol in query build

2009-11-20 Thread giridharraj
, Anitha S mail2eani...@... 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 giridhar...@... wrote

[Axapta-Knowledge-Village] Re: Number series

2009-11-19 Thread giridharraj
are creating sales order, pass the appropraite numbersequence group to the sales table. --- On Tue, 17/11/09, giridharraj giridhar...@... wrote: From: giridharraj giridhar...@... Subject: [Axapta-Knowledge-Village] Number series To: Axapta-Knowledge-Village@yahoogroups.com Date: Tuesday, 17

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

2009-11-17 Thread 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

2009-11-16 Thread 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

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

2009-11-10 Thread 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

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

2009-11-10 Thread giridharraj
.. Regards, Anitha On Tue, Nov 10, 2009 at 11:10 PM, giridharraj giridhar...@... 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

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

2009-11-10 Thread 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

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

2009-11-09 Thread giridharraj
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 giridhar...@... wrote: Hi, I am accessing a method in a AX class from dot net directly which takes an xml document

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

2009-11-09 Thread 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

[Axapta-Knowledge-Village] conversion of xml object

2009-11-08 Thread 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

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

2009-11-05 Thread giridharraj
= 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 giridharraj@ wrote

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

2009-11-02 Thread 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

2009-11-01 Thread giridharraj
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 giridharraj@ wrote: Hi, I am getting an error for AIF Inbound, I have done all

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

2009-10-31 Thread 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

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

2009-10-27 Thread 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

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

2009-10-27 Thread 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=50192ALocale=en-\ us http://www.microsoft.com/learning/en/us/Course.aspx?ID=50192ALocale=en\ -us or a walkthrough for AIF integration

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

2009-10-27 Thread 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 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

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

2009-10-27 Thread giridharraj
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 giridhar...@... wrote: Hi, Can anybody provide me some kind of material