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] 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

[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

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

RE: [Axapta-Knowledge-Village] Temp tables

[Harry Deshpande]

Everything going well on this side of the world. :)

There is an easy way to figure out whether the code is running on server, I 
think there is a variable/function called isAOS or something like that. I don't 
have access to a system right now, but you can search for it.

I agree with Moris regarding sum() function on temp tables, they will get 
degraded.

Regards

harry




From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of James Flavell
Sent: Friday, July 30, 2010 10:26 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Temp tables


Hi and thanks Harry for that, never thought to try it that way :)

Thanks and good to hear from you after so long, hope things are well with you 
and your family :)

From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Harry Deshpande
Sent: 31 July 2010 13:14
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Temp tables



The easiest way I can think of is, Write a method on the table, put a 
breakpoint. On the AOS configuration disable breakpoints running on server. Now 
execute the method, if it hits the break point then it is running on client 
otherwise on server.

Regards

Harry


From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of James Flavell
Sent: Friday, July 30, 2010 10:05 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Temp tables


Hi everyone once again

Can someone tell me for temp tables in AX2009 are they for sure always 
created/stored and processed on the AOS server?

Supposedly http://www.axaptapedia.com/Temporary_tables says the temp table is 
put on the hard disk of server or client based on where the first record is 
inserted.

In AX2009 I assume all code is executed on the server but am not 100% ... I am 
thinking the code in a form might well be executed on the client and hence my 
temp table end up on the client!???

My specific situation is to do with Arrival Overview form that populates some 
temp tables.

Is there any way I can check or test where the temp table is being created?

Thanks as ever
James

RE: [Axapta-Knowledge-Village] Temp tables

[Harry Deshpande]

The easiest way I can think of is, Write a method on the table, put a 
breakpoint. On the AOS configuration disable breakpoints running on server. Now 
execute the method, if it hits the break point then it is running on client 
otherwise on server.

Regards

Harry


From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of James Flavell
Sent: Friday, July 30, 2010 10:05 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Temp tables


Hi everyone once again

Can someone tell me for temp tables in AX2009 are they for sure always 
created/stored and processed on the AOS server?

Supposedly http://www.axaptapedia.com/Temporary_tables says the temp table is 
put on the hard disk of server or client based on where the first record is 
inserted.

In AX2009 I assume all code is executed on the server but am not 100% ... I am 
thinking the code in a form might well be executed on the client and hence my 
temp table end up on the client!???

My specific situation is to do with Arrival Overview form that populates some 
temp tables.

Is there any way I can check or test where the temp table is being created?

Thanks as ever
James

RE: [Axapta-Knowledge-Village] Batch helper in master scheduling

[Harry Deshpande]

There must be a white paper on batch heler, did u check partnersource?

Regards

harry

From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Henry Charles
Sent: Tuesday, July 20, 2010 8:36 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Batch helper in master scheduling


Hi All,

Have anyone ever try to use batch helper in master scheduling?  Is it working? 
Because I’ve tried several times to request batch helper when running master 
scheduling but when I see the log for master scheduling plan, no actual helper 
was given.

Please kindly give your thought. Thanks

Regards,
Henry

RE: [Axapta-Knowledge-Village] Ax2009 Upgrade Issue

[Harry Deshpande]

Did u check the event log? Upgrade runs in batch and errors will be logged in 
event log and not infolog.

Regards

harry

From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Pankaj Kant
Sent: Sunday, February 28, 2010 9:47 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Ax2009 Upgrade Issue [1 Attachment]


[Attachment(s) from Pankaj Kant included below]
Hi Every One

We have  tried even put the debugger but the issue is that it appears the 
system is not going ahead at all
Its throwing error in job no 24  (like Audit trail setup etc...PFA screen shot 
s) here it's trying to disable the index and it's failing to do. View job error 
button is not working. When we click reload scripts button its marking all the 
24 failed jobs to finished status and rerunning the remaining jobs results in 
Ready - Waiting Stage and after a while Run button is getting enabled again. 
Finally we are getting a infolog message 'No jobs are ready or executing, and 
no jobs can be moved to batch queue. Select the error and rerun job'

This seems to be a product problem, as is getting stuck at very beginning 
itself and when it's trying to disable index on base tables, where we don't 
have any customizations on it.
Any Pointers/ suggestions   which help us is analyzing the issue are appreciated


Thanks in advance
Pankaj



From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Arijit Basu
Sent: Sunday, February 28, 2010 12:01 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Ax2009 Upgrade Issue


Hi Imran,
   AX 4.0 can be upgraded to AX 2009. The issue may be somewhere else.
On Sun, Feb 28, 2010 at 11:00 AM, Imran Raza Niazi 
nadi_jabi...@yahoo.commailto:nadi_jabi...@yahoo.com wrote:

Dear,

i think AX04 is not upgrade with AX2009. install a fresh ax2009
Regards:

Imran Raza

00966544139262


--- On Wed, 2/24/10, Pankaj Kant 
pankaj_k...@infosys.commailto:pankaj_k...@infosys.com wrote:

From: Pankaj Kant pankaj_k...@infosys.commailto:pankaj_k...@infosys.com
Subject: [Axapta-Knowledge-Village] Ax2009 Upgrade Issue
To: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village@yahoogroups.com
 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village@yahoogroups.com
Date: Wednesday, February 24, 2010, 5:03 AM

Hi Every One

We are  upgrading Ax4.0 Sp1  instance to Ax 2009.I completed Application
upgrade. Now I am stuck in DB upgrade ,presynch step(After 11 % completion ,its 
not
proceeding further), I don't Have any idea why it is not going ahead

Please find below the steps which I had done so far :

1)Installed Ax 2009  (Pointed to Ax 4.0 DB ,service is not started at this
point).
2)Installed Ax 2009 Sp1(service is not started at this point)
3)Copied the upgraded aods
4)Started the service
5)Completed the steps in Upgrade Check list till Presynch...

There are around 214 jobs in Presynch ,but after the 25th job its not
proceeding and its not showing any error also..remaining jobs are moving to
'Waiting' status.

I request the group members to throw some light on this issue

Thanks in Advance

Pankaj






--


Arijit Basu

RE: [Axapta-Knowledge-Village] Master Planning

[Harry Deshpande]

You will need to increase the coverage time fence that is found on item 
coverage group and which can be overridden on master plan setup

Regards

harry

From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Khalil Rehman
Sent: Wednesday, February 10, 2010 4:15 AM
To: Knowlege Village; Development Axapta
Subject: [Axapta-Knowledge-Village] Master Planning



Dear all,

   i want to know how to increase the coverage days for SO  PO. because 
whenever i run my master scheduling in Periodics it gives me only 45 to 60 
days. i want to increase it upto 180 days.

thanks  best regards.




[http://graphics.hotmail.com/i.p.emrose.gif]  KHALIL UR REHMAN  
[http://graphics.hotmail.com/i.p.emrose.gif]



Your E-mail and More On-the-Go. Get Windows Live Hotmail Free. Sign up 
now.https://signup.live.com/signup.aspx?id=60969

RE: [Axapta-Knowledge-Village] pack and unpack a query object

[Harry Deshpande]

public boolean unpack(container packedClass)
{
Integer version= conpeek(packedClass,1);
container   packedQuery;
container   base;

switch (version)
{
case #CurrentVersion:
[version,base,packedQuery] = packedClass;
super(base);
if (packedQuery  conlen(packedQuery) == 1)
{
query = new QueryRun(packedQuery);
}
break;
default:
return false;
}
return true;
}

From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of giridharraj
Sent: Tuesday, February 09, 2010 11:13 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] pack and unpack a query object



Hi,

I have seen a method query.pack() which returns a container. Is there any 
method which unpacks it i.e., converts back to a query object because i didn't 
find query.unpack().

Simply I want a method which converts a query object to a container and that 
container to be converted into a query object.

Can anybody help me in this...

Regards,
giridhar Raj.

RE: [Axapta-Knowledge-Village] AX - Codes

[Harry Deshpande]

I had a similar problem when I started on Ax. No knowledge of programming 
whatsoever.

My advice?


1.   Get functional certifications, this will help you to understand code 
quickly. The problem with object oriented programming is one has to understand 
the objects completely. Being functionally aware speeds up this process.

2.   Debugger is your friend. Whenever someone reports any problem on this 
forum, start debugging the issue.

Regards

harry

From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Khan Axapta
Sent: Wednesday, February 03, 2010 6:42 AM
To: AX Knowledge; development axapta
Subject: [Axapta-Knowledge-Village] AX - Codes


Hi friends,

I am new to AX with some programing knowledge.
Can you please send me some small AX Codes used in real time or which you have 
developed for me to  refer and proceed.

Thanks in advance.

Regards,
AX

RE: [Axapta-Knowledge-Village] DAX 2009 INSTALLATION

[Harry Deshpande]

Looks like you are good to go! Exactly what problems are you facing while 
installing Ax?

Exactly

From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Irshad
Sent: Monday, January 18, 2010 10:54 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] DAX 2009 INSTALLATION


Hi All

i am new to Axapta world. though i can work in some of the modules in supply 
chain management but company has provided the limted access on AX.

i have DAX 2009 software and i want to install it in my laptop. i tried my best 
to install with the help of provided manual which is compilcated to understand 
for me. is there anyone who can help me for installation of DAX 2009. i already 
have installed windows 2003 server R2 in virtual machine and domain is also 
created. can any one help me online though skype or MSN Messenger or Yahoo 
Messenger or Google Talk for installation and configuration of Dynamics AX 
2009. this would be greate support to me. i have following softwares:

1.Dynamics AX 2009
2.SQL Server 2005  2008
3.microsoft sharepoint 2007
4. .Net 3.2 service pack 2
5. SDK

is there anything left behind? if yes kindly let me know so that i can arrange 
the missing software. in its reward i can provide the DAX 2009 and other tools.

thanks  regards,
Irshad

RE: [Axapta-Knowledge-Village] Master Planning

[Harry Deshpande]

You will need to exclude the sales order during 'insert data' phase.

Regards

harry

From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Alaa Assem
Sent: Monday, December 15, 2008 3:19 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Master Planning

Hi everyone,
In my case I  need to change the statues of the sales order in AX 4.0 to be 
held or something like that, from being considered in master planning.

Ex.
Item X
Customer Y
Sales Order Z

Customer Y made an order Z for item X with Qty of 1000, problem happened with 
Customer Y that should prevent him from taking his item X, when running master 
planning with regeneration option, I don't want item X to be appeared in the 
planned production orders!!
Is it possible to held the order, the item or the customer from being appeared 
in the planned production orders, so I won't put it in the production plan.

Please any help would be very appreciated, thanks
Alaa Assem

RE: [Axapta-Knowledge-Village] Compare layers sucks

[Harry Deshpande]

What is 'lot of differences'? Are they real differences? There is a setup tab 
on 'compare' form, try playing around with the values on this tab.

Regards

harry

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of James Flavell
Sent: Wednesday, December 10, 2008 6:58 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Compare layers sucks

Can anyone help explain when I take a AXVAR.AOD and copy it into the old folder 
and then do Tools/DevTools/Version update/compare layers and compare VAR and 
Old VAR that it comes up with lots of differences!!!

The VAR and old VAR are exactly the same

Even I do individual compare of an object its shows a lot of difference
Do I need to put the SYS and SYP also in the old folder? I dont think so right?

I am trying on AX4.0 SP2

Thanks
James

RE: [Axapta-Knowledge-Village] Re: Grouping of production orders for planning

[Harry Deshpande]

 maybe 30 different FG to be produced and then 
delivered on a certain date. They want to do the picking of all the material at 
the same time for all 30 Productions as well as do the 30 production ordrs 
together so they can then ship them out all together at the correct date.

All the production orders are pretty much involving only human labour and 
therefore there is not real machine constraints. So the customer would like all 
30 production orders to be 'together' in the scheduling then the shop floor 
(assembly) can just go and start any of them and then move on to the next one 
until they are all finished and then the project can be shipped out

Thanks
James





From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge- 
[EMAIL PROTECTED] ups.com] On Behalf Of Harry Deshpande
Sent: 27 November 2008 00:57
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: RE: [Axapta-Knowledge- Village] Re: Grouping of production orders for 
planning
I am not sure of what you are saying. Did you try 'limited by materials' 
checkbox while scheduling production orders?
Regards
Harry
From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge- 
[EMAIL PROTECTED] ups.com] On Behalf Of James Flavell
Sent: Wednesday, November 26, 2008 1:19 AM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: RE: [Axapta-Knowledge- Village] Re: Grouping of production orders for 
planning
Thanks Harry
Kind of getting you although probably not 100%
The production orders planned start date should be based on when the material 
is available
If the material is delayed then the start date of the production orders should 
be delayed and the user warned if they will miss the delivery date
I believe this is how the master planning is doing in AX (for single item) if 
everything is still in the planned status. But once firmed then I think AX 
master planning does not really give a good indication to the user
Thanks
James

From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge- 
[EMAIL PROTECTED] ups.com] On Behalf Of Harry Deshpande
Sent: 24 November 2008 12:22
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: RE: [Axapta-Knowledge- Village] Re: Grouping of production orders for 
planning
Hi James
Planned prod orders during coverage are scheduled backward from delivery date 
and during futures are scheduled forward from requirement date.
In theory planned prod orders at (only for products at level 0) can be 
scheduled forward from some date however what do you want to do in case such 
products cannot be manufactured before the delivery date?
Regards
Harry
From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge- 
[EMAIL PROTECTED] ups.com] On Behalf Of James Flavell
Sent: Sunday, November 23, 2008 5:31 PM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: RE: [Axapta-Knowledge- Village] Re: Grouping of production orders for 
planning
Thanks Sayeed,
I think maybe I didnt make it clear that each production order is for different 
items.  I dont think the grouping you are talking about works in this case 
right?
Thanks
James

From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge- 
[EMAIL PROTECTED] ups.com] On Behalf Of ax_con
Sent: 23 November 2008 16:38
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: [Axapta-Knowledge- Village] Re: Grouping of production orders for 
planning
HI James,

The planned production orders can be merged as one group, or one
production order from the Planned orders form...but once these orders
are firmed you can split them but cannot merge...

Hope this helps

Regards

Sayeed

--- In Axapta-Knowledge- [EMAIL PROTECTED] 
ups.commailto:Axapta-Knowledge-Village%40yahoogroups.com, James Flavell
[EMAIL PROTECTED] wrote:

 Good morning everyone

 I am not a master planning or production expert so not sure if my
 requirement is available in std AX. If it is not I would for sure
appreciate
 hearing from anyone who has considered or managed to address the
 requirement.

 What I need to be able to do is group all production orders for a
given
 sales order so that master planning plans them all for the same
start date.
 So if I have 10 production orders that master planning treats them
as one
 and works out the latest delivery date of any of the 10s components
and then
 plans that all 10 will start at that time (even if for some of the
 production orders master planning can see they could start
earlier). Of
 course following on from this would be to have all the planned
purchase
 orders suggested based on the start date of the grouped production
order etc

 I believe this is quite a difficult thing to do but would like to
know if
 there is anyway (std or otherwise)

 Thanks
 James






Add more friends to your messenger and enjoy! Invite them 
now.http://in.rd.yahoo.com

RE: [Axapta-Knowledge-Village] Editor Mumbai (Times of India)

[Harry Deshpande]

I hope you realize that moderator is going to restrict your posting going 
forward. I bet you forwarded this email to everyone in your contacts list.

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of visti Sethna
Sent: Wednesday, December 03, 2008 3:27 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; ANWAR MOHD JAMIL; 
APTE BHAGYASHREE VASANT; Sawant Ashok Sawant Atmaram; Bakshi Aroon; 
Seetharaman. A. R; [EMAIL PROTECTED]; [EMAIL PROTECTED]; Arun; Ashwani Kumar; 
[EMAIL PROTECTED]; aks s; Altaf Ansari; MADYAPGOL SANDEEP BHIMRAO; Zubin F. 
Bharucha; Babulal Panchal; benaz gazder; Mithra Birdie; Narendra Bahadur Singh; 
Nowzi [EMAIL PROTECTED]@ - Born to rule!!!; Parizad Buchia; Pushpinder Bhatia; 
[EMAIL PROTECTED]; [EMAIL PROTECTED]; D'CUNHA KINGSLEY GASPER; CHAUDHARI SAMIR 
SUBHASH; [EMAIL PROTECTED]; [EMAIL PROTECTED]; 
Axapta-Knowledge-Village@yahoogroups.com; CA. Pari Kanga; [EMAIL PROTECTED]; 
Neeraj Chutani; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL 
PROTECTED]; [EMAIL PROTECTED]; JOSHI MILIND DATTATREY; D .; Danesh Meher Palia; 
Daruwala, Jimmy
Cc: Dhananjay Suryavanshi; Dharmendra Supeda; Dilshad .S.; Dilshad Ukaji; 
FARISHTA DAVER; Homyar Desai; Kaizad Driver; Edward Fernandes; [EMAIL 
PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; percy f n; 
[EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; 
[EMAIL PROTECTED]; Gomes Linus Terrance; Kasekar Girish V; , Viraf H. Saher; 
hufriz talati; hormuzd daruwalla; [EMAIL PROTECTED]; Benaifer H Bhathena; 
[EMAIL PROTECTED]; harman preet singh sandhu; w a d i a; Khojeste is Rockin 
like a star; Isha Dua; krupa... the best is yet to come...; sharon; [EMAIL 
PROTECTED]
Subject: [Axapta-Knowledge-Village] Editor Mumbai (Times of India)



-- Forwarded message --
From: Sandeep Ghodvinde [EMAIL PROTECTED]mailto:[EMAIL PROTECTED]
Date: Wed, Dec 3, 2008 at 11:53 AM
Subject: FW: Editor Mumbai (Times of India)
To:


Thanks and Regards

Sandeep.





From: Sumit Deshpande
Sent: Wednesday, December 03, 2008 11:35 AM
To: Sandeep Ghodvinde; sudhanshu.ruia; Arun; Kaiser Salim; Sameer Deshmukh; 
Arvind Katakdhond; Ashish Singhal; Bhaskar Kulkarni; Smita Bhosale; Khushboo 
Shah; [EMAIL PROTECTED]mailto:[EMAIL PROTECTED]; [EMAIL 
PROTECTED]mailto:[EMAIL PROTECTED]
Subject: Editor Mumbai (Times of India)



Thanks and Regards

Sumit



LETTER TO PRIME MINISTER

Dear Mr. Prime minister

I am a typical mouse from Mumbai. In the local train compartment which has 
capacity of 100 persons, I travel with 500 more mouse. Mouse at least squeak 
but we don't even do that.

Today I heard your speech. In which you said 'NO BODY WOULD BE SPARED'. I would 
like to remind you that fourteen years has passed since serial bomb blast in 
Mumbai took place. Dawood was the main conspirator. Till today he is not 
caught. All our bolywood actors, our builders, our Gutka king meets him but 
your Government can not catch him. Reason is simple; all your ministers are 
hand in glove with him. If any attempt is made to catch him everybody will be 
exposed. Your statement 'NOBODY WOULD BE SPARED' is nothing but a cruel joke on 
this unfortunate people of India.

Enough is enough. As such after seeing terrorist attack carried out by about a 
dozen young boys I realize that if same thing continues days are not away when 
terrorist will attack by air, destroy our nuclear reactor and there will be one 
more Hiroshima.

We the people are left with only one mantra. Womb to Bomb to Tomb. You promised 
Mumbaikar Shanghai what you have given us is Jalianwala Baug.

Today only your home minister resigned. What took you so long to kick out this 
joker? Only reason was that he was loyal to Gandhi family. Loyalty to Gandhi 
family is more important than blood of innocent people, isn't it?

I am born and bought up in Mumbai for last fifty eight years. Believe me 
corruption in Maharashtra is worse than that in Bihar. Look at all the 
politician, Sharad Pawar, Chagan Bhujbal, Narayan Rane, Bal Thackray , Gopinath 
Munde, Raj Thackray, Vilasrao Deshmukh all are rolling in money.  Vilasrao 
Deshmukh is one of the worst Chief minister I have seen. His only business is 
to increase the FSI every other day, make money and send it to Delhi so 
Congress can fight next election. Now the clown has found new way and will 
increase FSI for fisherman so they can build concrete house right on sea shore. 
Next time terrorist can comfortably live in those house , enjoy the beauty of 
sea and then attack the Mumbai at their will.

Recently I had to purchase house in Mumbai. I met about two dozen builders. 
Everybody wanted about 30% in black. A common person like me knows this and 
with all your intelligent agency  CBI you and your finance minister are not 
aware of it. Where all the black money goes? To the underworld isn't it? Our 
politicians take help of these 

RE: [Axapta-Knowledge-Village] Re: Grouping of production orders for planning

[Harry Deshpande]

I am not sure of what you are saying. Did you try 'limited by materials' 
checkbox while scheduling production orders?

Regards

Harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of James Flavell
Sent: Wednesday, November 26, 2008 1:19 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Re: Grouping of production orders for 
planning

Thanks Harry

Kind of getting you although probably not 100%

The production orders planned start date should be based on when the material 
is available
If the material is delayed then the start date of the production orders should 
be delayed and the user warned if they will miss the delivery date

I believe this is how the master planning is doing in AX (for single item) if 
everything is still in the planned status. But once firmed then I think AX 
master planning does not really give a good indication to the user

Thanks
James




From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Harry Deshpande
Sent: 24 November 2008 12:22
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Re: Grouping of production orders for 
planning
Hi James
Planned prod orders during coverage are scheduled backward from delivery date 
and during futures are scheduled forward from requirement date.
In theory planned prod orders at (only for products at level 0) can be 
scheduled forward from some date however what do you want to do in case such 
products cannot be manufactured before the delivery date?
Regards
Harry
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of James Flavell
Sent: Sunday, November 23, 2008 5:31 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Re: Grouping of production orders for 
planning
Thanks Sayeed,
I think maybe I didnt make it clear that each production order is for different 
items.  I dont think the grouping you are talking about works in this case 
right?
Thanks
James

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of ax_con
Sent: 23 November 2008 16:38
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: Grouping of production orders for 
planning

HI James,

The planned production orders can be merged as one group, or one
production order from the Planned orders form...but once these orders
are firmed you can split them but cannot merge...

Hope this helps

Regards

Sayeed

--- In 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
 James Flavell
[EMAIL PROTECTED] wrote:

 Good morning everyone

 I am not a master planning or production expert so not sure if my
 requirement is available in std AX. If it is not I would for sure
appreciate
 hearing from anyone who has considered or managed to address the
 requirement.

 What I need to be able to do is group all production orders for a
given
 sales order so that master planning plans them all for the same
start date.
 So if I have 10 production orders that master planning treats them
as one
 and works out the latest delivery date of any of the 10s components
and then
 plans that all 10 will start at that time (even if for some of the
 production orders master planning can see they could start
earlier). Of
 course following on from this would be to have all the planned
purchase
 orders suggested based on the start date of the grouped production
order etc

 I believe this is quite a difficult thing to do but would like to
know if
 there is anyway (std or otherwise)

 Thanks
 James

RE: [Axapta-Knowledge-Village] Re: Grouping of production orders for planning

[Harry Deshpande]

Hi James

Planned prod orders during coverage are scheduled backward from delivery date 
and during futures are scheduled forward from requirement date.

In theory planned prod orders at (only for products at level 0) can be 
scheduled forward from some date however what do you want to do in case such 
products cannot be manufactured before the delivery date?

Regards

Harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of James Flavell
Sent: Sunday, November 23, 2008 5:31 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Re: Grouping of production orders for 
planning

Thanks Sayeed,

I think maybe I didnt make it clear that each production order is for different 
items.  I dont think the grouping you are talking about works in this case 
right?

Thanks
James


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of ax_con
Sent: 23 November 2008 16:38
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: Grouping of production orders for 
planning

HI James,

The planned production orders can be merged as one group, or one
production order from the Planned orders form...but once these orders
are firmed you can split them but cannot merge...

Hope this helps

Regards

Sayeed

--- In 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
 James Flavell
[EMAIL PROTECTED] wrote:

 Good morning everyone

 I am not a master planning or production expert so not sure if my
 requirement is available in std AX. If it is not I would for sure
appreciate
 hearing from anyone who has considered or managed to address the
 requirement.

 What I need to be able to do is group all production orders for a
given
 sales order so that master planning plans them all for the same
start date.
 So if I have 10 production orders that master planning treats them
as one
 and works out the latest delivery date of any of the 10s components
and then
 plans that all 10 will start at that time (even if for some of the
 production orders master planning can see they could start
earlier). Of
 course following on from this would be to have all the planned
purchase
 orders suggested based on the start date of the grouped production
order etc

 I believe this is quite a difficult thing to do but would like to
know if
 there is anyway (std or otherwise)

 Thanks
 James

RE: [Axapta-Knowledge-Village] How to delete VAR layer object using code?

[Harry Deshpande]

Take a look at  sysCompare class. There are a few variables in this class, one 
of them must point to the fact whether differences exist or not.

regards

harry

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of James Flavell
Sent: Monday, October 20, 2008 11:29 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] How to delete VAR layer object using code?

Hi everyone,

I have a painful task to do.  Some bright sprak turned on all the created and 
modified properties of all tables in the AOT so now every table is in the VAR 
layer.  I want to do an upgrade and having such meaningless info in the VAR is 
of course going to mean I have to check every table in the code upgrade

So I would like some way to turn the created and modified properties on all 
tables back to the default NO and then after that run auto compare on each 
table lowest layer versus next lowest layer) and if the result is no 
differences to then delete the lowest layer (VAR layer)

Anyone ever do such through coding or do I have to manually check the hundreds 
of tables in AX?

Thanks
James

RE: [Axapta-Knowledge-Village] How to delete VAR layer object using code?

[Harry Deshpande]

Use syscompare class on all objects to find out if anything exists for that 
object in var layer

Regards

Harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of James Flavell
Sent: Tuesday, October 21, 2008 5:47 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] How to delete VAR layer object using 
code?

mmm thanks but that deletes my whole VAR layer...I have plenty of other stuff I 
want to keep in my VAR :)


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of somanna gl
Sent: 21 October 2008 21:04
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] How to delete VAR layer object using 
code?
go the application folder search for *var then stop aos delete selected file.
restart aos.

- Original Message 
From: James Flavell [EMAIL PROTECTED]
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Tuesday, October 21, 2008 11:59:28 AM
Subject: [Axapta-Knowledge-Village] How to delete VAR layer object using code?
Hi everyone,

I have a painful task to do.  Some bright sprak turned on all the created and 
modified properties of all tables in the AOT so now every table is in the VAR 
layer.  I want to do an upgrade and having such meaningless info in the VAR is 
of course going to mean I have to check every table in the code upgrade

So I would like some way to turn the created and modified properties on all 
tables back to the default NO and then after that run auto compare on each 
table lowest layer versus next lowest layer) and if the result is no 
differences to then delete the lowest layer (VAR layer)

Anyone ever do such through coding or do I have to manually check the hundreds 
of tables in AX?

Thanks
James

RE: [Axapta-Knowledge-Village] Requirement to handle difference in sold item and delivered item

[Harry Deshpande]

but the delivery note really needs to show what was physical delivered to the 
customer site for tracking purposes

Quick question: Is it just for reporting? If yes, then it should be easy, add a 
check-box for bom lines that need to be printed along with the item sold.

Regards

Harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of James Flavell
Sent: Sunday, October 05, 2008 4:49 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Requirement to handle difference in sold 
item and delivered item

Hi everyone, once again I am wondering if anyone has gone where I am having to 
go 

I have a requirement whereby the item sold to the customer is a BOM item but 
only part of it is assembled at the factor and the other parts are shipped 
unassembled to the customer site where they are then assembled to the finished 
item.

The problem is the sold item needs to be the final finished good but the 
delivery note really needs to show what was physical delivered to the customer 
site for tracking purposes

Has anyone any ideas how to do this?
Any ideas/brain storming welcome

Thanks
James

RE: [Axapta-Knowledge-Village] Refill by item rather tahn warehouse

[Harry Deshpande]

One of the master planning classes (I think ReqSetupDim) has planned order 
type. Set this to purchase order/production order in case the conditions below 
are not met.

regards

harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of James Flavell
Sent: Tuesday, September 30, 2008 6:19 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Refill by item rather tahn warehouse

Good evening all

Just wondering has anyone attempted to change master planning such that refill 
(planned transfer orders) are only done for certain items rather than all items 
in a warehouse?

I want to be able to set on the item master whether refill orders should be 
done for the item such that the logic in master planning is:

If warehouse is set as refill and item allows refill then create planned 
transfer order
else
No planned transfer order (so later master planning will just plan a purchase 
order at the first warehouse)

Again Harry or anyone else with hints where to start looking in the code would 
be highly appreciated :)
Also anyone who tried and gave up?

Thanks
James

RE: [Axapta-Knowledge-Village] Refill by item rather than warehouse

[Harry Deshpande]

hi

I read the scenario as follows:

Warehouse MW and GW...An order has been placed for an item on warehouse MW. MW 
has also been set up to refill from GW. However, a transfer order from GW to MW 
should only be generated if there is enough stock in GW otherwise a planned 
purchase order on MW should be generated.

regards

harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of ASHWANI JAIN
Sent: Tuesday, September 30, 2008 10:12 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Refill by item rather than warehouse


Hi James,



This functionality is there in Standard Dynamics AX.

In such cases where the refilling warehouse should be applicable for some 
specific items, refilling warehouse should not be defined at the warehouse 
master.

In this case, you have to follow the path:
Basic requirement / Setup:
For the item for which you want to define the refilling warehouse, for those 
items, covergae plan check box should be ticked on the dimension group 
(attached to this item) -- warehouse.

Path:
Inventory module -- Item master -- Select the item for which you want to set 
this option -- Setup button
Under setup button there is option -- Item coverage.
On this form, select the warehouse (WH1) for which you want to define the 
refilling warehouse on Overview tab
On General tab -- under group Main warehouse, set the field value of 
Refilling = Always and Define the refilling warehouse to the field Main 
warehouse (RWH2).

Check this out. This will perhaps resolve your query / issue.
In case any further query, you can contact.

Thanks,
Ashwani Jain

- Original Message 
From: James Flavell [EMAIL PROTECTED]
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Tuesday, 30 September, 2008 6:48:41 PM
Subject: [Axapta-Knowledge-Village] Refill by item rather tahn warehouse
Good evening all

Just wondering has anyone attempted to change master planning such that refill 
(planned transfer orders) are only done for certain items rather than all items 
in a warehouse?

I want to be able to set on the item master whether refill orders should be 
done for the item such that the logic in master planning is:

If warehouse is set as refill and item allows refill then create planned 
transfer order
else
No planned transfer order (so later master planning will just plan a purchase 
order at the first warehouse)

Again Harry or anyone else with hints where to start looking in the code would 
be highly appreciated :)
Also anyone who tried and gave up?

Thanks
James




Add more friends to your messenger and enjoy! Invite them 
now.http://in.rd.yahoo.com/tagline_messenger_6/*http:/messenger.yahoo.com/invite/

RE: [Axapta-Knowledge-Village] Refill by item rather than warehouse

[Harry Deshpande]

Thats exactly what my first email was about :) This can only be achieved thru 
customization.

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of ASHWANI JAIN
Sent: Tuesday, September 30, 2008 10:27 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Refill by item rather than warehouse

Hi Harry,

In this case, system will not help as per standard axapta. This will have to be 
customized then.
As per standard Axapta, system considers the refilling warehouse as Supplying 
warehouse and warehouse against which this requirement is defined as 
Demanding warehouse. So in case of Demand / supply, system always create some 
process (Transfer order in this case).

And if the stock is not available at Supplying warehouse, then system will 
create PO requirement at Supplying warehouse.

System will always create this transfer order, even if the stock will not be 
available at supplying warehouse.

Thanks,
Ashwani Jain

- Original Message 
From: Harry Deshpande [EMAIL PROTECTED]
To: Axapta-Knowledge-Village@yahoogroups.com 
Axapta-Knowledge-Village@yahoogroups.com
Sent: Tuesday, 30 September, 2008 10:46:50 PM
Subject: RE: [Axapta-Knowledge-Village] Refill by item rather than warehouse
hi

I read the scenario as follows:

Warehouse MW and GW...An order has been placed for an item on warehouse MW. MW 
has also been set up to refill from GW. However, a transfer order from GW to MW 
should only be generated if there is enough stock in GW otherwise a planned 
purchase order on MW should be generated.

regards

harry


From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge- 
[EMAIL PROTECTED] ups.com] On Behalf Of ASHWANI JAIN
Sent: Tuesday, September 30, 2008 10:12 AM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] Refill by item rather than warehouse


Hi James,



This functionality is there in Standard Dynamics AX.

In such cases where the refilling warehouse should be applicable for some 
specific items, refilling warehouse should not be defined at the warehouse 
master.

In this case, you have to follow the path:
Basic requirement / Setup:
For the item for which you want to define the refilling warehouse, for those 
items, covergae plan check box should be ticked on the dimension group 
(attached to this item) -- warehouse.

Path:
Inventory module -- Item master -- Select the item for which you want to set 
this option -- Setup button
Under setup button there is option -- Item coverage.
On this form, select the warehouse (WH1) for which you want to define the 
refilling warehouse on Overview tab
On General tab -- under group Main warehouse, set the field value of 
Refilling = Always and Define the refilling warehouse to the field Main 
warehouse (RWH2).

Check this out. This will perhaps resolve your query / issue.
In case any further query, you can contact.

Thanks,
Ashwani Jain

- Original Message 
From: James Flavell [EMAIL PROTECTED] com
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Sent: Tuesday, 30 September, 2008 6:48:41 PM
Subject: [Axapta-Knowledge- Village] Refill by item rather tahn warehouse
Good evening all

Just wondering has anyone attempted to change master planning such that refill 
(planned transfer orders) are only done for certain items rather than all items 
in a warehouse?

I want to be able to set on the item master whether refill orders should be 
done for the item such that the logic in master planning is:

If warehouse is set as refill and item allows refill then create planned 
transfer order
else
No planned transfer order (so later master planning will just plan a purchase 
order at the first warehouse)

Again Harry or anyone else with hints where to start looking in the code would 
be highly appreciated :)
Also anyone who tried and gave up?

Thanks
James



Add more friends to your messenger and enjoy! Invite them 
now.http://in.rd.yahoo.com/tagline_messenger_6/*http:/messenger.yahoo.com/invite/



Be the first one to try the new Messenger 9 Beta! Click 
here.http://in.rd.yahoo.com/tagline_messenger_7/*http:/in.messenger.yahoo.com/win/

RE: [Axapta-Knowledge-Village] Re: Master planning and batch number flow through

[Harry Deshpande]

Sorry, you will need to enable batch dimension and make code changes.

I think the name of the method is createBOMRoute? I think this method is on 
reqTrans.

Regards

Harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of James Flavell
Sent: Tuesday, September 16, 2008 8:21 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Re: Master planning and batch number 
flow through

Thanks Harry once again for your help

I tried with Batch number turned on for coverage but the batch number would not 
flow into the BOM line items, am I missing some setup that can allow this (I 
thought I would have to enable this as well as do some code change but your 
reply seems to suggest otherwise)?

I am not sure of performance at this point but there is not a huge number of 
demand requirements or production orders so I am still tempted to go down this 
route, any idea where to start looking at the code to pass on the batch number 
to BOM sub items?


Also taking your idea of scrolling up the pegging I guess I could also use it 
to actually populate the batch number field once the master planning has run 
right? I.e. actually have a value in the batch number field rather than just a 
display method.

Thanks
James




From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Harry Deshpande
Sent: 17 September 2008 10:55
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Re: Master planning and batch number 
flow through
If u need it on the planned production orders then most likely you will have to 
enable planning by batch dimension. Either you do this or modify code to 
achieve the same effect. It will kill performance either way.
Otherwise at the time of firming you can just scroll up the production order 
hierarchy to find the sale order and hence the batch number. Since the number 
of firmed orders are very less this should not mucho effect on performance. 
Another advantage will be very few code changes.
If you really really want it on the planned orders you could write a display 
function to scroll thru hierarchy. Remember to display this field on any tab 
other than the overview tab.
You do have a headache when multiple requirements are grouped together for e.g. 
multiple sales orders or minimum stock and sales order etc.
Regards
Harry
Ps: Everything ok over here. Now it does not matter if the stock market goes 
down any further, I do not have any money left to lose anyway :)
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of James Flavell
Sent: Tuesday, September 16, 2008 7:02 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Re: Master planning and batch number 
flow through
Hi Harry

Good to hear from you again, hope all is well for you and your family
mmm I would say it would be far better to have on the planned production orders 
although it might be possible to get away with just at the time of firming.  
maybe you can explain a little more the possible pors/cons to have it on 
planning versus only at firming etc
Thanks once again
James

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Harry Deshpande
Sent: 17 September 2008 00:17
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Re: Master planning and batch number 
flow through
Hi
Batch number of production order and sub-items.
Do you also need them for planned production orders? Or rather is it a 
must-have functionality that you need to see batch number on planned production 
orders. Or is it enough if you get the batch number on the real production 
orders (i.e batch number introduced at the time of firming).
Regards
Harry
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of James Flavell
Sent: Monday, September 15, 2008 11:03 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Re: Master planning and batch number 
flow through
Thanks Steve and sorry it has taken me so long to reply (lot of things 
happening good and bad)
I understand what you have done but my focus at this point is more on the 
flowing of batch number through the master planning
Basically what I want to do is if I have a sales order line for an item that is 
a BOM and I put a batch number on it, then when I run master planning I want 
the batch number to be put on the planned production order for the finished 
good (std AX does this) but also to flow through and be put on the BOMs sub 
item lines.
The reason is actually for project based manufacturing where material is 
purchased for a specific project and so the whole operations from production 
and purchasing need to capture and work with this information (e.g. they cannot 
just buy 100 tons of item A as they need to issue

RE: [Axapta-Knowledge-Village] Re: Master planning and batch number flow through

[Harry Deshpande]

Hi

Batch number of production order and sub-items.

Do you also need them for planned production orders? Or rather is it a 
must-have functionality that you need to see batch number on planned production 
orders. Or is it enough if you get the batch number on the real production 
orders (i.e batch number introduced at the time of firming).

Regards

Harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of James Flavell
Sent: Monday, September 15, 2008 11:03 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Re: Master planning and batch number 
flow through

Thanks Steve and sorry it has taken me so long to reply (lot of things 
happening good and bad)

I understand what you have done but my focus at this point is more on the 
flowing of batch number through the master planning

Basically what I want to do is if I have a sales order line for an item that is 
a BOM and I put a batch number on it, then when I run master planning I want 
the batch number to be put on the planned production order for the finished 
good (std AX does this) but also to flow through and be put on the BOMs sub 
item lines.

The reason is actually for project based manufacturing where material is 
purchased for a specific project and so the whole operations from production 
and purchasing need to capture and work with this information (e.g. they cannot 
just buy 100 tons of item A as they need to issue purchase orders per project 
requirement and then track their inventory per project).  I could do 'per 
requirement' planning but the tracking is a nightmare since you will only have 
AX marking to go by (and all its many realted problems)

So there are 2 places for the flow through of batch number the way I see it:
1) During master planning when the system sees that the planned production 
order has a batch number it should pass the batch number on to the planned 
actions for the sub items (whether the action be a another planned production 
order or a planned purchase order). So basically the batch number flows all the 
way through the planning

2)If the user creates a production order directly from the sales line, the 
batch number for the production order should be set from the sales line adn the 
the batch number on the production order's picking list lines should be 
populated with the batch number on the production order headed (finished good's 
batch number)

I think point 1 is the trickier bit but again I think its just I need to find 
the code where the batch number is not passed on to sub items in a BOM so I 
hope someone familair with the master planning class might be able to help 
point me in the right direction


Thanks
James




From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of slees32
Sent: 01 August 2008 10:06
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: Master planning and batch number flow 
through

Hello James,

I can't answer your question regarding planned orders but we are doing
something similar so I thought I'd describe that and maybe it is of
some help.

We know our batch number when we create the sales order - in fact we
are using the sales order number as the batch number.
So when a sales order line is created, we have modified the code to go
to the batch number table and create a new line.
The modified code then also inserts the batch number in the existing
field on the sales order line.

At the moment we are always creating a production order from the sales
order.
We do not use planned orders in our process.
And the batch number is automatically passed from the sales order to
the production order (this is standard Axapta functionality).
I do not know whether this same facility exists to pass the batch
number to a planned order and then on to the purchase order - sorry.

I should also add that our modified code has a bug we have not yet
been able to isolate, where occassionaly, the batch number, although
created, does not get added to the sales order.
This is each to then add at receiving time so is not a huge issue for
us - probably partly why we haven't fixed it yet.

Regards - Steve
AX 3.0 SP2

--- In 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
 James Flavell
[EMAIL PROTECTED] wrote:

 Thanks,

 It is basically that we purchase items for a specific sales and we
need that
 visiblity (marking just does not cut it especially when the flow goes
 through several BOm levels and marking is also rather buggy from my
 experience...). So we will do something like set the batch on the sales
 order equal to the sales order number and want it to flow through

 Thanks
 James


 _

 From: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 [mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com]
  On 

RE: [Axapta-Knowledge-Village] Re: Master planning and batch number flow through

[Harry Deshpande]

If u need it on the planned production orders then most likely you will have to 
enable planning by batch dimension. Either you do this or modify code to 
achieve the same effect. It will kill performance either way.

Otherwise at the time of firming you can just scroll up the production order 
hierarchy to find the sale order and hence the batch number. Since the number 
of firmed orders are very less this should not mucho effect on performance. 
Another advantage will be very few code changes.

If you really really want it on the planned orders you could write a display 
function to scroll thru hierarchy. Remember to display this field on any tab 
other than the overview tab.

You do have a headache when multiple requirements are grouped together for e.g. 
multiple sales orders or minimum stock and sales order etc.

Regards

Harry
Ps: Everything ok over here. Now it does not matter if the stock market goes 
down any further, I do not have any money left to lose anyway :)


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of James Flavell
Sent: Tuesday, September 16, 2008 7:02 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Re: Master planning and batch number 
flow through

Hi Harry

Good to hear from you again, hope all is well for you and your family

mmm I would say it would be far better to have on the planned production orders 
although it might be possible to get away with just at the time of firming.  
maybe you can explain a little more the possible pors/cons to have it on 
planning versus only at firming etc

Thanks once again
James


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Harry Deshpande
Sent: 17 September 2008 00:17
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Re: Master planning and batch number 
flow through
Hi
Batch number of production order and sub-items.
Do you also need them for planned production orders? Or rather is it a 
must-have functionality that you need to see batch number on planned production 
orders. Or is it enough if you get the batch number on the real production 
orders (i.e batch number introduced at the time of firming).
Regards
Harry
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of James Flavell
Sent: Monday, September 15, 2008 11:03 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Re: Master planning and batch number 
flow through
Thanks Steve and sorry it has taken me so long to reply (lot of things 
happening good and bad)
I understand what you have done but my focus at this point is more on the 
flowing of batch number through the master planning
Basically what I want to do is if I have a sales order line for an item that is 
a BOM and I put a batch number on it, then when I run master planning I want 
the batch number to be put on the planned production order for the finished 
good (std AX does this) but also to flow through and be put on the BOMs sub 
item lines.
The reason is actually for project based manufacturing where material is 
purchased for a specific project and so the whole operations from production 
and purchasing need to capture and work with this information (e.g. they cannot 
just buy 100 tons of item A as they need to issue purchase orders per project 
requirement and then track their inventory per project).  I could do 'per 
requirement' planning but the tracking is a nightmare since you will only have 
AX marking to go by (and all its many realted problems)
So there are 2 places for the flow through of batch number the way I see it:
1) During master planning when the system sees that the planned production 
order has a batch number it should pass the batch number on to the planned 
actions for the sub items (whether the action be a another planned production 
order or a planned purchase order). So basically the batch number flows all the 
way through the planning
2)If the user creates a production order directly from the sales line, the 
batch number for the production order should be set from the sales line adn the 
the batch number on the production order's picking list lines should be 
populated with the batch number on the production order headed (finished good's 
batch number)
I think point 1 is the trickier bit but again I think its just I need to find 
the code where the batch number is not passed on to sub items in a BOM so I 
hope someone familair with the master planning class might be able to help 
point me in the right direction
Thanks
James

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of slees32
Sent: 01 August 2008 10:06
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: Master planning and batch number flow 
through

Hello James,

I can't answer your

RE: [Axapta-Knowledge-Village] Problem occured during Master planning

[Harry Deshpande]

Check positive days also try turning off futures and action messages

Regards

Harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of narendra singh
Sent: Wednesday, August 27, 2008 4:21 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Problem occured during Master planning

Dear Ashwani,

Tahnks for your reply.As per your reply Stock is available in MW warehouse and 
Demand is generating in MW warehouse.
Please provide a solution.Can you provide ur cell number also.

Awaiting your response.

Regards
NBSingh
9910365709

- Original Message 
From: ASHWANI JAIN [EMAIL PROTECTED]
To: Axapta-Knowledge-Village@yahoogroups.com; [EMAIL PROTECTED]
Sent: Sunday, 24 August, 2008 9:24:19 AM
Subject: Re: [Axapta-Knowledge-Village] Problem occured during Master planning

Hi Narender,



Whether this requirement is generated warehouse wise?

Can u please check, in which warehouse stock is available and in which 
warehouse demand is there?

Waiting for your reply, based on which i can propose resolution.



Thanks,

Ashwani Jain




- Original Message 
From: visti Sethna [EMAIL PROTECTED] com
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Sent: Saturday, 23 August, 2008 7:46:31 AM
Subject: Re: [Axapta-Knowledge- Village] Problem occured during Master planning
Dear NB

When the orders are getting generated, go to inquiries and check the net 
requirements. You will mostly observev that the orders are getting generated 
due to the stock being insufficient to satisfy the entire demand  for that 
particular item.

Also go to the item master = Quantity Tab and check the multiples  min order 
set for that item under inventory and purchase.

Mostly i feel that :

Total Demand = 170
Onhand = 125
thus Net Reqd = 45 (Total Demand - Onhand)
Min order Qty = 150
Multiples = 25
Order Generated = 175

Check this out, it will solve your problem

Regards
Vishtaspa
On Fri, Aug 22, 2008 at 12:01 PM, narendra singh narendra_srf@ yahoo.co. 
inmailto:[EMAIL PROTECTED] wrote:
All items are affecting

Regards
nbsingh
9910365709

- Original Message 
From: Harry Deshpande [EMAIL PROTECTED] commailto:[EMAIL PROTECTED]
To: Axapta-Knowledge- [EMAIL PROTECTED] 
ups.commailto:Axapta-Knowledge-Village@yahoogroups.com Axapta-Knowledge- 
[EMAIL PROTECTED] ups.commailto:Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, 21 August, 2008 10:46:08 PM
Subject: RE: [Axapta-Knowledge- Village] Problem occured during Master planning

Are all items getting affected by this problem or just a subset?



Regards





Harry Deshpande

http://blogs. msdn.com/ axperfhttp://blogs.msdn.com/axperf





From: Axapta-Knowledge- [EMAIL PROTECTED] ups.comhttp://ups.com/ 
[mailto:Axapta-mailto:Axapta- Knowledge- [EMAIL PROTECTED] 
ups.comhttp://ups.com/] On Behalf Of narendra singh

Sent: Thursday, August 21, 2008 4:30 AM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.comhttp://ups.com/

Subject: [Axapta-Knowledge- Village] Problem occured during Master planning



Hi Friends,
Can anyone of you help me.I am facing a problem during running master planning 
in Ax4.0 sp2.
Although on hand inventory is available before running master planning,but 
after running Master planning it is again generating requirement. I have 
checked all setup but unable to find out the problem.It is urgent.
Thanks  Regards
NBSingh
9910365709

Unlimited freedom, unlimited storage. Get it now, on http://help. yahoo.com/ 
l/in/yahoo/ mail/yahoomail/ tools/tools- 
08.html/http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/


Add more friends to your messenger and enjoy! Invite them 
now.http://in.rd.yahoo.com/tagline_messenger_6/*http:/in.messenger.yahoo.com/invite/



--
With Regards,
Mr. Vishtaspa Sethna
Associate E.R.P. Consultant
Godrej Infotech Ltd.
Cell: +919718010823


Connect with friends all over the world. Get Yahoo! India 
Messenger.http://in.rd.yahoo.com/tagline_messenger_1/*http:/in.messenger.yahoo.com/?wm=n/



Unlimited freedom, unlimited storage. Get it 
nowhttp://in.rd.yahoo.com/tagline_mail_2/*http:/help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/

RE: [Axapta-Knowledge-Village] Problem occured during Master planning

[Harry Deshpande]

Can you confirm that the ‘on hand inventories’ check box is turned on

Regards

harry

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of narendra singh
Sent: Thursday, August 21, 2008 11:32 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Problem occured during Master planning

All items are affecting

Regards
nbsingh
9910365709

- Original Message 
From: Harry Deshpande [EMAIL PROTECTED]
To: Axapta-Knowledge-Village@yahoogroups.com 
Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, 21 August, 2008 10:46:08 PM
Subject: RE: [Axapta-Knowledge-Village] Problem occured during Master planning
Are all items getting affected by this problem or just a subset?

Regards


Harry Deshpande
http://blogs. msdn.com/ axperfhttp://blogs.msdn.com/axperf


From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge- 
[EMAIL PROTECTED] ups.com] On Behalf Of narendra singh
Sent: Thursday, August 21, 2008 4:30 AM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: [Axapta-Knowledge- Village] Problem occured during Master planning


Hi Friends,
Can anyone of you help me.I am facing a problem during running master planning 
in Ax4.0 sp2.
Although on hand inventory is available before running master planning,but 
after running Master planning it is again generating requirement. I have 
checked all setup but unable to find out the problem.It is urgent.
Thanks  Regards
NBSingh
9910365709

Unlimited freedom, unlimited storage. Get it now, on http://help. yahoo.com/ 
l/in/yahoo/ mail/yahoomail/ tools/tools- 
08.html/http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/



Add more friends to your messenger and enjoy! Invite them 
now.http://in.rd.yahoo.com/tagline_messenger_6/*http:/in.messenger.yahoo.com/invite/

RE: [Axapta-Knowledge-Village] Problem occured during Master planning

[Harry Deshpande]

Are all items getting affected by this problem or just a subset?

Regards


Harry Deshpande
http://blogs.msdn.com/axperf


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of narendra singh
Sent: Thursday, August 21, 2008 4:30 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Problem occured during Master planning


Hi Friends,
Can anyone of you help me.I am facing a problem during running master planning 
in Ax4.0 sp2.
Although on hand inventory is available before running master planning,but 
after running Master planning it is again generating requirement.I have checked 
all setup but unable to find out the problem.It is urgent.
Thanks  Regards
NBSingh
9910365709

Unlimited freedom, unlimited storage. Get it now, on 
http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/

RE: [Axapta-Knowledge-Village] Re: Origin of the Axapta Name?

[Harry Deshpande]

Hi

I don't know this firsthand. But I remember reading on technet (this is old Ax 
support forum, does not exist today) that the guys paid a fortune to an agency 
to come up with a name that does not mean anything in any language but sounds 
good and professional. Axapta was the choice.

Regards

Harry
(hmmm...technet.navision.com made my quite nostalgic :))


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of slees32
Sent: Sunday, August 17, 2008 7:11 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: Origin of the Axapta Name?


While it is probably a bit late now, thanks very much for the feedback.
I like the Damgaard brother one and will run with that until I hear
otherwise.
I've had a couple of years away from Axapta but am now back involved.
And I have to agree with the customers wanting to have understanding
of the name and a need to feel ownership with it - I have to say I
feel that way myself.

Regards - Steve

--- In 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
 slees32
[EMAIL PROTECTED] wrote:

 Greetings,

 Does anyone know how the name AXAPTA was coined?
 Is it an acronym of something?

 I had a new user ask me today and I don't know the answer.
 have spent some time going through the posts and the web but cannot
 find anything specifically about the name.

 Appreciate any help,


 Steve

RE: [Axapta-Knowledge-Village] Helllllppppp!!!! sniff sniff

[Harry Deshpande]

So you want the changes to the table in your project not reflected in AOT?

Regards

Harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Hemant Sonawane
Sent: Wednesday, August 13, 2008 9:20 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Help sniff sniff

Hi,
  I have create one project in Private Project Window. Using the AOT tables 
copy from AOT to my new private project using Ctrl+Drag and Drop.
  But problem is that I have make changes in this table same changes will 
be occur in AOT. Why?
any setting or setup is required are there? Please guide me.

Thanks All
Hemant Sonawane
9922 947 479





Unlimited freedom, unlimited storage. Get it 
nowhttp://in.rd.yahoo.com/tagline_mail_2/*http:/help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/

RE: [Axapta-Knowledge-Village] Re: Hiding Code

[Harry Deshpande]

Hi

I remember reading somewhere that an Ax partner has developed X++ obfuscation 
tool. Not sure though, I may be wrong over here.

Regards

Harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of prasanna_koulgi
Sent: Wednesday, August 13, 2008 10:25 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: Hiding Code


Hi there...

As AXAPTA is open source.
It is not possible...

PRASANNA

--- In 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
 cool_minakshi
[EMAIL PROTECTED] wrote:

 Hi EveryBody,
 Can any one please help me to secure my code. Actually we dont want our
 code to be seen by any one including clients and other MS Partners .
 Can we secure our code as we do in Visual Basic where we make .exe of
 our code and deliver just that to clients so that no body can penetrate
 that code, i want same thing to be done in Ax4
 Thanks in advance.

RE: [Axapta-Knowledge-Village] Required Time In second

[Harry Deshpande]

I guess you will have to modify the code.

Regards

Harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Hemant Sonawane
Sent: Wednesday, August 13, 2008 9:30 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Required Time In second

Hi,
   I have create a work center in Basic module/Work Center Group on Times 
Tab.
I want to put the  run time in second but Hours/time ins min. parameters.
then how can I put the time in second any process are there.
please help me.

thanks
Hemant




Unlimited freedom, unlimited storage. Get it 
nowhttp://in.rd.yahoo.com/tagline_mail_2/*http:/help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/

RE: [Axapta-Knowledge-Village] Production Time in Seconds

[Harry Deshpande]

What is the date of your sales order?

Regards

Harry
www.systomatics.comhttp://www.systomatics.com


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Tushar Joshi
Sent: Saturday, August 09, 2008 3:15 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Production Time in Seconds

Hello All,

Does anyone has idea how to capture the runtime of a process in seconds?

I tried the same by putting the Conversion factor as (1/3000=.0003) into the 
Hours/Time field in Times Tab of the Route.

But it throws the error when i ran the Master scheduling saying working Time 
STD not defined for the period 31/12/2007.

I am running the master scheduling for the month of January and have changed my 
system date to 1/1/2008. Logically Axapta will do the requirements calculations 
for Purchase and Production orders in a backward direction i.e. from the date 
of delivery it will go backwards. My sales order quantities are around 40,000 
nos and if the cycle time for 1 unit(process qty) is 15 seconds then its should 
not go beyond 2 hrs of production time. But still am getting the eror for the 
period of 31/12/2005.

Any help would be highly appreciated!

a screenashot of the setups is attached for the reference.





Download prohibited? No problem. 
CHAThttp://in.rd.yahoo.com/tagline_webmessenger_1/*http:/in.webmessenger.yahoo.com/
 from any browser, without download.

RE: [Axapta-Knowledge-Village] Re: Production Time in Seconds

[Harry Deshpande]

Hi

This may be caused by capacity reservations for the past date. Delete the 
capacity reservations in the past if (and most likely) you are not going to 
need these records.

If I remember correctly, there is also a parameter on Production, which will do 
this automatically for you. This will delete capacity reservations for ended 
production orders.

Regards

harry

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Tushar Joshi
Sent: Saturday, August 09, 2008 4:35 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: Production Time in Seconds

Attached is the screenshot of the Master Scheduling error.

-Tushar

--- On Sat, 9/8/08, Tushar Joshi [EMAIL PROTECTED] wrote:
From: Tushar Joshi [EMAIL PROTECTED]
Subject: Production Time in Seconds
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Saturday, 9 August, 2008, 3:45 PM
Hello All,

Does anyone has idea how to capture the runtime of a process in seconds?

I tried the same by putting the Conversion factor as (1/3000=.0003) into the 
Hours/Time field in Times Tab of the Route.

But it throws the error when i ran the Master scheduling saying working Time 
STD not defined for the period 31/12/2007.

I am running the master scheduling for the month of January and have changed my 
system date to 1/1/2008. Logically Axapta will do the requirements calculations 
for Purchase and Production orders in a backward direction i.e. from the date 
of delivery it will go backwards. My sales order quantities are around 40,000 
nos and if the cycle time for 1 unit(process qty) is 15 seconds then its should 
not go beyond 2 hrs of production time. But still am getting the eror for the 
period of 31/12/2005.

Any help would be highly appreciated!

a screenashot of the setups is attached for the reference.



Download prohibited? No problem. 
CHAThttp://in.rd.yahoo.com/tagline_webmessenger_1/*http:/in.webmessenger.yahoo.com/
 from any browser, without download.





Unlimited freedom, unlimited storage. Get it 
nowhttp://in.rd.yahoo.com/tagline_mail_2/*http:/help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/

[Axapta-Knowledge-Village] Ax performance

[Harry Deshpande]

Hi guys

Have you checked out http://blogs.msdn.com/axperf/ lately? We have added a few 
very helpful articles on this site.

Do try out the trace parser training video. In case you have not already tried 
trace parser...this is going to play a major role in indentifying your 
performance issue. There is also a distinct possibility that if you log any 
performance bug the support people will start asking for trace files. So might 
as well get used to this tool now*s*

Regards

Harry

RE: [Axapta-Knowledge-Village] General Number in sue

[Harry Deshpande]

Hi

Check number sequences hot-fixes for the version that you are using.

Regards


Harry Deshpande
http://blogs.msdn.com/axperf



From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Ali Jawad
Sent: Wednesday, June 11, 2008 6:22 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] General Number in sue

Hello All,

When I try to create new journal, system says that this number is already used.
Actually it doesn't increment the number... when I drilled it down to 
find the cause I found that this journal number is in use..
How can I make it free from in USE.  IN USER check box is 
checked and it doesn't letting me to uncheck it.

Please anyone help me to do so.

Thank You,
Ali Jawad

[Axapta-Knowledge-Village] www.systomatics.com

[Harry Deshpande]

Hi

I have updated www.systomatics.comhttp://www.systomatics.com with a new blog 
about Activex Controls.

Regards

Harry

RE: [Axapta-Knowledge-Village] Import of Inventory

[Harry Deshpande]

Hi

May be rebuilding InventSum would help?

Regards

harry

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of consultant.axapta
Sent: Sunday, May 25, 2008 4:07 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Import of Inventory


Hi,

I am trying to import inventory data in the system and data is
imported but it dose not appear in the item window whereas the items
appears when I create Purchase Oreder or Sales order in line items.

Inventory items have got inventory dimensions also, I have imported
the data in the following tables.Even after importing data in all
folowing tables it dose not show the item in the item window in
Inventory Management.

InventTable
InventTableModule
InventColor
InventSize
ConfigTable
InventItemLocation

I'll highly appreciate if any one can give me quick response with
solution about this problem

Regards

[Axapta-Knowledge-Village] AX2009 has been Released ....

[Harry Deshpande]

Live on Partner 
Sourcehttps://mbs.microsoft.com/partnersource/support/selfsupport/productreleases/DynamicsAX2009release.htm

Microsoft Dynamics AX 
2009https://mbs.microsoft.com/partnersource/support/selfsupport/productreleases/DynamicsAX2009release.htm

Microsoft Dynamics AX 2009 is AVAILABLE NOW for download from Partner Source
https://mbs.microsoft.com/partnersource/support/selfsupport/productreleases/DynamicsAX2009release.htm

inline: image001.png

RE: [Axapta-Knowledge-Village] Re: Production Order To be Generated In Multiples - urgent

[Harry Deshpande]

Hi

I am confused is this not something that is readily available in standard Ax? I 
am talking about item settings where one can specify the multiple quantity.

Regards

harry

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of visti Sethna
Sent: Saturday, May 17, 2008 11:08 PM
To: [EMAIL PROTECTED]
Cc: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Re: Production Order To be Generated In 
Multiples - urgent

Dear Friend,

Thanks for your input and could you please send me some more details about the 
customisation coz this is my first project and need help on the same as I have 
to go live next week. This is one of my major hurdles.

Could you send me the exact details of the customisations done so that i can 
show my technical team the same and help me achieve my deadline


On 5/17/08, Mohamed [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] wrote:

--- In 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
 visti Sethna

Dear Friend,

I would like to inform you that this case i faced and after searching
I didn't found solution in Axapta standard
And for this case I made a customization that (I added field in item
master called increase ration)
This makes the system when you generate master planning multiple the
required quantities by this ratio and creates production order by new
quantity


[EMAIL PROTECTED] wrote:

 Dear Friends,

 I am in need of some urgent help.

 Currently Master Planning is Generating orders based on requirement
+ safety
 stock.

 I need to generate certain orders in multiples. For Eg. a
production order
 should always be generated in multiples of 5 for one quantity and in
 multiples of 7 for another quantity along with the period coverage.
pls Help






--
With Regards,
Mr. Vishtaspa Sethna
Associate E.R.P. Consultant
Godrej Infotech Ltd.
Cell: +919718010823

RE: [Axapta-Knowledge-Village] Help Required With ref to Sales Quotation to sales Order

[Harry Deshpande]

Hi

Check the dimension settings. May be warehouse ‘allow edit’ is set to false? 
Just a thought, don’t know much about quotations.

Regards


Harry Deshpande
http://blogs.msdn.com/axperf



From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of somanna gl
Sent: Tuesday, May 13, 2008 11:36 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Help Required With ref to Sales Quotation 
to sales Order

Hi all

Working on Dynamics Ax SP 2
i am not able to post the quotation after converting to sales order.
It gives me a error ware house is not selected. and in sales order i am not 
able to edit the warehouse field. but when i created quotation warehouse is 
selected..


what should i do??

thank you


with regards
somanna



Best Jokes, Best Friends, Best Food. Get all this and more on Best of Yahoo! 
Groups.http://in.rd.yahoo.com/tagline_groups_11/*http:/in.promos.yahoo.com/groups/bestofyahoo/

RE: [Axapta-Knowledge-Village] URGENT: Layers in AX

[Harry Deshpande]

Hi

Check the current company in code and decide which fields to display.

Regards


Harry Deshpande
http://blogs.msdn.com/axperf


This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm;
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Ax Consultant
Sent: Tuesday, May 13, 2008 10:20 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] URGENT: Layers in AX


Thanks Harry for your quick response:)

actually i am not a technical guy, but have a question if we are having more 
than 10 companies running on single AOS/File Server /DB. Now if I open another 
company within the same database. But for this company we may need few 
customization like modification of reports/forms , i don’t want to show these 
modified version to other companies . How this could be possible?






--- On Tue, 5/13/08, Harry Deshpande [EMAIL PROTECTED] wrote:
From: Harry Deshpande [EMAIL PROTECTED]
Subject: RE: [Axapta-Knowledge-Village] URGENT: Layers in AX
To: Axapta-Knowledge-Village@yahoogroups.com 
Axapta-Knowledge-Village@yahoogroups.com
Date: Tuesday, May 13, 2008, 6:16 PM
Dude! Don’t get me wrong but what you have stated is not the requirement. The 
requirement is something else, what you have stated is your solution.

If you state the requirement along with your solution, you have a better chance 
of someone coming up with a better way to satisfy the requirements.

As to your question..no it is not possible to put such restriction.

Regards

Harry


From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge- 
[EMAIL PROTECTED] ups.com] On Behalf Of Ax Consultant
Sent: Monday, May 12, 2008 11:23 PM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: [Axapta-Knowledge- Village] URGENT: Layers in AX


Hi ,

Can we add access restriction on Layers? like if i moda report in AX and dont 
want to show the modified form to all the users. How this could be possible?





Regards.

RE: [Axapta-Knowledge-Village] Upgrade steps from Axapta 3.0 SP3 to Axapta 4.0 Sp2

[Harry Deshpande]

Hi

The problem that you are facing has nothing to do with the Upgrade.

Open AOT and go to the class that is throwing errors. Or rather check the last 
5-6 classes on AOT. Compile these classes and check if any errors are being 
thrown. If errors are present then fix the errors.

If there are no errors in this class then rename axapd.aoi and restart AOS. If 
this does not work then replace all *.aod files (for e.g. .sys,.syp etc will 
come from 4.0SP2 cd and rest of the customized layers from your 3.0SP3 
installation)

Regards

Harry




From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Amit Jain
Sent: Tuesday, May 13, 2008 12:33 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Upgrade steps from Axapta 3.0 SP3 to 
Axapta 4.0 Sp2


Apparently i compiled whole AOT without any luck. Any other suggestion harry? 
Can you send me steps and TIPS (DOs and DONTS) for upgrade from 3.0 SP3 to 4.0 
SP2. Also guide me things to remember while doing and deciding about data 
migration from old version to new version.



Regards

Amit



Regards

Ankit
--- On Tue, 13/5/08, Harry Deshpande [EMAIL PROTECTED] wrote:
From: Harry Deshpande [EMAIL PROTECTED]
Subject: RE: [Axapta-Knowledge-Village] Upgrade steps from Axapta 3.0 SP3 to 
Axapta 4.0 Sp2
To: Axapta-Knowledge-Village@yahoogroups.com 
Axapta-Knowledge-Village@yahoogroups.com
Date: Tuesday, 13 May, 2008, 1:00 AM
Hi

If AOT is visible, then recompile these two classes, re-open client and then 
check whether you need to compile the whole AOT again.

Regards


Harry Deshpande
http://blogs. msdn.com/ axperfhttp://blogs.msdn.com/axperf



From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge- 
[EMAIL PROTECTED] ups.com] On Behalf Of a b
Sent: Friday, May 09, 2008 3:30 AM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: [Axapta-Knowledge- Village] Upgrade steps from Axapta 3.0 SP3 to 
Axapta 4.0 Sp2

Hi,

I am trying to upgrade Axapta 3.0 SP3 to Axapta 4.0 SP2, but i am getting few 
errors, which says that application class does not have runable code in new 
method and another error related to sysuserInfo class.

Once i open the 4.0 environment, i am not able to use any menuitem. when i 
click on any menuitem lets say sales order, nothing happens.

Any suggestions? Also i would appreciate, if you can send me steps and Dos and 
Donts while upgrade from these versions.

Regards

Ankit


Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it 
now.http://us.rd.yahoo.com/evt=51733/*http:/mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ%20





From Chandigarh to Chennai - find friends all over India. Click 
here.http://in.rd.yahoo.com/tagline_groups_10/*http:/in.promos.yahoo.com/groups/citygroups/

RE: [Axapta-Knowledge-Village] URGENT: Layers in AX

[Harry Deshpande]

Dude! Don't get me wrong but what you have stated is not the requirement. The 
requirement is something else, what you have stated is your solution.

If you state the requirement along with your solution, you have a better chance 
of someone coming up with a better way to satisfy the requirements.

As to your question..no it is not possible to put such restriction.

Regards

Harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Ax Consultant
Sent: Monday, May 12, 2008 11:23 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] URGENT: Layers in AX


Hi ,

Can we add access restriction on Layers? like if i moda report in AX and dont 
want to show the modified form to all the users. How this could be possible?





Regards.

RE: [Axapta-Knowledge-Village] Upgrade steps from Axapta 3.0 SP3 to Axapta 4.0 Sp2

[Harry Deshpande]

Hi

If AOT is visible, then recompile these two classes, re-open client and then 
check whether you need to compile the whole AOT again.

Regards


Harry Deshpande
http://blogs.msdn.com/axperf



From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of a b
Sent: Friday, May 09, 2008 3:30 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Upgrade steps from Axapta 3.0 SP3 to Axapta 
4.0 Sp2

Hi,

I am trying to upgrade Axapta 3.0 SP3 to Axapta 4.0 SP2, but i am getting few 
errors, which says that application class does not have runable code in new 
method and another error related to sysuserInfo class.

Once i open the 4.0 environment, i am not able to use any menuitem. when i 
click on any menuitem lets say sales order, nothing happens.

Any suggestions? Also i would appreciate, if you can send me steps and Dos and 
Donts while upgrade from these versions.

Regards

Ankit


Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it 
now.http://us.rd.yahoo.com/evt=51733/*http:/mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ%20

RE: [Axapta-Knowledge-Village] Accessing form data source methods from design

[Harry Deshpande]

Hi

Take a look at

http://www.systomatics.com/Projects/009UploadJournals/proj09.htm

The idea is to declare a new variable as an object and set the datasource to 
this new variable.

Now you can call even datasource.AxKnowledgeVillageRocks(), the code will 
compile (and fail at runtime if the method is missing).


Regards


Harry Deshpande
http://blogs.msdn.com/axperf


This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm;
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Tom Scott
Sent: Thursday, May 08, 2008 6:26 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Accessing form data source methods from 
design


I would have thought this was fairly straightforward but it's got me
puzzled.
I want to call a method I have created in a form data source from a
button click. I would have thought I just use
DataSourceName.MethodName() but the method is not available.
Suggestions please?

Regards
Tom

RE: [Axapta-Knowledge-Village] Problem after importing a table / table not in AOT

[Harry Deshpande]

Did you try restarting AOS+SQL Server?

Regards


Harry Deshpande
http://blogs.msdn.com/axperf


This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm;
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of derdoomi
Sent: Thursday, May 08, 2008 3:18 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Problem after importing a table / table not 
in AOT


hi,

i have a mysterious problem after a failed import of a table in AX3.0.

the table cannot be found in the AOT and it does also not exist in the
database.

problem is, when i try to import a table named like the one i first
tried to import, the import window closes very quick and no new object
in the AOT. if you try to rename an existing table with this name, you
get an error that the table already exists.

i tried rebuilding the application index, but that did not help.

any ideas?

tia,
timon

RE: [Axapta-Knowledge-Village] How to Import the VAR Layer Object into a USR Layer

[Harry Deshpande]

Hi

Go to Application - DBSysncronize , set return true at the top.

Export your code out of VAR Layer, make sure that you are exporting with ID's.

Delete your code from VAR Layer.

Log out and start Ax in USR Layer.

Import your project, make sure you are importing with ID's.

Remove the changes to application - DBSyncronize.

Regards


Harry Deshpande
http://blogs.msdn.com/axperf


This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm;
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of s_siet4u
Sent: Friday, April 25, 2008 3:18 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] How to Import the VAR Layer Object into a 
USR Layer


Hi All,
Can any one tell me how to import the VAR(Development Layer)
Layer to the User Layer. i have developed some customization in a VAR
Layer. i want to import this customization into the USR Layer.
Please help me out its a very Urgent.

[Axapta-Knowledge-Village] www.systomatics.com

[Harry Deshpande]

Hi

I have updated the site with the next part of debugging Ax Kernel

Regards

Harry

[Axapta-Knowledge-Village] www.systomatics.com

[Harry Deshpande]

Hi

I have updated systomatics.com with a new blog about debugging Ax kernel

Regards

Harry

RE: [Axapta-Knowledge-Village] Production Order

[Harry Deshpande]

Hi

I suppose you can schedule by priority on delivery date

Regards

Harry


This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm;
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Naeem Sarwar
Sent: Sunday, March 23, 2008 12:41 AM
To: [EMAIL PROTECTED]; Axapta-Knowledge-Village@yahoogroups.com; [EMAIL 
PROTECTED]
Subject: [Axapta-Knowledge-Village] Production Order


hi pplz,

we are in service industry and some time we receive services requests which are 
most urgent then the existing job in progress.
we are in progress of implementing  Dynamics AX. in AX we cam to know that once 
a production order is started it can't not be stopped and there is no priority 
setting for jobs in schedule so we can start a high priority job by stopping 
the jobs in progress immediatly.

any solution or way out 

Thanks

Naeem Sarwar

[Axapta-Knowledge-Village] Ax performance team

[Harry Deshpande]

Hi Guys

Please do take a look at http://blogs.msdn.com/axperf/

Regards

Harry

RE: [Axapta-Knowledge-Village] MRP plan not able to re-run

[Harry Deshpande]

Hi

Can you confirm whether 'scheduling type' and 'finite capacity' settings are 
the same?

Regards

Harry


This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm;
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of weishu_neo
Sent: Wednesday, March 05, 2008 1:38 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] MRP plan not able to re-run


Dear all,

Can I trouble you to advice on an issue that I'm having with the MRP
plan?

When running the MRP plan (MRP A) for the first time, it will take 8
hours to complete the run.

However, running the same MRP plan (MRP A) for the second time, it
will take more than 24 hours and still not able to complete the run.

When creating another MRP plan with the same settings (MRP B), it
will complete the run within 8 hours as well.

We have tried to do a re-indexing, check/sychronize and database
integrity check but the results are still the same.

Please advice if you have faced any similar issues before or if you
have any suggestions that I can try out.

Thank you very much for your help.

Warmest Regards,
Weishu



[Non-text portions of this message have been removed]

RE: [Axapta-Knowledge-Village] MRP plan not able to re-run

[Harry Deshpande]

Hi

And exactly what do you mean by When deleting the MRP-2008, it will also take 
more than 24 hours to complete and we are also forced to terminate the delete 
process.

Do you mean to say that it was deleting the records for 24 hours?

Regards

Harry

This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm;
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.

From: Harry Deshpande
Sent: Thursday, March 06, 2008 9:38 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] MRP plan not able to re-run

Hi

Can you confirm whether 'scheduling type' and 'finite capacity' settings are 
the same?

Regards

Harry


This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm;
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of weishu_neo
Sent: Wednesday, March 05, 2008 1:38 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] MRP plan not able to re-run


Dear all,

Can I trouble you to advice on an issue that I'm having with the MRP
plan?

When running the MRP plan (MRP A) for the first time, it will take 8
hours to complete the run.

However, running the same MRP plan (MRP A) for the second time, it
will take more than 24 hours and still not able to complete the run.

When creating another MRP plan with the same settings (MRP B), it
will complete the run within 8 hours as well.

We have tried to do a re-indexing, check/sychronize and database
integrity check but the results are still the same.

Please advice if you have faced any similar issues before or if you
have any suggestions that I can try out.

Thank you very much for your help.

Warmest Regards,
Weishu



[Non-text portions of this message have been removed]

[Axapta-Knowledge-Village] www.systomatics.com

[Harry Deshpande]

Hi

The site has been updated with a new blog

Regards

harry


[Non-text portions of this message have been removed]

RE: [Axapta-Knowledge-Village] www.systomatics.com

[Harry Deshpande]

Someone did send me a project about a month or two back. At that time I was not 
sure if I was going to upload xpo's any more so I declined. Now I have deleted 
his email and do not have any way of contacting him

Regards

Harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Mike Matta
Sent: Friday, February 22, 2008 10:19 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] www.systomatics.com


That's great Harry. Thanks a lot.

Has anybody sent you the project for Version 3.0 KR2?

From: Harry Deshpande [EMAIL PROTECTED]mailto:harryd%40microsoft.com
Reply-To: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
To: [EMAIL PROTECTED]mailto:development-axapta%40yahoogroups.com
[EMAIL PROTECTED]mailto:development-axapta%40yahoogroups.com
CC:
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
Subject: [Axapta-Knowledge-Village] www.systomatics.com
Date: Wed, 20 Feb 2008 19:19:49 -0800

Hi

www.systomatics.comhttp://www.systomatics.com is updated with a new blog,
new Microsoft watch. Also infolog project appearing under projects has been
modified with an upgraded version.

Regards

Harry



[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]

[Axapta-Knowledge-Village] www.systomatics.com

[Harry Deshpande]

Hi

www.systomatics.comhttp://www.systomatics.com is updated with a new blog, new 
Microsoft watch. Also infolog project appearing under projects has been 
modified with an upgraded version.

Regards

Harry



[Non-text portions of this message have been removed]

RE: [Axapta-Knowledge-Village] Re: delete record from InventDim table

[Harry Deshpande]

Hi

I thought there are no transactions for the inventDim that you are trying to 
delete.

Check if there are any corresponding records in InventTrans. If there are 
records then I do not think you can delete the records. (of course if this is a 
test system then you can remove the delete action, delete records and restore 
the delete action) but I do not think you should do this on live system.

--dittor- for inventsum

Regards

harry

This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm;
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of yunfeng.li2007
Sent: Thursday, January 24, 2008 9:25 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: delete record from InventDim table


Hi Harry,

Thank you for replying!

1) Clean up. I did the clean up manually, it did not help.
2) I noticed the InventDim uses delete(true/false) for delete
method. So I deleted the records using inventDim.delete(true); this
time. Here is the results:

Contents before calling inventDim.delete(true);:
--- -- 
InvendDimId InventSerialId InventLocationId
--- -- 
12345 45678 GW
12346 45679 GW
. . GW

Contents after calling inventDim.delete(true);: (all GW gone, but
12345, 12346 are still there)
--- -- 
InvendDimId InventSerialId InventLocationId
--- -- 
12345 45678
12346 45679
. .

As you can see, after deletion, all the records came back with
only GW becoming empty. I want to delete the 12345, 12346, ...
completely.

Could you (or some other experts) please help on this?

Thanks.

YLi

--- In 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
 Harry Deshpande
[EMAIL PROTECTED] wrote:

 Hi

 Check if you have a inventory - periodic job that cleans up
unutilized dimension.

 For understanding your problem you will have to look at inventDim -
delete method.

 Regards

 Harry


 From: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
  [mailto:Axapta-
[EMAIL PROTECTED]mailto:Knowledge-Village%40yahoogroups.com] On Behalf Of 
yunfeng.li2007
 Sent: Thursday, January 24, 2008 6:44 AM
 To: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 Subject: [Axapta-Knowledge-Village] delete record from InventDim
table


 Hi dear Axapta friends,

 I tried to delete a record from the InventDim table. I deleted it OK
 (it disappeared from the table browser). Then I closed the table
 browser and re-open the table browser to view InventDim table, the
 deleted record appeared again.

 Please give me a direction on how to solve it.

 Thank you very much!

 YLi



 [Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]

RE: [Axapta-Knowledge-Village] delete record from InventDim table

[Harry Deshpande]

Hi

Check if you have a inventory - periodic job that cleans up unutilized 
dimension.

For understanding your problem you will have to look at inventDim - delete 
method.

Regards

Harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of yunfeng.li2007
Sent: Thursday, January 24, 2008 6:44 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] delete record from InventDim table


Hi dear Axapta friends,

I tried to delete a record from the InventDim table. I deleted it OK
(it disappeared from the table browser). Then I closed the table
browser and re-open the table browser to view InventDim table, the
deleted record appeared again.

Please give me a direction on how to solve it.

Thank you very much!

YLi



[Non-text portions of this message have been removed]

RE: [Axapta-Knowledge-Village] Global Types

[Harry Deshpande]

Hi

If you are increasing the EDT length then it should not affect data consistency 
for the existing data

Regards

harry

This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm;
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of olivier_johan
Sent: Monday, January 21, 2008 6:01 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Global Types


Hi All,
I have installed a development instance using Dynamics AX 4 SP2. I have
also loaded the demo data into company called DMO. We then created a
new company which we will use to test our development on.

There is now a requirement to adjust global types - increasing the
projID to 20. We will do this for the new company we created.

I know global types must be configured before data is loaded and I was
wondering if the demo data in DMO company will cause problems if we
adjust global types in our new company X.

If it will be a problem, will you please advise on how I should
proceed. We do not need the demo data and DMO company. Can I somehow
remove DMO with it's data from the system in order to adjust the global
type or should I reinstall ?

thanks for all the help 

Johan



[Non-text portions of this message have been removed]

[Axapta-Knowledge-Village] systomatics.com

[Harry Deshpande]

Hi

www.systomatics.comhttp://www.systomatics.com has been updated with a new 
Microsoft Watch

regards

harry


[Non-text portions of this message have been removed]

RE: [Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 then SQL Server 2000?

[Harry Deshpande]

However, I must tell you that I am not an expert on bench-marking

Regards

Harry
Ps: and I forgot to include the disclaimer in my last email*s*

This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm;
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.

From: Harry Deshpande
Sent: Tuesday, January 08, 2008 9:13 AM
To: 'Axapta-Knowledge-Village@yahoogroups.com'
Subject: RE: [Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 
then SQL Server 2000?

Hi

Are you planning to use the same task for all the clients? May be that is not a 
good idea since they will end up locking each other.

I would say one client can do sales order, another can do gl posting, another 
can do something in projects and so on.

Regards

harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Steeve Gilbert
Sent: Tuesday, January 08, 2008 7:15 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 then 
SQL Server 2000?


Hi Harry,

Can you give me tips on how to build a good multi-user benchmark? I
have a few long running db intensive task in Axapta that I was
thinking of running. I can probably test it with 4 or maybe 5 client
at time, do you think that will be multi-user enough?

regards,

Steeve...

--- In 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
 Harry Deshpande
[EMAIL PROTECTED] wrote:

 Hi

 Another thing to note is if you are running benchmarks then please
run the benchmarks in multi-user environment. SQL Server 2005 is much
better than '2000' in handling multi-user environment. (After all
your live system works multi-user)

 You will get 100% advantage once you upgrade to 4.0+ version since
concurrency has even been introduced in the AX application.

 Regards

 Harry


 This posting is provided AS IS with no warranties, and confers no
 rights. Use of included script samples are subject to the terms
 specified at http://www.microsoft.com/info/cpyright.htm;
 The code provided (if any) may be written from the point of view of
a
 third party and the programming style/development standards may suit
 such a point of view.

 From: Harry Deshpande
 Sent: Tuesday, December 18, 2007 11:15 AM
 To: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 Subject: RE: [Axapta-Knowledge-Village] Axapta slower on SQL Server
2005 then SQL Server 2000?

 Hi

 As per my experience SQL Server 2005 performance is much better
than '2000'.


 1. Please check whether the SQL Server setup is in line with
Microsoft recommendations.

 2. Go further and check things like disc-alignment. Take a
look at
http://sqlblogcasts.com/blogs/christian/archive/2007/10/09/disk-
sector-alignment.aspx

 3. SQL Server 2005 engine is heavily optimized towards
cluster indexes. You will see a lot of cluster indexes introduced
from V4.0 onwards. Please back-port them. However, please note that
there is a small chance that the cluster indexes for some tables in
standard Ax may not be appropriate with your data usage pattern. In
this case you will have to figure out the best fit cluster index
yourself.

 4. Last but not the least make sure you are running the
database with compatibility mode 90. (It is easy to forget this).

 I must say I am a very happy camper since I started using SQL
Server 2005.

 Regards

 Harry



 This posting is provided AS IS with no warranties, and confers no
 rights. Use of included script samples are subject to the terms
 specified at http://www.microsoft.com/info/cpyright.htm;
 The code provided (if any) may be written from the point of view of
a
 third party and the programming style/development standards may suit
 such a point of view.

 From: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
  [mailto:Axapta-
[EMAIL PROTECTED]mailto:Knowledge-Village%40yahoogroups.com] On Behalf Of 
Steeve Gilbert
 Sent: Tuesday, December 18, 2007 10:51 AM
 To: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 Subject: [Axapta-Knowledge-Village] Axapta slower on SQL Server
2005 then SQL Server 2000?


 I read a couple of post here and there about Axapta being slower on
SQL
 Server 2005 then 2000. I thought that people that have problem post
 messages and those who don't stays quiet. That's why I was only
seeing
 post about SQL 2005 being slower. But then I stubble on a post on
MBS
 forum

(http://www.microsoft.com/Businesssolutions/Community/Newsgroups/dgbro
ws
 er/en-us/default.mspx?

query=sql+2005dg=microsoft.public.axapta.databasecat=lang=encr=US
pt
 =catlist=8d3f188d-a0E9-40e4-86e2-
 46508a35c759dglist=ptlist=exp=sloc=en-us

RE: [Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 then SQL Server 2000?

[Harry Deshpande]

Hi

Are you planning to use the same task for all the clients? May be that is not a 
good idea since they will end up locking each other.

I would say one client can do sales order, another can do gl posting, another 
can do something in projects and so on.

Regards

harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Steeve Gilbert
Sent: Tuesday, January 08, 2008 7:15 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 then 
SQL Server 2000?


Hi Harry,

Can you give me tips on how to build a good multi-user benchmark? I
have a few long running db intensive task in Axapta that I was
thinking of running. I can probably test it with 4 or maybe 5 client
at time, do you think that will be multi-user enough?

regards,

Steeve...

--- In 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
 Harry Deshpande
[EMAIL PROTECTED] wrote:

 Hi

 Another thing to note is if you are running benchmarks then please
run the benchmarks in multi-user environment. SQL Server 2005 is much
better than '2000' in handling multi-user environment. (After all
your live system works multi-user)

 You will get 100% advantage once you upgrade to 4.0+ version since
concurrency has even been introduced in the AX application.

 Regards

 Harry


 This posting is provided AS IS with no warranties, and confers no
 rights. Use of included script samples are subject to the terms
 specified at http://www.microsoft.com/info/cpyright.htm;
 The code provided (if any) may be written from the point of view of
a
 third party and the programming style/development standards may suit
 such a point of view.

 From: Harry Deshpande
 Sent: Tuesday, December 18, 2007 11:15 AM
 To: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 Subject: RE: [Axapta-Knowledge-Village] Axapta slower on SQL Server
2005 then SQL Server 2000?

 Hi

 As per my experience SQL Server 2005 performance is much better
than '2000'.


 1. Please check whether the SQL Server setup is in line with
Microsoft recommendations.

 2. Go further and check things like disc-alignment. Take a
look at
http://sqlblogcasts.com/blogs/christian/archive/2007/10/09/disk-
sector-alignment.aspx

 3. SQL Server 2005 engine is heavily optimized towards
cluster indexes. You will see a lot of cluster indexes introduced
from V4.0 onwards. Please back-port them. However, please note that
there is a small chance that the cluster indexes for some tables in
standard Ax may not be appropriate with your data usage pattern. In
this case you will have to figure out the best fit cluster index
yourself.

 4. Last but not the least make sure you are running the
database with compatibility mode 90. (It is easy to forget this).

 I must say I am a very happy camper since I started using SQL
Server 2005.

 Regards

 Harry



 This posting is provided AS IS with no warranties, and confers no
 rights. Use of included script samples are subject to the terms
 specified at http://www.microsoft.com/info/cpyright.htm;
 The code provided (if any) may be written from the point of view of
a
 third party and the programming style/development standards may suit
 such a point of view.

 From: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
  [mailto:Axapta-
[EMAIL PROTECTED]mailto:Knowledge-Village%40yahoogroups.com] On Behalf Of 
Steeve Gilbert
 Sent: Tuesday, December 18, 2007 10:51 AM
 To: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 Subject: [Axapta-Knowledge-Village] Axapta slower on SQL Server
2005 then SQL Server 2000?


 I read a couple of post here and there about Axapta being slower on
SQL
 Server 2005 then 2000. I thought that people that have problem post
 messages and those who don't stays quiet. That's why I was only
seeing
 post about SQL 2005 being slower. But then I stubble on a post on
MBS
 forum

(http://www.microsoft.com/Businesssolutions/Community/Newsgroups/dgbro
ws
 er/en-us/default.mspx?

query=sql+2005dg=microsoft.public.axapta.databasecat=lang=encr=US
pt
 =catlist=8d3f188d-a0E9-40e4-86e2-
 46508a35c759dglist=ptlist=exp=sloc=en-us). And the quote is :
 First of all Ax database runing on same hardware with SQL2005 is
~20%
 slower than SQL200 database (tested).

 I can't find something clearer that this. So, does my friends of the
 Axapta Knowledge Village acknowledge this statement?

 I'm gonna test this in our dev environment and if it turns out true,
 then it's gonna be the end of our SQL Server 2005 migration I guess.
 Btw, we are staying at Ax3.0 SP3 even if we migrate to SQL 2005.



 [Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]

[Axapta-Knowledge-Village] www.systomatics.com

[Harry Deshpande]

Hi

www.systomatics.comhttp://www.systomatics.com is updated with a new blog

regards

harry


[Non-text portions of this message have been removed]

RE: [Axapta-Knowledge-Village] Axapta SPIDs

[Harry Deshpande]

Hi

Are you talking about SPID or SID? Just curious

Regards

Harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Subhajit Ghosh
Sent: Monday, December 31, 2007 9:13 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Axapta SPIDs


Hi

SP id basically comes from domain machine. It is an unique machine no generated 
aganist domain administrator. In AX4, this SP id is very important. At the time 
of running administrator, it alwasy check this SP id. If this SP id do not 
match, then an error comes, You are not a registered user. Due to this in 
AX4, backup-restore from sql or attach/detach of database is not running. Only 
backup from AX4 will run properly. At the time of restoring database, backup 
taken from AX4, it automatically creates SPid in AX4 database.

Regards

Subhajit Ghosh

- Original Message 
From: Harry Deshpande [EMAIL PROTECTED]mailto:harryd%40microsoft.com
To: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
Sent: Monday, 31 December, 2007 11:16:27 PM
Subject: RE: [Axapta-Knowledge-Village] Axapta SPIDs

Hi

Administration - online users SPID comes from the database.

Regards

Harry

This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsof t.com/info/ cpyright. htm
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.

From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta-Knowledge- 
[EMAIL PROTECTED] ups.com] On Behalf Of cshauw
Sent: Sunday, December 30, 2007 7:43 PM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: [Axapta-Knowledge- Village] Axapta SPIDs

Hi All,

Anyone know what is the SPID use for in Axapta? Why sometime it appear
two numbers, please help to shed a light on this area,thank you.

dachong

[Non-text portions of this message have been removed]

!-- #ygrp-mkp{ border:1px solid #d8d8d8;font-family:Arial;margin:14px 
0px;padding:0px 14px;} #ygrp-mkp hr{ border:1px solid #d8d8d8;} #ygrp-mkp #hd{ 
color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px 0px;} 
#ygrp-mkp #ads{ margin-bottom:10px;} #ygrp-mkp .ad{ padding:0 0;} #ygrp-mkp .ad 
a{ color:#ff;text-decoration:none;} -- !-- #ygrp-sponsor #ygrp-lc{ 
font-family:Arial;} #ygrp-sponsor #ygrp-lc #hd{ margin:10px 
0px;font-weight:bold;font-size:78%;line-height:122%;} #ygrp-sponsor #ygrp-lc 
.ad{ margin-bottom:10px;padding:0 0;} -- !-- #ygrp-mlmsg 
{font-size:13px;font-family:arial, helvetica, clean, sans-serif;} #ygrp-mlmsg 
table {font-size:inherit;font:100%;} #ygrp-mlmsg select, input, textarea 
{font:99% arial, helvetica, clean, sans-serif;} #ygrp-mlmsg pre, code 
{font:115% monospace;} #ygrp-mlmsg * {line-height:1.22em;} #ygrp-text{ 
font-family:Georgia; } #ygrp-text p{ margin:0 0 1em 0;} #ygrp-tpmsgs{
font-family:Arial; clear:both;} #ygrp-vitnav{ 
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;} #ygrp-vitnav a{ 
padding:0 1px;} #ygrp-actbar{ clear:both;margin:25px 
0;white-space:nowrap;color:#666;text-align:right;} #ygrp-actbar .left{ 
float:left;white-space:nowrap;} .bld{font-weight:bold;} #ygrp-grft{ 
font-family:Verdana;font-size:77%;padding:15px 0;} #ygrp-ft{ 
font-family:verdana;font-size:77%;border-top:1px solid #666; padding:5px 0; } 
#ygrp-mlmsg #logo{ padding-bottom:10px;} #ygrp-vital{ 
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;} #ygrp-vital 
#vithd{ 
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
 #ygrp-vital ul{ padding:0;margin:2px 0;} #ygrp-vital ul li{ 
list-style-type:none;clear:both;border:1px solid #e0ecee; } #ygrp-vital ul li 
.ct{ 
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
 #ygrp-vital ul li .cat{ font-weight:bold;}
#ygrp-vital a{ text-decoration:none;} #ygrp-vital a:hover{ 
text-decoration:underline;} #ygrp-sponsor #hd{ color:#999;font-size:77%;} 
#ygrp-sponsor #ov{ padding:6px 
13px;background-color:#e0ecee;margin-bottom:20px;} #ygrp-sponsor #ov ul{ 
padding:0 0 0 8px;margin:0;} #ygrp-sponsor #ov li{ 
list-style-type:square;padding:6px 0;font-size:77%;} #ygrp-sponsor #ov li a{ 
text-decoration:none;font-size:130%;} #ygrp-sponsor #nc{ 
background-color:#eee;margin-bottom:20px;padding:0 8px;} #ygrp-sponsor .ad{ 
padding:8px 0;} #ygrp-sponsor .ad #hd1{ 
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
 #ygrp-sponsor .ad a{ text-decoration:none;} #ygrp-sponsor .ad a:hover{ 
text-decoration:underline;} #ygrp-sponsor .ad p{ margin:0;} o{font-size:0;} 
.MsoNormal{ margin:0 0 0 0;} #ygrp-text tt{ font-size:120%;} 
blockquote{margin:0 0 0 4px;} .replbq{margin:4;} --

5, 50, 500

RE: [Axapta-Knowledge-Village] Axapta SPIDs

[Harry Deshpande]

Hi

Administration - online users  SPID comes from the database.

Regards

Harry


This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm;
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of cshauw
Sent: Sunday, December 30, 2007 7:43 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Axapta SPIDs


Hi All,

Anyone know what is the SPID use for in Axapta? Why sometime it appear
two numbers, please help to shed a light on this area,thank you.

dachong



[Non-text portions of this message have been removed]

RE: [Axapta-Knowledge-Village] Backup restore problem in AX4 sp1

[Harry Deshpande]

Hi

You seem to have duplicate recid's.

Regards

Harry


This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm;
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of ghoshsubhajit
Sent: Wednesday, December 26, 2007 9:33 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Backup restore problem in AX4 sp1


Hi All

I am working on AX4, SP1. At the time of restoring bkup data is not
coming properly in 3 tables. One is docuvalue in base axapta and
another two tables are customized.

Error coming

Cannot create a record in Map(TmprecidMap). The record already
exists.

I am taking bakup from axapta, not from sql.

Please help me.

Regards

Subhajit Ghosh

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]

RE: [Axapta-Knowledge-Village] Synchronize Problem

[Harry Deshpande]

Check event-viewer

Regards

harry

This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm;
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of ghoshsubhajit
Sent: Wednesday, December 26, 2007 9:35 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Synchronize Problem


Hi

At the time of synchronization, 3 tables failed to synchronize. How I
find this tables, which creates problem. I am using AX4, SP1.

Regards

Subhajit Ghosh



[Non-text portions of this message have been removed]

RE: [Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 then SQL Server 2000?

[Harry Deshpande]

Hi

There are a lot of considerations regarding SQL server setup and I am no expert 
in this stuff.  Some examples are :  Default schema for all users should be set 
to DBO, Tempb should be configured with multiple, equal -sized files. Number of 
files should match the number of processors, There are also special 
recommendations as to where to keep the tempDB file.

There should be some documentation regarding SQL server setup on msdn or 
technet microsoft. Or try placing a request thru partner channel.

Please also take into account my comment about concurrency. i.e. if you are 
going to do bench-marking then do bench-marking for x number of concurrent user 
and not a single user.

Regards

Harry


This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm;
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Steeve Gilbert
Sent: Wednesday, December 19, 2007 1:08 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 then 
SQL Server 2000?


Hi Harry,

1 - Is there documentation explaining MS recommendations about SQL
Server setup you're talking about?

2 - Wow, never heard of those disc-alignment issue. Seems to cause
quite of a performance problem. It's surprising people don't talk
about that much. I'll need a bit more reading to understand the
problem better and check if our SAN could suffer from this. I hope
not!

3, 4 - Cluster Index and compatibility mode : Note inserted in my
upgrade plan. :)

Thanks for the tips!

Steeve...

--- In 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
 Harry Deshpande
[EMAIL PROTECTED] wrote:

 Hi

 As per my experience SQL Server 2005 performance is much better
than '2000'.


 1. Please check whether the SQL Server setup is in line with
Microsoft recommendations.

 2. Go further and check things like disc-alignment. Take a
look at
http://sqlblogcasts.com/blogs/christian/archive/2007/10/09/disk-
sector-alignment.aspx

 3. SQL Server 2005 engine is heavily optimized towards
cluster indexes. You will see a lot of cluster indexes introduced
from V4.0 onwards. Please back-port them. However, please note that
there is a small chance that the cluster indexes for some tables in
standard Ax may not be appropriate with your data usage pattern. In
this case you will have to figure out the best fit cluster index
yourself.

 4. Last but not the least make sure you are running the
database with compatibility mode 90. (It is easy to forget this).

 I must say I am a very happy camper since I started using SQL
Server 2005.

 Regards

 Harry



 This posting is provided AS IS with no warranties, and confers no
 rights. Use of included script samples are subject to the terms
 specified at http://www.microsoft.com/info/cpyright.htm;
 The code provided (if any) may be written from the point of view of
a
 third party and the programming style/development standards may suit
 such a point of view.

 From: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
  [mailto:Axapta-
[EMAIL PROTECTED]mailto:Knowledge-Village%40yahoogroups.com] On Behalf Of 
Steeve Gilbert
 Sent: Tuesday, December 18, 2007 10:51 AM
 To: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 Subject: [Axapta-Knowledge-Village] Axapta slower on SQL Server
2005 then SQL Server 2000?


 I read a couple of post here and there about Axapta being slower on
SQL
 Server 2005 then 2000. I thought that people that have problem post
 messages and those who don't stays quiet. That's why I was only
seeing
 post about SQL 2005 being slower. But then I stubble on a post on
MBS
 forum

(http://www.microsoft.com/Businesssolutions/Community/Newsgroups/dgbro
ws
 er/en-us/default.mspx?

query=sql+2005dg=microsoft.public.axapta.databasecat=lang=encr=US
pt
 =catlist=8d3f188d-a0E9-40e4-86e2-
 46508a35c759dglist=ptlist=exp=sloc=en-us). And the quote is :
 First of all Ax database runing on same hardware with SQL2005 is
~20%
 slower than SQL200 database (tested).

 I can't find something clearer that this. So, does my friends of the
 Axapta Knowledge Village acknowledge this statement?

 I'm gonna test this in our dev environment and if it turns out true,
 then it's gonna be the end of our SQL Server 2005 migration I guess.
 Btw, we are staying at Ax3.0 SP3 even if we migrate to SQL 2005.



 [Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]

RE: [Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 then SQL Server 2000?

[Harry Deshpande]

Remembered something else...the DB server I was investigating had 1 system disk 
+ 2 physical hard disk. The machine also had 2 hard-disk controllers. I kept 
the mdf and ldf file on separate physical drives and was very happy. No 
difference in the performance though. It took me some time to figure out that 
the same controller serviced both data hard disks  and the other controller was 
for system disk.

Regards

Harry


This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm;
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Harry Deshpande
Sent: Wednesday, December 19, 2007 1:24 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 
then SQL Server 2000?


Hi

There are a lot of considerations regarding SQL server setup and I am no expert 
in this stuff. Some examples are : Default schema for all users should be set 
to DBO, Tempb should be configured with multiple, equal -sized files. Number of 
files should match the number of processors, There are also special 
recommendations as to where to keep the tempDB file.

There should be some documentation regarding SQL server setup on msdn or 
technet microsoft. Or try placing a request thru partner channel.

Please also take into account my comment about concurrency. i.e. if you are 
going to do bench-marking then do bench-marking for x number of concurrent user 
and not a single user.

Regards

Harry

This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm;
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.

From: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 
[mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of Steeve Gilbert
Sent: Wednesday, December 19, 2007 1:08 PM
To: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: Axapta slower on SQL Server 2005 then 
SQL Server 2000?

Hi Harry,

1 - Is there documentation explaining MS recommendations about SQL
Server setup you're talking about?

2 - Wow, never heard of those disc-alignment issue. Seems to cause
quite of a performance problem. It's surprising people don't talk
about that much. I'll need a bit more reading to understand the
problem better and check if our SAN could suffer from this. I hope
not!

3, 4 - Cluster Index and compatibility mode : Note inserted in my
upgrade plan. :)

Thanks for the tips!

Steeve...

--- In 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
 Harry Deshpande
[EMAIL PROTECTED] wrote:

 Hi

 As per my experience SQL Server 2005 performance is much better
than '2000'.


 1. Please check whether the SQL Server setup is in line with
Microsoft recommendations.

 2. Go further and check things like disc-alignment. Take a
look at
http://sqlblogcasts.com/blogs/christian/archive/2007/10/09/disk-
sector-alignment.aspx

 3. SQL Server 2005 engine is heavily optimized towards
cluster indexes. You will see a lot of cluster indexes introduced
from V4.0 onwards. Please back-port them. However, please note that
there is a small chance that the cluster indexes for some tables in
standard Ax may not be appropriate with your data usage pattern. In
this case you will have to figure out the best fit cluster index
yourself.

 4. Last but not the least make sure you are running the
database with compatibility mode 90. (It is easy to forget this).

 I must say I am a very happy camper since I started using SQL
Server 2005.

 Regards

 Harry



 This posting is provided AS IS with no warranties, and confers no
 rights. Use of included script samples are subject to the terms
 specified at http://www.microsoft.com/info/cpyright.htm;
 The code provided (if any) may be written from the point of view of
a
 third party and the programming style/development standards may suit
 such a point of view.

 From: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
  [mailto:Axapta-
[EMAIL 
PROTECTED]mailto:Knowledge-Village%40yahoogroups.commailto:Knowledge-Village%40yahoogroups.com]
 On Behalf Of Steeve Gilbert
 Sent: Tuesday, December 18, 2007 10:51 AM
 To: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta

RE: [Axapta-Knowledge-Village] Axapta slower on SQL Server 2005 then SQL Server 2000?

[Harry Deshpande]

Hi

As per my experience SQL Server 2005 performance is much better than '2000'.


1.   Please check whether the SQL Server setup is in line with Microsoft 
recommendations.

2.   Go further and check things like disc-alignment. Take a look at 
http://sqlblogcasts.com/blogs/christian/archive/2007/10/09/disk-sector-alignment.aspx

3.   SQL Server 2005 engine is heavily optimized towards cluster indexes. 
You will see a lot of cluster indexes introduced from V4.0 onwards. Please 
back-port them. However, please note that there is a small chance that the 
cluster indexes for some tables in standard Ax may not be appropriate with your 
data usage pattern. In this case you will have to figure out the best fit 
cluster index yourself.

4.   Last but not the least make sure you are running the database with 
compatibility mode 90. (It is easy to forget this).

I must say I am a very happy camper since I started using SQL Server 2005.

Regards

Harry



This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm;
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Steeve Gilbert
Sent: Tuesday, December 18, 2007 10:51 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Axapta slower on SQL Server 2005 then SQL 
Server 2000?


I read a couple of post here and there about Axapta being slower on SQL
Server 2005 then 2000. I thought that people that have problem post
messages and those who don't stays quiet. That's why I was only seeing
post about SQL 2005 being slower. But then I stubble on a post on MBS
forum
(http://www.microsoft.com/Businesssolutions/Community/Newsgroups/dgbrows
er/en-us/default.mspx?
query=sql+2005dg=microsoft.public.axapta.databasecat=lang=encr=USpt
=catlist=8d3f188d-a0E9-40e4-86e2-
46508a35c759dglist=ptlist=exp=sloc=en-us). And the quote is :
First of all Ax database runing on same hardware with SQL2005 is ~20%
slower than SQL200 database (tested).

I can't find something clearer that this. So, does my friends of the
Axapta Knowledge Village acknowledge this statement?

I'm gonna test this in our dev environment and if it turns out true,
then it's gonna be the end of our SQL Server 2005 migration I guess.
Btw, we are staying at Ax3.0 SP3 even if we migrate to SQL 2005.



[Non-text portions of this message have been removed]

RE: [Axapta-Knowledge-Village] Axapta slower on SQL Server 2005 then SQL Server 2000?

[Harry Deshpande]

Hi

Another thing to note is if you are running benchmarks then please run the 
benchmarks in multi-user environment. SQL Server 2005 is much better than 
'2000' in handling multi-user environment. (After all your live system works 
multi-user)

You will get 100% advantage once you upgrade to 4.0+ version since concurrency 
has even been introduced in the AX application.

Regards

Harry


This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm;
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.

From: Harry Deshpande
Sent: Tuesday, December 18, 2007 11:15 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Axapta slower on SQL Server 2005 then 
SQL Server 2000?

Hi

As per my experience SQL Server 2005 performance is much better than '2000'.


1.   Please check whether the SQL Server setup is in line with Microsoft 
recommendations.

2.   Go further and check things like disc-alignment. Take a look at 
http://sqlblogcasts.com/blogs/christian/archive/2007/10/09/disk-sector-alignment.aspx

3.   SQL Server 2005 engine is heavily optimized towards cluster indexes. 
You will see a lot of cluster indexes introduced from V4.0 onwards. Please 
back-port them. However, please note that there is a small chance that the 
cluster indexes for some tables in standard Ax may not be appropriate with your 
data usage pattern. In this case you will have to figure out the best fit 
cluster index yourself.

4.   Last but not the least make sure you are running the database with 
compatibility mode 90. (It is easy to forget this).

I must say I am a very happy camper since I started using SQL Server 2005.

Regards

Harry



This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm;
The code provided (if any) may be written from the point of view of a
third party and the programming style/development standards may suit
such a point of view.

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Steeve Gilbert
Sent: Tuesday, December 18, 2007 10:51 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Axapta slower on SQL Server 2005 then SQL 
Server 2000?


I read a couple of post here and there about Axapta being slower on SQL
Server 2005 then 2000. I thought that people that have problem post
messages and those who don't stays quiet. That's why I was only seeing
post about SQL 2005 being slower. But then I stubble on a post on MBS
forum
(http://www.microsoft.com/Businesssolutions/Community/Newsgroups/dgbrows
er/en-us/default.mspx?
query=sql+2005dg=microsoft.public.axapta.databasecat=lang=encr=USpt
=catlist=8d3f188d-a0E9-40e4-86e2-
46508a35c759dglist=ptlist=exp=sloc=en-us). And the quote is :
First of all Ax database runing on same hardware with SQL2005 is ~20%
slower than SQL200 database (tested).

I can't find something clearer that this. So, does my friends of the
Axapta Knowledge Village acknowledge this statement?

I'm gonna test this in our dev environment and if it turns out true,
then it's gonna be the end of our SQL Server 2005 migration I guess.
Btw, we are staying at Ax3.0 SP3 even if we migrate to SQL 2005.



[Non-text portions of this message have been removed]

RE: [Axapta-Knowledge-Village] select firstonly

[Harry Deshpande]

Hi

May be worthwhile to ' join tableid from inventTable'. This will help slightly 
with indexes that do not have recId.

Regards

Harry


-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Varden Morris
Sent: Thursday, November 01, 2007 8:37 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] select firstonly

You are most welcome. I have done countless tuning with joins as oppose to 
individual selects and see major improvement in performance when the dataset is 
large. Another thing you could do is field select instead of selecting all 
the fields from each table. This can lead to major performance improvement. If 
a table is needed in a join for a filter condition and the fields are not being 
used I usually select the RecId field only to improve performance instead of 
selecting all the fields. For example,

while select ItemId, LineAmount from salesLine
join recId from inventTable
where inventTable.ItemId== salesLine.ItemId
inventTable.ItemGroupId   == 
{
//Use ItemID and LineAmount (only) here
}

Selecting two out of 60 fields means a significant reduction in the amount of 
data being fetched from the database sitting on one server to the AOS and/or 
client on other computers across a network. You have to be careful with the 
field select at times. It can lead to a bug if you decide to use an additional 
field and you forget to add it to the select statement.

Regards,

Varden Morris

276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada

(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED]





- Original Message 
From: James Flavell [EMAIL PROTECTED]
To: Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, November 1, 2007 9:17:25 AM
Subject: RE: [Axapta-Knowledge-Village] select firstonly

Thanks Varden,

Yes you are very correct.
I guess I will test with the join. The concern I had was both tables are
quite large in number of transactions so I was not sure join would work out
to be the best approach but I think yes I should test it out to see. :)

Thanks
James

_

From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
[mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris
Sent: 01 November 2007 11:02
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] select firstonly

You can surely save on the number of calls being made to the database by
joining the two tables in the while select instead of separate calls to the
database for the while select followed by another select. If you do not use
the index hint the database will choose an optimum index, provided that
indexes exist and the database is configured to collect and update the
statistics periodically.

Regards,

Varden Morris

276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada

(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED] mailto:vardenm% 40yahoo.com com

- Original Message 
From: James Flavell [EMAIL PROTECTED] mailto:djf1994% 40gmail.com com
To: Axapta-Knowledge- mailto:Axapta- Knowledge- Village%40yahoog roups.com
[EMAIL PROTECTED] .com
Sent: Thursday, November 1, 2007 8:05:29 AM
Subject: [Axapta-Knowledge- Village] select firstonly

Hi again everyone,

Thanks Christoph for the feebdack on index. I have added indexes just to
play safe.

Another query I have is with the firstonly command. I understand basically
how it works but want to know how it really works in practice

Given this code:

while select WMSPallet
order by WMSPalletId
{
select firstonly InventPalletBP
where InventPalletBP. PalletId ==
WMSPallet.wMSPallet Id;

}

Is it better to use firstonly in such a situation?

I mean I am going to be looping through pallets so if I dont use firstonly a
number of inventpalletbp table records will be fetched together which in
theory would be a good thing to save on database calls. But then i am
wondering will the records that are fetched be in any particualr order (e.g.
by palletid) or just from the same page in the SQL server? I guess it
should be read ahead according to the where clause or do I need to
explicitly put an order by or index command against the InventPalletBP
select statement to be sure of this?

Looking forward to your input

Thanks
James

[Non-text portions of this message have been removed]

 _ _ _ _ __
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail. http://mail. yahoo.com yahoo.com

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]




__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]



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

RE: [Axapta-Knowledge-Village] select firstonly

[Harry Deshpande]

Hi

If recid is not part of the index then the logic has to do one more lookup to 
get the recid. With tableId you get rid of this problem.

There are some inventory report where I remember this design has been 
implemented.

Regards

Harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Varden Morris
Sent: Thursday, November 01, 2007 9:27 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] select firstonly


Hey Harry,

This sounds new and unclear to me. Can you please give me some more details on 
what you are saying here?

Regards,

Varden Morris

276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada

(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED]mailto:vardenm%40yahoo.com



- Original Message 
From: Harry Deshpande [EMAIL PROTECTED]mailto:harryd%40microsoft.com
To: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
Sent: Thursday, November 1, 2007 10:15:56 AM
Subject: RE: [Axapta-Knowledge-Village] select firstonly

Hi

May be worthwhile to ' join tableid from inventTable' . This will help slightly 
with indexes that do not have recId.

Regards

Harry

-Original Message-
From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta-Knowledge- 
[EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris
Sent: Thursday, November 01, 2007 8:37 AM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] select firstonly

You are most welcome. I have done countless tuning with joins as oppose to 
individual selects and see major improvement in performance when the dataset is 
large. Another thing you could do is field select instead of selecting all 
the fields from each table. This can lead to major performance improvement. If 
a table is needed in a join for a filter condition and the fields are not being 
used I usually select the RecId field only to improve performance instead of 
selecting all the fields. For example,

while select ItemId, LineAmount from salesLine
join recId from inventTable
where inventTable. ItemId == salesLine.ItemId
 inventTable. ItemGroupId == 
{
//Use ItemID and LineAmount (only) here
}

Selecting two out of 60 fields means a significant reduction in the amount of 
data being fetched from the database sitting on one server to the AOS and/or 
client on other computers across a network. You have to be careful with the 
field select at times. It can lead to a bug if you decide to use an additional 
field and you forget to add it to the select statement.

Regards,

Varden Morris

276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada

(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED] com

- Original Message 
From: James Flavell [EMAIL PROTECTED] com
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Sent: Thursday, November 1, 2007 9:17:25 AM
Subject: RE: [Axapta-Knowledge- Village] select firstonly

Thanks Varden,

Yes you are very correct.
I guess I will test with the join. The concern I had was both tables are
quite large in number of transactions so I was not sure join would work out
to be the best approach but I think yes I should test it out to see. :)

Thanks
James

_

From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
[mailto:Axapta- Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris
Sent: 01 November 2007 11:02
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] select firstonly

You can surely save on the number of calls being made to the database by
joining the two tables in the while select instead of separate calls to the
database for the while select followed by another select. If you do not use
the index hint the database will choose an optimum index, provided that
indexes exist and the database is configured to collect and update the
statistics periodically.

Regards,

Varden Morris

276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada

(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED] mailto:vardenm% 40yahoo.com com

- Original Message 
From: James Flavell [EMAIL PROTECTED] mailto:djf1994% 40gmail.com com
To: Axapta-Knowledge- mailto:Axapta- Knowledge- Village%40yahoog roups.com
[EMAIL PROTECTED] .com
Sent: Thursday, November 1, 2007 8:05:29 AM
Subject: [Axapta-Knowledge- Village] select firstonly

Hi again everyone,

Thanks Christoph for the feebdack on index. I have added indexes just to
play safe.

Another query I have is with the firstonly command. I understand basically
how it works but want to know how it really works in practice

Given this code:

while select WMSPallet
order by WMSPalletId
{
select firstonly InventPalletBP
where InventPalletBP. PalletId ==
WMSPallet.wMSPallet Id;

}

Is it better to use firstonly in such a situation?

I mean I am going to be looping through pallets so if I dont use

RE: [Axapta-Knowledge-Village] select firstonly

[Harry Deshpande]

No, I don't think tableId is part of the index. Let me check the actual SQL 
syntax generated and get back to you.

Regards

harry

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Varden Morris
Sent: Thursday, November 01, 2007 9:36 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] select firstonly


Ok, I think I may understand what you are saying. Are you refering to a cover 
index where the database uses the fields in the index page as the data without 
using the data page (provided that all the required data fields are in the 
index)? If this is so, are you saying that the tableId is usually apart of all 
indexes created for tables in DAX?

Regards,

Varden Morris

276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada

(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED]mailto:vardenm%40yahoo.com



- Original Message 
From: Harry Deshpande [EMAIL PROTECTED]mailto:harryd%40microsoft.com
To: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
Sent: Thursday, November 1, 2007 10:29:52 AM
Subject: RE: [Axapta-Knowledge-Village] select firstonly

Hi

If recid is not part of the index then the logic has to do one more lookup to 
get the recid. With tableId you get rid of this problem.

There are some inventory report where I remember this design has been 
implemented.

Regards

Harry

From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta-Knowledge- 
[EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris
Sent: Thursday, November 01, 2007 9:27 AM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] select firstonly

Hey Harry,

This sounds new and unclear to me. Can you please give me some more details on 
what you are saying here?

Regards,

Varden Morris

276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada

(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED] commailto:vardenm% 40yahoo.com

- Original Message 
From: Harry Deshpande [EMAIL PROTECTED] commailto:harryd% 40microsoft. com
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.commailto:Axapta- Knowledge- 
Village%40yahoog roups.com  Axapta-Knowledge- [EMAIL PROTECTED] 
ups.commailto:Axapta- Knowledge- Village%40yahoog roups.com 
Sent: Thursday, November 1, 2007 10:15:56 AM
Subject: RE: [Axapta-Knowledge- Village] select firstonly

Hi

May be worthwhile to ' join tableid from inventTable' . This will help slightly 
with indexes that do not have recId.

Regards

Harry

-Original Message-
From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge- 
[EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris
Sent: Thursday, November 01, 2007 8:37 AM
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] select firstonly

You are most welcome. I have done countless tuning with joins as oppose to 
individual selects and see major improvement in performance when the dataset is 
large. Another thing you could do is field select instead of selecting all 
the fields from each table. This can lead to major performance improvement. If 
a table is needed in a join for a filter condition and the fields are not being 
used I usually select the RecId field only to improve performance instead of 
selecting all the fields. For example,

while select ItemId, LineAmount from salesLine
join recId from inventTable
where inventTable. ItemId == salesLine.ItemId
 inventTable. ItemGroupId == 
{
//Use ItemID and LineAmount (only) here
}

Selecting two out of 60 fields means a significant reduction in the amount of 
data being fetched from the database sitting on one server to the AOS and/or 
client on other computers across a network. You have to be careful with the 
field select at times. It can lead to a bug if you decide to use an additional 
field and you forget to add it to the select statement.

Regards,

Varden Morris

276 Taralake Terrace N.E.
Calgary, Alberta T3J 0A1
Canada

(403) 366-8434 (H)
(403) 615-1604 (C)
[EMAIL PROTECTED] com

- Original Message 
From: James Flavell [EMAIL PROTECTED] com
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Sent: Thursday, November 1, 2007 9:17:25 AM
Subject: RE: [Axapta-Knowledge- Village] select firstonly

Thanks Varden,

Yes you are very correct.
I guess I will test with the join. The concern I had was both tables are
quite large in number of transactions so I was not sure join would work out
to be the best approach but I think yes I should test it out to see. :)

Thanks
James

_

From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
[mailto:Axapta- Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Varden Morris
Sent: 01 November 2007 11:02
To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
Subject: Re: [Axapta-Knowledge- Village] select firstonly

You can surely save on the number of calls

[Axapta-Knowledge-Village] www.systomatics.com

[Harry Deshpande]

Hi

The site is updated with a new blog

Regards

Harry



[Non-text portions of this message have been removed]

RE: [Axapta-Knowledge-Village] Re: Planned purchase vs ended works order

[Harry Deshpande]

Hi

Do you see any childRefId for such inventory transactions (with remaining qty  
0)?

Regards

harry

From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of nevarcretep
Sent: Friday, July 13, 2007 11:06 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: Planned purchase vs ended works order


Did you ever find a solution to this issue. We too are experiencing
this event, planning orders with an ENDED status.

--- In 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
 Jens Strandberg
[EMAIL PROTECTED] wrote:

 Hello there,

 I was wondering if any of you have encountered this problem.

 During master planning we have noticed that Ax will create a couple
of
 planned purchase order for works orders with the
status Ended... :-(

 If I browse through the production BOM, I can still see items with a
 remaining qty - event though the works order is ended.

 How can this happen ? I would pretty much think that this is a
(major)
 bug, since I would expect the logic to clear all remaining qty's
during
 the closing of the works order.

 Any thoughts ? Thanks in advance.

 Best Regards,
 /Jens

 Running Ax 3.0 SP4.




[Non-text portions of this message have been removed]

[Axapta-Knowledge-Village] Systomatics.com

[Harry Deshpande]

Hi

I have updated systomatics.com with a new blog

Regards

Harry
Ps: Please note that I will removing all code from this website very soon.




[Non-text portions of this message have been removed]

RE: [Axapta-Knowledge-Village] Master Scheduling

[Harry Deshpande]

hi

check under inquiries action messages. If the form does not show action for 
cancelling quantity then check you action messages settings

regards

harry


From: Axapta-Knowledge-Village@yahoogroups.com [EMAIL PROTECTED] On Behalf Of 
vijay_navaxapta [EMAIL PROTECTED]
Sent: Wednesday, February 07, 2007 12:07 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Master Scheduling


Hi,
I have a sales Order for an Item-K-TRD-1000, Qty=10, DelDate=30th
April,2007. I run the Master scheduling for the above Item.

System creates a planned Purchase Order for Qty 10 and same is
converted into a Regular Purchase Order.

After creation of Purchase Order, customer cancels the Order and
consequently Sales Order is deleted,

I run once again the Master scheduling for the above Item. System
does not suggest to cancel the Purchase Order as there is no Demand.

Can anybody explain why?

Because I expect the system to cancel Purchase Order as there is no
Demand to match this supply.

Thanks and Regards.

Vijay

RE: [Axapta-Knowledge-Village] Master Planning Requirement

[Harry Deshpande]

Look at Reqcalc-covCodeQty,  use date of _issue to determine whether to use 
min-max or just min qty

Regards

Harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of varsityblews
Sent: Friday, February 02, 2007 6:46 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Master Planning Requirement


Hi all

One of our clients requires the following. For the first half of the
month they want the master planning to plan a purchase order using
the min/max levels ie. create a requirement for the maximum quantity
if stock goes below minimum, which is fine. But what they also want
is in the second half of the month the plan should create a planned
order only for the minimum quantity. As far as I know Axapta doesnt
do this. I have tried to add 2 item coverage lines, each linked to a
different coverage group as shown below:

WH Min Max Coverage Group
X 40 85 First Half
X 40 40 Second Half

The problem with this firstly, is that AX doesnt allow you to add a
coverge for the same warehouse twice, so i put it into different
warehouses just to see. I then set default coverage on MRP
Parameters to First Half (the item has a blank coverage in item
master at this point). When i ran the plan it created 2 lines, one
for 85 and one for 40. Does anyone have any ideas on how to achieve
this. Your help would really be appreciated.

Regards
Pragashnee



[Non-text portions of this message have been removed]

RE: [Axapta-Knowledge-Village] Re: Production closing error: Quantity ordered may not be reduced, as there are

[Harry Deshpande]

Hi

Ok now copy the data to a test system. Clear out the inventory reference (set 
it to none) and inventory reference number (set it to ) manually. Close the 
production order and check if the problem goes away. This will confirm the root 
cause of the problem

Regards

Harry



From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of futzawm
Sent: 22 January 2007 18:33
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: Production closing error: Quantity 
ordered may not be reduced, as there are


Hi Harry, thanks for the response. I can't find the line in any of the
BoM journals (there isn't a BoM journal associated with that
particular production which has not been registered). So just to be
sure, would the line in the database you mention be the line in the
'InventTrans' table--i.e., the line with references?

Thanks again!
Mikki

--- In 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
 Harry Deshpande
[EMAIL PROTECTED] wrote:

 Hi

 If this field is filled up then there is a BOM journal that has not
been posted. If you cant see this in the form then search for the line
in the database.

 If (you find the line)
 Delete this line and you should be ok
 else
 Let me know.

 Regards

 Harry




 This posting is provided AS IS with no warranties, and confers no
rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm;

 The code provided (if any) may be written from the point of view of
a third party and the programming style/development standards may suit
such a point of view.



 
 From: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
[mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of futzawm
 Sent: 17 January 2007 18:21
 To: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 Subject: [Axapta-Knowledge-Village] Re: Production closing error:
Quantity ordered may not be reduced, as there are


 Thanks for your response, Harry. I believe you are referring to the
 'General' tab of the 'Transactions' form. Yes, there's an inventory
 reference (the field is 'TransChildRefId' and the Type is 'Picking
 List Journal'). Would that be of significance? Note that the status of
 the transaction is 'On order' as pointed out in my original question.

 Regards.
 Mikki

 --- In
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
Harry Deshpande
 harryd@ wrote:
 
  hi
 
  Is there any inventory reference on the inventory transaction for
 the item? I dont have Ax in front of me right now, but this reference
 is I think on the second tab and the field is InventRefChildId or
 something similar
 
  regards
 
  harry
 
  
  From:
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com

[EMAIL 
PROTECTED]mailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com]
On Behalf Of futzawm
 [EMAIL PROTECTED]
  Sent: Monday, January 15, 2007 9:23 PM
  To:
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
  Subject: [Axapta-Knowledge-Village] Production closing error:
 Quantity ordered may not be reduced, as there are..
 
 
  Please help on the following problem (I have seen similar questions in
  the forum but none Were resolved):
 
  We are trying to close a production order and the following error is
  being generated:
 
  Calculating BOM Consumption
  Posting - Picking list journal
  Journal: PJ
  Voucher: PV
  Line No: 1
  Item No: 00123
 
  Quantity ordered may not be reduced, as there are not enough stock
  transactions with 'on order' status.
  The items are 'Sold', 'Deducted' or 'Picked'.
 
  The production was started with the item in question but another item
  was substituted during production. Registration of the picking list
  journal was thus done with the item consumption = 0. There are no
  transactions with 'Sold', 'Deducted' or 'Picked' status for the item
  as referring to that particular production. However, the item
  transactions show a quantity equal to the original started quantity
  with status 'On Order' for that particular production (therefore, no
  reason for the error not enough stock transactions with 'On Order'
  status). I saw one earlier response to this type of problem by
  fvatne where it was suggested that the problem can be a result of
  mismatch between different dimensions. This seemed a logical reason
  but the problem was not solved even after we removed all dimension
  restrictions

RE: [Axapta-Knowledge-Village] Re: Production closing error: Quantity ordered may not be reduced, as there are

[Harry Deshpande]

hi

The two fields on inventtrans transchildtype and transchildrefid. you will have 
to change the field properties to enable allowedit

regards

harry


This posting is provided AS IS with no warranties, and confers no
 rights. Use of included script samples are subject to the terms
 specified at http://www.microsoft.com/info/cpyright.htm;
 
  The code provided (if any) may be written from the point of view of
 a third party and the programming style/development standards may suit
 such a point of view.

From: Axapta-Knowledge-Village@yahoogroups.com [EMAIL PROTECTED] On Behalf Of 
futzawm [EMAIL PROTECTED]
Sent: Tuesday, January 23, 2007 8:49 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: Production closing error: Quantity 
ordered may not be reduced, as there are


I am sorry Harry, but exactly where and how do I do that? I mean I
copied the data to a test environment and I do know how to make manual
changes on tables (though I am very uncomfortable doing that). But I
am not sure exactly which table and exactly which fields to change
(clear out the inventory reference, inventory reference number).
Thanks for bearing with me!

Mikki

--- In 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
 Harry Deshpande
[EMAIL PROTECTED] wrote:

 Hi

 Ok now copy the data to a test system. Clear out the inventory
reference (set it to none) and inventory reference number (set it to
) manually. Close the production order and check if the problem goes
away. This will confirm the root cause of the problem

 Regards

 Harry


 
 From: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
[mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of futzawm
 Sent: 22 January 2007 18:33
 To: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 Subject: [Axapta-Knowledge-Village] Re: Production closing error:
Quantity ordered may not be reduced, as there are


 Hi Harry, thanks for the response. I can't find the line in any of the
 BoM journals (there isn't a BoM journal associated with that
 particular production which has not been registered). So just to be
 sure, would the line in the database you mention be the line in the
 'InventTrans' table--i.e., the line with references?

 Thanks again!
 Mikki

 --- In
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
Harry Deshpande
 harryd@ wrote:
 
  Hi
 
  If this field is filled up then there is a BOM journal that has not
 been posted. If you cant see this in the form then search for the line
 in the database.
 
  If (you find the line)
  Delete this line and you should be ok
  else
  Let me know.
 
  Regards
 
  Harry
 
 
 
 
  This posting is provided AS IS with no warranties, and confers no
 rights. Use of included script samples are subject to the terms
 specified at http://www.microsoft.com/info/cpyright.htm;
 
  The code provided (if any) may be written from the point of view of
 a third party and the programming style/development standards may suit
 such a point of view.
 
 
 
  
  From:
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com

[mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com]
On Behalf Of futzawm
  Sent: 17 January 2007 18:21
  To:
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
  Subject: [Axapta-Knowledge-Village] Re: Production closing error:
 Quantity ordered may not be reduced, as there are
 
 
  Thanks for your response, Harry. I believe you are referring to the
  'General' tab of the 'Transactions' form. Yes, there's an inventory
  reference (the field is 'TransChildRefId' and the Type is 'Picking
  List Journal'). Would that be of significance? Note that the status of
  the transaction is 'On order' as pointed out in my original question.
 
  Regards.
  Mikki
 
  --- In

Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
 Harry Deshpande
  harryd@ wrote:
  
   hi
  
   Is there any inventory reference on the inventory transaction for
  the item? I dont have Ax in front of me right now, but this reference
  is I think on the second tab and the field is InventRefChildId or
  something similar
  
   regards
  
   harry
  
   
   From:

Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village

RE: [Axapta-Knowledge-Village] Re: Production closing error: Quantity ordered may not be reduced, as there are

[Harry Deshpande]

Hi

If this field is filled up then there is a BOM journal that has not been 
posted. If you cant see this in the form then search for the line in the 
database.

If (you find the line)
 Delete this line and you should be ok
else
 Let me know.

Regards

Harry




This posting is provided AS IS with no warranties, and confers no rights. Use 
of included script samples are subject to the terms specified at 
http://www.microsoft.com/info/cpyright.htm;

The code provided (if any) may be written from the point of view of a third 
party and the programming style/development standards may suit such a point of 
view.




From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of futzawm
Sent: 17 January 2007 18:21
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: Production closing error: Quantity 
ordered may not be reduced, as there are


Thanks for your response, Harry. I believe you are referring to the
'General' tab of the 'Transactions' form. Yes, there's an inventory
reference (the field is 'TransChildRefId' and the Type is 'Picking
List Journal'). Would that be of significance? Note that the status of
the transaction is 'On order' as pointed out in my original question.

Regards.
Mikki

--- In 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
 Harry Deshpande
[EMAIL PROTECTED] wrote:

 hi

 Is there any inventory reference on the inventory transaction for
the item? I dont have Ax in front of me right now, but this reference
is I think on the second tab and the field is InventRefChildId or
something similar

 regards

 harry

 
 From: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
[EMAIL PROTECTED]mailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf 
Of futzawm
[EMAIL PROTECTED]
 Sent: Monday, January 15, 2007 9:23 PM
 To: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 Subject: [Axapta-Knowledge-Village] Production closing error:
Quantity ordered may not be reduced, as there are..


 Please help on the following problem (I have seen similar questions in
 the forum but none Were resolved):

 We are trying to close a production order and the following error is
 being generated:

 Calculating BOM Consumption
 Posting - Picking list journal
 Journal: PJ
 Voucher: PV
 Line No: 1
 Item No: 00123

 Quantity ordered may not be reduced, as there are not enough stock
 transactions with 'on order' status.
 The items are 'Sold', 'Deducted' or 'Picked'.

 The production was started with the item in question but another item
 was substituted during production. Registration of the picking list
 journal was thus done with the item consumption = 0. There are no
 transactions with 'Sold', 'Deducted' or 'Picked' status for the item
 as referring to that particular production. However, the item
 transactions show a quantity equal to the original started quantity
 with status 'On Order' for that particular production (therefore, no
 reason for the error not enough stock transactions with 'On Order'
 status). I saw one earlier response to this type of problem by
 fvatne where it was suggested that the problem can be a result of
 mismatch between different dimensions. This seemed a logical reason
 but the problem was not solved even after we removed all dimension
 restrictions on the particular item. How would we be able to resolve
 this problem? Would be very grateful for some pointers.

 Thanks.
 Mikki




[Non-text portions of this message have been removed]

RE: [Axapta-Knowledge-Village] Re: updating problem at production

[Harry Deshpande]

Check the inventory transactions for the production order, what do you see? 
What is the quantity of the production order vs inventory transaction quantity

Regards

harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of IRWAN
Sent: 15 January 2007 05:41
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: updating problem at production


We also have the similar problem as that. We received message
Quantity ordered cannot be reduced, as there are not enough inventory
transaction with the 'on order' status. can anyone help me ?

--- In 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
 fvatne [EMAIL PROTECTED]
wrote:

 Hi
 The problem is that there is not a match between the different
 dimensions E.g. Batch number at the one and not at the other one.

 --- In 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com,
  Hulya Erginler
 hulyaerginler@ wrote:
 
  Hi,
  we update our production orders as  end .
  at some production orders, we having an error
 message. Quantity ordered cannot be reduced, as there are not enough
 open inventory transactions with the Ordered status.
 and we can not finish update.
  Orders have picking list journals, job cards,
 reported as finished journals and they are posted.
  what must we do to finish update?
  many thanks for your answer.
  Hulya Erginler
 
 
 
 
 
 
 
  -
  Need a quick answer? Get one in minutes from people who know. Ask
 your question on Yahoo! Answers.
 
  [Non-text portions of this message have been removed]
 




[Non-text portions of this message have been removed]

RE: RE: [Axapta-Knowledge-Village] Item Master Record

[Harry Deshpande]

It does not take much time to do this*s*, and one can easily delete the 
modification once done.



From: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
[mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of Jens
Strandberg
Sent: Friday, January 05, 2007 4:02 AM
To: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Item Master Record

Okay ... :-)

I just find it a little drastic to delete the DS. Comparing records in
Table
Browser should also give some pointers ...

Best Regards,
Jens

_

From: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
mailto:Axapta-Knowledge-Village%40yahoogroups.com
[mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of Harry
Deshpande
Sent: Friday, January 05, 2007 9:54 AM
To: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
mailto:Axapta-Knowledge-Village%40yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Item Master Record

Hi

If this datasource is deleted and the records show up then we know that
the
problem is with inventitemlocation otherwise we know that the problem is
with inventtablemodule

That's how I figured out the problem when I first encountered it*s*

Regards

Harry


From: Axapta-Knowledge-
mailto:Axapta-Knowledge-Village%40yahoogroups.com
[EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
mailto:Village%40yahoogroups.com
[mailto:Axapta-Knowledge-
mailto:Axapta-Knowledge-Village%40yahoogroups.com
[EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
mailto:Village%40yahoogroups.com ]
On Behalf Of Jens Strandberg
Sent: 05 January 2007 09:39
To: Axapta-Knowledge-
mailto:Axapta-Knowledge-Village%40yahoogroups.com
[EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
mailto:Village%40yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Item Master Record

Hello Harry,

You lost me here ... :-)

/Jens

_

From: Axapta-Knowledge-
mailto:Axapta-Knowledge-Village%40yahoogroups.com
[EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
mailto:Village%40yahoogroups.com
mailto:Axapta-Knowledge-Village%40yahoogroups.com
[mailto:Axapta-Knowledge-
mailto:Axapta-Knowledge-Village%40yahoogroups.com
[EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
mailto:Village%40yahoogroups.com
mailto:Axapta-Knowledge-Village%40yahoogroups.com]
On Behalf Of Harry
Deshpande
Sent: Friday, January 05, 2007 9:21 AM
To: Axapta-Knowledge-
mailto:Axapta-Knowledge-Village%40yahoogroups.com
[EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
mailto:Village%40yahoogroups.com
mailto:Axapta-Knowledge-Village%40yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Item Master Record

Hi

From the inventtable form delete the datasource inventitemlocation and
check
if the form now shows records.

Regards

Harry


From: Axapta-Knowledge-
mailto:Axapta-Knowledge-Village%40yahoogroups.com
[EMAIL PROTECTED] mailto:Village%40yahoogroups.com
.commailto:Village%40yahoogroups.com [mailto:Axapta-Knowledge-
mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED]
mailto:Village%40yahoogroups.com
.commailto:Village%40yahoogroups.com]
On Behalf Of faiqa.khushi@ mailto:faiqa.khushi%40m-consultants.com
m-consultants.com
Sent: 04 January 2007 11:52
To: Axapta-Knowledge-
mailto:Axapta-Knowledge-Village%40yahoogroups.com
[EMAIL PROTECTED] mailto:Village%40yahoogroups.com
.commailto:Village%40yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Item Master Record

Thanks Harry.

I have searched and read that post but I have already done what they
have
suggested . I had tried following tables but still could not see item
records in the form

InventTable,
InventTableModule

InventItemLocation.

Can anyone please guide me in this regard.

Thanks

From: Axapta-Knowledge-
mailto:Axapta-Knowledge-Village%40yahoogroups.com
[EMAIL PROTECTED] mailto:Village%40yahoogroups.com
.commailto:Village%40yahoogroups.commailto:Axapta-Knowledge-Village%4
0yah
oogroups.com
[mailto:Axapta-Knowledge-
mailto:Axapta-Knowledge-Village%40yahoogroups.com
[EMAIL PROTECTED] mailto:Village%40yahoogroups.com
.commailto:Village%40yahoogroups.commailto:Axapta-Knowledge-Village%4
0yah
oogroups.com]
On Behalf Of Harry
Deshpande
Sent: Thursday, January 04, 2007 3:19 PM
To: Axapta-Knowledge-
mailto:Axapta-Knowledge-Village%40yahoogroups.com
[EMAIL PROTECTED] mailto:Village%40yahoogroups.com
.commailto:Village%40yahoogroups.commailto:Axapta-Knowledge-Village%4
0yah
oogroups.com
Subject: RE: [Axapta-Knowledge-Village] Item Master Record

Hi

Please search the previous posts, this has already been discussed
multiple
times*s*

Regards

Harry


From

RE: [Axapta-Knowledge-Village] Item Master Record

[Harry Deshpande]

Hi

Please search the previous posts, this has already been discussed multiple 
times*s*

Regards

Harry



From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of [EMAIL PROTECTED]
Sent: 04 January 2007 06:22
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Item Master Record


Hi everyone,

I am trying to import inventory master record in Inventory Management module
using InvenTable. It imports record successfully but don't show records in
Item form.

Can anyone please guide if I have missed something?

Regards.

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]

RE: RE: [Axapta-Knowledge-Village] Number sequence-Error

[Harry Deshpande]

Hi

I bet it is the missing reference in CRM module.*s*

Regards

harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Bonk, David
Sent: 29 December 2006 14:58
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Number sequence-Error


It sounds like you are entering a customer number yourself which is
conflicting with how you have the number sequence set-up for the
customer numbering. You either have a mask that is different from what
you are entering or you have it set to continuous which means that the
system needs to allocate the next number. If you had the wizard create
the number sequences then the one for customers would be Acco_16; review
the set-up.

David



From: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
[mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of
k.v.s.sitaram
Sent: Tuesday, December 26, 2006 2:13 AM
To: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
Subject: [Axapta-Knowledge-Village] Number sequence-Error

Hi,
When I tried to save a created vendor/Customer account,it is informing
that,Number sequence not defined properly.
Please advice me

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]

[Axapta-Knowledge-Village] RE: www.systomatics.com

[Harry Deshpande]

hi

the downloadable xpo file was not accessible, now it is accessible.

regards

harry


From: Harry Deshpande
Sent: Monday, December 18, 2006 5:44 PM
To: 'Axapta-Knowledge-Village@yahoogroups.com'; 
development-axapta@yahoogroups.com
Subject: www.systomatics.com

Hi

www.systomatics.com is updated with a new project

Regards

harry

From: Harry Deshpande
Sent: Monday, December 18, 2006 12:24 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Re: Ax 4.0 login screen as 3.0

Hi

Read this link to understand why the passwords should not be stored in the 
database

http://en.wikipedia.org/wiki/MD5

regards

harry



From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Ax Dev
Sent: 18 December 2006 12:06
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Re: Ax 4.0 login screen as 3.0


Hi Friends,

It was asked from one of our costumers as well. Does anyone has the
solution of how to provide the same kind of user input in Ax4.0 as we have
in Ax3.0?

It is something very interesting and we are curious to know about it. Please
share your views.

Thanks  Regards,
Harsh

On 12/18/06, John Lindsay [EMAIL PROTECTED]mailto:jtl%40dragonsfoot.com 
wrote:

 You can use the runas command to change the user

 Confidentiality Notice: This e-mail contains confidential and/or
 privileged
 information and is intended to be read only by the person or authorized
 representative of the organization to whom it is addressed. If you are
 neither of these persons, you have received this e-mail in error. Please
 do
 not print, copy, re-transmit, disseminate or otherwise use the
 information,
 all of which are prohibited. Please immediately notify the sender by
 return
 e-mail or by telephone at (303) 593-1246 that you have received this
 communication in error and delete this e-mail from your system. Thank you.

 MBS Dynamics AX Master

 John T. Lindsay

 Micro Sciences

 303 593-1246

 720 982-4620

 _

 From: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 [mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of Andreas
 Rudischhauser
 Sent: Saturday, December 16, 2006 4:48 AM
 To: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 Subject: AW: [Axapta-Knowledge-Village] Re: Ax 4.0 login screen as 3.0

 Please contact Mr. Schuster on schuster(AT)back2.biz.

 Von: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com
 [mailto:Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com]
 Im Auftrag von Hardi
 Gesendet: Samstag, 16. Dezember 2006 00:52
 An: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com
 Betreff: [Axapta-Knowledge-Village] Re: Ax 4.0 login screen as 3.0

 As Ax40 is integrated with active directory, I think what is
 required is to prompt user to re-enter login/password when
 application started.
 This is something being asked too from my customer.

 Thanks

 Hardi

 --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoog
 roups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com , Jake
 [EMAIL PROTECTED] wrote:
 
  Hi Andreas -
 
  Do you have any info on how this is being done? Are you doing a
  second Active Directory login?
 
  Thanks, Jake
 
  http://axaptasource http://axaptasource.com .com
 
  --- In Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com , Andreas
  Rudischhauser Andreas.Rudischhauser@ wrote:
  
   We're currently in development. I will post the link here in a
 few
  days
  
  
  
   Von: Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
   [mailto:Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com ] Im Auftrag von
  Agus
   Riyadi
   Gesendet: Donnerstag, 14. Dezember 2006 03:14
   An: Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com
 mailto:Axapta-Knowledge

RE: [Axapta-Knowledge-Village] Job scheduling margin

[Harry Deshpande]

Hi

Exactly what do you want? Any example?

Regards

Harry



From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Syner P
Sent: 20 December 2006 09:00
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Job scheduling margin


Hi,

I have a problem with manual planning. When job scheduling backwards from the 
delivery date, we want to have a margin. But couldn't find a parameter to 
adjust.

Any help appreciated.

( I tried coverage group safety margin but it is not working.)

Regards,
Syner

__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]

RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line!!!!

[Harry Deshpande]

Hi

Routing this thru official Microsoft support is the right way to do it. What 
you have in your hand is quite unusual and the problem may lie outside master 
planning or imts

Regards

Harry



From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Ricardo Cortés
Sent: 19 December 2006 17:44
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion feature at 
the sales line


Hi,
No, after deleting the plan and run again the regeneration worked, but to test 
more I let the users play in the environment and after a few hours I tested and 
it didn't work again. I don't know what is happening.

Some guy from microsoft say that might be the *.aoc file but i don't know. What 
do you think?

I'm having this issue in differents pc and with differents users.

Regards

Harry Deshpande [EMAIL PROTECTED]mailto:harryd%40microsoft.com escribió:
Hi

'delete the plan'? So after deleting the plan and running 'net change' your 
problem gets solved?

Regards

harry


From: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 
[mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of Ricardo Cortés
Sent: 18 December 2006 23:21
To: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion feature at 
the sales line

Hi,

If I run the master planning in net change the problem persist, what i'm doing 
now is deleting the plan and doing the scenario, it seems to be working now, 
but what i don't like is the fact you need to delete the plan or make a 
regeneration to make it works.

Do you think is a problem the way the master plan tables are updated?

Regards

Ricardo Cortes

Harry Deshpande [EMAIL 
PROTECTED]mailto:harryd%40microsoft.commailto:harryd%40microsoft.com 
escribió:
hi

ok, this is different. If 38 records are being created then it seems the 
problem is in master planning.

Just to make sure, try the following:

after invocing the sales order, go into the net requirements screen and run 
update net requirements (principle : net change). Do you still have the same 
problem?

Have you been able to repro this on the demo system?

regards

harry


From: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL 
PROTECTED]mailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of Ricardo Cortés [EMAIL 
PROTECTED]mailto:ricardocortesrivero%40yahoo.com.mxmailto:ricardocortesrivero%40yahoo.com.mx]
Sent: Monday, December 18, 2006 8:10 PM
To: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion feature at 
the sales line

Hi Harry,

I've been lookig at the InventSumLogTTS table and in each step creates records, 
but in each step creates more than one record. After finishinsihing the last 
step(invoice the sales) the item had 38 records.

After, I created a new sales order and i did the explosion, but the system 
showed me onhand. I checked the InventSumLogTTS, and the system added just a 
new record for that sales order.

Only running the master scheduling in regeneration worked to create thye 
planned purchse order, because with this that table get clean.

Do you know what is causing this problem?

Regards,

Ricardo Cortes

Harry Deshpande [EMAIL 
PROTECTED]mailto:harryd%40microsoft.commailto:harryd%40microsoft.commailto:harryd%40microsoft.com
 escribió:
Hi

It looks like the problem is with InventSumLogTTS and not with master planning.

Check the records in inventsumlogtts after each step (the steps are slightly 
different)

i.e

1. create sales order
2. create purchase order
3. receive item
4. post sales

Ideally you should have records created in InventSumLogTTS after each step. 
Please also try this on standard installation.

regards

harry


From: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 
[mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of Ricardo Cortés
Sent: 18 December 2006 02:00
To: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
Subject: RE: [Axapta-Knowledge

RE: [Axapta-Knowledge-Village] Job scheduling margin

[Harry Deshpande]

Hi

Did u try safety margins on coverage groups?

Regards

Harry



From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Syner P
Sent: 20 December 2006 13:11
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Job scheduling margin


Of course. Lets assume we have an sales order to be shipped on 20.02.2002.
And related production order. If I job schedule the production order with the 
backwards from the delivery date method, the system starts allocating the 
capacity backwards from 20.02.2002 and the time point given in Master planning 
parameter/planned orders receipt time.

But we want for example always to start 2 days before the given delivery date.

Regards,
Syner

- Original Message 
From: Harry Deshpande [EMAIL PROTECTED]mailto:harryd%40microsoft.com
To: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
Sent: Wednesday, December 20, 2006 1:06:40 PM
Subject: RE: [Axapta-Knowledge-Village] Job scheduling margin

Hi

Exactly what do you want? Any example?

Regards

Harry

 _ _ __

From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta-Knowledge- 
[EMAIL PROTECTED] ups.com] On Behalf Of Syner P

Sent: 20 December 2006 09:00

To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com

Subject: [Axapta-Knowledge- Village] Job scheduling margin

Hi,

I have a problem with manual planning. When job scheduling backwards from the 
delivery date, we want to have a margin. But couldn't find a parameter to 
adjust.

Any help appreciated.

( I tried coverage group safety margin but it is not working.)

Regards,

Syner

 _ _ _ _ __

Do You Yahoo!?

Tired of spam? Yahoo! Mail has the best spam protection around

http://mail. yahoo.com

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

!--

#ygrp-mlmsg {font-size:13px;font-family:arial,helvetica,clean,sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial,helvetica,clean,sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;
}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;
}
#ygrp-vitnav{
padding-top:10px;
font-family:Verdana;
font-size:77%;
margin:0;
}
#ygrp-vitnav a{
padding:0 1px;
}
#ygrp-actbar{
clear:both;
margin:25px 0;
white-space:nowrap;
color:#666;
text-align:right;
}
#ygrp-actbar .left{
float:left;
white-space:nowrap;
}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;
font-size:77%;
padding:15px 0;
}
#ygrp-ft{
font-family:verdana;
font-size:77%;
border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;
}

#ygrp-vital{
background-color:#e0ecee;
margin-bottom:20px;
padding:2px 0 8px 8px;
}
#ygrp-vital #vithd{
font-size:77%;
font-family:Verdana;
font-weight:bold;
color:#333;
text-transform:uppercase;
}
#ygrp-vital ul{
padding:0;
margin:2px 0;
}
#ygrp-vital ul li{
list-style-type:none;
clear:both;
border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;
color:#ff7900;
float:right;
width:2em;
text-align:right;
padding-right:.5em;
}
#ygrp-vital ul li .cat{
font-weight:bold;
}
#ygrp-vital a {
text-decoration:none;
}

#ygrp-vital a:hover{
text-decoration:underline;
}

#ygrp-sponsor #hd{
color:#999;
font-size:77%;
}
#ygrp-sponsor #ov{
padding:6px 13px;
background-color:#e0ecee;
margin-bottom:20px;
}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;
margin:0;
}
#ygrp-sponsor #ov li{
list-style-type:square;
padding:6px 0;
font-size:77%;
}
#ygrp-sponsor #ov li a{
text-decoration:none;
font-size:130%;
}
#ygrp-sponsor #nc {
background-color:#eee;
margin-bottom:20px;
padding:0 8px;
}
#ygrp-sponsor .ad{
padding:8px 0;
}
#ygrp-sponsor .ad #hd1{
font-family:Arial;
font-weight:bold;
color:#628c2a;
font-size:100%;
line-height:122%;
}
#ygrp-sponsor .ad a{
text-decoration:none;
}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;
}
#ygrp-sponsor .ad p{
margin:0;
}
o {font-size:0;}
.MsoNormal {
margin:0 0 0 0;
}
#ygrp-text tt{
font-size:120%;
}
blockquote{margin:0 0 0 4px;}
.replbq {margin:4;}
--

__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]

RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line!!!!

[Harry Deshpande]

Hi

'delete the plan'? So after deleting the plan and running 'net change' your 
problem gets solved?

Regards

harry



From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Ricardo Cortés
Sent: 18 December 2006 23:21
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion feature at 
the sales line


Hi,

If I run the master planning in net change the problem persist, what i'm doing 
now is deleting the plan and doing the scenario, it seems to be working now, 
but what i don't like is the fact you need to delete the plan or make a 
regeneration to make it works.

Do you think is a problem the way the master plan tables are updated?

Regards

Ricardo Cortes

Harry Deshpande [EMAIL PROTECTED]mailto:harryd%40microsoft.com escribió:
hi

ok, this is different. If 38 records are being created then it seems the 
problem is in master planning.

Just to make sure, try the following:

after invocing the sales order, go into the net requirements screen and run 
update net requirements (principle : net change). Do you still have the same 
problem?

Have you been able to repro this on the demo system?

regards

harry


From: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Axapta-Knowledge-Village%40yahoogroups.com] On 
Behalf Of Ricardo Cortés [EMAIL 
PROTECTED]mailto:ricardocortesrivero%40yahoo.com.mx]
Sent: Monday, December 18, 2006 8:10 PM
To: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion feature at 
the sales line

Hi Harry,

I've been lookig at the InventSumLogTTS table and in each step creates records, 
but in each step creates more than one record. After finishinsihing the last 
step(invoice the sales) the item had 38 records.

After, I created a new sales order and i did the explosion, but the system 
showed me onhand. I checked the InventSumLogTTS, and the system added just a 
new record for that sales order.

Only running the master scheduling in regeneration worked to create thye 
planned purchse order, because with this that table get clean.

Do you know what is causing this problem?

Regards,

Ricardo Cortes

Harry Deshpande [EMAIL 
PROTECTED]mailto:harryd%40microsoft.commailto:harryd%40microsoft.com 
escribió:
Hi

It looks like the problem is with InventSumLogTTS and not with master planning.

Check the records in inventsumlogtts after each step (the steps are slightly 
different)

i.e

1. create sales order
2. create purchase order
3. receive item
4. post sales

Ideally you should have records created in InventSumLogTTS after each step. 
Please also try this on standard installation.

regards

harry


From: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 
[mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of Ricardo Cortés
Sent: 18 December 2006 02:00
To: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion feature at 
the sales line

Hi Harry,

I'm running in ax 3.0 sp 5.

After invoice the first sales order there isn't any record on that table 
(InventSumtts) for the item. There are only two records on inventSum table.
The net requirement form for that item shows two lines with on hand, one with 
positive quantity and other with negative quantity.

Do you know what is happening?

Regards

Ricardo Cortes

Harry Deshpande [EMAIL 
PROTECTED]mailto:harryd%40microsoft.commailto:harryd%40microsoft.commailto:harryd%40microsoft.com
 escribió:
hi

Which version are you running?

You will have to do some investigation

after you invoice the first sales order, what are the records in 
InventSumLogtts table?

regards

harry


From: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL 
PROTECTED]mailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of Ricardo Cortés [EMAIL 
PROTECTED]mailto:ricardocortesrivero%40yahoo.com.mxmailto:ricardocortesrivero%40yahoo.com.mxmailto:ricardocortesrivero%40yahoo.com.mx]
Sent: Friday, December 15, 2006 10:53 PM
To: foro
Subject: [Axapta-Knowledge-Village] Problem with the explosion feature at the 
sales line

Hi all,

I've been having troubles with the explosion at the sales

RE: [Axapta-Knowledge-Village] Re: Ax 4.0 login screen as 3.0

[Harry Deshpande]

Hi

Read this link to understand why the passwords should not be stored in the 
database

http://en.wikipedia.org/wiki/MD5

regards

harry



From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Ax Dev
Sent: 18 December 2006 12:06
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Re: Ax 4.0 login screen as 3.0


Hi Friends,

It was asked from one of our costumers as well. Does anyone has the
solution of how to provide the same kind of user input in Ax4.0 as we have
in Ax3.0?

It is something very interesting and we are curious to know about it. Please
share your views.

Thanks  Regards,
Harsh

On 12/18/06, John Lindsay [EMAIL PROTECTED]mailto:jtl%40dragonsfoot.com 
wrote:

 You can use the runas command to change the user

 Confidentiality Notice: This e-mail contains confidential and/or
 privileged
 information and is intended to be read only by the person or authorized
 representative of the organization to whom it is addressed. If you are
 neither of these persons, you have received this e-mail in error. Please
 do
 not print, copy, re-transmit, disseminate or otherwise use the
 information,
 all of which are prohibited. Please immediately notify the sender by
 return
 e-mail or by telephone at (303) 593-1246 that you have received this
 communication in error and delete this e-mail from your system. Thank you.

 MBS Dynamics AX Master

 John T. Lindsay

 Micro Sciences

 303 593-1246

 720 982-4620

 _

 From: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 [mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of Andreas
 Rudischhauser
 Sent: Saturday, December 16, 2006 4:48 AM
 To: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 Subject: AW: [Axapta-Knowledge-Village] Re: Ax 4.0 login screen as 3.0

 Please contact Mr. Schuster on schuster(AT)back2.biz.

 Von: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com
 [mailto:Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com]
 Im Auftrag von Hardi
 Gesendet: Samstag, 16. Dezember 2006 00:52
 An: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com
 Betreff: [Axapta-Knowledge-Village] Re: Ax 4.0 login screen as 3.0

 As Ax40 is integrated with active directory, I think what is
 required is to prompt user to re-enter login/password when
 application started.
 This is something being asked too from my customer.

 Thanks

 Hardi

 --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoog
 roups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com , Jake
 [EMAIL PROTECTED] wrote:
 
  Hi Andreas -
 
  Do you have any info on how this is being done? Are you doing a
  second Active Directory login?
 
  Thanks, Jake
 
  http://axaptasource http://axaptasource.com .com
 
  --- In Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com , Andreas
  Rudischhauser Andreas.Rudischhauser@ wrote:
  
   We're currently in development. I will post the link here in a
 few
  days
  
  
  
   Von: Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
   [mailto:Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com ] Im Auftrag von
  Agus
   Riyadi
   Gesendet: Donnerstag, 14. Dezember 2006 03:14
   An: Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
   Betreff: [Axapta-Knowledge-Village] Ax 4.0 login screen as 3.0
  
  
  
   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]
  
  
  
  
  
   [Non-text portions of this message have been removed]
  
 

 [Non-text portions of this message have been removed]

 [Non-text portions of this message have been removed]




[Non-text portions of this message have been 

RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line!!!!

[Harry Deshpande]

Hi

Nopes, in your case regeneration will be much faster than net change.

Regards

Harry


From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Ax Dev
Sent: 18 December 2006 12:54
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Problem with the explosion feature at 
the sales line


Hi Harry,

Yes, I was referring 'Net Change'. We ran Regeneration for the whole system.
And after one week of last Regeneration Run, we were using 'Net change'
instead of 'Regeneration', because it make sense to run the master planning
for the last one week. But during the one week period, records are created
in InventSumLogTTS table very rapidly. So it took more than 3 hours which is
not acceptable from clients' point of view. So just curious to know is there
any way to improve the execution time of 'Net change' for this one week of
records?

Otherwise, we need to convince them to use Regeneration all the time as it
is taking 1 hour of time frame, after using the clean job of InventSumLogTTS
table.

Thanks  Regards,
Harsh

On 12/18/06, Harry Deshpande [EMAIL PROTECTED]mailto:harryd%40microsoft.com 
wrote:

 Hi

 What is incremental run? Are you referring to net change? The assumption
 that incremental run should take less time that regeneration is not correct.
 If you have a huge number of records in InventSumLogTTS table then
 regeneration is faster than net change.

 Why do you run net change for the complete system at all? Why not just
 regeneration?

 Regards

 Harry

 
 From: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com[mailto:
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of Ax Dev
 Sent: 18 December 2006 12:18
 To: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 Subject: Re: [Axapta-Knowledge-Village] Problem with the explosion feature
 at the sales line

 Hi Harry,

 I also have some problem related to Master Planning where InventSumLogTTS
 table is the main culprit. We had a client with huge database, and they
 tried to run Master Planning using Principle as Regeneration. It took more
 than 8 hours for execution and at last it gives the error like Deletion of
 records from InventSumLogTTS table exhausted the memory. We analyzed the
 code and found that during Regeneration, we don't need the records in
 InventSumLogTTS table(as these are required for Incremental Run). So we
 created a truncate job to delete the records from InventSumLogTTS table
 before Regeneration Run. And now it took around 1 hour and it executed
 successfully. Now the problem is; if we are doing Incremental Run, it took
 more than 3 hours, which is not exceptable from client's point of view, if
 Regeneration is taking 1 hour, then Incremental Run should take less than
 that. But Incremental Run is using records from InventSumLogTTS table, we
 can't delete/truncate this table. Do you have any suggestions how to
 improve
 the Incremental Run process, it would be really helpful.?

 Thanks  Regards,
 Harsh

 On 12/18/06, Harry Deshpande [EMAIL 
 PROTECTED]mailto:harryd%40microsoft.comharryd%40microsoft.com
 mailto:harryd% harryd%2540microsoft.com wrote:
 
  Hi
 
  It looks like the problem is with InventSumLogTTS and not with master
  planning.
 
  Check the records in inventsumlogtts after each step (the steps are
  slightly different)
 
  i.e
 
  1. create sales order
  2. create purchase order
  3. receive item
  4. post sales
 
  Ideally you should have records created in InventSumLogTTS after each
  step. Please also try this on standard installation.
 
  regards
 
  harry
 
  
  From: 
  Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 Axapta-Knowledge-Village%40yahoogroups.com[mailto:
  Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 Axapta-Knowledge-Village%40yahoogroups.com]
  On Behalf Of Ricardo Cortés
  Sent: 18 December 2006 02:00
  To: 
  Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 Axapta-Knowledge-Village%40yahoogroups.com
  Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion
 feature
  at the sales line
 
  Hi Harry,
 
  I'm running in ax 3.0 sp 5.
 
  After invoice the first sales order there isn't any record on that table
  (InventSumtts) for the item. There are only

RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line!!!!

[Harry Deshpande]

Hi

On other things: I would pay more attention to the error message about 
exhausted memory. Please check out CPU and Mem utilization on AOS as well as 
SQL server

Regards

Harry



From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Ax Dev
Sent: 18 December 2006 12:18
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Problem with the explosion feature at 
the sales line


Hi Harry,

I also have some problem related to Master Planning where InventSumLogTTS
table is the main culprit. We had a client with huge database, and they
tried to run Master Planning using Principle as Regeneration. It took more
than 8 hours for execution and at last it gives the error like Deletion of
records from InventSumLogTTS table exhausted the memory. We analyzed the
code and found that during Regeneration, we don't need the records in
InventSumLogTTS table(as these are required for Incremental Run). So we
created a truncate job to delete the records from InventSumLogTTS table
before Regeneration Run. And now it took around 1 hour and it executed
successfully. Now the problem is; if we are doing Incremental Run, it took
more than 3 hours, which is not exceptable from client's point of view, if
Regeneration is taking 1 hour, then Incremental Run should take less than
that. But Incremental Run is using records from InventSumLogTTS table, we
can't delete/truncate this table. Do you have any suggestions how to improve
the Incremental Run process, it would be really helpful.?

Thanks  Regards,
Harsh

On 12/18/06, Harry Deshpande [EMAIL PROTECTED]mailto:harryd%40microsoft.com 
wrote:

 Hi

 It looks like the problem is with InventSumLogTTS and not with master
 planning.

 Check the records in inventsumlogtts after each step (the steps are
 slightly different)

 i.e

 1. create sales order
 2. create purchase order
 3. receive item
 4. post sales

 Ideally you should have records created in InventSumLogTTS after each
 step. Please also try this on standard installation.

 regards

 harry

 
 From: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com[mailto:
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of Ricardo Cortés
 Sent: 18 December 2006 02:00
 To: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion feature
 at the sales line

 Hi Harry,

 I'm running in ax 3.0 sp 5.

 After invoice the first sales order there isn't any record on that table
 (InventSumtts) for the item. There are only two records on inventSum table.
 The net requirement form for that item shows two lines with on hand, one
 with positive quantity and other with negative quantity.

 Do you know what is happening?

 Regards

 Ricardo Cortes

 Harry Deshpande [EMAIL PROTECTED]mailto:harryd%40microsoft.com 
 harryd%40microsoft.commailto:
 harryd% harryd%2540microsoft.com escribió:
 hi

 Which version are you running?

 You will have to do some investigation

 after you invoice the first sales order, what are the records in
 InventSumLogtts table?

 regards

 harry

 
 From: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com [
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Ricardo
 Cortés [EMAIL 
 PROTECTED]mailto:ricardocortesrivero%40yahoo.com.mxricardocortesrivero%40yahoo.com.mx
 mailto:ricardocortesrivero%40yahoo.com.mx]
 Sent: Friday, December 15, 2006 10:53 PM
 To: foro
 Subject: [Axapta-Knowledge-Village] Problem with the explosion feature at
 the sales line

 Hi all,

 I've been having troubles with the explosion at the sales line, it is
 showing that i have inventory on hand when there isn't.

 The scenario to reproduce teh problem is:

 Create a sales order for an item without inventory on hand
 Run the explosion from the sales line
 The explosion form will show you a planned purchased order, this is
 correct.
 Firm the planned purchased order, receive the item and invoice the sales
 order.

 Create a new sales order for the same item (the item don't have inventory)
 Run the explosion from the sales line again
 The explosion form will show that the item has inventory onhand when the
 reality there isn't.

 If you check the net requirement thru the sales order you can see that
 axapta is showing two lines in on hand one with a positive quantity and
 other with neative. So, like

RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line!!!!

[Harry Deshpande]

hi

ok, this is different. If 38 records are being created then it seems the 
problem is in master planning.

Just to make sure, try the following:

after invocing the sales order, go into the net requirements screen and run 
update net requirements (principle : net change). Do you still have the same 
problem?

Have you been able to repro this on the demo system?

regards

harry


From: Axapta-Knowledge-Village@yahoogroups.com [EMAIL PROTECTED] On Behalf Of 
Ricardo Cortés [EMAIL PROTECTED]
Sent: Monday, December 18, 2006 8:10 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion feature at 
the sales line


Hi Harry,

I've been lookig at the InventSumLogTTS table and in each step creates records, 
but in each step creates more than one record. After finishinsihing the last 
step(invoice the sales) the item had 38 records.

After, I created a new sales order and i did the explosion, but the system 
showed me onhand. I checked the InventSumLogTTS, and the system added just a 
new record for that sales order.

Only running the master scheduling in regeneration worked to create thye 
planned purchse order, because with this that table get clean.

Do you know what is causing this problem?

Regards,

Ricardo Cortes



Harry Deshpande [EMAIL PROTECTED]mailto:harryd%40microsoft.com escribió:
Hi

It looks like the problem is with InventSumLogTTS and not with master planning.

Check the records in inventsumlogtts after each step (the steps are slightly 
different)

i.e

1. create sales order
2. create purchase order
3. receive item
4. post sales

Ideally you should have records created in InventSumLogTTS after each step. 
Please also try this on standard installation.

regards

harry


From: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 
[mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of Ricardo Cortés
Sent: 18 December 2006 02:00
To: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion feature at 
the sales line

Hi Harry,

I'm running in ax 3.0 sp 5.

After invoice the first sales order there isn't any record on that table 
(InventSumtts) for the item. There are only two records on inventSum table.
The net requirement form for that item shows two lines with on hand, one with 
positive quantity and other with negative quantity.

Do you know what is happening?

Regards

Ricardo Cortes

Harry Deshpande [EMAIL 
PROTECTED]mailto:harryd%40microsoft.commailto:harryd%40microsoft.com 
escribió:
hi

Which version are you running?

You will have to do some investigation

after you invoice the first sales order, what are the records in 
InventSumLogtts table?

regards

harry


From: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL 
PROTECTED]mailto:Axapta-Knowledge-Village%40yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of Ricardo Cortés [EMAIL 
PROTECTED]mailto:ricardocortesrivero%40yahoo.com.mxmailto:ricardocortesrivero%40yahoo.com.mx]
Sent: Friday, December 15, 2006 10:53 PM
To: foro
Subject: [Axapta-Knowledge-Village] Problem with the explosion feature at the 
sales line

Hi all,

I've been having troubles with the explosion at the sales line, it is showing 
that i have inventory on hand when there isn't.

The scenario to reproduce teh problem is:

Create a sales order for an item without inventory on hand
Run the explosion from the sales line
The explosion form will show you a planned purchased order, this is correct.
Firm the planned purchased order, receive the item and invoice the sales order.

Create a new sales order for the same item (the item don't have inventory)
Run the explosion from the sales line again
The explosion form will show that the item has inventory onhand when the 
reality there isn't.

If you check the net requirement thru the sales order you can see that axapta 
is showing two lines in on hand one with a positive quantity and other with 
neative. So, like axapta is seeing lines with on hand for this item is not 
calculating the requirement and is not plannig the purchase order.

I know that Axapta in the explosion only take into account a few transaction 
for the item, but in this case it seems that is not settling the previous 
transaction and that is why the result from the explosion is wrong.

Only running the Master planning for all the items in the regeneration mode fix 
the problem.

Does any one have an idea of what is happening or if this is a bug?

Thanks in advance

Ricardo Cortes

__
Correo Yahoo!
Espacio para todos tus mensajes

[Axapta-Knowledge-Village] www.systomatics.com

[Harry Deshpande]

Hi

www.systomatics.com is updated with a new project

Regards

harry

From: Harry Deshpande
Sent: Monday, December 18, 2006 12:24 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Re: Ax 4.0 login screen as 3.0

Hi

Read this link to understand why the passwords should not be stored in the 
database

http://en.wikipedia.org/wiki/MD5

regards

harry



From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Ax Dev
Sent: 18 December 2006 12:06
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Re: Ax 4.0 login screen as 3.0


Hi Friends,

It was asked from one of our costumers as well. Does anyone has the
solution of how to provide the same kind of user input in Ax4.0 as we have
in Ax3.0?

It is something very interesting and we are curious to know about it. Please
share your views.

Thanks  Regards,
Harsh

On 12/18/06, John Lindsay [EMAIL PROTECTED]mailto:jtl%40dragonsfoot.com 
wrote:

 You can use the runas command to change the user

 Confidentiality Notice: This e-mail contains confidential and/or
 privileged
 information and is intended to be read only by the person or authorized
 representative of the organization to whom it is addressed. If you are
 neither of these persons, you have received this e-mail in error. Please
 do
 not print, copy, re-transmit, disseminate or otherwise use the
 information,
 all of which are prohibited. Please immediately notify the sender by
 return
 e-mail or by telephone at (303) 593-1246 that you have received this
 communication in error and delete this e-mail from your system. Thank you.

 MBS Dynamics AX Master

 John T. Lindsay

 Micro Sciences

 303 593-1246

 720 982-4620

 _

 From: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 [mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com]
 On Behalf Of Andreas
 Rudischhauser
 Sent: Saturday, December 16, 2006 4:48 AM
 To: 
 Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com
 Subject: AW: [Axapta-Knowledge-Village] Re: Ax 4.0 login screen as 3.0

 Please contact Mr. Schuster on schuster(AT)back2.biz.

 Von: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com
 [mailto:Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com]
 Im Auftrag von Hardi
 Gesendet: Samstag, 16. Dezember 2006 00:52
 An: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com
 Betreff: [Axapta-Knowledge-Village] Re: Ax 4.0 login screen as 3.0

 As Ax40 is integrated with active directory, I think what is
 required is to prompt user to re-enter login/password when
 application started.
 This is something being asked too from my customer.

 Thanks

 Hardi

 --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoog
 roups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com , Jake
 [EMAIL PROTECTED] wrote:
 
  Hi Andreas -
 
  Do you have any info on how this is being done? Are you doing a
  second Active Directory login?
 
  Thanks, Jake
 
  http://axaptasource http://axaptasource.com .com
 
  --- In Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com , Andreas
  Rudischhauser Andreas.Rudischhauser@ wrote:
  
   We're currently in development. I will post the link here in a
 few
  days
  
  
  
   Von: Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
   [mailto:Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com ] Im Auftrag von
  Agus
   Riyadi
   Gesendet: Donnerstag, 14. Dezember 2006 03:14
   An: Axapta-Knowledge-
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Village%40yahoogroups.com 
 Village%40yahoogroups.com
 mailto:Axapta-Knowledge-Village%40yahoogroups.com
   Betreff: [Axapta-Knowledge-Village] Ax 4.0 login screen as 3.0
  
  
  
   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

RE: [Axapta-Knowledge-Village] Problem with the explosion feature at the sales line!!!!

[Harry Deshpande]

Hi

It looks like the problem is with InventSumLogTTS and not with master planning.

Check the records in inventsumlogtts after each step (the steps are slightly 
different)

i.e


 1.  create sales order
 2.  create purchase order
 3.  receive item
 4.  post sales

Ideally you should have records created in InventSumLogTTS after each step. 
Please also try this on standard installation.

regards

harry



From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
Behalf Of Ricardo Cortés
Sent: 18 December 2006 02:00
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Problem with the explosion feature at 
the sales line


Hi Harry,

I'm running in ax 3.0 sp 5.

After invoice the first sales order there isn't any record on that table 
(InventSumtts) for the item. There are only two records on inventSum table.
The net requirement form for that item shows two lines with on hand, one with 
positive quantity and other with negative quantity.

Do you know what is happening?

Regards


Ricardo Cortes

Harry Deshpande [EMAIL PROTECTED]mailto:harryd%40microsoft.com escribió:
hi

Which version are you running?

You will have to do some investigation

after you invoice the first sales order, what are the records in 
InventSumLogtts table?

regards

harry


From: 
Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com
 [EMAIL PROTECTED]mailto:Axapta-Knowledge-Village%40yahoogroups.com] On 
Behalf Of Ricardo Cortés [EMAIL 
PROTECTED]mailto:ricardocortesrivero%40yahoo.com.mx]
Sent: Friday, December 15, 2006 10:53 PM
To: foro
Subject: [Axapta-Knowledge-Village] Problem with the explosion feature at the 
sales line

Hi all,

I've been having troubles with the explosion at the sales line, it is showing 
that i have inventory on hand when there isn't.

The scenario to reproduce teh problem is:

Create a sales order for an item without inventory on hand
Run the explosion from the sales line
The explosion form will show you a planned purchased order, this is correct.
Firm the planned purchased order, receive the item and invoice the sales order.

Create a new sales order for the same item (the item don't have inventory)
Run the explosion from the sales line again
The explosion form will show that the item has inventory onhand when the 
reality there isn't.

If you check the net requirement thru the sales order you can see that axapta 
is showing two lines in on hand one with a positive quantity and other with 
neative. So, like axapta is seeing lines with on hand for this item is not 
calculating the requirement and is not plannig the purchase order.

I know that Axapta in the explosion only take into account a few transaction 
for the item, but in this case it seems that is not settling the previous 
transaction and that is why the result from the explosion is wrong.

Only running the Master planning for all the items in the regeneration mode fix 
the problem.

Does any one have an idea of what is happening or if this is a bug?

Thanks in advance

Ricardo Cortes

__
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
Regístrate ya - http://correo.yahoo.com.mx/

[Non-text portions of this message have been removed]


-
Do You Yahoo!? La mejor conexión a Internet y 2GB extra a tu correo por $100 al 
mes. http://net.yahoo.com.mx

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]