[Axapta-Knowledge-Village] I Am Trying To Set Up CLR Interop, Can Anyone Provide Guidance?

[Girac]

Hello all, 
I have my dll built and added as a reference in the AOT, now I need to develop 
code to communicate with it. 

The code I put in place I get error, The table does not contain this field. I 
am trying to reference my CLR Interop DLL in the AOT. 
Looking forward to your assistnace.


regards,

[Axapta-Knowledge-Village] Re: Compile error with XML Create Document

[Girac]

Thank you for your assistance. I solved it by using the in2str as well as the 
strfmt('%1').



--- In Axapta-Knowledge-Village@yahoogroups.com, sreenath reddy 
shysrin...@... wrote:

 use  xmlDoc.createTextNode( strfmt('%1',ReqTrans. Qty));
 
  sreenath
 
 --- On Thu, 8/13/09, giarc 127 girac...@... wrote:
 
 From: giarc 127 girac...@...
 Subject: Re: [Axapta-Knowledge-Village] Compile error with XML Create Document
 To: Axapta-Knowledge-Village@yahoogroups.com
 Date: Thursday, August 13, 2009, 9:09 PM
 
 
 
 
 
 
  
 
 
 
 
 
   prashan,
 I tried the any2str and it compiles but I receive runtime error, Error 
 executing code: Wrong type of argument for conversion function.
 Would I need to use variables for this?
 
 Regards.
 
 
 
 
 
 From: prashant verma prashant_axapta@ yahoo.co. in
 To: Axapta-Knowledge- vill...@yahoogro ups.com
 Sent: Wednesday, August 12, 2009 11:26:43 PM
 Subject: Re: [Axapta-Knowledge- Village] Compile error with XML Create 
 Document
 
 
 
 
 
 
 
 
  
 
 
   
 
 
 
 Goodmorning Girac,
  
 Your problem is solved.Actually createTextNode method accepts str 
 argument.Just write
 any2str like this xmlText = xmlDoc.createTextNo de(any2str( ReqTrans. Qty));
 And for integers or real value always use num2str.
 
 
 Regards,
 Prashant Verma
 ILFS Technologies Limited.
 
 --- On Wed, 12/8/09, Girac girac...@yahoo. com wrote:
 
 
 From: Girac girac...@yahoo. com
 Subject: [Axapta-Knowledge- Village] Compile error with XML Create Document
 To: Axapta-Knowledge- vill...@yahoogro ups.com
 Date: Wednesday, 12 August, 2009, 8:10 PM
 
 
   
 
 Good day all,
 
 I am getting an error when I compile this job, 
 
 Argument 'Text' is incompatible with the required type. 
 Here it the code I am using,
 
 // Create a node for the Qty
 xmlElement = xmlDoc.createElemen t(Qty);
 NodeAddr = NodeEmpl.appendChil d(xmlElement) ;
 xmlText = xmlDoc.createTextNo de(ReqTrans. Qty);
 NodeAddr.appendChil d(xmlText) ;
 
 Qty is an real number, 
 
 What arguments would I need to use for integers/numbers?
 
 Here is my full code:
 static void XMLitem(Args _args)
 {
 XMLDocument xmlDoc = XMLDocument: :newBlank( );
 XMLNode rootNode;
 XMLNode NodeEmpl, NodeName, NodeAddr;
 XMLElement xmlElement;
 XMLText xmlText;
 //XMLreal xmlNumber;
 ReqTrans ReqTrans;
 
 int i;
 ;
 // Create first line containing version info
 rootNode = xmlDoc.documentElem ent();
 xmlElement = xmlDoc.createElemen t(axItems );
 rootNode = xmlDoc.appendChild( xmlElement)
  ;
 while select ReqTrans 
 {
 // Create a node for the Items record
 xmlElement = xmlDoc.createElemen t(Items );
 NodeEmpl = rootNode..appendChi l d(xmlElement) ;
 // Create a node for the ItemID
 xmlElement = xmlDoc.createElemen t(ItemID );
 NodeName = NodeEmpl.appendChil d(xmlElement) ;
 xmlText = xmlDoc.createTextNo de(ReqTrans. ItemID);
 NodeName.appendChil d(xmlText) ;
 // Create a node for the Qty
 xmlElement = xmlDoc.createElemen t(Qty);
 NodeAddr = NodeEmpl.appendChil d(xmlElement) ;
 xmlText = xmlDoc.createTextNo de(ReqTrans. Qty);
 NodeAddr.appendChil d(xmlText) ;
 i++;
 print i;
 }
 // Save the file
 xmldoc.save( 'C:\\Temp\ \XML.xml' );
 }
 
 
 
See the Web's breaking stories, chosen by people like you. Check out  
 Yahoo! Buzz.

[Axapta-Knowledge-Village] Help with Lookup Form Ignoring characters

[Girac]

Hello all,

In Ax we have ItemId listed as '*123*456*789' however we have an 
integration app and users that search several ways, such as 
'.123.456.789' , '123-456-789'  and just numbers '123456789'


what would your suggestions be to search in AX by ignoring the *,., and
 - character?


regards.

 

[Axapta-Knowledge-Village] Compile error with XML Create Document

[Girac]

Good day all,

I am getting an error when I compile this job, 

Argument 'Text' is incompatible with the required type. 
Here it the code I am using,

// Create a node for the Qty
xmlElement = xmlDoc.createElement(Qty);
NodeAddr = NodeEmpl.appendChild(xmlElement);
xmlText = xmlDoc.createTextNode(ReqTrans.Qty);
NodeAddr.appendChild(xmlText);

Qty is an real number, 

What arguments would I need to use for integers/numbers?

Here is my full code:
static void XMLitem(Args _args)
{
XMLDocument xmlDoc = XMLDocument::newBlank();
XMLNode rootNode;
XMLNode NodeEmpl, NodeName, NodeAddr;
XMLElement xmlElement;
XMLText xmlText;
//XMLreal  xmlNumber;
ReqTrans ReqTrans;

int i;
;
// Create first line containing version info
rootNode = xmlDoc.documentElement();
xmlElement = xmlDoc.createElement(axItems);
rootNode = xmlDoc.appendChild(xmlElement);
while select ReqTrans 
{
// Create a node for the Items record
xmlElement = xmlDoc.createElement(Items);
NodeEmpl = rootNode.appendChild(xmlElement);
// Create a node for the ItemID
xmlElement = xmlDoc.createElement(ItemID);
NodeName = NodeEmpl.appendChild(xmlElement);
xmlText = xmlDoc.createTextNode(ReqTrans.ItemID);
NodeName.appendChild(xmlText);
// Create a node for the Qty
xmlElement = xmlDoc.createElement(Qty);
NodeAddr = NodeEmpl.appendChild(xmlElement);
xmlText = xmlDoc.createTextNode(ReqTrans.Qty);
NodeAddr.appendChild(xmlText);
i++;
print i;
}
// Save the file
xmldoc.save('C:\\Temp\\XML.xml');
}

[Axapta-Knowledge-Village] Converting C# Code for Ax

[Girac]

Hello all,
I have sample C# code provided by my partner for document exchange. I 
need to convert this code to X++  in order to have Ax submit the xml
document to partner. 

Is there anyone who can assist in this matter?

Regards,

[Axapta-Knowledge-Village] Re: Help with adding lookup filters on forms

[Girac]

Maybe I am not explaining correctly,
I have a form that displays a grid of work orders. On grid there is 
filter for responsible person and department. Both of these are 
fields on my grid. I would also like to add a new filter called order
 id, which is also a field on grid, in same table as responsible 
person and department.

I have copied the methods for these tables but cannot get the filter
 to work. The query is pulling all order ID correctly but when I 
select a record in the filter query I do not go to that record.
I put the methods under my form filter control, as overrides. This is
 how other were set.


When I add your code to the datasource I get the following error: 
Argument 'callingControl' is incompatible with the required type. 
This in happening on line 3. 

I have worked within Ax for 3 years but new to the development side, 

 thank you for bearing with me.






--- In Axapta-Knowledge-Village@yahoogroups.com, Anitha S mail2eani...@... 
wrote:

 Hi..
Could you reframe ur qtn.. I could help you out if i m clear with the
 scenario...
 
U can override the lookup method @ datasource level and design level as
 well..
The code which I ve sent u is to be called @ datasource level.
 
So give me a clear picture and we shall try again..
 
 Regards,
 Anitha
 
 On Wed, Aug 5, 2009 at 10:12 PM, Girac girac...@... wrote:
 
 
 
  I am not sure where to put the method. Is this a override, would this
  go under the datasource, or under my filter from control and is
  there more code that need to be modified?
 
  Regards,
 
  G
 
 
  --- In 
  Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com,
  Girac girac127@ wrote:
  
   I have tried your suggestion and no luck. It is acting as if the query is
  not getting executed.
   any other suggestions?
  
  
   regards, G
  
   --- In 
   Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com,
  Anitha S mail2eanitha@ wrote:
   
hi..
Try to pass a valid value in QueryValue and check if the commented code
  is
working.
   
   
On Tue, Aug 4, 2009 at 8:03 PM, Girac girac127@ wrote:
   


 Below is the code I'm using, the table does get queried and results
  are
 returned as expected. However, when one is selected the record is
 not returned. Do I need another method for that?

 I have looked at the SysTableLookup class on MSDN and Axaptapedia and
  all
 looks correct. What did I miss?

 Regards.
 G

 public void lookup()
 {
 SysTableLookup sysTableLookup =
 SysTableLookup::newParameters(TableNum(OrderTable), this);
 query query = new Query();
 QueryBuildDataSource qbds;
 QueryBuildRange queryBuildRange;
 ;

 sysTableLookup. addLookupfield( fieldnum( OrderTable, OrderID));
 sysTableLookup. addLookupfield( fieldnum( OrderTable, Name));

 qbds = query.addDataSource (tablenum( OrderTable));

 qbds.addRange(fieldnum(OrderTable, OrderID));
 //qbds.addRange(fieldnum(OrderTable, OrderID)).value(QueryValue(1));
 //***When above uncommented no results are showing

 sysTableLookup. parmQuery( query);
 sysTableLookup. performFormLookup();
 }

 --- In 
 Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
  Axapta-Knowledge-Village%40yahoogroups.com,
 Anitha S mail2eanitha@ wrote:
 
  Hi,
 
  Try this code:
 
  public void lookup()
  {
  SysTableLookup sysTableLookup =
  SysTableLookup::newParameters(TableNum,this);
  Query query = new Query() ;
  QueryBuildDataSource qbds;
  Table1 objTable1;
  ;
 
  sysTableLookup.addLookupfield(fieldnum(Table1, Field1));
  sysTableLookup.addLookupfield(fieldnum(Table1, Field2));
 
  qbds = query.addDataSource(tablenum(Table1));
 
  qbds.addRange(fieldnum(Table1, Field1));
  qbds.addRange(fieldnum(Table1, Field2)).value(QueryValue(1));
 
  sysTableLookup.parmQuery(query);
  sysTableLookup.performFormLookup();
  }
 
  Hope this helps.
  Regards,
  Anitha
 
 
  On Tue, Aug 4, 2009 at 2:39 AM, Girac girac127@ wrote:
 
  
  
   Hello all,
   Can someone help me with building a lookup filter on a form? I
  want to
   add a new filter to some forms. I have copied the code from
  existing
   filter to new one. when i compile I get errors variable not
  declared,
   table does not contain this field, etc...
  
   I have declared my variable and the error I receive is is table
  does
   not contain this field.
  
   Where do I put this table info in my code?
  
   If someone can document steps are involved that will be great.
  
  
  
 



   
  
 
   
 

[Axapta-Knowledge-Village] Re: Help with adding lookup filters on forms

[Girac]

I have tried your suggestion and no luck. It is acting as if the query is not 
getting executed. 
any other suggestions?


regards, G

--- In Axapta-Knowledge-Village@yahoogroups.com, Anitha S mail2eani...@... 
wrote:

 hi..
 Try to pass a valid value in QueryValue and check if the commented code is
 working.
 
 
 On Tue, Aug 4, 2009 at 8:03 PM, Girac girac...@... wrote:
 
 
 
  Below is the code I'm using, the table does get queried and results are
  returned as expected. However, when one is selected the record is
  not returned. Do I need another method for that?
 
  I have looked at the SysTableLookup class on MSDN and Axaptapedia and all
  looks correct. What did I miss?
 
  Regards.
  G
 
  public void lookup()
  {
  SysTableLookup sysTableLookup =
  SysTableLookup::newParameters(TableNum(OrderTable), this);
  query query = new Query();
  QueryBuildDataSource qbds;
  QueryBuildRange queryBuildRange;
  ;
 
  sysTableLookup. addLookupfield( fieldnum( OrderTable, OrderID));
  sysTableLookup. addLookupfield( fieldnum( OrderTable, Name));
 
  qbds = query.addDataSource (tablenum( OrderTable));
 
  qbds.addRange(fieldnum(OrderTable, OrderID));
  //qbds.addRange(fieldnum(OrderTable, OrderID)).value(QueryValue(1));
  //***When above uncommented no results are showing
 
  sysTableLookup. parmQuery( query);
  sysTableLookup. performFormLookup();
  }
 
  --- In 
  Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com,
  Anitha S mail2eanitha@ wrote:
  
   Hi,
  
   Try this code:
  
   public void lookup()
   {
   SysTableLookup sysTableLookup =
   SysTableLookup::newParameters(TableNum,this);
   Query query = new Query() ;
   QueryBuildDataSource qbds;
   Table1 objTable1;
   ;
  
   sysTableLookup.addLookupfield(fieldnum(Table1, Field1));
   sysTableLookup.addLookupfield(fieldnum(Table1, Field2));
  
   qbds = query.addDataSource(tablenum(Table1));
  
   qbds.addRange(fieldnum(Table1, Field1));
   qbds.addRange(fieldnum(Table1, Field2)).value(QueryValue(1));
  
   sysTableLookup.parmQuery(query);
   sysTableLookup.performFormLookup();
   }
  
   Hope this helps.
   Regards,
   Anitha
  
  
   On Tue, Aug 4, 2009 at 2:39 AM, Girac girac127@ wrote:
  
   
   
Hello all,
Can someone help me with building a lookup filter on a form? I want to
add a new filter to some forms. I have copied the code from existing
filter to new one. when i compile I get errors variable not declared,
table does not contain this field, etc...
   
I have declared my variable and the error I receive is is table does
not contain this field.
   
Where do I put this table info in my code?
   
If someone can document steps are involved that will be great.
   
   
   
  
 
   
 

[Axapta-Knowledge-Village] Re: Help with adding lookup filters on forms

[Girac]

I am not sure where to put the method. Is this a override, would this
 go under the datasource, or under my filter from control and is 
there more code that need to be modified?



Regards, 


G


--- In Axapta-Knowledge-Village@yahoogroups.com, Girac girac...@... wrote:

 I have tried your suggestion and no luck. It is acting as if the query is not 
 getting executed. 
 any other suggestions?
 
 
 regards, G
 
 --- In Axapta-Knowledge-Village@yahoogroups.com, Anitha S mail2eanitha@ 
 wrote:
 
  hi..
  Try to pass a valid value in QueryValue and check if the commented code is
  working.
  
  
  On Tue, Aug 4, 2009 at 8:03 PM, Girac girac127@ wrote:
  
  
  
   Below is the code I'm using, the table does get queried and results are
   returned as expected. However, when one is selected the record is
   not returned. Do I need another method for that?
  
   I have looked at the SysTableLookup class on MSDN and Axaptapedia and all
   looks correct. What did I miss?
  
   Regards.
   G
  
   public void lookup()
   {
   SysTableLookup sysTableLookup =
   SysTableLookup::newParameters(TableNum(OrderTable), this);
   query query = new Query();
   QueryBuildDataSource qbds;
   QueryBuildRange queryBuildRange;
   ;
  
   sysTableLookup. addLookupfield( fieldnum( OrderTable, OrderID));
   sysTableLookup. addLookupfield( fieldnum( OrderTable, Name));
  
   qbds = query.addDataSource (tablenum( OrderTable));
  
   qbds.addRange(fieldnum(OrderTable, OrderID));
   //qbds.addRange(fieldnum(OrderTable, OrderID)).value(QueryValue(1));
   //***When above uncommented no results are showing
  
   sysTableLookup. parmQuery( query);
   sysTableLookup. performFormLookup();
   }
  
   --- In 
   Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com,
   Anitha S mail2eanitha@ wrote:
   
Hi,
   
Try this code:
   
public void lookup()
{
SysTableLookup sysTableLookup =
SysTableLookup::newParameters(TableNum,this);
Query query = new Query() ;
QueryBuildDataSource qbds;
Table1 objTable1;
;
   
sysTableLookup.addLookupfield(fieldnum(Table1, Field1));
sysTableLookup.addLookupfield(fieldnum(Table1, Field2));
   
qbds = query.addDataSource(tablenum(Table1));
   
qbds.addRange(fieldnum(Table1, Field1));
qbds.addRange(fieldnum(Table1, Field2)).value(QueryValue(1));
   
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
   
Hope this helps.
Regards,
Anitha
   
   
On Tue, Aug 4, 2009 at 2:39 AM, Girac girac127@ wrote:
   


 Hello all,
 Can someone help me with building a lookup filter on a form? I want to
 add a new filter to some forms. I have copied the code from existing
 filter to new one. when i compile I get errors variable not declared,
 table does not contain this field, etc...

 I have declared my variable and the error I receive is is table does
 not contain this field.

 Where do I put this table info in my code?

 If someone can document steps are involved that will be great.



   
  

  
 

[Axapta-Knowledge-Village] Re: Help with adding lookup filters on forms

[Girac]

Below is the code I'm using, the table does get queried and results are
 returned as expected. However, when one is selected the record is
 not returned. Do I need another method for that?

I have looked at the SysTableLookup class on MSDN and Axaptapedia and all looks 
correct. What did I miss?

Regards.
G




public void lookup()
{
SysTableLookupsysTableLookup = 
SysTableLookup::newParameters(TableNum(OrderTable), this);
query   query = new Query();
QueryBuildDataSourceqbds;
QueryBuildRange queryBuildRange;
   ;

sysTableLookup. addLookupfield( fieldnum( OrderTable, OrderID));
sysTableLookup. addLookupfield( fieldnum( OrderTable, Name));

qbds = query.addDataSource (tablenum( OrderTable));

qbds.addRange(fieldnum(OrderTable, OrderID));
//qbds.addRange(fieldnum(OrderTable, OrderID)).value(QueryValue(1));
//***When above uncommented no results are showing

sysTableLookup. parmQuery( query);
sysTableLookup. performFormLookup();
}



--- In Axapta-Knowledge-Village@yahoogroups.com, Anitha S mail2eani...@... 
wrote:

 Hi,
 
 Try this code:
 
 public void lookup()
 {
 SysTableLookup   sysTableLookup =
 SysTableLookup::newParameters(TableNum,this);
 Query  query = new Query() ;
 QueryBuildDataSource   qbds;
 Table1 objTable1;
  ;
 
 sysTableLookup.addLookupfield(fieldnum(Table1, Field1));
 sysTableLookup.addLookupfield(fieldnum(Table1, Field2));
 
 qbds = query.addDataSource(tablenum(Table1));
 
 qbds.addRange(fieldnum(Table1, Field1));
 qbds.addRange(fieldnum(Table1, Field2)).value(QueryValue(1));
 
 sysTableLookup.parmQuery(query);
 sysTableLookup.performFormLookup();
 }
 
 Hope this helps.
 Regards,
 Anitha
 
 
 On Tue, Aug 4, 2009 at 2:39 AM, Girac girac...@... wrote:
 
 
 
  Hello all,
  Can someone help me with building a lookup filter on a form? I want to
  add a new filter to some forms. I have copied the code from existing
  filter to new one. when i compile I get errors variable not declared,
  table does not contain this field, etc...
 
  I have declared my variable and the error I receive is is table does
  not contain this field.
 
  Where do I put this table info in my code?
 
  If someone can document steps are involved that will be great.
 
  
 

[Axapta-Knowledge-Village] What is the best way to lookup itemID field using a variant of the itemID?

[Girac]

For example, the ItemID in Ax is abc*123*def. The users would like
 to search this item using multiple variants of the ItemID such as:
 'abc.123.def' or 'abc123def' 



What is the best way to accomplish this? 

[Axapta-Knowledge-Village] Help with adding lookup filters on forms

[Girac]

Hello all, 
Can someone help me with building a lookup filter on a form? I want to
 add a new filter to some forms. I have copied the code from existing 
filter to new one. when i compile I get errors variable not declared, 
table does not contain this field, etc...


I have declared my variable and the error I receive is is table does 
not contain this field. 


Where do I put this table info in my code?


If someone can document steps are involved that will be great. 

[Axapta-Knowledge-Village] Not enough rights to use table 'Item configurations' (ConfigTable).

[Girac]

Hell all, 
I am logged in as admin and I have checked group permissions and all
 are set to full control. However I get this error when I try to access 
the ConfigTable. I cannot access this the table directly from the AOT 
or a form in the MRP area. Can anyone offer assistance on this,



Regards

G

[Axapta-Knowledge-Village] Re: Not enough rights to use table 'Item configurations' (ConfigTable).

[Girac]

Here is a sillier question? How do I verify that it is enabled? I did remove 
the key and was still unable to access the table through the TableBrowser in 
AOT.

Thanks

G

--- In Axapta-Knowledge-Village@yahoogroups.com, Varden Morris vard...@... 
wrote:

 This might be a silly question but do you know if the configuration key used 
 by that table is enabled?
  
 Regards,
  
 Varden Morris
 Varalth Solutions Inc.  
 693 Abbottsfield Road NW
 Edmonton, Alberta T5W 4R4
 Canada 
 (780) 752-0406 
 (780) 716-8604 (c)
 www.varalth.com 
 
 CONFIDENTIALITY NOTICE 
  
 This message and any attachments are confidential.  If you have received this 
 transmission in error, please be advised that any disclosure, copying, 
 distribution or action taken in reliance upon this communication is strictly 
 prohibited.  If you have received this communication in error, please contact 
 the sender immediately. Please note that any views or opinions presented in 
 this email are solely those of the author and do not necessarily represent 
 those of the company.  Finally, the recipient should check this email and any 
 attachments for the presence of viruses. The company accepts no liability for 
 any damage caused by any virus transmitted by this email.
 
 
 
 
 
 From: Girac girac...@...
 To: Axapta-Knowledge-Village@yahoogroups.com
 Sent: Friday, July 31, 2009 10:25:46 AM
 Subject: [Axapta-Knowledge-Village] Not enough rights to use table 'Item 
 configurations' (ConfigTable).
 
   
 Hell all, 
 I am logged in as admin and I have checked group permissions and all
 are set to full control. However I get this error when I try to access 
 the ConfigTable. I cannot access this the table directly from the AOT 
 or a form in the MRP area. Can anyone offer assistance on this,
 
 Regards
 
 G

[Axapta-Knowledge-Village] Re: Not enough rights to use table 'Item configurations' (ConfigTable).

[Girac]

Thats what I had to set. Thank you Varden. 



--- In Axapta-Knowledge-Village@yahoogroups.com, Varden Morris vard...@... 
wrote:

 Ok, the configuration key should be enabled. Otherwise you would not see the 
 table in the AOT. Did you try removing the security key value from the table? 
 The configuration keys associated with this table are in the Logistics 
 hierarchy. Go to Administration - Setup - Systems - 
 Configuration.�Ensure that all the children nodes are enabled.
 �
 Regards,
 �
 Varden Morris
 Varalth Solutions Inc.��
 693 Abbottsfield Road NW
 Edmonton, Alberta T5W 4R4
 Canada 
 (780) 752-0406 
 (780) 716-8604 (c)
 www.varalth.com�
 
 CONFIDENTIALITY NOTICE�
 �
 This message and any attachments are confidential.� If you have received 
 this transmission in error, please be advised that any disclosure, copying, 
 distribution or action taken in reliance upon this communication is strictly 
 prohibited.� If you have received this communication in error, please 
 contact the sender immediately. Please note that any views or opinions 
 presented in this email are solely those of the author and do not necessarily 
 represent those of the company.� Finally, the recipient should check this 
 email and any attachments for the presence of viruses. The company accepts no 
 liability for any damage caused by any virus transmitted by this email.
 
 
 
 
 
 From: Girac girac...@...
 To: Axapta-Knowledge-Village@yahoogroups.com
 Sent: Friday, July 31, 2009 11:20:56 AM
 Subject: [Axapta-Knowledge-Village] Re: Not enough rights to use table 'Item 
 configurations' (ConfigTable).
 
 � 
 Here is a sillier question? How do I verify that it is enabled? I did remove 
 the key and was still unable to access the table through the TableBrowser in 
 AOT.
 
 Thanks
 
 G
 
 --- In Axapta-Knowledge- vill...@yahoogro ups.com, Varden Morris vardenm@  
 wrote:
 
  This might be a silly question but do you know if the configuration 
  key�used by that table is enabled?
  �
  Regards,
  �
  Varden Morris
  Varalth Solutions Inc.��
  693 Abbottsfield Road NW
  Edmonton, Alberta T5W 4R4
  Canada 
  (780) 752-0406 
  (780) 716-8604 (c)
  www.varalth. com�
  
  CONFIDENTIALITY NOTICE�
  �
  This message and any attachments are confidential.� If you have received 
  this transmission in error, please be advised that any disclosure, copying, 
  distribution or action taken in reliance upon this communication is 
  strictly prohibited.� If you have received this communication in error, 
  please contact the sender immediately. Please note that any views or 
  opinions presented in this email are solely those of the author and do not 
  necessarily represent those of the company.� Finally, the recipient 
  should check this email and any attachments for the presence of viruses. 
  The company accepts no liability for any damage caused by any virus 
  transmitted by this email.
  
  
  
  
   _ _ __
  From: Girac girac127@ .
  To: Axapta-Knowledge- vill...@yahoogro ups.com
  Sent: Friday, July 31, 2009 10:25:46 AM
  Subject: [Axapta-Knowledge- Village] Not enough rights to use table 'Item 
  configurations' (ConfigTable) .
  
  � 
  Hell all, 
  I am logged in as admin and I have checked group permissions and all
  are set to full control. However I get this error when I try to access 
  the ConfigTable. I cannot access this the table directly from the AOT 
  or a form in the MRP area. Can anyone offer assistance on this,
  
  Regards
  
  G
 

[Axapta-Knowledge-Village] Re: Help with Movement Journal...Mass Update Having Errors

[Girac]

Yes, I am importing lines into a journal. What do you mean copy the journal to 
a new one afterwards, then post? What would that do?


G

--- In Axapta-Knowledge-Village@yahoogroups.com, Jens Strandberg j...@... 
wrote:

 What do you mean by mass update ?
  
 If you are importing movement lines into a journal, you should copy the
 journal to a new one afterwards. Then post the new one and you will be
 fine.
  
 /Jens
 
   _  
 
 From: Axapta-Knowledge-Village@yahoogroups.com
 [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Agus Riyadi
 Sent: Thursday, July 30, 2009 6:14 AM
 To: Axapta-Knowledge-Village@yahoogroups.com
 Subject: Re: [Axapta-Knowledge-Village] Help with Movement Journal...Mass
 Update Having Errors
 
 
   
 
 Hi,
 
 Check if the total qty you are going to mass update for that particular item
 is more than available qty.
 
 Regards,
 
 Agus
 
 
 
 On Thu, Jul 30, 2009 at 4:28 AM, Girac girac...@yahoo.
 mailto:girac...@... com wrote:
 
 
   
 
 When I do a mass update for my movement journal I receive the following
 error: Cannot receive quantity 1.00 because inventory transactions with
 status Ordered, Arrived, or Registered, are insufficient. 
 
 When I do a manual journal it post fine. 
 
 Am I missing a table update?

[Axapta-Knowledge-Village] Re: Help with Movement Journal...Mass Update Having Errors

[Girac]

Jens, 

Thank you for shedding light on this issue. I have done as suggested and all is 
well. 

Regards. 



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

 Hi,
 
 If you just do a raw import into the journal, no invent transactions will
 be made, and this is why Ax is complaining about Cannot receive... etc.
 
 When you copy from one journal to another, Ax will automatically create
 the required inventory transactions, and when you post, it will work.
 
 I have done so in many Ax implementations without problems.
 
 /J
 
 
  Yes, I am importing lines into a journal. What do you mean copy the
  journal to a new one afterwards, then post? What would that do?
 
 
  G
 
  --- In Axapta-Knowledge-Village@yahoogroups.com, Jens Strandberg
  jens@ wrote:
 
  What do you mean by mass update ?
 
  If you are importing movement lines into a journal, you should copy the
  journal to a new one afterwards. Then post the new one and you will be
  fine.
 
  /Jens
 
_
 
  From: Axapta-Knowledge-Village@yahoogroups.com
  [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Agus
  Riyadi
  Sent: Thursday, July 30, 2009 6:14 AM
  To: Axapta-Knowledge-Village@yahoogroups.com
  Subject: Re: [Axapta-Knowledge-Village] Help with Movement
  Journal...Mass
  Update Having Errors
 
 
 
 
  Hi,
 
  Check if the total qty you are going to mass update for that particular
  item
  is more than available qty.
 
  Regards,
 
  Agus
 
 
 
  On Thu, Jul 30, 2009 at 4:28 AM, Girac girac...@yahoo.
  mailto:girac127@ com wrote:
 
 
 
 
  When I do a mass update for my movement journal I receive the following
  error: Cannot receive quantity 1.00 because inventory transactions with
  status Ordered, Arrived, or Registered, are insufficient.
 
  When I do a manual journal it post fine.
 
  Am I missing a table update?
 
 
 
 

[Axapta-Knowledge-Village] Validating a Movement Journal takes a really long time on Ax2009.

[Girac]

My journal has 1000 lines and takes 45 minutes to validate, what is the reason 
for this and how can I increase performance?
I have reindexed and synched the db.

[Axapta-Knowledge-Village] Re: Validating a Movement Journal takes a really long time on Ax2009.

[Girac]

On PartnerSource I found Kb967203 You experience slow performance when you 
post inventory journals that contain many positions in Microsoft Dynamics AX 
2009 and installed the hotfix and now it validates 25K line in ~4 minutes. 





--- In Axapta-Knowledge-Village@yahoogroups.com, Girac girac...@... wrote:

 My journal has 1000 lines and takes 45 minutes to validate, what is the 
 reason for this and how can I increase performance?
 I have reindexed and synched the db.

[Axapta-Knowledge-Village] Help with Movement Journal...Mass Update Having Errors

[Girac]

When I do a mass update for my movement journal I receive the following error: 
Cannot receive quantity 1.00 because inventory transactions with status 
Ordered, Arrived, or Registered, are insufficient. 

When I do a manual journal it post fine. 


Am I missing a table update?

[Axapta-Knowledge-Village] Does anyone know how I can automatically print a COM Word Document from the....

[Girac]

Document Handler?

Hello all, 

I have a report that I created using the Document Handler and a Word DOT file. 
(Document Handling/New/MyDocu), it works as expected. My requirements are to 
automatically send the report to the printer once the document is created. How 
can this be accomplished?

[Axapta-Knowledge-Village] Urgent Help Needed Regarding Movement Journals:

[Girac]

Hello all,
I have my inventory imported in the system and now I need to do Movement 
Journal. I tried the manual process but I receive the following infolog 
warning:Infolog: Item has no parameter for Inventory:

What is the process for doing movement journal as I have never been involved 
with inventory setup. 


regards
G

[Axapta-Knowledge-Village] Help On A Calculation With An Exponent.

[Girac]

I have the following calculation I am trying to do:
T = (1-((1/(1+I))^n)/I)*((1+I)/I*30)/(1+(I*DFP)/30);
I do not get the proper result returned to me. 
When I try a T=N^2; where N=60, I get a 62 returned. 
How would I use an exponent in X++.

[Axapta-Knowledge-Village] Restricting Access on Lokup Filter

[Girac]

Hello, 
I have a form that has a Employee Lookup Filter, and I would like to restrict 
access on that form and have regular employees not choose anyone else, but 
allow the supervisor access to the filter. 
What is the best way for me to accomplish this. I have tried setting a security 
key without any luck, perhaps I am not doing this correctly.

[Axapta-Knowledge-Village] Querying Ax With XML Documents

[Girac]

Hello all,
I need to have a trading partner query the Ax database for available stock and 
pricing by passing XML and we will respond by sending XML document back. 
Can I do this within AX, or should I query the database directly from a .NET or 
PHP scripting.

[Axapta-Knowledge-Village] I am updating inventroy into system, what tables need updating for this?

[Girac]

I am getting ready import my inventory into AX, what tables would I have to 
update and will I have to do a movement journal?
I would think it would be Inventtable, inventtablemodule, inventdim and 
inventsum. are there any more for inventory? 


regards
G

[Axapta-Knowledge-Village] AX Reporting Help...Passing criteria and 1 click printing?

[Girac]

I have created new forms and from there I want to run a report, but I must 
enter the ID number as the criteria. How can I pass this ID from the record 
that I have selected in my form to my report.

Another query, how can I send the report directly to the printer from my form? 
is there a way to do this.


regards.

[Axapta-Knowledge-Village] What Is The Process To Receive PO Line Items In?

[Girac]

All this is done through the AP/PO advance form. A client is going through 
change and we need to make this as simple as possible for them. Currently they 
scan the barcode on the item to receive in, can this functionality be done in 
AX?

[Axapta-Knowledge-Village] Has anyone used the AX 2009 Mobile Client?

[Girac]

Is there anything special that needs to be done or is it all straight forward?

Thanks,

[Axapta-Knowledge-Village] how can I put a hyperlink on a form?

[Girac]

hi all, 
I want to put a hyperlink on a form or pass parameters to a web page. 
What I want to do is go to a website and use have a some db values passed 
along, such as domain.com/Q?=dbvalue1/dbvalue2 how can I accomplish this? 

G

[Axapta-Knowledge-Village] Re: Adding a button to a form

[Girac]

Hello Santosh
I have that option checked and have the button next to my alert, but I want to 
add a button on the form that when pressed will open the Document handler and 
select my NewDocument that I specify, instead of the user having to click 
the DocHandler, then New, then find the right word document as that will ba 
many to choose from.




--- In Axapta-Knowledge-Village@yahoogroups.com, r_ssh 
ramamurthy.sant...@... wrote:

 Hi Girac,
 
 Any form which is designed will have the Document handling button readily 
 available.
 
 Please enable the Document Handling via
 
 Tools  Options  Enable Document Handling active.(This is generic way where 
 it enables globally to all the forms in AX)
 
 Hope this answers your query.
 
 Thanks
 Santosh.R
 
 --- In Axapta-Knowledge-Village@yahoogroups.com, Girac girac127@ wrote:
 
  I would like to add a document handler button to a form of mine and only 
  have the document show up. 
  I dont have alot of ax programming, can anyone shed light on how this is 
  done. 
  
  best regards,,,
  
  
  g
 

[Axapta-Knowledge-Village] Adding a button to a form

[Girac]

I would like to add a document handler button to a form of mine and only have 
the document show up. 
I dont have alot of ax programming, can anyone shed light on how this is done. 

best regards,,,


g

[Axapta-Knowledge-Village] 'Address book type' must be filled in error

[Girac]

Hi all, 
When trying to update the smmbusreltable from the custtable I am getting the 
following error: Field 'Address book type' must be filled in. However the 
Address book type or PartyID is filled in. and I am unable to update. 
can anyone offer suggestions?


best regards, 

G

[Axapta-Knowledge-Village] 'Address book type' must be filled in error

[Girac]

Hi all, 
When trying to update the smmbusreltable from the custtable I am getting the 
following error: Field 'Address book type' must be filled in. However the 
Address book type or PartyID is filled in. and I am unable to update. 
can anyone offer suggestions?


best regards, 

G

[Axapta-Knowledge-Village] Importing Question

[Girac]

Hi Everyone, I'm fairly new to Ax2009. My question is on importing data into 
the CustTable. 
I have about 50K rows of customer info to import into Ax. Can I import directly 
into the database or should I do this through AX Admin/Data export-import form?
Thanks