[Axapta-Knowledge-Village] production journal report customisation

[Robert Linggoputro]

Hi all,
I have been asked to add item name into production journal report.
I have managed to create this report using report wizard from join of
ProdTableJour & InventTable. However I could not get the item name next to
the item ID on the report since item name are located on different body. Is
there any way to combine two bodies so that Item Id and name can be on the
same line?

Thanks in advance.

Regards
Robert

Re: [Axapta-Knowledge-Village] How to open new outlook meeting request from ax on button click

[Anitha S]

Hi,

Try this code :
static void OutlookAppointment(Args _args)
{
  COM sysOutlookCollection;
  COM collection;
  COMVariant comStartDate = new COMVariant();
  COMVariant comEndDate = new COMVariant();
  COM c;
   #SysOutLookCOMDEF
   #define.mapi("MAPI")
   #define.outlook("Outlook.Application")
   COM sysOutlook;
   COM sysOutlookNameSpace;
   COM sysOutlookMAPIFolder;
;
   sysOutlook = new COM(#outlook);
   sysOutlookNameSpace = sysOutlook.getNamespace(#mapi);
   sysOutlookNameSpace.logon();
   sysOutlookMAPIFolder = sysOutlookNameSpace.getDefaultFolder
(#OlDefaultFolders_olFolderCalendar);
   collection = sysOutlookMAPIFolder.items();
   c = collection.add();
   comStartDate.date(today());
   comStartDate.time(str2Time( "16:00:00"));
   comEndDate.date(today());
   comEndDate.time(str2Time( "16:45:00"));
   c.location("Sonata Software Ltd,conference Room,2nd Floor ,HO");
   c.subject("Meeting regarding Project status");
   c.body('Discuss about latest issues in project");
   c.start(comStartDate);
   c.end(comEndDate);
   c.save();
   if (c)
   {
 c.display();
 info("The action is created in Microsoft Outlook");
   }
   else
throw error("Error");
sysOutlookNameSpace.logoff();
}

Hope it helps ..

Regards,
Anitha
Sonata-Software Ltd,Blore

On Tue, Dec 15, 2009 at 9:40 PM, asit nayak  wrote:

>
>  
> [Attachment(s)from
>  asit nayak included below]
>
>   HI All ,
>
> I want to open Outlook meeting request on button click of AX form. This
> form is activity form in CRM module. Can anyone please help me with this,
> how can i do this. Your help is much apprciated.Please attached screenshot
> of meeting request i want to open.
>
> Thanks,
> Asit
>
>  
>

Re: [Axapta-Knowledge-Village] Workflow client error

[Anitha S]

Hi,

Compile and restore the classes and forms that are listed in the error
list.

Hope it helps!!!
Mail me if you still face any issues.

Regards,
Anitha
Sonata-Software,Blore.

On Wed, Dec 16, 2009 at 2:59 AM, Edvandro Santos
wrote:

>
>
> Hi All,
>
> When I submmit a workflow document, by the client machine, The "Actions"
> button enables the option to show the Workflow history.
>
> So, when I click in this button, the Workflow history shows, and a error is
> displayed every time:
>
> Error executing code: Wrong type argument to function.
>
>
>
> _
>
>
>
> (C)\Classes\WorkflowStatusTreeInfo\loadTrackingData
>
> (S)\Classes\WorkflowStatusTreeInfo\buildDetails - line 7
>
> (C)\Classes\WorkflowStatusTreeInfo\newTreeInfo - line 3
>
> (C)\Classes\WorkflowStatusForm\getSubmitterUserName
>
> (C)\Forms\WorkflowStatus\Data
> Sources\WorkflowTrackingStatusTable\Methods\submitterUserName - line 4
>
>
> Any suggestions?
>
> Regards,
>
> --
> Santos, Edvandro
> Microsoft Dynamics Development Consultant
> fale...@edvandro.com
> http://www.edvandro.com
> http://www.axfordummies.com
>
> 
>

Re: [Axapta-Knowledge-Village] Workflow setup error

[Edvandro Santos]

All, forget this mail, because I resolved it!

Thanks,

On Tue, Dec 15, 2009 at 6:31 PM, Edvandro Santos
wrote:

> Hi all,
>
> When I uninstall and install again the Workflow service in my Windows 2008
> Server, And define the Workflow Aplication Pool on IIS to 32bit-enabled and
> restart it, When i going to the Workflow Wizard in the administration module
> and click to validate the URL, the same error was shown:
>
>  "The request failed with HTTP status 405: Method Not Allowed."
>
> How can I resolved it?
>
> Regards,
>
>   On Wed, Dec 9, 2009 at 7:19 PM, Edvandro Santos <
> edvandro.san...@gmail.com> wrote:
>
>> Manoj, Jonathan and everybody who help me in this issue: thanks for the
>> support.
>>
>> Manoj, your solution was successfully!
>>
>> Regards,
>>
>>   On Mon, Dec 7, 2009 at 2:14 AM, manoj manoharan <
>> manoj19842...@yahoo.co.in> wrote:
>>
>>>
>>>
>>>   Hi Edvandro,
>>>
>>> *I got a solution for this.*
>>> **
>>> As you are using win2008 server , it is bit tricky in IIS settings.
>>> I tried for longtime and i got it.
>>>
>>> Now goto IIS -->Application pool of WF--> rightclick advanced settings
>>> and change 32 bit to TRUE.
>>>
>>> Now it will work
>>>
>>> Thanks
>>> Manoj
>>>
>>>
>>> --- On *Fri, 4/12/09, Edvandro Santos *wrote:
>>>
>>>
>>> From: Edvandro Santos 
>>> Subject: Re: [Axapta-Knowledge-Village] Workflow setup error
>>> To: Axapta-Knowledge-Village@yahoogroups.com
>>> Date: Friday, 4 December, 2009, 6:01 PM
>>>
>>>
>>>  My version is the same.
>>>
>>>  On Fri, Dec 4, 2009 at 10:08 AM, Jonathan Halland >> com
>>> > wrote:
>>>

  You can check out what version of ASP your Workflow is running on
 using IIS Manager -> Websites -> [WebsiteName] -> MicrosoftDynamicsAX
 Workflow50, right click, select Properties, Click on 
 ASP.NETTAB. I'm running on version 2.0.50


 Regards
 Jonathan
 http://workflowax. wordpress. com 


   On Fri, Dec 4, 2009 at 2:02 PM, Edvandro Santos >>> gmail.com
 > wrote:

>
>Hi Jonathan, how can I check it? I see that in my server exist 2
> folders with ASP.NET :
>
> 1. Framework;
> 2. Framework64.
>
>On Fri, Dec 4, 2009 at 4:03 AM, Jonathan Halland  com >wrote:
>
>>
>>Hi Edvandro.
>>
>> Have you tried checking that you have the latest version of 
>> asp.netinstalled for your IIS version. This may also be causing errors.
>>
>> Regards
>> Jonathan
>>
>>   On Fri, Dec 4, 2009 at 6:37 AM, Anitha S > gmail.com
>> > wrote:
>>
>>>
>>>   
>>> [Attachment(s)from
>>>  Anitha S included below]
>>> Hi Edvandro ,
>>>
>>> Check the attachement to configure URL.
>>> Hope it helps !!!
>>>
>>> Revert back if you still face issues.
>>>
>>> Regards,
>>> Anitha
>>>
>>>On Fri, Dec 4, 2009 at 12:59 AM, Edvandro Santos >> gmail.com
>>> > wrote:
>>>

Hi all,

 I have two servers with Windows 2008 R2 installed:

 1 - AOS/Application server, with IIS 7.0 installed;

 2 - Database Server (SQL Server 2008).

 I follow every steps mentioned in the manual, but when I will
 validate the URL in AX, I´ve got the error message: "The request 
 failed with
 HTTP status 405: Method Not Allowed."

 How can I resolved it?

 Thanks,

 --
 Santos, Edvandro
 Microsoft Dynamics Development Consultant
 fale...@edvandro. 
 com
 http://www.edvandro .com 
 http://www.axfordum mies.com 

>>>
>>>
>>
>
>
> --
> Santos, Edvandro
> Microsoft Dynamics Development Consultant
> fale...@edvandro. 
> com
> http://www.edvandro .com 
> http://www.axfordum mies.com 
>


>>>
>>>
>>> --
>>> Santos, Edvandro
>>> Microsoft Dynamics Development Consultant
>>> fale...@edvandro. 
>>> com
>>> http://www.edvandro .com 
>>> http://www.axf

[Axapta-Knowledge-Village] Workflow client error

[Edvandro Santos]

Hi All,

When I submmit a workflow document, by the client machine, The "Actions"
button enables the option to show the Workflow history.

So, when I click in this button, the Workflow history shows, and a error is
displayed every time:

Error executing code: Wrong type argument to function.



_



(C)\Classes\WorkflowStatusTreeInfo\loadTrackingData

(S)\Classes\WorkflowStatusTreeInfo\buildDetails - line 7

(C)\Classes\WorkflowStatusTreeInfo\newTreeInfo - line 3

(C)\Classes\WorkflowStatusForm\getSubmitterUserName

(C)\Forms\WorkflowStatus\Data
Sources\WorkflowTrackingStatusTable\Methods\submitterUserName - line 4


Any suggestions?

Regards,

-- 
Santos, Edvandro
Microsoft Dynamics Development Consultant
fale...@edvandro.com
http://www.edvandro.com
http://www.axfordummies.com

Re: [Axapta-Knowledge-Village] Workflow setup error

[Edvandro Santos]

Hi all,

When I uninstall and install again the Workflow service in my Windows 2008
Server, And define the Workflow Aplication Pool on IIS to 32bit-enabled and
restart it, When i going to the Workflow Wizard in the administration module
and click to validate the URL, the same error was shown:

 "The request failed with HTTP status 405: Method Not Allowed."

How can I resolved it?

Regards,

On Wed, Dec 9, 2009 at 7:19 PM, Edvandro Santos
wrote:

> Manoj, Jonathan and everybody who help me in this issue: thanks for the
> support.
>
> Manoj, your solution was successfully!
>
> Regards,
>
>   On Mon, Dec 7, 2009 at 2:14 AM, manoj manoharan <
> manoj19842...@yahoo.co.in> wrote:
>
>>
>>
>>   Hi Edvandro,
>>
>> *I got a solution for this.*
>> **
>> As you are using win2008 server , it is bit tricky in IIS settings.
>> I tried for longtime and i got it.
>>
>> Now goto IIS -->Application pool of WF--> rightclick advanced settings and
>> change 32 bit to TRUE.
>>
>> Now it will work
>>
>> Thanks
>> Manoj
>>
>>
>> --- On *Fri, 4/12/09, Edvandro Santos * wrote:
>>
>>
>> From: Edvandro Santos 
>> Subject: Re: [Axapta-Knowledge-Village] Workflow setup error
>> To: Axapta-Knowledge-Village@yahoogroups.com
>> Date: Friday, 4 December, 2009, 6:01 PM
>>
>>
>>  My version is the same.
>>
>>  On Fri, Dec 4, 2009 at 10:08 AM, Jonathan Halland > com
>> > wrote:
>>
>>>
>>>  You can check out what version of ASP your Workflow is running on using
>>> IIS Manager -> Websites -> [WebsiteName] -> MicrosoftDynamicsAX Workflow50,
>>> right click, select Properties, Click on ASP.NET  TAB.
>>> I'm running on version 2.0.50
>>>
>>>
>>> Regards
>>> Jonathan
>>> http://workflowax. wordpress. com 
>>>
>>>
>>>   On Fri, Dec 4, 2009 at 2:02 PM, Edvandro Santos >> gmail.com
>>> > wrote:
>>>

Hi Jonathan, how can I check it? I see that in my server exist 2
 folders with ASP.NET :

 1. Framework;
 2. Framework64.

On Fri, Dec 4, 2009 at 4:03 AM, Jonathan Halland >>> com
 > wrote:

>
>Hi Edvandro.
>
> Have you tried checking that you have the latest version of 
> asp.netinstalled for your IIS version. This may also be causing errors.
>
> Regards
> Jonathan
>
>   On Fri, Dec 4, 2009 at 6:37 AM, Anitha S  gmail.com
> > wrote:
>
>>
>>   
>> [Attachment(s)from
>>  Anitha S included below]
>> Hi Edvandro ,
>>
>> Check the attachement to configure URL.
>> Hope it helps !!!
>>
>> Revert back if you still face issues.
>>
>> Regards,
>> Anitha
>>
>>On Fri, Dec 4, 2009 at 12:59 AM, Edvandro Santos > gmail.com
>> > wrote:
>>
>>>
>>>Hi all,
>>>
>>> I have two servers with Windows 2008 R2 installed:
>>>
>>> 1 - AOS/Application server, with IIS 7.0 installed;
>>>
>>> 2 - Database Server (SQL Server 2008).
>>>
>>> I follow every steps mentioned in the manual, but when I will
>>> validate the URL in AX, I´ve got the error message: "The request failed 
>>> with
>>> HTTP status 405: Method Not Allowed."
>>>
>>> How can I resolved it?
>>>
>>> Thanks,
>>>
>>> --
>>> Santos, Edvandro
>>> Microsoft Dynamics Development Consultant
>>> fale...@edvandro. 
>>> com
>>> http://www.edvandro .com 
>>> http://www.axfordum mies.com 
>>>
>>
>>
>


 --
 Santos, Edvandro
 Microsoft Dynamics Development Consultant
 fale...@edvandro. 
 com
 http://www.edvandro .com 
 http://www.axfordum mies.com 

>>>
>>>
>>
>>
>> --
>> Santos, Edvandro
>> Microsoft Dynamics Development Consultant
>> fale...@edvandro. 
>> com
>> http://www.edvandro .com 
>> http://www.axfordum mies.com 
>>
>>
>> --
>> The INTERNET now has a personality. YOURS! See your Yahoo! 
>> Homepage.
>>
>>
>>  
>>
>
>
>
> --
> Santos, Edvandro
> Microsoft Dynamics Development Consultant
> 

[Axapta-Knowledge-Village] How to open new outlook meeting request from ax on button click [1 Attachment]

[asit nayak]

HI All ,
I want to open Outlook meeting request on button click of AX form. This form is 
activity form in CRM module. Can anyone please help me with this, how can i do 
this. Your help is much apprciated.Please attached screenshot of meeting 
request i want to open.
Thanks,Asit 


  

Re: [Axapta-Knowledge-Village] AOD modified date

[jens]

James,

When you delete the .aoi file, this will be rebuilt - and all .aod files
will have a new date.

/Jens

> Our auditor requires to know when are the AOD files updated by AX.
>
> Is it only when a change is made in the corresponding layer in an AOT
> object
> or are there other situations?
>
> If an object exists in both VAR and USR, if it is modified in USR can the
> VAR aod file in anyway be affected?
>
> If aoi is rebuilt can this affect?
> If cross reference is updated can this affect?
>
> The reason is the VAR aod file has strange dates that cannot be explained
> (since we did not do any changes in the VAR layer since a certain date)
> and
> so the auditor wants to know the situations of how AX can modify it
>
> Is there any way we can filter or see if there is any object in the VAR
> layer that has a created or modified date after a certain date?
>
>
>
> Thanks
>
> James
>
>
>
>

[Axapta-Knowledge-Village] Sub-Selects in X++ Query

[Jonathan Halland]

Hi All.

Has anyone managed to use s subselect within queries sepecifically
QueryRange objects in X++? I'm trying to do something along the following
lines:

select from table_x where voucher_id is in (select voucher_id from table_x
where table_x.Posting_Type='Ledger')

The real query is a bit more complex than the above and will not allow for a
normal join.

Any Help?