RE: [Axapta-Knowledge-Village] Microsoft SNAP vs. Atlas XL
Hello Zvika While Atlas and SNAP appear to offer the same result (ie a report in Excel), its how these products are implemented is what really separates them. Lets assume you want to get a figure from AX into a cell in your spreadsheet, for example, a customer balance - a sum of all transactions. With SNAP you are required to identify the cell and give it a named range, eg SNAPCustomerBalance. You are then required to WRITE some XML code in a shadow Excel file (same name as your spreadsheet but with a different file extension) where this Excel Named Range is the link between the two files. You need to do this per cell. Imagine you have 100 rows down and 12 months across, so repeat this step another 1199 times. There is no copy/paste option as you need to enter named ranges for each cell. Atlas on the other hand implements new formula into Excel where the result of the formula (whenever it is calculated) comes from AX. This formula can be copied and pasted just like any other Excel formula, so in the case above you use the Atlas formula designer for the first cell and then simply drag the formula down and across to the other 1199 cells. Being a formula you can see immediately where the data is coming from and you know its 100% accurate. With SNAP you can't tell if the figure in the cell has been delivered by SNAP or the keyboard. Atlas formula appear in the standard Excel formula bar meaning you can also read it to understand the datasource (table) and filters which built the AX query. Atlas formula also allow drill-down (into a popup form - not AX) of the transactions that make up the balance. For more... http://www.atlasxl.com.au/DetailFormula.htmMore than 1000 AX Implementations and 10,000 users worldwide use Atlas today. Signup for a free trial at http://partner.atlasxl.com.au (please be patient with this site..it's 100% AX!), you will need to know your AX Serial number. Regards Steve From: Axapta-Knowledge-Village@yahoogroups.com on behalf of Zvika Rimalt Sent: Wed 19/11/2008 5:33 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Microsoft SNAP vs. Atlas XL I am looking at 2 Dynamics AX and Excel integration tools. I am fairly familiar with Atlas XL but never worked with Microsoft SNAP. Has anyone had an opportunity to use the Microsoft provided SNAP integration with Excel? And how did you find it in comparison with Atlas XL? Do you think there is additional value (more features, ease of use etc.) of using the Atlas XL add-on, rather than the Microsoft native integration? Zvika winmail.dat
RE: [Axapta-Knowledge-Village] How to protect code in Axapta???
AX is open source...enjoy! From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of jazib.abdulah Sent: Monday, 8 September 2008 7:26 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] How to protect code in Axapta??? Hi guys, need your help How can I protect my code in Axapta??? I have written some code at USR layer and my employer wants to protect it before installing it at customers sites. How can I do that ? Thanks
RE: [Axapta-Knowledge-Village] AxaptaCOMConnector on WindowsCE
Chris How did you get the COM Connector on the device (AXCOM.DLL)? Steve From: Axapta-Knowledge-Village@yahoogroups.com on behalf of kwit1962 Sent: Wed 16/07/2008 9:50 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] AxaptaCOMConnector on WindowsCE Hi! I want to use Ax3.5 ComClients on Symbol MC-3090 devices with WindowsCE. The way to solve, I've heard, is to use Visual Studio 2003. I've used this product (2003.NET + SP1) and in Microsoft Visual Basic I can produce an app for WindowsCE. Everything works fine until I add a reference to AxaptaCOMConnector. Can anyone give me Status Quo to basic solving of such project regards Chris winmail.dat
RE: [Axapta-Knowledge-Village] Withholding Tax Issue --- URGENT HELP REQUIRED
You need to turn on Australian Country Configuration Key. Steve From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Sanam Khan Sent: Friday, 30 May 2008 12:51 PM To: Axapta-Knowledge-Village@yahoogroups.com Cc: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Withholding Tax Issue --- URGENT HELP REQUIRED Hii all Can anyone tell me that what is actually required to enable WH tax complete functionality in AX. The problem is that It is not showing me the following reports GL Reports Externalwithholding tax-monthly report GL Reports Externalwithholding tax-yearly report Is there some country /Region setting missing because of which its not showing or whats the reason.kindly help me out Any help would be highly appreciated Regards, Sanam Khan
RE: [Axapta-Knowledge-Village] Payment of Staff Debtors
Attempting to pay a staff member will make them a VENDOR, not a customer. That should work. Stee From: Axapta-Knowledge-Village@yahoogroups.com on behalf of leroux_marica Sent: Thu 3/04/2008 3:04 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Payment of Staff Debtors Hi All, I am attempting to pay a staff member through Dynamics, which will in effect make that employee a staff debtor (customer). My challenge is this: If I utilize the payment journal through Accounts Payable I am only able to select vendors. Does anyone have any ideas on how to make this payment work? Thanks Marica winmail.dat
RE: [Axapta-Knowledge-Village] Credit Card process
Take a look at www.redmaple.com Their credit card module is very mature. Steve From: Axapta-Knowledge-Village@yahoogroups.com on behalf of Ashokkumar Sent: Sat 29/12/2007 7:40 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Credit Card process hi any body help for credit card process in axapta 3.0 Keep Smiling. Have a Nice Day G.Ashokkumar - Sent from Yahoo! #45; a smarter inbox. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] How to overcome auto save option in all forms.
That's not the AX way so unless this is something you want to add to every form in AX (in this release and the next one after that - ax5) I would not bother. AX takes the other approach..save everything without being asked to. If you don't want to save your change then press the ESC key on the keyboard. NOT saving should be seen as the exception, not the reverse. Regards Steve From: Axapta-Knowledge-Village@yahoogroups.com on behalf of knee_soft Sent: Thu 29/11/2007 5:40 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] How to overcome auto save option in all forms. hi all, if there is any possibilities to overcome auto save option in all the forms. I have created one button called Save, if i click that button then only the record should save in Table, other wise don' t save in the table. How to overcome this issue ? any idea Friends.. Regards. K . Neelagandan [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Re: AX 4.0 crashes when getting a date/time column from an ODBC data source
Thanks for the input. We have used the convert to string, then date approach. This bug has surfaced during an upgrade from AX3 to AX4. The AX3 code has been working for 4 years. Regards Steve From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Subbu Sent: Tuesday, 20 November 2007 11:09 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: AX 4.0 crashes when getting a date/time column from an ODBC data source for myDate = resultSet.getDate(1) ; // ERROR !!! do you know the 3rd column is daatetime type?? or you can use the CCADO* classes which are very powerful and very efficient... str getCRMContacts_INV(CustAccount _custAccount) { CCADOConnection Connection; CCADORecordSet adoRecordSet; str fslr1; str fslr2; str packQueryEmp; str packQueryContact; str emailPackQueryEmp; ; fslr1 = ''; fslr2 = ''; packQueryEmp = ''; packQueryContact = ''; emailPackQueryEmp = ''; Select FsemailConfigTable where FsemailConfigTable.RecId != 0; Connection = new CCADOConnection(); Connection.open(FsemailConfigTable.DBString); adoRecordSet = new CCADORecordSet(); adoRecordSet.open( strfmt(SELECT * FROM ACCOUNT where AccountNumber = '%1',_custAccount),connection); while (!adoRecordSet.EOF()) { fslr1 = adoRecordSEt.fields().itemName(AccountId).value(); adoRecordSet.moveNext(); } adoRecordSet.close(); Connection.close(); if(fslr1 != '' ) { Connection = new CCADOConnection(); Connection.open(FsemailConfigTable.DBString); adoRecordSet = new CCADORecordSet(); if(curext() == '110') { adoRecordSet.open((strfmt( SELECT * FROM CONTACT where ACCOUNTID = '%1' and invoicePBG = 1,fslr1)),connection); } else if( curext() == '210' ) { adoRecordSet.open((strfmt( SELECT * FROM CONTACT where ACCOUNTID = '%1' and invoiceFFO = 1,fslr1)),connection); } while (!adoRecordSet.EOF()) { select FstmpEmailList; FstmpEmailList.ToEmail = adoRecordSEt.fields().itemName (EMailAddress1).value(); FstmpEmailList.insert(); emailPackQueryEmp = emailPackQueryEmp+ adoRecordSEt.fields ().itemName(EMailAddress1).value(); emailPackQueryEmp = emailPackQueryEmp+';'; adoRecordSet.moveNext(); } adoRecordSet.close(); Connection.close(); } return emailPackQueryEmp; } --- In Axapta [EMAIL PROTECTED] mailto:-Knowledge-Village%40yahoogroups.com , cdlmalherbe01 [EMAIL PROTECTED] wrote: Hi again, Instead of using the ODBCConnection and related classes, you could use the CCADO* classes. --- In Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com , Steve Wright steve@ wrote: Hi The code below fails in AX3 3-tier and also in AX 4.0 (which can only be 3-tier). myDate = resultSet.getDate(1) ; // AX CRASH!!! Does anyone know of a workaround? Thanks Steve OdbcConnection connection ; LoginProperty loginProperty = new LoginProperty() ; Statement statement ; ; loginProperty.setDSN(SQL2005Database) ; connection = new OdbcConnection(loginProperty) ; statement = connection.createStatement() ; resultSet = statement.executeQuery(select * from LedgerTrans) ; while (resultSet.next()) { myStr = resultSet.getString(1) ; // Ok myInt = resultSet.getInt(1) ; // Ok myDate = resultSet.getDate(1) ; // ERROR !!! } [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] AX 4.0 crashes when getting a date/time column from an ODBC data source
Hi The code below fails in AX3 3-tier and also in AX 4.0 (which can only be 3-tier). myDate = resultSet.getDate(1) ; // AX CRASH!!! Does anyone know of a workaround? Thanks Steve OdbcConnection connection ; LoginProperty loginProperty = new LoginProperty() ; Statement statement ; ; loginProperty.setDSN(SQL2005Database) ; connection = new OdbcConnection(loginProperty) ; statement = connection.createStatement() ; resultSet = statement.executeQuery(select * from LedgerTrans) ; while (resultSet.next()) { myStr = resultSet.getString(1) ; // Ok myInt = resultSet.getInt(1) ; // Ok myDate = resultSet.getDate(1) ; // ERROR !!! } [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] AX 4.0 SP2 is now available for download from partnersource
A very large fixlist has been provided. SP2 can only be applied to AX 4.0 SP1. Steve. [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Opening balances
Open invoices can be entered into AX as a standard GL journal. In this case you would specify the customer account, invoice number etc and make the offset account in the journal your customer control account. This will make the net effect $0 in the GL but you will now have open invoices for customers. Regards Steve From: Axapta-Knowledge-Village@yahoogroups.com on behalf of kamaraju80 Sent: Wed 25/07/2007 10:32 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Opening balances Hi, Can any one guide me how to handle open invoices in Axapta 4.0. These invoices are for the period prior to Axapta Implementation. Can any one share their valuable experience...It will be of high value. Thanks. V.Kamaraju [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Enterprise Portal
You need to look at the Data Crawler setup in AX (Administration module) to get searching working. Steve From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of dhiraj.karmalkar Sent: Friday, 1 June 2007 2:48 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Enterprise Portal Hi, We are working on Enterprise Portal and I am not getting much of functionality. We have to implement search functionality and I am not at all getting how I can implement that. Can any one please guide me? I am using axapta 3.0 for implementing Enterprise Portal. [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Marked Transactions/Settlements
In the AOT, the table is SpecTrans.based on source table id and record ID of the AP transaction (VendTrans), delete the record and the settlement transaction will be removed. Steve From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James Flavell Sent: Friday, 1 June 2007 7:48 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Marked Transactions/Settlements I think the table is called Specification, use table browser and you should see any markings waiting to be posted in here -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of redneckwoman2151 Sent: 29 May 2007 14:31 To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Marked Transactions/Settlements Hi all, I am currently working with 2.5 I have a problem in my AP module, I am trying to settle some outdated transactions and it shows that one of the transactions is marked for settlement, I cannot locate the marked transaction, does anyone know how to fix this problem? Thank you Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledge-village.tk Yahoo! Groups Links [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Uploading Opening Balances
Hi Subbu Sorry to hear about your support issues. Atlas was developed for AX 2.1 and supports 2.5, 3.0 and 4.0. Next Innovation have requested support for your permission issue from us yesterday.Your import definition can have a user group or ax user id assigned to it, only users in this group (or specific userid) can then use the import. Security needs to be placed in AX at a table level and not a menu level. The thing to remember about Atlas and AX security...all access to AX is controlled by AX security keys, the product itself does no database access itself. If your ax permissions do not allow it (updating, reading) then you will see the normal insufficient access rights error. I will correspond with Next Innovation more on this. Re:loading external item descriptions getting confused about zip codes...forward screen pictures to Next Innovation or our support desk [EMAIL PROTECTED] Regards Steve. Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Subrahmanyam,Mamidi Sent: Thursday, 24 May 2007 11:59 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Uploading Opening Balances Hi Steve, AtlasXl is really a pain as I have been having. FIrst one is, no good support from next innovation. Second thing is: it does not work properly with Ax4.0. I tried to load Item external description, it just looks/points to zipcode. One and foremost thing is, it does not use Axapta security groups and permissions. For example, I have given limited permission to a user. The user is still able to insert/update all the listed main tables via atlas xl Login This disappointed me a lot.. Or just data export wise, yes its good..but for just data import , if the std import does not support my requirements, I rather prefer to write scripts using X++... All I wanted to say is VERY BAD support... I thought of sharing my exp...for atlasxl with Ax4.0. I hope my comments can be taken in a friendly manner! thanks, subbu Steve Wright [EMAIL PROTECTED] mailto:steve%40globesoftware.com.au wrote: Use General Ledger general journal or all opening balances. Step 1. For GL, bring in balances per period per account (so you can use AX for prior period comparisions). Step 2. For customers, one line in the journal per open invoice (the offset account is your customer control account in the GL). The control account is used as the offset so the net effect on it (the control account) is zero. It needs to be zero as step one (above) has the correct balance in it already. Step 3. For vendors, one line in the journal per open invoice, the offset account is your vendor control account) Try using www.atlasxl.com.au It allows you to import AX journals from Excel. Get your data from the old system into Excel and then use Atlas xl to create and import the AX journals. Atlas xl handles number sequences and validation for you. Regards Steve From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of Hardees Buff Sent: Wednesday, 23 May 2007 8:16 PM To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Uploading Opening Balances Hi, I am into my first implementation of AX. I need to upload GL opening balances, Customer Balances and Vendor Balances to be transfered into the system for the first time. Can anyone help me on how to do it? I searched previous posts but could not get anything solid. Thanks, - Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] - Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Uploading Opening Balances
Use General Ledger general journal or all opening balances. Step 1. For GL, bring in balances per period per account (so you can use AX for prior period comparisions). Step 2. For customers, one line in the journal per open invoice (the offset account is your customer control account in the GL). The control account is used as the offset so the net effect on it (the control account) is zero. It needs to be zero as step one (above) has the correct balance in it already. Step 3. For vendors, one line in the journal per open invoice, the offset account is your vendor control account) Try using www.atlasxl.com.au It allows you to import AX journals from Excel. Get your data from the old system into Excel and then use Atlas xl to create and import the AX journals. Atlas xl handles number sequences and validation for you. Regards Steve From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hardees Buff Sent: Wednesday, 23 May 2007 8:16 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Uploading Opening Balances Hi, I am into my first implementation of AX. I need to upload GL opening balances, Customer Balances and Vendor Balances to be transfered into the system for the first time. Can anyone help me on how to do it? I searched previous posts but could not get anything solid. Thanks, - Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] How do you Identify different AX4 instances?
In the client AX Configuration Utility, first tab page there is an entry Startup message.You could place PRODUCTION SYSTEM or TEST SYSTEM etc into this field. Steve From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of thestorm1974 Sent: Monday, 14 May 2007 8:15 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] How do you Identify different AX4 instances? Hi, I have two AX4 instances installed, when you login to AX how can you identify which instance you are using? I know you can check the online users, but in AX 3 it showed you which AOS instance you are attached too. How is tis possible in AX 4, basically I would like an easy way to highlight to users what system they are using. Many Thanks Garry [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Vendor Customer Report - URGENT
URL for that screen shot is www.atlasxl.com.au\VendCustBalanceSample.jpg http://www.atlasxl.com.au/VendCustBalanceSample.jpg http://partner.atlasxl.com.au and signup for a free trial if you're not already a user. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Wright Sent: Wednesday, 4 April 2007 3:07 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Vendor Customer Report - URGENT I have not seen this in AX...but the attached report (screen shot) shows the report you're after using Atlas xl. There are a couple of steps to produce it however total time to build the report...5 minutes. Steve http://partner.atlasxl.com.au and signup for a free trial if you're not already a user. From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of Dynamics Freak Sent: Wednesday, 4 April 2007 8:33 AM To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Vendor Customer Report - URGENT Hi Guys, A reporting clarification - I want to check the balance outstanding for a vendor who is also my customer. For this, In the vendor Master, I specify the customer account.Then I run the Vendor Balances report. But the report shows only the Vendor related transactions. Not the Transactions on the Customer Side? Is there a different report to run to check the net balance? Thanks and Regards, __ 8:00? 8:25? 8:40? Find a flick in no time with the Yahoo! Search movie showtime shortcut. http://tools.search.yahoo.com/shortcuts/#news [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] AtlasXL
Hannes Atlas xl will automatically manage InventDimId's for you.There is a tickbox on the Import Definition template (inside of AX) relating to InventDIM support. From Excel you will be able to see all of the inventory dimensions (Warehouse, Size, Colour, Serial Number, Batch etc) to populate. Atlas xl will create the InventDIM if it has to (it checks the combination first to see if one already exisits). Regards Steve www.atlasxl.com.au From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of JI Markusse Sent: Tuesday, 13 March 2007 3:40 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] AtlasXL Hi Everybody, I have been using AtlasXL for data migration into Axapta and it has been working fairly well. I now want to upload the inventory opening balances into Axapta and I would like AtlasXL to create the InventDimId's for the serialised items. I know this can be done by calling the correct Axapta method. Is there anybody out there that can help me with this problem? Many thanks! Hannes Hannes Markusse Pr. Sci. Nat. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Accessing Dynamics AX 4.0 SP1 environment from outside the domain.
When creating AX users, you need to have a valid domain network account, this is how ax4 knows who you are. Remote Desktop / Citrix still means you need to create a domain network user? Steve From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Lindsay Sent: Monday, 5 March 2007 4:02 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Accessing Dynamics AX 4.0 SP1 environment from outside the domain. Use remote desktop or citrix Confidentiality Notice: This e-mail contains confidential and/or privileged information and is intended to be read only by the person or authorized representative of the organization to whom it is addressed. If you are neither of these persons, you have received this e-mail in error. Please do not print, copy, re-transmit, disseminate or otherwise use the information, all of which are prohibited. Please immediately notify the sender by return e-mail or by telephone at (303) 593-1246 that you have received this communication in error and delete this e-mail from your system. Thank you. MBS Dynamics AX Master John T. Lindsay Micro Sciences 303 593-1246 720 982-4620 _ From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of aziz.tahir Sent: Saturday, March 03, 2007 9:51 AM To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Accessing Dynamics AX 4.0 SP1 environment from outside the domain. Hi all, Please help me in finding the subject scenario. My client wants to provide access to some of his employee who are not part of the domain user. How this can be achieved. Any idea. Regards, and thanks in advance, Tahir Aziz [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] How do I revalue my secondary currency
My ledger has 2 currencies - GBP as my base currency - EURO as my secondary reporting currency How can I revalue the secondary currency ONLY for posted transactions? I don't want to change the amount of my base currency. Thanks Steve. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Free Text Invoice
If the first line in the free text invoice is a negative, it is assumed to be a credit note. Move this down the list if possible and it should be ok. Steve. Reply -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Luxflux Sent: Thursday, 20 April 2006 2:07 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Free Text Invoice Hi to all: Hi have the next problem an dI appreciatte if some of you have the answer. I´m trying to do a free text invoice with several lines, so, one of this lines has a negative ammount. Because of this, my free text invoice become a credit note. My invoice total ammount is positive. Is there some parameter that i´m forgeting. Thanks. Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] AtlasXl users
Hi John As per my email to you directly, check to see if you have enough AX COM licenses. Each concurrent Atlas user requires 1 AX COM license. If so, then check the online users form in AX to see if AX thinks the user is still logged in. Removing axdat.udb will do this however if you don't have enough AX COM licenses then there is no benefit. As far as I know this was resolved in AX 3.0 SP3.The latest copy of AX 4.0 has finally fixed code in the .logout call, in all previous version of AX (back to AX 2.1) this has never worked. Regards, Steve. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of axaptos Sent: Monday, 17 April 2006 11:04 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] AtlasXl users All, Our client buys 2 license users, standard edition. But only 1 user can login. I have restarted the AOS, delete the axdat.udb but still only 1 user can login at a time. There is a warning that the users have exceeded the purchased rights. Axapta licence users are more than enough, any idea? Regards, John Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Excel Add-ins for Axapta
Hi Satish Atlas xl ( at www.atlasxl.com.au ) has the functionality to - Support the AX 3-tier implementation - Requires your AX login password with all AX security supported by Atlas xl - Support AX label files - report off all tables and views in the AOT - upload into any table in the AOT from Excel - support for number sequences (when uploading) Signup for a free trial at http://partner.atlasxl.com.au Regards, Steve -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Satish Sent: Friday, 31 March 2006 2:03 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Excel Add-ins for Axapta Hi, Has anyone worked with Excel add-ins for Axapta? I need to identify,evaluate and recommend one to my client. Any inputs would be greatly appreciated. :) Thanks in anticipation. Regards, Satish Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Excel Add-ins for Axapta
Hi Satish Take a look at www.atlasxl.com.au This Excel add-in has been designed for Dynamics AX since Damgaard Axapta v2.1 and is now available AX 4.0. Regards, Steve. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Satish Sent: Friday, 31 March 2006 2:03 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Excel Add-ins for Axapta Hi, Has anyone worked with Excel add-ins for Axapta? I need to identify,evaluate and recommend one to my client. Any inputs would be greatly appreciated. :) Thanks in anticipation. Regards, Satish Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Axapta SP4
Axapta SP5 is now available from Partnersource. Steve -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of shaik ahmed Sent: Tuesday, 21 March 2006 7:05 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Axapta SP4 Hi Where from i can download the Axapta SP4. Thanks in Advance... Regards Riaz - Yahoo! Mail Bring photos to life! New PhotoMail makes sharing a breeze. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Currency Characters for Symbols
Using windows xp.. Start run charmap You can the find the symbol and you will see you can copy/paste direct into Axapta or take a note of the ALT keypress options. Steve -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Brandon George Sent: Thursday, 2 February 2006 4:53 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Currency Characters for Symbols Does anyone have a lit of Currency Symbols, and the Key's need to create that for the symbol when setting up currencies for at least: GB Pounds Euro Pesos ? Thanks in advance. Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Demo Data
We have the Light Company DMO on our web site for download. http://www.globesoftware.com.au/Atlas/AtlasDEMOCompany.zip (1mb) Or www.atlasxl.com.au download page Demo building a simple report from an empty workbook using Atlas xl... http://www.globesoftware.com.au/Movies/Atlas35SimpleRevenueReport.wmv (3mb) -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Craig Fidler Sent: Monday, 30 January 2006 4:40 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Demo Data Hi, Is there any site that allow download of demo data?? Regards Craig The views expressed in this email are, unless otherwise stated, those of the author and not those of the BS3 Group or its management. The information in this e-mail is confidential and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted in reliance on this, is prohibited and may be unlawful. Whilst all reasonable steps are taken to ensure the accuracy and integrity of information and data transmitted electronically and to preserve the confidentiality thereof, no liability or responsibility whatsoever is accepted if information or data is, for whatever reason corrupted or does not reach its intended destination. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Has anyone Axapta 4.0 News?
Beta 2 has been released to the beta program members. I am unsure when/if a public beta will be available. I would expect the Microsoft ConvergenceConference in March will contain a lot of AX 4.0 sessions. Regards. Steve From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andreas RudischhauserSent: Monday, 9 January 2006 6:31 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Has anyone Axapta 4.0 News? When is the beta coming and such things Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] we have 120 license,but only 110-114user logined and axapta give not enought license message,why?
Which version of Axapta and Service pack do you have. I know this was a problem with Axapta 2.5 which SP4 resolved. Regards Steve -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, 24 October 2005 1:49 PM To: Axapta-Knowledge-Village; Axapta-Knowledge-Village; Axapta_Documentation Subject: [Axapta-Knowledge-Village] we have 120 license,but only 110-114user logined and axapta give not enought license message,why? dear all, some times we can login 115 users,sometimes we only can login 112,and then the system give me the following message: cannot start navision axapta,as more users are running the system than the purchased rights allow. could some one give me some sollution or advice?? Best regards, qhpeng [EMAIL PROTECTED] 2005-10-24 Yahoo! Groups Sponsor ~-- Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Axapta Data Dictionary and physical table tructure not match
I expect that the AOT would complain the complete set of fields on a table. If you have used configuration keys to turn off features that would introduce fields, these fields would already be in the AOT (it must in order to compile clean) but not in SQL. Turn on the configurations and Axapta will Synchronise and create the columns it needs to. Steve. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Peter CCH Sent: Wednesday, 19 October 2005 2:35 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Axapta Data Dictionary and physical table tructure not match I open the table structure in Axapta Data Dictionary and physically open the table structure of the database. I found that there's some slight difference between it. I can see about 13 fields extra at the table in Axapta Data Dictionary, but when I physically look at it the physical database structure (Oracle), that 13 fields is not in there. I tried synchronize the data dictionary and even particularly synchronize that table, but it still the same. Is there any possibility that a license will restrict the field creation in physical database? Or how this could happen? -- I started to look at it when there's some error logged into SysTraceTableSQL. Peter CCH Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Consignment (3rd party) stock
You can create an Inventory location/warehouse for this. Items On Hand for this location will be your consignment stock. Steve. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hennie PotgieterSent: Tuesday, 18 October 2005 9:31 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Consignment (3rd party) stock Hi all, Can Axaptas inventory model and financials handle consignment / 3rd party stock items? I cannot find anything that looks like consignment stock in the inventory module. Can anyone please give me any pointers on this? Regards, Hennie Sharing the knowledge on Axapta. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] XPO import some properties missed out
Title: Message James The same bug is in SP3. The only solution I have is to import the .xpo 2 or 3 times. Steve From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James FlavellSent: Wednesday, 10 August 2005 12:03 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] XPO import some properties missed out Hi everyone, does anyone know or have experience of an XPO import not importing all the properties correctly? I think I remember seeing a posting long ago but cannot find it... It seems I have v3.0 SP2 and some XPO imported do not have all the properties set (such as alignment), this is of course a very serious problem if we cannot trust an XPO is imported 'fully' and so I need to get to the bottom of this. I know there has been alot of posting aboutimport with and without ID, is this likely to have any effect? Thanks James Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Inventory management - Physical Value by Item Group Report
Try this menu... General Ledger Reports Reconciliation. You will find Inventory in there. S. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Koh Meng ChiatSent: Thursday, 23 June 2005 3:57 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] Inventory management - Physical Value by Item Group Report Hi Harry,Just want to check. Where / how can i analyze thevariances between Inventory and GL? Can i break downthe variances into its detail transactions?Thanks in advance.Best Regards,Jack Koh --- "Harry (Harshawardhan Deshpande"[EMAIL PROTECTED] wrote: hi Try this run the same report as of a date less than the go live date say 1 Jan 1990 and see if the physical inventory report prints this amount? regards harry Koh Meng Chiat [EMAIL PROTECTED] wrote: Hi Harry, Yes. We're currently facing some problems as the discrepancies between inventory on hand and GL inventory are hard to trace. For example, if there is a difference of 1511.02 between inventory and GL, how can one identifies the causes of the differences? Do appreciate your valuable advice. :) Thanks in advance. --- "Harry (Harshawardhan Deshpande" [EMAIL PROTECTED] wrote: hiThe way our client does this is that he reconciles the total of physical value with the gl balance as of a particular date.are u facing any problems with this?regards harry Koh Meng Chiat [EMAIL PROTECTED] wrote: Hi Harry, Thanks for your prompt reply. Just curious how should the user perform Inventory reconciliation with GL. The steps should it be:1. Print out Pyhsical Value by Item Group Report in Inventory Management Module as of closing date (ideally month end) 2. Print out Ledger Transaction List in General Ledger Module. OR Print out Reconciliation report (GL Reports Reconciliation Inventory)?? 3. Compare both reports and find out the unreconciling items?? Appreciate your valuable advice.Best Regards,Jack Koh "Harry (Harshawardhan Deshpande" [EMAIL PROTECTED] wrote: hi 1. Yes 2. known value is invoice updated SO/PO, costed production orders etc. Anything before that is floating. (I hope).regards harryKoh Meng Chiat [EMAIL PROTECTED] wrote: Hi all,2 questions: 1. Can i use Pyhsical Value by Item Group Report to reconcile with my GL stock? I think most of you had encountered this before as there is no specific report in inventory module which can help to reconcile with your GL. (Note: The inventory reconcilation report does not provide sufficient information in terms of GL stocks and stock value in inventory) 2. What is the "Known Value" column in Physical Value by Item Group Report? Appreciate any help.Thanks in advance. Best Regards,Jack Koh Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Footballhttp://football.fantasysports.yahoo.com Sharing the knowledge on Axapta. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. - Yahoo! Groups LinksTo visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. - Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. === message truncated ===__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo!
RE: [Axapta-Knowledge-Village] Upgrading Axapta 2.5MP to Axsapta 3.0 sp3.
Title: Message Do you know if you have applied Hotfix 4 for Axapta 3 SP3. This is... HF30SP3_004, Hot Fix Corrections made for: This Hot Fix is related to Axapta SE PS 155 / (NSS# DK-644-614-J8RZ), but is more like a general solution to consider when big databases are upgraded and performance is an issue Steve. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Myrl StadnickSent: Tuesday, 17 May 2005 2:25 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Upgrading Axapta 2.5MP to Axsapta 3.0 sp3. I am in the process of Upgrading Axapta 2.5MP to Axsapta 3.0 sp3. I did not have an adequate server and tried to Syncronize the database it took 3 days. I have rented a server with 6 GB of memory dual 2.8 Xeon processors on a Compaq DL380 server. The syncronize now only takes a few hours but I am having a problem with the data Update. I seem to get locked processes when trying to do the update. The jobs that get hung up will not show executing in the data update cockpit. But do show as executing in the Batch list. I understand that we can open up many clients to do the update quicker; but immediatly after opening up more than two clients (DataUpdate Cockpit, and the client to run Jobs.)I get locked processes and Sql will not release the locked process. I can kill the clients and the AXDB database will recover itself after about 6 hours sometimes longer. Regards, Myrl Stadnick Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Re: Report Writer
Hi Kevin. Please feel free to email me directly [EMAIL PROTECTED] with your thoughts on how we can improve Atlas xl. I am always requesting feedback from partners and end users so that Atlas xl remains the leading 3rd party report writer developed specifically for Axapta. You are correct, Atlas 3.5 which will be released at the Microsoft Worldwide Partner Conference early July will support every table in Axapta, including any tables added yourself. Thank you Steve. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of kvnbatmanSent: Wednesday, 11 May 2005 10:54 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Re: Report Writer Chris,I wasn't too impressed with Atlas either, but I know that a new release is coming out that allow you to report on data from any table or field in Axapta (not just GL). You may want to get more information on the new release.Kevin--- In Axapta-Knowledge-Village@yahoogroups.com, "leganchris" [EMAIL PROTECTED] wrote: Hello. I am looking for a report package that integrates in with Axapta. I have used FRX and Atlas, and was not too impressed with either of them. Does anyone know of a not so complex report writer that is available for Axapta? Thanks ChrisSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Introduction...
www.perfectprogramming.com.au (bold statement!) have a version control module - 100% Axapta! Steve From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Harry (Harshawardhan DeshpandeSent: Friday, 15 April 2005 6:57 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] Introduction... hi So you are basically using version control to essentially tocompare the changes and not to necessarily to reset the project. I did try my hands on version control but realised thatcomparing changes made by different developers at different point of time is a massive pain. I however find comments (and with very strict control on the structure of the comments)very useful to compare the changes and ofcourse distrubution of work to developers so that there is minimumconflict (whenever possible). Can I ask you something? How many times did you have to actually use the version control to really really compare the changes? I believe I have worked alongside quite a few cowboys and even then I never had any problems with using comments to compare the changes. Another problem is that to domeaningful version control every singlemodification will have to have a well-defined and documented break-point, otherwise the saved data just will not make any sense. regards harry ps: please do give my regards to david payneMaurice Cohen [EMAIL PROTECTED] wrote: Hi Harry, Version control is not necessary if you are the only developer working on a project. In this case, you are right you might as well backup the previous file. But if you work on large projects with multiple developers working on the same project affecting the same areas or not then version control becomes essential. With the version control we use we can keep track and compare changes made by different developers at the same layer. We can go back to any previous version. Versions can be saved for any project, group of projects or for all (build). Maurice Advanced Systems Integration, Inc. 26449 Rancho Parkway South Lake Forest, CA 92630 ph: 949-597-2170 fax: 949-597-0720 cell: 949-533-5966 From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com] On Behalf Of Harry (Harshawardhan DeshpandeSent: Thursday, April 14, 2005 3:20 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] Introduction... hi Maurice I always wonder how any version control will work in Axapta. Version control with a specific project is not practical since If I want to go back to the previous version then there is a very good chance that I will reset the code written for some other project and this thing will not be discovered till its too late. Version control will certainly work when the Axapta implementation is divided into various stages. However, in this case its easier just to keep a back up of axvar.aod I have not used any kind of a version control for the last three years and never had any problems. (Except @one site where I did keep a back up of axvar.aod @various points of time , it was a big and clearly defined project) Looking forward to your comments. regards harry Maurice Cohen [EMAIL PROTECTED] wrote: Hi Brandon, We experienced with visual source safe and Axapta but we determined that it was not practical. Instead we are using the Axapta version control (not a standard module) which works very well. Maurice Cohen Advanced Systems Integration, Inc. 26449 Rancho Parkway South Lake Forest, CA 92630 ph: 949-597-2170 fax: 949-597-0720 cell: 949-533-5966 From: Brandon George [mailto:[EMAIL PROTECTED] Sent: Thursday, April 14, 2005 8:38 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Introduction... Hello All! My Name is Brandon - I am a Software Engineer from Georgia, U.S. I was invited by someone to join this group. Our company is implementing Axapta right now, and I am part of the Development / Support / Admin team for it. This is my first exposure to axapta, but I have been developing software for years - I am a C# for Windows / Web / Mobile Developer, and I can't wait to start diving into X++ and Axapta. Anyway I do have a few questions: (1) Has anyone ever tried to store projects / objects etc. into VSS (Visual Source Safe)? We are wanting to continue to use VSS for our version control just like we use it for the rest of our projects.
RE: AW: [Axapta-Knowledge-Village] reporting tools and Axapta
Try taking a look at Atlas xl Management Reporting for Axapta. This product integrates Excel with Axapta and can easily provide your multi-dimensional financial reporting. www.atlasxl.com.au Steve From: Subrahmanyam Mamidi [mailto:[EMAIL PROTECTED] Sent: Sunday, 27 February 2005 2:18 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: AW: [Axapta-Knowledge-Village] reporting tools and Axapta Hi Rocco, We didn't buy Axapta OLAP for our reporting. Let me briefly give me my project scenarios. We had to develope PL reports in Various currencies. The problem with the format of the P:L is , some of the rows in the PL had to be shown by Cost center /department wise while someoter rows direct account wise. And as you know Axapta can not handle multi dimensional financial reporting. Hence we opted for Targit. Waht happens is : Targit also can not handle multi dimensiona reporting if it uses Axapta database. The problem is not with the Targit. Its the problem with Axapta. Why because, TARGIT database is directly coupled with Axapta Live database so are the tables are mapped to directly with Targit tables. So we run the DTS packae to refresh the TARGIT data base so that it will fetch the data as in Axapta at the aprticular point of time. It lead to enough maintenace. Like suddenly they used to post some entries and they would like to see asap. Then I wake at the midnight, and refresh the Targit EM in order to show the latest data. Hence I created those reports in Axapta using some temp tables etc etc.. Now we are using targit only for sales reporting. Because sales data we get from XL files from outside the company. Hence we upload those data ( getting rid of Axapta tables ) in to self created tables in Targit. Hence we can show reports like anyway we wanted as its not using axapta database ( or the mapped to axapta tables ). Shipement history by location,by customer, by product , bar,pie etc tec etc etc... Numerous cubes and dimesions have been created to show the reports in various dimesions for these data which came from XL. Presently, weare uploading approximately 10M records in the sales/shipment history. The performance is good. I would say, it depends upon ur reports formats( financial ). If the reports are half single dimesional and half the report is multiple dimesional, its not Possible in targit if they are connected to axapta DB. but if you want two seperate reports, with one report single dimesional and the other report mutli dimesional, its possible in targit. But in the same report, with mixed dimensional its not possible. we have to manually created hundres of calculations which slows the targit perofrmance . its very cumbersome to make any changes to that type of reports. I am not very sure if I have answered your Q . but if you need anymore clarifiacations, please contact me as we are using Targit since 6 months. And we know what Targit can do also. Thanks Regards, subbu Rocco Giumelli [EMAIL PROTECTED] wrote: Hi Subbu Do you like the OLAP that is within Axapta or a SQL Bolt-on ? Multi dimension is critical in our workplace. My major concern is that Axapta Internal OLAP will slow everything else down while it builds the cubes or does anything quick and easy for the boss.. Can you explain 'can't handle multiple dimensional financial reports' like Branch Department Purpose , or do you mean more than that. Thankyou for taking the time to express an opinion. Rocco From: Subrahmanyam Mamidi [mailto:[EMAIL PROTECTED] Sent: Saturday, 26 February 2005 1:52 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: AW: [Axapta-Knowledge-Village] reporting tools and Axapta We are currently using TARGIT ( denmark ). Its good for Sales shipment/Sales related stuff. But I prefer Axapta for Financial reports.but hey, TARGIT can't handle multiple dimensional financial reports.. best of luck. regards, subbu"Leberbauer, Herbert - News" [EMAIL PROTECTED] wrote: Hi Willem! Maybe it was already mentionend, but did you take a look at Business Analytics (BA)from Targit? They have some cubes for Axapta, and it doesn't touch Axapta too. It only connects to the DB where Axapta is located and transfers the data to its own DB (which is MS SQL). But there are DTS possibilities in SQL Server getting data from Oracle, so this should be no problem. On the other side until now we haveBA only implemented with MS SQL (both for Axapta, and BA). But the response from our customers is very good. I'm also interested on how you'll solve this situation. regards Herbert Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 25. Februar 2005 15:52An: Axapta-Knowledge-Village@yahoogroups.comBetreff: RE:
RE: [Axapta-Knowledge-Village] X++ Reference/Instruction
Inside Axapta, take a look at Help Axapta Developers Guide, you will find the full syntax. Also, in the AOT you should find tutorial forms and reports (all being with a 'T"). Otherwise book yourself on an x++ course or a java course. Steve. From: super_hero32 [mailto:[EMAIL PROTECTED] Sent: Thursday, 3 February 2005 8:53 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] X++ Reference/Instruction Hello,Another newbie to the Axapta world and I am being asked to develop reports and new forms for users.I have had no formal training on X++ and am stuggling to understand the language and syntax without some sort of manual or how to guide.Does anyone have or know of any helpful resources that would be available to me?Any help is greatly appreciated.Michael MussmanBehringer USASharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] announcements from MBS
I have heard that in Axapta 4 a lot of form logic will be pushed out to classes so that we can make better use of calling X++ from outside. Steve. From: Andrae, Tobias [mailto:[EMAIL PROTECTED] Sent: Monday, 31 January 2005 7:24 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: AW: [Axapta-Knowledge-Village] announcements from MBS By the way: "Microsoft officials decided to delay Axapta in order to open up the application programming interfaces (APIs) and add a software development kit (SDK) to the product, " ... what would you call the MorphX / X++ environment, which is part of Axapta from the start ?? -Ursprüngliche Nachricht- Von: Jesper Kehlet [mailto:[EMAIL PROTECTED] Gesendet: Sa 29.01.2005 01:57 An: Axapta-Knowledge-Village@yahoogroups.com Cc: Betreff: RE: [Axapta-Knowledge-Village] announcements from MBS It's not the first time an ERP product such as GP or Axapta or anything in that category has been delayed. Your statement makes it obvious that you are new to Axapta, possibly even new to ERP systems in general, and statements like this are truly worthless opinions. Before you get upset, let me tell you that we are many people that are tired of this happening again and again, but we've grown to expect it, and although it may be a cynical view, we'll be surprised if there is ever a release that comes out as promised. With regards to the ERP strategy, it has never been Microsoft's intention to keep several (competing) ERP product lines, and it's obvious that Great Plains is at the end of its life cycle along with XAL, C5, C4, Solomon. Also, I would not be surprised to see Navision go into maintenance mode soon. And that's the way it is with great products. Even Henry Ford discontinued the Ford T, because although popular, it was also getting old and outdated with time, and never technologies provided for cheaper and better models. From: serioga [mailto:[EMAIL PROTECTED] Sent: Friday, January 28, 2005 5:24 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] announcements from MBS http://www.microsoft-watch.com/article2/0,1995,1756529,00.asp"Microsoft has pushed back the 4.0 release of its high-end ERPoffering to 2006 and is hinting it will soon move some its ERP waresinto 'maintenance mode.'Microsoft's ERP strategy is morphing.Axapta, one of Microsoft's four ERP products, has fallen victim toMicrosoft's slip-date curse. Meanwhile, it sounds as if Microsoft hasstarted to take measures to streamline its stable of four differentERP lines."Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] query range - like
I think sCrit should be a comma separated list "*CPP*,*RV*" as this is standard Axapta syntax when entering filters, eg in the Ledger Transactions Inquiry form. You should not need to know ANY SQL to do an Axapta query - tableid and fieldid/values should be enough. S From: anton_tjiptadi [mailto:[EMAIL PROTECTED] Sent: Wednesday, 12 January 2005 12:32 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] query range - like I want to create query range with "like" and "or" criteria", something like this :(SQL Statement)select accountnum, voucher, * from ledgerjournaltrans where voucher like '%CPP%' or voucher like '%RV%'My statement rises an error if I wrote it like this one in X++ :sCrit = strFmt('((Voucher like %1) || (Voucher like %2))', "*CPP*", "*RV*");qRange2 = qbds1.addRange(fieldnum(LedgerJournalTrans, Voucher));qRange2.value(sCrit);please help,thanks in advance,AntonSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Customer inquiry
There is a transactiontype field on custtrans which can tell you where the transaction originated from. For example - Sales invoice from Sales Order Invoicing - Customer is from Free Text Invoicing HOWEVER you may have to fix Axapta as it normally leaves this field blank - which is really a strange thing. Steve From: Ahmed Ibrahim [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 November 2004 11:35 PMTo: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] Customer inquiry Thanks so much James, I checked the CustTrans table, it including all customer transactions (Sales, credit note and payments) but I want to know how to segregate Receipts, Cash discounts, Sales, Credit notedand any other kind of transations. is there any way to know the type of tranaction in custTrans. regards Ahmed James Flavell [EMAIL PROTECTED] wrote: Hi Ahmed, Its CustTrans and not CustInvoiceTransyou need if you want balances (I take it meaning unsettled amount on a transaction) James -Original Message-From: Ahmed Ibrahim [mailto:[EMAIL PROTECTED]Sent: 24 November 2004 13:56To: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] Customer inquiry Thanks James, I will try to go through custinvoicetrans and will look at standard reports. Ahmed.James Flavell [EMAIL PROTECTED] wrote: I thinksince you mention balance here then you have to focus on the custtrans. If you wanted just list of sales and credit notes then custinvoicetrans would be okay but since you seem to be wanting something with balance then you need to use custtrans I would expect. This can be a bit tricky and I suggest oyu look at the standard reports such as external or internal customer account statement (I tend to just reuse the query logic of this and add my own required format) James -Original Message-From: allie [mailto:[EMAIL PROTECTED]Sent: 24 November 2004 04:00To: [EMAIL PROTECTED]Subject: Re: [Axapta-Knowledge-Village] Customer inquiry The typical tables to use are the Inventjournaltrans,Inventtrans Custinvoicetrans.mbsdeveloper [EMAIL PROTECTED] wrote: Hi ,I want to create a report for the customer movement to show sales, receipts, credit notes, debit notes and balance so I want to know what are the tablesQueries required to get these informationRegards Ahmed El-sayed Sharing the knowledge on Axapta. ALL-NEW Yahoo! Messenger - all new features - even more fun! Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!?The all-new My Yahoo! - Get yours free! Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!?Take Yahoo! Mail with you! Get it on your mobile phone. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor Get unlimited calls to U.S./Canada Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Purchase Contracts in Axapta
You need to have the Trade Agreements module. From an Item, you can create selling agreements for customers and purchase pricing from vendors. This is also available from the customer form and vendor form. Regards, Steve From: Subbu [mailto:[EMAIL PROTECTED] Sent: Thursday, 11 November 2004 3:39 AMTo: [EMAIL PROTECTED]Subject: [Axapta-Knowledge-Village] Purchase Contracts in Axapta Hi,I am trying to seek help in Purchase Contracts. I want to know the following from the guys who have worked in Axapta side.How to attach / create a Purchase contract or agreement in Axapta for the suppliers / Items??Any document?Any help will be greatly appreciated...subbu Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] How to get all offset account info rmation from a vendor?
the voucher number will the same system wide. From: hfmadcr [mailto:[EMAIL PROTECTED] Sent: Thursday, 11 November 2004 7:48 AMTo: [EMAIL PROTECTED]Subject: [Axapta-Knowledge-Village] How to get all offset account information from a vendor? Hello. I'm making a report listing all offset account of a vendor. To get alloffset account I extract the information from the "LedgerTrans" table,but I need show in some cases the Invoice number or cheque number. Theproblem is that I don't know how get the Invoice Number or ChequeNumber from a line of the "LedgerTrans".Or if somebody knows the way to link the LedgerTrans Table with the"LedgerJournalTrans" Table . Thanks in advanceSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Insufficient licence rights erro r starting Axapta for 2nd user onwards
Hi Jim We solved this issue using a windows registry setting on the server. Axapta Technet article 9091 talks about Opportunistic Locking in Windows. What I do not understand is how this is only a problem for Axapta 3 axdat.udb file. Ax2.5 works fine. Regards, Steve. HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MRXSmb\Parameters\OplocksDisabled REG_DWORD 0 or 1Default: 0 (not disabled)NOTE: The OplocksDisabled registry value configures Windows clients toeither request or not request opportunistic locks on a remote file.You can also deny the granting of opportunistic locks by setting thefollowing registry entry to 0:HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\ParametersEnableOplocks REG_DWORD 0 or 1Default: 1 (Enabled by Default)NOTE: The EnableOplocks value configures Windows-based servers(including Workstations sharing files) to allow or deny opportunisticlocks on local files. From: Jim Jo [mailto:[EMAIL PROTECTED] Sent: Thursday, 7 October 2004 12:25 PMTo: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] "Insufficient licence rights" erro r starting Axapta for 2nd user onwards Hi Steve, Jus curious ! have you solved the problem. If so how ? Share ? JimMalcolm Burtt [EMAIL PROTECTED] wrote: Ah, well. Buy BackupExec instead then. :-) Although it considered the .udb file a corrupt file (so I just excluded it from backup) at least it didn't have your problem. Must be very annoying that ArcServe can't cope with it. If the ArcServe agent is anything like the BackupExec one, it isn't cheap. Malcolm. -Original Message-From: David VanEchaute [mailto:[EMAIL PROTECTED]Sent: 06 October 2004 14:27To: '[EMAIL PROTECTED]'Subject: RE: [Axapta-Knowledge-Village] "Insufficient licence rights" erro r starting Axapta for 2nd user onwards Hi, Tried that too before removing the Agent. It didn't help to exclude the file. Would be nice if it did though. David -Original Message-From: Malcolm Burtt [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 06, 2004 8:26 AMTo: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] "Insufficient licence rights" erro r starting Axapta for 2nd user onwards Hi If the ArcServe open file agent is thecause of the problem then maybe you could get the backup to exclude the .udb file. As you say, its not needed anyhow as Axapta will rebuild it if it needs to. That way you cankeep the benefits of the open file agent without the pain. Regards Malcolm Burtt -Original Message-From: David VanEchaute [mailto:[EMAIL PROTECTED]Sent: 06 October 2004 14:21To: '[EMAIL PROTECTED]'Subject: RE: [Axapta-Knowledge-Village] "Insufficient licence rights" erro r starting Axapta for 2nd user onwards Hi, I had the same exact problem. I could log in directly on the application server but yet only one client at a time. I shut down the ArcServe services but it didn't matter. I worked on the problem for weeks before trying to remove\uninstalling the OpenFile Agent. The OpenFile agent locks the udb file somehow and it will only allow one client on. The only file I don't get during the nightly backup now that I have removed the OpenFile agent is the .udb file which isn't a big deal because it is rebuilt if missing anyways. The only way I could get more than one client on after a backup had ran was the get everyone off the system and delete the .udb file and let it rebuild. It would work fine again until the next backup had occurred. Something happens to the .udb file during each backup that keeps more than one client PC from being able to access Axapta. I would uninstall OpenFile agent and get everyone off the system, rename the .udb file to .old and let it rebuild. Take a look at the backup after having removed OpenFile agent and see if you cant backup any "important" files that absolutely need backed up every night without exception. GoodLuck, David -Original Message-From: Steve Wright [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 06, 2004 8:20 AMTo: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] "Insufficient licence rights" erro r starting Axapta for 2nd user onwards Hi David Thank you for your post. I stopped the ArcServe service (via the Windows 2000 Server "Services" icon). There were about 4 services of which one is the Open File Agent. The ArcServe backup job is set to run at 7pm each night, so even with this service running, I would not expect
RE: [Axapta-Knowledge-Village] Insufficient licence rights erro r starting Axapta for 2nd user onwards
Hi Lalith Thank you for your response. The client has 50 end user licenses, but I can't get the second user in. Thanks Steve From: Lalith Jayantha [mailto:[EMAIL PROTECTED] Sent: Wednesday, 6 October 2004 5:49 PMTo: [EMAIL PROTECTED]Subject: Re: [Axapta-Knowledge-Village] "Insufficient licence rights" error starting Axapta for 2nd user onwards Hi check the noofuser licence is activated to 20 by going to administrator menu licen information LalithSteve Wright [EMAIL PROTECTED] wrote: I have a situation running Ax3 SP3 2-tier whereI cannot get more than 1 person logged into Axapta. The technet discussion below is exactly the same problem. The resolution was to shutdown ArcServe backup software but we have stopped all services and still nothing. Has anyone a suggestion? Thanks steve Axapta Technet 7316.4 Insufficient licence rights. Can not start Axapta as more users are running the system than the purchased rights allows".My license code in Axapta is for 20 users and when more than 1 user tries to connect the Axapta we get the message above. We check the permission (full access) on the Axapta folder and defined as shared. We can concurrently run Axapta on Axapta application server (Axapta install+ Sql Server install same machine) and we can run one client machine, then no other machine can connect, we receive the message that we can not login because there are no available liceneses on any other machine . If we log off client Machine 1 then we can start from client machine 2 but no other machine then can login, or sometimes If we can run Axapta on server, client machine 1, client machine 2 then no other client machine can connect.Sharing the knowledge on Axapta. Do you Yahoo!?Yahoo! Mail Address AutoComplete - You start. We finish. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Insufficient licence rights erro r starting Axapta for 2nd user onwards
Hi David Thank you for your post. I stopped the ArcServe service (via the Windows 2000 Server "Services" icon). There were about 4 services of which one is the Open File Agent. The ArcServe backup job is set to run at 7pm each night, so even with this service running, I would not expect it to lock the axdat.udb file until the backup job started at 7pm. My question is, Is shutting down the service as good as uninstalling ArcServ? Thanks Steve From: David VanEchaute [mailto:[EMAIL PROTECTED] Sent: Wednesday, 6 October 2004 8:56 PMTo: '[EMAIL PROTECTED]'Subject: RE: [Axapta-Knowledge-Village] "Insufficient licence rights" erro r starting Axapta for 2nd user onwards Hi, If you have ArcServe OpenFile agent loaded on the Server the Axapta application files are located on you need to completely uninstall the agent. The ArcServe SQL agent doesn't cause a problem with the Axapta application but the OpenFile agent locks the .udb file. David -Original Message-----From: Steve Wright [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 06, 2004 7:08 AMTo: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] "Insufficient licence rights" erro r starting Axapta for 2nd user onwards Hi Tobias Thank you for your post. We have taken read-only off all of the application folders...but I am unsure about the client folders. Thanks steve From: Andrae, Tobias [mailto:[EMAIL PROTECTED] Sent: Wednesday, 6 October 2004 5:59 PMTo: [EMAIL PROTECTED]Subject: AW: [Axapta-Knowledge-Village] "Insufficient licence rights" error starting Axapta for 2nd user onwards Are there any read-only-flags in your Application directory? Try to reset everything to readwrite, including subdirectories. Important: Do this for zhe user that runs that Axapta client ;-)) Hth Tobias -Ursprüngliche Nachricht-Von: Steve Wright [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 6. Oktober 2004 11:21An: [EMAIL PROTECTED]Betreff: [Axapta-Knowledge-Village] "Insufficient licence rights" error starting Axapta for 2nd user onwards I have a situation running Ax3 SP3 2-tier whereI cannot get more than 1 person logged into Axapta. The technet discussion below is exactly the same problem. The resolution was to shutdown ArcServe backup software but we have stopped all services and still nothing. Has anyone a suggestion? Thanks Steve Axapta Technet 7316.4 Insufficient licence rights. Can not start Axapta as more users are running the system than the purchased rights allows".My license code in Axapta is for 20 users and when more than 1 user tries to connect the Axapta we get the message above. We check the permission (full access) on the Axapta folder and defined as shared. We can concurrently run Axapta on Axapta application server (Axapta install+ Sql Server install same machine) and we can run one client machine, then no other machine can connect, we receive the message that we can not login because there are no available liceneses on any other machine . If we log off client Machine 1 then we can start from client machine 2 but no other machine then can login, or sometimes If we can run Axapta on server, client machine 1, client machine 2 then no other client machine can connect. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Insufficient licence rights erro r starting Axapta for 2nd user onwards
Hi Tobias Thank you for your post. We have taken read-only off all of the application folders...but I am unsure about the client folders. Thanks steve From: Andrae, Tobias [mailto:[EMAIL PROTECTED] Sent: Wednesday, 6 October 2004 5:59 PMTo: [EMAIL PROTECTED]Subject: AW: [Axapta-Knowledge-Village] "Insufficient licence rights" error starting Axapta for 2nd user onwards Are there any read-only-flags in your Application directory? Try to reset everything to readwrite, including subdirectories. Important: Do this for zhe user that runs that Axapta client ;-)) Hth Tobias -Ursprüngliche Nachricht-Von: Steve Wright [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 6. Oktober 2004 11:21An: [EMAIL PROTECTED]Betreff: [Axapta-Knowledge-Village] "Insufficient licence rights" error starting Axapta for 2nd user onwards I have a situation running Ax3 SP3 2-tier whereI cannot get more than 1 person logged into Axapta. The technet discussion below is exactly the same problem. The resolution was to shutdown ArcServe backup software but we have stopped all services and still nothing. Has anyone a suggestion? Thanks Steve Axapta Technet 7316.4 Insufficient licence rights. Can not start Axapta as more users are running the system than the purchased rights allows".My license code in Axapta is for 20 users and when more than 1 user tries to connect the Axapta we get the message above. We check the permission (full access) on the Axapta folder and defined as shared. We can concurrently run Axapta on Axapta application server (Axapta install+ Sql Server install same machine) and we can run one client machine, then no other machine can connect, we receive the message that we can not login because there are no available liceneses on any other machine . If we log off client Machine 1 then we can start from client machine 2 but no other machine then can login, or sometimes If we can run Axapta on server, client machine 1, client machine 2 then no other client machine can connect. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Insufficient licence rights erro r starting Axapta for 2nd user onwards
Hi Tobias We are running only in 2-tier so there is no AOS installed. The axdat.udb file has been deleted several times during our day. No matter which PC is used, the second computer cannot gain access. Thanks Steve. From: Andrae, Tobias [mailto:[EMAIL PROTECTED] Sent: Wednesday, 6 October 2004 8:49 PMTo: [EMAIL PROTECTED]Subject: AW: [Axapta-Knowledge-Village] "Insufficient licence rights" error starting Axapta for 2nd user onwards Hi Steve, Client read-only should not be a problem here. Did you ever try to delete axdat.udb from the Application directory? (you have to stop all clients and or AOS before this is possible). Tobias -Ursprüngliche Nachricht-Von: Steve Wright [mailto:[EMAIL PROTECTED].com.au] Gesendet: Mittwoch, 6. Oktober 2004 14:08An: [EMAIL PROTECTED]Betreff: RE: [Axapta-Knowledge-Village] "Insufficient licence rights" error starting Axapta for 2nd user onwards Hi Tobias Thank you for your post. We have taken read-only off all of the application folders...but I am unsure about the client folders. Thanks steve From: Andrae, Tobias [mailto:[EMAIL PROTECTED] Sent: Wednesday, 6 October 2004 5:59 PMTo: [EMAIL PROTECTED]Subject: AW: [Axapta-Knowledge-Village] "Insufficient licence rights" error starting Axapta for 2nd user onwards Are there any read-only-flags in your Application directory? Try to reset everything to readwrite, including subdirectories. Important: Do this for zhe user that runs that Axapta client ;-)) Hth Tobias -Ursprüngliche Nachricht-Von: Steve Wright [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 6. Oktober 2004 11:21An: [EMAIL PROTECTED]Betreff: [Axapta-Knowledge-Village] "Insufficient licence rights" error starting Axapta for 2nd user onwards I have a situation running Ax3 SP3 2-tier whereI cannot get more than 1 person logged into Axapta. The technet discussion below is exactly the same problem. The resolution was to shutdown ArcServe backup software but we have stopped all services and still nothing. Has anyone a suggestion? Thanks Steve Axapta Technet 7316.4 Insufficient licence rights. Can not start Axapta as more users are running the system than the purchased rights allows".My license code in Axapta is for 20 users and when more than 1 user tries to connect the Axapta we get the message above. We check the permission (full access) on the Axapta folder and defined as shared. We can concurrently run Axapta on Axapta application server (Axapta install+ Sql Server install same machine) and we can run one client machine, then no other machine can connect, we receive the message that we can not login because there are no available liceneses on any other machine . If we log off client Machine 1 then we can start from client machine 2 but no other machine then can login, or sometimes If we can run Axapta on server, client machine 1, client machine 2 then no other client machine can connect. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Insufficient licence rights erro r starting Axapta for 2nd user onwards
Hi Jim Still looking for an answer. I suspect it's network permissions (write access to Axapta folders etc). Steve From: Jim Jo [mailto:[EMAIL PROTECTED] Sent: Thursday, 7 October 2004 12:25 PMTo: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] "Insufficient licence rights" erro r starting Axapta for 2nd user onwards Hi Steve, Jus curious ! have you solved the problem. If so how ? Share ? JimMalcolm Burtt [EMAIL PROTECTED] wrote: Ah, well. Buy BackupExec instead then. :-) Although it considered the .udb file a corrupt file (so I just excluded it from backup) at least it didn't have your problem. Must be very annoying that ArcServe can't cope with it. If the ArcServe agent is anything like the BackupExec one, it isn't cheap. Malcolm. -Original Message-From: David VanEchaute [mailto:[EMAIL PROTECTED]Sent: 06 October 2004 14:27To: '[EMAIL PROTECTED]'Subject: RE: [Axapta-Knowledge-Village] "Insufficient licence rights" erro r starting Axapta for 2nd user onwards Hi, Tried that too before removing the Agent. It didn't help to exclude the file. Would be nice if it did though. David -Original Message-From: Malcolm Burtt [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 06, 2004 8:26 AMTo: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] "Insufficient licence rights" erro r starting Axapta for 2nd user onwards Hi If the ArcServe open file agent is thecause of the problem then maybe you could get the backup to exclude the .udb file. As you say, its not needed anyhow as Axapta will rebuild it if it needs to. That way you cankeep the benefits of the open file agent without the pain. Regards Malcolm Burtt -Original Message-From: David VanEchaute [mailto:[EMAIL PROTECTED]Sent: 06 October 2004 14:21To: '[EMAIL PROTECTED]'Subject: RE: [Axapta-Knowledge-Village] "Insufficient licence rights" erro r starting Axapta for 2nd user onwards Hi, I had the same exact problem. I could log in directly on the application server but yet only one client at a time. I shut down the ArcServe services but it didn't matter. I worked on the problem for weeks before trying to remove\uninstalling the OpenFile Agent. The OpenFile agent locks the udb file somehow and it will only allow one client on. The only file I don't get during the nightly backup now that I have removed the OpenFile agent is the .udb file which isn't a big deal because it is rebuilt if missing anyways. The only way I could get more than one client on after a backup had ran was the get everyone off the system and delete the .udb file and let it rebuild. It would work fine again until the next backup had occurred. Something happens to the .udb file during each backup that keeps more than one client PC from being able to access Axapta. I would uninstall OpenFile agent and get everyone off the system, rename the .udb file to .old and let it rebuild. Take a look at the backup after having removed OpenFile agent and see if you cant backup any "important" files that absolutely need backed up every night without exception. GoodLuck, David -Original Message-From: Steve Wright [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 06, 2004 8:20 AMTo: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] "Insufficient licence rights" erro r starting Axapta for 2nd user onwards Hi David Thank you for your post. I stopped the ArcServe service (via the Windows 2000 Server "Services" icon). There were about 4 services of which one is the Open File Agent. The ArcServe backup job is set to run at 7pm each night, so even with this service running, I would not expect it to lock the axdat.udb file until the backup job started at 7pm. My question is, Is shutting down the service as good as uninstalling ArcServ? Thanks Steve From: David VanEchaute [mailto:[EMAIL PROTECTED] Sent: Wednesday, 6 October 2004 8:56 PMTo: '[EMAIL PROTECTED]'Subject: RE: [Axapta-Knowledge-Village] "Insufficient licence rights" erro r starting Axapta for 2nd user onwards Hi, If you have ArcServe OpenFile agent loaded on the Server the Axapta application files are located on you need to completely uninstall the agent. The ArcServe SQL agent doesn't cause a problem with the Axapta application but the OpenFile agent locks the .udb file. David
RE: [Axapta-Knowledge-Village] Offline Mode
Hi Nitesh Jim - thank you for the referral. Atlas xl Management Reporting for Axapta can be found at www.atlasxl.com.au In addition to reporting, this product lets you create validated journals ( Financials, Assets, Inventory and Projects ) from Excel and post to Axapta. All access if via the Axapta COM client making it compatible with 3-tier AOS, label files, customisation (x++), and Axapta security (as you need to log in using your Axapta username and password). A partner enterprise portal has been developed (100% Axapta!) at http://partner.atlasxl.com.au Regards, Steve. From: NITESH SETH [mailto:[EMAIL PROTECTED] Sent: Wednesday, 29 September 2004 5:10 PMTo: [EMAIL PROTECTED]Subject: Re: [Axapta-Knowledge-Village] Offline Mode hi jim thanks for the reply, frankly speaking the word " atlasxl" is completly new for meso please give the details of that..and i request every gp memeber to give a response to my problem. This will give me wide opportunity of discussing this problem with all axapta people. Regard |NiteshSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Bank reconcilation
Hi Harry You are completely correct on all accounts. It turns out we have added an "Unreconcile" button to the Bank Reconcilation form and not as an AOT job. This will unreoncile the selected bank statement. You are also correct that if manual entries were created they will now be in your GL. In this case the user would need to revisit those entries and remove them from being manual to now reconciling against an existing transaction like any other. Aswith any bits of x++ code you pick up for Axapta, let the buyer beware and test before implementing in a live situation. Regards, Steve. From: Harry Deshpande [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 September 2004 4:56 AMTo: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] Bank reconsilation Hi Steve! We had to write a utility to cancel bank reconciliation. I dont see how you can handle this with a job. Correct me if I am wrong but it seems you have a major bug In case of bank reconciliations where a manual entry has been created, reconciling the bank account posts the entry into ledger. Now if you un-reconcile the statement with a job, make whatever changes you are making and re-reconcile the statement, one more entry will be posted to the GL. Regards harry From: Steve Wright [mailto:[EMAIL PROTECTED] Sent: Monday, 6 September 2004 6:24 p.m.To: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] Bank reconsilation Hi DariusIf you're using Axapta 3, we have written a job to do this. Email me ifyou would like this, you will have to import into the AOT and then run it.Regards,Steve[EMAIL PROTECTED]www.atlasxl.com.au - Management Reporting for Axapta-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, 6 September 2004 2:00 PMTo: [EMAIL PROTECTED]Subject: [Axapta-Knowledge-Village] Bank reconsilationHi, Is there some way of cancelling bank reconsilation, as sometimes happensthat client enters wrong date for it and it needs to be canceled. As far asI know there is no such canceletion but still I need confirmation fromsomebody - becaus there might be..?!Darius Yahoo! Groups Sponsor ~--$9.95 domain names from Yahoo!. Register anything.http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/kGEolB/TM~- Sharing the knowledge on Axapta. Yahoo! Groups LinksSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Stack Trace error
Stack Trace errors normally mean you have a compile error - somewhere. Is this possible? S From: userm1837 [mailto:[EMAIL PROTECTED] Sent: Friday, 30 July 2004 12:07 AMTo: [EMAIL PROTECTED]Subject: [Axapta-Knowledge-Village] Stack Trace error Hi All,Could somebody explain to me what this track error is saying needs to be done.Report Control Object not initialized.Stace Trace:(s)[0:188]\classes\control\left100mm(s)[0:188]\Reports\PurchVendItemStatistics\Designs\ReportDesign\AutoDesignSpecs\[PageHeader:PagerHeader]\methods\ExecuteSection(s)[0:827]\classes\reportSection\ExecuteSection and so forth.What do I need to change?ThanksNote: Is there a reference somewhere that all this stace errors are explained.Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.