[Axapta-Knowledge-Village] How to change the currency format to Indian currency
Hai friends, This is sreekanth iam facing the problem with currency, in the purchase order form in the Net Amount field when we have the amount as 23,45,678=00 in Axapta it is displaying in Millons format,i.e 2,345,678=00 how to change the format in to indian currency i.e in to lacks,Thousands and Hunderds.if any knows reply. with regards , sreekanth.
[Axapta-Knowledge-Village] Strings and Enum Type
Hi all, I have a problem, i currently have a string which i read from a file that contains both alpha and numeric values. eg GA12312.12 FR3123 ER1211 How do i just get the alpha characters ie GA or FR out of the string? And how do i then compare to a Enum type i have created? how do i loop through enum values in code? Thanking you in advance Ricardo
RE: [Axapta-Knowledge-Village] Strings and Enum Type
Get a look at str2enum() method Regards, __ Jérôme Piquot Gédimat Wolff-Catenne 6, rue de la Gare 67120 Ernolsheim sur Bruche France Tél : +33 3 88 59 50 60 Fax: +33 1 41 30 17 34 __ De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de ricardodegouveia Envoyé : mardi 4 décembre 2007 11:57 À : Axapta-Knowledge-Village@yahoogroups.com Objet : [Axapta-Knowledge-Village] Strings and Enum Type Hi all, I have a problem, i currently have a string which i read from a file that contains both alpha and numeric values. eg GA12312.12 FR3123 ER1211 How do i just get the alpha characters ie GA or FR out of the string? And how do i then compare to a Enum type i have created? how do i loop through enum values in code? Thanking you in advance Ricardo [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village]
I was wondering, if anyone could explain this ... :-/ I need to setup Ax in a way that pricing information is not displayed in the InventSum form. While setting this up I noticed, that the Cost Price field is filled out through a datasource display method, averageCostPrice, which is run on the client. However, this datasource display method just returns the InventSum table method costPricePcs. My question: Why not call the table method from the form instead of the datasource method ? Thanks in advance ! /Jens
[Axapta-Knowledge-Village] Re: Document grouping conditions
I still don't know where this is hidden in the main menu but I've found the form. What I was looking for is : SalesSummaryParameters. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Jens Strandberg [EMAIL PROTECTED] wrote: Steeve, I believe that you are looking for Sales Ledger + Setup + Forms; Form sorting ... /Jens _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steeve Gilbert Sent: Monday, December 03, 2007 11:11 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Document grouping conditions I'm looking for the form where you can setup the criteria that decide how a customer document (Picking list, packing slip, invoice) is grouped. By this I mean : If I select 100 orders and try to validate the PackingSlip, Axapta will group them by customer id, shipping address, etc... I'm looking for the form where I setup those condition (customer id, shipping address). If I remember correctly, the form has a tab for each document and in each of them you find 2 list with arrow between them so you can activate a condition or not. I can never manage to remember where this is hidden. If anyone can tell me where I could find that form, that'd be nice. Thanks! [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Re: Document grouping conditions
Actually, AX4.0/SP1, the display menu item for this is SalesFormLetterSortingParameters and the form name is SalesFormLetterSortingParameters and actually it has security key custsetup... AOT path = Cust - Setup - Form - Sort Probably I might be looking differently from what you are looking??? Steeve Gilbert [EMAIL PROTECTED] wrote: I still don't know where this is hidden in the main menu but I've found the form. What I was looking for is : SalesSummaryParameters. Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Jens Strandberg [EMAIL PROTECTED] wrote: Steeve, I believe that you are looking for Sales Ledger + Setup + Forms; Form sorting ... /Jens _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steeve Gilbert Sent: Monday, December 03, 2007 11:11 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Document grouping conditions I'm looking for the form where you can setup the criteria that decide how a customer document (Picking list, packing slip, invoice) is grouped. By this I mean : If I select 100 orders and try to validate the PackingSlip, Axapta will group them by customer id, shipping address, etc... I'm looking for the form where I setup those condition (customer id, shipping address). If I remember correctly, the form has a tab for each document and in each of them you find 2 list with arrow between them so you can activate a condition or not. I can never manage to remember where this is hidden. If anyone can tell me where I could find that form, that'd be nice. Thanks! [Non-text portions of this message have been removed] - Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how. [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] How can Axapta provide report (trial balance) in second home currency
Hi all Need your expertise to advice on how can i make use of Axapta to provide another set of report in USD (second home currency) when current home currency is maitain with SGD. Client is base in S'pore has agree to use SGD as home currency in Axapta. However, due to Accounting policy requirement, client have to prepare another set of financial reports in USD (client's business transact mostly in USD) to submit to auditor. Base on requirement gather from client, they required to Profit Loss Accounts 1. Exchange rate is base on monthly exchange rate (or average rate for the year). Preference will be on monthly exchange rate to achieve greater accuracy. 2. Remove realized unrealized exchange gain/loss for computation. 3. Fixed Asset depreciation disposal at historical rates. Balance Sheet Accounts 1. Exchange rate for monetary accounts (AR, AP, Cash borrowing or lending) is base on year end rate. 2. Exchange rate for non-monetary accounts (fixed asset, inventory, capital reverse) is base on historical rate. 3. Inventory fixed asset will be kept at historical cost when possible. 4. Prior retain earnings share capital kept at historical cost. Does anyone have any idea how can I produce report in USD from above requirement? If you have already impletemented similar requirement for your client, do let me know. Pls advaice. Thank you.
Re: [Axapta-Knowledge-Village] Strings and Enum Type
Hi ricardo, can you use substr method, to get the alpha value alone. ricardodegouveia [EMAIL PROTECTED] wrote: Hi all, I have a problem, i currently have a string which i read from a file that contains both alpha and numeric values. eg GA12312.12 FR3123 ER1211 How do i just get the alpha characters ie GA or FR out of the string? And how do i then compare to a Enum type i have created? how do i loop through enum values in code? Thanking you in advance Ricardo K.Neelagandan. 9994307471. - Get easy, one-click access to your favorites. Make Yahoo! your homepage. [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Strings and Enum Type
Place the following in a job and see what you can get from it: DictTable dictTable; int FieldCount; int NumOfFields; FieldId fieldId; TableId tableId; DictField dictField; DictEnumdictEnum; int enumCount; ; tableId = tableNum(CustInvoiceJour); dictTable = new DictTable(tableId); NumOfFields = dictTable.fieldCnt(); setPrefix(TableId2Name(tableId)); for (FieldCount = 1; FieldCount = NumOfFields; FieldCount++) { fieldId = dictTable.fieldCnt2Id(FieldCount); dictField = new DictField(tableId, fieldId); if (dictField.baseType() == Types::Enum) { dictEnum = new DictEnum(dictField.enumId()); info(strfmt('Field Name - %1', dictTable.fieldName(FieldId))); info(strfmt(' Enum Name - %1', dictEnum.name())); for (enumCount=0;enumCount=dictEnum.values() - 1;enumCount++) { info(strfmt(' %1 %2', enumCount, dictEnum.index2Label(enumCount))); } } } Varden Morris 276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] - Original Message From: neela gandan [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, December 4, 2007 8:45:12 PM Subject: Re: [Axapta-Knowledge-Village] Strings and Enum Type Hi ricardo, can you use substr method, to get the alpha value alone. ricardodegouveia ricardodegouveia@ yahoo.com wrote: Hi all, I have a problem, i currently have a string which i read from a file that contains both alpha and numeric values. eg GA12312.12 FR3123 ER1211 How do i just get the alpha characters ie GA or FR out of the string? And how do i then compare to a Enum type i have created? how do i loop through enum values in code? Thanking you in advance Ricardo K.Neelagandan. 9994307471. - - --- Get easy, one-click access to your favorites. Make Yahoo! your homepage. [Non-text portions of this message have been removed] Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Visual Morphxplorer
Hi everyone, Visual Morphexplorer is the tool for modelling tables and classes in Axapta. But there is limitations. It cannot show tables in method. Tables must declared in classDeclaration to show in Visual MorphEx. Is there any other way, to enhance Visual Morphx so we can get all tables in the class ? It is difficult if we have to move one by one table declaration in each method into classDeclaration. - setiaji -
Re: [Axapta-Knowledge-Village] Displaying an image from a specified path
void showSymbol(FormWindowControl_formWindow, fileName _fileName) { Image logoImage; Bindata binData = new BinData(); Bitmap symbol; ; try { if (binData.loadFile(_fileName)) { symbol = binData.getData(); } if (symbol) { logoImage = new Image(); logoImage.setData(symbol); _formWindow.image(logoImage); _formWindow.widthValue(40);//logoimage.width()); _formWindow.heightValue(40);//(logoimage.height()); } else { _formWindow.imageResource(932); } } catch (EXCEPTION::Warning) { error(StrFmt(@SYS19312, symbol)); } } From: Sumit Loya Sent: Tuesday, December 04, 2007 4:18 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Displaying an image from a specified path Hi, The pic in the Company logo is stored in the database in the table called CompanyImage. It reads the supplied file converts it into binary data and then stores it in the above said table. It is possible to display am image from a path in the system, but problem we normally face is that the image may not be available to all the users in the network if the supplied path is not accessible for all the users. Regards, Sumit On Dec 3, 2007 9:22 PM, [EMAIL PROTECTED] wrote: Hi, think in standard under Basic/Setup/Company Information/ Button Company Logo you found an example for your issue. Best regards Michael From: Barunava Pal Sent: Monday, December 03, 2007 1:19 PM To: Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Displaying an image from a specified path Hello Everybody, If you have done this before, please suggest me. I want to create a from where I will specify the path of an image file and the image will be displayed on the form. The image file will not be stored in the database and it also can not be added as an image resource, i.e. only the path of the file will be specified and the image have to be displayed. Thanks in advance, Barunava Pal Now you can chat without downloading messenger. Go to http://in.messenger.yahoo.com/webmessengerpromo.php [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] [Non-text portions of this message have been removed]