Re: [Axapta-Knowledge-Village] delete_from vs loop delete

2010-09-01 Thread thomas 'znal' ramdhan
- Solutions *From:* Axapta-Knowledge-Village@yahoogroups.com [mailto: axapta-knowledge-vill...@yahoogroups.com] *On Behalf Of *thomas 'znal' ramdhan *Sent:* 01 September 2010 06:20 *To:* Axapta-Knowledge-Village@yahoogroups.com *Subject:* [Axapta-Knowledge-Village] delete_from vs loop

[Axapta-Knowledge-Village] decimal value in strfmt

2010-08-30 Thread thomas 'znal' ramdhan
Dear all, I'd like to ask about strfmt function, how could I declare more than 2 decimal digit in strfmt ? Let's say, I have a value like below 2.98776584 I'd like to show them all in strfmt function. Actually strfmt only show 2 decimal digit. THanks and Regards, Afin -- ne faites pas une

Re: [Axapta-Knowledge-Village] Re: decimal value in strfmt

2010-08-30 Thread thomas 'znal' ramdhan
type with more than two digits. With best regards, Bernd --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com, thomas 'znal' ramdhan thomasramd...@... wrote: Dear all, I'd like to ask about strfmt function, how could I declare more than 2 decimal

Re: [Axapta-Knowledge-Village] Re: decimal value in strfmt

2010-08-30 Thread thomas 'znal' ramdhan
this Function. Which AX-Version do you user. We use Microsoft Dynamics AX 2009. With best regards, Bernd --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com, thomas 'znal' ramdhan thomasramd...@... wrote: Hi Seyfried, thanks for replying my email

Re: [Axapta-Knowledge-Village] Re: decimal value in strfmt

2010-08-30 Thread thomas 'znal' ramdhan
, I havn't even got any problem using this Function. Which AX-Version do you user. We use Microsoft Dynamics AX 2009. With best regards, Bernd --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com, thomas 'znal' ramdhan thomasramd...@... wrote: Hi

[Axapta-Knowledge-Village] lock handle in Axapta

2010-08-25 Thread thomas 'znal' ramdhan
Dear all, I have customized number sequence in Axapta to fulfill the reset number in every month functionality. So that the number sequence function will call my method. I have a problem with getting the newest number. Sometimes 2 user get the same number when they created a new transaction. Has

Re: [Axapta-Knowledge-Village] when to use Index and index hint

2010-08-18 Thread thomas 'znal' ramdhan
Hi Malcolm, From above question, I'd like to ask another question which related to indexhint. Let's say I need to query to tableA which field criteria is field1. select * from tableA where tableA.field1 = _field1 indexs for table A are below 1. NumIdx field1 field2 field3 2.

[Axapta-Knowledge-Village] Open a file

2010-08-17 Thread thomas 'znal' ramdhan
Dear all, I'd like to know, how can I open a file automatically through Axapta ? Let's say, I have an excel file in my desktop, and I'd like to open it by code in Axapta. Thanks and Regards, Afin -- ne faites pas une limite pour votre competence

Re: [Axapta-Knowledge-Village] Open a file

2010-08-17 Thread thomas 'znal' ramdhan
'; ; WinAPI::shellExecute(filename,'','',#ShellExeOpen); } Regards, Sumit On Tue, Aug 17, 2010 at 5:55 PM, thomas 'znal' ramdhan thomasramd...@gmail.com wrote: Hi Nix, Thanks for replying, but what I mean was not the content. I'd like to launch the file from axapta. I've tried code

[Axapta-Knowledge-Village] Default Batch for an item

2010-08-10 Thread thomas 'znal' ramdhan
Dear all, I'd like to ask few questions about default batch for an item. Let's say I have an item id 'Item A' with batch number 'batch A' and 'batch A1'. I'd like to update - start in production order, with reservation status set to manual. In this case, my batch number was not set automatically.

[Axapta-Knowledge-Village] New screen access right

2010-08-02 Thread thomas 'znal' ramdhan
Dear all, I'd just like to make sure, let's say I have 1 new screen call 'xtsItemGroup' and I'd like to import it to live database. Is it different if I set the security key between before and after I import the table to live database ? In my case, I used Invent Setup as my security key. It

Re: [Axapta-Knowledge-Village] Re: How to get a current range

2010-07-07 Thread thomas 'znal' ramdhan
; } // if not blanks } // end for all the datasource query ranges found } // end for all the datasources found. return sShowRanges; } /textarea --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com, thomas 'znal' ramdhan thomasramd...@... wrote: Dear all

[Axapta-Knowledge-Village] How to get a current range

2010-07-05 Thread thomas 'znal' ramdhan
Dear all, I'd like to ask a question about findRange in queryBuildDataSource. For illustration, I have a form and I define a range. I'd like to get the range value in that form. I'm using queryBuildDataSource.findRange(fieldnum(xtsWRKRmTrfHeader, RefId)), but the result return null. Does anyone

Re: [Axapta-Knowledge-Village] Table exists

2010-06-11 Thread thomas 'znal' ramdhan
Abhishek Mehta, -- *From:* thomas 'znal' ramdhan thomasramd...@gmail.com *To:* Axapta-Knowledge-Village@yahoogroups.com *Sent:* Thu, June 10, 2010 2:35:31 PM *Subject:* [Axapta-Knowledge-Village] Table exists Dear all, I got error message when I imported a table

Re: [Axapta-Knowledge-Village] Synchronize issue

2010-06-09 Thread thomas 'znal' ramdhan
, thomas 'znal' ramdhan thomasramd...@gmail.com wrote: The AX still try to delete the SQL -- ne faites pas une limite pour votre competence - bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit

[Axapta-Knowledge-Village] Synchronize issue

2010-06-08 Thread thomas 'znal' ramdhan
Dear all, I have an issue in synchronizing PurchReqLine table. Actually this table has already customized, and the issue came because we restore the database from the live database to test database (the problem faced in test database). I have deleted all customizations in PurchReqLine table, and

[Axapta-Knowledge-Village] Different data in different call method

2010-06-01 Thread thomas 'znal' ramdhan
Dear all, I have a form which data were inserted from preprocess. If my form was called from Inventtable via menu item, number of the data didn't show as I selected it from SQL query. If I just open it from AOT, the data showed as I selected it from SQL query. Did I miss something ? Thanks and

[Axapta-Knowledge-Village] error in event viewer

2010-05-31 Thread thomas 'znal' ramdhan
Dear all, I got this error in event viewer. The Microsoft Dynamics AX Application Object Server is running on an operating system that is not supported. The supported operating system is Microsoft Windows Server 2003 with Service Pack 1. Actually I installed Win Server 2008 Enterprise Edition

Re: [Axapta-Knowledge-Village] error in event viewer

2010-05-31 Thread thomas 'znal' ramdhan
-- *From:* thomas 'znal' ramdhan thomasramd...@gmail.com *To:* Axapta-Knowledge-Village@yahoogroups.com *Sent:* Mon, 31 May, 2010 9:14:14 AM *Subject:* [Axapta-Knowledge-Village] error in event viewer Dear all, I got this error in event viewer. The Microsoft Dynamics AX

[Axapta-Knowledge-Village] effect of changing domain name

2010-05-31 Thread thomas 'znal' ramdhan
Dear all, I'd like to know for sure, is there any others effect of changing domain name (in my server) beside I should update the network domain in userinfo table ? Thanks and Regards, -Afin- -- ne faites pas une limite pour votre competence

[Axapta-Knowledge-Village] Production Costing

2010-05-27 Thread thomas 'znal' ramdhan
Dear all, Do anyone of you have an experience in customizing production costing ? I've added some codes in costsheetnodeCalculation and costSheetNodeCalculationRate, the result was error rateSubType (undefined). Actually I didn't add any codes related to rateSubType. Is there any best practices

Re: [Axapta-Knowledge-Village] Dimension in query build data source

2010-05-21 Thread thomas 'znal' ramdhan
, 2010 at 8:33 AM, thomas 'znal' ramdhan thomasramd...@gmail.com wrote: Dear all, Could anyone tell me how to declare the array dimension in querybuilddatasource. For example, qbds.addRange(fieldnum(DIMENSIONSETCOMBINATION, *Dimension*)) I'd like to add range only for Dimension[1]. When I add

[Axapta-Knowledge-Village] Dimension in query build data source

2010-05-20 Thread thomas 'znal' ramdhan
Dear all, Could anyone tell me how to declare the array dimension in querybuilddatasource. For example, qbds.addRange(fieldnum(DIMENSIONSETCOMBINATION, *Dimension*)) I'd like to add range only for Dimension[1]. When I add the array[1] in above code, the compiler returns an error. Thanks and