correctly.
--- In
Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com,
Agus Riyadi agusa...@... wrote:
Dear All,
Using Ax built-in function WkOfYr I get the following result :
1 Jan 2005 = 53 1 Jan 2006 = 52 1 Jan 2007 = 1 1 Jan 2008 = 1 1 Jan
2009
Dear All,
Using Ax built-in function WkOfYr I get the following result :
1 Jan 2005 = 53 1 Jan 2006 = 52 1 Jan 2007 = 1 1 Jan 2008 = 1 1 Jan 2009
= 1 1 Jan 2010 = 53 1 Jan 2011 = 52 1 Jan 2012 = 52 1 Jan 2013 = 1 1
Jan 2014 = 1 1 Jan 2015 = 1 1 Jan 2016 = 53 1 Jan 2017 = 52 1 Jan 2018
= 1 1 Jan
...@mail.tele.dk wrote:
http://msdn.microsoft.com/en-us/library/aa890352.aspx
2010/7/29 Agus Riyadi agusa...@gmail.com
Dear All,
Using Ax built-in function WkOfYr I get the following result :
1 Jan 2005 = 53 1 Jan 2006 = 52 1 Jan 2007 = 1 1 Jan 2008 = 1 1
Jan 2009 = 1 1 Jan 2010
Hi Donny,
If your actual problem is why it is slow in Ax compared to direct sql in the
database, I suggest you use sql server profiler to capture whether there is
difference between your direct sql and the sql generated by Ax kernel.
Regards,
Agus
On Fri, Jul 9, 2010 at 7:55 AM, mgk915
Hi,
You can see example in the InventTable table insert() method.
Regards,
Agus
On Mon, Jul 5, 2010 at 10:42 AM, sai sharan saisharan@gmail.com wrote:
can u please just send me a sample code for an insert.
On Sun, Jul 4, 2010 at 9:28 PM, Agus Riyadi agusa...@gmail.com wrote:
Hi
Hi,
You can write a class with batch framework (see class
tutorial_runbasebatch), that you set to run every night to check for all
employee that has due one month since the last vacation day update. There
should be a date field in the employee that show what is the last update
date the vacation
not supported in Ax - except for index
constraint which is generated also from the application.
Foreign key relation and delete action constraints are also defined within
the application, not in the database.
Best regards,
Agus Riyadi
On Sat, Jul 3, 2010 at 6:22 PM, sai sharan saisharan@gmail.com
Hi,
As far I know, it is used in SQL Server Analysis Service KPI, which is then
shown in the Role Center / Enterprise Portal page.
Regards,
Agus
On Mon, Jun 28, 2010 at 2:00 PM, Asrar Ahamed asrarsh...@yahoo.com wrote:
These catageories are useful in FRx report tool.
Thanks,
Asrar
---
Hi,
Try open UtilElements and UtilIdElements (AOT System Documentation
Tables UtilElements Right Click Add Ins Table browser).
See if any record using the name there, try delete it and reimport (Always
backup your database first).
Regards,
Agus
On Fri, Jun 11, 2010 at 11:53 AM, abhishek
.
This happen to some users. Another user works just fine on the same
computer. I have deleted usage data of the troubling users but no avail.
Hope someone can show direction on this matter.
Ax 5.0.1000.52
SQL Server 2005 Standard SP2.
Thanks and best regards,
Agus Riyadi
12, 2010 at 1:10 PM, Anitha Santosh mail2eani...@gmail.comwrote:
Agus,
Check if you are able to add a new element to the Base Enum
SysDimension.
Regards,
anithaSantosh
On Mon, Apr 12, 2010 at 10:25 AM, Agus Riyadi agusa...@gmail.com wrote:
Hi Anitha,
Very interesting.
How long
Hi,
Rename can be done quite straightforward in the label properties. There are
one enum (SysDimension) and several *dimension* EDTs which the label need to
be changed. Use find tool to find all objects with that name.
To add new financial dimension,from Ax 4.0 there is add new dimension wizard
with the wizard.
The additional dimensions were created manually .
I guess if we are opting the above method for creating new ones,there is no
need to go for new license concept.
Regards,
AnithaSantosh
On Mon, Apr 12, 2010 at 9:48 AM, Agus Riyadi agusa...@gmail.com wrote:
Hi,
Rename can
not
provide it. :)
Thanks,
Axl
--- In
Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com,
Agus Riyadi agusa...@... wrote:
Hi,
We met this similar kind of requirement and the only solution that we
found
was to modify the Aging report.
Best
Hi,
We met this similar kind of requirement and the only solution that we found
was to modify the Aging report.
Best Regards,
Agus
On Wed, Apr 7, 2010 at 11:00 AM, axaeffect axaeff...@yahoo.com.sg wrote:
Hi all,
In report customer aging (A/R - reports - Status - Aging report), is
there
Hi,
It is enough. Note that Ax backup using data export (.dat) is company
specific data and cannot be used during disaster recovery when there is a
problem with the database.
Also it is better if you do daily database full backup and transaction log
backup (can be hourly during not busy hours)
reject adding new index column as it
has 16 index key column limit.
Can anyone help ? Or does it mean we have only maximum 3 custom inventory
dimension in Ax 2009?
Thanks and best regards,
Agus Riyadi
Hi,
Open Administration Setup Server configuration.
Check if on the right after AOS name, there is column 'Is batch server'
activated.
Regards,
Agus
On Fri, Aug 7, 2009 at 12:11 PM, Anitha S mail2eani...@gmail.com wrote:
Hi,
It is not necessary you should use the tutorial form.
When
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.com wrote:
When I do a mass update for my movement journal I receive the following
error: Cannot receive
Dear All,
Ax2009 SP1.
We have problem that many users are still online while they are actually has
exit Ax. The session cannot be ended using end session in the online users
form.
This cause problems as online ending-blocked status still consume
concurrent users allowed by license so no more user
.
Thanks for your time.
Agus
On Tue, Jun 2, 2009 at 3:50 PM, Agus Riyadi agusa...@gmail.com wrote:
Dear All,
Ax2009 SP1.
We have problem that many users are still online while they are actually
has exit Ax. The session cannot be ended using end session in the online
users form.
This cause
Hi,
Using query classes you can do that.
e.g.
q = new Query();
ds = q.addDataSource(tablenum(projInvoiceEmpl));
ds.addSelectionField(fieldnum(projInvoiceEmpl,qty),SelectionField::Sum);
ds.addSortField(*fieldnum(projInvoiceEmpl,categoryid)*);
Hi,
Try create the new db for Ax by using Ax installer. It will make sure any
required permisson settings and initial objects are created properly with
the correct version.
Regards,
Agus
On Tue, May 12, 2009 at 2:37 PM, kardo_ax kardo...@yahoo.com wrote:
i have created a new DB in sql
Hi,
Use
Global::roundup() or just roundup()
Regards,
Agus
On Thu, May 7, 2009 at 5:43 PM, Tom Scott
tom.sc...@britishceramictile.comwrote:
Hi, I was wondering if there is a ceiling (i.e. round up) function in
X++. I have tried playing with the round() function but I haven't managed to
-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com,
Agus Riyadi agusa...@... wrote:
Hi All,
Ax document recommends that domain account that is used as business
connector proxy should be set with the following option :
- password does not expire
- no interactive
Hi All,
Ax document recommends that domain account that is used as business
connector proxy should be set with the following option :
- password does not expire
- no interactive logon rights
However I can't find the second option 'no interactive logon rights', both
in Windows 2000 and Windows
Of *Agus Riyadi
*Sent:* 04 March 2009 07:27
*To:* axapta-knowledge-village
*Subject:* [Axapta-Knowledge-Village] Create index with first column not
dataareaid
Dear all,
Using sql server database engine tuning advisor, I got a recommendation to
add new index with the following scheme
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:* Agus Riyadi agusa...@gmail.com
*To:* axapta-knowledge-village Axapta-Knowledge-Village
--
*From:* Axapta-Knowledge-Village@yahoogroups.com [mailto:
axapta-knowledge-vill...@yahoogroups.com] *On Behalf Of *Agus Riyadi
*Sent:* 05 March 2009 11:33
*To:* Axapta-Knowledge-Village@yahoogroups.com
*Subject:* Re: [Axapta-Knowledge-Village] Create index
, 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: Agus Riyadi agusa...@gmail.com
To: Axapta-Knowledge-Village
Hi,
You can use runbuf function.
Regards,
Agus
On Wed, Mar 4, 2009 at 12:50 PM, Sumit Loya loya.su...@gmail.com wrote:
Hi,
You can create a method in Global class where it evaluates your expression
and pass all the variable values as parameters...
This way you can call this method
Hi All,
I found a bug in AX 3.0 SP6 client where it produce wrong date value in
ReportOutputUser.writeDate() method.
For example for a date value 11/11/2008 it produces arbitrary value in excel
like below :
39/CL/2064 40/CL/2000 38/2/1984 41/CL/2104
There is no particular pattern what value
Dear All,
My instance is AX30SP6 with SQL Server 2005.
Please let me know if you have experienced and know what is the solution for
the following error.
[Microsoft][ODBC SQL Server Driver]Connection is busy with results for
another hstmt. The SQL statement was: INSERT INTO REQPO…
Hi,
You can try using sql server profiler (if you use sql server) to capture
what data are going to be inserted, and check what table is it and which
unique index of the table is being affected.
Regards,
Agus
On Fri, Sep 12, 2008 at 10:59 AM, naveed ali [EMAIL PROTECTED]wrote:
Hi,
Hi,
Try change your class to run on server or client which one works.
Regards,
Agus
On Fri, Mar 14, 2008 at 1:34 PM, Pankaj Gupta [EMAIL PROTECTED] wrote:
Hi.
I have a requirement where I need to store a text file on client's
computer which is on same network,
I m using AsciiIo class
Hi,
When I open Master planning planned order inquiries explosion, then
open the gantt tab I get this error message :
FormActiveXObject does not have method 'worldview'.
I use AX40SP2 and the latest vcgantt.ocx (3.200.3311.26).
Any help?
Thanks,
Agus
[Non-text portions of this message
Hi,
This is because I missed some scripts to update empty string data. During
new record creation it calls initFromXX where the source table has some
square characters.
This question is closed. Thanks everyone!
Regards,
Agus
On Dec 12, 2007 6:19 PM, Agus Riyadi [EMAIL PROTECTED] wrote:
Hi
,
Agus Riyadi [EMAIL PROTECTED] agusacil%40gmail.com wrote:
Hi,
I experienced strange behavior after upgrade axapta from 3.0 SP1 to 4.0SP2.
When creating new record in purchase order, many string fields got square
character (hexa 02) value after I selected vendor account.
This does not happen
Hi,
I experienced strange behavior after upgrade axapta from 3.0 SP1 to 4.0 SP2.
When creating new record in purchase order, many string fields got square
character (hexa 02) value after I selected vendor account.
This does not happen to other tables.
Any suggestions ?
Thanks and best regards,
Hi,
I guess you need to create a page footer instead of grand total footer.
- Have Generated Design created.
- Then copy all sum controls from grand total footer into your own page
footer, remove the grand total footer.
- Set the page footer auto declaration to yes
- Override the fetch method,
Hi,
We once had similar requirement as you. It need modification on the
CustCreditLimit class, started on the check() method.
Regards,
Agus
On 9/24/07, Sumit Loya [EMAIL PROTECTED] wrote:
Hi Neeraj,
If you are having parent-child relationship b/w different customers, then
u
may be
Hi,
I don't have knowledge on electronic banking but a discussion with a
colleage told me that one possibility is to use integration server such as
BizTalk. Using that integration server Axapta can 'talk' to many different
system.
Please share if you get any progress.
Regards,
Agus
On
and in which
format it receives the data it is not mentioned. Please guide me how it
will
work.
Regards,
Mukesh
On 9/20/07, Agus Riyadi [EMAIL PROTECTED] agusacil%40gmail.com wrote:
Hi,
I don't have knowledge on electronic banking but a discussion with a
colleage told me that one
!!
Shahzad Butt
From:
Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
[mailto:Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com]
On Behalf Of Agus
Riyadi
Sent: 11 September 2007 11:04
[mailto:Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com]
On Behalf Of Agus
Riyadi
Sent: 11 September 2007 05:16
To: axapta-knowledge-village
Subject: [Axapta-Knowledge-Village] EP Passing parameter to report
displayed as web output content item
Dear All,
I have
Hi Ricardo,
Use DictTable and DictField classes.
Regards,
Agus
On 9/10/07, ricardodegouveia [EMAIL PROTECTED] wrote:
Hi i'm trying to find out how in the emplTable or any table which
fields are in the table, in other words i want to check if in code
eg. field name = Race is a field in
Dear All,
I have a webform which has some value that I need to send to a standard
report displayed as web report upon closedOk().
Here is my code :
weblink = new weblink();
webUrlMenuFunction = new WebUrlMenuFunction(weburlitemstr(myReport));
weblink.parm(my parameter);
/mysite was not created correctly. Exception: No
.NET Business Connector session could be found.
I have created the business connector configuraton (Non interactive use
only) as suggested but still no avail.
Can anyone help what's wrong ?
Regards,
Agus
On 8/16/07, Agus Riyadi [EMAIL PROTECTED
Further inverstigation on the event log I found :
Rpc error : RPC exception 1727 occurred in session 0.
I am using Win 2003 SP1, AX40SP1, Windows Share Point Services 2.
Has anyone experienced this before ?
Regards,
Agus
On 8/20/07, Agus Riyadi [EMAIL PROTECTED] wrote:
Hi All,
I search
Hi Ricky,
You can put a breakpoint at EmplTable.insert() method to see which class
used.
Regards,
Agus
On 7/24/07, ricardodegouveia [EMAIL PROTECTED] wrote:
i'm struggling the class that are used when you create a new employee?
i know that purchFormLetter and salesFormLetter are used for
Hi Amir,
If you are affiliated to a partner, you may have What's new documents (both
functional and technical).
Those explain the difference between Ax 4.0 and 3.0.
I don't know about SP6.
Regards,
Agus
On 7/15/07, Amin Khan [EMAIL PROTECTED] wrote:
hi friends
can any body help me
if the user is a member of 1 group
(this.configurationKeyId() !isConfigurationkeyEnabled(
this.configurationKeyId(
return false;
return true;
}
Regards,
Agus
On 7/5/07, Agus Riyadi [EMAIL PROTECTED] wrote:
Hi All,
How do we set security permission for temporary table
Hi All,
How do we set security permission for temporary table that has security key
property?
I can't find TmpInventTransWMS table below Invent tables in the security
hierarchy as the properties suggested.
Any help would be appreciated.
Regards,
Agus
[Non-text portions of this message have
Hi All,
I need to import csv file into a table using definition group of type
custom.
The table has string field that allow multiline (e.g. item description), so
there could be newline character in the field value.
The problem is when I try to put newline character in the csv file, it is
Hi Ton,
Set the properties FetchMode to 1:1 to the second and third data source.
Regards,
Agus
On 6/8/07, axaeffect [EMAIL PROTECTED] wrote:
hi kamal,
Thx, I already know the relation, the problem is when I use
QueryBuildDataSource, after I create the first Query (InventDim), add
new
Hi Pragashnee,
Once I experienced the similar problem. We have client that need to add more
share tables after go live.
Axapta doesn't directly recognize the shared tables as we expected. I don't
really sure which step that make it correct but I did these ways :
- export out all existing data
Hi All,
Has any of you experienced this error message :
Error Message (14:12:55) Failed loading assembly
Microsoft.Dynamics.EP.Deployment, Version=4.0.0.0, Culture=neutral,
PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL
Error Message (14:12:55) Failed loading assembly
Hi James,
Any container typed is stored as image data type in SQL Server database so
it is variable sized with maximum size of 2 GB.
Don't how it is implemented in Oracle.
Regards,
Agus
On 5/19/07, James Flavell [EMAIL PROTECTED] wrote:
Hi everyone,
I was wondering if I use the
Has nobody succeeded setting up web application connecting to Ax 4.0 ?
It would be very helpful if you can share the tips.
Regards,
Agus
On 5/1/07, Agus Riyadi [EMAIL PROTECTED] wrote:
Hi Arijit,
Thanks for your reply.
I have managed it works with windows application, but my problem
Hi Thanks for your response,
I am using Ax 4.0 SP1.
Regards,
Agus
On 5/1/07, Arijit Basu [EMAIL PROTECTED] wrote:
Hi Agus,
Can you tell me if you are using AX 3.0 or AX 4.x??
Arijit Basu
On 5/1/07, Agus Riyadi [EMAIL PROTECTED] agusacil%40gmail.com wrote:
Hi All,
I have
Hi All,
I experienced unbalance error when tried to settle an invoice to prepayment
(a foreign transaction), in which prepayment and invoice use different exch
rate.
Anyone have a fix on it or know how to amend on Ax 3.0 ?
I use Ax 3.0 SP5.
Thanks and regards,
Agus
[Non-text portions of
Hi Enrique,
It is not recommended to use two applications with one DB.
You will get problem if one object (table / view) exist in one application
but doesn't in the other. When you open Axapta from the application that
doesn't have the object then it will delete the objects phsyically from the
Dear All,
I wonder why some clients of our network can't run Ax 4.0 using run as
command while some others can.
Currently we are used to login with local client credential. When need to
connect an Ax 4.0 instance in the network, we just right click Dynamic
client select run as, specify network
Hi Amer,
That should work, and Axapta class can not directly assign to member
variable, use parameter method instead. You also need to instantiate the
Args object.
Regards,
Agus
On 1/17/07, Amer Adnan [EMAIL PROTECTED] wrote:
Dears,
How can I pass a value from the args in the main(Args
Hi All,
Why sales order picking list can't exceed qty ordered ? while packing slip
can ?
I need to pick qty more than qty ordered (but at maximum qty ordered + over
delivery pct) but can not. In packing slip it can be done.
Why doesn't Axapta allow this?
Thanks,
Agus
[Non-text portions of
Hi All,
Is there any setting or workaround so that user can have a login screen in
Axapta 4.0 like in 3.0 ?
Thanks,
Agus
[Non-text portions of this message have been removed]
explanation (only a simple sample silent installation script).
Please help if any of you have a better way to mass install client without
web deployment.
Thanks,
Agus
On 12/8/06, Agus Riyadi [EMAIL PROTECTED] wrote:
Hi All,
I setup a web deployment. I open web browser in a client and successfully
Hi All,
I setup a web deployment. I open web browser in a client and successfully
install activeX and the client setup.
However, it failed when try installing service pack.
My Configuration is :
Computer name : AOS
Web deployment root directory C:\AxWebDeploy with virtual directory named
Hi Jay,
Did u set up record level security for the user ?
Regards,
Agus
On 12/8/06, jay_naik_99 [EMAIL PROTECTED] wrote:
Hi Can anyone help me answering this query.
Regards,
Jay
--- In
Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com,
jay_naik_99
-Knowledge-Village%40yahoogroups.com, Agus Riyadi
[EMAIL PROTECTED] wrote:
Hi Agus,
Yes. I just did. compile and compile forward as you suggested.
However, the error still occur.
THanks,
Patrick
Hi,
Have u try compile or compile forward (add ins compile forward) ?
Regards
Hi,
Have u try compile or compile forward (add ins compile forward) ?
Regards,
Agus
On 12/5/06, chuapatrickd [EMAIL PROTECTED] wrote:
Hi to all,
I'm encountering an error when running my class which extend the
runbaseReport base class. The error message Iv'e got is
Error executing
Hi Faiqa,
You can enlarge the string width of Ledger Account through AccountNum
Extended Data Type ( I don't know whether Gread Plains use the same concept
of EDT or not - never use it).
It is converted into varchar data type in the physical database which means
you can set it to maxium of 8000
Hi,
If I understand you correctly, you can are trying to create an inquiry form
that will display sum qty of sale line group by item group. This inquiry
form is then called from sales order.
That can be achieved by creating view of three tables, salesline,
inventtable and inventitemgroup.
This
thank you
Agus Riyadi [EMAIL PROTECTED] wrote:
Hi,
Not clear with your requirement. There is doc handling in axapta.
Regards,
Agus
On 3/23/06, niphawan sungnoi [EMAIL PROTECTED] wrote:
dear all
who can use attach file
Hi Subbu,
I am also interested to take a look how it works.
Would you please send me an email too :-)
Thanks,
Agus
On 3/31/06, Subrahmanyam, Mamidi [EMAIL PROTECTED] wrote:
Hi Steve Sir,
I apolozise for this dely as I am travelling.
I did this in previous project ( employer ) and I sent
Hi Rick,
Yes, I faced the same problem and have not found any clue.
Regards,
Agus
On 3/27/06, saykai83 [EMAIL PROTECTED] wrote:
Hi all,
Any of you facing the problem selecting query in on-hand inventory
report ( Inventory management reports on-hand on-hans inventory ).
This is due
Hi,
Not clear with your requirement. There is doc handling in axapta.
Regards,
Agus
On 3/23/06, niphawan sungnoi [EMAIL PROTECTED] wrote:
dear all
who can use attach file on axapta
thank you
There is also system monitoring tools under Tools Development tools
System Monitoring.
This tools display database activity. When running in three-tier it also
display AOS activity, where we can examine traffic load and tune our
code if necessary.
Regards,
Agus Riyadi
-Original Message
Hi Anton,
You can use Axapta OLAP for that purpose.
This requires MS Analysis Services SP3 installed.
Regards,
Agus
-Original Message-
From: Anton Tjiptadi [mailto:[EMAIL PROTECTED]
Sent: 30 Maret 2005 9:27
To: Axapta-Knowledge-Village@yahoogroups.com
Subject:
reply, but I guess I can't try it 'cause my
company didn't buy the 'OLAP' things hahaha
--- In Axapta-Knowledge-Village@yahoogroups.com, Agus Riyadi
[EMAIL PROTECTED] wrote:
Hi Anton,
You can use Axapta OLAP for that purpose.
This requires MS Analysis Services SP3 installed.
Regards
Joy,
If you combine two different layers into one application, there will
be the outmost layer that is run by axapta. If you have an object
with two layers customization (i.e var and usr), and you login with
usr layer, you will get the usr layer. If you login in var layer, you
will get the
Probably it is a problem with your SysDataImport class. Have you
update it ? I have it if you need.
Agus
--- In [EMAIL PROTECTED], Danny Gaethofs
[EMAIL PROTECTED] wrote:
Dear all,
I have exported data import/export definitions from my development
database.
When importing my data
Hi Morris,
You can put a combobox, set its lookup property to always, set its
extended data type property to the same extended data type with the
field you want to display.
Then you should override its lookup method. There are various
examples of 'creating your own lookup form' in the
Yes, the password is encrypted. It is Dictionary.buildPassword()
method that encrypt it.
I think we can not know how axapta doing the encryption. I don't have
idea of decrypting it.
Maybe someone expert in security area can help you.
Regards,
Agus
--- In [EMAIL PROTECTED], Joel WU
[EMAIL
General Ledger Setup Financial Statement
Click columns, then in the Formatting Tab, set the show zero property.
choose no
regards,
agus
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thu 8/26/2004 9:48 PM
To: [EMAIL PROTECTED]
Subject:
85 matches
Mail list logo