Re: [Axapta-Knowledge-Village] How to speed up my report processing

2005-02-17 Thread Girish B
where have you written the validations to populate your temp table? you could create a class in which the validation and population of data can be done. Make sure that the class is run on the server (set the properties). Finally when the data is populated you could call the report from the

Re: [Axapta-Knowledge-Village] Re: Cleaning up Item Master records!?

2005-02-16 Thread Girish B
. Regards Amit Jain Girish B [EMAIL PROTECTED] wrote: I am not sure if its a good idea to delete the Items from the Item master, when the transactions are there. you cannot delete directly as the validations would not allow to delete itm if the transactions are done. You could

Re: [Axapta-Knowledge-Village] High Importance!!!! Syntax error after a Int declaration.

2005-02-16 Thread Girish B
Myrl, this is very scary error. Right now i dont have 2.5 installed on my system to check and I am not sure why this problem occured. I would suggest you to restart the system again, i know its a stupid advice but many times when some weird thing happened , in axapta, restarting did work for me.

Re: [Axapta-Knowledge-Village] Re: Cleaning up Item Master records!?

2005-02-15 Thread Girish B
I am not sure if its a good idea to delete the Items from the Item master, when the transactions are there. you cannot delete directly as the validations would not allow to delete itm if the transactions are done. You could bypass the validations and delete but it would affect the data

RE: [Axapta-Knowledge-Village] 4th Financial Dimension

2005-02-11 Thread Girish B
_ From: Girish B [mailto:[EMAIL PROTECTED] Sent: Friday, 11 February 2005 9:11 a.m. To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] 4th Financial Dimension you dont need to buy new license for extra dimensions. you could add new

RE: [Axapta-Knowledge-Village] 4th Financial Dimension

2005-02-11 Thread Girish B
This is another Axapta community site!!! have a great week end,. http://www.axaptacentral.com/axapta.php --- Subrahmanyam Mamidi [EMAIL PROTECTED] wrote: BTW, what is this Axapta Central?. Sorry for my ignorance... thanks, subbu Girish B [EMAIL PROTECTED] wrote: Hi Harry

Re: [Axapta-Knowledge-Village] 4th Financial Dimension

2005-02-10 Thread Girish B
you dont need to buy new license for extra dimensions. you could add new dimensions by making some modifications. One of our earlier client had paid for extra 2 dimensions but with the new license they did not get additional dimensions but instead i had to modify to get 2 new dimensions. So i

Re: [Axapta-Knowledge-Village] Axapta implementation components - Urgent help needed

2005-02-06 Thread Girish B
Hi Ramya, i would suggest the following A person (project manager) who would act as a link between all the members and keep a tight control on the time set for the roll out. It is very important that you decide well in advace the time required and stick to it. It is also important

Re: RE : [Axapta-Knowledge-Village] Simple Question .... reports

2005-02-02 Thread Girish B
the end users can use the financial statement report to generate different financial reports. --- Steeve Gilbert [EMAIL PROTECTED] wrote: - There are a couple of build-in customer reports (~40). You should probably install the demo to see if the one you needs

[Axapta-Knowledge-Village] remitance advice when payment done by BACS

2005-01-30 Thread Girish B
Hi All, Our client pays electronically (By BACS) and subsequently wants to send the remitance advice to the supplier. Can any one let me know if its possible and if yes then what are the settings and from where can we print the remitance advice. we have been able to print the remitance

Re: [Axapta-Knowledge-Village] SalesLine disappears

2005-01-18 Thread Girish B
sorry this is a stupid question of mine , do you see the salesId in the salesLine table?? and how r u populating the salesline table ? --- Danny Gaethofs [EMAIL PROTECTED] wrote: - Dear all, I have a SalesLine record that is not shown in the form SalesTable

Re: [Axapta-Knowledge-Village] InventDim,BOM,BOMTable,BOMVersion,ConfigTable,InventDimCombination

2005-01-18 Thread Girish B
you need to write inventdim.clear(); inventdim.config = value; ... inventdim = inventdim::findorcreate(inventdim); BOM.inventdimId = inventdim.inventdimId; well i had created jobs in order to import the BOM, BOMTable and BOMVersion for our clients. the above lines would include the required

Re: [Axapta-Knowledge-Village] CacheAddMethod() in VER 2.5 sp4

2005-01-15 Thread Girish B
PROTECTED] wrote: - Hi Girish, Thanks for the reply . These display methods are based on some business logic which is not stored any where. like a sales tax total for all saleslines showing in the salesTable header. TJJ --- Girish B [EMAIL PROTECTED] wrote

Re: [Axapta-Knowledge-Village] CacheAddMethod() in VER 2.5 sp4

2005-01-14 Thread Girish B
why dont you add the table in the datasource and directly display??? where ever possible we should always avoid using display methods on the forms.. --- tj_jayson [EMAIL PROTECTED] wrote: - Hi All, How can I cache a method in Axapta ver 2.5 sp 4 I

Re: [Axapta-Knowledge-Village] One report with data from all companies

2005-01-11 Thread Girish B
you need to include the table which will be populated with the records (and used in the report) , in the virtual company which has access to all the companies. now you can write a function to populate the data and use the changecompany() function to change to another company. this will

Re: [Axapta-Knowledge-Village] Layer Question

2005-01-04 Thread Girish B
by using this method of exporting ... deleting and then importing back in the new layer, you might lose the data in these tables. you might need to export the data (of the new tables) before deleting them. you might have to see if the modified tables (new fields added) have the data , If

Re: [Axapta-Knowledge-Village] Batch processing

2005-01-03 Thread Girish B
after setting the batch process did you start the process ? i.e did you run Basic/Periodic / Batch / Processing ? you need to run this and select the Batch group. --- birzanto [EMAIL PROTECTED] wrote: - Dear all, Is there anyone of you know how to use

Re: [Axapta-Knowledge-Village] InventJournalTable InventJournalCheckPost

2004-12-11 Thread Girish B
when you run the class InventJournalCheckPost just before running this class see that you block the inventjournaltable record. you can write InventJournalTable.systemBlocked = NoYes::Yes; then also see that after the posting is done you write to unblock. hope this would solve your problem.

Re: [Axapta-Knowledge-Village] Digest Number 200

2004-12-09 Thread Girish B
import error From: Stefan Osterburg 14. Re: Sample code for IAxaptaBufferData From: Varden Morris 15. Instructions From: userm1837 16. Re: Instructions From: Girish B 17. credit and debit is not equal for journal and voucher From: Cenk Ince 18. Re: Instructions From: UserM1837

Re: [Axapta-Knowledge-Village] Instructions

2004-12-08 Thread Girish B
why dont you add a text field to display in Page the footer or include epilog and add the text field depending on how you want to include. --- userm1837 [EMAIL PROTECTED] wrote: - Hi, Could I get some ideas as to how I could include and have instructions

Re: [Axapta-Knowledge-Village] unbalanced x++ ttsbegin/ttscommit

2004-12-06 Thread Girish B
put the ttsbegin after if (qryRunAddress.prompt()) and then close the transaction by ttscommit accordingly. cheers, Girish --- Danny Gaethofs [EMAIL PROTECTED] wrote: - dear all, I am writing a job to update some values on a table based on input

Re: [Axapta-Knowledge-Village] unbalanced x++ ttsbegin/ttscommit

2004-12-06 Thread Girish B
here between the ttsbegin and ttscommit try to avoid entering the pause. you could use debugging to find the values or else you could put the pause after ttscommit. --- Danny Gaethofs [EMAIL PROTECTED] wrote: - dear all, I am writing a job to update some

Re: [Axapta-Knowledge-Village] Using Radio Button

2004-12-01 Thread Girish B
refer the form InventPosting in the AOT. --- Morris Mendoza [EMAIL PROTECTED] wrote: - How do you put labels on the items of a radio button both at design and run-time? Also, how do i capture the event everytime i change my option in the radio button? Thanks!

[Axapta-Knowledge-Village] multiple transaction line for the same purchase line

2004-11-16 Thread Girish B
Hi All, Today I saw a very peculiar thing. When I looked for the OnHand for a particular Item I found that it has 250 Qty with receipt status Ordered. But when I checked this PO it had this status as delivered. Also when I checked for the transactions for this Item and for the selected PO i

Re: [Axapta-Knowledge-Village] Urgent Functional Help P1 ticket

2004-11-12 Thread Girish B
Hi Subbu, what you need to do is select the voucher series (in the number sequence) and check if there are any open nos (select the button and it will display if any nos are left undecided). delete them and then ones again create the journal. this is a bug in axapta, even though the num seq is

Re: [Axapta-Knowledge-Village] How to get all offset account information from a vendor?

2004-11-11 Thread Girish B
if you want the corresponding data (of the LedgerTrans table) from LedgerJournalTrans table. then in the LedgerTrans the Posting has to be ledgerJournal and then get the match using the journalNo and the voucher of both the tables. Butif the voucher nos are the same on multiple lines then it will

[Axapta-Knowledge-Village] Configuration utility settings gets reset

2004-11-11 Thread Girish B
Hi All, At our client site , all the users connect to Axapta using the Terminal server. The users after log on in the Terminal server using their domain userid and password,. Had set on the Axapta configuration utility their UserId and Company. When ever they enter the terminal server ,

Re: [Axapta-Knowledge-Village] A field in the first page of a report

2004-11-11 Thread Girish B
enter in ProLog section. --- Alfonso Collados Arroyo [EMAIL PROTECTED] wrote: Hi, I need to put a Control Text in the first page of a report, but only in the first. How can I do this? Regards, Alfonso

Re: [Axapta-Knowledge-Village] Best Practice in Axapta to ensure quality AXAPTA based ERP Solutions

2004-11-10 Thread Girish B
Hi, The best way is to check in the developer’s guide (see for programming standards). Also you can check for some good documents on the technet. If you want to see how the relations are set in the datasource and all then the best place to see are the tutorials. Rest of the things come by

Re: [Axapta-Knowledge-Village] Intercompany Scenario in different Localisations

2004-11-09 Thread Girish B
Hi Subbu, vaibhav, Good morning. i understand the reason why subbu is looking for and MS has advised to maintain multiple databases. But there would be a few restrictions (which again could be solved using modifications) like 1. supposed in future one company needs to understand the

Re: [Axapta-Knowledge-Village] Posting Errors !

2004-10-28 Thread Girish B
for that. New new issues comes up daily. Fun trouble shooting all.!! Jack please keep posted of errors !! if you still have. Would be able to give some suggestions !!! Regards Jim Girish B [EMAIL PROTECTED] wrote: Hi Jim, May be you could import the transactions directly

Re: [Axapta-Knowledge-Village] Is it possible to change records posted?

2004-10-28 Thread Girish B
System does not allow to modify the posted data to maintain the data consistency. Some of the posted data we can change by writing jobs but its not a good thing to do. When the posting is done the system updates multiple tables with data and if we now try to change the posted data then we might

Re: [Axapta-Knowledge-Village] Move system messages

2004-10-13 Thread Girish B
sunil, how can this help in controlling the position of the system messages which appears ? --- sunil padhy [EMAIL PROTECTED] wrote: - Hi Irving There is an option are there in axapta go to tools - option -- SQL Tabpage. if the check box of SQL Trace

Re: [Axapta-Knowledge-Village] importing for invoice through Excel

2004-10-12 Thread Girish B
Can u let me know about the Training courses conducted for the Axapta or where i can the information. Thanks RAJ --- Girish B [EMAIL PROTECTED] wrote: Hi Nitesh, Import function like the one you are doing should be done when we need to import data in the tables which usually dont

Re: [Axapta-Knowledge-Village] Rename Value

2004-08-23 Thread Girish B
in axapta there are several ways of renaming a value. one way is to write a job to rename the values of the field in a particular table. in your case i think you want to globally rename. for the example which you have specified to rename an ITEMID. you go to item master. Then select the ItemId

Re: [Axapta-Knowledge-Village] Chart of Accounts importing, part 2

2004-08-21 Thread Girish B
Hi Serioga, i had explained in my earlier mail how to import data using excel sheet. any way i m writing the steps again 1. go to Administration / periodic / data exportimport / excel spread sheets / Template wizard here you will be asked to select the table. here you select LedgerTable. then

Re: [Axapta-Knowledge-Village] Re: Auto Declaration

2004-08-20 Thread Girish B
diplaying in a report and using the value in some other place are 2 different things. the sum displayed in the report is generated by the sum function on the report and its not saved which could be used later. where do you want to use the value from the report and in which way? can you be

Re: [Axapta-Knowledge-Village] Looking for Functional or Technical Axapta Consultant

2004-08-19 Thread Girish B
Hi martina, i can give reference of my ex-collegue (with my earlier employer), he is very good in technical side of axapta. his name is Deepak shetty and his email id is [EMAIL PROTECTED] good luck. cheers, Girish --- martina_graph [EMAIL PROTECTED] wrote: -

Re: [Axapta-Knowledge-Village] looking for tips on importing/exporting data

2004-08-19 Thread Girish B
The first thing you should do is import the default data which is customer independent. This is an prerequisite for any axapta installation. This can be done from administration tab/ periodic menu / data export /import, default data. then you can start importing the customer specific data. if

Re: [Axapta-Knowledge-Village] how to deeply learn x++/axapta

2004-08-09 Thread Girish B
your development knowledge can get better only by experience. when ever you do any modifications or create new functionality try to use the axapta standard (look out for similar functions and make the changes similarly) as the time goes you will get to know the struture automatically. you can

Re: [Axapta-Knowledge-Village] X++ Training

2004-08-08 Thread Girish B
you should contact ur local microsoft office. now usually its done through training centres. --- kbi kbi [EMAIL PROTECTED] wrote: me too, please notify me if you know. thanks friends bigjwman [EMAIL PROTECTED] wrote: I am planning to purchase Axapta for my company. It's going to require

Re: AW: [Axapta-Knowledge-Village] SQL Select in axapata (X++)

2004-07-29 Thread Girish B
select maxof(IDNumber) from myTable; lastIDProcessed = myTable.IDNumber; --- Theissen, Annette [EMAIL PROTECTED] wrote: Please try maxof instead of max: select maxof(IDNumber) from myTable; Bye, Annette Mit freundlichen Grüßen / Best regards Dipl. Phys. Annette Theißen

Re: [Axapta-Knowledge-Village] AOS Exam

2004-07-28 Thread Girish B
the questions are not clear about the cache : cache is held in Axapta When first AOS instance starts the database server other question i think should be : how many max no of instances can be created on AOS server answer is Unlimited cheers, Girish --- axapta2004 [EMAIL PROTECTED] wrote:

Re: [Axapta-Knowledge-Village] How About Production Exam?

2004-07-26 Thread Girish B
you should have a look at the inventory , production setups. i remember 2 questions which had appeared 1.What is necessary to enable reservations on physical inventory to a production order 2. Upon receipt of a purchase order, an incorrect serial number was registered. How can this be corrected