[Axapta-Knowledge-Village] Re: "reread" versus "_ds.reread"
Hi Anita, Thanks. but still confuse about reread in table ([table].reread) and form datasource ([_ds].reread), is it the same? regards, --- In Axapta-Knowledge-Village@yahoogroups.com, Anitha S wrote: > > Hi.. > > refresh() will not reread the record from the database. It basically just > refreshes the screen with whatever is stored in the form cache. > > > refreshEx() will refresh the view of the records. > > > reread() will only re-read the CURRENT record from the DB so you should not > use it to refresh the form data if you have added/removed records. It's > often used if you change some values in the current record in some code, and > commit them to the database using .update() on the table, instead of through > the form datasource. In this case .reread() will make those changes appear > on the form. > > research() will rerun the existing form query against the datasource, > therefore updating the list with new/removed records as well as updating > existing ones. This will honour any existing filters and sorting on the > form. > > executeQuery() is another useful one. It should be used if you have > modified the query in your code and need to refresh the form. It's like > .research() except it takes query changes into account. > > Hope your queries have been answered. > > I am not sure about the combination of using table.reread followed by > datasource.refresh. > > If you have any other thoughts, kindly share it across. > > > Regards, > > Anitha > > > On Fri, May 29, 2009 at 10:13 AM, anton_tjiptadi > 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) > > but sometime return old value. > > > > FYI, bfore using the Reread function, I update or write first the record. I > > run few times, but often after Reread what I already > > "write" on that table is lost. > > > > For more detail may I ask what Ax exactly doing with below function : > > [table].reread > > [datasource].reread > > [datasource].refresh > > [datasource].refreshEx > > [datasource].research > > [datasource].executeQuery > > > > furthermore can I use it in combination for example after [table].reread > > then [datasource].refresh ? > > > > Thanks in advance, > > Anton > > > > > > >
[Axapta-Knowledge-Village] "reread" versus "_ds.reread"
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, I update or write first the record. I run few times, but often after Reread what I already "write" on that table is lost. For more detail may I ask what Ax exactly doing with below function : [table].reread [datasource].reread [datasource].refresh [datasource].refreshEx [datasource].research [datasource].executeQuery furthermore can I use it in combination for example after [table].reread then [datasource].refresh ? Thanks in advance, Anton
[Axapta-Knowledge-Village] Re: TTSBEGIN/TTSCOMMIT ERROR
Dear all,
Thanks for your kind assistance.
Regards,
Anton
--- In Axapta-Knowledge-Village@yahoogroups.com, "r_ssh"
wrote:
>
> Hi Anton,
>
> TTS level '1' usually leaves your Ax session in an unusable state
> that you can't close properly.
>
> Solution:
> Open the AOT and run this job:
> static void resetTTS(Args _args)
> {
> while (appl.ttsLevel() > 0)
> ttsAbort;
> }
>
> It simply rolls back any pending transactions until the TTS level is back at
> zero. Hope this resove your issue.
>
> Thanks
> Santosh.R
>
>
> --- In Axapta-Knowledge-Village@yahoogroups.com, "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) Return calls within TTSBEGIN/TTSCOMMIT.
> >
> > c) User interaction within TTSBEGIN/TTSCOMMIT pairs.
> >
> >
> >
> > The current TTS level is `1'.
> >
> > Any help/sudgestion will be appreciated. thanks
> >
> > Regards,
> > Anton
> >
>
[Axapta-Knowledge-Village] Re: TTSBEGIN/TTSCOMMIT ERROR
Hi, thanks for the reply. one more question.. is there any function to know if we haven't commit the transaction yet? so if I know there is open trasaction, I will add ttscomit first in order to show dialog. thanks in advance, Anton --- In Axapta-Knowledge-Village@yahoogroups.com, Ali Ýhsan Aðca wrote: > > Hi Anton, > > You can not show dialog in tts routine as message says in (c). You have to > commit transaction first and open dialog, after getting value from user, then > you can open a transaction again. > > > --- In Axapta-Knowledge-Village@yahoogroups.com, "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) Return calls within TTSBEGIN/TTSCOMMIT. > > > > c) User interaction within TTSBEGIN/TTSCOMMIT pairs. > > > > > > > > The current TTS level is `1'. > > > > Any help/sudgestion will be appreciated. thanks > > > > Regards, > > Anton > > >
[Axapta-Knowledge-Village] TTSBEGIN/TTSCOMMIT ERROR
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 interaction within TTSBEGIN/TTSCOMMIT pairs. The current TTS level is `1'. Any help/sudgestion will be appreciated. thanks Regards, Anton
[Axapta-Knowledge-Village] Re: Format text for sending email
Hi Manoch, It works. Thanks very much. Regards, Anton --- In Axapta-Knowledge-Village@yahoogroups.com, "manoch_niti" wrote: > > Hi. > > The message body must written in html language. > Please try to apply HTML tag into your message. > for example, surround it with ... . > > Regards. > manoch > > > --- In Axapta-Knowledge-Village@yahoogroups.com, "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 when my user receive it. Turns out all the format > > missing so it would only display one long lines without any format. > > > > Example of my lines is > > "Purchase order no 1234 is created \n. Please approve or reject \n\n > > Regards \n Admin" > > > > I'm using dialog to display this message before Axapta send it. It already > > looks nice on screen. > > Message body in my dialog already looks like this : > > > > "Purchase order no 1234 is created > > Please approve or reject. > > > > Regards > > Admin" > > > > After I clicked ok on my dialog, it send the email but with all character > > in one line. > > --> "Purchase order no 1234 is created.Please approve or rejectRegardsAdmin" > > > > Any suggestion? > > > > Thanks in advance. > > Regards, > > Anton > > >
[Axapta-Knowledge-Village] Format text for sending email
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 format. Example of my lines is "Purchase order no 1234 is created \n. Please approve or reject \n\n Regards \n Admin" I'm using dialog to display this message before Axapta send it. It already looks nice on screen. Message body in my dialog already looks like this : "Purchase order no 1234 is created Please approve or reject. Regards Admin" After I clicked ok on my dialog, it send the email but with all character in one line. --> "Purchase order no 1234 is created.Please approve or rejectRegardsAdmin" Any suggestion? Thanks in advance. Regards, Anton
[Axapta-Knowledge-Village] Misc. charges adjustment (AP)
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 cannot use it since the value all is positive. How to skip the small value and adjust others? Btw, it's Axapta 3.0. Thanks in advance, Anton
[Axapta-Knowledge-Village] AP Misc. Charges adjustment
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 cannot use it since the value all is positive. How to skip the small value and adjust others? Btw, it's Axapta 3.0. Thanks in advance, Anton
[Axapta-Knowledge-Village] Goods return for items already blocked
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
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 PO lines and invoice), postin ginvoice one time only, not partial. But when I check to InventTrans there are 2 transaction (2 records) each with qty, 143.9 and 1026.1, the first one with those above fields updated and the second record with those above fields empty. Both status are Purchased. I don't know where this transaction come from and how to fixed it? and is it related to those field, which is one is filled, one empty? Thanks in advance, Anton
[Axapta-Knowledge-Village] Re: How to correct wrong cost amount in Credit Note
Hi James, I just debug the code again, turns out someone blocked the transaction with return lot id (Class InventAdjTransSelect). I just change it back to default code, and my credit note transaction appeared. Thanks for your help. Ton. --- In Axapta-Knowledge-Village@yahoogroups.com, "James Flavell" wrote: > > Hi Ton, > > A quick look in AX4.0 SP1 (sorry no Ax3.0 handy right now) shows that the > only 2 criteria set as default in the Query InventTransAdjust (maybe you can > check the query in your AX3.0, look in the ranges of teh data source) are: > 1) StatusReciept: Purchased > (criteria is set as Open rather than Locked so would seem a bit scary that > user might be able to actaully select an issue transaction ...no time to > test but do let us know if you test it and it really can be cahnged so > issues can be selected) > > 2) PackingSlipReturned: No > I am guessing maybe your credit note trasnaction has this as Yes hence why > it is not getting picked up > Why is this filtered out I guess because when you reverse a delivery note > the inventtrans gets status sold and purchased even though really there is > no financial and so fitlering packingslipupdate=no means they will make sure > to avoid allowing the user to adjust any of these transactions. The problem > is I think a valid sales credit note transaction (at least in AX3.0 I > believe seeing it) can also end up with thise field = Yes (and I am not sure > whether fitlering out such transactions is what the programmer had in mind) > > Let us know if this is the reason you cannot pick up the transaction. > > The only quick way I know would be either to write off the item and bring it > back in with the different cost in a journal OR adjust the original reciept > and let it flow through to the credit note (assuming easy to track back so > for sure forget it if you are using average plus that the original reciept > is still not closed) > > Good luck and do report back > James > > _ > > From: Axapta-Knowledge-Village@yahoogroups.com > [mailto:axapta-knowledge-vill...@yahoogroups.com] 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- <mailto:Axapta-Knowledge-Village% 40yahoogroups.com> > vill...@yahoogroups.com, "James Flavell" > wrote: > > > > Is the inventory transaction already closed? > > > > What version of AX are you using? > > > > Thanks > > James > > > > > > > > _ > > > > From: Axapta-Knowledge- > <mailto:Axapta-Knowledge-Village%40yahoogroups.com> vill...@yahoogroups.com > > [mailto:Axapta-Knowledge- > <mailto:Axapta-Knowledge-Village%40yahoogroups.com> vill...@yahoogroups.com] > On Behalf Of > > anton_tjiptadi > > Sent: Thursday, January 29, 2009 6:00 PM > > To: Axapta-Knowledge- <mailto:Axapta-Knowledge-Village% 40yahoogroups.com> > vill...@yahoogroups.com > > Subject: [Axapta-Knowledge-Village] Re: How to correct wrong cost > amount in > > Credit Note > > > > > > > > Hi James, > > > > It doesn't appear in the list even I already mention the voucher > > number or Lot Id in the selection. > > > > thanks, > > Ton > > > > --- In Axapta-Knowledge- <mailto:Axapta-Knowledge-Village% > 40yahoogroups.com> > > vill...@yahoogroups <mailto:Village% 40yahoogroups.com> .com, "James > Flavell" > > wrote: > > > > > > Are you sure inventory transaction adjustment cannot change it? I > > thought > > > any reciept could be affect by this function? > > > Thanks > > > James > > > > > > > > > _ > > > > > > From: Axapta-Knowledge- > > <mailto:Axapta-Knowledge-Village%40yahoogroups.com> > vill...@yahoogroups <mailto:Village%40yahoogroups.com> .com > > > [mailto:Axapta-Knowledge- > > <mailto:Axapta-Knowledge-Village%40yahoogroups.com> > vill...@yahoogroups <mailto:Village%40yahoogroups.com> .com] > > On Behalf Of > > > anton_tjiptadi > > > Sent: Thursday, January 29, 2009 5:16 PM > > > To: Axapta-Knowledge- <mailto:Axapta-Knowledge-Village% > 40yahoogroups.com> > > vill...@yahoogroups <mailto:Village%40yahoogroups.com> .com > > > Subject: [Axapta-Knowledge-Village] How to correct wrong cost > > amount in > > > Credit Note > > > > > > > > > > > > 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
Hi Anil, How to cancel a credit note? Btw I'm using Ax 3.0 Thanks, Ton --- In Axapta-Knowledge-Village@yahoogroups.com, "Anil Kumar Sinha" wrote: > > Hi Ton, > > I don't think there is any other place other than Inventory > transaction adjustment from where we can adjust 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" > wrote: > > > > Hi James, > > > > It doesn't appear in the list even I already mention the voucher > > number or Lot Id in the selection. > > > > thanks, > > Ton > > > > --- In Axapta-Knowledge-Village@yahoogroups.com, "James Flavell" > > wrote: > > > > > > Are you sure inventory transaction adjustment cannot change it? > I > > thought > > > any 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] How to correct wrong cost > > amount in > > > Credit Note > > > > > > > > > > > > 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
O ya, sorry, forgot to mention. It's Ax 3.0 :) Thanks. --- In Axapta-Knowledge-Village@yahoogroups.com, "James Flavell" wrote: > > Is the inventory transaction already closed? > > What version of AX are you using? > > Thanks > James > > > > _ > > From: Axapta-Knowledge-Village@yahoogroups.com > [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of > anton_tjiptadi > Sent: Thursday, January 29, 2009 6:00 PM > To: Axapta-Knowledge-Village@yahoogroups.com > Subject: [Axapta-Knowledge-Village] Re: How to correct wrong cost amount in > Credit Note > > > > Hi James, > > It doesn't appear in the list even I already mention the voucher > number or Lot Id in the selection. > > thanks, > Ton > > --- In Axapta-Knowledge- <mailto:Axapta-Knowledge-Village% 40yahoogroups.com> > vill...@yahoogroups.com, "James Flavell" > wrote: > > > > Are you sure inventory transaction adjustment cannot change it? I > thought > > any reciept could be affect by this function? > > Thanks > > James > > > > > > _ > > > > From: Axapta-Knowledge- > <mailto:Axapta-Knowledge-Village%40yahoogroups.com> vill...@yahoogroups.com > > [mailto:Axapta-Knowledge- > <mailto:Axapta-Knowledge-Village%40yahoogroups.com> vill...@yahoogroups.com] > On Behalf Of > > anton_tjiptadi > > Sent: Thursday, January 29, 2009 5:16 PM > > To: Axapta-Knowledge- <mailto:Axapta-Knowledge-Village% 40yahoogroups.com> > vill...@yahoogroups.com > > Subject: [Axapta-Knowledge-Village] How to correct wrong cost > amount in > > Credit Note > > > > > > > > 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
Hi James, It doesn't appear in the list even I already mention the voucher number or Lot Id in the selection. thanks, Ton --- In Axapta-Knowledge-Village@yahoogroups.com, "James Flavell" wrote: > > Are you sure inventory transaction adjustment cannot change it? I thought > any 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] How to correct wrong cost amount in > Credit Note > > > > 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] How to correct wrong cost amount in Credit Note
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] Production Order Ended, costing is wrong
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] How to show hidden field without change prop. ?
Hi all, how to show hidden field in table browser without changing its Visible property? Thanks, Anton
[Axapta-Knowledge-Village] change fieldid in Ax4
Hi all, how to change field id in Ax 4 ? TIA, Ton
[Axapta-Knowledge-Village] Re: not recognized user
Hi Raj, sorry I forgot to tell, you're right, I can run axapta, if I
log in to the domain, although I'm not connected to any.
The problem is, actually last time I can run it even when I'm log on
locally, only I forgot what is the step when I installed before.. :(.
FYI this is my second time install after I got problem when changing
DB from SQL 2000 to SQL 2005.
thx,
Ton.
--- In Axapta-Knowledge-Village@yahoogroups.com, "Raj Kumar"
<[EMAIL PROTECTED]> wrote:
>
> Anton,
> Use the domain account to log into ur notebook. This has to be done
> regardless of whether you are connceted to the domain or now. A
domain
> account is required to install AX. But once Ax is installed, you
can use it
> without the conncetion to domain.
>
> There will be a domain profile created in the notebook and this
profile is
> the one that is recognized by Ax. So, log on to the notebook, as u
will do
> when u r 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 no
> > domain server / log on locally ("this computer").
> >
> > rgds,
> > Ton
> >
> > --- In Axapta-Knowledge-Village@yahoogroups.com,
> > mohit rajvanshy
> > wrote:
> > >
> > > Hi Ton,
> > >
> > > It is due to the domain problem. Becuase AOS is
> > > installed on different domain so the wondows service
> > > will not start for it. you have to install AOS locally
> > > to the domain "this computer" to make it work.
> > >
> > > Rgrds
> > > Mohit
> > > --- axaeffect wrote:
> > >
> > > > Hi all,
> > > >
> > > > I just installed Dynamics Ax 4 in my notebook. First
> > > > I installed it
> > > > when connecting to domain, although I installing
> > > > AOS, dB Server to my
> > > > notebook. First time, it working just fine. The AOS
> > > > started in my local
> > > > notebook, and DB connection to my local SQL server
> > > > is success.
> > > >
> > > > But the problem is when i log out from domain, and
> > > > then I log in again
> > > > to my Local domain (windows logon -> connect to
> > > > "this computer"), I got
> > > > the message "You are not recognized user of ...".
> > > >
> > > > can someone help me, b'coz I really need to open it
> > > > locally, not depend
> > > > on domain server.
> > > >
> > > > thanks,
> > > > Ton.
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > Regards
> > > Mohit Rajvanshy
> > >
> > >
> > >
> > >
> > __
> > __
> > > Park yourself in front of a world of choices in alternative
> > vehicles. Visit the Yahoo! Auto Green Center.
> > > http://autos.yahoo.com/green_center/
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
[Axapta-Knowledge-Village] Re: not recognized user
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
<[EMAIL PROTECTED]> wrote:
>
> Hi Ton,
>
> It is due to the domain problem. Becuase AOS is
> installed on different domain so the wondows service
> will not start for it. you have to install AOS locally
> to the domain "this computer" to make it work.
>
> Rgrds
> Mohit
> --- axaeffect <[EMAIL PROTECTED]> wrote:
>
> > Hi all,
> >
> > I just installed Dynamics Ax 4 in my notebook. First
> > I installed it
> > when connecting to domain, although I installing
> > AOS, dB Server to my
> > notebook. First time, it working just fine. The AOS
> > started in my local
> > notebook, and DB connection to my local SQL server
> > is success.
> >
> > But the problem is when i log out from domain, and
> > then I log in again
> > to my Local domain (windows logon -> connect to
> > "this computer"), I got
> > the message "You are not recognized user of ...".
> >
> > can someone help me, b'coz I really need to open it
> > locally, not depend
> > on domain server.
> >
> > thanks,
> > Ton.
> >
> >
> >
> >
> >
>
>
> Regards
> Mohit Rajvanshy
>
>
>
>
__
__
> Park yourself in front of a world of choices in alternative
vehicles. Visit the Yahoo! Auto Green Center.
> http://autos.yahoo.com/green_center/
>
[Axapta-Knowledge-Village] select with force_placeholders
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;
InventDim Inventdim;
;
qbds = q.addDataSource(tablenum(InventDim));
qbds.addSortField(fieldnumInventDim, configid);
qbds.addSortField(fieldnumInventDim, inventBatchId);
qbds.ordermode(ordermode::groupby);
qr = new QueryRun(q);
while (qr.next())
{
...
}
above statement produce grouping by configid ascending and
inventbatchid ascending order.
The problem is I want to join with another table (InventBatch) which
is I want to make order not in InventBatchId, but ExpireDate, so it
will conflict with the firt query (InventBatchId asc) bcoz might be
in second table (Inventbatch), the ExpDate sorted but not the
inventBatchId.
please help,
thx,
Ton.
[Axapta-Knowledge-Village] Select statement
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 friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] DictTable
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) || fieldNum(ledgerJournalTrans, interCoDimension) == dictTable.fieldCnt2Id(i) || fieldNum(ledgerJournalTrans, txt) == dictTable.fieldCnt2Id(i) || fieldNum(ledgerJournalTrans, offsetTxt) == dictTable.fieldCnt2Id(i) || fieldNum(ledgerJournalTrans, exchRate) == dictTable.fieldCnt2Id(i)) objectLedgerJournalTrans.allowEdit(true); } Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Re: Run Report from a Form
Hi Lars, of course, 'I'm not kidding... although u can say that, 'cause in Axapta I'm only a 'kid'... hahaha I'll try to make a class first then... Thanks for you reply so soon... :) --- In Axapta-Knowledge-Village@yahoogroups.com, "Lars Holm" <[EMAIL PROTECTED]> wrote: > You are kidding, right? > > If not, it depends on how you call your report. A report can either be > called directly or using a class which inherits from runbasereport. In > both cases you must call either the class or report from a menu item. > This menu item you just drag into the form design (preferably in a > button group) and that's it. > > > Best regards, > > Lars Holm > Senior Technical Consultant > > T O I N C R E A S E - Y O U R B U S I N E S S > > > -Original Message- > From: Axapta-Knowledge-Village@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of Anton > Tjiptadi > Sent: 20. april 2005 12:10 > To: Axapta-Knowledge-Village@yahoogroups.com > Subject: [Axapta-Knowledge-Village] Run Report from a Form > > > > Hi, > how to run reports from a Form. > > I plan to create 2 or more report and it will run under 1 form, so in > that form will have 2 or more button, and when I clicked the button, it > will run the corresponding report. > > thanks in advance, > > > > > > > Yahoo! Groups Sponsor ~--> > What would our lives be like without music, dance, and theater? > Donate or volunteer in the arts today at Network for Good! > http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM > --- -~-> > > Sharing the knowledge on Axapta. > Yahoo! Groups Links Yahoo! Groups Sponsor ~--> In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~-> 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 email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Re: Subquery
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_date; > > select max(createddate) from _table1; > _date = _table.createdate ; > select _table2 where _table2.createdate == _date; > > > === 2005-01-25 10:30:06 ÄúÔÚÀ´ÐÅÖÐдµÀ£º=== > > >thanks, but isn't your query will only produce one line / record ? > > > >for my case, there might be many record which has the same date. > > > >thanks, > > > > > >--- In Axapta-Knowledge-Village@yahoogroups.com, "henrik3.rm" > ><[EMAIL PROTECTED]> wrote: > >> > >> > >> > >> Hi, > >> try this; > >> > >> Custtable Custtable; > >> ; > >> select firstonly Custtable order by createdDate desc; > >> > >> regards, > >> Henrik Østergård > >> computercamp DK > >> > >> --- In Axapta-Knowledge- [EMAIL PROTECTED], "anton_tjiptadi" > >> <[EMAIL PROTECTED]> wrote: > >> > > >> > 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 --- -~--> > >Has someone you know been affected by illness or disease? > >Network for Good is THE place to support health awareness efforts! > >http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM > >-- --~-> > > > >Sharing the knowledge on Axapta. > >Yahoo! Groups Links > > > > > > > > > > = = = = = = = = = = = = = = = = = = = = > > > Ö > Àñ£¡ > > > akin > [EMAIL PROTECTED] > 2005-01-25 Yahoo! Groups Sponsor ~--> In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~-> 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 email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Re: Subquery
thanks, but isn't your query will only produce one line / record ? for my case, there might be many record which has the same date. thanks, --- In Axapta-Knowledge-Village@yahoogroups.com, "henrik3.rm" <[EMAIL PROTECTED]> wrote: > > > > Hi, > try this; > > Custtable Custtable; > ; > select firstonly Custtable order by createdDate desc; > > regards, > Henrik Østergård > computercamp DK > > --- In Axapta-Knowledge-Village@yahoogroups.com, "anton_tjiptadi" > <[EMAIL PROTECTED]> wrote: > > > > 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 ~--> Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~-> 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 email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Subquery
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 computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~-> 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 email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Re: Lookup table in EDT ?
thanks guys,
but this time I don't want to write a code.
My steps are :
1. Create new EDT
2. in Relation node, I specify table name (PurchTable) and the field.
3. add Related Field Fixed, which is Dimension[5]
..the problem is the value is integer, whereas the value I want to
insert is "TNG".
The purpose is when I use the EDT in DialogField, user can
lookup/search records in PurchTable with Dimension[5] criteria value
is "TNG"
thanks,
--- In Axapta-Knowledge-Village@yahoogroups.com, akash malohatra
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> write the code in the ExecuteQuery() method of the
> datasource to filetr the data with user input value.
>
> declare "QBR" of type Querybuildrange in the class
> declartion.
>
> Then simply pass the userinput value to this
> querybuildrange in the executeQuery() method
>
> QBR.value(queryvalue("the user input")).
>
>
>
> hope this will help you.
> Regards
> Akash
> --- Tony Depalo <[EMAIL PROTECTED]> wrote:
>
> > In AOT/Forms/InventJournalTable there is a drop down
> > box showing ALL,
> > Posted or not Posted then depending on this value
> > the form is filtered,
> > that is maybe show only the posted entries. If this
> > is the sort of
> > functionality you are looking 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 table in
> > EDT ?
> >
> >
> >
> > Hi,
> > I want to add lookup table in my EDT which is
> > relate to some
> > table,
> > ex : PurchTable.
> >
> > I want to filter the data to show only some record,
> > for ex :
> > data
> > with Dimension(4) = "TNG"
> >
> > nb : this EDT, I'm gonna use it in Dialog so user
> > can lookup
> > table
> > first to insert the value in that DialogField.
> >
> > Can anyone help me ?
> > thanks in advance,
> > Anton
> >
> >
> >
> >
> >
> > 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 email to:
> >
> > [EMAIL PROTECTED]
> >
> <mailto:[EMAIL PROTECTED]
subject=Uns
> > ubscribe>
> >
> > * Your use of Yahoo! Groups is subject to the
> > Yahoo! Terms
> > of Service <http://docs.yahoo.com/info/terms/> .
> >
> >
> >
>
>
> __
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
Yahoo! Groups Sponsor ~-->
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM
~->
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 email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Lookup table in EDT ?
Hi, I want to add lookup table in my EDT which is relate to some table, ex : PurchTable. I want to filter the data to show only some record, for ex : data with Dimension(4) = "TNG" nb : this EDT, I'm gonna use it in Dialog so user can lookup table first to insert the value in that DialogField. Can anyone help me ? thanks in advance, Anton Yahoo! Groups Sponsor ~--> What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~-> 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 email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Re: Need help on Axap3.0 Exam Preparation
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 of 125 min. > Nitesh > - Original Message - > From: Ahmed Maghraby > To: Axapta-Knowledge-Village@yahoogroups.com > Sent: Saturday, January 15, 2005 12:52 PM > Subject: Re: [Axapta-Knowledge-Village] Need help on Axap3.0 Exam Preparation > > > Hi Padmaja, > > This is Axapta 3.0 programming exam preparation guide as in partnersource. > > Regards, > > Ahmed Maghraby > > Microsoft Business Solutions Certified Professional-Axapta 3.0 Programming Exam (VUE Exam # AX 30-202, Prometric Exam # MB6-202) Preparation Guide > Last Modified 12/15/2004 12:00:12 PM > Posted 9/27/2004 8:30:00 PM > This preparation guide includes information and tools to assist you in preparation for the exam. > > > > --- --- > > > > > Certification Track > > > Certification Title Exam Requirements > Microsoft Business Solutions Certified Professional-Axapta Programming >Axapta Programming Exam (VUE Exam # AX 30-202, Prometric Exam # MB6-202) > > > Note: Exam version must be 2.x or 3.0. For a list of Microsoft Axapta Exam Equivalents please click here. > > top > > > > > > Target Audience > Microsoft Business Solutions partners wishing to become a Microsoft Business Solutions Certified Professional-Axapta Programming should take this exam. Partners authorized for Microsoft Axapta should take this exam. > > top > > > > > > Exam Specifics > > > Skills Being Measured: > > This certification exam measures your ability to understand and articulate how to work with the development environment in Microsoft Axapta. It will also measure your understanding of how development is apply into 'real world' situations and how best practices are applied. > > Time Requirements & Questions: > > a.. 90 minutes to complete the exam > b.. 80 questions with a passing rate of 70% > top > > > > > > Exam Preparation Tools > In addition to your hands-on experience working with the product, we highly recommend using the following tools and training to help you prepare for this exam: > > a.. Axapta Development I (Training Manual/Courseware/eCourse) > b.. Axapta Development II - Introduction to X++ (Courseware/eCourse) > c.. Axapta X++ Advanced (Training Manual/Courseware (upon availability)) > Courseware will be updated and renamed to Axapta Development III - X++ Advanced > d.. Axapta MorphX Integration (Training Manual/Courseware (upon availability)) > Courseware will be updated and renamed to Axapta Development IV - MorphX Integration > > > For Training Manual and/or Courseware information or to order please click here. > > > > For eCourse information and/or to register please click here. > > > > For Classroom Training information/availability please check with your region. > > > > Supplemental Learning Resources: > > Developer's Guide > Best Practice Guide for Developers > > Additional Skills Recommended: > > Good general knowledge of Axapta would be a distinct advantage > Previous experience with object-oriented languages, such as Java or C# > Knowledge of Microsoft SQL and SQL syntax > Approximately 6-12 months Axapta developing experience would be helpful > > top > > > > > > Exam Topics > > > General Microsoft Axapta Architecture - 14% > > a.. 2-tier vs. 3-tier architecture > b.. Understanding of AOS and its significance > c.. Layer Technology > d.. Label system > e.. Data Import/Export > Development Tools - 16% > > a.. General AOT knowledge > b.. Intellimorph > c.. Understanding the Web Development environment > d.. Import/Export Objects > e.. Debugging Techniques > f.. Visual MorphXplorer > Application Objects - 18% > > a.. Data Dictionary Objects > b.. Forms > c.. Projects > d.. Reports > e.. Classes > f.. Queries > g.. Menus and Menue Items > h.. Security > i.. Configuration > j.. Table Collections > k.. Macros > l.. Web Objects > X++ Development - 22% > > a.. Cross-references > b.. Accessing the database > c.. Maps > d.. Temporary Tables > e.. Interaction with the User > f.. Data models > g.. Class models > h.. Delete methods > i.. Object IDs > Integration - 14% > > a.. Axapta APIs > b.. ActiveX Controls > c.. Working with DLLs >
[Axapta-Knowledge-Village] Re: query range -> like
correct, I just found it.
the criteria string should be like this :
sCrit = strFmt(('%1, %2'),'*CPP*', '*RV*');
thanks for your reply
rgds,
--- In Axapta-Knowledge-Village@yahoogroups.com, Steve Wright
<[EMAIL PROTECTED]> wrote:
>
> I think sCrit should be a comma separated list "*CPP*,*RV*" 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: Wednesday, 12 January 2005 12:32 PM
> To: Axapta-Knowledge-Village@yahoogroups.com
> Subject: [Axapta-Knowledge-Village] query range -> like
>
>
>
> 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 like %1) || (Voucher like %2))',
> "*CPP*", "*RV*");
>
> qRange2 = qbds1.addRange(fieldnum(LedgerJournalTrans, Voucher));
> qRange2.value(sCrit);
>
> please help,
> thanks in advance,
> Anton
>
>
>
>
>
> Sharing the knowledge on Axapta.
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
>
<http://us.ard.yahoo.com/SIG=129tb5609/M=298184.5639630.6699735.30011
76/D=gr
>
oups/S=1705001380:HM/EXP=1105590723/A=2495202/R=0/SIG=11evjk50a/*http
://www.
> netflix.com/Default?mqso=60188913> click here
>
> <http://us.adserver.yahoo.com/l?
M=298184.5639630.6699735.3001176/D=groups/S=
> :HM/A=2495202/rand=365997701>
>
> _
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/Axapta-Knowledge-Village/
> <http://groups.yahoo.com/group/Axapta-Knowledge-Village/>
>
>
> * To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]
subject=Unsubsc
> ribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service
> <http://docs.yahoo.com/info/terms/> .
Yahoo! Groups Sponsor ~-->
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM
~->
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 email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Re: query range -> like
thanks,
but I need to create it in querybuildrange, not in 'select statement'
rgds,
--- In Axapta-Knowledge-Village@yahoogroups.com, Lalith Jayantha
<[EMAIL PROTECTED]> wrote:
> Hi anton
>
> Create a string type Extenderd data type and asign the string
value to Extenderd data type
>
> ex: 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",
> 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 like %1) || (Voucher like %2))',
> "*CPP*", "*RV*");
>
> qRange2 = qbds1.addRange(fieldnum(LedgerJournalTrans, Voucher));
> qRange2.value(sCrit);
>
> please help,
> thanks in advance,
> Anton
>
>
>
>
>
> Sharing the knowledge on Axapta.
>
>
> Yahoo! Groups SponsorADVERTISEMENT
>
>
> -
> 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 email to:
> [EMAIL PROTECTED]
>
>Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
> -
> Do you Yahoo!?
> Yahoo! Mail - now with 250MB free storage. Learn more.
Yahoo! Groups Sponsor ~-->
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM
~->
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 email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] query range -> like
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 like %1) || (Voucher like %2))',
"*CPP*", "*RV*");
qRange2 = qbds1.addRange(fieldnum(LedgerJournalTrans, Voucher));
qRange2.value(sCrit);
please help,
thanks in advance,
Anton
Yahoo! Groups Sponsor ~-->
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM
~->
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 email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Group by in X++ ??
Hi, How to create X++ query for Group By ?? My select statement is simply like this (in Transact SQL) select a.salesid, sum(b.lineamount) from salestable a, salesline b where a.salesid=b.salesid group by a.salesid I try to build in X++ like this, but it cause error said that there's no Group by dsSalesTable = q.addDataSource(tablenum(SalesTable)); dsSalesLine = dsSalesTable.addDataSource(tablenum(SalesLine)); dsSalesLine.addLink(FieldNum(SalesTable, SalesId), FieldNum (SalesLine,SalesId)); dsSalesLine.JoinMode(JoinMode::InnerJoin); dsSalesLine.addSortField(FieldNum(SalesLine, SalesId)); dsSalesLine.orderMode(ordermode::GroupBy); dsSalesLine.addSelectionField(FieldNum(SalesLine, LineAmount), SelectionField::Sum); Thanks in advance, Yahoo! Groups Sponsor ~--> In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~-> 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 email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] fetchmode vs joinmode
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 = QueryBuildDataSource1.adddatasource(tablenum (LedgerJournalTrans)); QueryBuildDataSource2.addlink(fieldnum(SalesTable, SalesId), fieldnum (LedgerJournalTrans, SalesId)); QueryBuildDataSource2.JoinMode(JoinMode::Existjoin) . . . and then I see in some example using FetchMode, like this : QueryBuildDataSource2.FetchMode(JoinMode::ExistJoin); . . NB: the two example actually not related, but the point is, Is it right to join table with FetchMode like example no.2 ? I appreciate any kind of information :)) Thanks, Yahoo! Groups Sponsor ~--> What would our lives be like without music, dance, and theater? Donate or volunteer in the arts today at Network for Good! http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM ~-> 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 email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Pack / Unpack
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 email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: SV: [Axapta-Knowledge-Village] EDT -> Dimensions
hi,
what if I want to do it in "while select" statement ?
for ex :
While select salesid, payment, projid, salesresponsible, createddate
from salestable
where fieldid2ext(fieldnum(salestable, dimension),5) == _Branch
{
}
(above statement cause error ->Container and unbounded string (text)
fields are not allowed in a WHERE expression.)
thanks,
Merry Christmas or Happy Holiday to all of U . :))
--- In Axapta-Knowledge-Village@yahoogroups.com, "Lars Holm"
<[EMAIL PROTECTED]> wrote:
> Perhaps replace 1 with a comile time check, like this:
>
> range = dsInventTable.addRange(fieldid2ext(fieldnum(InventTable,
Dimension), SysDimension::Department+1));
>
> Br,
> Lars
>
>
>
> Fra: Varden Morris [mailto:[EMAIL PROTECTED]
> Sendt: ma 20-12-2004 13:23
> Til: Axapta-Knowledge-Village@yahoogroups.com
> Emne: Re: [Axapta-Knowledge-Village] EDT -> Dimensions
>
>
> You can try this:
>
> range1 = dsInventTable.addRange(fieldid2ext(fieldnum
(InventTable,Dimension),1))
> OR
> range2 = dsInventTable.addRange(fieldid2ext(fieldnum
(InventTable,Dimension),2))
> OR
> range3 = dsInventTable.addRange(fieldid2ext(fieldnum
(InventTable,Dimension),3))
>
>
>
> Varden Morris
>
>
>
> J. Wray & Nephew Ltd. - Group I.S.
>
> 234 Spanish Town Road
>
> Kingston 11, Jamaica, W.I.
>
>
>
> Phone: (876) - 923 - 6141 Ext. 2400, 2412
> Fax: (876) - 923 - 5372
>
> Cell: (876) - 3833566
> Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>
> [EMAIL PROTECTED]
<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,
dimension));
>
> -> I want to filter my report by dimesion number 4, how
should I
> write it in code, I tried by specifying the array ->
dimension[4] but
> its cause error
>
> thanks,
>
>
>
>
>
> Sharing the knowledge on Axapta.
>
>
>
>
>
>
> Do you Yahoo!?
> The all-new My Yahoo! <http://my.yahoo.com> - Get yours free!
>
> Sharing the knowledge on Axapta.
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
> click here
<http://us.ard.yahoo.com/SIG=129jluhdf/M=294855.5468653.6549235.30011
76/D=groups/S=1705001380:HM/EXP=1103631801/A=2455396/R=0/SIG=119u9qmi
7/*http://smallbusiness.yahoo.com/domains/>
>
>
>
>
> 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 email to:
> [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
Yahoo! Groups Sponsor ~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM
~->
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 email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] 2 company account, 2 DB in 1 Axapta Application
Hi, Is it possible to have 2 or more company account, 2 DB, and that 2 or more company account has its own AOT (in that case different objects) in 1 Axapta Application ? for example I have installed my Axapta application, and then I created : - 1 DB for company A and 1 DB for company B - and then I Axapta configuration utility, I created 2 configuration, one connect to DB A and the other to DB B. - when I login to Axapta, I choose company A, (with config to DB A), and I import AOT (I already export AOT from another Axapta Appl to XPO file), specific for that company. - and then I login with config to DB B, I choose company B and I import AOT specific for that company. please note that objects in this 2 AOT (2 XPO for this case) is different in their objects, such classes, form, report, even tables. I haven't try it yet, but who knows, maybe someone does, because in my logic, that's imposible, I meant two DB, yes, but the AOT structure must be same. please enlighten me :) thanks in advance, Anton Yahoo! Groups Sponsor ~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM ~-> 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 email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] String Manipulation
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! Groups Sponsor ~--> $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/kGEolB/TM ~-> 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 email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Re: Section Printing in Report.
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 data source); // or element.execute(x);
ret = true;
}
don't know it will help ? :)
rgds,
Anton
--- In [EMAIL PROTECTED], Ahmed Ibrahim
<[EMAIL PROTECTED]> wrote:
> Tony,
>
> Thanks so much but actually I want to prevent the printing of
bodysection if the return value of display methos is zero so how can
I bypass the printing of bodysection if value is zero?.
>
> Thanks in advance.
>
> Ahmed
>
>
> Tony Depalo <[EMAIL PROTECTED]> wrote:
> One way of doing this is to have your display method return a
str. Then within your display
> display str yourAnswer()
> {
> if(your answer <> 0)
> StrFmt('%1',YourAnswer;
> return '';
> }
>
> I think there is a property Show Zero that might also work?
> Tony
>
>
> -Original Message-
> From: mbsdeveloper [mailto:[EMAIL PROTECTED]
> Sent: Monday, 6 December 2004 3:38 PM
> To: [EMAIL PROTECTED]
> Subject: [Axapta-Knowledge-Village] Section Printing in Report.
>
>
>
>
> Dears,
>
> I created a display method in the body section to do some
> calculations, that works fine but actually I don't want the body
> section to be printed if the value of the function is zero. so can
> someone tell me how to do it?
>
> regards
> Ahmed
>
>
>
>
>
>
>
> Sharing the knowledge on Axapta.
>
>
>
>
> Sharing the knowledge on Axapta.
>
>
> Yahoo! Groups SponsorADVERTISEMENT
>
>
> -
> 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 email to:
> [EMAIL PROTECTED]
>
>Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
> __
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
Yahoo! Groups Sponsor ~-->
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/kGEolB/TM
~->
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 email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Add DialogField in report query form
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;
}
I've created an EDT called MLR_LedgerJournalTrans which relate to
table LedgerJournalTrans. When I execute the class, it did shows a
new textbox with LookUp to table LedgerJournalTrans, only the
problem is what I really want is to filter some of the record so for
example only show records with CurrencyCode "EUR".
can someone help me, please... :)
many thanks,
Anton
Yahoo! Groups Sponsor ~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM
~->
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 email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Executing Report from a self made form
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 Yahoo! Groups Sponsor ~--> $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/kGEolB/TM ~-> 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 email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
