Re: [Axapta-Knowledge-Village] Which module is active

2004-10-28 Thread Subrahmanyam Mamidi
Hi,   where do I get Axapta database log?. The record info doesn't give much info. Do you use some kind of tool for this or do you use SQL DB logging tool on a particular table?. can you please share your exp with me?. many thanks, SubbuWolfgang Rieger <[EMAIL PROTECTED]> wrote: Hi. Maybe you

RE: [Axapta-Knowledge-Village] G/L account balances

2004-10-28 Thread VilmaQ \(Axteam\)
Hi, Which option did you use to post the invoice? Invoice Register or Invoice Journal? The Invoice Register option is a two step process, after posting the entry you must go to the Invoice approval Journal and complete the process. In the fisrt step, the vendor info if updated but not the G/L.

RE: [Axapta-Knowledge-Village] G/L account balances

2004-10-28 Thread Karina Normann Jakobsen \(MICROSOFT BUSINESS SOLUTIONS\)
Your balance in G/L depend on the period you select under General Ledger/Chart of account/Balance/setup - have fun Med venlig hilsen/Best regards/Mit freundlichen Grüßen Karina Normann Jakobsen Program Manager, Supply Chain Management -Original Message- From: Serioga [mailto:[EMAIL

Re: [Axapta-Knowledge-Village] Which module is active

2004-10-28 Thread Wolfgang Rieger
Hi. Maybe you could use the Axapta database log for that purpose? There you can set up all tables to keep track of insert, modify or delete actions. So after setting it up for the specific tables you just need to take a look in the log. Wolfgang. Hennie Potgieter <[EMAIL PROTECTED]> wrote: Hi,Is

RE: [Axapta-Knowledge-Village] G/L account balances

2004-10-28 Thread Serioga
Karina, thank you! I found the missing entries. One of my accounts wasn't mapped correctly; I'll have to figure out the setup. Related question: though my G/L account has a balance if I print transactional reports, it shows $0 in the Balance column or if I click on Balance button. Is there a r

RE: [Axapta-Knowledge-Village] G/L account balances

2004-10-28 Thread Karina Normann Jakobsen \(MICROSOFT BUSINESS SOLUTIONS\)
Axapta post G/L when you post the invoice. If you have a vendor transaction you must also have the corresponding entries in G/L. The only way you can avoid this if it the summarized amount on a account in G/L is zero = read all transactions is pointing at the same account. If this is th

[Axapta-Knowledge-Village] Axapta + Windows Service

2004-10-28 Thread krg
Does anyone know how post data from Axapta to a 'Windows service' ? Or how to call a 'Windows service' from Axapta Yahoo! Groups Sponsor ~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/kGEolB/TM

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

2004-10-28 Thread roberto pineda
Thanks... I appreciate your help. --- Girish B <[EMAIL PROTECTED]> escribió: > 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 syste

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 e

[Axapta-Knowledge-Village] G/L account balances

2004-10-28 Thread serioga
Hello, At what point do Axapta G/L accounts get updated with transactions from other modules? I posted several invoices in A/P and I can see immediate impact on vendor balances, but it doesn't seem to affect G/L account balances. Am I missing a step in order to transfer the transaction fro

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

2004-10-28 Thread roberto pineda
Hello. It is my understanding that once an entry is posted, it becomes a permanent record. I have a customer that wants to be able to: 1. Change or update information to records that have been posted 2. Void an entry by eliminating the entry as if it never existed 3. Void an in

RE: Antwort: RE: [Axapta-Knowledge-Village] Axapta Enterprise Portal behind a Firewall

2004-10-28 Thread Morten Aasheim
First of all. 1433 Is the AOS port if you run in a 3-tiered environment. This is the only port you need then. You can specify any other port in the configuration file also. If you run in a 2-tiered environment, you have to open 1521, which is standard SQL-server port.   You don’t hav

[Axapta-Knowledge-Village] Outstanding Checks on Conversion

2004-10-28 Thread frodnew57
We recently converted from 2.5 to 3.0. It was a complete re-install, not an upgrade. One of the items we didn't consider was how the check reconciliation process would work after the implementation. Obviously we still have checks outstanding that were written in 2.5 that do not appear in

[Axapta-Knowledge-Village] Re: Container checkIfupdate on class SalesTableForm

2004-10-28 Thread dgaethofs
Hi all, I finally found it! Must say it has been made complicated. I wonder whether that was necessary. The method checkIfUpdate() on the table SalesTable calls the type() method. The type() method returns an object of the SalesTableType using the construct on the class SalesTableType. Th

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

2004-10-28 Thread Jim Jo
HI Meng,     Great To see hear that!!!.     Hey man, Am in singapore and do sometimes travel to KL,JB etc. If you happen to be in singapore mail me!.   Regards   JimKoh Meng <[EMAIL PROTECTED]> wrote: Hi Jim and Girish,   Hurray ! I managed to solve the problem already !  The problem is caused

RE : RE : [Axapta-Knowledge-Village] Std filter records on form transferred to functionality

2004-10-28 Thread Steeve Gilbert
Ok I'll look stuck on this idea but you can still browse record that are not marked by just calling getFirst() with no parameter. Tried that? I successfully tested it with this : InventTable invTab; invTab = InventTable_ds.getFirst(); while (invTab) { info(invTab.NameAlia

[Axapta-Knowledge-Village] Which module is active

2004-10-28 Thread Hennie Potgieter
Hi, Is there any way of determining in code which module a user is currently working in? I need to determine if a user is maintaining alternate addresses from SalesLedger, PurchaseLedger or CRM side but have no clue. Thanks, Hennie Yahoo! Groups Sponsor --

RE : [Axapta-Knowledge-Village] Customising a report

2004-10-28 Thread Steeve Gilbert
Here's where I think ledger account range is added: Class/LedgerReport_TrialBalance.initQuery() Steeve... -Message d'origine- De : rwngroom [mailto:[EMAIL PROTECTED] Envoyé : 28 octobre 2004 03:03 À : [EMAIL PROTECTED] Objet : [Axapta-Knowledge-Village] Customising a report Hi guys

Antwort: RE: [Axapta-Knowledge-Village] Axapta Enterprise Portal behind a Firewall

2004-10-28 Thread mkrauss
Tank you for the fast answer. I will try it. Hi,   I have Axapta client for EP on Server on DMZ of firewall. The SQL and App Server are both on Trusted side of firewall. You have to allow HTTP from External to DMZ  (Port 80). You have to allow COM (Port 35) from DMZ to Tru

RE: [Axapta-Knowledge-Village] Axapta Enterprise Portal behind a Firewall

2004-10-28 Thread David VanEchaute
Hi,   I have Axapta client for EP on Server on DMZ of firewall. The SQL and App Server are both on Trusted side of firewall. You have to allow HTTP from External to DMZ  (Port 80). You have to allow COM (Port 35) from DMZ to Trusted. You have to allow SQL (Port 1433) from DMZ to Tru

[Axapta-Knowledge-Village] Container checkIfupdate on class SalesTableForm

2004-10-28 Thread dgaethofs
Hi all, I need some help in figuring out how the container checkIfupdate gets its value. In the method enableUpdateJournalButtons a container checkIfupdate is used. THe container gets values assigned the moment the method checkIfUpdate() on the table SalesTable is called. I have been tryin

[Axapta-Knowledge-Village] Axapta Enterprise Portal behind a Firewall

2004-10-28 Thread mkrauss
i have a problem with the enterpriseportal behind a firewall. The peblem is, that i cant connect to the portal over the internet. If I use the portal without the firewall, there are no problems. Are there some setting to made on the firewall? For youe answer many thanks Sharing the knowledge

Re: RE : [Axapta-Knowledge-Village] Std filter records on form transferred to functionality

2004-10-28 Thread Irving
Thanks steve, but I did try that. I have tried to transfer the data (args.record(tablename)) to class, and then step through them using getfirst and getnext, but it's only when I manually mark the records that it works. The customer wants to be able to filter records (ctrl + F3), and then n

[Axapta-Knowledge-Village] Active Directory Integration

2004-10-28 Thread jeroen_vangheluwe
Dear, Is there anyone who knows how to itegrate the Active Directory with Axapta? The fact is: i would like to let the users to be logged on automatically when they start the Axapta Client, with their username in the Active Directory (network name) By this way, the user should online log

Re: [Axapta-Knowledge-Village] Override the data method of table

2004-10-28 Thread Amit Jain
Well i think you cannot override the data method of any table because this method is of Final type.   This method is used to get the record of any table object. Usually used where a new record is to be inserted and you want to initiate some data from another table instance.     Regards   Amit Ja

Re: [Axapta-Knowledge-Village] Re: Override the data method of table

2004-10-28 Thread Nitesh
Thanks, WoHeGro   Regards Nitesh - Original Message - From: wohegro To: [EMAIL PROTECTED] Sent: Thursday, October 28, 2004 5:29 PM Subject: [Axapta-Knowledge-Village] Re: Override the data method of table Hi nitesh,(1)you can't override this method 'caus

[Axapta-Knowledge-Village] Re: Override the data method of table

2004-10-28 Thread wohegro
Hi nitesh, (1) you can't override this method 'cause it's an "non open" system- method for every table. (b.th.w.: it's only possible to override methods -in any method-node of the AOT- which are listed in the context-menu, line "Override method") (2) description is shown in the AOT | System

[Axapta-Knowledge-Village] Re: Is there a possibility to work with Axapta and MySQL?

2004-10-28 Thread affekatz
In what way? I believe it's possible to connect to mysql with odbc or maybe axapta com ( How to use the com thing I don't know ), but im currently looking in to the odbc thing and it dosn't look to hard but i haven't tried to make it yet --- In [EMAIL PROTECTED], "stefan" <[EMAIL PROTECTE

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

2004-10-28 Thread Koh Meng
Hi Jim and Girish,   Hurray ! I managed to solve the problem already !  The problem is caused by the fields in the DB whereby in the Excel template it appears to be 2 decimal points but in DB it becomes > 2 decimal points.    One thing i need to ask is:  Why in Excel template i've already forma

[Axapta-Knowledge-Village] Override the data method of table

2004-10-28 Thread Nitesh
Hi Everybody    how can i override the "Data" method of any table? and wats its function? :-)   Regards Nitesh   Sharing the knowledge on Axapta. Yahoo! Groups Sponsor Get unlimited calls to U.S./Canada Yahoo! Groups Links To visit your group on

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

2004-10-28 Thread Jim Jo
Hi Meng,     Did you try the manual process that I suggested for the lines marked red aafter the validate journal ???   Regs   JimKoh Meng <[EMAIL PROTECTED]> wrote: Hi Jim and Girish,   Attached is my posting errors.  The thing i find it strange is that my GL Journal has 1005 lines but only c

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

2004-10-28 Thread Girish B
Jim, if possible can you email the excel format with some data (3-4 lines will do) which you used to create the Lines ? when free i will too try to catch each data and see where it goes wrong. But earlier when our client went live i tried many times to import but since they had too many transact

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

2004-10-28 Thread Jim Jo
Hi Girish,   Thats true that you have said. But really I ahve not gone though these tables :). Yep you are rit that when you use the general journal for opening balances before go live .. after the import you will get a lot of validation errors. but i dont find it really good to ask the user to

[Axapta-Knowledge-Village] Re: Axapta and Outlook

2004-10-28 Thread dgaethofs
Dear Ronny, Here is what you need to do: - Select menu Basic, select employee and create an employee - Go to tab Outlook and set the outlook user id In most cases you can find it when you look at services in outlook. Give it a try, if you can find it I have a job that shows the user id from w

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

2004-10-28 Thread Girish B
Hi Jim, May be you could import the transactions directly and post but I had tried in a few times and kept getting errors. When I see the “LedgerjournalTransDaily” table, I see that there is one more table in the datasource “CustVendPaymJournalFee” . I don’t know exactly what is saved in this t

[Axapta-Knowledge-Village] AXAPTA HR

2004-10-28 Thread hrogut
Is there way for changing the start date of an employee in AXAPTA HR. This employee is active. Yahoo! Groups Sponsor ~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/kGEolB/TM ---

[Axapta-Knowledge-Village] Is there a possibility to work with Axapta and MySQL?

2004-10-28 Thread stefan
Someone can Help? Yahoo! Groups Sponsor ~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/kGEolB/TM ~-> Sharing the knowled

RE: [Axapta-Knowledge-Village] AXAPTA 3.0 SP3 COMPATIBILITY WITH WINDOWS SERVER 2003

2004-10-28 Thread Fabrice Perez
Not so far. Could you elaborate, if you have encountered any problem?   Fabrice Perez Microsoft® Business Solutions Certified Master - Axapta® General Application, Finance, Trade & Logistics, Production, Projects, Shop Floor Control, Product Builder   Mobile:    +65 9836 4065 Fa

[Axapta-Knowledge-Village] Customising a report

2004-10-28 Thread rwngroom
Hi guys I am new to axapta and I have what is probably a simple question. I need to customise the trial balance report(under GeneralLedger/Reports/Transactions/Periodic). I need to add the Dimensions Cost Center,Department,Purpose to the report form so that I can report according to these c