RE: [development-axapta] Rounding

The decround function works just fine. Thanks Otto. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, January 27, 2004 6:59 PMTo: [EMAIL PROTECTED]Subject: AW: [development-axapta] Rounding Hi, use this:   decround(4.321 ,2) 

RE: [development-axapta] Is there any Numeric To Words function ?

Title: RE: [development-axapta] Is there any Numeric To Words function ? Thank's a lot Anil !!! -Original Message- From: Anil Ozay To: [EMAIL PROTECTED] Sent: 1/27/2004 6:59 PM Subject: RE: [development-axapta] Is there any Numeric To Words function ? Hi Arief,   you can use Glo

[development-axapta] Inventory transfer - Question

Hi all, Need help here. The requirement: To transfer item from one location to another. However, i am transfering not 1 qty but many qty with respective serial numbers. How to record in system (inventory transfer journal) where i transfer all the serial numbers at one go, from one locatio

Re: [development-axapta] Document handling

Be sure to uncheck "Use Active documents table" checkbox under Basic/Document management parameters so that you dont have add any table in Active Document Tables. Also check the Document Handling Active under Administration/Users:User Options.   regards, ugur - Original Message -

[development-axapta] Select from Map

Is it possible to run a select based on a map? How? Like I want to select journaltransactions with a given journalid from JournalTransMap. How can I do that?? Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://group

AW: [development-axapta] howto count rows in a OCIConnect ResultSet

not possible without runnig the statement twice (the first in a modified way) example: statement will be select fieldlist from sometableorview wherecondition modify the statement as follows: select count(*) from sometableorview wherecondition run this statement -> you'll get 1 reocrd contai

RE: RE : [development-axapta] Re: Document handling

Hi Steeve   When installing an Axapta 3.0 or upgrading, there is a built-in check in the wizard – the menu ‘Initializing the help system’. If you do not run this part, but only flag it as complete the document handling system will not be activated.   You can run this part of the wiza

RE : [development-axapta] Re: Document handling

So weird...  I've just look into the active document tables in our Production environment and there's no table listed there, still, the document handling works in Prod and not Dev.  I'll try adding the table and synchronize to see what happens. Steeve... -Message d'origine- De : vozad

SV: [development-axapta] Document handling

Hi Steve Maybe the ActiveTable parameter is enabled in the document parameter form? In that case you need to setup SalesTables in the activetables-table. Regards Thomas -Oprindelig meddelelse- Fra: Steeve Gilbert [mailto:[EMAIL PROTECTED] Sendt: 27. januar 2004 14:50 Til: [EMAIL PRO

[development-axapta] Re: Document handling

Did you add the related table to the form below? Basic -> Setup -> Document Management -> Active Document Tables Once although I added it to there the document handling button didn't appear active then I recompiled or synchronized the AOD and the problem has been corrected. --- In [EMAIL P

[development-axapta] Document handling

Hello All!   The "Document Handling" functionality seems to be disabled (Can't access Command -> Document handling while being in a Sales Order) in our Dev environment and I can't find why.  Besides checking the "Document handling active" checkbox in user option, do you know what else I should

[development-axapta] Urgent: Selection on WebGrid

Hi everyone, I do some calculations on a WebForm and it has a WebGrid. The problem is that when I write the following code (or a while select statement) select count(recid) from TableOfWebGrid; the rows on the WebGrid disappear or not shown properly. What should I do? Thanks.

[development-axapta] How to change the filegroups of all the indexes of all tables

Title: How to change the filegroups of all the indexes of all tables Hi All, I need your suggestions. I want to tune up my axapta sql server database. I want to separate the indexes and the data into different filegroups. Currently, in SQL Server Enterprise Manager, i have to change all th

RE: [development-axapta] Is there any Numeric To Words function ?

Title: Is there any Numeric To Words function ? Hi Arief,   you can use Global::NumeralsToTxt(...) method..   Sample :   Global::NumeralsToTxt(round(125000,1.0), CompanyInfo::standardCurrency()));   Anil Ozay From: Arief Tarmizi [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 27, 2004

[development-axapta] Is there any Numeric To Words function ?

Title: Is there any Numeric To Words function ? Dear All, I need your help. I need a function to convert a numeric into words eg. 2000 --> 'Two Thousands'. Does axapta provide this function ? Or if not, does anybody has developed it and kindly want to share it for me :D, would greatly app

AW: [development-axapta] Rounding

Hi, use this:   decround(4.321 ,2)  --> 4.32 decround(123.456 ,2 --> 123.46   Otto -Ursprüngliche Nachricht-Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Gesendet: Dienstag, 27. Januar 2004 11:46An: [EMAIL PROTECTED]Betreff: [development-axapta] Rounding Hi,   I would

RE: [development-axapta] Rounding

Try round().   Ex : Round(123.456,0.01) -> 123.46 Med venlig hilsen     Palle Mølgaard     Systemate A/S   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 27. januar 2004 11:46To: [EMAIL PROTECTED]Subject: [development-axapta] Rounding Hi,   I would like to round a real value

[development-axapta] Rounding

Hi,   I would like to round a real value to its nearest 2 decimal places. For example 123.456 -> 123.46 and 4.321 -> 4.32.  Is there any functions available in axapta to do this? I've tried the roundZeroDec function but all it does is round down if the value is > 0 and vice versa.   TIA,

RE: [development-axapta] Sales Order - Simple mode

Hi gigi,   You can look Forms/SalesTable/Methods/toggelSimpleAdvanced(...)   all initialization about simple-advanced occurs in tihs method. Also if you want to add "only" some fields from advanced, drag and drop to related sections of :   Forms/SalesTable/Designs/Design/Group:Table/Tab:

Re: RE : [development-axapta] sum

Thanks all! Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/  To unsubscribe from this group, send an email to:[EMAIL PROTECTED]  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

AW: [development-axapta] OLAP Error...

RE: [development-axapta] OLAP Error...

Hi In order to transfer or process the cube you need to install the cube management tools from SQL Analysis Services on your client. These are on the SQL Server CD. Regards Malcolm Burtt Global I.T Group   -Original Message-   From: ANDRES PINZON [mailto:[EMAIL

[development-axapta] Budget on fixedprice projects

On Fixed Price projects - we want to have budget on income. How can it be done? It seems to me that the ProjBudgetRevenue - table is not open for Fixed Price project. Also it would be strange, since ProjOnAccTrans do not have CategoryId. And in reports and in ex. ProjStatistics - the ProjOn