[development-axapta] Unwanted Corrected sales tax amount in VendInvoiceJournal...

[Peter Chalem]

Hi All...
 
When we are typing a Invoice Journal in Accounts Payable, 
sometimes the system generates "automatically" some value on the Corrected Sales 
Tax Amount field ... I know if I go to the Sales Tax button in the form and then 
put an adjustment, it should create it, but in this case were not putting any 
adjustments in there but still the field gets calculated..
 
Does anyone know why?? or how to stop 
this??
 
Thanks and regards
 
Peter




Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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: [development-axapta] Re: Filtering on a memo field

[Preston A. Larimer]

I forgot to keep
in mind the dataAreaID, I figure you’d catch it
Don, but incase anyone else is looking.  

 

BTW you’ll
notice searching memo fields in the where clause is not a SQL shortcoming, but
an Axapta one.

 

-Preston

 

static void pl_scratch(Args _args)

{

    docuRef
dr;

    Connection 
con = new Connection();

    Statement  
sqlStmt = Con.createStatement();

    ResultSet  
sqlTable;

    notes  
sqlStr;

    str
searchWord;

    str
rangeList;

    str
dataareaID;

    ;

 

    dataareaID = curExt();

 

    searchWord = "Remark";

 

 

    sqlSTR = strFmt("select
recID from docuref where
notes like '\%%1\%' AND refCompanyID = '%2'", searchWord, dataareaID);

 

    info(sqlStr);

 

    sqlTable = sqlStmt.executeQuery(sqlSTR);

 

 while
(sqlTable.next()){

 

  //build recidList to use in other query

  rangeList = rangeList
+ (rangeList ? ", " + int2STR(sqlTable.getInt(1)) : int2STR(sqlTable.getInt(1)));

 

 }

    info(rangeList);

 

} 








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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: [development-axapta] Re: Filtering on a memo field

[Preston A. Larimer]

Hey Don, this code will loop the records
to build the  range list faster than anything
you can do with straight Axapta.

 

 

static void pl_scratch(Args
_args)

{

    docuRef
dr;

    Connection 
con = new Connection();

    Statement  
sqlStmt = Con.createStatement();

    ResultSet  
sqlTable;

    notes  
sqlStr;

    str
searchWord;

    str
rangeList;

    ;

 

    searchWord = "Remark";

 

    sqlSTR = strFmt("select
recID from docuref where
notes like '\%%1\%'", searchWord);

 

    info(sqlStr);

 

    sqlTable = sqlStmt.executeQuery(sqlSTR);

 

 while
(sqlTable.next()){

 

  //build recidList to use in other query

  rangeList = rangeList
+ (rangeList ? ", " + int2STR(sqlTable.getInt(1)) : int2STR(sqlTable.getInt(1)));

 

 }

    info(rangeList);

 

}

 

-Original Message-
From: Jacob Christian
Døskeland [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 22, 2004
1:39 PM
To:
[EMAIL PROTECTED]
Subject: Re: [development-axapta]
Re: Filtering on a memo field

 

As far as i know it's not possible to use where
statements on a memo field. It's a limit in SQL server.
So i think you need to loop the whole table and strscan() the field, and then
build the queryranges.

JAcob

At 17:06 22.01.2004 +, you wrote:



Invalid Range Type


--- In [EMAIL PROTECTED],
"Jonathan St-Louis" 
<[EMAIL PROTECTED]> wrote:
> Hi, what kind of exeption do you have?  
>   - Original Message - 
>   From: axaptacoder 
>   To:
[EMAIL PROTECTED] 
>   Sent: Thursday, January 22, 2004
10:30 AM
>   Subject: [development-axapta]
Filtering on a memo field
> 
> 
>   Hi All,
> 
> Has anybody ever been
able to come up with a solution to 
filter on 
>   a memo field?  Currently if
you try to set a range on this type 
of 
>   field it will throw an exception.
The only possible solution 
I've 
>   thought of is searching the table
myself in a loop and building 
a 
>   range of recids to pass on to the
query.  So that's probably not 
>   good for performance. I would
appreciate any hint or solution.
> 
> 
> 
>   Thanks
> 
>   Don
> 
> 
> 
> 
>
---
---
>   Yahoo! Groups Links
> 
> a.. To visit your
group on the web, go to:
> http://groups.yahoo.com/group/development-axapta/
>   
> b.. To unsubscribe
from this group, send an email to:
>
[EMAIL PROTECTED]
>   
> c.. Your use of
Yahoo! Groups is subject to the Yahoo! Terms 
of Service.









Yahoo! Groups Links 

·
To visit your group on the
web, go to: 

·
http://groups.yahoo.com/group/development-axapta/


·
  

·
To unsubscribe from this
group, send an email to: 

·
[EMAIL PROTECTED]


·
  

·
Your use of Yahoo! Groups is
subject to the Yahoo! Terms of
Service. 



 







Yahoo!
Groups Links

·
To visit your group on the
web, go to:
http://groups.yahoo.com/group/development-axapta/
  

·
To unsubscribe from this
group, send an email to:
[EMAIL PROTECTED]
  

·
Your use of Yahoo! Groups is
subject to the Yahoo! Terms of
Service. 









Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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: [development-axapta] Re: Filtering on a memo field

[Jacob Christian Døskeland]

As far as i know it's not possible to use where statements on a memo
field. It's a limit in SQL server.
So i think you need to loop the whole table and strscan() the field, and
then build the queryranges.
JAcob
At 17:06 22.01.2004 +, you wrote:
Invalid Range Type

--- In [EMAIL PROTECTED], "Jonathan St-Louis"

<[EMAIL PROTECTED]> wrote:
> Hi, what kind of exeption do you have?  
>   - Original Message - 
>   From: axaptacoder 
>   To: [EMAIL PROTECTED] 
>   Sent: Thursday, January 22, 2004 10:30 AM
>   Subject: [development-axapta] Filtering on a memo
field
> 
> 
>   Hi All,
> 
> Has anybody ever been able to come up with a
solution to 
filter on 
>   a memo field?  Currently if you try to set a range
on this type 
of 
>   field it will throw an exception. The only possible
solution 
I've 
>   thought of is searching the table myself in a loop and
building 
a 
>   range of recids to pass on to the query.  So that's
probably not 
>   good for performance. I would appreciate any hint or
solution.
> 
> 
> 
>   Thanks
> 
>   Don
> 
> 
> 
> 
>
---
---
>   Yahoo! Groups Links
> 
> a.. To visit your group on the web, go
to:
>
http://groups.yahoo.com/group/development-axapta/
>   
> b.. To unsubscribe from this group, send an
email to:
>
[EMAIL PROTECTED]
>   
> c.. Your use of Yahoo! Groups is subject to
the Yahoo! Terms 
of Service.


Yahoo! Groups Links

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








Yahoo! Groups Sponsor


  ADVERTISEMENT 









Yahoo! Groups Links

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

[development-axapta] Re: Filtering on a memo field

[axaptacoder]

Invalid Range Type


--- In [EMAIL PROTECTED], "Jonathan St-Louis" 
<[EMAIL PROTECTED]> wrote:
> Hi, what kind of exeption do you have?  
>   - Original Message - 
>   From: axaptacoder 
>   To: [EMAIL PROTECTED] 
>   Sent: Thursday, January 22, 2004 10:30 AM
>   Subject: [development-axapta] Filtering on a memo field
> 
> 
>   Hi All,
> 
> Has anybody ever been able to come up with a solution to 
filter on 
>   a memo field?  Currently if you try to set a range on this type 
of 
>   field it will throw an exception. The only possible solution 
I've 
>   thought of is searching the table myself in a loop and building 
a 
>   range of recids to pass on to the query.  So that's probably not 
>   good for performance. I would appreciate any hint or solution.
> 
> 
> 
>   Thanks
> 
>   Don
> 
> 
> 
> 
> ---
---
>   Yahoo! Groups Links
> 
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/development-axapta/
>   
> b.. To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>   
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms 
of Service.







Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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: [development-axapta] Filtering on a memo field

[Jonathan St-Louis]

Hi, what kind of exeption do you have?  


  - Original Message - 
  From: 
  axaptacoder 
  To: [EMAIL PROTECTED] 
  
  Sent: Thursday, January 22, 2004 10:30 
  AM
  Subject: [development-axapta] Filtering 
  on a memo field
  Hi All,  Has anybody ever been able to come up 
  with a solution to filter on a memo field?  Currently if you try to 
  set a range on this type of field it will throw an exception. The only 
  possible solution I've thought of is searching the table myself in a loop 
  and building a range of recids to pass on to the query.  So that's 
  probably not good for performance. I would appreciate any hint or 
  solution.ThanksDon
  
  Yahoo! Groups Links
  
To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/  

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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 
  




Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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: [development-axapta] Setting Width Size Of A Coloumn In The Look Up Window

[Anil Ozay]

Hi, 
sysTableLookup class doesn't support this functionality. You can edit this class 
and add this functionality. Another technique is creating a new form (most 
personalized but may be a bit slow) and using it to lookup. You can find more 
information on Axapta Help.
 
Help / Creating Forms / Designig 
Forms
 
Anil


From: Michael Jackson 
[mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 
2004 5:46 PMTo: [EMAIL PROTECTED]Subject: 
[development-axapta] Setting Width Size Of A Coloumn In The Look Up 
Window


 
    
    Hi All,
 
    
I want to set width of a coloumn in the look up window. Because, now, my that 
look up window has a coloumn and all data in that coloum aren’t beeing read as 
whole. So, actually these data have long string expressions. What must I do in 
order to display all row data with their all characters in coloumn of look up 
window.
 
    
Regards.
 
    
MJ.
 
 

Yahoo! Groups Links

  To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/  

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

  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 





Yahoo! Groups Links

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

[development-axapta] How I can Insert New Column type in Financials statements?

[finitocr]

> Hi all,
>
> I need add two column type in the option Financial
> statement/Columns/ColumType for print reports, one for fiscal 
account, and
> one for fiscal name? Any idea or tip ?
>
> Please help me!
>
> Best Regards all and I wish a succesfully year !
>
> Julio,
>








Yahoo! Groups Links

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

[development-axapta] Filtering on a memo field

[Don Price]

Hi All,

 

  Has anybody
ever been able to come up with a solution to filter on a memo field?  Currently if you try to set a range on
this type of field it will throw an exception. The only possible solution I’ve
thought of is searching the table myself in a loop and building a range of recids to pass on to the query.  So that’s probably not good for
performance. I would appreciate any hint or solution.

 

Thanks

Don








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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: SV: [development-axapta] Regarding Labels

[jesper.joergensen]

Title: Meddelelse









Hi Mikael,
try deleting the .ali (index file) for the label file, start the application 
on the Server in 2-tier mode. Then restart the AOS.
/Jesper
 
 

  


  
Original 
Message  
  
 processed 
by Tobit InfoCenter 

  
Subject: 
  SV: 
[development-axapta] Regarding Labels (22-Jan-2004 
  16:25)

  
From:
  [EMAIL PROTECTED]

  
To:  
  [EMAIL PROTECTED]
   
  Hi 
  Thomas
   
  I 
  tried that a several times - and still got the same 
  problem.
   
  Br. 
  Mikael
  

-Oprindelig meddelelse-Fra: Thomas Jensen 
[mailto:[EMAIL PROTECTED] Sendt: 22. januar 2004 16:16Til: 
'[EMAIL PROTECTED]'Emne: SV: 
[development-axapta] Regarding Labels

Hi 
Mikael
 
Stop 
the AOS, copy the labelfiles to the server and 
start the AOS again. That should work.
 
Regards
Thomas
 
-Oprindelig meddelelse-Fra: Mikael Dalgård 
[mailto:[EMAIL PROTECTED] Sendt: 22. januar 2004 
16:05Til: 
[EMAIL PROTECTED]Emne: [development-axapta] Regarding 
Labels
 

Hi 
all

 

I got a BIG (label 
problem),

 

when I try to 
import a project from my developer laptop into our AOS Test Server, I 
don't get all of the labels during the import (only some of them). I 
try to set all of the labels to (be overwritten, but that doesn't't work 
either).

 

I tried to copy 
all of the labels files manually into the AOS server - but without any 
further luck (by using copy axmid*.* etc.) I still got the same @MIDnumber 
something instead of the label text.

 

Does anybody have 
a hint for me about this.

 

best 
regards

Mikael 
Dalgård




Yahoo! Groups 
Links
· 
To visit your group on 
the web, go to:http://groups..yahoo.com/group/development-axapta/  

· 
To unsubscribe from this 
group, send an email to:[EMAIL PROTECTED]  

· 
Your use of Yahoo! 
Groups is subject to the Yahoo! 
Terms of Service. 

Yahoo! Groups Links

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

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







Yahoo! Groups Sponsor


  ADVERTISEMENT 









Yahoo! Groups Links

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

[development-axapta] Setting Width Size Of A Coloumn In The Look Up Window

[Michael Jackson]

 

        Hi All,

 

   
I want to set width of a coloumn in the look up window. Because, now, my that
look up window has a coloumn and all data in that coloum aren’t beeing
read as whole. So, actually these data have long string expressions. What must
I do in order to display all row data with their all characters in coloumn of
look up window.

 

    Regards.

 

    MJ.

 

 








Yahoo! Groups Links

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

[development-axapta] Filtering on a memo field

[axaptacoder]

Hi All,

  Has anybody ever been able to come up with a solution to filter on 
a memo field?  Currently if you try to set a range on this type of 
field it will throw an exception. The only possible solution I've 
thought of is searching the table myself in a loop and building a 
range of recids to pass on to the query.  So that's probably not 
good for performance. I would appreciate any hint or solution.

 

Thanks

Don








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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: [development-axapta] Regarding Labels

[Cenk Ince]

Title: Meddelelse











On AOS try to create new label file with
id MID. Then Close AOS and replace your labels with new created labels.

 

Maybe that will work.

 

Good Luck.

 

-Original
Message-
From: Mikael Dalgård
[mailto:[EMAIL PROTECTED] 
Sent: Thursday,
 January 22, 2004 5:23
 PM
To:
[EMAIL PROTECTED]
Subject: SV: [development-axapta]
Regarding Labels

 



Hi Thomas





 





I tried that a several times - and still got the same problem.





 





Br. Mikael





-Oprindelig meddelelse-
Fra: Thomas Jensen
[mailto:[EMAIL PROTECTED] 
Sendt: 22. januar 2004 16:16
Til:
'[EMAIL PROTECTED]'
Emne: SV: [development-axapta]
Regarding Labels

Hi
Mikael

 

Stop the AOS, copy the labelfiles to the server and start the AOS
again. That should work.

 

Regards

Thomas

 

-Oprindelig
meddelelse-
Fra: Mikael Dalgård
[mailto:[EMAIL PROTECTED] 
Sendt: 22. januar 2004 16:05
Til:
[EMAIL PROTECTED]
Emne: [development-axapta]
Regarding Labels

 



Hi all





 





I got a BIG (label
problem),





 





when I try to import a
project from my developer laptop into our AOS Test Server, I don´t get all
of the labels during the import (only some of them). I try to set all of
the labels to (be overwritten, but that doesn't´t work either).





 





I tried to copy all of the
labels files manually into the AOS server - but without any further luck (by
using copy axmid*.* etc.) I still got the same @MIDnumber something instead of
the label text.





 





Does anybody have a hint
for me about this.





 





best regards





Mikael Dalgård

















Yahoo!
Groups Links

·
To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
  

·
To unsubscribe from this group, send an email
to:
[EMAIL PROTECTED]
  

·
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 

 







Yahoo!
Groups Links

·
To visit your group on the
web, go to:
http://groups.yahoo.com/group/development-axapta/
  

·
To unsubscribe from this
group, send an email to:
[EMAIL PROTECTED]
  

·
Your use of Yahoo! Groups is
subject to the Yahoo! Terms of
Service. 

 















Yahoo!
Groups Links

·
To visit your group on the
web, go to:
http://groups.yahoo.com/group/development-axapta/
  

·
To unsubscribe from this
group, send an email to:
[EMAIL PROTECTED]
  

·
Your use of Yahoo! Groups is
subject to the Yahoo! Terms of
Service. 









Yahoo! Groups Links

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

SV: [development-axapta] Regarding Labels

[Thomas Jensen]

Title: Meddelelse











Maybe
your label file isn't updated with the labels. Remember that it's
updated only when the last user exists Axapta. Try to open the labelfile
in a notepad to check.

 

Thomas

 

-Oprindelig
meddelelse-
Fra: Mikael Dalgård
[mailto:[EMAIL PROTECTED] 
Sendt: 22. januar 2004 16:23
Til:
[EMAIL PROTECTED]
Emne: SV: [development-axapta]
Regarding Labels

 



Hi
Thomas





 





I
tried that a several times - and still got the same problem.





 





Br.
Mikael





-Oprindelig meddelelse-
Fra: Thomas Jensen
[mailto:[EMAIL PROTECTED] 
Sendt: 22. januar 2004 16:16
Til:
'[EMAIL PROTECTED]'
Emne: SV: [development-axapta]
Regarding Labels

Hi
Mikael

 

Stop the AOS, copy the labelfiles to the
server and start the AOS again. That should work.

 

Regards

Thomas

 

-Oprindelig meddelelse-
Fra: Mikael Dalgård
[mailto:[EMAIL PROTECTED] 
Sendt: 22. januar 2004 16:05
Til:
[EMAIL PROTECTED]
Emne: [development-axapta]
Regarding Labels

 



Hi all





 





I got a BIG (label problem),





 





when I try to import a project from
my developer laptop into our AOS Test Server, I don´t get all of the
labels during the import (only some of them). I try to set all of the labels to
(be overwritten, but that doesn't´t work either).





 





I tried to copy all of the labels
files manually into the AOS server - but without any further luck (by using
copy axmid*.* etc.) I still got the same @MIDnumber something instead of the
label text.





 





Does anybody have a hint for me
about this.





 





best regards





Mikael Dalgård

















Yahoo!
Groups Links

1.  To
visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
  

2.   
To unsubscribe from this
group, send an email to:
[EMAIL PROTECTED]
  

3.   
Your use of Yahoo! Groups is
subject to the Yahoo! Terms of
Service. 

 







Yahoo!
Groups Links

· To
visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
  

·
To unsubscribe from this
group, send an email to:
[EMAIL PROTECTED]
  

·
Your use of Yahoo! Groups is
subject to the Yahoo! Terms of
Service. 

 















Yahoo!
Groups Links

·
To visit your group on the
web, go to:
http://groups.yahoo.com/group/development-axapta/
  

·
To unsubscribe from this
group, send an email to:
[EMAIL PROTECTED]
  

·
Your use of Yahoo! Groups is
subject to the Yahoo! Terms of
Service. 









Yahoo! Groups Links

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

SV: [development-axapta] Regarding Labels

[Mikael Dalgård]

Title: Meddelelse





Hi 
Thomas
 
I 
tried that a several times - and still got the same problem.
 
Br. 
Mikael

  
  -Oprindelig meddelelse-Fra: Thomas Jensen 
  [mailto:[EMAIL PROTECTED] Sendt: 22. januar 2004 16:16Til: 
  '[EMAIL PROTECTED]'Emne: SV: [development-axapta] 
  Regarding Labels
  
  Hi 
  Mikael
   
  Stop 
  the AOS, copy the labelfiles to the server and start 
  the AOS again. That should work.
   
  Regards
  Thomas
   
  -Oprindelig meddelelse-Fra: Mikael Dalgård 
  [mailto:[EMAIL PROTECTED] Sendt: 22. januar 2004 16:05Til: 
  [EMAIL PROTECTED]Emne: [development-axapta] Regarding 
  Labels
   
  
  Hi 
  all
  
   
  
  I got a BIG (label 
  problem),
  
   
  
  when I try to import a project 
  from my developer laptop into our AOS Test Server, I don´t get all 
  of the labels during the import (only some of them). I try to set all of 
  the labels to (be overwritten, but that doesn't´t work 
  either).
  
   
  
  I tried to copy all of the labels 
  files manually into the AOS server - but without any further luck (by using 
  copy axmid*.* etc.) I still got the same @MIDnumber something instead of the 
  label text.
  
   
  
  Does anybody have a hint for me 
  about this.
  
   
  
  best 
  regards
  
  Mikael 
  Dalgård
  
  
  
  
  Yahoo! Groups 
  Links
  · 
  To visit your 
  group on the web, go to:http://groups.yahoo.com/group/development-axapta/  
  
  · 
  To 
  unsubscribe from this group, send an email to:[EMAIL PROTECTED]  
  
  · 
  Your use of 
  Yahoo! Groups is subject to the Yahoo! Terms of Service. 
  
  
  Yahoo! Groups Links
  
To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/  

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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 
  







Yahoo! Groups Sponsor


  ADVERTISEMENT 









Yahoo! Groups Links

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

AW: [development-axapta] Re: overwritesystemfields doesnt work

[HEW (Mag. Helmut Wimmer)]

Hi

I remember to have read somewhere (probably in Technet) that you can only
overwrite the systemfields when inserting records. So, only "createdBy" and
the like can be set manually, but not "modifiedBy" etc.

The only solution for you I can think of is directly writing SQL statements
(either in SQL tool or with Axapta connection/statement).

Best regards
Helmut Wimmer

-Ursprüngliche Nachricht-
Von: Henrik Østergård [mailto:[EMAIL PROTECTED] 
Gesendet: Donnerstag, 22. Jänner 2004 15:17
An: [EMAIL PROTECTED]
Betreff: RE: [development-axapta] Re: overwritesystemfields doesnt work



>-- Oprindelig Besked --
>To: [EMAIL PROTECTED]
>From: "agramm2000" <[EMAIL PROTECTED]>
>Date: Thu, 22 Jan 2004 13:55:52 -
>Subject: [development-axapta] Re: overwritesystemfields doesnt work
>Reply-To: [EMAIL PROTECTED]
>
>
>--- In [EMAIL PROTECTED], Henrik Østergård
><[EMAIL PROTECTED]> wrote:
>> Hi,
>> 
>> Could anyone please tell me why the systemfield "ModifiedBy" doesnt
>seem
>> to be updated.
>> Its for an conversion from XAL, where some transacts uses these 
>fields.
>> Dirty trick would be to make a new field, but I would rather not.
>> 
>> 
>>    ttsbegin
>>    cg = custgroup::find("test1",true);
>> 
>> info(cg.modifiedby);
>>    cg.overwriteSystemfields(true);
>>    cg.(fieldname2id(cg.TableId,"modifiedBy")) = "test";
>>    cg.update();
>> 
>>    ttscommit;
>> info(cg.modifiedby);
>> 
>> Rgz, Henrik
>
>Did you enable "Modified By" in property of table custgroup? It it not 
>enabled in standard.
>
>Regards
>Andi

Hi Andi
I did now, but it didnt help. 
rqz, Henrik



 

Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/

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/ 







Yahoo! Groups Links

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

SV: [development-axapta] Regarding Labels

[Thomas Jensen]

Title: Meddelelse











Hi Mikael

 

Stop
the AOS, copy the labelfiles to the server and start
the AOS again. That should work.

 

Regards

Thomas

 

-Oprindelig
meddelelse-
Fra: Mikael Dalgård
[mailto:[EMAIL PROTECTED] 
Sendt: 22. januar 2004 16:05
Til:
[EMAIL PROTECTED]
Emne: [development-axapta]
Regarding Labels

 



Hi all





 





I got a BIG (label problem),





 





when I try to import a project from
my developer laptop into our AOS Test Server, I don´t get all of the
labels during the import (only some of them). I try to set all of the labels to
(be overwritten, but that doesn't´t work either).





 





I tried to copy all of the labels
files manually into the AOS server - but without any further luck (by using
copy axmid*.* etc.) I still got the same @MIDnumber something instead of the
label text.





 





Does anybody have a hint for me
about this.





 





best regards





Mikael Dalgård















Yahoo!
Groups Links

·
To visit your group on the
web, go to:
http://groups.yahoo.com/group/development-axapta/
  

·
To unsubscribe from this
group, send an email to:
[EMAIL PROTECTED]
  

·
Your use of Yahoo! Groups is
subject to the Yahoo! Terms of
Service. 









Yahoo! Groups Links

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

[development-axapta] Regarding Labels

[Mikael Dalgård]

Title: Meddelelse





Hi 
all
 
I got a BIG (label 
problem),
 
when I try to 
import a project from my developer laptop into our AOS Test Server, I don´t 
get all of the labels during the import (only some of them). I try to set 
all of the labels to (be overwritten, but that doesn't´t work 
either).
 
I tried to copy all 
of the labels files manually into the AOS server - but without any further luck 
(by using copy axmid*.* etc.) I still got the same @MIDnumber something instead 
of the label text.
 
Does anybody have a 
hint for me about this.
 
best 
regards
Mikael 
Dalgård







Yahoo! Groups Sponsor


  ADVERTISEMENT 









Yahoo! Groups Links

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

[development-axapta] Setting Width Size Of A Coloumn In The Look Up Screen

[Michael Jackson]

 

   
Hi All,

 

   
I want to set width of look up screen. Because, now, look up screen has a
coloumn and all data in that coloum aren’t beeing read. So, actually
these data have long string expressions. And also, label of this coloumn is
“Color”. I suppose that I must change label name (for example;
“Color Names” or  of this coloumn in order to extend
size of this coloumn. Therefore, I used this code (sysTableLookup.setLabel("Color
Name");) into my look up code section.

 

   
I wrote this code into here (in my look up method);

 

 

    //The next line
actualy adds the fields that will be displayed in the lookup grid

    

   
sysTableLookup.setLabel("Color Name");

    sysTableLookup.addLookupfield(fieldNum(INVENTDIMCOMBINATION,
INVENTCOLORID));

 

 

or I wrote
this code into here (in my look up method);

    //The next line
actualy adds the fields that will be displayed in the lookup grid

    

   
sysTableLookup.addLookupfield(fieldNum(INVENTDIMCOMBINATION, INVENTCOLORID));

   
sysTableLookup.setLabel("Color Name");

 

 

   
But, I didn’t do it.

 

   
Maybe, I must write another code without using setLabel method of
sysTableLookup class. 

 

   
You think, what must I do for this operation. Tell me please.

 

   
Thank you.

 

   
MJ.

 

 








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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: [development-axapta] Re: overwritesystemfields doesnt work

[Henrik Østergård]

>-- Oprindelig Besked --
>To: [EMAIL PROTECTED]
>From: "agramm2000" <[EMAIL PROTECTED]>
>Date: Thu, 22 Jan 2004 13:55:52 -
>Subject: [development-axapta] Re: overwritesystemfields doesnt work
>Reply-To: [EMAIL PROTECTED]
>
>
>--- In [EMAIL PROTECTED], Henrik Østergård 
><[EMAIL PROTECTED]> wrote:
>> Hi,
>> 
>> Could anyone please tell me why the systemfield "ModifiedBy" doesnt 
>seem
>> to be updated. 
>> Its for an conversion from XAL, where some transacts uses these 
>fields.
>> Dirty trick would be to make a new field, but I would rather not.
>> 
>> 
>>ttsbegin
>>cg = custgroup::find("test1",true);
>> 
>> info(cg.modifiedby);
>>cg.overwriteSystemfields(true);
>>cg.(fieldname2id(cg.TableId,"modifiedBy")) = "test";
>>cg.update();
>> 
>>ttscommit;
>> info(cg.modifiedby);
>> 
>> Rgz, Henrik
>
>Did you enable "Modified By" in property of table custgroup?
>It it not enabled in standard.
>
>Regards
>Andi

Hi Andi
I did now, but it didnt help. 
rqz, Henrik



 

Yahoo! Groups Links

To visit your group on the web, go to:
 http://groups.yahoo.com/group/development-axapta/

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/ 

[development-axapta] Re: overwritesystemfields doesnt work

[agramm2000]

--- In [EMAIL PROTECTED], Henrik Østergård 
<[EMAIL PROTECTED]> wrote:
> Hi,
> 
> Could anyone please tell me why the systemfield "ModifiedBy" doesnt 
seem
> to be updated. 
> Its for an conversion from XAL, where some transacts uses these 
fields.
> Dirty trick would be to make a new field, but I would rather not.
> 
> 
>    ttsbegin
>    cg = custgroup::find("test1",true);
> 
> info(cg.modifiedby);
>    cg.overwriteSystemfields(true);
>    cg.(fieldname2id(cg.TableId,"modifiedBy")) = "test";
>    cg.update();
> 
>    ttscommit;
> info(cg.modifiedby);
> 
> Rgz, Henrik

Did you enable "Modified By" in property of table custgroup?
It it not enabled in standard.

Regards
Andi










Yahoo! Groups Sponsor


  ADVERTISEMENT 









Yahoo! Groups Links

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

[development-axapta] Rename the field...

["Boris Gartner"]

Hi All!
How can I rename the field at any form?
E.g. I want to rename: Accounts receivable -> Sales Order -> Dimensions -> Department 
--->>> into Division ???
Or Accounts receivable -> Sales Order -> Dimensions -> Color --->>> textile ???

Boris

 

 Yahoo! Groups Sponsor -~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/saFolB/TM
-~->

Yahoo! Groups Links

To visit your group on the web, go to:
 http://groups.yahoo.com/group/development-axapta/

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 : [development-axapta] what's better ??

[Steeve Gilbert]

Here we have a mix of import project and layer.  Here's our environment setup.

| Dev | --project--> | Test | --USR Layer--> | Production |
  <---project---

Dev : Where we do all our development

Test : When a development is over it's moved too Test Env for testing.  Once in a while we move the layer to production to put our new approved modification live.  Before moving the layer, if some stuff is still not tested we put back the production version into the Test env.  Once the layer is moved to production, we put back the "not tested yet" stuff from Dev to Test.  The application is compile/synchronised before going live.

Production : Live environnement.

Steeve...

-Message d'origine-
De : vario0 [mailto:[EMAIL PROTECTED] 
Envoyé : 22 janvier 2004 08:01
À : [EMAIL PROTECTED]
Objet : [development-axapta] what's better ??

Hy, 

When we began with axapta programming, one of our consultant said 
that the usage of Import/Export project was a wrong solution.

Then, he adviced us to import our developpement by making a copy of 
the "CUS Layer".  But, in this case, before each copy, we need a 
stabilised layer.  And, some people have to wait others before 
beginning a new developpement.

Then, what's the best solution for developpement importing in the 
Live environment??
What do you use??

Thanks a lot
Thierry



 

Yahoo! Groups Links

To visit your group on the web, go to:
 http://groups.yahoo.com/group/development-axapta/

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/ 











Yahoo! Groups Sponsor


  ADVERTISEMENT 









Yahoo! Groups Links

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

[development-axapta] Re: what's better ??

[vario0]

Thanks a lot
--- In [EMAIL PROTECTED], Jacob Christian Døskeland 
<[EMAIL PROTECTED]> wrote:
> It depends on your needs!
> If you are able to always have a stabilised layer its very nice to 
use the 
> way the consultant talks about. Because you are then 100 % sure 
that you 
> are operating with the same table ids and so on in both enviroments.
> 
> If it's hard to keep the dev enviroment stabilised at all times, 
the 
> export/import solution is just super!
> It's also nice with the export/import rutine that you can do it 
when people 
> are one the solution, not always, but most of the times.
> 
> Best regards Jacob
> 
> At 13:00 22.01.2004 +, you wrote:
> >Hy,
> >
> >When we began with axapta programming, one of our consultant said
> >that the usage of Import/Export project was a wrong solution.
> >
> >Then, he adviced us to import our developpement by making a copy of
> >the "CUS Layer".  But, in this case, before each copy, we need a
> >stabilised layer.  And, some people have to wait others before
> >beginning a new developpement.
> >
> >Then, what's the best solution for developpement importing in the
> >Live environment??
> >What do you use??
> >
> >Thanks a lot
> >Thierry
> >
> >
> >
> >
> >--
> >Yahoo! Groups Links
> >    * To visit your group on the web, go to:
> >    * 
> > http://groups.yahoo.com/group/development-axapta/ 
> >
> >    *
> >    * To unsubscribe from this group, send an email to:
> >    * 
> > 
subject=Unsubscribe>[EMAIL PROTECTED] 
> >
> >    *
> >    * Your use of Yahoo! Groups is subject to the 
> > Yahoo! Terms of Service.










Yahoo! Groups Sponsor


  ADVERTISEMENT 









Yahoo! Groups Links

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

[development-axapta] overwritesystemfields doesnt work

[Henrik Østergård]

Hi,

Could anyone please tell me why the systemfield "ModifiedBy" doesnt seem
to be updated. 
Its for an conversion from XAL, where some transacts uses these fields.
Dirty trick would be to make a new field, but I would rather not.


   ttsbegin
   cg = custgroup::find("test1",true);

info(cg.modifiedby);
   cg.overwriteSystemfields(true);
   cg.(fieldname2id(cg.TableId,"modifiedBy")) = "test";
   cg.update();

   ttscommit;
info(cg.modifiedby);

Rgz, Henrik



 

Yahoo! Groups Links

To visit your group on the web, go to:
 http://groups.yahoo.com/group/development-axapta/

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: [development-axapta] what's better ??

[Jacob Christian Døskeland]

It depends on your needs!
If you are able to always have a stabilised layer its very nice to use
the way the consultant talks about. Because you are then 100 % sure that
you are operating with the same table ids and so on in both
enviroments.
If it's hard to keep the dev enviroment stabilised at all times, the
export/import solution is just super!
It's also nice with the export/import rutine that you can do it when
people are one the solution, not always, but most of the times.
Best regards Jacob
At 13:00 22.01.2004 +, you wrote:
Hy, 
When we began with axapta programming, one of our consultant said 
that the usage of Import/Export project was a wrong solution.
Then, he adviced us to import our developpement by making a copy of 

the "CUS Layer".  But, in this case, before each copy, we
need a 
stabilised layer.  And, some people have to wait others before 

beginning a new developpement.
Then, what's the best solution for developpement importing in the 
Live environment??
What do you use??
Thanks a lot
Thierry



Yahoo! Groups Links

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








Yahoo! Groups Sponsor


  ADVERTISEMENT 









Yahoo! Groups Links

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

[development-axapta] what's better ??

[vario0]

Hy, 

When we began with axapta programming, one of our consultant said 
that the usage of Import/Export project was a wrong solution.

Then, he adviced us to import our developpement by making a copy of 
the "CUS Layer".  But, in this case, before each copy, we need a 
stabilised layer.  And, some people have to wait others before 
beginning a new developpement.

Then, what's the best solution for developpement importing in the 
Live environment??
What do you use??

Thanks a lot
Thierry








Yahoo! Groups Links

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

[development-axapta] commission

[[EMAIL PROTECTED]]

sorry, i forgot to change the subject on previous mail.


hi,

anyone know how to pay external emploied commission ?


the setting on commision customer group and sales group and so on run properly, the commission are correctly calculated on invoice. I do not know if a specific procedure has to be used to pay these commision.
I know is not a development issue, but plese give me some advise.

thaks
Bob 








Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
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:[development-axapta] Notes of DocuRef are not splitted correctly (Axapta3SP1)

[[EMAIL PROTECTED]]

hi,

anyone know how to pay external emploied commission ?


the setting on commision customer group and sales group and so on run properly, the commission are correctly calculated on invoice. I do not know if a specific procedure has to be used to pay these commision.
I know is not a development issue, but plese give me some advise.

thaks
Bob 








Yahoo! Groups Links

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

[development-axapta] Notes of DocuRef are not splitted correctly (Axapta3SP1)

[agramm2000]

Hi,

There is a note, which do not fit on one page in report 
SalesQuotation. If printing you have a page with part of text then 
you have a page only with header and footer next page next part of 
text is printed then an empty page again and so on.

ReportStringControl ist set to dynamic height = yes but changes it 
back to functionality of Axapta2.5 and set heigth of control 
explicitly gives the same result.

Does anybody know this bug?
Is a solution available?

Regards
Andi







Yahoo! Groups Links

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

[development-axapta] Re: What does element.close() do on Web Forms?

[vozadali]

Ok :)

I saw that it is used is the code of Enterprise Portal in various 
places. But I didn't use it in any place in the codes I developed 
for the Web. So I thought that it may cause errors in the future 
since I don't use element.close() anywhere:)

--- In [EMAIL PROTECTED], Jacob Christian Døskeland 
<[EMAIL PROTECTED]> wrote:
> Obs, sorry. Didn't see the  'web' word...
> I'm not sure about the web
> 
> At 19:02 21.01.2004 +, you wrote:
> 
> >On web forms,
> >
> >What does element.close() do? When is it used?
> >
> >Thanks
> >
> >
> >
> >--
> >Yahoo! Groups Links
> >    * To visit your group on the web, go to:
> >    * 
> > http://groups.yahoo.com/group/development-axapta/ 
> >
> >    *
> >    * To unsubscribe from this group, send an email to:
> >    * 
> > 
subject=Unsubscribe>[EMAIL PROTECTED] 
> >
> >    *
> >    * Your use of Yahoo! Groups is subject to the 
> > Yahoo! Terms of Service.










Yahoo! Groups Sponsor


  ADVERTISEMENT 









Yahoo! Groups Links

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

[development-axapta] Setting Width Size Of Look Up Screen

[Michael JACKSON]

 

    Hi
All,

 

    I
want to set width of look up screen. Because, now, look up screen has a coloumn
and all data in that coloum aren’t beeing read. So, actually these data
have long string expressions. And also, label of this coloumn is “Color”.
I suppose that I must change label name (for example; “Color Names”
or  of this coloumn in order to extend size of this coloumn. Therefore,
I used this code (sysTableLookup.setLabel("Color Name");) into my
look up code section.

 

    I
wrote this code into here (in my look up method);

 

 

    //The next line
actualy adds the fields that will be displayed in the lookup grid

    

   
sysTableLookup.setLabel("Color Name");

   
sysTableLookup.addLookupfield(fieldNum(INVENTDIMCOMBINATION, INVENTCOLORID));

 

 

or I wrote this code into here (in
my look up method);



    //The next line
actualy adds the fields that will be displayed in the lookup grid

    

   
sysTableLookup.addLookupfield(fieldNum(INVENTDIMCOMBINATION, INVENTCOLORID));

   
sysTableLookup.setLabel("Color Name");

 

 

    But,
I didn’t do it.

 

    Maybe,
I must write another code without using setLabel method of sysTableLookup class.


 

    You
think, what must I do for this operation. Tell me please.

 

    Thank
you.

 

    MJ.

 











Yahoo! Groups Sponsor


  ADVERTISEMENT 









Yahoo! Groups Links

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

[development-axapta] About Look Up Operations

[Michael JACKSON]

 

    Hi
All,

 

    I
asked some information about look up operations before. Fist of all, Thank you
for your helps.

    Besides,
I want to ask a question about look up operations. So, I wanted to limit look
up screen for a coloumn related with two coloumns on the same grid table. I
asked this question before. And I learned. Now, my look up screen has a coloumn
(for example; that’s name is InventColorId (from InventDimCombination
table on the database)) and its working is true. But also, I want to add a
coloumn (for example; that’s name is Name from InventColor table on the
same database) at the same time. I suppose that I must write a query which supplies
relations (or join) between these two tables (for example; InventDimCombination.InventColorId
== InventColor.InventColorId).

 

    In
addition to above; my look up code is now :

 

public void lookup()

{


sysTableLookup 
sysTableLookup  =
SysTableLookup::newParameters(tableNum(INVENTDIMCOMBINATION), this);

 


Query  
 query  
= New Query();


QueryBuildDataSource    qbdsTbl1;

 QueryBuildRange
   qbr;

 ;

 

 //Add Tables to the data source


qbdsTbl1  =
query.addDataSource(tableNum(INVENTDIMCOMBINATION));

 

 //Add Query Ranges to limit List
records

 qbr =
qbdsTbl1.addRange(fieldNum(INVENTDIMCOMBINATION, ITEMID));

 qbr.value(SalesLine.ItemId);

 

 if ((InventDim.configId ==
"") || (InventDim.InventSizeId == ""))

 {

    // This section
is used, if user don’t select another two coloumn (those are required)
together on the same grid.

    qbr =
qbdsTbl1.addRange(fieldNum(INVENTDIMCOMBINATION, CONFIGID));

   
qbr.value(".");

 

    qbr =
qbdsTbl1.addRange(fieldNum(INVENTDIMCOMBINATION, INVENTSIZEID));

   
qbr.value(".");

 }

 else

 {

    qbr =
qbdsTbl1.addRange(fieldNum(INVENTDIMCOMBINATION, CONFIGID));

   
qbr.value(InventDim.configId);

 

    qbr = qbdsTbl1.addRange(fieldNum(INVENTDIMCOMBINATION,
INVENTSIZEID));

   
qbr.value(InventDim.InventSizeId);

 

 }

    //The next line
actualy adds the fields that will be displayed in the lookup grid

   
sysTableLookup.addLookupfield(fieldNum(INVENTDIMCOMBINATION, INVENTCOLORID));

 

    //Hand the
created query to the sysTableLookupClass

   
sysTableLookup.parmQuery(query);

 

    //Display the
drop down

   
sysTableLookup.performFormLookup();

}

 

    Consequently,
You think, what must I do for this operations.

 

    Thank
you.

 

    MJ.

 











Yahoo! Groups Sponsor


  ADVERTISEMENT 









Yahoo! Groups Links

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