Re: [Axapta-Knowledge-Village] Printing reports in pdf format

2007-05-21 Thread Chaminda Kothalawala
Hi kbi Acrobat reader is installed in a client. We are using JPEG file as a logo file. Is there anything with file format? My client is using acrobat reader not writer or professional. I think there is no license issue for that. My client is facing problem when the report is printed in PDF format o

RE: [Axapta-Knowledge-Village] Financial dimensions on a Stock close

2007-05-21 Thread Asrar Ahamed
If the Inventory Profit/Loss summary account dimension validity is set up as "To be filled", you will find this message. If you want to have this set up for Inventory P&L Journal as well, set up the dimensions at Item Master Level. Hope this will solve your problem. Thanks, Asrar

RE: [Axapta-Knowledge-Village] SQL Query for AXAPTA BACKEND DATABASE

2007-05-21 Thread p.saravanakumar
Dear Pankaj Yes, Now we are taking this way, but my question is some of the data could not match with original Axapta figures. So I required the sample queries from internet. Where I can get? Regards P Saravanakumar Co-Its 09894999281 -Original Message- From: Pankaj Kant [mailto:[EM

Re: [Axapta-Knowledge-Village] Re: Pick Inventory per Batch by ExpiryDate

2007-05-21 Thread Hemant Kumthekar
Hi, If the user is going to enter the batch number manually then you have only option is to modify your lookup for Batch numbers (on Hand tab) so that the inventory is displayed in sequence of Expiry date, also if your printing any Pick list then you can print the available batches in expiry da

[Axapta-Knowledge-Village] Re: Pick Inventory per Batch by ExpiryDate

2007-05-21 Thread axaeffect
Hi Hemant, thx, but I think it won't work, correct me if I'm wrong, but as I look in the code, "date controlled" only look for LastUpdatePhysical in Onhand Inventory. and I can't use automatic batch number bcoz already agreed, user will give the batch manually, also expiry date. The problem

Re: [Axapta-Knowledge-Village] Pick Inventory per Batch by ExpiryDate

2007-05-21 Thread Hemant Kumthekar
Hi Ton, How about checking the flag on IMG Reservation "date controlled" also you would like to consider the allocation of batch numbers to be Automatic rather than manual as the number allocated will be in sequential order. Hemant K - Original Message From: axaeffect <[EMAIL PROTECT

[Axapta-Knowledge-Village] Pick Inventory per Batch by ExpiryDate

2007-05-21 Thread axaeffect
hi all, I want to pick Onhand Inventory, and the batch that should be picked usually in alpabhet order (batchid). How if I want to sort by Expiry Date ? For Example, I have Onhand Inventory like this : Item A - Batch X - ExpDate : 20/5/2007 Item A - Batch Y - ExpDate : 18/5/2007 Item A - Batch

RE: [Axapta-Knowledge-Village] Form Refresh problem

2007-05-21 Thread Anil Ozay
Hi Suneel, If you want the refresh all the records in the grid, you can use table_ds.executeQuery(); if you want to refresh current record, you can use table_ds.refresh(); Best regards, McDonalds Anýl ÖZAY Software Eng,Business Solutions MVP Dynamics AX, MBSCP, MCP ANADOLU BÝLÝÞÝM

[Axapta-Knowledge-Village] File lock error with AOS?

2007-05-21 Thread James Flavell
Hi everyone, I am getting an intermittent error running Ax3.0 SP5 KR2 on a Windows 2003 server (which is running on VMWare) The log is below: Event Type: Error Event Source: Axapta Object Server Event Category: None Event ID: 152 Date: 5/18/2007 Time: 10:25:42 AM User: N/A Computer:

RE: [Axapta-Knowledge-Village] Re: SQL Query for AXAPTA BACKEND DATABASE

2007-05-21 Thread p.saravanakumar
Dear Santhoh Thanks for Your valuable advice, but I'm Not in position to execute this thru Axapta, because I'm not a technical person, but I know the Sql query, so I want to take any reports from database directly. Regards P Saravanakumar Co-Its 09894999281 -Original Message- From: S

RE: [Axapta-Knowledge-Village] Financial dimensions on a Stock close

2007-05-21 Thread James Flavell
I think there was a hotfix for this issue (this is Ax3.0 right?) -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of anishafakir1 Sent: 21 May 2007 07:25 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Fi

RE: [Axapta-Knowledge-Village] SQL Query for AXAPTA BACKEND DATABASE

2007-05-21 Thread Pankaj Kant
Dear Sarvana U need to connect to Axapta Database using SQL-Net Connect Client and run your query for generating the report Best regards Pankaj From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of p.saravanakumar Sent: Monda

RE: [Axapta-Knowledge-Village] SQL Query for AXAPTA BACKEND DATABASE

2007-05-21 Thread p.saravanakumar
Dear Srinivas We are using Oracle Database Regards P Saravanakumar 09894999281 -Original Message- From: Ajit Srivastava [mailto:[EMAIL PROTECTED] Sent: Friday, May 18, 2007 4:55 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] SQL Query for AX

[Axapta-Knowledge-Village] Financial dimensions on a Stock close

2007-05-21 Thread anishafakir1
Hi. Please assist me with the following, When I do a stock close, upon completion an error appears. The error is " Department, Cost center must be specified for ledger account.." How do I switch off this error for stock closings and still keep it available for the profit/loss journal? Thanki

AW: [Axapta-Knowledge-Village] exam quests

2007-05-21 Thread Andrae, Tobias
> "And lastly, I dont know when u gonna take the exam but I may share the real > exam quests which I remember after the exam." Before you do that, *carefully* read the agreement between MS and you which you will sign by clicking "ok" when doing the exam -- this is one of the things you are ex

[Axapta-Knowledge-Village] Form Refresh problem

2007-05-21 Thread suneel babu
HI., I have problem with form refresh in axapta. when i change an record info in the data source of the current form then it doesn't refreshed. once i close the form and then open then its refreshed. plz tell any solution. for this. Thank u., ___

Re: [Axapta-Knowledge-Village] SQL Query for AXAPTA BACKEND DATABASE

2007-05-21 Thread Ajit Srivastava
Hello srinivas, U hav to do by Sql Server 2005 reporting services.. Regards Ajit Srivastava @ +91441034Technical Consultant NSL - A Tata Group Company New Delhi -110 058 Tel. +91(11) 25544 703 / 4704 Telefax +91(11) 25544705 Websites: www.tata.com/nelito/index.htm ww

[Axapta-Knowledge-Village] Report_query

2007-05-21 Thread kumkum kirodiwal
dear All, I m fetching records from many tables at form' open time. For that I used a Class and wrote a query on that,and called that query at form's open time(form/datasource/init). now I want to print reports at one time by clicking a single button, for that I want to select all record by

[Axapta-Knowledge-Village] Re: How can we call multiple reports

2007-05-21 Thread Santosh Kumar Sharma
If you r running the report from a class then in the lastvalueelementname() method , based on conditions , you can mention which reports to use . I belive this will solve ur problem. --- In Axapta-Knowledge-Village@yahoogroups.com, "Steeve Gilbert" <[EMAIL PROTECTED]> wrote: > > You should be

[Axapta-Knowledge-Village] Re: SQL Query for AXAPTA BACKEND DATABASE

2007-05-21 Thread Santosh Kumar Sharma
Dear Saravanakumar , Try using the following in the fetch() method of ur report Connection Con = new Connection(); Statement SQLStmt = Con.createStatement(); Notes SQLStrl; ResultSet RS; ret = element.prompt(); SQLStrl = Strfmt(""); RS = S

[Axapta-Knowledge-Village] Reading Lotus emails from Axapta

2007-05-21 Thread Santosh Kumar Sharma
How can we read emails of a Lotus Client from Axapta ? I know there is a class called SysInetMail in Axapta which has a method named readmail(). But somehow its not working for me...Please help.

RE: [Axapta-Knowledge-Village] exam quests

2007-05-21 Thread c
Hi Mike, I havent receieved any quests yet. But as soons as I get the ragarding documents, I will directly share them with you also. Meanwhile if u find any valuable resource, could u please share it with me? And lastly, I dont know when u gonna take the exam but I may share the real exa

[Axapta-Knowledge-Village] FRX integration with AX 4.0

2007-05-21 Thread chenthusomu
Hi All, I would be greatful if anyhelp can be extended in knowing more about FRX integration with AX 4.O. I would like to know things like how to connect Axapta with FRX and so on. I tried with FRX manuals, but nowhere there is info about this. thanks, Senthil

[Axapta-Knowledge-Village] Form with 2 grids and same datasource

2007-05-21 Thread Dimitri Dejonghe
Hi, I try to make a form with 2 grids (Heading grid an Detail grid) that have the same datasource but with other fields of the table used. The table contains header records and detail records and are marked in a field that contains the number 1 or 2. This field is related with a field called Docu