RE: [Axapta-Knowledge-Village] Problem occured during Master planning

2008-08-21 Thread Harry Deshpande 
Are all items getting affected by this problem or just a subset?

Regards


Harry Deshpande
http://blogs.msdn.com/axperf


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of narendra singh
Sent: Thursday, August 21, 2008 4:30 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Problem occured during Master planning


Hi Friends,
Can anyone of you help me.I am facing a problem during running master planning 
in Ax4.0 sp2.
Although on hand inventory is available before running master planning,but 
after running Master planning it is again generating requirement.I have checked 
all setup but unable to find out the problem.It is urgent.
Thanks & Regards
NBSingh
9910365709

Unlimited freedom, unlimited storage. Get it now, on 
http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/

[Axapta-Knowledge-Village] Required Method

2008-08-21 Thread Hemant Sonawane 
Hi All,
  I want one method.
 
Requirement : I have 3 table x , y  and z 
x table field is    f1,f2,f3
y table field is    f1,f4,f5
z table field is    f4,f6,f7
 
table x and y common field is f1
and table y and z common field is f4
 
I want display data of z table f6 on report then what is the method of that..
 
I have already create the relation in reports data sources as following manners
 
Report Name (ABC)
method (mm)
Data Sources
    Data Sources
        first table x
            data sources
                second table y
                    relation is y.f1=x.f1
                            data sources
                                third table z
                                        relation is z.f4=y.f4
but z.f4 field value is not display on reports
so please suggest me.
 
thanks


  Unlimited freedom, unlimited storage. Get it now, on 
http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/

Re: [Axapta-Knowledge-Village]

2008-08-21 Thread Tri Budianto 
U can't use select distinct like in the sql.
In axapta, it's a little tricky
I'm test this code below in AX 5.0 and it works

While Select F2, F3, F4
>From table
Group By F2, F3, F4
{
   info(strfmt('%1 - %2 - %3', table.F2, table.F3, table.F4));
}

cheers..

On Thu, Aug 21, 2008 at 2:13 PM, joelwu <[EMAIL PROTECTED]> wrote:

>
>  Dear All:
>
> Anyone know how to do a select distinct in Dynamics AX, for exmple I have a
> table like this
>
> F1   F2   F3   F4   F5   F6   F7
> A   P-01   Ser   TTA   0   0   0
> A   P-01   Ser   TTA   0   65   65
> A   P-01   Ser   TTA   35   0   -35
> A   P-01   Spa   EOI   0   0   0
> A   P-01   Spa   EOI   26.01   0   -26.01
> A   P-02   Spa   Cab   0   0   0
> A   P-02   Spa   Cab   596.25   0   -596.25
> A   P   Sub   MLL   0   105   105
> A   P   Sub   MLL   0   5000   5000
>
> I want to get the unique field of F2, F3,F4 like the result bellow
>
> P-01   Ser   TTA
> P-01   Spa   EOI
> P-02   Spa   Cab
>  P   Sub   MLL
>
> How can I do this in AX??
>
> Joel
>
>  
>



-- 
Best Regards,
Tri Budianto

[Axapta-Knowledge-Village] Required Method Knowledge (Documents)

2008-08-21 Thread Hemant Sonawane 
Hi All,
 I don't know how method is write in Ax. I am fresher in Ax 
Dynamics 4.0. I have very well in Relation, Indexing,Report and Qurery in Sql 
Server. 
So please help me any documentation is available on net. So please give me a 
string of "PDF" file doc.
    I want basic knowledge of methods also.
 
Thanks & Regards
Have a nice day.


  Add more friends to your messenger and enjoy! Go to 
http://in.messenger.yahoo.com/invite/

[Axapta-Knowledge-Village] Re: Multiple PO's in 1 Packing slip

2008-08-21 Thread Kavitha Axapta 
Hi
 
Select all Po's at once and use summary update

[Axapta-Knowledge-Village] Log in on diffrent system

2008-08-21 Thread vikrant verma 
Hi,
Iam working on AX-4.0 Sp-2 Version, the user id is connected/attached with a 
system in a domain.
Now said user can,t work upon another system or can't log on to his/her ID 
remotely. also its very difficult to create user group and test the same on 
single PC
If there any solution 
please guide .
Vikrant
functional consultant

[Axapta-Knowledge-Village] Problem occured during Master planning

2008-08-21 Thread narendra singh 
Hi Friends,
Can anyone of you help me.I am facing a problem during running master planning 
in Ax4.0 sp2.
Although on hand inventory is available before running master planning,but 
after running Master planning it is again generating requirement.I have checked 
all setup but unable to find out the problem.It is urgent.
Thanks & Regards
NBSingh
9910365709


  Unlimited freedom, unlimited storage. Get it now, on 
http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/

[Axapta-Knowledge-Village] Required Solution

2008-08-21 Thread Hemant Sonawane 
Hi All,
    I have create my won project in Private Project folder. If I have 
make a any changes in my private project table ( table is drag from AOT ) then 
live AOT table is also change same as in Relation and method.
means I have make a new methode in my private project the method is create aslo 
in AOT.
How can I avoid this problem.
  Any process or setting is available to avoid this problem.
Thanks & Regards


  From Chandigarh to Chennai - find friends all over India. Go to 
http://in.promos.yahoo.com/groups/citygroups/

Re: [Axapta-Knowledge-Village] Required Time In second

2008-08-21 Thread Hemant Sonawane 
Yes,
 I was modify the code.
thanks



- Original Message 
From: Harry Deshpande <[EMAIL PROTECTED]>
To: "Axapta-Knowledge-Village@yahoogroups.com" 

Sent: Thursday, 14 August, 2008 10:57:48 AM
Subject: RE: [Axapta-Knowledge-Village] Required Time In second


I guess you will have to modify the code.
 
Regards
 
Harry
 
 
From:Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge- 
[EMAIL PROTECTED] ups.com] On Behalf Of Hemant Sonawane
Sent: Wednesday, August 13, 2008 9:30 PM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: [Axapta-Knowledge- Village] Required Time In second
 
Hi,
   I have create a work center in Basic module/Work Center Group on Times 
Tab.
I want to put the  run time in second but Hours/time ins min. parameters.
then how can I put the time in second any process are there.
please help me.
 
thanks 
Hemant
 





Unlimited freedom, unlimited storage. Get it now 


  Download prohibited? No problem. CHAT from any browser, without download. 
Go to http://in.webmessenger.yahoo.com/

Re: [Axapta-Knowledge-Village]

2008-08-21 Thread Marko Salonen 
Hi,

DISTINCT is, uh, tricky.
Start by checking this
out
.

--m

2008/8/21 joelwu <[EMAIL PROTECTED]>

>
>  Dear All:
>
> Anyone know how to do a select distinct in Dynamics AX, for exmple I have a
> table like this
>
> F1   F2   F3   F4   F5   F6   F7
> A   P-01   Ser   TTA   0   0   0
> A   P-01   Ser   TTA   0   65   65
> A   P-01   Ser   TTA   35   0   -35
> A   P-01   Spa   EOI   0   0   0
> A   P-01   Spa   EOI   26.01   0   -26.01
> A   P-02   Spa   Cab   0   0   0
> A   P-02   Spa   Cab   596.25   0   -596.25
> A   P   Sub   MLL   0   105   105
> A   P   Sub   MLL   0   5000   5000
>
> I want to get the unique field of F2, F3,F4 like the result bellow
>
> P-01   Ser   TTA
> P-01   Spa   EOI
> P-02   Spa   Cab
>  P   Sub   MLL
>
> How can I do this in AX??
>
> Joel
>
>
>

[Axapta-Knowledge-Village]

2008-08-21 Thread joelwu 

 Dear All:
 
Anyone know how to do a select distinct in Dynamics AX, for exmple I have a 
table like this
 
F1   F2   F3   F4   F5   F6   F7
A   P-01   Ser   TTA   0   0   0
A   P-01   Ser   TTA   0   65   65
A   P-01   Ser   TTA   35   0   -35
A   P-01   Spa   EOI   0   0   0
A   P-01   Spa   EOI   26.01   0   -26.01
A   P-02   Spa   Cab   0   0   0
A   P-02   Spa   Cab   596.25   0   -596.25
A   P   Sub   MLL   0   105   105
A   P   Sub   MLL   0   5000   5000

I want to get the unique field of F2, F3,F4 like the result bellow

P-01   Ser   TTA 
P-01   Spa   EOI 
P-02   Spa   Cab
P   Sub   MLL

How can I do this in AX??

Joel