[development-axapta] ISO Country Code

I don't have a standard Axapta DB available to me right now but I'm checking the ISO Country Code in my database I have entry for UK (United Kingdom) and GB (Great Britain).  I don't know much about Europe but Isn't it the same thing?  Official iso-code is supposed to be GB. http://www.iso.ch

RE: [development-axapta] SQL error when log into Axapta - Invalid Object Name 'SQLSYSTEMVARIABLES'

Hi, Really thanks for your help. I'll try it out! Gulden SAYLAN <[EMAIL PROTECTED]> wrote: Hi, I think, you have a problem  about database owner user 'bmssa' on your database (But, You can try after database backup) You should run script for on your database (query analyzer) exec sp_chan

[development-axapta] Upgrade 2.5 to 3.0

We are in the middle of upgrading an Axapta-customer from 2.5 to 3.0 SP2 Does anybody have a document showing the objects that has changed between the versions? We have searched Microsofts webpages including the partnersource but found nothing. Any help would be appreciated. Regards, Bo S

RE: [development-axapta] SQL error when log into Axapta - Invalid Object Name 'SQLSYSTEMVARIABLES'

Thanks Amit, I think the last choise for me but i will add new field "LineNum" to LedgerTrans. Because voucher and transdate is not enough for me. Anil Ozay   _  From: Amit Jain [mailto:[EMAIL PROTECTED] Sent: Friday, May 21, 2004 12:15 PM To: [EMAIL PROTECTED] Subject: RE: [

RE: [development-axapta] SQL error when log into Axapta - Invalid Object Name 'SQLSYSTEMVARIABLES'

Hi Anil, Each transaction in the ledgerjournalTrans and LedgerTrans are related to each other by transdate and voucher and whereas the case of relation of one line of voucher to its transaction is concerned i think there is no relation other then voucher and transdate.  thats why whenever you

[development-axapta] webapp join

Hi all, I created two web tab pages, each consists of a grid with data source property set to 'table1' and 'table2'. The 'table2' is the detail table, so  I set its join source property to 'table1'. But I wonder how to select a row from the first grid (in the first web tab page), so that

[development-axapta] Problem with amount bases of letters!!

Hi folks When we conformed a letters patent we have observed that the amount bases of this letters patent calculates applying the discount total, introduced in the sale order, by each one of the lines. The wished behavior would be that this percentage of discount was applied in the end and not

Re: [development-axapta] using COM in-out params from Axapta

Hi, have a look at the [optional] parameters to the COMVariant constructor. eg: COMVariant comvar_in = new COMVariant(COMVariantInOut::In, COMVariantType::VT_VARIANT); COMVariant comvar_out = new COMVariant(COMVariantInOut::Out, COMVariantType::VT_VARIANT); Amund On Wed, 19 May

RE: [development-axapta] SQL error when log into Axapta - Invalid Object Name 'SQLSYSTEMVARIABLES'

Hi, I think, you have a problem  about database owner user 'bmssa' on your database (But, You can try after database backup) You should run script for on your database (query analyzer) exec sp_change_users_login AUTO_FIX,'bmssa' I hope that solve your problem. -Original Message-

RE: [development-axapta] SQL error when log into Axapta - Invalid Object Name 'SQLSYSTEMVARIABLES'

Hi.. This problem generally occurs when sql server system rights changed. For ex, if you use "bmssa" user to connect to sql server, and if owner of many tables in AXDB is "dmo", you can't select records. So this message occurs. You should change the owners of tables. Regards Anil

RE: [development-axapta] Relation with LedgerJournalTrans and LedgerTrans

Thanks Steve. You are right but i can't find relational record. For ex : LedgerJournalTrans : JournalNum   LineNum   Voucher    AmountCurCredit -   -   - -- 40_JN    1  

RE: [development-axapta] web lookup button

Thank you Gahr for your clues, it works now ! I chose the second option, using webedit control (or webstringcontrol in your term) to handle the integer field. I also found in developer's guide that only webedit and webdate control can have lookup button. Just wonder why do the 'lookup button

[development-axapta] Technet gone?

I see technet has been merged into Partnersource etc so much so I cant find the database compatibility sheet for Axapta. Can anyone give me the URL or send me the latest as I want to know for Oracle 8.01 and Axapta 3.0 Thanks James [Non-text portions of this message have been removed]

[development-axapta] SQL error when log into Axapta - Invalid Object Name 'SQLSYSTEMVARIABLES'

Hi all, Could anyone of you help me to resolve the problem?  When i want to log into axapta the following SQL error occurs SQL has reported the following error: [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid Object name `SQLSYSTEMVARIABLES' You may refer to the error log file for

RE: [development-axapta] Relation with LedgerJournalTrans and Led gerTrans

Hi Anil LedgerJournalTrans is the table that holds most journal entries.   When you post a journal ledgertrans records are created from LedgerJournalTrans. You can link the 2 via JournalNum or Voucher.   One journal line (ledgerjournaltrans) will create a minimum of 2 Ledgertrans records -

[development-axapta] AOS Protocol

Anywhere I can get some tech details on the protocol AOS uses in a three tier environment? And any configuration advice for running in an environment where the AOS server and the clients are separated by a slow WAN link? Any optimizations to make AOS less chatty? Yahoo! Groups Sp