Hi,
why do you want to do that?
The table ID is used internally in Dynamics AX to link objects in the
development environment. It is also used to synchronize the data dictionary
from Dynamics AX on the SQL Server. If you change the ID a table synchronizing
the database will give you problems.
The number Sequence uses two sessions (two concurrent users?) to allocate a new
number. Check the eventlogs on the server to see if you have problems with your
license.
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen / Abt. NMT-XD
Senior Product Manager
arvato
Hi Jennifer,
yes I do – I did ☺.
What version are you implementing?
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen / Abt. NMT-XD
Senior Product Manager
arvato systems | Technologies GmbH
An der Autobahn 18
33311 Gütersloh
Hi Jennifer,
there is no standard service to create purchase orders. The service you found
is the purchase requisition that requires a purchase order to work.
You will need to create a new service to be able for create purchase orders.
For a complete listing of the AX standard services please
Hi James,
We are solving that problem for a customer at the moment.
You could check if the batch user is logged on to the SQL server, only that
will not give you the answer you are looking for. The user can be logged on,
and the batch process has crashed, or the user is not logged on, but the
Hi,
the short answer is no. The .net connector from ax does not support forms or
reports.
You would have to start the ax client to open the form. You need to modify ax
to launch a form during startup.
Or you can consider building a .net form and utilize the application
integration framework
Hi,
Hope this helps. Generally we prefer using the Biztalk, but it is always an
budget issue.
a) pros cons of using BizTalk v/s File adapter v/s MSMQ? The BizTalk server
is often mistaken for being a batch engine, if you plan to use the Biztalk
server like that, save your money and use
Hi,
I only know the Return Order Acknowledgement Document within Dynamics AX
2009. I guess that is not what you are looking for, as Dynamics AX 2009 sends
this.
The process you describe we never solve within Dynamics AX, we prefer using the
Biztalk server for that. The process monitoring
HI
Why do you not create a table collection containing your table. You can setup
an Virtual company account containing your table collection. Attach your two
companies to your virtual company account.
Your solution shares the table to all company accounts in the installation.
Mit freundlichen
Hi,
You can take a look at the standard documents (AX 4.0 and 2009).
Inventory Journals AxdProfitLossJournal
Ledger Journals AxdCustPaymJournal.
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen / Abt. NMT-XD
Senior Product Manager
arvato systems | Technologies GmbH
Hallo James,
check the entries in the event log proir to your termination log entry.
Jesper
From: development-axapta@yahoogroups.com
[mailto:development-axa...@yahoogroups.com] On Behalf Of James Flavell
Sent: Dienstag, 3. November 2009 11:53
To: development-axapta@yahoogroups.com
Subject:
Hi,
yes. You have exceeded your license you are missing the license key for
unlimited Company accounts.
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen / Abt. NMT-XD
Senior Product Manager
arvato systems | Technologies GmbH
An der Autobahn 18
33311 Gütersloh
Hi,
Load the macro #Admin
Implement this Method in the class Global
static boolean IsUserInGroup (UserGroupId _GroupId = '', UserId _userId =
CurUserId())
{
#Admin
UserGroupList info;
;
if (!prmisdefault(_groupId))
_groupId = #AdminUserGroup;
return (select recid
Hi,
You are adding the join condition twice
qHeader.addRange(fieldnum(ALPurchReqTable, PurchReqId))
.value(strfmt(' (%1.%2 == %3.%4) ',
purchReqLine_ds.query().dataSourceNo(1).name(),
fieldStr(ALPurchReqLine, PurchReqId),
purchReqLine_ds.query().dataSourceNo(2).name(),
fieldStr(ALPurchReqTable,
HI,
the class Global has a method formHasMethod, to avoid a stack trace at
runtime you might want to check if the caller has the method before you
executes it using object. Object cannot validate the existence of the method
during compilation.
Best regards
Jesper
Von:
HI
Take a look at the form DocuView. Microsoft uses an ActiveX control
Microsoft Web Browser.
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen / Abt. NMT-XD
Senior Product Manager
arvato systems | Technologies GmbH
An der Autobahn 18
33311 Gütersloh
HI
Use the WinApi Class.
WinApi::shellExecute('Notepad.exe');
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen / Abt. NMT-XD
Senior Product Manager
arvato systems | Technologies GmbH
An der Autobahn 18
33311 Gütersloh
Hi,
if you are post 4.0 you should take a look at the AIF components.
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen / Abt. NMT-XD
Senior Product Manager
arvato systems | Technologies GmbH
An der Autobahn 18
33311 Gütersloh
Hi,
Using the excel COM object you can select an range. In the range you can return
the collector Borders and from there the object border.
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen / Abt. NMT-XD
Senior Product Manager
arvato systems | Technologies
HI,
you need an .net SFTP component you can add within Dynamics Ax. (Or an API as
OCX / DLL / Com+ prior to 4.0).
There are several providers for SFTP components. One of them is Eldos
SecureBlackBox.
HI
You are close to the result.
You can't assume, that the counter has the same value as the table id... Try
this.
I have excluded the maps, views, tmptables, and the system tables as well.
static void findGlobalTables(Args _args)
{
Dictionary Dictionary;
HI,
Have fun. You can not print Vertical and horizontal on the same report within
Ax. I solved the problem by writing on a plain text printer, sending the native
printer codes to a barcode printer. Not a nice solution, but it worked.
The best solution is to look for a barcode printing
HI,
is your InventDim there? (InventItemLocation.InventDimId =
InventDim::findOrCreate(inventDim)?
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen / Abt. NMT-XD
Senior Product Manager
arvato systems | Technologies GmbH
An der Autobahn 18
33311 Gütersloh
Hi
Try using the AX Standard way of getting an query for inventory on hand. You
will find that on the table InventDim.
Query query;
QueryRunqueryRun;
inventDimParm inventDimParmCriteria;
inventDimParm inventDimParmGroupby;
InventDim
Try this
catch(Exception::Error)
{
Info(Failed);
}
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen / Abt. NMT-XD
Senior Product Manager
arvato systems | Technologies GmbH
An der Autobahn 18
33311 Gütersloh
[EMAIL PROTECTED]
Hi Letron,
first of all, use SysQuery::findOrCreateRange to get your range.
Use Global:QueryRangeConcat to create your reange value. The syntax is xx1,
xx2, xx3.
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen / Abt. NMT-XD
Senior Product Manager
arvato
HI Morten,
Use cryptoblob2binary and cryptoblob2str from Global.
If you want to protect your data using the WinApi_Server Class
(cryptUnProtectData and cryptProtectData), be aware that the crypt / decrypt
from Windows use a checksum from the machine doing the crypt, you need this
No, select distinct is not implemented in Ax. You can achieve the same with:
Select Field1, Field2 from Table
Group by Field1, Field2
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen / Abt. NMT-XD
Senior Product Manager
Von:
HI,
SQL Backup. The export from Ax only exports one company account. If you mess up
the recid's you are not able to restore the export.
If you need a company based restore you restore your database with a new db
name. In the company accounts you can restore one company from an external
Hi Tore,
You need to add the menuitem to the form CustTable.
Exportfile for AOT version 1.0 or later
Formatversion: 1
***Element: FTM
; Microsoft Dynamics MENUITEM : CustSort unloaded
;
Hi Ricardo,
The User Groups are stored in UserGroupInfo.
The User Groups for a specific user are stored in UserGroupList.
Be aware that the access rights in AX can be setup depending on the domain of
the company account.
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Hi,
I have made a solution for the problem. You need to extract the labels from the
enums in the AOT.
Goes something like this:
public void run()
{
EDAViewWizardEnum viewWizardEnumTable;
EDAViewWizardLanguage viewWizardLanguageTable;
Dictionary
Hallo Trinadh,
this can not work. You will have two applications with differences in the data
model. You need a database for each application.
The US version is part of the sys layer in 4.0.
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen / Abt. NMT-XD
In the online User Form U see the SPID for an Ax user.
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen / Abt. NMT-XD
Senior Product Manager
arvato systems | Technologies GmbH
An der Autobahn 18
33311 Gütersloh
[EMAIL PROTECTED]
HI,
I have crated a form (Quick and Dirty) in 4.0 SP2 based on CustTable that shows
U how to do that.
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen / Abt. NMT-XD
Senior Product Manager
arvato systems | Technologies GmbH
An der Autobahn 18
33311
Hi
Try using the code profiler to identify the problem.
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen / Abt. NMT-XD
Senior Product Manager
Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und
Hi,
just to make sure you does not get a stack trace at runtime you should check if
the Method exists on the caller object.
Object fr ;
Table tt; //
fr = element.caller();
If (formHasMethod(fr,identifierstr(updateControls)) // formHasMethod is
implemented in Global.
tt =
Hi,
You could use the COM class wrapper wizard to implement all objects from a COM
application in Dynamics Ax. You need to review a couple of objects after
wrapping them. The wizard has problems with polymorph objects. The automatic
implementation of e.g. the Range and the selection object
Hi there
I have solved it a bit different, but you would be able to construct your
scenario based on my code.
I got a XML document with the table name or an alias for the table as XML
element, as child elements I got the fields and needs to create a record in
Axapta based on this.
Hi
Try this:
static void Job1(Args _args)
{
SysDictTable dictTable;
SysDictField dictField;
SysDictType dictType;
SysDictEnum dictEnum;
str baseType;
Counter fieldCounter;
Counter arrayCounter;
;
dictTable = new SysDictTable(TableNum(CustTable));
for (fieldCounter =
Hi
Try this
XUtilIdElements::find(UtilElementType::Class, 'ABCBase').id;
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen / Abt. NMT-XD
Entwicklung Axapta
arvato systems | Technologies GmbH
An der Autobahn 18
33311 Gütersloh
[EMAIL PROTECTED]
U can use the configurationkey to determin is a function is active, if you want to query on the licensecode try this.
static void Job2(Args _args)
{
Dictionary dictionary = new Dictionary();
SysConfig sysConfigTemp;
select sysConfigTemp
where sysConfigTemp.id ==
Hi Preety,
You should use the class SalesAutoCreate, or create an extension of it
to meet your demands.
Cheers
Jesper
Von: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] Im Auftrag von Priyank
Krishna
Gesendet: Mittwoch, 19. Oktober 2005 17:43
An:
Hi Herbert,
You can programme the inter company using COM, or use the commerce
gateway and BizTalk in Standard.
If you want the full inter company you need to implement it using COM,
sorry.
/Jesper
_
Von: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED]
Hi Lars,
Sorry but I need to correct you concerning the support of like in Axapta. Axapta does support like.
Try this out.
static void TestLike(Args _args)
{
InventTable it;
;
while select it
where !(it.ItemId like '1*')
{
info(it.ItemId);
}
}
/Jesper
HI Lars,
Take a look at the form SysRecordInfo, The form generates a new form and
uses FormBuildDatasource. I am having problems attaching a new data
source to an existing form at runtime. You can add a new data source,
but you can not attach a table to the data source.
/Jesper
Hi all.
Can I set a field (in a primary index) to case insensitive from within Axapta? I need to build hold the components a as well as A in the index.
My database is set to Latin1_genarel_CP1_CI_AS.
/Jesper
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Hi Herbert,
I know, but in the SQL Server I can set a single row to use a different collation. I an looking for a possibility to control this row property on the SQL server from Axapta.
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen
NMS -
HI,
use SysExcelWorkbooks Open to open an existing file. Workbooks add will always add a new workbook to the existing instance of excel.
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen
NMS - Entwicklung Axapta
arvato systems Technologies GmbH
An der
Hi Herbert
We are working on a module to dynamically convert charters upon import or export from Axapta. You need to substitute an Germany ö to #246; and a Ö to #214; in a XML format (Other scenarios are EBCDICT, ASCII etc.). It would have been nice if I could just change the collation
Hi
You can loop over an enum like this
static void EnumTest(Args _args)
{
SysDictenum dictEnum;
Counter counter;
;
dictEnum = new SysDictEnum(EnumNum(ABC));
for (counter = 0; counter dictEnum.values(); counter++)
{
print dictEnum.index2Name(counter);
}
pause;
}
Hi,
You need to use * in Aaapra.
If you are selecting with wildcards you need to use the keyword like not ==.
/Jesper
Von: Padmaja Iyingar [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 14. März 2005 05:06
An: development-axapta@yahoogroups.com;
Hi Lars,
try this
Table_q.dataSourceNo(1).addDynalink(fieldNum(Table, Field), element.args().record(), fieldnum(callerTable, RelationField) );
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen
NMS - Entwicklung Axapta
arvato systems Technologies
Hi,
You need a handle to the windows process id. The example below gets the ID of Axapta.
DLL user = new DLL('USER32');
DLLFunction getActiveWindow = new DLLFunction(user,'GetActiveWindow');
WINGDI Absi;
;
GetActiveWindow.returns(EXTTYPES::DWORD);
Absi=new
HI
try this
static void SQLStmt_Demo(Args _args)
{
Connection Connection;
Statement Statement;
ResultSet ResultSet;
str myString;
;
// Create a new connection to the Axapta database
connection = new Connection();
// Create a statement for the new connection
Statement =
You get a resultset(Class) from a statement.
You extract a string with the method getstring.
/Jesper
Original Message
Subject: [development-axapta] return sqlstatement to user (12-Nov-2004 13:33)
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Im using the command
Hi Ben,
you get the result correct, but you change the language temporay for the session.
I have solved the problem in the following manner:
add this method to the class SysDictEnum:
LabelId Value2LabelLabel(int value)
{
#Properties
SysDictEnum SysDictEnum;
TreeNode treeNode;
;
return
Hi Bodo,
Take a look the ODBCConnection. I think Claudia Göries wrote an answer last week.
The class conenction always creates an connection to the current Axapta database.
/Jesper
Original Message
Subject: [development-axapta] Catch SQL-Exceptions from CONNECTION Class
Hi all.
Does anybody know a possibility to the SQL case statements in queries?
/Jesper
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/
To unsubscribe from this group,
Hi,
element would be the father object. This is the current control element. If you are in a datasource in a form, this would be the datasource, to address an mothod from the form, you need to address it using element.
/Jesper
Original Message
Subject: [development-axapta]
Hi Akash,
Take a look at the template in word. The statement tries to fetch the first table in the template. Does the template have a table (for quotation lines), and is it the the first table in the template?
// Jesper
Original Message
Subject: [development-axapta] Error
Hi Morten,
cteate a datasource of the table you want to display. If the form is linked you must overwrite the linkActive method. In the Method you add datasource.tmpdata(YourTable). Not the cursor of the datasource points to the tmpData.
Take a look at the form LedgerTransBase in standard
Hi Akash,
The COM Object ComTable in an object in Word (ActiveDocument.Tables). The COM object in Axapta expects to find a table in your template. If not it throws an error unknown. Axapta tries to output the quatation lines in a table.
Take a look at the templete in
Hi Jay,
take a look at the update_recordset statement.
/Jesper
Original Message
Subject: [development-axapta] Speedup my Insert Records Process (22-Jun-2004 6:52)
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Hi Guys,
I am try to Update like 5000 or more records and
Hi Stefan,
you need to clean up the system table SQLDictionary to avoid loosing data when moving objects to a lower ID.
You need to create a class that scan the data dictionary in Axapta and match that to the SQLDictionary on name not on id as the standard.
You can browse the SQLdictionary
HI,
Do you have Axapta tables in the database? If so the Axapta tables should be user tables. If all your tables are system tables you need to change the properties of the table.
If the ownership on the tables is wrong you can eigther use the allready mailed solution to fix it.
Title: Message
You get a error form the faxserver that Axapta can not resolve to a
errormessage.
Check if you get an object of FaxDoc.
/Jesper
Original
Message
processed
by Tobit InfoCenter
Subject:
the class is xinfo method runStartupMenu().
Original Message
Subject: [development-axapta] Startup Menu (18-Mrz-2004 14:36)
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Hi,
Is there someone that knows which class is responsible for composing
the startupmenu. I am
Hi Girish,
could you not use the a batch job?
/Jesper
Original
Message
processed
by Tobit InfoCenter
Subject:
RE:
[development-axapta] want to understand how to create a record in the
The SP3a should only be used with Axapta 3.0 SP2. Check the release notes.
/Jesper
Original Message
Subject: [development-axapta] Re: 45 GB Datebase with SQL2000 (03-Mrz-2004 17:05)
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
I think they work still with SP2. To use SP3a
Title: Meddelelse
Hi.
have you restarted your AOS after updating (and stopping)the Oracle
server?
/Jesper
Original
Message
processed
by Tobit InfoCenter
Subject:
[development-axapta] Regarding AOS
HI,
It is no Problem having interaction before the transaction. I use the class RecordInsertList to avoid using temp tables.
/Jesper
Original Message
Subject: RE: [development-axapta] Transactions with multiple forms (05-Feb-2004 12:06)
From: [EMAIL PROTECTED]
To: [EMAIL
Hi,
check that the two users are both starting in the same language.
If so try this:
1. Shut down the AOS.
2. Delete the file ax122lang.ali
3. Start axapta client on server in 2 tier mode searche any label, Axapta should now recreate the file *.ali if not existing.
4. Start the AOS again.
Title: How to change the filegroups of all the indexes of all tables
Hidden in the development menu you will find a form "SYSSQLSetup" Use this to
change the settings for the filegroups. Then Axapta will also use the settings
doing the synchronization.
/Jesper
As you need to return a real not a record.
static real MyTotal(Date _dd, Code _cc)
{
MyTable myTable;
;
return
(select sum (realfield)
from myTable
where myTable.Date == _dd
myTable.Code == _cc).realfield;
}
/Jesper
Original Message
Subject:
Title: Meddelelse
Hi Mikael,
try deleting the .ali (index file) for the label file, start the application
on the Server in 2-tier mode. Then restart the AOS.
/Jesper
Original
Message
processed
by Tobit InfoCenter
Title: Melding
Mit freundlichen Grüßen / Best regards / Med venlig Hilsen
Jesper
J¢rgensenConsulting
mailto: [EMAIL PROTECTED]
Aston
Business SolutionsGmbHKettelerstr. 3-11D-97222 Würzburg-RimparGermany
Tel.+49-9365-8075-0Fax+49-9365-8075-300
Work with a Winner. Aston Business
77 matches
Mail list logo