[Axapta-Knowledge-Village] Inventdimposted

[Rocco Giumelli]

Hi 
all
 
I wonder if anyone 
can help..
 
I have modified the 
Inventdimpost Report in Axapta and I want to add a cloumn, that will give the 
date of last sale with inventrans.transtype::Project. and have this last trans 
date appear on this report
 
Or is there another 
way to get from the Invent module a report that will give last trans date of 
this type, without listing all trans dates as the Inventory Transaction report 
does. Maybe a criteria that will be like = 'latest date'
 
 
Thanking 
you
 



  
  
 

  Rocco Giumelli
  IT 
  MANAGER   
  Metric Australia Pty 
  Ltd
  Assistance is only the 
  Beginning 
  893745331


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.








<>

[Axapta-Knowledge-Village] Hardware Requirements for Axapta.

[tj_jayson]

Hi All,

Where I can look for Recommended hardware configuration for Axapta 
Ver 3 sp3 / Sql server 2000 installation for the following.

1) Database server
2) Application File server
3) AOS 
4) 2 tier Client
5) 3 tier thin Client 
6) 3 tier Fat client
7) Terminal Server

Thanks for all your help

TJJ





 Yahoo! Groups Sponsor ~--> 
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

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

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

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

Re: [Axapta-Knowledge-Village] Axapta AOS Cluster parameter

[Arijit Basu]

Use the parameter
 -cluster=clustername
in the advanced field of the ACU


On Mon, 10 Jan 2005 16:22:57 +0800, tonychan <[EMAIL PROTECTED]> wrote:
>  
> Hi all,
>I try to use 2 AOS and point to same application, and there is a
> parameter neet to be placed at the 'Advanced' Field in setting up the AOS in
> order to run cluster , anyone can help on the syntax of the parameter ? Many
> Thanks.
>  
> Best Regards,
>  
> Tony.
> 
> Sharing the knowledge on Axapta. 
> 
> 
> 
> Yahoo! Groups Links
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/Axapta-Knowledge-Village/
>   
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>   
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 


-- 


Arijit


 Yahoo! Groups Sponsor ~--> 
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

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

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

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

RE: [Axapta-Knowledge-Village] Re: VAR/USR Layer changes and data

[Jesper Kehlet]

You don't mention anything about synchronizing.  Did 
you?  That is the lithmus-test...


From: Danny Gaethofs 
[mailto:[EMAIL PROTECTED] Sent: Monday, January 10, 2005 10:54 
AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: 
[Axapta-Knowledge-Village] Re: VAR/USR Layer changes and 
data
Dear Jesper,I am running axapta 3.0 sp3.To 
simulate the situation I did some testing in a test-environment and in a 
development-environment.I created a new field for the table VendTable in 
both environments. In my test-environment I did it in the usr layer. In my 
development environment I did it in the var layer. Same name for the field. 
I entered data in the field for the records in my test-environment.I 
logged out of both environments. I removed the axusr.aod and related 
files from the test-environment application directory. I copied the 
axvar.aod and related files from the development-environment to the 
test-environment application directory.I started the axapta 
test-environment. Axapta then starts building the axapd.aoi, axapden-us.khi 
and axapden-us.ahi files.After that I logged in and checked whether the 
data entered previously was still there. I checked the field id, which was 
changed from 51 into 31.The data was still in the 
fields.regards,Danny--- In 
Axapta-Knowledge-Village@yahoogroups.com, "Jesper Kehlet" 
<[EMAIL PROTECTED]> wrote:> Your explanation is a little 
confusing:  Did you do a synchronize in> your own 
environment?  What version of Axapta are you using?> > 
> > From: Danny Gaethofs 
[mailto:[EMAIL PROTECTED] > Sent: Monday, January 10, 2005 9:57 AM> 
To: Axapta-Knowledge-Village@yahoogroups.com> Subject: 
[Axapta-Knowledge-Village] Re: VAR/USR Layer changes and data> 
> > > Dear all,> > The reason for my question 
was that my customer made noticed after > they installed the var layer 
that the field values were deleted.> > I did some testing in my 
own environment. I removed the USR layer > file axusr.aod and related 
files and replaced them by axvar.aod. > After logging back into axapta I 
saw the id's of the fields were > changed from 51 to 31.> 
> The data in the fields was not deleted.> > I conclude 
that using this approach replacing axusr.aod with > axvar.aod will not 
change the content of the fields in the table > being modified. Only 
thing that is changed are the id's.> > regards,> 
Danny> > --- In Axapta-Knowledge-Village@yahoogroups.com, "Jesper 
Kehlet" > <[EMAIL PROTECTED]> wrote:> > Use the SQL 
Administration/Tables/Synchronize -- it works just > fine, at> 
> least in 3.0.> >  > > Another way to go about 
this, and if it's only a few fields > (Caution:> > Should be 
done in 2-tier mode with AOSs shut down, and without > anybody> 
> else in the system!):> >  > 
> 1.  In the SqlDictionary table, find the 
fields, and change > their> > field ids to the new field ids 
(5 -> 3), then log out.> > 2.  
Put the new VAR/USR layer in there.> > 
3.  Start Axapta and perform synchronization to create other > 
new> > fields etc.> >  > > Of course, test it 
in a test environment before you perform > updates in> > live 
environments -- you may experience some trouble that causes > it 
to> > go haywire, especially in heavily customized systems.> 
> > > > > > > 
From: Danny Gaethofs [mailto:[EMAIL PROTECTED] > > Sent: Monday, January 
10, 2005 8:12 AM> > To: 
Axapta-Knowledge-Village@yahoogroups.com> > Subject: 
[Axapta-Knowledge-Village] VAR/USR Layer changes and data> > 
> > > > > > Dear all,> > > > 
One of my customers has made table changes in the usr layer. They > 
> added new fields. These fields have been used already in their > 
> production database and of course values have been entered.> > 
> > Now I need to transfer these changes to the VAR layer.> 
> > > I notice when I just export the changes and import them in 
the var > > layer, nothing happens. Is this correct, I assume it 
is a way the > > software is trying to keep things consistent. As 
such it is not > > possible to overwrite changes made in the user 
layer.> > > > Am I correct that it is not possible to load 
these changes into > the > > var layer while they are still in 
the usr layer. Is this behavior > > only valid for tables?> 
> > > How can I get the changes transferred to the var layer 
without > > loosing the data already entered.> > > 
> regards,> > Danny Gaethofs> > > > > 
> > > > > > > Sharing the knowledge on Axapta. 
> > > > > > > > 
> > > > Yahoo! Groups 
Links> > > > > > *  
To visit your group on the web, go to:> 
>   http://groups.yahoo.com/group/Axapta-Knowledge-Village/> 
> > > 
*  To unsubscribe from this group, send an email 
to:> >   
[EMAIL PROTECTED]> > 
> 
subject=Uns> > ubscribe> > 
> > > 
*  Your use of Yahoo! Groups is subject to the 
Yahoo! Terms of> > Service  
.> > > > > > Sh

[Axapta-Knowledge-Village] Re: VAR/USR Layer changes and data

[Danny Gaethofs]

Dear Jesper,

I am running axapta 3.0 sp3.

To simulate the situation I did some testing in a test-environment 
and in a development-environment.

I created a new field for the table VendTable in both environments. 
In my test-environment I did it in the usr layer. In my development 
environment I did it in the var layer. Same name for the field. I 
entered data in the field for the records in my test-environment.

I logged out of both environments. 

I removed the axusr.aod and related files from the test-environment 
application directory. I copied the axvar.aod and related files from 
the development-environment to the test-environment application 
directory.

I started the axapta test-environment. Axapta then starts building 
the axapd.aoi, axapden-us.khi and axapden-us.ahi files.

After that I logged in and checked whether the data entered 
previously was still there. I checked the field id, which was 
changed from 51 into 31.

The data was still in the fields.

regards,
Danny

--- In Axapta-Knowledge-Village@yahoogroups.com, "Jesper Kehlet" 
<[EMAIL PROTECTED]> wrote:
> Your explanation is a little confusing:  Did you do a synchronize 
in
> your own environment?  What version of Axapta are you using?
> 
> 
> 
> From: Danny Gaethofs [mailto:[EMAIL PROTECTED] 
> Sent: Monday, January 10, 2005 9:57 AM
> To: Axapta-Knowledge-Village@yahoogroups.com
> Subject: [Axapta-Knowledge-Village] Re: VAR/USR Layer changes and 
data
> 
> 
> 
> Dear all,
> 
> The reason for my question was that my customer made noticed after 
> they installed the var layer that the field values were deleted.
> 
> I did some testing in my own environment. I removed the USR layer 
> file axusr.aod and related files and replaced them by axvar.aod. 
> After logging back into axapta I saw the id's of the fields were 
> changed from 51 to 31.
> 
> The data in the fields was not deleted.
> 
> I conclude that using this approach replacing axusr.aod with 
> axvar.aod will not change the content of the fields in the table 
> being modified. Only thing that is changed are the id's.
> 
> regards,
> Danny
> 
> --- In Axapta-Knowledge-Village@yahoogroups.com, "Jesper Kehlet" 
> <[EMAIL PROTECTED]> wrote:
> > Use the SQL Administration/Tables/Synchronize -- it works just 
> fine, at
> > least in 3.0.
> >  
> > Another way to go about this, and if it's only a few fields 
> (Caution:
> > Should be done in 2-tier mode with AOSs shut down, and without 
> anybody
> > else in the system!):
> >  
> > 1.  In the SqlDictionary table, find the fields, and change 
> their
> > field ids to the new field ids (5 -> 3), then log out.
> > 2.  Put the new VAR/USR layer in there.
> > 3.  Start Axapta and perform synchronization to create other 
> new
> > fields etc.
> >  
> > Of course, test it in a test environment before you perform 
> updates in
> > live environments -- you may experience some trouble that causes 
> it to
> > go haywire, especially in heavily customized systems.
> > 
> > 
> > 
> > From: Danny Gaethofs [mailto:[EMAIL PROTECTED] 
> > Sent: Monday, January 10, 2005 8:12 AM
> > To: Axapta-Knowledge-Village@yahoogroups.com
> > Subject: [Axapta-Knowledge-Village] VAR/USR Layer changes and 
data
> > 
> > 
> > 
> > Dear all,
> > 
> > One of my customers has made table changes in the usr layer. 
They 
> > added new fields. These fields have been used already in their 
> > production database and of course values have been entered.
> > 
> > Now I need to transfer these changes to the VAR layer.
> > 
> > I notice when I just export the changes and import them in the 
var 
> > layer, nothing happens. Is this correct, I assume it is a way 
the 
> > software is trying to keep things consistent. As such it is not 
> > possible to overwrite changes made in the user layer.
> > 
> > Am I correct that it is not possible to load these changes into 
> the 
> > var layer while they are still in the usr layer. Is this 
behavior 
> > only valid for tables?
> > 
> > How can I get the changes transferred to the var layer without 
> > loosing the data already entered.
> > 
> > regards,
> > Danny Gaethofs
> > 
> > 
> > 
> > 
> > 
> > Sharing the knowledge on Axapta. 
> > 
> > 
> > 
> > 
> > 
> > Yahoo! Groups Links
> > 
> > 
> > *  To visit your group on the web, go to:
> >   http://groups.yahoo.com/group/Axapta-Knowledge-Village/
> > 
> > *  To unsubscribe from this group, send an email to:
> >   [EMAIL PROTECTED]
> >  subject=Uns
> > ubscribe> 
> > 
> > *  Your use of Yahoo! Groups is subject to the Yahoo! Terms 
of
> > Service  .
> 
> 
> 
> 
> 
> Sharing the knowledge on Axapta. 
> 
> 
> 
> 
> 
> Yahoo! Groups Links
> 
> 
> * To visit your group on the web, go to:
>   http://groups.yahoo.com/group/Axapta

[Axapta-Knowledge-Village] Full Import of InventTable from navision

[rodrigo Matiazo]

Hello all, 

Someone already had an experience
importing a database from Navision to Axapta?

The table structure for items
in Axapta is quite different from Navision (inventtable,
inventtablemodule, inventdim) and we need to import 2000 items from our
costumer Navision native database to the Axapta database.

 

Any help will be helpfull

 

Thanks,

 

Rodrigo Matiazo 
[EMAIL PROTECTED] 

Cadia Consulting do Brasil
Ltda. 
Av. Eng. Luis Carlos Berrini,
1091 2º andar 
Edifício A R S Cep. 04571-010 -
Brooklin – SP, Brasil
Tel. (55-11) 5505-0173 
Fax. (55-11) 5505-0659 

www.cadia-consulting.com.br 



 






Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [Axapta-Knowledge-Village] Re: VAR/USR Layer changes and data

[Jesper Kehlet]

Your explanation is a little confusing:  Did you do a 
synchronize in your own environment?  What version of Axapta are you 
using?


From: Danny Gaethofs 
[mailto:[EMAIL PROTECTED] Sent: Monday, January 10, 2005 9:57 
AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: 
[Axapta-Knowledge-Village] Re: VAR/USR Layer changes and 
data
Dear all,The reason for my question was that my 
customer made noticed after they installed the var layer that the field 
values were deleted.I did some testing in my own environment. I removed 
the USR layer file axusr.aod and related files and replaced them by 
axvar.aod. After logging back into axapta I saw the id's of the fields were 
changed from 51 to 31.The data in the fields was not 
deleted.I conclude that using this approach replacing axusr.aod with 
axvar.aod will not change the content of the fields in the table being 
modified. Only thing that is changed are the 
id's.regards,Danny--- In 
Axapta-Knowledge-Village@yahoogroups.com, "Jesper Kehlet" 
<[EMAIL PROTECTED]> wrote:> Use the SQL 
Administration/Tables/Synchronize -- it works just fine, at> least in 
3.0.>  > Another way to go about this, and if it's only a few 
fields (Caution:> Should be done in 2-tier mode with AOSs shut down, 
and without anybody> else in the system!):>  
> 1.  In the SqlDictionary table, find the 
fields, and change their> field ids to the new field ids (5 -> 
3), then log out.> 2.  Put the new 
VAR/USR layer in there.> 3.  Start Axapta 
and perform synchronization to create other new> fields 
etc.>  > Of course, test it in a test environment before you 
perform updates in> live environments -- you may experience some 
trouble that causes it to> go haywire, especially in heavily 
customized systems.> > > 
> From: Danny Gaethofs [mailto:[EMAIL PROTECTED] > Sent: Monday, 
January 10, 2005 8:12 AM> To: 
Axapta-Knowledge-Village@yahoogroups.com> Subject: 
[Axapta-Knowledge-Village] VAR/USR Layer changes and data> > 
> > Dear all,> > One of my customers has made table 
changes in the usr layer. They > added new fields. These fields have been 
used already in their > production database and of course values have 
been entered.> > Now I need to transfer these changes to the VAR 
layer.> > I notice when I just export the changes and import them 
in the var > layer, nothing happens. Is this correct, I assume it is a 
way the > software is trying to keep things consistent. As such it is not 
> possible to overwrite changes made in the user layer.> > 
Am I correct that it is not possible to load these changes into the > 
var layer while they are still in the usr layer. Is this behavior > only 
valid for tables?> > How can I get the changes transferred to the 
var layer without > loosing the data already entered.> > 
regards,> Danny Gaethofs> > > > > 
> Sharing the knowledge on Axapta. > > > > 
> > Yahoo! Groups Links> 
> > *  To visit your group on the 
web, go to:>   http://groups.yahoo.com/group/Axapta-Knowledge-Village/> 
    > *  
To unsubscribe from this group, send an email to:> 
  
[EMAIL PROTECTED]> 
subject=Uns> 
ubscribe> >     > 
*  Your use of Yahoo! Groups is subject to the 
Yahoo! Terms of> Service  
.Sharing the knowledge on Axapta. 


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Axapta-Knowledge-Village] Re: VAR/USR Layer changes and data

[Danny Gaethofs]

Dear all,

The reason for my question was that my customer made noticed after 
they installed the var layer that the field values were deleted.

I did some testing in my own environment. I removed the USR layer 
file axusr.aod and related files and replaced them by axvar.aod. 
After logging back into axapta I saw the id's of the fields were 
changed from 51 to 31.

The data in the fields was not deleted.

I conclude that using this approach replacing axusr.aod with 
axvar.aod will not change the content of the fields in the table 
being modified. Only thing that is changed are the id's.

regards,
Danny

--- In Axapta-Knowledge-Village@yahoogroups.com, "Jesper Kehlet" 
<[EMAIL PROTECTED]> wrote:
> Use the SQL Administration/Tables/Synchronize -- it works just 
fine, at
> least in 3.0.
>  
> Another way to go about this, and if it's only a few fields 
(Caution:
> Should be done in 2-tier mode with AOSs shut down, and without 
anybody
> else in the system!):
>  
> 1.  In the SqlDictionary table, find the fields, and change 
their
> field ids to the new field ids (5 -> 3), then log out.
> 2.  Put the new VAR/USR layer in there.
> 3.  Start Axapta and perform synchronization to create other 
new
> fields etc.
>  
> Of course, test it in a test environment before you perform 
updates in
> live environments -- you may experience some trouble that causes 
it to
> go haywire, especially in heavily customized systems.
> 
> 
> 
> From: Danny Gaethofs [mailto:[EMAIL PROTECTED] 
> Sent: Monday, January 10, 2005 8:12 AM
> To: Axapta-Knowledge-Village@yahoogroups.com
> Subject: [Axapta-Knowledge-Village] VAR/USR Layer changes and data
> 
> 
> 
> Dear all,
> 
> One of my customers has made table changes in the usr layer. They 
> added new fields. These fields have been used already in their 
> production database and of course values have been entered.
> 
> Now I need to transfer these changes to the VAR layer.
> 
> I notice when I just export the changes and import them in the var 
> layer, nothing happens. Is this correct, I assume it is a way the 
> software is trying to keep things consistent. As such it is not 
> possible to overwrite changes made in the user layer.
> 
> Am I correct that it is not possible to load these changes into 
the 
> var layer while they are still in the usr layer. Is this behavior 
> only valid for tables?
> 
> How can I get the changes transferred to the var layer without 
> loosing the data already entered.
> 
> regards,
> Danny Gaethofs
> 
> 
> 
> 
> 
> Sharing the knowledge on Axapta. 
> 
> 
> 
> 
> 
> Yahoo! Groups Links
> 
> 
> * To visit your group on the web, go to:
>   http://groups.yahoo.com/group/Axapta-Knowledge-Village/
> 
> * To unsubscribe from this group, send an email to:
>   [EMAIL PROTECTED]
>  ubscribe> 
> 
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service  .





 Yahoo! Groups Sponsor ~--> 
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

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

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

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

RE: [Axapta-Knowledge-Village] Branch Definition within an Entity and attachment of documents to Branch

[Jesper Kehlet]

I take it that you want different report layouts for 
each branch?  What version of Axapta are you running?  Are the branches separate companies in Axapta, or are 
they all in the same company, and then, how are they 
segregated?


From: bhgopal12 [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 10, 2005 4:24 AMTo: 
Axapta-Knowledge-Village@yahoogroups.comSubject: 
[Axapta-Knowledge-Village] Branch Definition within an Entity and attachment of 
documents to Branch
Hi All,I have a clarification:An organization 
with 100 Branches / Sales Depots going for Axapta 
implementation.Each Branch / Sales Depot is having a seperate Set of 
documents (including running serial number) such as Sales Invoice, DN, CN, 
etc.How to define the branches / Sales Depots and attach a set of 
documents to it. Sharing the 
knowledge on Axapta. 


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Re: [Axapta-Knowledge-Village] VAR/USR Layer changes and data

[Varden Morris]

Hi Danny,
 
You will have to export the data also and then import them in the VAR layer. After exporting the changes in the USR layer you will have to delete the changes. 
 
After you have done this you will be able to inport the changes in the VAR layer. You should then import the data after doinf this.
 

Varden Morris
 
J. Wray & Nephew Ltd. - Group I.S.
234 Spanish Town Road
Kingston 11, Jamaica, W.I.
 
Phone:  (876) - 923 - 6141 Ext. 2400, 2412Fax:  (876) - 923 - 5372 
Cell:  (876) - 3833566Email:   [EMAIL PROTECTED]
    [EMAIL PROTECTED]   
 Danny Gaethofs <[EMAIL PROTECTED]> wrote:
Dear all,One of my customers has made table changes in the usr layer. They added new fields. These fields have been used already in their production database and of course values have been entered.Now I need to transfer these changes to the VAR layer.I notice when I just export the changes and import them in the var layer, nothing happens. Is this correct, I assume it is a way the software is trying to keep things consistent. As such it is not possible to overwrite changes made in the user layer.Am I correct that it is not possible to load these changes into the var layer while they are still in the usr layer. Is this behavior only valid for tables?How can I get the changes transferred to the var layer without loosing the data already entered.regards,Danny
 GaethofsSharing the knowledge on Axapta. 
		Do you Yahoo!? 
Yahoo! Mail - 250MB free storage. Do more. Manage less.


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Re: Re: [Axapta-Knowledge-Village] SQL database error -> equal to-operation

[Raul Llorente Peña/OPENSOLUTIONS]

Or do so via SQL Administration in Axapta; Or/and look for duplicated records in the table; If table browser doesn't show nothing strange, do it via SQL directly.Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS-Varden Morris <[EMAIL PROTECTED]> escribió: -Para: Axapta-Knowledge-Village@yahoogroups.comDe: Varden Morris <[EMAIL PROTECTED]>Fecha: 10/01/2005 15:36Asunto: Re: [Axapta-Knowledge-Village] SQL database error -> equal to-operationTry synchronizing the inventTable. Stefan Heidkamp <[EMAIL PROTECTED]> wrote: Hi all, when we want to open the form InventTable or the menu item InventTable (under display) we get the following error: Cannot select a record in table Item table (InventTable). The SQL database has issued an error. SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server] Konflikt der Sortierung für die equal to-Operation kann nicht aufgelöst werden. SQL statement: SELECT A.ITEMGROUPID,A.ITEMID,A.ITEMNAME,A.ITEMTYPE,A.PURCHMODEL,A.HEIGHT,A. ... It's only in the test environments :-) but it would be interesting for us how we could solve the problem. Many thanks in advance, Stefan Sharing the knowledge on Axapta. Do you Yahoo!? The all-new My Yahoo! ? What will yours do? Sharing the knowledge on Axapta. 


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [Axapta-Knowledge-Village] SQL database error -> equal to-operation

[Jesper Kehlet]

My German is a bit rusty after not having spoken it for a 
few years, but it sounds like you have a sort order problem on 
that database.  What sort order are you using for it?  Most 
importantly:  How did you create the database/how did you get data in 
it?  DTC?  Backup/restore?
 
What version of SQL + Axapta are you 
running?


From: Stefan Heidkamp 
[mailto:[EMAIL PROTECTED] Sent: Monday, 
January 10, 2005 9:31 AMTo: 
Axapta-Knowledge-Village@yahoogroups.comSubject: 
[Axapta-Knowledge-Village] SQL database error -> equal 
to-operation
Hi all,when we want to open the form InventTable or 
the menu item InventTable (under display) we get the following 
error:Cannot select a record in table Item table (InventTable).The 
SQL database has issued an error.SQL error description: [Microsoft][ODBC SQL 
Server Driver][SQL Server]Konflikt der Sortierung für die equal to-Operation 
kann nicht aufgelöst werden.SQL statement: SELECT 
A.ITEMGROUPID,A.ITEMID,A.ITEMNAME,A.ITEMTYPE,A.PURCHMODEL,A.HEIGHT,A. 
...It's only in the test environments :-) but it would be 
interesting for us how we could solve the problem.Many thanks in 
advance,StefanSharing the knowledge 
on Axapta. 


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Re: [Axapta-Knowledge-Village] printing invoice or picking list

[Raul Llorente Peña/OPENSOLUTIONS]

This one is easy: Usually will be SalesFormLetter_Invoice or SalesFormLetter_PickingList (or Purch...). Be Careful when initializing parameters... Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [Axapta-Knowledge-Village] VAR/USR Layer changes and data

[Jesper Kehlet]

Use the SQL Administration/Tables/Synchronize -- it works 
just fine, at least in 3.0.
 
Another way to go about this, and if it's only a few fields 
(Caution:  Should be done in 2-tier mode with AOSs shut down, and without 
anybody else in the system!):
 
    1.  In the SqlDictionary table, 
find the fields, and change their field ids to the new field ids (5 -> 
3), then log out.
    2.  Put the new VAR/USR layer in 
there.
    3.  Start Axapta and perform 
synchronization to create other new fields etc.
 
Of course, test it in a test environment before you perform 
updates in live environments -- you may experience some trouble that causes it 
to go haywire, especially in heavily customized systems.


From: Danny Gaethofs 
[mailto:[EMAIL PROTECTED] Sent: Monday, January 10, 2005 8:12 
AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: 
[Axapta-Knowledge-Village] VAR/USR Layer changes and data
Dear all,One of my customers has made table changes 
in the usr layer. They added new fields. These fields have been used already 
in their production database and of course values have been 
entered.Now I need to transfer these changes to the VAR layer.I 
notice when I just export the changes and import them in the var layer, 
nothing happens. Is this correct, I assume it is a way the software is 
trying to keep things consistent. As such it is not possible to overwrite 
changes made in the user layer.Am I correct that it is not possible to 
load these changes into the var layer while they are still in the usr layer. 
Is this behavior only valid for tables?How can I get the changes 
transferred to the var layer without loosing the data already 
entered.regards,Danny 
GaethofsSharing the knowledge on Axapta. 



Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Axapta-Knowledge-Village] Re: printing invoice or picking list

[Danny Gaethofs]

Jesmond,

Have a look at the SalesFormLetter class and subsequent classes 
SalesFormLetter_

What exactly are you trying to accomplish?

regards,
Danny
--- In Axapta-Knowledge-Village@yahoogroups.com, Jesmond Giordimaina 
<[EMAIL PROTECTED]> wrote:
> 
> Hi,
> 
> can anyone highlight which class shall I use for printing an 
invoice or picking list?
> 
> reg
> 
> Jesmond
> 
>   
> -
> Do you Yahoo!?
>  The all-new My Yahoo! – Get yours free!





 Yahoo! Groups Sponsor ~--> 
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

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

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

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

Re: [Axapta-Knowledge-Village] printing invoice or picking list

[Varden Morris]

Hi Jesmond
 
The class name is SalesFormLetter.Jesmond Giordimaina <[EMAIL PROTECTED]> wrote:

Hi,
can anyone highlight which class shall I use for printing an invoice or picking list?
reg
Jesmond


Do you Yahoo!?The all-new My Yahoo! – Get yours free! Sharing the knowledge on Axapta. 
		Do you Yahoo!? 
Read only the mail you want - Yahoo! Mail SpamGuard.


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Re: [Axapta-Knowledge-Village] SQL database error -> equal to-operation

[Varden Morris]

Try synchronizing the inventTable.Stefan Heidkamp <[EMAIL PROTECTED]> wrote:
Hi all,when we want to open the form InventTable or the menu item InventTable (under display) we get the following error:Cannot select a record in table Item table (InventTable).The SQL database has issued an error.SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Konflikt der Sortierung für die equal to-Operation kann nicht aufgelöst werden.SQL statement: SELECT A.ITEMGROUPID,A.ITEMID,A.ITEMNAME,A.ITEMTYPE,A.PURCHMODEL,A.HEIGHT,A. ...It's only in the test environments :-) but it would be interesting for us how we could solve the problem.Many thanks in advance,StefanSharing the knowledge on Axapta. 
		Do you Yahoo!? 
The all-new My Yahoo! – What will yours do?


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Axapta-Knowledge-Village] SQL database error -> equal to-operation

[Stefan Heidkamp]

Hi all,

when we want to open the form InventTable or the menu item 
InventTable (under display) we get the following error:

Cannot select a record in table Item table (InventTable).
The SQL database has issued an error.
SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]
Konflikt der Sortierung für die equal to-Operation kann nicht 
aufgelöst werden.
SQL statement: SELECT 
A.ITEMGROUPID,A.ITEMID,A.ITEMNAME,A.ITEMTYPE,A.PURCHMODEL,A.HEIGHT,A. 
...

It's only in the test environments :-) but it would be interesting 
for us how we could solve the problem.

Many thanks in advance,
Stefan







 Yahoo! Groups Sponsor ~--> 
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

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

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

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

[Axapta-Knowledge-Village] printing invoice or picking list

[Jesmond Giordimaina]

Hi,
can anyone highlight which class shall I use for printing an invoice or picking list?
reg
Jesmond
		Do you Yahoo!? 
The all-new My Yahoo! – Get yours free! 
 
 
 



Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Re: [Axapta-Knowledge-Village] One report with data from all companies

[Raul Llorente Peña/OPENSOLUTIONS]

Have you heard about changeCompany(companyId){   //the sentences of this block will be executed with the company companyId data.}?? Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Axapta-Knowledge-Village] One report with data from all companies

[hbrommer]

Hi all,

I would like to run a report in one company, containing data from 
several other companies as well.

Does anyone have a clue how this can be done?

Thanks in advance,
Henk-Jan





 Yahoo! Groups Sponsor ~--> 
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

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

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

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

[Axapta-Knowledge-Village] VAR/USR Layer changes and data

[Danny Gaethofs]

Dear all,

One of my customers has made table changes in the usr layer. They 
added new fields. These fields have been used already in their 
production database and of course values have been entered.

Now I need to transfer these changes to the VAR layer.

I notice when I just export the changes and import them in the var 
layer, nothing happens. Is this correct, I assume it is a way the 
software is trying to keep things consistent. As such it is not 
possible to overwrite changes made in the user layer.

Am I correct that it is not possible to load these changes into the 
var layer while they are still in the usr layer. Is this behavior 
only valid for tables?

How can I get the changes transferred to the var layer without 
loosing the data already entered.

regards,
Danny Gaethofs





 Yahoo! Groups Sponsor ~--> 
What would our lives be like without music, dance, and theater?
Donate or volunteer in the arts today at Network for Good!
http://us.click.yahoo.com/Tcy2bD/SOnJAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

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

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

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

[Axapta-Knowledge-Village] Multithreading

[sasaxapta]

Dear all,
Does anybody has any experience about multithreading technique when 
making report program for axapta .
Background , My server big enough ( 4 processor , with 8 GB RAM , AWE 
enabled ) , but when i run the report program , I saw the processor 
utilization is less then 20% .The goal  I wanna make the processor as 
busy as possible.
thx
Sas





 Yahoo! Groups Sponsor ~--> 
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

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

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

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

[Axapta-Knowledge-Village] Re: Branch Definition within an Entity and attachment of documents to Branch

[crusader_chen]

Hi,

Does each depot has its own customer? If yes, then you can set the 
Number sequence group for each customer in the customer master. But 
sales order number is only one. 

If one customer can purchase from two depots then you can change the 
default number sequence group in the sales order header.


Regards,
Sun Fen

--- In Axapta-Knowledge-Village@yahoogroups.com, "bhgopal12" 
<[EMAIL PROTECTED]> wrote:
> 
> Hi All,
> 
> I have a clarification:
> 
> An organization with 100 Branches / Sales Depots going for Axapta 
> implementation.
> 
> Each Branch / Sales Depot is having a seperate Set of documents 
> (including running serial number) such as Sales Invoice, DN, CN, 
etc.
> 
> How to define the branches / Sales Depots and attach a set of 
> documents to it.





 Yahoo! Groups Sponsor ~--> 
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

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

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

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

[Axapta-Knowledge-Village] Branch Definition within an Entity and attachment of documents to Branch

[bhgopal12]

Hi All,

I have a clarification:

An organization with 100 Branches / Sales Depots going for Axapta 
implementation.

Each Branch / Sales Depot is having a seperate Set of documents 
(including running serial number) such as Sales Invoice, DN, CN, etc.

How to define the branches / Sales Depots and attach a set of 
documents to it. 







 Yahoo! Groups Sponsor ~--> 
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

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

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

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

[Axapta-Knowledge-Village] Capacity Planning Problem ( Urgent )

[Gokhan Can]

Hı
I have 2 questions 
1)
I have 16 Work Centers in a Work Center Group
I create a Production order and in the Route of this production I defined count 
of Work Center is 6
In my production parameters I set Max conflict solution Qty 100
I ran Job Scheduling an I got an error which says 
"too many combination to solve conflicts" and It selects alphabetically first 6 
work
 center from the work center group "
I changed the Max conflict solution Qty 1000 and ran job scheduling again and 
this time computer is locked and I closed AX32.exe.
Can anybody give a hint about this problem.
Or should I not use Axapta Job scheduling to select best work centers , and 
select work centers manually.
2) 
I have a production order which is registered to an sales order and sales order 
and production order qty is same and 1000.
My deals with my customers are I can ship sales order in -+ %2 quantity.
I finished my production and my good quantity is 998.
So for my customer 998 quantity is not a problem but when I try to finish my 
production order it gives an error "Production count is reserved and you can 
not decrease production quantity" so I can not finish my production order.
 
Thanks 
Gokhan Can

 


 Yahoo! Groups Sponsor ~--> 
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM
~-> 

Sharing the knowledge on Axapta. 
Yahoo! Groups Links

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

<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

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

[Axapta-Knowledge-Village] Axapta AOS Cluster parameter

[tonychan]

 
Hi 
all,
   I try to use 2 AOS and point to same application, and there 
is a parameter neet to be placed at the 'Advanced' Field in setting up the AOS 
in order to run cluster , anyone can help on the syntax of the parameter ? Many 
Thanks.
 
Best 
Regards,
 
Tony.


Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Axapta-Knowledge-Village] Update PackingSlip

[Alfonso Collados Arroyo]

Hi all,

I’m trying to update a packingslip this way:

 

    purchFormLetter =
purchFormLetter::construct(DocumentStatus::PackingSlip);  // Get a new instance
of PurchFormletter

    purchformletter.transDate(date);

 

    purchFormLetter.update
(_purchTable, // PurchTable

   _packingslipId,

   _date,

  
PurchUpdate::Recorded, // Quantity to update (SpecQty)

  
AccountOrder::None, // AccountOrder  

   false, //
Proforma   only?   

   false); //
Printout

 

 

Sometimes I’ m able to update the PAckingSlip,
but when I try to inquiry the packinglslip I can’t (line disable). The
purchstatus is Received.

 

Can anyone help?

 

Regards,

Alfonso

 






Sharing the knowledge on Axapta.








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.