[Axapta-Knowledge-Village] How to call SSRS report directly.

[SUNEEL BABU]

Hi, How to call SSRS report using x++ code like calling normal reports in ax?. 
With out using menuitem.?

Regards.,Suneel   

Re: [Axapta-Knowledge-Village] AX 2009 with POS 2009

[somanna gl]

Thanks for the reply.

POS 2009 is more graphical and user friendly than AX 2009 pos.


Kind Regards
Somanna


From: Victor Tunggal virawan11...@yahoo.com
To: Axapta-Knowledge-Village@yahoogroups.com; 
development-axa...@yahoogroups.com development-axa...@yahoogroups.com
Sent: Friday, July 15, 2011 11:07 AM
Subject: Re: [Axapta-Knowledge-Village] AX 2009 with POS 2009


  
Why don't u use ax retail instead?

Sent from my BlackBerry®
powered by Sinyal Kuat INDOSAT


From:  somanna gl glsom...@yahoo.com 
Sender:  Axapta-Knowledge-Village@yahoogroups.com 
Date: Tue, 12 Jul 2011 22:46:21 -0700 (PDT)
To: development-axa...@yahoogroups.comdevelopment-axa...@yahoogroups.com; 
Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village@yahoogroups.com
ReplyTo:  Axapta-Knowledge-Village@yahoogroups.com 
Subject: [Axapta-Knowledge-Village] AX 2009 with POS 2009
  
Hi All,

Can we integrate AX 2009 with POS 2009.

Thanks a lot.

Kind Regards,
Somanna
 

Re: [Axapta-Knowledge-Village] AX 2009 with POS 2009

[Victor Tunggal]

Why don't u use ax retail instead?

Sent from my BlackBerry®
powered by Sinyal Kuat INDOSAT

-Original Message-
From: somanna gl glsom...@yahoo.com
Sender: Axapta-Knowledge-Village@yahoogroups.com
Date: Tue, 12 Jul 2011 22:46:21 
To: development-axa...@yahoogroups.comdevelopment-axa...@yahoogroups.com; 
Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village@yahoogroups.com
Reply-To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] AX 2009 with POS 2009

Hi All,

Can we integrate AX 2009 with POS 2009.

Thanks a lot.

Kind Regards,
Somanna

[Axapta-Knowledge-Village] AX 2009 with POS 2009

[somanna gl]

Hi All,

Can we integrate AX 2009 with POS 2009.

Thanks a lot.

Kind Regards,
Somanna

[Axapta-Knowledge-Village] remove HTML tag

[V G]

Hi
I am using a html editor from ax and type in (amp; in html) when I get the
text back in AX  it is returned as  amp;.
Is there a way in ax to remove all these characters and only get  instead
of whole html amp; and similarly for other html characters.
I used web::striphtml but that removed html tags but doesn't convert amp;
to .
Any help is greatly appreciated.
Thanks
VG

Re: [Axapta-Knowledge-Village] Change Message on delete record

[Iin Dewi]

Hi VG,

Why don't you try to change it from Label Editor, search the message that you 
wanted to change, if you find it then rename the message and save it.

The path : Menu - Tools - Development Tools - Lable - Label Editor

Regards,

Iin Dewi Wahyuni

http://geeks.netindonesia.net/blogs/idw/ or

http://www.linkedin.com/in/iindewi

--- On Mon, 5/16/11, V G learnaxa...@gmail.com wrote:

From: V G learnaxa...@gmail.com
Subject: [Axapta-Knowledge-Village] Change Message on delete record
To: axapta-Knowledge-Village@yahoogroups.com, development-axa...@yahoogroups.com
Date: Monday, May 16, 2011, 1:18 AM















 
 



  



  
  
  Hi All
How can we change the standard message that we get when we want to delete a 
record in AX.
Or how can we suppress the standard message and give our own message.
Thanks
VG




 





 



  

[Axapta-Knowledge-Village] Change Message on delete record

[V G]

Hi All
How can we change the standard message that we get when we want to delete a
record in AX.
Or how can we suppress the standard message and give our own message.
Thanks
VG

[Axapta-Knowledge-Village] show counter of letters typed in a field

[V G]

Hi All

Is there a way in AX  to show the no of letters a user has typed in a
particular field.
And this has to show and keep changing while the user is typing the letters.
So if the user typed 'ab' it will show 2 char and when he types 'abc' it
should change to 3 char.

Thanks
VG

[Axapta-Knowledge-Village] Show Item Name and save Item ID

[V G]

Hi All

I have a requirement where we have to show the item name on the production
order and save as item id in the table.
This needs to be one field showing itemname and saving itemId.
Any help is greatly appreciated.

Thanks
VG

Re: [Axapta-Knowledge-Village] Show Item Name and save Item ID

[Iin Dewi]

Hi VG,

Create a display method on ProdTable table as shown below :

display ItemName getItemName()
{
  return InventTable::find(this.ItemId).ItemName;
}

after that drag the method into the grid on ProdTable form, and fill out the 
datasource property into ProdTable.

That's it !!

Regards,

Iin Dewi Wahyuni

http://geeks.netindonesia.net/blogs/idw/ or

http://www.linkedin.com/in/iindewi

--- On Tue, 5/10/11, V G learnaxa...@gmail.com wrote:

From: V G learnaxa...@gmail.com
Subject: [Axapta-Knowledge-Village] Show Item Name and save Item ID
To: axapta-Knowledge-Village@yahoogroups.com, development-axa...@yahoogroups.com
Date: Tuesday, May 10, 2011, 3:25 AM















 
 



  



  
  
  Hi All

I have a requirement where we have to show the item name on the production 
order and save as item id in the table.
This needs to be one field showing itemname and saving itemId.
Any help is greatly appreciated.


Thanks
VG 




 





 



  

Re: [Axapta-Knowledge-Village] Show Item Name and save Item ID

[somanna gl]

use a form lookup and say close select item ID



From: V G learnaxa...@gmail.com
To: axapta-Knowledge-Village@yahoogroups.com; development-axa...@yahoogroups.com
Sent: Tue, May 10, 2011 12:55:04 PM
Subject: [Axapta-Knowledge-Village] Show Item Name and save Item ID

  
Hi All

I have a requirement where we have to show the item name on the production 
order 
and save as item id in the table.
This needs to be one field showing itemname and saving itemId.
Any help is greatly appreciated.

Thanks
VG 

 

[Axapta-Knowledge-Village] Regarding virtual company

[srinath s]

Hi All,

I have issue when saving a record  in the virtual company.

Environment:
Client and server 5.0.1000.52
Assume VIR1 AND VIR2 are the AX company and its been setup as virtual company. 
Table collection contains Vendtable and custtable. Also dirpartycollection is 
added as well.

Imported the CEU setup data into the VIR1. While importing it asked whether we 
need to import custable and vendtable. I gave Yes. So VIR1 has customer and 
vendor data.

Imported the CEU setup data into the VIR2. While importing it asked whether we 
need to import custable and vendtable. I gave No. Because the already it will 
be there and shared between VIR1 and VIR2.



Now when i edit any of the record in customer form from VIR1 company its saving 
the changes. But when i edit the record in the customer form from VIR2 company 
then following error is thrown my AX.
The values displayed in the form are not current, so an update or deletion 
cannot be made. To view the current values, on the Command menu, click Restore

Could anybody help on this. Am i doing wrong with virtual company setup.
 
Thanks and Regards,
Srinath. S

[Axapta-Knowledge-Village] Regarding intercompany

[srinath s]

Hello Champs,

Could you please share any document or steps for AX intercompany setup and how 
to do the transaction related to it.

Appreciate a response.
 
Regards,
Srinath. S

[Axapta-Knowledge-Village] Auto save in AX 4.0

[V G]

Hi

Can the auto save in AX be disabled and only save when the save button is
pressed.
We don't want to save the record when navigating to next record.

Thanks

[Axapta-Knowledge-Village] HTML editor in AX

[V G]

Hi Group

We have a requirement where in the client want to use a html editor from AX.
They have a description field and they want to have description like in bold
or bullet points.
Please let me know if this is a possibility in AX 4.0

Thanks

[Axapta-Knowledge-Village] Spell check in AX 4.0

[V G]

Hi Group

I have a client who wants to have spell check feature in AX 4.0.
Is that a possibility. Please let me know your experience.
Thanks in advance

[Axapta-Knowledge-Village] Help required

[somanna gl]

Hi All,

 how to calculate setup cost of production.

thanks a lot.

Bye
Somanna

[Axapta-Knowledge-Village] Help Requred

[somanna gl]

hi All,

How can i calculate work center capacity vs load for a given period.

Thank you.

Best Regards
Somanna

[Axapta-Knowledge-Village] Ax 2009 WorkSlow error - Windows 2008 R2 X64 system

[SUNEEL BABU]

Hi,,
During deployment of Microsoft Dynamics AX 2009 Workflow on one of environments 
running on Windows Server 2008 R2 I was able to validate Workflow URL in Basic 
 Setup  Settings for workflow. I was also able to access Workflow page from 
AOS server,
 
but when running the workflow processing batch job I got an error in the 
Windows Event viewer for Microsoft Dynamics Ax Workflow:
 
Exception thrown in SysWorkflowEventDispatcher-onAcknowledgeWorkflowActivation 
SysWorkflowEventDispatcher-raiseWorkflowActivationEvent : Web service failed: 
workflow id 48_201 System.Web.Services.Protocols.SoapException: Server was 
unable to process request. --- System.ComponentModel.Win32Exception: Access is 
denied 
at System.Diagnostics.ProcessManager.OpenProcess(Int32 processId, Int32 access, 
Boolean throwIfExited) 
at System.Diagnostics.NtProcessManager.GetModuleInfos(Int32 processId, Boolean 
firstModuleOnly) 
at System.Diagnostics.Process.get_MainModule() 
at System.Workflow.Runtime.PerformanceCounterManager.SetInstanceName(String 
instanceName) 
at System.Workflow.Runtime.WorkflowRuntime.StartRuntime() 
at 
Microsoft.Dynamics.Framework.Workflow.AxWorkflowRuntime.get_WindowsWorkflowRuntime()
 
at 
Microsoft.Dynamics.Framework.Workflow.AxWorkflowRuntime.CreateWorkflowInstance(XmlReader
 workflowDefinitionReader, Guid workflowInstanceId) 
at 
Microsoft.Dynamics.Framework.Workflow.WorkflowInstanceManager.Activate(Activity 
workflowRoot, Guid workflowInstanceId) 
at 
Microsoft.Dynamics.Framework.Workflow.WorkflowInstanceManager.Activate(WorkflowActivationRequest
 activationInfo) 
at 
Microsoft.Dynamics.Framework.Workflow.WebServices.AxaptaWorkflowInstance.Activate(WorkflowActivationRequest
 activationRequest)




  

[Axapta-Knowledge-Village] IMP link http://janataparty.org/sonia.html

[somanna gl]

[Axapta-Knowledge-Village] Axapta 3.0 vs AX 2009

[SUNEEL BABU]

Hi,
 
What are the technical diffrences between Axapta 3.O and Ax 2009 in technical 
terms?

Regards.,
Suneel

  

[Axapta-Knowledge-Village] multiple production orders from sales line(bom)

[SUNEEL BABU]

1.how to create multiple production orders  from the sales lines
2.Is it possible to create production orders for the SUB BOMs of a main BOM 
from the sales order line .if yes HOW? 

Regards.,
Suneel
 
 

  

[Axapta-Knowledge-Village] Error while importing XPO

[SUNEEL BABU]

HI,
 
I try to import an XPO object to my new server. After importing i got the 
following errors and warnings. 
 






1.Cannot create a record in Group rights (AccessRightsList). Group: Admin, 
Admin.







2.Illegal value: HPREMPLSHIFTS for property Table.






3.Minor error during import of Table HPRLOANPlease help me on this issues.

Regards.,
Suneel

  

[Axapta-Knowledge-Village] Sending reports as attachment by batch process - Urgent

[Sakthivel K]

Dear All,
    I am using Ax 2009 Sp1 with windows 2008 r2 64 bit machine.I can 
send report as attachment,but when i try to send reports as attachment by using 
batch process i am getting following error message.I have configured SMTP 
information as well as batch related information.



Error message:
COM object of class 'CDO .Message' could not be created. Ensure that the object 
has been properly registered on computer computername

  Thanks for your reply


Thanks,
Sakthivel




  

[Axapta-Knowledge-Village] Info class customization leads to import issue...

[srinath s]

Hi All, 
 
 As i customized the info class  formnotify() to meet the requirement, export 
the customized objects along info class as xpo and imported the same in new 
environment. 
After the import the AX throws infolog message saying the Error: Recompile the 
script Info\formnotify(). I need to follow the below steps after importing then 
only the issue is getting resolved. 
 1. Recompile or do compile forward for 3 or 4 times 
2. Relauch ax and compile. 
 Is this issue will happen when we write code in info class? 
How to rectify the issue instead of compiling. Because will feel something 
happened wrong. Instead of making the Infologdetail as none in the Tools- 
options window anyother way to do automatic compiling and not showing the 
infolog error message. 
 
 
Is it a known issue? 
 
Please suggest me on this. 
 
Appreciate a response. 
 
Regards, 
Srinath. S 
 
Sweet Regards,
Srinath. S
 

[Axapta-Knowledge-Village] How to know current user group in AX

[SUNEEL BABU]

How to know current user group in AX?

Regards.,
Suneel

  

[Axapta-Knowledge-Village] Regarding help files

[SUNEEL BABU]

HI,I want do create a help file for my module developed in. I have the .chm 
file and copied it in to the client bin location. Now i created a help menu for 
that. It shows in the help menu but when i click that it shows error html path 
not exist. Is there any other process for adding our own help files to AX help 
menu.


Thanks  Regards.,Suneel

  

[Axapta-Knowledge-Village] On BOM Configuration and Product Builder

[somanna gl]

Hi All,

Can you please tell me the difference between BOM configuration and Product 
builder.
And when to use them..


Any tips will be of Gr8 help.

Kindest Regards
Somanna


  

[Axapta-Knowledge-Village] updation of physical inventory with ax inventory

[phallini]

Hi,
The client generated inventory report of purchases and sales, where  financial 
quantity (Axapta Stock) n physical stock (Actual stock present in the 
warehouse) is showing difference, where both have to be equal or same. Now how 
to make both financial quantity n physical stock same or equal. Pls kindly 
suggest what steps to be followed. And what could be the major reason for the 
differences.
Pls kindly help me.

Thank u
Regards
saanvi

Re: [Axapta-Knowledge-Village] Grids that show only One Record, not all Records, no filters!

[René Roca]

Hi George.

Check that your client have the same versión in Client and Server.
In some cases, if you have diferents version on Client you only view one
record in a grid. for Example Server in Sp1 rollup 4 and client with Sp1 and
Rollup 5

Regards.
www.dynamicsax.es

2010/9/9 George Burrell george.burr...@solutionpartners.co.nz



  We have an AX 2009 SP1 hotfix rollup 4 installation.



 I have struck an unusual, and seemingly intermittent issue.


 When starting an AX client on the AOS server many grids only shows one
 record - Users, On line Users, Sales Orders, Customers.  A report we were
 testing shows one line also.

 On the other hand, the complete General Ledger Chart of Accounts can be
 seen on grid.

 Thankfully, our users who have client computers, are not reporting any
 problems.  (Perhaps they might at some stage in the future?)

 Other observations:
 *  Table Browsers in Dynamics Ax showed single record where the Grids did
 *  SQL Server shows complete data
 *  Drilling down from one Form to another form shows records PRECEDING the
 target record, the target record, then no more records below that.  e.g.
 Drilling down from a Sales Order line to the Item Form.

 This morning we had the 1-record grids etc, later on we had all records
 showing, now I see one record per grid.

 The problem has recently been reported elsewhere - in a Google forum last
 month:


 http://groups.google.com/group/microsoft.public.axapta/browse_thread/thread/854e431c358aea13

 No solution offered there, but I can see we are not alone.

 We found this very scary.  Can you please let us know how to resolve this.


 http://groups.google.com/group/microsoft.public.axapta/browse_thread/thread/854e431c358aea13



 In our case


 Kernel Version   5.0.1500.3200
 Application Version  5.0.1500.2116

 TIA

 *george *



  

[Axapta-Knowledge-Village] Help to create a form using ocx file

[anamika singh]

Hi All,

I've a .ocx file  i want to create a form using it in ax 2009
I've already registered this file through regsvr32 cmd.
Kindly tell me the solution.
 
With Regards
Anamika Singh
 

Re: [Axapta-Knowledge-Village] Help to create a form using ocx file

[mni_col]

Hi,

perhaps  http://msdn.microsoft.com/en-us/library/aa551694.aspx could help you.

Best regards 
Michael


From: anamika singh 
Sent: Wednesday, September 08, 2010 1:26 PM
To: Axapta-Knowledge 
Subject: [Axapta-Knowledge-Village] Help to create a form using ocx file


  
  Hi All,

  I've a .ocx file  i want to create a form using it in ax 2009
  I've already registered this file through regsvr32 cmd.
  Kindly tell me the solution.

  With Regards
  Anamika Singh
 

[Axapta-Knowledge-Village] Grids that show only One Record, not all Records, no filters!

[George Burrell]

We have an AX 2009 SP1 hotfix rollup 4 installation. 

 

I have struck an unusual, and seemingly intermittent issue.


When starting an AX client on the AOS server many grids only shows one
record - Users, On line Users, Sales Orders, Customers.  A report we
were testing shows one line also.

On the other hand, the complete General Ledger Chart of Accounts can be
seen on grid. 

Thankfully, our users who have client computers, are not reporting any
problems.  (Perhaps they might at some stage in the future?)

Other observations:
*  Table Browsers in Dynamics Ax showed single record where the Grids
did
*  SQL Server shows complete data
*  Drilling down from one Form to another form shows records PRECEDING
the target record, the target record, then no more records below that.
e.g. Drilling down from a Sales Order line to the Item Form.

This morning we had the 1-record grids etc, later on we had all records
showing, now I see one record per grid.

The problem has recently been reported elsewhere - in a Google forum
last month:

http://groups.google.com/group/microsoft.public.axapta/browse_thread/thr
ead/854e431c358aea13

No solution offered there, but I can see we are not alone.  

We found this very scary.  Can you please let us know how to resolve
this.



http://groups.google.com/group/microsoft.public.axapta/browse_thread/thr
ead/854e431c358aea13

 

In our case


Kernel Version   5.0.1500.3200
Application Version  5.0.1500.2116

TIA

george 

 

[Axapta-Knowledge-Village] Unable to create company account in ax 09

[neeraj]

Hi All,
I am using ax 09 sp1 with IND Localization standard(Base) package.
when i tried to create an company from administrator/Company account
it create the company.but when  again i reopen the same form company account  
doesnt exist their.after that i checked in SQL server record is their but its 
not showing in AX(front End).
i tired with different SQL server also but same issue persist.
kindly suggest me the solution  or cause behind this.
I am looking forward for response asap.

Re: [Axapta-Knowledge-Village] INSTALLATION ERRO

[Chaminda Kothalawala]

Hi Irshad
Use windows server 2003 or 2008 as a operating system. Then you will not get
this error.

Thank you
Chaminda
On Mon, Sep 6, 2010 at 10:46 PM, Irshad heartambassa...@gmail.com wrote:



 Hi

 i am trying to install microsoft ax 2009 but i am getting below error,
 could you please help me to sort out this issue.

  === Setup logging started: 06/09/2010 18:30:48 ===
 Running file: C:\DOCUME~1\IRSHAD~1.MUH\LOCALS~1\Temp\AxSetup\AxSetup.exe
 RelatedFilesDir=D:\Downloads\Compressed\MD.AX.2009.Full\MD.AX.2009.Full\DynamicsAX2009

 AxSetup version number: 5.0.593.0
 Microsoft Windows NT 5.1.2600 Service Pack 3 (32 bit)
 IRSHAD
 SFS-LIB\irshad.muhammad
 Interactive: True


 RelatedFilesDir=D:\Downloads\Compressed\MD.AX.2009.Full\MD.AX.2009.Full\DynamicsAX2009
 Property RelatedFilesDir set to:
 'D:\Downloads\Compressed\MD.AX.2009.Full\MD.AX.2009.Full\DynamicsAX2009\'
 Property SetupLanguage set to: 'EN'

 === Loading parameters from the command line or a parameter file ===
 Initializing log file: C:\Documents and Settings\All Users\Application
 Data\Microsoft\Dynamics AX\Dynamics AX Setup Logs\2010-09-06
 18-30-47\DynamicsSetupLog.txt

  === Starting evaluation of existing installation state ===
 MSI file: Components32.msi  Installed: False
 MSI file: ClientHelp.msi  Installed: False


  === Checking parameters ===
 Property InstallPath set to: 'C:\Program Files\Microsoft Dynamics AX\50'

  === Starting UI phase ===
 Property AcceptLicenseTerms set to: '1'
 Property BypassWarnings set to: '0'
 Property RunMode set to: 'DeveloperComponents'
 Property InstallAnalysisServicesExtensions set to: '0'
 Setup has detected that you are installing Application Object Server (AOS)
 on an operating system that is not supported for Microsoft Dynamics AX.
 The minimum supported server operating system is Microsoft Windows Server
 2003 with Service Pack 2.
 Property InstallAos set to: '1'
 Property ClientAosServer set to: 'IRSHAD'
 Property InstallApplication set to: '1'
 Property InstallAifWebServices set to: '0'
 Property InstallBizTalkAdapter set to: '0'
 Property InstallClientUI set to: '1'
 Property InstallComBusinessConnector set to: '0'
 Property InstallDatabase set to: '1'
 Property InstallEnterprisePortal set to: '0'
 Property InstallNetBusinessConnector set to: '1'
 Property InstallDebugger set to: '1'
 Property InstallEnterprisePortalTools set to: '0'
 Property InstallReportingServicesExtensions set to: '0'
 Property InstallReportingTools set to: '0'
 Property InstallSynchronizationProxy set to: '0'
 Property InstallSynchronizationService set to: '0'
 Property InstallWorkflow set to: '0'
 Property DbServerType set to: '0'
 Property InstallDatabase set to: '0'
 Performing  prerequisite validation: VC++ SP1
 Performing  prerequisite validation: VC++ SP1
 Performing  prerequisite validation: SNAC
 Property InstallPath set to: 'C:\Program Files\Microsoft Dynamics AX\50'
 Property DbSqlServer set to: 'IRSHAD'
 Connected to SQL Server: 'IRSHAD'
 Connected to SQL Server: 'IRSHAD'
 Property DbSqlDatabaseName set to: 'ContosoBaseDemoDataAx2009'
 Property InstallApplication set to: '2'
 Property ApplicationInstanceName set to: 'ContosoBaseDemoDataAx2009'
 Property ApplicationRegion set to: '-'
 Property AosPort set to: '2712'
 Property AosInstanceName set to: 'ContosoBaseDemoDataAx2009'
 Property AosPort set to: '2712'
 Property AosReportErrors set to: '0'
 The localized name for the NT Authority\Network Service account has
 been identified as 'NT AUTHORITY\NETWORK SERVICE'.
 Property AosAccount set to: 'SFS-LIB\irshad.muhammad'
 We do not recommend using your account SFS-LIB\irshad.muhammad for the
 Application Object Server (AOS) account. Contact your system administrator
 to create a dedicated account.
 Property AosAccountPassword set to: '**'
 Property ClientLanguage set to: 'EN-US'
 Property ClientHelpLanguages set to: 'EN-US'
 Property AosStart set to: '0'

  === Starting execution phase ===
 === Setting up Application files ===
 Completed setup of Application files.
 === Setting up Application Object Server (AOS) ===
 Adding account 'SFS-LIB\irshad.muhammad' as a login in Microsoft SQL
 Server.
 isolation level = read committed snapshot
 isolation level = read committed snapshot
 Property AosApplicationPath set to: 'C:\Program Files\Microsoft Dynamics
 AX\50'
 Setting up rights for the AOS service account 'SFS-LIB\irshad.muhammad' to
 access the application files at: C:\Program Files\Microsoft Dynamics
 AX\50\Application
 The localized name for the BUILTIN\USERS account has been identified as
 'BUILTIN\Users'.
 Launching MSI:  /i
 D:\Downloads\Compressed\MD.AX.2009.Full\MD.AX.2009.Full\DynamicsAX2009\Msi\ObjectServer32\ObjectServer32.msi
 /qb-! /l*v C:\Documents and Settings\All Users\Application
 Data\Microsoft\Dynamics AX\Dynamics AX Setup Logs\2010-09-06
 18-30-47\ObjectServer32 Log.txt DIRECTEXECUTE=1 SETUPLANGUAGE=EN
 TRANSFORMS=:Instance01 MSINEWINSTANCE=1 INSTALLDIR=C:\Program
 

[Axapta-Knowledge-Village] Services are getting stopped/ AOS stops

[pranam mukher]

Hi all 
 
We have been working to solve this issue, just need some inputs from your end. 
We have a server where we have installed workflows, and its our test 
environment. 
And i have done customization, on Purchase order form to incorporate workflows 
into it. 
It was working fine, all of a sudden sometimes, if  i try to create a record in 
PO, or some other tables, AOS goes down. I dont underastand the issue here. Can 
anyone tell me. 
 
Number of users on the AOS is only 20. Dont know why AOS is going down. 
 
Thanks 
Pranam. 
 
 

Re: [Axapta-Knowledge-Village] Record Level Security on Reports

[René Roca]

Try putting the following statement in your code the report before making
fetch

Table.recordLevelSecurity(True);

Regards.
www.dynamicsax.es

2010/9/6 Ax Consultant ax_consult...@yahoo.com



 We implemented RLS on tables, for example Customer dimension wise. When
 concern user opens the customer detail form; he sees only respective
 dimension’s customers. So it means that RLS is working; however when that
 particular customer take Customer report, it shows report for all customer.

 Do we have to implement RLS separately on Report tables as I believe report
 uses the same tables we insert the data.

 any idea?

  

Re: [Axapta-Knowledge-Village] Services are getting stopped/ AOS stops

[venkat raghavan]

Dear Pranam,
 
What is the error message registered in the event viewer while AOS is going 
down?
 
Regards,
Venkat.

--- On Tue, 9/7/10, pranam mukher pranam_shub...@yahoo.co.in wrote:


From: pranam mukher pranam_shub...@yahoo.co.in
Subject: [Axapta-Knowledge-Village] Services are getting stopped/ AOS stops
To: axa knwoldge Axapta-Knowledge-Village@yahoogroups.com, dev ax 
development-axa...@yahoogroups.com
Date: Tuesday, September 7, 2010, 12:53 PM


  








Hi all 
 
We have been working to solve this issue, just need some inputs from your end. 
We have a server where we have installed workflows, and its our test 
environment. 
And i have done customization, on Purchase order form to incorporate workflows 
into it. 
It was working fine, all of a sudden sometimes, if  i try to create a record in 
PO, or some other tables, AOS goes down. I dont underastand the issue here. Can 
anyone tell me. 
 
Number of users on the AOS is only 20. Dont know why AOS is going down. 
 
Thanks 
Pranam. 
 
 








  

Re: [Axapta-Knowledge-Village] Services are getting stopped/ AOS stops

[pranam mukher]

Issue is with BusinessConnector. 
 event log says. 
RPC exception 1722, in ping occured in session 140.
any idea.

--- On Tue, 7/9/10, venkat raghavan pvraghavan...@yahoo.com wrote:


From: venkat raghavan pvraghavan...@yahoo.com
Subject: Re: [Axapta-Knowledge-Village] Services are getting stopped/ AOS stops
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Tuesday, 7 September, 2010, 3:09 PM


  








Dear Pranam,
 
What is the error message registered in the event viewer while AOS is going 
down?
 
Regards,
Venkat.

--- On Tue, 9/7/10, pranam mukher pranam_shub...@yahoo.co.in wrote:


From: pranam mukher pranam_shub...@yahoo.co.in
Subject: [Axapta-Knowledge-Village] Services are getting stopped/ AOS stops
To: axa knwoldge Axapta-Knowledge-Village@yahoogroups.com, dev ax 
development-axa...@yahoogroups.com
Date: Tuesday, September 7, 2010, 12:53 PM


  






Hi all 
 
We have been working to solve this issue, just need some inputs from your end. 
We have a server where we have installed workflows, and its our test 
environment. 
And i have done customization, on Purchase order form to incorporate workflows 
into it. 
It was working fine, all of a sudden sometimes, if  i try to create a record in 
PO, or some other tables, AOS goes down. I dont underastand the issue here. Can 
anyone tell me. 
 
Number of users on the AOS is only 20. Dont know why AOS is going down. 
 
Thanks 
Pranam. 
 
 

Re: [Axapta-Knowledge-Village] Services are getting stopped/ AOS stops

[venkat raghavan]

Dear Pranam,
 
 
Hope it helps you to solve the issue.
The Dynamics AX Object Server 5.0 service terminated with service-specific 
error 80 (0x50)
When attempting to start the AOS Service after changing the Log on, the 
following error appeared:


Windows could not start the Dynamics AX Object Server 5.0$01-[Application] on 
[Server].  For more information, review the System Event Log.  If this is a 
non-Microsoft service, contact the service vendor, and refer to 
service-specific error code 80.

System Event Log:


The Dynamics AX Object Server 5.0$01-[Application] service terminated with 
service-specific error 80 (0x50).

This occurred regardless of any database permissions.  The workaround was to 
apply the following permissions to the following folders:



%ProgramFiles%\Microsoft Dynamics AX\50\Application\Appl\[Application]


Modify, Read  execute 
List folder contents 
Read 
Write

%ProgramFiles%\Microsoft Dynamics AX\50\Server\[Application]\Log


Read 
Write
While the AOS Service was down, the following error got written into the 
Application log each second:


Microsoft Dynamics AX Business Connector Session 7.
RPC error: RPC exception 1722 in Ping occurred in session 50


 
Source : http://danielkuettel.spaces.live.com/
 
Regards,
Venkat
 


--- On Tue, 9/7/10, pranam mukher pranam_shub...@yahoo.co.in wrote:


From: pranam mukher pranam_shub...@yahoo.co.in
Subject: Re: [Axapta-Knowledge-Village] Services are getting stopped/ AOS stops
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Tuesday, September 7, 2010, 3:53 PM


  








Issue is with BusinessConnector. 
 event log says. 
RPC exception 1722, in ping occured in session 140.
any idea.

--- On Tue, 7/9/10, venkat raghavan pvraghavan...@yahoo.com wrote:


From: venkat raghavan pvraghavan...@yahoo.com
Subject: Re: [Axapta-Knowledge-Village] Services are getting stopped/ AOS stops
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Tuesday, 7 September, 2010, 3:09 PM


  






Dear Pranam,
 
What is the error message registered in the event viewer while AOS is going 
down?
 
Regards,
Venkat.

--- On Tue, 9/7/10, pranam mukher pranam_shub...@yahoo.co.in wrote:


From: pranam mukher pranam_shub...@yahoo.co.in
Subject: [Axapta-Knowledge-Village] Services are getting stopped/ AOS stops
To: axa knwoldge Axapta-Knowledge-Village@yahoogroups.com, dev ax 
development-axa...@yahoogroups.com
Date: Tuesday, September 7, 2010, 12:53 PM


  






Hi all 
 
We have been working to solve this issue, just need some inputs from your end. 
We have a server where we have installed workflows, and its our test 
environment. 
And i have done customization, on Purchase order form to incorporate workflows 
into it. 
It was working fine, all of a sudden sometimes, if  i try to create a record in 
PO, or some other tables, AOS goes down. I dont underastand the issue here. Can 
anyone tell me. 
 
Number of users on the AOS is only 20. Dont know why AOS is going down. 
 
Thanks 
Pranam. 
 
 










  

Re: [Axapta-Knowledge-Village] Error in Connecting to Another Database

[venkat raghavan]

Dear Sai sharan,
 
Please find below the valuable details from a SQL expert to solve the error you 
have mentioned below
 
http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/
 
Hope it may help.
 
Regards,
Venkat

--- On Mon, 9/6/10, sai sharan saisharan@gmail.com wrote:


From: sai sharan saisharan@gmail.com
Subject: Re: [Axapta-Knowledge-Village] Error in Connecting to Another Database
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Monday, September 6, 2010, 12:39 PM


  



Hi venkat Raghavan,

   Thnx fr ur valuable Info.
  I created a class for connction and i calld that class from 
SalesFormLetter_pickingList, But it has shown  up with an Another Error. can u 
help  me out of this. 
  
 A network-related or instance-specific error occurred while establishing a 
connection to SQL Server. The server was not found or was not accessible. 
Verify that the instance name is correct and that SQL Server is configured to 
allow remote connections. (provider: Named Pipes Provider, error: 40 - Could 
not open a connection to SQL Server)  


On Mon, Sep 6, 2010 at 9:34 AM, venkat raghavan pvraghavan...@yahoo.com wrote:


  








Dear Sai Sharan,
 
It worked for you in VPC because, both salesFormLetter 
and SalesFormLetter_PickingList classes Runon property is by default set to 
CalledFrom. In VPC both AOS and Client resides in the same virtual machine, 
the Runon behaviour will be obviously on server. 
 
What you can do is, you can write a class for connecting to the other database 
and set the Runon property for that class to Server. Then you can call that 
class from SalesFormLetter_PickingList.
 
Hope it will help you.
 
Regards,
Venkat

--- On Mon, 9/6/10, venkat raghavan pvraghavan...@yahoo.com wrote:


From: venkat raghavan pvraghavan...@yahoo.com
Subject: Re: [Axapta-Knowledge-Village] Error in Connecting to Another Database

To: Axapta-Knowledge-Village@yahoogroups.com
Date: Monday, September 6, 2010, 9:17 AM



  






Dear Sai Sharan,
 
Make sure that Runon property is set to server.
 
Regards,
Venkat.

--- On Sat, 9/4/10, Sai Sharan saisharan@gmail.com wrote:


From: Sai Sharan saisharan@gmail.com
Subject: [Axapta-Knowledge-Village] Error in Connecting to Another Database
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Saturday, September 4, 2010, 6:30 PM


  

Hi all,
i had a senario where i need to save some data from Ax_Database to another 
database. I had Written a code for connecting to the Externa database.
It worked fine when i Executed my code in VPC(VirtualPC)., But when i Execute 
the same code in Client System it showed me a Problem
saying that
1.ODBC operation failed.Unable to log on to the database.
2.[Microsoft][SQL Native Client]Login timeout expired.
3.Object 'OdbcConnection' could not be created.

i wrote my code in SalesFormLetter Class and i caled from 
SalesFormLetter_PickingList.

waiting fr ur valuable sugessions







-- 
Saisharan koka,
PH:9550654880










  

Re: [Axapta-Knowledge-Village] Error in Connecting to Another Database

[sai sharan]

Thnx a lo fr ur help. vl get back to u if there are any queries
On 9/4/10, Ashish Singh compa...@gmail.com wrote:






 Hi Sai Sharan,

 You can see the code in the standard DAX 2009 classes for your reference
 \Classes\SIGSigningProvider_SQLServer_Server

 Couple of suggestions for you, try to incorporate them.

 a) Try to incroporate the Permission class.
 b) Use the CCADO classes rather than ODBC classes for connecting to the
 another database.
 c) Be careful when supplying the login user name, make sure that the user
 name that you are using to connect to other system should not be used more
 than once.
 d) Put the code inside the Try Catch statement, else you will not be able to
 figure out as to why some error had happened at least that is the case for
 the CCADO classes.

 This is the sample code that i have posted from you. Here you can see that i
 written the code inside the try catch block and see the last part where i
 had done the exception handling this will give you detailed error message as
 to why error is popping up. This code is consuming the CCADO classes.


 void openConnection()
 {
 System.Exception clrException;
 InteropPermissionpermission = new
 InteropPermission(InteropKind::ClrInterop);
 Str
 localConnectionString;
  ;
 try
 {
 permission.assert();
  // BP deviation documented
 sqlConnection  = new
 System.Data.SqlClient.SqlConnection(sqlConnectionString);
 if(sqlConnection.get_State() !=
 System.Data.ConnectionState::Open)
 {
 sqlConnection.Open();
 }
 else
 {
 info(Connection is already open !);
  }
 CodeAccessPermission::revertAssert();
 }
 catch(Exception::CLRError)
 {
 // BP deviation documented
 clrException = CLRInterop::getLastException();
 if (clrException != null)
  {
 clrException =
 clrException.get_InnerException();
 if (clrException != null)
 {
 //store error - don't throw here
 throw error(clrException.get_Message());
  }
 }
 }
 }

 Hope this will help you.

 Have a nice day.

 Regards,
 ashish singh
  
 accenture


 On Sat, Sep 4, 2010 at 6:30 PM, Sai Sharan saisharan@gmail.com wrote:

 
 
 
 
 
 
  Hi all,
  i had a senario where i need to save some data from Ax_Database to another
 database. I had Written a code for connecting to the Externa database.
  It worked fine when i Executed my code in VPC(VirtualPC)., But when i
 Execute the same code in Client System it showed me a Problem
  saying that
  1.ODBC operation failed.Unable to log on to the database.
  2.[Microsoft][SQL Native Client]Login timeout expired.
  3.Object 'OdbcConnection' could not be created.
 
  i wrote my code in SalesFormLetter Class and i caled from
 SalesFormLetter_PickingList.
 
  waiting fr ur valuable sugessions
 
 
 




 


-- thnx for ur valuable sugessions.i vl check d code and come back to
u if dere are any queries.
Saisharan koka,
*PH*:9550654880




News-Flash of Axapta Knowledge Village
===
VISIT THE Microsoft Dynamics AX Knowledge Village at LINKEDIN: 
http://www.linkedin.com/e/gis/165338.

Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.

Come and choose your preferred name for Microsoft Dynamics AX on the Axapta 
Knowledge Village, Visit www.axapta-knowledge-village.tk
Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/

* Your email settings:
Individual Email | Traditional

* To change settings online go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/join
(Yahoo! ID required)

* To change settings via email:
axapta-knowledge-village-dig...@yahoogroups.com 
axapta-knowledge-village-fullfeatu...@yahoogroups.com

* To unsubscribe from this group, send an email to:
axapta-knowledge-village-unsubscr...@yahoogroups.com

* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

Re: [Axapta-Knowledge-Village] Error in Connecting to Another Database

[sai sharan]

Hi venkat Raghavan,

   Thnx fr ur valuable Info.
  I created a class for connction and i calld that class from
SalesFormLetter_pickingList, But it has shown  up with an Another Error. can
u help  me out of this.

 A network-related or instance-specific error occurred while establishing a
connection to SQL Server. The server was not found or was not accessible.
Verify that the instance name is correct and that SQL Server is configured
to allow remote connections. (provider: Named Pipes Provider, error: 40 -
Could not open a connection to SQL Server) 

On Mon, Sep 6, 2010 at 9:34 AM, venkat raghavan pvraghavan...@yahoo.comwrote:



 Dear Sai Sharan,

 It worked for you in VPC because, both salesFormLetter
 and SalesFormLetter_PickingList classes Runon property is by default set to
 CalledFrom. In VPC both AOS and Client resides in the same virtual
 machine, the Runon behaviour will be obviously on server.

 What you can do is, you can write a class for connecting to the other
 database and set the Runon property for that class to Server. Then you can
 call that class from SalesFormLetter_PickingList.

 Hope it will help you.

 Regards,
 Venkat

 --- On *Mon, 9/6/10, venkat raghavan pvraghavan...@yahoo.com* wrote:


 From: venkat raghavan pvraghavan...@yahoo.com
 Subject: Re: [Axapta-Knowledge-Village] Error in Connecting to Another
 Database

 To: Axapta-Knowledge-Village@yahoogroups.com
 Date: Monday, September 6, 2010, 9:17 AM



Dear Sai Sharan,

 Make sure that Runon property is set to server.

 Regards,
 Venkat.

 --- On *Sat, 9/4/10, Sai Sharan saisharan@gmail.com* wrote:


 From: Sai Sharan saisharan@gmail.com
 Subject: [Axapta-Knowledge-Village] Error in Connecting to Another Database
 To: Axapta-Knowledge-Village@yahoogroups.com
 Date: Saturday, September 4, 2010, 6:30 PM


 Hi all,
 i had a senario where i need to save some data from Ax_Database to another
 database. I had Written a code for connecting to the Externa database.
 It worked fine when i Executed my code in VPC(VirtualPC)., But when i
 Execute the same code in Client System it showed me a Problem
 saying that
 1.ODBC operation failed.Unable to log on to the database.
 2.[Microsoft][SQL Native Client]Login timeout expired.
 3.Object 'OdbcConnection' could not be created.

 i wrote my code in SalesFormLetter Class and i caled from
 SalesFormLetter_PickingList.

 waiting fr ur valuable sugessions



  




-- 
Saisharan koka,
*PH*:9550654880

Re: [Axapta-Knowledge-Village] Error in Connecting to Another Database

[sai sharan]

Hi  Ashish Singh,

  i had followed what u have to told me , but now getting a new error. I
think may be this is an error in Sql Server. I need a way to resolve this
error. The error that i got was.

   '' A network-related or instance-specific error occurred while
establishing a connection to SQL Server. The server was not found or was not
accessible. Verify that the instance name is correct and that SQL Server is
configured to allow remote connections. (provider: Named Pipes Provider,
error: 40 - Could not open a connection to SQL Server) ''





On Sat, Sep 4, 2010 at 11:14 PM, Ashish Singh compa...@gmail.com wrote:



 Hi Sai Sharan,

 You can see the code in the standard DAX 2009 classes for your reference *
 \Classes\SIGSigningProvider_SQLServer_Server*

 Couple of suggestions for you, try to incorporate them.

 a) Try to incroporate the Permission class.
 b) Use the CCADO classes rather than ODBC classes for connecting to the
 another database.
 c) Be careful when supplying the login user name, make sure that the user
 name that you are using to connect to other system should not be used more
 than once.
 d) Put the code inside the Try Catch statement, else you will not be able
 to figure out as to why some error had happened at least that is the case
 for the CCADO classes.

 This is the sample code that i have posted from you. Here you can see that
 i written the code inside the try catch block and see the last part where i
 had done the exception handling this will give you detailed error message as
 to why error is popping up. This code is consuming the CCADO classes.


 void openConnection()
 {
 System.Exception clrException;
 InteropPermissionpermission = new
 InteropPermission(InteropKind::ClrInterop);
 Str  localConnectionString;
 ;
 try
 {
 permission.assert();
  // BP deviation documented
 sqlConnection  = new
 System.Data.SqlClient.SqlConnection(sqlConnectionString);
 if(sqlConnection.get_State() != System.Data.ConnectionState::Open)
 {
 sqlConnection.Open();
 }
 else
 {
 info(Connection is already open !);
 }
 CodeAccessPermission::revertAssert();
 }
 catch(Exception::CLRError)
 {
 // BP deviation documented
 clrException = CLRInterop::getLastException();
 if (clrException != null)
 {
 clrException = clrException.get_InnerException();
 if (clrException != null)
 {
 //store error - don't throw here
 throw error(clrException.get_Message());
 }
 }
 }
 }
 Hope this will help you.

 Have a nice day.

 Regards,
 ashish singh
  **
 *accenture*

 On Sat, Sep 4, 2010 at 6:30 PM, Sai Sharan saisharan@gmail.comwrote:



 Hi all,
 i had a senario where i need to save some data from Ax_Database to another
 database. I had Written a code for connecting to the Externa database.
 It worked fine when i Executed my code in VPC(VirtualPC)., But when i
 Execute the same code in Client System it showed me a Problem
 saying that
 1.ODBC operation failed.Unable to log on to the database.
 2.[Microsoft][SQL Native Client]Login timeout expired.
 3.Object 'OdbcConnection' could not be created.

 i wrote my code in SalesFormLetter Class and i caled from
 SalesFormLetter_PickingList.

 waiting fr ur valuable sugessions


  




-- 
Saisharan koka,
*PH*:9550654880

[Axapta-Knowledge-Village] Record Level Security on Reports

[Ax Consultant]

We implemented RLS on tables, for example Customer dimension wise. When concern 
user opens the customer detail form; he sees only respective dimension’s 
customers. So it means that RLS is working; however when that particular 
customer take Customer report, it shows report for all customer. 

Do we have to implement RLS separately on Report tables as I believe report 
uses the same tables we insert the data. 

any idea?


  

[Axapta-Knowledge-Village] INSTALLATION ERRO

[Irshad]

Hi

i am trying to install microsoft ax 2009 but i am getting below error, could
you please help me to sort out this issue.

 === Setup logging started: 06/09/2010 18:30:48 ===
Running file: C:\DOCUME~1\IRSHAD~1.MUH\LOCALS~1\Temp\AxSetup\AxSetup.exe
RelatedFilesDir=D:\Downloads\Compressed\MD.AX.2009.Full\MD.AX.2009.Full\DynamicsAX2009

AxSetup version number: 5.0.593.0
Microsoft Windows NT 5.1.2600 Service Pack 3 (32 bit)
IRSHAD
SFS-LIB\irshad.muhammad
Interactive: True

RelatedFilesDir=D:\Downloads\Compressed\MD.AX.2009.Full\MD.AX.2009.Full\DynamicsAX2009
Property RelatedFilesDir set to:
'D:\Downloads\Compressed\MD.AX.2009.Full\MD.AX.2009.Full\DynamicsAX2009\'
Property SetupLanguage set to: 'EN'

=== Loading parameters from the command line or a parameter file ===
Initializing log file: C:\Documents and Settings\All Users\Application
Data\Microsoft\Dynamics AX\Dynamics AX Setup Logs\2010-09-06
18-30-47\DynamicsSetupLog.txt

 === Starting evaluation of existing installation state ===
MSI file: Components32.msi  Installed: False
MSI file: ClientHelp.msi  Installed: False


 === Checking parameters ===
Property InstallPath set to: 'C:\Program Files\Microsoft Dynamics AX\50'

 === Starting UI phase ===
Property AcceptLicenseTerms set to: '1'
Property BypassWarnings set to: '0'
Property RunMode set to: 'DeveloperComponents'
Property InstallAnalysisServicesExtensions set to: '0'
Setup has detected that you are installing Application Object Server (AOS)
on an operating system that is not supported for Microsoft Dynamics AX.
The minimum supported server operating system is Microsoft Windows Server
2003 with Service Pack 2.
Property InstallAos set to: '1'
Property ClientAosServer set to: 'IRSHAD'
Property InstallApplication set to: '1'
Property InstallAifWebServices set to: '0'
Property InstallBizTalkAdapter set to: '0'
Property InstallClientUI set to: '1'
Property InstallComBusinessConnector set to: '0'
Property InstallDatabase set to: '1'
Property InstallEnterprisePortal set to: '0'
Property InstallNetBusinessConnector set to: '1'
Property InstallDebugger set to: '1'
Property InstallEnterprisePortalTools set to: '0'
Property InstallReportingServicesExtensions set to: '0'
Property InstallReportingTools set to: '0'
Property InstallSynchronizationProxy set to: '0'
Property InstallSynchronizationService set to: '0'
Property InstallWorkflow set to: '0'
Property DbServerType set to: '0'
Property InstallDatabase set to: '0'
Performing  prerequisite validation: VC++ SP1
Performing  prerequisite validation: VC++ SP1
Performing  prerequisite validation: SNAC
Property InstallPath set to: 'C:\Program Files\Microsoft Dynamics AX\50'
Property DbSqlServer set to: 'IRSHAD'
Connected to SQL Server: 'IRSHAD'
Connected to SQL Server: 'IRSHAD'
Property DbSqlDatabaseName set to: 'ContosoBaseDemoDataAx2009'
Property InstallApplication set to: '2'
Property ApplicationInstanceName set to: 'ContosoBaseDemoDataAx2009'
Property ApplicationRegion set to: '-'
Property AosPort set to: '2712'
Property AosInstanceName set to: 'ContosoBaseDemoDataAx2009'
Property AosPort set to: '2712'
Property AosReportErrors set to: '0'
The localized name for the NT Authority\Network Service account has been
identified as 'NT AUTHORITY\NETWORK SERVICE'.
Property AosAccount set to: 'SFS-LIB\irshad.muhammad'
We do not recommend using your account SFS-LIB\irshad.muhammad for the
Application Object Server (AOS) account. Contact your system administrator
to create a dedicated account.
Property AosAccountPassword set to: '**'
Property ClientLanguage set to: 'EN-US'
Property ClientHelpLanguages set to: 'EN-US'
Property AosStart set to: '0'

 === Starting execution phase ===
=== Setting up Application files ===
Completed setup of Application files.
=== Setting up Application Object Server (AOS) ===
Adding account 'SFS-LIB\irshad.muhammad' as a login in Microsoft SQL Server.
isolation level = read committed snapshot
isolation level = read committed snapshot
Property AosApplicationPath set to: 'C:\Program Files\Microsoft Dynamics
AX\50'
Setting up rights for the AOS service account 'SFS-LIB\irshad.muhammad' to
access the application files at: C:\Program Files\Microsoft Dynamics
AX\50\Application
The localized name for the BUILTIN\USERS account has been identified as
'BUILTIN\Users'.
Launching MSI:  /i
D:\Downloads\Compressed\MD.AX.2009.Full\MD.AX.2009.Full\DynamicsAX2009\Msi\ObjectServer32\ObjectServer32.msi
/qb-! /l*v C:\Documents and Settings\All Users\Application
Data\Microsoft\Dynamics AX\Dynamics AX Setup Logs\2010-09-06
18-30-47\ObjectServer32 Log.txt DIRECTEXECUTE=1 SETUPLANGUAGE=EN
TRANSFORMS=:Instance01 MSINEWINSTANCE=1 INSTALLDIR=C:\Program
Files\Microsoft Dynamics AX\50\Server AOSACCOUNTPASSWORD=
BYPASSWARNINGS=0
An error occurred during setup of Application Object Server (AOS).
For more information see: C:\Documents and Settings\All Users\Application
Data\Microsoft\Dynamics AX\Dynamics AX Setup Logs\2010-09-06

Re: [Axapta-Knowledge-Village] Error in Connecting to Another Database

[venkat raghavan]

Dear Sai Sharan,
 
Make sure that Runon property is set to server.
 
Regards,
Venkat.

--- On Sat, 9/4/10, Sai Sharan saisharan@gmail.com wrote:


From: Sai Sharan saisharan@gmail.com
Subject: [Axapta-Knowledge-Village] Error in Connecting to Another Database
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Saturday, September 4, 2010, 6:30 PM


  



Hi all,
i had a senario where i need to save some data from Ax_Database to another 
database. I had Written a code for connecting to the Externa database.
It worked fine when i Executed my code in VPC(VirtualPC)., But when i Execute 
the same code in Client System it showed me a Problem
saying that
1.ODBC operation failed.Unable to log on to the database.
2.[Microsoft][SQL Native Client]Login timeout expired.
3.Object 'OdbcConnection' could not be created.

i wrote my code in SalesFormLetter Class and i caled from 
SalesFormLetter_PickingList.

waiting fr ur valuable sugessions









  

Re: [Axapta-Knowledge-Village] Error in Connecting to Another Database

[venkat raghavan]

Dear Sai Sharan,
 
It worked for you in VPC because, both salesFormLetter 
and SalesFormLetter_PickingList classes Runon property is by default set to 
CalledFrom. In VPC both AOS and Client resides in the same virtual machine, 
the Runon behaviour will be obviously on server. 
 
What you can do is, you can write a class for connecting to the other database 
and set the Runon property for that class to Server. Then you can call that 
class from SalesFormLetter_PickingList.
 
Hope it will help you.
 
Regards,
Venkat

--- On Mon, 9/6/10, venkat raghavan pvraghavan...@yahoo.com wrote:


From: venkat raghavan pvraghavan...@yahoo.com
Subject: Re: [Axapta-Knowledge-Village] Error in Connecting to Another Database
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Monday, September 6, 2010, 9:17 AM


  








Dear Sai Sharan,
 
Make sure that Runon property is set to server.
 
Regards,
Venkat.

--- On Sat, 9/4/10, Sai Sharan saisharan@gmail.com wrote:


From: Sai Sharan saisharan@gmail.com
Subject: [Axapta-Knowledge-Village] Error in Connecting to Another Database
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Saturday, September 4, 2010, 6:30 PM


  

Hi all,
i had a senario where i need to save some data from Ax_Database to another 
database. I had Written a code for connecting to the Externa database.
It worked fine when i Executed my code in VPC(VirtualPC)., But when i Execute 
the same code in Client System it showed me a Problem
saying that
1.ODBC operation failed.Unable to log on to the database.
2.[Microsoft][SQL Native Client]Login timeout expired.
3.Object 'OdbcConnection' could not be created.

i wrote my code in SalesFormLetter Class and i caled from 
SalesFormLetter_PickingList.

waiting fr ur valuable sugessions










  

[Axapta-Knowledge-Village] Disaster recovery Plan for ax 2009

[prashant verma]

Hello people,
 
Can anyone help me with Disaster Recovery plan for Ax 2009, any kind of help 
will be appreciated.
 
 


 
Regards,
Prashant Verma
ILFS Technologies Limited.

[Axapta-Knowledge-Village] Re: Error when duplicating code

[bala_chivukula]

I got solution for the problem.
I deleted Usage data in tools--Options,then it worked.
 copy the customization from one company to 
 other means, I did some customization  for a company, and i copy  pasted the 
same code for another company. It worked fine for first company but not for 
second company. But, after resetting Usage Data, it worked fine for second 
company also.



Thank you for your reply.

--- In Axapta-Knowledge-Village@yahoogroups.com, Diwakar Reddy Atchi 
divakar_uni...@... wrote:

 Hey Bala
  
 I didn’t get what you meant by copy the customization from one company to 
 other; can you please elaborate the problem?
 If you trying to post a packing slip through X++ code, could you paste your 
 code 
 here? Also explain what you want to achieve.
  
 Thanks!
 
 
 
 
 
 From: bala_chivukula bala_chivuk...@...
 To: Axapta-Knowledge-Village@yahoogroups.com
 Sent: Tue, 31 August, 2010 5:29:22 AM
 Subject: [Axapta-Knowledge-Village] Error when duplicating code
 
   
 
 Am getting this error when am trying to copy the customization from one 
 company 
 to other. i can able to create packing slip in original company but am 
 getting 
 this error when am trying to create it in dulicated company.
 
 Cannot create a record in Sales order - Update (SalesParmUpdate).
 Insert operations are not allowed across companies. Please use changecompany 
 keyword to change the current company before inserting the record.
 
 Please help me...

Re: [Axapta-Knowledge-Village] Error in Connecting to Another Database

[Ashish Singh]

Hi Sai Sharan,

You can see the code in the standard DAX 2009 classes for your reference *
\Classes\SIGSigningProvider_SQLServer_Server*

Couple of suggestions for you, try to incorporate them.

a) Try to incroporate the Permission class.
b) Use the CCADO classes rather than ODBC classes for connecting to the
another database.
c) Be careful when supplying the login user name, make sure that the user
name that you are using to connect to other system should not be used more
than once.
d) Put the code inside the Try Catch statement, else you will not be able to
figure out as to why some error had happened at least that is the case for
the CCADO classes.

This is the sample code that i have posted from you. Here you can see that i
written the code inside the try catch block and see the last part where i
had done the exception handling this will give you detailed error message as
to why error is popping up. This code is consuming the CCADO classes.


void openConnection()
{
System.Exception clrException;
InteropPermissionpermission = new
InteropPermission(InteropKind::ClrInterop);
Str  localConnectionString;
;
try
{
permission.assert();
 // BP deviation documented
sqlConnection  = new
System.Data.SqlClient.SqlConnection(sqlConnectionString);
if(sqlConnection.get_State() != System.Data.ConnectionState::Open)
{
sqlConnection.Open();
}
else
{
info(Connection is already open !);
}
CodeAccessPermission::revertAssert();
}
catch(Exception::CLRError)
{
// BP deviation documented
clrException = CLRInterop::getLastException();
if (clrException != null)
{
clrException = clrException.get_InnerException();
if (clrException != null)
{
//store error - don't throw here
throw error(clrException.get_Message());
}
}
}
}
Hope this will help you.

Have a nice day.

Regards,
ashish singh
 **
*accenture*

On Sat, Sep 4, 2010 at 6:30 PM, Sai Sharan saisharan@gmail.com wrote:



 Hi all,
 i had a senario where i need to save some data from Ax_Database to another
 database. I had Written a code for connecting to the Externa database.
 It worked fine when i Executed my code in VPC(VirtualPC)., But when i
 Execute the same code in Client System it showed me a Problem
 saying that
 1.ODBC operation failed.Unable to log on to the database.
 2.[Microsoft][SQL Native Client]Login timeout expired.
 3.Object 'OdbcConnection' could not be created.

 i wrote my code in SalesFormLetter Class and i caled from
 SalesFormLetter_PickingList.

 waiting fr ur valuable sugessions

 

RE: [Axapta-Knowledge-Village] Error in Connecting to Another Database

[Harry Deshpande]

A quick note:

i wrote my code in SalesFormLetter Class and i caled from 
SalesFormLetter_PickingList.

The below try catch block will need to be at a place where ttslevel = 0

Regards

harry


From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Ashish Singh
Sent: Saturday, September 04, 2010 10:44 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Error in Connecting to Another Database


Hi Sai Sharan,

You can see the code in the standard DAX 2009 classes for your reference 
\Classes\SIGSigningProvider_SQLServer_Server

Couple of suggestions for you, try to incorporate them.

a) Try to incroporate the Permission class.
b) Use the CCADO classes rather than ODBC classes for connecting to the another 
database.
c) Be careful when supplying the login user name, make sure that the user name 
that you are using to connect to other system should not be used more than once.
d) Put the code inside the Try Catch statement, else you will not be able to 
figure out as to why some error had happened at least that is the case for the 
CCADO classes.

This is the sample code that i have posted from you. Here you can see that i 
written the code inside the try catch block and see the last part where i had 
done the exception handling this will give you detailed error message as to why 
error is popping up. This code is consuming the CCADO classes.


void openConnection()
{
System.Exception clrException;
InteropPermissionpermission = new 
InteropPermission(InteropKind::ClrInterop);
Str  localConnectionString;
;
try
{
permission.assert();
 // BP deviation documented
sqlConnection  = new 
System.Data.SqlClient.SqlConnection(sqlConnectionString);
if(sqlConnection.get_State() != System.Data.ConnectionState::Open)
{
sqlConnection.Open();
}
else
{
info(Connection is already open !);
}
CodeAccessPermission::revertAssert();
}
catch(Exception::CLRError)
{
// BP deviation documented
clrException = CLRInterop::getLastException();
if (clrException != null)
{
clrException = clrException.get_InnerException();
if (clrException != null)
{
//store error - don't throw here
throw error(clrException.get_Message());
}
}
}
}
Hope this will help you.

Have a nice day.

Regards,
ashish singh
 
accenture
On Sat, Sep 4, 2010 at 6:30 PM, Sai Sharan 
saisharan@gmail.commailto:saisharan@gmail.com wrote:


Hi all,
i had a senario where i need to save some data from Ax_Database to another 
database. I had Written a code for connecting to the Externa database.
It worked fine when i Executed my code in VPC(VirtualPC)., But when i Execute 
the same code in Client System it showed me a Problem
saying that
1.ODBC operation failed.Unable to log on to the database.
2.[Microsoft][SQL Native Client]Login timeout expired.
3.Object 'OdbcConnection' could not be created.

i wrote my code in SalesFormLetter Class and i caled from 
SalesFormLetter_PickingList.

waiting fr ur valuable sugessions

Re: [Axapta-Knowledge-Village] Re: Changing Units of Measure in AX2009

[visti Sethna]

Hi please ensure these are done with great care and will have an impact on
cost and quantity both. Forcefully updating the units of measure thought not
a best practise is possible and i have done the same through this code that
i have given you

On Wed, Aug 25, 2010 at 6:32 AM, george_spl 
george.burr...@solutionpartners.co.nz wrote:



 Thank you for this Vishtaspa, I'll see if we can put these instructions to
 good use.

 Feedback from Microsoft is that changing Units of Measure, for items with
 open and/or closed transactions, has been blocked in AX2009. Suggestion is
 that we rename item number with wrong Units of Measure, and enter the old
 code as a new item.

 I can see the reason for the tightening of the logic here, but clients do
 mourn some lost features - even features which we'd see as being a bit
 loose!

 George

 --- In 
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com,
 visti Sethna visti2...@... wrote:
 
  static void TEC_UpdateInvent(Args _args)
 
  {
 
  InventTableModule inventTableModule;
 
  inventTable inventTable;
 
  ;
 
  ttsbegin;
 
 
  select forupdate inventTable where inventTable.ItemId == 'XXX';
  inventTable.BOMUnitId = 'YYY';
  // instead of XXX enter item id
  // instead of YYY enter Unit id
 
  inventTable.doUpdate();
 
 
 
  while select forupdate inventTableModule where inventTableModule.ItemId
  == 'XXX'
 
  {
  inventTableModule.UnitId = 'YYY';
  // instead of XXX enter item id
  // instead of YYY enter Unit id
 
  inventTableModule.doUpdate();
 
  }
 
 
 
  ttscommit;
 
 
 
 
 
 
 
 
 
  }
 
 
  On Tue, Aug 24, 2010 at 6:51 AM, George Burrell 
  george.burr...@... wrote:
 
  
  
   Hello group
  
  
  
   In Version 3, and I think Version 4, it was always possible to change a
   Unit of Measure for an item, provided that there were no open
 transactions
   for the item.
  
  
  
   In AX2009, we are finding an obstacle here .. the error message is
 implying
   that there are open transactions when there are not.
  
  
  
   While this is an unusual thing for a client to be doing, I would still
 like
   to know more background if you have any.
  
   TIA
   George
  
  
  
 
 
 
  --
 
  *Thanks and Regards*

 
  **
 
  *Vishtaspa N. Sethna***
 
  *AX Functional Consultant**
 
  Tectura
  **Level 8, Vibgyor Towers
  C-62, G Block,
  **Bandra Kurla Complex,
  Bandra (E),
  Mumbai, Maharashtra, 400051
  INDIA**
  Board Tel (+91) 22 **40907152
  ** (+91) 22 4**0907153***
 
  *Fax Number (+91) 22 **40907070***
 
  *Mobile: (+91) 9833213532*
 
  *Email:
  vishtaspananu.set...@...
 https://owa.mytectura.com/owa/redir.aspx?C=c3ca3a2452714ee29cbcc3fbdee85241URL=mailto%3arajesh.degaonkar%40tectura.com
 
  ***
 
  *Web:
  www.tectura.com
 https://owa.mytectura.com/owa/redir.aspx?C=c3ca3a2452714ee29cbcc3fbdee85241URL=https%3a%2f%2fowa.mytectura.com%2fexchweb%2fbin%2fredir.asp%3fURL%3dhttp%3a%2f%2fwww.tectura.com%2f
 
  ***
 
 
 
  *Tectura | Your Business. Our Insight. *

 
  A worldwide provider of business consulting services.
  www.tectura.com
 https://owa.mytectura.com/owa/redir.aspx?C=c3ca3a2452714ee29cbcc3fbdee85241URL=http%3a%2f%2fwww.tectura.com%2f


 
  [image: Reseller_India_2010]
 
  [image: presidentsclubhorizontal_2010]
 

  




-- 

*Thanks and Regards*

**

*Vishtaspa N. Sethna***

*AX Functional Consultant**

Tectura
**Level 8, Vibgyor Towers
C-62, G Block,
**Bandra Kurla Complex,
Bandra (E),
Mumbai, Maharashtra, 400051
INDIA**
Board Tel   (+91) 22 **40907152
**   (+91) 22 4**0907153***

*Fax Number   (+91) 22 **40907070***

*Mobile:  (+91) 9833213532*

*Email:
vishtaspananu.set...@tectura.comhttps://owa.mytectura.com/owa/redir.aspx?C=c3ca3a2452714ee29cbcc3fbdee85241URL=mailto%3arajesh.degaonkar%40tectura.com
***

*Web:
www.tectura.comhttps://owa.mytectura.com/owa/redir.aspx?C=c3ca3a2452714ee29cbcc3fbdee85241URL=https%3a%2f%2fowa.mytectura.com%2fexchweb%2fbin%2fredir.asp%3fURL%3dhttp%3a%2f%2fwww.tectura.com%2f
***



*Tectura | Your Business. Our Insight. *

A worldwide provider of business consulting services.
www.tectura.comhttps://owa.mytectura.com/owa/redir.aspx?C=c3ca3a2452714ee29cbcc3fbdee85241URL=http%3a%2f%2fwww.tectura.com%2f

[image: Reseller_India_2010]

[image: presidentsclubhorizontal_2010]

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

[Harry Deshpande]

You have a problem :( I suppose _refId in the first statement and 
_reqTrans.RefId in the second statement is same? (at least for some 
transactions?)

You have a couple of options:


1.   Put the first delete statement in a separate transaction block. This 
has the side-effect that if your process crashes then the records will not be 
rolled back. But with master planning data consistency is not a big issue, if 
at all the process crashes (very rare) then the user will run it again any way.

2.   Create an isDeleted flag on xtrProdBreakDown table and instead of 
delete_from set this flag to true - in the second statement add one more 
predicate isDeleted = false and then find a suitable place to issue a delete 
statement i.e. delete_from where isDeleted = true.

Regards

harry

From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of thomas 'znal' 
ramdhan
Sent: Wednesday, September 01, 2010 6:21 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] delete_from vs loop delete



Hi Deshpande,

This is my code, I insert below code in Tables/ReqTrans/insertFromreqPO

delete_from xtsProdBreakDown
where   xtsProdbreakDown.Type == _BreakDownType
 (xtsProdBreakDown.RefId == _refId ||
 xtsProdBreakDown.LinkRefId == _refId);

..
...


select forUpdate * from xtsProdBreakDown
where   xtsProdBreakDown.RefId == _reqTrans.RefId
 xtsProdBreakDown.ItemId == _reqTrans.ItemId
 xtsProdBreakDown.RAFDate == UsedRAFDate
 xtsProdBreakDown.Shift == xtsShift.Shift
 xtsProdBreakDown.WrkCtrIdMachine == WrkCtrCapResLoop.WrkCtrId;


The meaning of my above code is I like to refresh the xtsProdBreakDown table 
every master planning is generated, so that I need to delete it all first, and 
then regenerate it again.
The most lock process that I found in SQL activity monitor is in delete codes. 
Do you have any suggestions ?


On Wed, Sep 1, 2010 at 9:55 PM, Harry Deshpande 
har...@microsoft.commailto:har...@microsoft.com wrote:

Are u doing anything in the delete method for your customized table? Can you 
post the code? Another way would to find out which statement is getting 
blocked, you will find a lot of information on the net. I had posted some info 
long time back 
http://www.systomatics.com/Blog/010ExpensiveQueries/010_ExpensiveQueries.htm 
not sure if this is still valid.

Regards

harry

From: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village@yahoogroups.com
 
[mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village@yahoogroups.com]
 On Behalf Of thomas 'znal' ramdhan
Sent: Wednesday, September 01, 2010 7:43 AM

To: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] delete_from vs loop delete



Hi Harry,

I didn't delete reqTrans records. It's my own customized table, but the process 
is inside the master planning scheduler.
On Wed, Sep 1, 2010 at 9:31 PM, Harry Deshpande 
har...@microsoft.commailto:har...@microsoft.com wrote:

Hi
From your reference to Batch helpers, it looks like you are trying to delete 
master planning records
I further suspect that you are trying to delete reqTrans. Delete_from will 
still give you a lock error since deleting one record of reqTrans triggers 
another delete statement on another record.
Say we have 2 record record no 1 and 2, which are related.
You execute delete_from statement which will
Delete record no 1 and
Delete record no 2
However, when record no 1 is deleted, it creates a delete statement on record 
no 2.
Now delete_from will try to delete record no 2 which is next in sequence and 
you will get the lock error.
You should you skipDataMethods and skipDeleteActions in such scenarios. 
However, you really need to know what you are doing :)
Seeing locks in activity monitor does not mean anything. What is the problem 
that you are facing (other than lock error while deleting)?
Regards
harry

From: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village@yahoogroups.com
 
[mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village@yahoogroups.com]
 On Behalf Of thomas 'znal' ramdhan
Sent: 01 September 2010 10:34

To: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] delete_from vs loop delete



Hi Burtt,

Thanks for brief explanation :)
I have declare all suitable index for my table, but sometimes still returns me 
lock error. If I use batch helpers, for sure I get more lock issue in activity 
monitor. If this is the case, is loop delete the righteous solution ?

Thanks and Regards,
Afin
On Wed, Sep 1, 2010 at 4:07 PM, Malcolm Burtt 
malcolm.bu...@touchstone.co.ukmailto:malcolm.bu...@touchstone.co.uk wrote:

Hi

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

[Zainal Arifin]

Hi Deshpande,

Thanks for the explanation and detail suggestion :)
The delete statement means I'd like to delete current record and all records
related to their parent, so that I used refId and linkRefId.
I've ever separated the delete refid and linkrefid, but it gave me more
locked error, so that I combined it in 1 query.
I'll try accommodate the second option in my behavior :)

Thanks and Regards,
Afin

On Thu, Sep 2, 2010 at 9:57 PM, Harry Deshpande har...@microsoft.comwrote:



  You have a problem L I suppose _refId in the first statement and
 _reqTrans.RefId in the second statement is same? (at least for some
 transactions?)



 You have a couple of options:



 1.   Put the first delete statement in a separate transaction block.
 This has the side-effect that if your process crashes then the records will
 not be rolled back. But with master planning data consistency is not a big
 issue, if at all the process crashes (very rare) then the user will run it
 again any way.

 2.   Create an isDeleted flag on xtrProdBreakDown table and instead of
 delete_from set this flag to true - in the second statement add one more
 predicate isDeleted = false and then find a suitable place to issue a delete
 statement i.e. delete_from where isDeleted = true.



 Regards



 harry



 *From:* Axapta-Knowledge-Village@yahoogroups.com [mailto:
 axapta-knowledge-vill...@yahoogroups.com] *On Behalf Of *thomas 'znal'
 ramdhan
 *Sent:* Wednesday, September 01, 2010 6:21 PM

 *To:* Axapta-Knowledge-Village@yahoogroups.com
 *Subject:* Re: [Axapta-Knowledge-Village] delete_from vs loop delete





 Hi Deshpande,

 This is my code, I insert below code in Tables/ReqTrans/insertFromreqPO

 *delete_from xtsProdBreakDown
 where   xtsProdbreakDown.Type == _BreakDownType
  (xtsProdBreakDown.RefId == _refId ||
  xtsProdBreakDown.LinkRefId == _refId);*

 ..
 ...
 

 *select forUpdate * from xtsProdBreakDown
 where   xtsProdBreakDown.RefId == _reqTrans.RefId
  xtsProdBreakDown.ItemId == _reqTrans.ItemId
  xtsProdBreakDown.RAFDate == UsedRAFDate
  xtsProdBreakDown.Shift == xtsShift.Shift
  xtsProdBreakDown.WrkCtrIdMachine ==
 WrkCtrCapResLoop.WrkCtrId;


 *The meaning of my above code is I like to refresh the xtsProdBreakDown
 table every master planning is generated, so that I need to delete it all
 first, and then regenerate it again.
 The most lock process that I found in SQL activity monitor is in delete
 codes. Do you have any suggestions ?


  On Wed, Sep 1, 2010 at 9:55 PM, Harry Deshpande har...@microsoft.com
 wrote:



 Are u doing anything in the delete method for your customized table? Can
 you post the code? Another way would to find out which statement is getting
 blocked, you will find a lot of information on the net. I had posted some
 info long time back
 http://www.systomatics.com/Blog/010ExpensiveQueries/010_ExpensiveQueries.htmnot
  sure if this is still valid.



 Regards



 harry



 *From:* Axapta-Knowledge-Village@yahoogroups.com [mailto:
 axapta-knowledge-vill...@yahoogroups.com] *On Behalf Of *thomas 'znal'
 ramdhan
 *Sent:* Wednesday, September 01, 2010 7:43 AM


 *To:* Axapta-Knowledge-Village@yahoogroups.com
 *Subject:* Re: [Axapta-Knowledge-Village] delete_from vs loop delete





 Hi Harry,

 I didn't delete reqTrans records. It's my own customized table, but the
 process is inside the master planning scheduler.

 On Wed, Sep 1, 2010 at 9:31 PM, Harry Deshpande har...@microsoft.com
 wrote:



 Hi

 From your reference to Batch helpers, it looks like you are trying to
 delete master planning records

 I further suspect that you are trying to delete reqTrans. Delete_from will
 still give you a lock error since deleting one record of reqTrans triggers
 another delete statement on another record.

 Say we have 2 record record no 1 and 2, which are related.

 You execute delete_from statement which will

 Delete record no 1 and

 Delete record no 2

 However, when record no 1 is deleted, it creates a delete statement on
 record no 2.

 Now delete_from will try to delete record no 2 which is next in sequence
 and you will get the lock error.

 You should you skipDataMethods and skipDeleteActions in such scenarios.
 However, you really need to know what you are doing J

 Seeing locks in activity monitor does not mean anything. What is the
 problem that you are facing (other than lock error while deleting)?

 Regards

 harry



 *From:* Axapta-Knowledge-Village@yahoogroups.com [mailto:
 axapta-knowledge-vill...@yahoogroups.com] *On Behalf Of *thomas 'znal'
 ramdhan
 *Sent:* 01 September 2010 10:34


 *To:* Axapta-Knowledge-Village@yahoogroups.com

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





 Hi Burtt,

 Thanks for brief explanation :)
 I have declare all suitable index for my table, but sometimes still returns
 me lock error. If I use

[Axapta-Knowledge-Village] Does SSRS supports Record level security

[gaurav pandey]

Hi Experts ,

We have implemented record level security in AX 2009, but when we are executing 
the reports using SSRS ,it bypass the record level security.

Is there any way to handle record level security in SSRS.


Thanks

Re: [Axapta-Knowledge-Village] Re:Physical Negative Inventory

[Ax Consultant]

i didnt get you...
what is Inventory valid first.
setup on Inventory Management SetupInventoryInventory Model group
FIFO….SETUP (tab) these two check boxes are marked Financial Negative 
inventory….Physical Negative inventory 
Because of which Negative Inventory is allowed.
But now we have decided to unmark these two options to avoid negative inventory 
any more.
When we try to unmark this option ,the attached script generates an error 
message.
i know Solution for this error is to bring all the –ve inventory to +ve value 
but it’s a very long process and we cannot afford to keep this option ON as 
this will bring more items with –ve values.
Hence we want,  if the error script could be commented/hided and system doesn’t 
generate any error and we can unmark these check boxes.
or if there could be any other quick solution for this???

--- On Tue, 8/31/10, George Burrell george.burr...@solutionpartners.co.nz 
wrote:


From: George Burrell george.burr...@solutionpartners.co.nz
Subject: [Axapta-Knowledge-Village] Re:Physical Negative Inventory
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Tuesday, August 31, 2010, 9:13 PM


  





Looks like you have to make Inventory valid first!  i.e. If you insist on 
positive inventory, make sure that all inventory is positive or zero.







  

Re: [Axapta-Knowledge-Village] Re:Physical Negative Inventory

[Ax Consultant]

i didnt get you...
what is Inventory valid first.
setup on Inventory Management SetupInventoryInventory Model group
FIFO….SETUP (tab) these two check boxes are marked Financial Negative 
inventory….Physical Negative inventory 
Because of which Negative Inventory is allowed.
But now we have decided to unmark these two options to avoid negative inventory 
any more.
When we try to unmark this option ,the attached script generates an error 
message.
i know Solution for this error is to bring all the –ve inventory to +ve value 
but it’s a very long process and we cannot afford to keep this option ON as 
this will bring more items with –ve values.
Hence we want,  if the error script could be commented/hided and system doesn’t 
generate any error and we can unmark these check boxes.
or if there could be any other quick solution for this???

--- On Tue, 8/31/10, George Burrell george.burr...@solutionpartners.co.nz 
wrote:


From: George Burrell george.burr...@solutionpartners.co.nz
Subject: [Axapta-Knowledge-Village] Re:Physical Negative Inventory
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Tuesday, August 31, 2010, 9:13 PM


  





Looks like you have to make Inventory valid first!  i.e. If you insist on 
positive inventory, make sure that all inventory is positive or zero.







  

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

[Malcolm Burtt]

Hi

The difference between the two approaches is in the speed of execution.

Assuming that the tables delete() method has not been overridden and that there 
is no database logging of deletes for the table then delete_from x++ code 
will generate a single database round trip which will delete all of the records 
matched by the where clause. The looping approach will issue one database round 
trip for each record to be deleted in addition to the initial select and is, 
consequently, slower than the delete_from approach.

It's worth noting that delete_from will automatically revert to a looped 
approach if the table's delete() method has been overridden or AX has been 
configured to log deletes for the table. This can be avoided by call the 
table's skipDataMethod() and skipDatabaseLog() passing true as the argument 
to each of these calls but you can only do that if you are sure that the code 
in the delete() method isn't needed in this instance and that its okay to not 
log the delete.

You might have seen table locks with delete_from if your where clause has no 
viable index. In such cases the database has no choice but to lock the whole 
table while it deletes the rows.

My advice: use delete_from wherever you can but, as with all database access, 
make sure you have suitable indexes.

Regards


Malcolm Burtt
Touchstone Group
People - Partnership - Solutions



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



Dear all,

I'd like to ask about delete issue in AX.
AX has 2 way to delete records by using 'delete_from' or below code

while select forUpdate * from tableA
{
tableA.doDelete();
}

Which one do you prefer to delete some records from both above code ?

Sometimes, I found locked table if I use delete_from code.

Thanks and Regards,
Afin

--
ne faites pas une limite pour votre competence
-
bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
-
non faccia un limite per la vostra abilita
-
--(-@

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

[thomas 'znal' ramdhan]

Hi Burtt,

Thanks for brief explanation :)
I have declare all suitable index for my table, but sometimes still returns
me lock error. If I use batch helpers, for sure I get more lock issue in
activity monitor. If this is the case, is loop delete the righteous solution
?

Thanks and Regards,
Afin

On Wed, Sep 1, 2010 at 4:07 PM, Malcolm Burtt 
malcolm.bu...@touchstone.co.uk wrote:



  Hi



 The difference between the two approaches is in the speed of execution.



 Assuming that the tables delete() method has not been overridden and that
 there is no database logging of deletes for the table then “delete_from” x++
 code will generate a single database round trip which will delete all of the
 records matched by the where clause. The looping approach will issue one
 database round trip for each record to be deleted in addition to the initial
 select and is, consequently, slower than the “delete_from” approach.



 It’s worth noting that “delete_from” will automatically revert to a looped
 approach if the table’s delete() method has been overridden or AX has been
 configured to log deletes for the table. This can be avoided by call the
 table’s skipDataMethod() and skipDatabaseLog() passing “true” as the
 argument to each of these calls but you can only do that if you are sure
 that the code in the delete() method isn’t needed in this instance and that
 its okay to not log the delete.



 You might have seen table locks with “delete_from” if your where clause has
 no viable index. In such cases the database has no choice but to lock the
 whole table while it deletes the rows.



 My advice: use “delete_from” wherever you can but, as with all database
 access, make sure you have suitable indexes.



 Regards





 Malcolm Burtt

 Touchstone Group

 People - Partnership - Solutions







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





 Dear all,

 I'd like to ask about delete issue in AX.
 AX has 2 way to delete records by using *'delete_from'* or below code

 *while select forUpdate * from tableA
 {
 tableA.doDelete();
 }

 *Which one do you prefer to delete some records from both above code ?

 Sometimes, I found locked table if I use *delete_from* code.

 Thanks and Regards,
 Afin
 *
 *--
 ne faites pas une limite pour votre competence
 -
 bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
 -
 non faccia un limite per la vostra abilita
 -
 --(-@

   




-- 
ne faites pas une limite pour votre competence
-
bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
-
non faccia un limite per la vostra abilita
-
--(-@

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

[Marko Salonen]

try-catch deadlock and retry?

On 1 September 2010 10:33, thomas 'znal' ramdhan thomasramd...@gmail.comwrote:



 Hi Burtt,

 Thanks for brief explanation :)
 I have declare all suitable index for my table, but sometimes still returns
 me lock error. If I use batch helpers, for sure I get more lock issue in
 activity monitor. If this is the case, is loop delete the righteous solution
 ?

 Thanks and Regards,
 Afin

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

[Malcolm Burtt]

Hi

Ultimately, either mechanism will result in locks being held on the affected 
records until you commit the transaction. In fact, because the looped approach 
takes longer to execute the locks will actually be held longer using this 
approach.

Malcolm

From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of thomas 'znal' 
ramdhan
Sent: 01 September 2010 10:34
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] delete_from vs loop delete



Hi Burtt,

Thanks for brief explanation :)
I have declare all suitable index for my table, but sometimes still returns me 
lock error. If I use batch helpers, for sure I get more lock issue in activity 
monitor. If this is the case, is loop delete the righteous solution ?

Thanks and Regards,
Afin
On Wed, Sep 1, 2010 at 4:07 PM, Malcolm Burtt 
malcolm.bu...@touchstone.co.ukmailto:malcolm.bu...@touchstone.co.uk wrote:

Hi

The difference between the two approaches is in the speed of execution.

Assuming that the tables delete() method has not been overridden and that there 
is no database logging of deletes for the table then delete_from x++ code 
will generate a single database round trip which will delete all of the records 
matched by the where clause. The looping approach will issue one database round 
trip for each record to be deleted in addition to the initial select and is, 
consequently, slower than the delete_from approach.

It's worth noting that delete_from will automatically revert to a looped 
approach if the table's delete() method has been overridden or AX has been 
configured to log deletes for the table. This can be avoided by call the 
table's skipDataMethod() and skipDatabaseLog() passing true as the argument 
to each of these calls but you can only do that if you are sure that the code 
in the delete() method isn't needed in this instance and that its okay to not 
log the delete.

You might have seen table locks with delete_from if your where clause has no 
viable index. In such cases the database has no choice but to lock the whole 
table while it deletes the rows.

My advice: use delete_from wherever you can but, as with all database access, 
make sure you have suitable indexes.

Regards


Malcolm Burtt
Touchstone Group
People - Partnership - Solutions



From: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village@yahoogroups.com
 
[mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village@yahoogroups.com]
 On Behalf Of thomas 'znal' ramdhan
Sent: 01 September 2010 06:20
To: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] delete_from vs loop delete



Dear all,

I'd like to ask about delete issue in AX.
AX has 2 way to delete records by using 'delete_from' or below code

while select forUpdate * from tableA
{
tableA.doDelete();
}

Which one do you prefer to delete some records from both above code ?

Sometimes, I found locked table if I use delete_from code.

Thanks and Regards,
Afin

--
ne faites pas une limite pour votre competence
-
bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
-
non faccia un limite per la vostra abilita
-
--(-@



--
ne faites pas une limite pour votre competence
-
bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
-
non faccia un limite per la vostra abilita
-
--(-@

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

[Harry Deshpande]

Are u doing anything in the delete method for your customized table? Can you 
post the code? Another way would to find out which statement is getting 
blocked, you will find a lot of information on the net. I had posted some info 
long time back 
http://www.systomatics.com/Blog/010ExpensiveQueries/010_ExpensiveQueries.htm 
not sure if this is still valid.

Regards

harry

From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of thomas 'znal' 
ramdhan
Sent: Wednesday, September 01, 2010 7:43 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] delete_from vs loop delete



Hi Harry,

I didn't delete reqTrans records. It's my own customized table, but the process 
is inside the master planning scheduler.
On Wed, Sep 1, 2010 at 9:31 PM, Harry Deshpande 
har...@microsoft.commailto:har...@microsoft.com wrote:

Hi
From your reference to Batch helpers, it looks like you are trying to delete 
master planning records
I further suspect that you are trying to delete reqTrans. Delete_from will 
still give you a lock error since deleting one record of reqTrans triggers 
another delete statement on another record.
Say we have 2 record record no 1 and 2, which are related.
You execute delete_from statement which will
Delete record no 1 and
Delete record no 2
However, when record no 1 is deleted, it creates a delete statement on record 
no 2.
Now delete_from will try to delete record no 2 which is next in sequence and 
you will get the lock error.
You should you skipDataMethods and skipDeleteActions in such scenarios. 
However, you really need to know what you are doing :)
Seeing locks in activity monitor does not mean anything. What is the problem 
that you are facing (other than lock error while deleting)?
Regards
harry

From: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village@yahoogroups.com
 
[mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village@yahoogroups.com]
 On Behalf Of thomas 'znal' ramdhan
Sent: 01 September 2010 10:34

To: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] delete_from vs loop delete



Hi Burtt,

Thanks for brief explanation :)
I have declare all suitable index for my table, but sometimes still returns me 
lock error. If I use batch helpers, for sure I get more lock issue in activity 
monitor. If this is the case, is loop delete the righteous solution ?

Thanks and Regards,
Afin
On Wed, Sep 1, 2010 at 4:07 PM, Malcolm Burtt 
malcolm.bu...@touchstone.co.ukmailto:malcolm.bu...@touchstone.co.uk wrote:

Hi

The difference between the two approaches is in the speed of execution.

Assuming that the tables delete() method has not been overridden and that there 
is no database logging of deletes for the table then delete_from x++ code 
will generate a single database round trip which will delete all of the records 
matched by the where clause. The looping approach will issue one database round 
trip for each record to be deleted in addition to the initial select and is, 
consequently, slower than the delete_from approach.

It's worth noting that delete_from will automatically revert to a looped 
approach if the table's delete() method has been overridden or AX has been 
configured to log deletes for the table. This can be avoided by call the 
table's skipDataMethod() and skipDatabaseLog() passing true as the argument 
to each of these calls but you can only do that if you are sure that the code 
in the delete() method isn't needed in this instance and that its okay to not 
log the delete.

You might have seen table locks with delete_from if your where clause has no 
viable index. In such cases the database has no choice but to lock the whole 
table while it deletes the rows.

My advice: use delete_from wherever you can but, as with all database access, 
make sure you have suitable indexes.

Regards


Malcolm Burtt
Touchstone Group
People - Partnership - Solutions



From: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village@yahoogroups.com
 
[mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village@yahoogroups.com]
 On Behalf Of thomas 'znal' ramdhan
Sent: 01 September 2010 06:20
To: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] delete_from vs loop delete



Dear all,

I'd like to ask about delete issue in AX.
AX has 2 way to delete records by using 'delete_from' or below code

while select forUpdate * from tableA
{
tableA.doDelete();
}

Which one do you prefer to delete some records from both above code ?

Sometimes, I found locked table if I use delete_from code.

Thanks and Regards,
Afin

--
ne faites pas une limite pour votre competence
-
bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit

[Axapta-Knowledge-Village] decimal value in strfmt

[thomas 'znal' ramdhan]

Dear all,

I'd like to ask about strfmt function, how could I declare more than 2
decimal digit in strfmt ?
Let's say, I have a value like below
2.98776584

I'd like to show them all in strfmt function. Actually strfmt only show 2
decimal digit.

THanks and Regards,
Afin

-- 
ne faites pas une limite pour votre competence
-
bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
-
non faccia un limite per la vostra abilita
-
--(-@

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

[bernd.seyfried]

Hi Afin,

I have had the same Problem some time ago.
In the msdn-library i have found a workaround to solve this Problem.

http://msdn.microsoft.com/en-us/library/aa589727.aspx

There will be an example how to format a real type with more than two digits.

With best regards,
Bernd

--- In Axapta-Knowledge-Village@yahoogroups.com, thomas 'znal' ramdhan 
thomasramd...@... wrote:

 Dear all,
 
 I'd like to ask about strfmt function, how could I declare more than 2
 decimal digit in strfmt ?
 Let's say, I have a value like below
 2.98776584
 
 I'd like to show them all in strfmt function. Actually strfmt only show 2
 decimal digit.
 
 THanks and Regards,
 Afin
 
 -- 
 ne faites pas une limite pour votre competence
 -
 bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
 -
 non faccia un limite per la vostra abilita
 -
 --(-@

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

[thomas 'znal' ramdhan]

Hi Seyfried,

thanks for replying my email :)
By the way, do the function need the special permission ?
Actually I got this error, Request for the permission of type
'InteropPermission' failed. I'm using it in programmable section of report
designer.

Thanks and regards,
Afin

On Mon, Aug 30, 2010 at 1:50 PM, bernd.seyfried 
bernd.seyfr...@segmueller.de wrote:



 Hi Afin,

 I have had the same Problem some time ago.
 In the msdn-library i have found a workaround to solve this Problem.

 http://msdn.microsoft.com/en-us/library/aa589727.aspx

 There will be an example how to format a real type with more than two
 digits.

 With best regards,
 Bernd


 --- In 
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com,
 thomas 'znal' ramdhan thomasramd...@... wrote:
 
  Dear all,
 
  I'd like to ask about strfmt function, how could I declare more than 2
  decimal digit in strfmt ?
  Let's say, I have a value like below
  2.98776584
 
  I'd like to show them all in strfmt function. Actually strfmt only show 2
  decimal digit.
 
  THanks and Regards,
  Afin
 
  --
  ne faites pas une limite pour votre competence
  --
  bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
  --
  non faccia un limite per la vostra abilita
  --
  --(-@
 

  




-- 
ne faites pas une limite pour votre competence
-
bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
-
non faccia un limite per la vostra abilita
-
--(-@

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

[bernd.seyfried]

Hi Afin,
I havn't even got any problem using this Function. 
Which AX-Version do you user. We use Microsoft Dynamics AX 2009. 
With best regards,
Bernd


--- In Axapta-Knowledge-Village@yahoogroups.com, thomas 'znal' ramdhan 
thomasramd...@... wrote:

 Hi Seyfried,
 
 thanks for replying my email :)
 By the way, do the function need the special permission ?
 Actually I got this error, Request for the permission of type
 'InteropPermission' failed. I'm using it in programmable section of report
 designer.
 
 Thanks and regards,
 Afin
 
 On Mon, Aug 30, 2010 at 1:50 PM, bernd.seyfried 
 bernd.seyfr...@... wrote:
 
 
 
  Hi Afin,
 
  I have had the same Problem some time ago.
  In the msdn-library i have found a workaround to solve this Problem.
 
  http://msdn.microsoft.com/en-us/library/aa589727.aspx
 
  There will be an example how to format a real type with more than two
  digits.
 
  With best regards,
  Bernd
 
 
  --- In 
  Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com,
  thomas 'znal' ramdhan thomasramdhan@ wrote:
  
   Dear all,
  
   I'd like to ask about strfmt function, how could I declare more than 2
   decimal digit in strfmt ?
   Let's say, I have a value like below
   2.98776584
  
   I'd like to show them all in strfmt function. Actually strfmt only show 2
   decimal digit.
  
   THanks and Regards,
   Afin
  
   --
   ne faites pas une limite pour votre competence
   --
   bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
   --
   non faccia un limite per la vostra abilita
   --
   --(-@
  
 
   
 
 
 
 
 -- 
 ne faites pas une limite pour votre competence
 -
 bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
 -
 non faccia un limite per la vostra abilita
 -
 --(-@

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

[thomas 'znal' ramdhan]

Hi Seyfried,

I'm using AX 2009.
Where do you use this function ?
I'm using in display method of programmable section report and returns me
that error.

On Mon, Aug 30, 2010 at 4:14 PM, bernd.seyfried 
bernd.seyfr...@segmueller.de wrote:



 Hi Afin,
 I havn't even got any problem using this Function.
 Which AX-Version do you user. We use Microsoft Dynamics AX 2009.
 With best regards,
 Bernd

 --- In 
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com,
 thomas 'znal' ramdhan thomasramd...@... wrote:
 
  Hi Seyfried,
 
  thanks for replying my email :)
  By the way, do the function need the special permission ?
  Actually I got this error, Request for the permission of type
  'InteropPermission' failed. I'm using it in programmable section of
 report
  designer.
 
  Thanks and regards,
  Afin
 
  On Mon, Aug 30, 2010 at 1:50 PM, bernd.seyfried 
  bernd.seyfr...@... wrote:
 
  
  
   Hi Afin,
  
   I have had the same Problem some time ago.
   In the msdn-library i have found a workaround to solve this Problem.
  
   http://msdn.microsoft.com/en-us/library/aa589727.aspx
  
   There will be an example how to format a real type with more than two
   digits.
  
   With best regards,
   Bernd
  
  
   --- In 
   Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 Axapta-Knowledge-Village%40yahoogroups.com,

   thomas 'znal' ramdhan thomasramdhan@ wrote:
   
Dear all,
   
I'd like to ask about strfmt function, how could I declare more than
 2
decimal digit in strfmt ?
Let's say, I have a value like below
2.98776584
   
I'd like to show them all in strfmt function. Actually strfmt only
 show 2
decimal digit.
   
THanks and Regards,
Afin
   
--
ne faites pas une limite pour votre competence
--
bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
--
non faccia un limite per la vostra abilita
--
--(-@
   
  
  
  
 
 
 
  --
  ne faites pas une limite pour votre competence
  --
  bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
  --
  non faccia un limite per la vostra abilita
  --
  --(-@
 

  




-- 
ne faites pas une limite pour votre competence
-
bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
-
non faccia un limite per la vostra abilita
-
--(-@

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

[Anitha Santosh]

Hi..

Chk if this link would help you..

http://dynamics-ax-live.blogspot.com/2009/09/error-request-for-permission-of-type.html



On Mon, Aug 30, 2010 at 3:38 PM, thomas 'znal' ramdhan 
thomasramd...@gmail.com wrote:



 Hi Seyfried,

 I'm using AX 2009.
 Where do you use this function ?
 I'm using in display method of programmable section report and returns me
 that error.


 On Mon, Aug 30, 2010 at 4:14 PM, bernd.seyfried 
 bernd.seyfr...@segmueller.de wrote:



 Hi Afin,
 I havn't even got any problem using this Function.
 Which AX-Version do you user. We use Microsoft Dynamics AX 2009.
 With best regards,
 Bernd

 --- In 
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com,
 thomas 'znal' ramdhan thomasramd...@... wrote:
 
  Hi Seyfried,
 
  thanks for replying my email :)
  By the way, do the function need the special permission ?
  Actually I got this error, Request for the permission of type
  'InteropPermission' failed. I'm using it in programmable section of
 report
  designer.
 
  Thanks and regards,
  Afin
 
  On Mon, Aug 30, 2010 at 1:50 PM, bernd.seyfried 
  bernd.seyfr...@... wrote:
 
  
  
   Hi Afin,
  
   I have had the same Problem some time ago.
   In the msdn-library i have found a workaround to solve this Problem.
  
   http://msdn.microsoft.com/en-us/library/aa589727.aspx
  
   There will be an example how to format a real type with more than two
   digits.
  
   With best regards,
   Bernd
  
  
   --- In 
   Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 Axapta-Knowledge-Village%40yahoogroups.com,

   thomas 'znal' ramdhan thomasramdhan@ wrote:
   
Dear all,
   
I'd like to ask about strfmt function, how could I declare more than
 2
decimal digit in strfmt ?
Let's say, I have a value like below
2.98776584
   
I'd like to show them all in strfmt function. Actually strfmt only
 show 2
decimal digit.
   
THanks and Regards,
Afin
   
--
ne faites pas une limite pour votre competence
--
bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
--
non faccia un limite per la vostra abilita
--
--(-@
   
  
  
  
 
 
 
  --
  ne faites pas une limite pour votre competence
  --
  bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
  --
  non faccia un limite per la vostra abilita
  --
  --(-@
 




 --
 ne faites pas une limite pour votre competence
 -
 bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
 -
 non faccia un limite per la vostra abilita
 -
 --(-@

 




-- 
Regards,
AnithaSantosh

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

[thomas 'znal' ramdhan]

Thanks Anitha :) it worked ...

On Mon, Aug 30, 2010 at 5:20 PM, Anitha Santosh mail2eani...@gmail.comwrote:



 Hi..

 Chk if this link would help you..


 http://dynamics-ax-live.blogspot.com/2009/09/error-request-for-permission-of-type.html



 On Mon, Aug 30, 2010 at 3:38 PM, thomas 'znal' ramdhan 
 thomasramd...@gmail.com wrote:



 Hi Seyfried,

 I'm using AX 2009.
 Where do you use this function ?
 I'm using in display method of programmable section report and returns me
 that error.


 On Mon, Aug 30, 2010 at 4:14 PM, bernd.seyfried 
 bernd.seyfr...@segmueller.de wrote:



 Hi Afin,
 I havn't even got any problem using this Function.
 Which AX-Version do you user. We use Microsoft Dynamics AX 2009.
 With best regards,
 Bernd

 --- In 
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com,
 thomas 'znal' ramdhan thomasramd...@... wrote:
 
  Hi Seyfried,
 
  thanks for replying my email :)
  By the way, do the function need the special permission ?
  Actually I got this error, Request for the permission of type
  'InteropPermission' failed. I'm using it in programmable section of
 report
  designer.
 
  Thanks and regards,
  Afin
 
  On Mon, Aug 30, 2010 at 1:50 PM, bernd.seyfried 
  bernd.seyfr...@... wrote:
 
  
  
   Hi Afin,
  
   I have had the same Problem some time ago.
   In the msdn-library i have found a workaround to solve this Problem.
  
   http://msdn.microsoft.com/en-us/library/aa589727.aspx
  
   There will be an example how to format a real type with more than two
   digits.
  
   With best regards,
   Bernd
  
  
   --- In 
   Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 Axapta-Knowledge-Village%40yahoogroups.com,

   thomas 'znal' ramdhan thomasramdhan@ wrote:
   
Dear all,
   
I'd like to ask about strfmt function, how could I declare more
 than 2
decimal digit in strfmt ?
Let's say, I have a value like below
2.98776584
   
I'd like to show them all in strfmt function. Actually strfmt only
 show 2
decimal digit.
   
THanks and Regards,
Afin
   
--
ne faites pas une limite pour votre competence
--
bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
--
non faccia un limite per la vostra abilita
--
--(-@
   
  
  
  
 
 
 
  --
  ne faites pas une limite pour votre competence
  --
  bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
  --
  non faccia un limite per la vostra abilita
  --
  --(-@
 




 --
 ne faites pas une limite pour votre competence
 -
 bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
 -
 non faccia un limite per la vostra abilita
 -
 --(-@




 --
 Regards,
 AnithaSantosh
  




-- 
ne faites pas une limite pour votre competence
-
bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
-
non faccia un limite per la vostra abilita
-
--(-@

Re: [Axapta-Knowledge-Village] Re: Changing Units of Measure in AX2009

[mni_col]

Hi
it's not possible if inventtrans exists for item .
\Data Dictionary\Tables\InventTableModule\Methods\validateField.

We miss this feature too!

Best regards
Michael 


From: g4ernev 
Sent: Wednesday, August 25, 2010 7:45 PM
To: Axapta-Knowledge-Village@yahoogroups.com 
Subject: [Axapta-Knowledge-Village] Re: Changing Units of Measure in AX2009


  
Hi George,
Have you tried to close all transactions for the item and then get the 
inventory on-hand to zero with a PL journal or counting journal? We do this 
when we have to update the dimension group for certain items. When you are done 
with the changes, you simple get the same quantity back into the inventory 
using the same journal type but with the new UOM.

GeorgeC

--- In Axapta-Knowledge-Village@yahoogroups.com, george_spl 
george.burr...@... wrote:

 Thank you for this Vishtaspa, I'll see if we can put these instructions to 
 good use.
 
 Feedback from Microsoft is that changing Units of Measure, for items with 
 open and/or closed transactions, has been blocked in AX2009. Suggestion is 
 that we rename item number with wrong Units of Measure, and enter the old 
 code as a new item. 
 
 I can see the reason for the tightening of the logic here, but clients do 
 mourn some lost features - even features which we'd see as being a bit loose! 
 
 George 
 

[Axapta-Knowledge-Village] Re: Changing Units of Measure in AX2009

[George Burrell]

Thank you for this Michael.  Have you considered bringing the feature
back through modifying this class?  I suspect it might be prudent to
follow the lead of Microsoft on this occasion.

 

George B

Re: [Axapta-Knowledge-Village] Purchase Req Workflow Configuration

[TAHIR AZIZ]

One way to handle this is to create a sub-workflow within a workflow.

In the first workflow, set completion to automatic completion and set approval 
to the Manager. 

Then in the second one, set proper completion step and proper approval (if 
required).

Apart from this, you will require customization.
 

Tahir Aziz, 
 





From: Dishant Singhal singhal_dish...@yahoo.com
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Mon, August 23, 2010 9:15:07 AM
Subject: Re: [Axapta-Knowledge-Village] Purchase Req Workflow Configuration

  
Post Submission by the requisitioner, this should get assigned to the manager 
for approval. After this approval, this can go to the Purchaser for RFQ etc.

Hope this is clear

Thanks, Dishant





From: Anitha Santosh mail2eani...@gmail.com
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Mon, August 23, 2010 4:59:27 PM
Subject: Re: [Axapta-Knowledge-Village] Purchase Req Workflow Configuration

  
Hi,

Could you give me more info ??

@ which stage you want the assignement to happen in Purch Req ??


On Mon, Aug 23, 2010 at 4:52 PM, Dishant Singhal singhal_dish...@yahoo.com 
wrote:

  
Hi

I understand that the DAX 2009 Purchase requsition workflow when submitted 
goes 

to the Purchase Department for processing which can then convert it to the RFQ 
before completing the same.

Is it possible to set the same to when submited, this workflow goes to the 
manager defined in the assignment, who can approve or reject this. If 
approved, 

then is workflow goes to the Purchase department who can then convert it to 
RFQ 

after the manager has approved / completed the same in the earlier stage.

can this be set in the Standard Ax 2009 or would need to customize the 
workflow 

template.

Any help / suggestions would be appreciated.

Thanks, Dishant




-- 
Regards,
AnithaSantosh

[Axapta-Knowledge-Village] Master planning error log

[Henry Charles]

Hi all,

Have anyone ever encountered this error message when running master planning:
Could not acquire lock on scheduling engine ??

I wonder why does this error showed up. I'm running master planning using batch 
helper. i'm getting this error quite often, but i don't know where the fault 
was.. please help me explain this error. thanks..

Regards,
Henry

[Axapta-Knowledge-Village] Could not acquire lock on scheduling engine in master planning log

[henrycharles8888]

Hi all,

Could anyone explained this error to me:
Could not acquire lock on scheduling engine. I'm getting this error when 
running master planning.. 

Is there a table which i must unlock manually to run master planning? please 
give me your thought. I will appreciate it. Thanks

Regards
Henry

RE: [Axapta-Knowledge-Village] Master planning error log

[Harry Deshpande]

Open label editor - paste the error message - find label id - search for the 
label id in AOT.

Finite scheduling must be run in parallel.  (Master planning engine has been 
optimized to block other scheduling threads for as minimum time as possible).

In your case it looks like one of the threads is taking too long to schedule a 
production order


1.   Search for master planning white paper on partner net

2.   Take an item trace and try to figure out which item is the culprit

Regards

harry


From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Henry Charles
Sent: Saturday, August 28, 2010 9:34 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Master planning error log


Hi all,

Have anyone ever encountered this error message when running master planning:
Could not acquire lock on scheduling engine ??

I wonder why does this error showed up. I'm running master planning using batch 
helper. i'm getting this error quite often, but i don't know where the fault 
was.. please help me explain this error. thanks..

Regards,
Henry

[Axapta-Knowledge-Village] New objects moving to vap layer automatically

[satya k]

We are using Ax 3.0 with oracle 9i database and project has gone live just few 
months back. We are having 3 environment (development, testing and production) 
and all the development has done in VAR layer. Recently we are facing the 
problem in development application where development work is saved into VAP 
layer even though we are working on VAR (its already set in the Axapta 
configuration utility). 

When we try to delete this VAP development then system is throwing error and 
not allow to delete the object. 

 I have read in the axapta help file where the range has been mentioned for the 
VAR layer development (30001-3). I have created one table in this 
application and its created with the id no (31728) and subsequently the next no 
is assigned to the object Map. When i tried to create any Form, Report and view 
then system saved these objects into VAP layer. We have to release some new 
functionality therefore the same would require the development and currently 
our development application is down due to this issue.

[Axapta-Knowledge-Village] Re: Inventory Transfer Journal

[CTV]

Check in site 2, you have already sold item ABC - 5Pcs each for 2 sales orders, 
with physical negative inventory enabled.  System is settling the posted 
inventory transactions with physical negative inventory.

Revert back, if not the case.

CTV

--- In Axapta-Knowledge-Village@yahoogroups.com, Ax Consultant 
ax_consult...@... wrote:

 I have a transaction in Inventory Transfer Journal in which I enter a 
 transfer like:
 item from site Qtyto site  
 ABC   1 10  2
 
 when i post this transaction, system post this like:
 
 item  Qtyto site  Issue Status
 ABC   -5  1  Sold
 ABC   -5  1  Sold
 ABC   10 2  Purchased
 
 why system is splitting this transaction to 5 ,5 . All dimensions and lot 
 number are same for one complete transaction but why system is splitting this 
 to several lines.
 
 Pleas Help...!!

[Axapta-Knowledge-Village] Inventory Transfer Journal

[Ax Consultant]

I have a transaction in Inventory Transfer Journal in which I enter a transfer 
like:
item from site Qtyto site  
ABC   1 10  2

when i post this transaction, system post this like:

item  Qtyto site  Issue Status
ABC   -5  1  Sold
ABC   -5  1  Sold
ABC   10 2  Purchased

why system is splitting this transaction to 5 ,5 . All dimensions and lot 
number are same for one complete transaction but why system is splitting this 
to several lines.

Pleas Help...!!


  

[Axapta-Knowledge-Village] PDF Attachments to Outlook 2003 Messages

[george_spl]

Hello again

Some of our customers are receiving attachments called winmail.dat, others 
are reporting no attachments at all.  Most are receiving the PDFs as 
attachments - research so far suggests that these lucky customers are the ones 
most like to be using Microsoft Outlook as well.

Version of kernel: 5.0.1500.2116
Version of application:  5.0.1500.2116

i.e. AX2009 with Hotfix Rollup 4 

Version of Microsoft Outlook 2003:  Service Pack 3

Some Internet surfing says that we should not be using RTFs at any stage - but 
we are twice nominating HTML as our format in Microsoft Outlook.

I have checked properties of our attachments in Adobe- True Type (CID), Arial, 
Identity-H.  While these are not the same in detail as documents in Version 3 
Axapta, they are common enough.

If anyone has good advice or a link to offer on this topic, I'd be pleased.  
This is a very common issue - sadly it has occurred in AX2009 not Axapta 
Version 3 for us!

TIA 
George 

[Axapta-Knowledge-Village] Re: Changing Units of Measure in AX2009

[g4ernev]

Hi George,
Have you tried to close all transactions for the item and then get the 
inventory on-hand to zero with a PL journal or counting journal? We do this 
when we have to update the dimension group for certain items. When you are done 
with the changes, you simple get the same quantity back into the inventory 
using the same journal type but with the new UOM.

GeorgeC

--- In Axapta-Knowledge-Village@yahoogroups.com, george_spl 
george.burr...@... wrote:

 Thank you for this Vishtaspa, I'll see if we can put these instructions to 
 good use.
 
 Feedback from Microsoft is that changing Units of Measure, for items with 
 open and/or closed transactions, has been blocked in AX2009.  Suggestion is 
 that we rename item number with wrong Units of Measure, and enter the old 
 code as a new item.  
 
 I can see the reason for the tightening of the logic here, but clients do 
 mourn some lost features - even features which we'd see as being a bit loose! 
   
 
 George 
 

[Axapta-Knowledge-Village] lock handle in Axapta

[thomas 'znal' ramdhan]

Dear all,

I have customized number sequence in Axapta to fulfill the reset number in
every month functionality. So that the number sequence function will call my

method. I have a problem with getting the newest number. Sometimes 2 user
get the same number when they created a new transaction.
Has AX select statement already fulfill nolock functionality just like as
sql server query ?
Yesterday I got so many locked transaction in sql activity monitor. Most of
the locked transaction came from number sequence. Does it relate to get the
same number problem ?

I'm using below code to select my number sequence table.

select firstonly * from xtsNumSeq index hint KeyIdx where
xtsNumSeq.NumberSequenceId == _numSeqId  xtsNumSeq.Month == _month;

Please advise how to prevent that locked ?
Actually in 1.5 years, the locked problem happens just one. I don't know
whether this lock relate to licensed user since my client has upgraded their

license to 150 users.

Thanks and Regards,

Afin


-- 
ne faites pas une limite pour votre competence
-
bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
-
non faccia un limite per la vostra abilita
-
--(-@

[Axapta-Knowledge-Village] Displayfield in tablebrowser

[bernd.seyfried]

Hi!

I have to modify an existing Table. In this table is the field ItemId. I want 
to create a Field like a Displayfield to show the ItemName to the the user. 
This Displayfiel should only be visible in the table browser, not in the 
related Form.

Is this possible to implement in AX?

With best regards,
Bernd

[Axapta-Knowledge-Village] AX 2009 Licensing Editions dounbts?

[kardo_ax]

Dear All,

I have a doubt regarding the AX 2009 licensing versions.

A) In QRG, they are talking about the following:

1)Business Essentials.2)Advanced Management.3)Advanced Management 
Enterprise.4)Additional Components.

B)While in the Excel pricing sheet we can find:

1)Business Ready Licensing - Business Essentials Edition.
2)Business Ready Licensing - Advanced Management Edition.
3)Module Based Licensing - Enterprise.

i)The doubt or confusion is about  Advanced Management Enterprise and how 
defined or mapped to the excel sheet? OR is it the Advanced Management in 
addition to the Additional components?
ii) Is the Module based Licensing still valid for new customers or when do we 
use it?
iii) The Multi-site or GVA in the excel pricing sheet, how can we know what 
each agreement means(example: Multi Agreement tier D?Mutli Agreement Tier E?

[Axapta-Knowledge-Village] AX 2009 Licensing Editions doubts?

[kardo_ax]

Dear All,

I have a doubt regarding the AX 2009 licensing versions.

A) In QRG, they are talking about the following:

1)Business Essentials.2)Advanced Management.3)Advanced Management
Enterprise.4)Additional Components.

B)While in the Excel pricing sheet we can find:

1)Business Ready Licensing - Business Essentials Edition.
2)Business Ready Licensing - Advanced Management Edition.
3)Module Based Licensing - Enterprise.

i)The doubt or confusion is about Advanced Management Enterprise and how
defined or mapped to the excel sheet? OR is it the Advanced Management in
addition to the Additional components?
ii) Is the Module based Licensing still valid for new customers or when do we
use it?
iii) The Multi-site or GVA in the excel pricing sheet, how can we know what each
agreement means(example: Multi Agreement tier D?Mutli Agreement Tier E?

[Axapta-Knowledge-Village] Re: How to highlight a row in a grid

[manoch]

You can use method findRecord() and mark() on datasource
to active or select any rows in grid.


--- In Axapta-Knowledge-Village@yahoogroups.com, maevek mae...@... wrote:

 Is there a way to highlight a specific row in a grid?
 
  I don't wish to filter out the other rows - just cause the
 specific row to have focus, be selected, be highlighted,
 when the user clicks the tab
 that the data-grid is a part of.
 
   The conditions from the linked-from Form
 don't allow me to create a data-relationship directly,
 so I'll need to be able to do it by overriding
 some form method.
 
   Any ideas how to do this?
 
  Thanks for your help!
 
  - Maeve

Re: [Axapta-Knowledge-Village] Purchase Req Workflow Configuration

[Anitha Santosh]

Hi,

Could you give me more info ??

@ which stage you want the assignement to happen in Purch Req ??

On Mon, Aug 23, 2010 at 4:52 PM, Dishant Singhal
singhal_dish...@yahoo.comwrote:



 Hi

 I understand that the DAX 2009 Purchase requsition workflow when submitted
 goes
 to the Purchase Department for processing which can then convert it to the
 RFQ
 before completing the same.

 Is it possible to set the same to when submited, this workflow goes to the
 manager defined in the assignment, who can approve or reject this. If
 approved,
 then is workflow goes to the Purchase department who can then convert it to
 RFQ
 after the manager has approved / completed the same in the earlier stage.

 can this be set in the Standard Ax 2009 or would need to customize the
 workflow
 template.

 Any help / suggestions would be appreciated.

 Thanks, Dishant

 




-- 
Regards,
AnithaSantosh

Re: [Axapta-Knowledge-Village] Purchase Req Workflow Configuration

[Dishant Singhal]

Post Submission by the requisitioner, this should get assigned to the manager 
for approval. After this approval, this can go to the Purchaser for RFQ etc.

Hope this is clear

Thanks, Dishant





From: Anitha Santosh mail2eani...@gmail.com
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Mon, August 23, 2010 4:59:27 PM
Subject: Re: [Axapta-Knowledge-Village] Purchase Req Workflow Configuration

  
Hi,

Could you give me more info ??

@ which stage you want the assignement to happen in Purch Req ??


On Mon, Aug 23, 2010 at 4:52 PM, Dishant Singhal singhal_dish...@yahoo.com 
wrote:

  
Hi

I understand that the DAX 2009 Purchase requsition workflow when submitted 
goes 

to the Purchase Department for processing which can then convert it to the RFQ 
before completing the same.

Is it possible to set the same to when submited, this workflow goes to the 
manager defined in the assignment, who can approve or reject this. If 
approved, 

then is workflow goes to the Purchase department who can then convert it to 
RFQ 

after the manager has approved / completed the same in the earlier stage.

can this be set in the Standard Ax 2009 or would need to customize the 
workflow 

template.

Any help / suggestions would be appreciated.

Thanks, Dishant




-- 
Regards,
AnithaSantosh




  

[Axapta-Knowledge-Village] (unknown)

[Accenter 079-Iin Dewi]

test

Regards,

Iin Dewi Wahyuni
Accent-er 079 * Avega Silver Polaris
http://geeks.netindonesia.net/blogs/idw/ or
http://www.linkedin.com/in/iindewi


  

Re: [Axapta-Knowledge-Village] I got a problem with employee form

[Accenter 079-Iin Dewi]

Try to close the AX and then open again, see what happen

Regards,



Iin Dewi Wahyuni

Accent-er 079 * Avega Silver Polaris

http://geeks.netindonesia.net/blogs/idw/ or

http://www.linkedin.com/in/iindewi

--- On Thu, 8/5/10, SUNEEL BABU suneel...@hotmail.com wrote:

From: SUNEEL BABU suneel...@hotmail.com
Subject: [Axapta-Knowledge-Village] I got a problem with employee form
To: Axapta Knowledge village axapta-knowledge-village@yahoogroups.com, 
Development development-axa...@yahoogroups.com, Arjit babu Ax 
arijit.b...@gmail.com, amit bhatt AX amit_bha...@yahoo.com, Anitha AX 
mail2eani...@gmail.com
Date: Thursday, August 5, 2010, 1:20 AM







 



  



  
  
  


 

Hi,
I got a problem with employee form.  i.e.,

I want to add some fields to empltable. For this I create a new table with the 
required fields along with emplid. And i attach the table as a datasource in 
the employee form. I put the fields in a new tab page.

Now i create a new record in empltable but i am unable to insert values in to 
my new table. The fileds are disabled in the tab page. How can i activate the 
fields. I tried with create method. But it does't work. 


Please any one send me the solution ASAP


  



 





 



  






  

[Axapta-Knowledge-Village] AX 2009, Communication Error

[birendra singh]

Hi All,
  when i am posting purchase  Sales order the following error throwing 
in Axapta 2009.
 
Communication Error:-
 
'Your Microsoft Dynamics AX session is no longer valid.Log off your computer 
and log on again.If the problem persists,contact your Microsoft Dynamics AX 
Administrator'  OK'
 
When i  click on OK. AX2009 closed.
 
 
Pls help ,if any one known above problem.


--
Thanks  Regards,
BK Singh

Mobile No.9711203419

[Axapta-Knowledge-Village] Record Level Security

[amit babber]

Hi

Can any one  confirm me  how can I give  the record level security  through
X++ code.

I have  done that by  making a query  in the init of form  and  applied the
range of  according to users
onSmmopportunityTable   form.
 There are filters on the  said form  such as  show all,
and  owner wise.

When I click the select all  checkbox,  then the  my query is   broken  and
it shows the  records  of all users   ,  where as  I have  passed  the
specific user range  in the  init of  form   through query range.

Can  anyone  confirm  how  can I use the  said  code.

.
Thanks in advance



Regards
Amit Babber
9711141075

Re: [Axapta-Knowledge-Village] New screen access right

[Accenter 079-Iin Dewi]

Hi Thomas,

If you imported the object only without data then the security access will not 
affecting to the live database.

Regards,



Iin Dewi Wahyuni

Accent-er 079 * Avega Silver Polaris

http://geeks.netindonesia.net/blogs/idw/ or

http://www.linkedin.com/in/iindewi

--- On Mon, 8/2/10, thomas 'znal' ramdhan thomasramd...@gmail.com wrote:

From: thomas 'znal' ramdhan thomasramd...@gmail.com
Subject: [Axapta-Knowledge-Village] New screen access right
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Monday, August 2, 2010, 3:02 AM







 



  



  
  
  Dear all,

I'd just like to make sure, let's say I have 1 new screen call 

'xtsItemGroup' and I'd like to import it to live database.
Is it 
different if I set the security key between before and after I import 
the 
table to live database ?

In my case, I used Invent Setup as my security 
key.  It means, all user 
group who have access to Invent Setup could open my 
new screen 
('xtsItemGroup'), doesn't it ? Is there any suggestion so that my 
newest 
screen access has default to no ?

Thanks and Regards,
Afin

-- 
ne faites pas une limite pour votre competence
 - - - - - - ---

bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
 - - - - - - ---
non faccia un limite per la vostra abilita
 - - - - - - ---

--(-@




 





 



  






  

[Axapta-Knowledge-Village] Re: How to call a method fr ever selection change in combo box

[Sai Sharan]

thnx a lot nikhil.

--- In Axapta-Knowledge-Village@yahoogroups.com, Nix pujar.nik...@... wrote:

 Hii SaiSharan,
 
 You can override the method selectionchange() of the Combobox control and
 call ur respective method in it.
 
 On Thu, Jul 29, 2010 at 11:59 AM, Sai Sharan saisharan@...wrote:
 
 
 
  Hi all,
 
  I am a beginner in Ax Programming.
  I want to call a method for ever selection change i made in a combo box.
  Please help me in resolving this,
  waiting fr u reply.
 
   
 
 
 
 
 -- 
 
 Thanks and Regards
 Nikhil   Pujar

[Axapta-Knowledge-Village] Error executing code: Insufficient memory to run script when running master plan

[alpsamdancioglu]

Hi All,

We want to run master planning for a year on a standard application and keep 
taking same error all the time Error executing code: Insufficient memory to 
run script. 

We have changed maxbuffersize in registry to 0 zero but nothing has changed.

Server  Client Configuration values are default.

King regards.
Alper.

[Axapta-Knowledge-Village] Record level security using curuserid()

[amit babber]

Hi

I am trying to  use the record level security on a particular table ,  In
that,  I  want  that a particular user group members  should be able to
see   only their own created record.

I have  tried  the record level security setup. In Query part  I have  added
the particular table, added  the  *Created By*  field  and  in the  *criteria
*field   I have   used the  function   *=curuserid()*.


But when I am  trying  to open the form ,  no  records  are  being  shown.

Please  suggest me  the better  solution  for the  same.
Thanks in advance

Regards:
Amit  Babber
9711141075

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

[Accenter 079-Iin Dewi]

You also can use TextIo object :

void main(Args _args)
{
    str    filename, txt;
    TextIo   file;
    container   c;
    ;

    filename = C:\Axapta\Test.txt;
    if (! WinAPI::fileExistsClient(fileName))
    return checkFailed(strfmt(@SYS62207,fileName));

    if (filename)

    {

    file = new TextIo(filename, mode);

    }

    else

    file = null;


    file.inFieldDelimiter(file.inRecordDelimiter());
    while (file.status() == IO_Status::Ok)
    {
    c = file.read();

    if (file.status() != IO_Status::Ok)
    break;

    [txt] = c;
    txt = strLRTrim(txt);
    ... *you can put 
any kind of your logic here*
    }
}

Regards,



Iin Dewi Wahyuni
http://geeks.netindonesia.net/blogs/idw/ or

http://www.linkedin.com/in/iindewi

--- On Tue, 8/17/10, Sumit Loya loya.su...@gmail.com wrote:

From: Sumit Loya loya.su...@gmail.com
Subject: Re: [Axapta-Knowledge-Village] Open a file
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Tuesday, August 17, 2010, 8:33 AM







 



  



  
  
  Hi Afin,
 
Try this out
 
static void openFile(Args _args)
{
    #WinApi
    str filename = @'C:\Users\sumit.loya\Desktop\Test.docx';
    ;
    
    WinAPI::shellExecute(filename,'','',#ShellExeOpen);

}
 
Regards,
Sumit


On Tue, Aug 17, 2010 at 5:55 PM, thomas 'znal' ramdhan 
thomasramd...@gmail.com wrote:


  



Hi Nix,

Thanks for replying, but what I mean was not the content. I'd like to launch 
the file from axapta.
I've tried code infoLog.urlLookup , but the result was return an error.

Thanks and Regards,

Afin


On Tue, Aug 17, 2010 at 2:31 PM, Nix pujar.nik...@gmail.com wrote:


  




Hi Afin,
 
You can use SYSEXCELAPPLICATION class for opening the excel application on the 
desktop from AXAPTA.
 
The Code should look something like this
 
SysExcelApplication application;
    SysExcelWorkbooks workbooks;
    ;
    application = SysExcelApplication::construct();
    workbooks = application.workbooks();
    application.visible(true);

    workbooks.add(); // In case you want to open a new blank worksheet
    workbooks.open( str _filename)// In case you want to open the existing file 
in to excel from the code in Axapta.(Str _ filename is nothing but the string 
parameter for the function) i.e. your existing file path.






On Tue, Aug 17, 2010 at 12:35 PM, thomas 'znal' ramdhan 
thomasramd...@gmail.com wrote:


  



Dear all,

I'd like to know, how can I open a file automatically through Axapta ?
Let's say, I have an excel file in my desktop, and I'd like to open it by code 
in Axapta.

Thanks and Regards,

Afin

-- 
ne faites pas une limite pour votre competence
-
bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
-

non faccia un limite per la vostra abilita
-
--(-@




-- 

Thanks and Regards
Nikhil   Pujar




-- 
ne faites pas une limite pour votre competence
-

bilden Sie nicht eine Begrenzung fur Ihre Fahigkeit
-
non faccia un limite per la vostra abilita
-

--(-@







 





 



  






  

[Axapta-Knowledge-Village] Ax 2009 consuming web service issue with Dimension field.

[nitin_jobs2k3]

Hi,

I am trying to consume AIF web service using C#. I am facing one issue, while 
setting the value for Dimension field in customer service. Can any one know how 
to handle field having EDT of array elements.

Regards
Nitin

[Axapta-Knowledge-Village] How to highlight a row in a grid

[maevek]

Is there a way to highlight a specific row in a grid?

 I don't wish to filter out the other rows - just cause the
specific row to have focus, be selected, be highlighted,
when the user clicks the tab
that the data-grid is a part of.

  The conditions from the linked-from Form
don't allow me to create a data-relationship directly,
so I'll need to be able to do it by overriding
some form method.

  Any ideas how to do this?

 Thanks for your help!

 - Maeve

Re: [Axapta-Knowledge-Village] InventDim in a Relation definition?

[Mairi]

Hi,

Just make a relation in your new table to inventdim table
and put 2 new normal relation to each field you mentioned below.

but don't know though why you have to make this link table, is it for
production ?

Rgds,
Mai

On Wed, Aug 18, 2010 at 10:15 PM, mgk915 mae...@alrinach.net wrote:



 How can I specify
 a component of InventDim in a relationship?
 I want to relate a table that has just
 ItemId and InventSerialId
 to
 InventSum, which has ItemId, and InventDim.

 - Please help!
 I don't see anyway to create a relationship like this
 on the table-definitions.