[Axapta-Knowledge-Village] Re: reread versus _ds.reread

2009-05-29 Thread anton_tjiptadi
, 2009 at 10:13 AM, anton_tjiptadi anton_tjipt...@...wrote: Hi all, What is the different between [table].reread and [datasaource].reread ? I have a problem with my Ax3, seems this reread function not working correctly bcos sometimes return the correct value (the new updated record

[Axapta-Knowledge-Village] reread versus _ds.reread

2009-05-28 Thread anton_tjiptadi
Hi all, What is the different between [table].reread and [datasaource].reread ? I have a problem with my Ax3, seems this reread function not working correctly bcos sometimes return the correct value (the new updated record) but sometime return old value. FYI, bfore using the Reread function,

[Axapta-Knowledge-Village] Re: TTSBEGIN/TTSCOMMIT ERROR

2009-05-08 Thread anton_tjiptadi
, anton_tjiptadi anton_tjiptadi@ wrote: Hi all, Can someone help me to fix this error? It happened when I open a dialog after some routine in my code. An unbalanced X++ TTSBEGIN/TTSCOMMIT pair has been detected. a) Cause of this includes too many/few TTSBEGIN or TTSCOMMIT

[Axapta-Knowledge-Village] TTSBEGIN/TTSCOMMIT ERROR

2009-05-07 Thread anton_tjiptadi
Hi all, Can someone help me to fix this error? It happened when I open a dialog after some routine in my code. An unbalanced X++ TTSBEGIN/TTSCOMMIT pair has been detected. a) Cause of this includes too many/few TTSBEGIN or TTSCOMMIT. b) Return calls within TTSBEGIN/TTSCOMMIT. c) User

[Axapta-Knowledge-Village] Re: TTSBEGIN/TTSCOMMIT ERROR

2009-05-07 Thread anton_tjiptadi
, anton_tjiptadi anton_tjiptadi@ wrote: Hi all, Can someone help me to fix this error? It happened when I open a dialog after some routine in my code. An unbalanced X++ TTSBEGIN/TTSCOMMIT pair has been detected. a) Cause of this includes too many/few TTSBEGIN or TTSCOMMIT. b

[Axapta-Knowledge-Village] Format text for sending email

2009-04-20 Thread anton_tjiptadi
Dear all, I developed some notification program in Ax 3. This program should send email regarding some changes in Axapta. Problem is I set the message body so it would look nice when my user receive it. Turns out all the format missing so it would only display one long lines without any

[Axapta-Knowledge-Village] Re: Format text for sending email

2009-04-20 Thread anton_tjiptadi
. Regards. manoch --- In Axapta-Knowledge-Village@yahoogroups.com, anton_tjiptadi anton_tjiptadi@ wrote: Dear all, I developed some notification program in Ax 3. This program should send email regarding some changes in Axapta. Problem is I set the message body so it would look nice

[Axapta-Knowledge-Village] Misc. charges adjustment (AP)

2009-04-17 Thread anton_tjiptadi
Dear all, anyone ever got problem when doing Misc.charges adjustment. I have a case that adjustment failed (error: no inventory transaction generated) I debug the error, and turns out one of the line has value too small (0.0015, rounded become 0.00). Option only positive or negative line, I

[Axapta-Knowledge-Village] AP Misc. Charges adjustment

2009-04-08 Thread anton_tjiptadi
Dear all, anyone ever got problem when doing Misc.charges adjustment. I have a case that adjustment failed (error: no inventory transaction generated) I debug the error, and turns out one of the line has value too small (0.0015, rounded become 0.00). Option only positive or negative line, I

[Axapta-Knowledge-Village] Goods return for items already blocked

2009-03-24 Thread anton_tjiptadi
Dear all, Need opinion about how to handle return goods that in inventory we already blocked it? and what to do if we already change the setting in item group, for example we already changed the ledger account setting so it obviously different with the first we sell it. Thanks a lot, Anton

[Axapta-Knowledge-Village] InventTrans

2009-03-10 Thread anton_tjiptadi
Hello, need more info on InventTrans table. There are fields : - QtySettled - CostAmountSettled - ValueOpen What are exactly those fields for? On what actions does these fields usually updated? I have one weird transaction, my PO already invoiced and it has only 1 item for qty 376.50 (stated in

[Axapta-Knowledge-Village] Re: How to correct wrong cost amount in Credit Note

2009-02-02 Thread anton_tjiptadi
] On Behalf Of anton_tjiptadi Sent: Friday, January 30, 2009 7:30 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: How to correct wrong cost amount in Credit Note O ya, sorry, forgot to mention. It's Ax 3.0 :) Thanks. --- In Axapta-Knowledge

[Axapta-Knowledge-Village] Re: How to correct wrong cost amount in Credit Note

2009-01-30 Thread anton_tjiptadi
a transaction. How about canceling this credit note and create a new one with correct value? Regards Anil Sinha --- In Axapta-Knowledge-Village@yahoogroups.com, anton_tjiptadi anton_tjiptadi@ wrote: Hi James, It doesn't appear in the list even I already mention the voucher number

[Axapta-Knowledge-Village] How to correct wrong cost amount in Credit Note

2009-01-29 Thread anton_tjiptadi
Dear all, I have Credit note (return SO) which has wrong value with its cost amount. How to adjust it since Inventory Adjustment doesn't apply to Credit note / Return sales order. Thanks in advance, Ton

[Axapta-Knowledge-Village] Re: How to correct wrong cost amount in Credit Note

2009-01-29 Thread anton_tjiptadi
reciept could be affect by this function? Thanks James _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of anton_tjiptadi Sent: Thursday, January 29, 2009 5:16 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject

[Axapta-Knowledge-Village] Production Order Ended, costing is wrong

2009-01-20 Thread anton_tjiptadi
Hi there, Have any idea if in Production which is already ended, turns out the costing is wrong because the item consumption / BOM consumption is wrong? Because the system don't allow me to reset the status once it is Ended. Thanks in advance. Anton

[Axapta-Knowledge-Village] change fieldid in Ax4

2007-07-04 Thread anton_tjiptadi
Hi all, how to change field id in Ax 4 ? TIA, Ton

[Axapta-Knowledge-Village] Re: not recognized user

2007-06-05 Thread anton_tjiptadi
Thx, Mohit, but the service did start, only when open Ax, the message not recognized... appears. Also, if I'm not mistaken, setup Ax 4 will not run if there's no domain server / log on locally (this computer). rgds, Ton --- In Axapta-Knowledge-Village@yahoogroups.com, mohit rajvanshy

[Axapta-Knowledge-Village] Re: not recognized user

2007-06-05 Thread anton_tjiptadi
on the domain and log into Ax. It will work. Regards. Raj. On 6/5/07, anton_tjiptadi [EMAIL PROTECTED] wrote: Thx, Mohit, but the service did start, only when open Ax, the message not recognized... appears. Also, if I'm not mistaken, setup Ax 4 will not run if there's

[Axapta-Knowledge-Village] select with force_placeholders

2007-05-22 Thread anton_tjiptadi
does anyone know what is select with force_placeholder means? also is it possible to grouping with QueryBuildDataSource without using key addSortField ? common query is like this for example: QueryBuildDataSource qbds; Query q = new query(); QueryRun qr;

[Axapta-Knowledge-Village] Select statement

2006-06-04 Thread anton_tjiptadi
Hi guys, I found one of select statement using key with nested_loop and force_placeholder can anyone tell me what it's means ? //SELECT WITH NESTED_LOOP, FORCE_PLACEHOLDERS * FROM InventDim... many thanks, Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta

[Axapta-Knowledge-Village] DictTable

2006-05-15 Thread anton_tjiptadi
Hi guys, can anyone tell me what is the purpose of DicTable ? I found one of the class using that and don't know for sure the meaning. the class is LedgerJournalEngine_Payment in method Active ... if ( fieldNum(ledgerJournalTrans, dimension) == dictTable.fieldCnt2Id(i) ||

[Axapta-Knowledge-Village] Re: Subquery

2005-01-24 Thread anton_tjiptadi
well, not the way I'm expected, but thanks though :)) I guess there's a limitation in X++ query thanks, --- In Axapta-Knowledge-Village@yahoogroups.com, akin [EMAIL PROTECTED] wrote: anton_tjiptadi how about this code: custtable _table1,_table2; date

[Axapta-Knowledge-Village] Subquery

2005-01-23 Thread anton_tjiptadi
Hi, How to write a subquery in X++ Select statement for ex in SQL Server : -- select * from CustTable where createddate = (select max (createddate) from Custtable) thanks, Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own

[Axapta-Knowledge-Village] Re: Lookup table in EDT ?

2005-01-19 Thread anton_tjiptadi
for then follow the logic on this form. Good luck Tony -Original Message- From: anton_tjiptadi [mailto:[EMAIL PROTECTED] Sent: Tuesday, 18 January 2005 2:40 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Lookup

[Axapta-Knowledge-Village] Re: Need help on Axap3.0 Exam Preparation

2005-01-16 Thread anton_tjiptadi
Hi, are this exam already has its Braindumps, you know, sample question from earlier test participant which's kind enough to share their experience :) ? rgds, --- In Axapta-Knowledge-Village@yahoogroups.com, Nitesh [EMAIL PROTECTED] wrote: hi padmaja now the time duration for the exam is

[Axapta-Knowledge-Village] query range - like

2005-01-11 Thread anton_tjiptadi
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

[Axapta-Knowledge-Village] Re: query range - like

2005-01-11 Thread anton_tjiptadi
: if Extenderd data type is Likestring assign the string value Likestring = '%RV%' select accountnum, voucher, * from ledgerjournaltrans where voucher like Likestring ; Lalith anton_tjiptadi [EMAIL PROTECTED] wrote: I want to create query range with like and or criteria

[Axapta-Knowledge-Village] Re: query range - like

2005-01-11 Thread anton_tjiptadi
* 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

[Axapta-Knowledge-Village] fetchmode vs joinmode

2005-01-07 Thread anton_tjiptadi
I'm a bit confuse about fetchmode and joinmode, what is exactly the two method means ? 'cause sometimes a report can use fetch mode, but with value of joinmode for example : QueryBuildDataSource1 = Query.adddatasource(tablenum(SalesTable)); QueryBuildDataSource2 =

[Axapta-Knowledge-Village] Pack / Unpack

2005-01-03 Thread anton_tjiptadi
Hi, can someone tell me what is the purpose of Pack and Unpack in Class method ? thanks, 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

Re: SV: [Axapta-Knowledge-Village] EDT - Dimensions

2004-12-24 Thread anton_tjiptadi
] http://us.f414.mail.yahoo.com/ym/[EMAIL PROTECTED] anton_tjiptadi [EMAIL PROTECTED] wrote: Hi, how to manipulate field Dimension ('cause it's an array var) ? for example : range1 = dsInventTable.addRange(fieldnum(InventTable

[Axapta-Knowledge-Village] Re: Section Printing in Report.

2004-12-06 Thread anton_tjiptadi
Hi, From what I've just learned, I think you should add some statement in Fetch Method in the report, such as : While (qr.next()) { (your data source) = qr.get(tablenum(your table)); . .. //the calculation if (YourAmount 0) element.send(your

[Axapta-Knowledge-Village] String Manipulation

2004-12-06 Thread anton_tjiptadi
Hi, what is the syntax for string manipulation in X++, for ex (in VB): MyText -- left(string,2) -- My MyText -- right(string,4) -- Text MyText -- Substring(string,4,2) -- ex or format string like 0123456789 to be display like 01-234-567- 8.9 thanks, Yahoo!

[Axapta-Knowledge-Village] Executing Report from a self made form

2004-12-05 Thread anton_tjiptadi
Hi, I want to execute a report from a form which I alrady make. This form form used to cater user creiteria and when they click OK buton, it runs the report. How can I do that ? Should I create a class first then callig the form and then calling the report or.. ? thanks, Anton

[Axapta-Knowledge-Village] Add DialogField in report query form

2004-12-05 Thread anton_tjiptadi
Hi all, I'm trying to add dialog field to my report, code is below : public Object dialog() { DialogRunBase dialog = super(); ; dialog.addGroup(Range); dialogTaxInvNo = dialog.addField(typeid (MLR_LedgerJournalTrans),Tax Invoice :,Tax Invoice Number); return dialog; }