Re: [Axapta-Knowledge-Village] Changing App. Title Bar Color?

2005-08-26 Thread hemant kumar







hi,
i think u really have the problem but as u said that u r a programmer then i suggest u to make a pop up which pop on every time when u switch between companies, with giving the name of the company u r working,the login Id, and also if u want then database and application.
Regards
hemant




Brandon George [EMAIL PROTECTED] wrote: 


Hello All,

 I have a problem, that I would like some advice on please.

You see we have 3 companies that use Axapta, and certain Power Users, and developers like myself switch between those companies a lot during the normal course of the day.

One of the issues we are of coursed faced with is being able to show the User, Clearly, what company they are in. Now I know the current company is displayed at the bottom right hand corner, but what we would like to do is Change the Application Title Bar Color, based on the Company you are in.

And I don't mean the Main menu, but actually change the Top Application Title bar - where it says the Name of the Application.

Has anyone had any experience with this? 

Thanks in advance!

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





Sharing the knowledge on Axapta.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



  Visit your group "Axapta-Knowledge-Village" on the web.
  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] ledgerTrans.postload

2005-08-26 Thread Harry \(Harshawardhan Deshpande



hi

be very careful with this method, you can potentially manipulate every record when it is selected from anywhere i.e. from form or from a select statement. 

regards

harry"Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote:

Hi 

Does anyone have any idea of postload() function?. what does it do?.
For example: LedgerTrans.postload(), what does it do?.

Thanks,
subbu



Start your day with Yahoo! - make it your home page __Do You Yahoo!?Tired of spam?  Yahoo! Mail has the best spam protection around http://mail.yahoo.com 





Sharing the knowledge on Axapta.





  




  
  
  YAHOO! GROUPS LINKS



  Visit your group "Axapta-Knowledge-Village" on the web.
  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] Production module!

2005-08-26 Thread jaidev004
hi EVERYONE,
In productionjournalspicking list

when i create a picing list it says posted to a journal no so and so!
now how do i view where this picking list journal is

thanks
jaidev




 Yahoo! Groups Sponsor ~-- 
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/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] caching of tables in Axapta

2005-08-26 Thread Harry \(Harshawardhan Deshpande



hi James,

wanted to try this myself but looks like it will take me a week to get around this.

if it is urgent what you can do is take advantage of the fact that

if a table as cachelookup property to 'entire table' then evenif you enable sql trace, you cannot see any sql statement (in sql statement trace log) selecting records from the particular table.

what you could do is enable sql trace, change company, select records from this table just to be sure and check sql statement trace log. This will answer your question.

regards

harry
James Flavell [EMAIL PROTECTED] wrote:



Hi 
Can anyone tell me the table protperty for 'CacheLookup' if set to EntireTable will this load all Axapta companies records or only the company I am in when I access that table?

Also if I set it up in user options the 'PreLoad' for a table deos it also load all Axapta companies or just the one I am in?

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





Sharing the knowledge on Axapta.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



  Visit your group "Axapta-Knowledge-Village" on the web.
  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] Changing App. Title Bar Color?

2005-08-26 Thread Jens Strandberg





Brandon,

I am 
sure it can be done.

I have 
seen a factsheet for a solution, where you can "color" your company accounts in 
order to distinguish. But, I have not been able to look at some code 
samles.

/Jens

  -Oprindelig meddelelse-Fra: 
  Axapta-Knowledge-Village@yahoogroups.com 
  [mailto:[EMAIL PROTECTED]P vegne af Brandon 
  GeorgeSendt: 25. august 2005 14:10Til: 
  Axapta-Knowledge-Village@yahoogroups.comEmne: 
  [Axapta-Knowledge-Village] Changing App. Title Bar Color?
  Hello All,
  
   I have a problem, that I would like some advice on 
  please.
  
  You 
  see we have 3 companies that use Axapta, and certain Power Users, and 
  developers like myself switch between those companies a lot during the normal 
  course of the day.
  
  One 
  of the issues we are of coursed faced with is being able to show the User, 
  Clearly, what company they are in. Now I know the current company is displayed 
  at the bottom right hand corner, but what we would like to do is Change the 
  Application Title Bar Color, based on the Company you are 
  in.
  
  And 
  I don't mean the Main menu, but actually change the Top Application Title bar 
  - where it says the Name of the Application.
  
  Has 
  anyone had any experience with this? 
  
  Thanks in advance!
  
  -Brandon
  





Sharing the knowledge on Axapta.





  




  
  
  YAHOO! GROUPS LINKS



  Visit your group "Axapta-Knowledge-Village" on the web.
  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] caching of tables in Axapta

2005-08-26 Thread James Flavell
Title: Message





thansk 
harry

its 
not so urgent, more a nice to know.

never 
used the sql trace tool yet and my customer going live 1st SEpt so I think it 
will be awhile before I attempt anything on this also
Thanks
James


  
  -Original Message-From: 
  Axapta-Knowledge-Village@yahoogroups.com 
  [mailto:[EMAIL PROTECTED] On Behalf Of Harry 
  (Harshawardhan DeshpandeSent: 26 August 2005 15:34To: 
  Axapta-Knowledge-Village@yahoogroups.comSubject: Re: 
  [Axapta-Knowledge-Village] caching of tables in Axapta
  hi James,
  
  wanted to try this myself but looks like it will take me a week to get 
  around this.
  
  if it is urgent what you can do is take advantage of the fact 
  that
  
  if a table as cachelookup property to 'entire table' then evenif 
  you enable sql trace, you cannot see any sql statement (in sql statement trace 
  log) selecting records from the particular table.
  
  what you could do is enable sql trace, change company, select records 
  from this table just to be sure and check sql statement trace log. This will 
  answer your question.
  
  regards
  
  harry
  James Flavell [EMAIL PROTECTED] 
  wrote:
  


Hi 

Can anyone tell me the table 
protperty for 'CacheLookup' if set to EntireTable will this load all Axapta 
companies records or only the company I am in when I access that 
table?

Also if I set it up in user options the 'PreLoad' for a table deos it 
also load all Axapta companies or just the one I am in?

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





Sharing the knowledge on Axapta.





  




  
  
  YAHOO! GROUPS LINKS



  Visit your group "Axapta-Knowledge-Village" on the web.
  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: caching of tables in Axapta

2005-08-26 Thread hwimmer
Hi James!

The records will only be loaded for the current company and only at 
first access of the table.

Best regards,
Helmut
http://axaptafreak.blogspot.com

--- In Axapta-Knowledge-Village@yahoogroups.com, James Flavell 
[EMAIL PROTECTED] wrote:
 thansk harry
  
 its not so urgent, more a nice to know.
  
 never used the sql trace tool yet and my customer going live 1st 
SEpt so I
 think it will be awhile before I attempt anything on this also
 Thanks
 James
  
 
 -Original Message-
 From: Axapta-Knowledge-Village@yahoogroups.com
 [mailto:[EMAIL PROTECTED] On Behalf Of 
Harry
 (Harshawardhan Deshpande
 Sent: 26 August 2005 15:34
 To: Axapta-Knowledge-Village@yahoogroups.com
 Subject: Re: [Axapta-Knowledge-Village] caching of tables in Axapta
 
 
 hi James,
  
 wanted to try this myself but looks like it will take me a week to 
get
 around this.
  
 if it is urgent what you can do is take advantage of the fact 
that
  
 if a table as cachelookup property to 'entire table' then even if 
you enable
 sql trace, you cannot see any sql statement (in sql statement 
trace log)
 selecting records from the particular table.
  
 what you could do is enable sql trace, change company, select 
records from
 this table just to be sure and check sql statement trace log. This 
will
 answer your question.
  
 regards
  
 harry
 
 
 James Flavell [EMAIL PROTECTED] wrote:
 
 Hi 
 
 
 Can anyone tell me the table protperty for 'CacheLookup' if set to
 EntireTable will this load all Axapta companies records or only 
the company
 I am in when I access that table?
  
 Also if I set it up in user options the 'PreLoad' for a table deos 
it also
 load all Axapta companies or just the one I am in?
  
 Thanks
 James
 
 __
 Do You Yahoo!?
 Tired of spam? Yahoo! Mail has the best spam protection around 
 http://mail.yahoo.com 
 
 Sharing the knowledge on Axapta. 
 
 
 
 
 
 SPONSORED LINKS 
 Business
 http://groups.yahoo.com/gads?
t=msk=Business+finance+coursew1=Business+fin
 
ance+coursew2=Business+to+business+financew3=Small+business+finance
w4=Bus
 
iness+finance+consultantw5=Business+finance+magazinew6=Business+fin
ance+sc
 hoolsc=6s=185.sig=I8jDsORmsaYn0BeqghcJ2w finance course 
Business
 http://groups.yahoo.com/gads?
t=msk=Business+to+business+financew1=Busines
 
s+finance+coursew2=Business+to+business+financew3=Small+business+fi
nancew
 
4=Business+finance+consultantw5=Business+finance+magazinew6=Busines
s+finan
 ce+schoolsc=6s=185.sig=fCzze7cxm1K7TVKkzAaOrA to business 
finance
 Small
 http://groups.yahoo.com/gads?
t=msk=Small+business+financew1=Business+fina
 
nce+coursew2=Business+to+business+financew3=Small+business+finance
w4=Busi
 
ness+finance+consultantw5=Business+finance+magazinew6=Business+fina
nce+sch
 oolsc=6s=185.sig=v9sWAno7Kz4WuL8Tadcdhw business finance  
 Business
 http://groups.yahoo.com/gads?
t=msk=Business+finance+consultantw1=Business
 
+finance+coursew2=Business+to+business+financew3=Small+business+fin
ancew4
 
=Business+finance+consultantw5=Business+finance+magazinew6=Business
+financ
 e+schoolsc=6s=185.sig=d1xwT3WL0E6XBf6cAV5BXA finance consultant
 Business
 http://groups.yahoo.com/gads?
t=msk=Business+finance+magazinew1=Business+f
 
inance+coursew2=Business+to+business+financew3=Small+business+finan
cew4=B
 
usiness+finance+consultantw5=Business+finance+magazinew6=Business+f
inance+
 schoolsc=6s=185.sig=qphRINaNuVm_6bwoQxgUmg finance magazine
 Business
 http://groups.yahoo.com/gads?
t=msk=Business+finance+schoolsw1=Business+fi
 
nance+coursew2=Business+to+business+financew3=Small+business+financ
ew4=Bu
 
siness+finance+consultantw5=Business+finance+magazinew6=Business+fi
nance+s
 choolsc=6s=185.sig=1RfnhYZpV99RKWRZzSH4gA finance schools 

 
   _  
 
 YAHOO! GROUPS LINKS 
 
 
   
 *  Visit your group Axapta-Knowledge-Village
 http://groups.yahoo.com/group/Axapta-Knowledge-Village  on the 
web.
   
 
 *  To unsubscribe from this group, send an email to:
  [EMAIL PROTECTED]
 mailto:[EMAIL PROTECTED]
subject=Unsubsc
 ribe 
   
 
 *  Your use of Yahoo! Groups is subject to the Yahoo! Terms of 
Service
 http://docs.yahoo.com/info/terms/ . 
 
 
   _




 Yahoo! Groups Sponsor ~-- 
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/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: caching of tables in Axapta

2005-08-26 Thread James Flavell
Thanks Helmut :)

-Original Message-
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of hwimmer
Sent: 26 August 2005 16:08
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: caching of tables in Axapta


Hi James!

The records will only be loaded for the current company and only at 
first access of the table.

Best regards,
Helmut
http://axaptafreak.blogspot.com

--- In Axapta-Knowledge-Village@yahoogroups.com, James Flavell 
[EMAIL PROTECTED] wrote:
 thansk harry
  
 its not so urgent, more a nice to know.
  
 never used the sql trace tool yet and my customer going live 1st
SEpt so I
 think it will be awhile before I attempt anything on this also Thanks
 James
  
 
 -Original Message-
 From: Axapta-Knowledge-Village@yahoogroups.com
 [mailto:[EMAIL PROTECTED] On Behalf Of
Harry
 (Harshawardhan Deshpande
 Sent: 26 August 2005 15:34
 To: Axapta-Knowledge-Village@yahoogroups.com
 Subject: Re: [Axapta-Knowledge-Village] caching of tables in Axapta
 
 
 hi James,
  
 wanted to try this myself but looks like it will take me a week to
get
 around this.
  
 if it is urgent what you can do is take advantage of the fact
that
  
 if a table as cachelookup property to 'entire table' then even if
you enable
 sql trace, you cannot see any sql statement (in sql statement
trace log)
 selecting records from the particular table.
  
 what you could do is enable sql trace, change company, select
records from
 this table just to be sure and check sql statement trace log. This
will
 answer your question.
  
 regards
  
 harry
 
 
 James Flavell [EMAIL PROTECTED] wrote:
 
 Hi
 
 
 Can anyone tell me the table protperty for 'CacheLookup' if set to 
 EntireTable will this load all Axapta companies records or only
the company
 I am in when I access that table?
  
 Also if I set it up in user options the 'PreLoad' for a table deos
it also
 load all Axapta companies or just the one I am in?
  
 Thanks
 James
 
 __
 Do You Yahoo!?
 Tired of spam? Yahoo! Mail has the best spam protection around
 http://mail.yahoo.com 
 
 Sharing the knowledge on Axapta.
 
 
 
 
 
 SPONSORED LINKS
 Business
 http://groups.yahoo.com/gads?
t=msk=Business+finance+coursew1=Business+fin
 
ance+coursew2=Business+to+business+financew3=Small+business+finance
w4=Bus
 
iness+finance+consultantw5=Business+finance+magazinew6=Business+fin
ance+sc
 hoolsc=6s=185.sig=I8jDsORmsaYn0BeqghcJ2w finance course
Business
 http://groups.yahoo.com/gads?
t=msk=Business+to+business+financew1=Busines
 
s+finance+coursew2=Business+to+business+financew3=Small+business+fi
nancew
 
4=Business+finance+consultantw5=Business+finance+magazinew6=Busines
s+finan
 ce+schoolsc=6s=185.sig=fCzze7cxm1K7TVKkzAaOrA to business
finance
 Small
 http://groups.yahoo.com/gads?
t=msk=Small+business+financew1=Business+fina
 
nce+coursew2=Business+to+business+financew3=Small+business+finance
w4=Busi
 
ness+finance+consultantw5=Business+finance+magazinew6=Business+fina
nce+sch
 oolsc=6s=185.sig=v9sWAno7Kz4WuL8Tadcdhw business finance  
 Business
 http://groups.yahoo.com/gads?
t=msk=Business+finance+consultantw1=Business
 
+finance+coursew2=Business+to+business+financew3=Small+business+fin
ancew4
 
=Business+finance+consultantw5=Business+finance+magazinew6=Business
+financ
 e+schoolsc=6s=185.sig=d1xwT3WL0E6XBf6cAV5BXA finance consultant
 Business
 http://groups.yahoo.com/gads?
t=msk=Business+finance+magazinew1=Business+f
 
inance+coursew2=Business+to+business+financew3=Small+business+finan
cew4=B
 
usiness+finance+consultantw5=Business+finance+magazinew6=Business+f
inance+
 schoolsc=6s=185.sig=qphRINaNuVm_6bwoQxgUmg finance magazine 
 Business http://groups.yahoo.com/gads?
t=msk=Business+finance+schoolsw1=Business+fi
 
nance+coursew2=Business+to+business+financew3=Small+business+financ
ew4=Bu
 
siness+finance+consultantw5=Business+finance+magazinew6=Business+fi
nance+s
 choolsc=6s=185.sig=1RfnhYZpV99RKWRZzSH4gA finance schools

 
   _
 
 YAHOO! GROUPS LINKS
 
 
   
 *  Visit your group Axapta-Knowledge-Village
 http://groups.yahoo.com/group/Axapta-Knowledge-Village  on the
web.
   
 
 *  To unsubscribe from this group, send an email to:
  [EMAIL PROTECTED]
 mailto:[EMAIL PROTECTED]
subject=Unsubsc
 ribe 
   
 
 *  Your use of Yahoo! Groups is subject to the Yahoo! Terms of 
Service
 http://docs.yahoo.com/info/terms/ .
 
 
   _





Sharing the knowledge on Axapta. 
Yahoo! Groups Links



 




 Yahoo! Groups Sponsor ~-- 
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/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 

RE: [Axapta-Knowledge-Village] caching of tables in Axapta

2005-08-26 Thread Harry \(Harshawardhan Deshpande



hi James

hi SQL tool is very important. After a modification is complete, a programmer/tester should enable this tool and run through the modificationto seeif any warning messages are displyed like missing indexes etc. I would say most of the time, it will catch problems.

regards

harryJames Flavell [EMAIL PROTECTED] wrote:


thansk harry

its not so urgent, more a nice to know.

never used the sql trace tool yet and my customer going live 1st SEpt so I think it will be awhile before I attempt anything on this also
Thanks
James



-Original Message-From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Harry (Harshawardhan DeshpandeSent: 26 August 2005 15:34To: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] caching of tables in Axapta
hi James,

wanted to try this myself but looks like it will take me a week to get around this.

if it is urgent what you can do is take advantage of the fact that

if a table as cachelookup property to 'entire table' then evenif you enable sql trace, you cannot see any sql statement (in sql statement trace log) selecting records from the particular table.

what you could do is enable sql trace, change company, select records from this table just to be sure and check sql statement trace log. This will answer your question.

regards

harry
James Flavell [EMAIL PROTECTED] wrote:



Hi 
Can anyone tell me the table protperty for 'CacheLookup' if set to EntireTable will this load all Axapta companies records or only the company I am in when I access that table?

Also if I set it up in user options the 'PreLoad' for a table deos it also load all Axapta companies or just the one I am in?

Thanks
James
__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com 
		 Start your day with Yahoo! - make it your home page 





Sharing the knowledge on Axapta.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



  Visit your group "Axapta-Knowledge-Village" on the web.
  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] ctrl+ f or find crashes axapta

2005-08-26 Thread Sonny Wibawa Adi
Hi Ed Tarnovsky,


Does your modified form have a control that use
display method to get the data?

If so, Is that control's Mandatory property set to
Yes?

If so, then set that control's Mandatory property to
No.

I was experiencing that problem before and solved by
using above steps.

If not, then try to simplified the problem by deleting
some controls, until it doesn't crash. Then check the
deleted controls to find the cause of the crash.

Good luck.


Best regards,


Sonny Wibawa Adi, MBSCP, MCSD.NET, MCAD.NET

--- Ed Tarnovsky [EMAIL PROTECTED] wrote:

 I have a custom form. When the form is loaded from
 the main menu and you try to do search on the grid
 with ctrl+ f or right click find it crashes whole
 axapta env.
 But when this form is open and the search is
 performed on the other (any) from , then you can
 perfom finds on my form without any problems.
 when i debugged it looks like it crashes in lower
 layers when it is trying to call formNotify method
 .
 help
 thanks
 
 
 
 __
 Do You Yahoo!?
 Tired of spam?  Yahoo! Mail has the best spam
 protection around 
 http://mail.yahoo.com 





Start your day with Yahoo! - make it your home page 
http://www.yahoo.com/r/hs 
 


 Yahoo! Groups Sponsor ~-- 
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/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] Picking list created when no onhand stock was available

2005-08-26 Thread Girish Bhatkal
Hi everybody,

The following is the scenario:

  The picking lists are generated from salesLedger/
periodic/Sales Update/ picking list

on the Item stock model group the following are set:
Physical negative stock - not active
Financial negative stock - active
Registration requirements - active
picking requirements - not active

the client said that a pick list was printed this
morning even when the stock was not available.

   i tried to post another picking list for the same
line  but i could not as i got the expected error that
no stock was available. 

But when i got to salesorder/ posting/ picking list
registration i can see the picking list posted, today
, with this item (with a particular batch, warehouse
and location) which does not have any onhand stock.

 when i see the transactions i see that the stock
avaiable was deducted yesterday and hence i believe
there was never any stock today.

   had anyone seen this problem earlier and can any
one tell what could be the condition when the picking
list was created.

This had happened earlier too. i would appreciate
any thoughts on this issue.

cheers,
GIrish



___ 
To help you stay safe and secure online, we've developed the all new Yahoo! 
Security Centre. http://uk.security.yahoo.com


 Yahoo! Groups Sponsor ~-- 
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/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] Error sending e-mail automatically in axapta

2005-08-26 Thread Melih Demir










Hi all,



While sending e-mail automatically in axapta, SmtpServer
doesnt recognize the e-mail address given outside the domain. Only sends
to an e-mail account in the domain. But we can send e-mail to outside the domain
normally from outlook.



The error is : RCPT command failed. The specified account
doesnt exist.



What can be the problem? How to solve that?



Thanks,

Melih.









Sharing the knowledge on Axapta.





  




  
  
  YAHOO! GROUPS LINKS



  Visit your group "Axapta-Knowledge-Village" on the web.
  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] Error sending e-mail automatically in axapta

2005-08-26 Thread Malcolm Burtt





Hi

It sounds like the SMTP server that youhave 
configured SysMailer to use hasn't been set up to forward mail outside of your 
organisation. You can verify this by bypassing Axapta and making a test email 
directly to theSMTP server yourself to see what happens. To do this get to 
a Windows command prompt and type the following


  telnet smtpserverAddress 25
  HELOyourComputerName
  MAIL FROM:yourEmailAddress
  RCPT TO:externalEmailAddress
  DATA
  Text of your simple email 
message
  .
  QUIT
So, for example, you might type


  telnet 192.168.1.99 25
  HELO melihpc1
  MAIL FROM:[EMAIL PROTECTED]
  RCPT TO:[EMAIL PROTECTED]
  DATA
  Hi Bill
  .
  QUIT
You won't see any of what you type after the telnet 
command, so be careful as you enter the text.

My guess is that you will get an error from the mail 
serverafter you enter the RCP TO: line saying that it cannot route to that 
address. The message should give you a clue as to why. Mail servers are often 
configured to block relaying (which is what you are trying to do here) except 
for a known list of client machines, so if the computer that is making the SMTP 
connection isn't one of those known machines the message will be blocked. That 
could be what is happening to you.

Hope that gives you some help

Malcolm Burtt


From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:[EMAIL PROTECTED] On Behalf Of Melih 
DemirSent: 26 August 2005 13:09To: 
Axapta-Knowledge-Village@yahoogroups.com; 
development-axapta@yahoogroups.comSubject: [Axapta-Knowledge-Village] 
Error sending e-mail automatically in axapta


Hi all,

While sending e-mail automatically 
in axapta, SmtpServer doesnt recognize the e-mail address given outside the 
domain. Only sends to an e-mail account in the domain. But we can send e-mail to 
outside the domain normally from outlook.

The error is : RCPT command failed. 
The specified account doesnt exist.

What can be the problem? How to 
solve that?

Thanks,
Melih.





Sharing the knowledge on Axapta.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



  Visit your group "Axapta-Knowledge-Village" on the web.
  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] ledgerTrans.postload

2005-08-26 Thread Subrahmanyam, Mamidi



Hi harry,

We need to roundoff the LedgetTrans's amountMST and AmountCUR. hence I did this way. It works for me since I could round off them while reading/loading the records. I tested properly in the local axapta with the demo data. 


Thank you for the input.

Regards,
subbu"Harry (Harshawardhan Deshpande" [EMAIL PROTECTED] wrote:

hi

be very careful with this method, you can potentially manipulate every record when it is selected from anywhere i.e. from form or from a select statement. 

regards

harry"Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote:

Hi 

Does anyone have any idea of postload() function?. what does it do?.
For example: LedgerTrans.postload(), what does it do?.

Thanks,
subbu



Start your day with Yahoo! - make it your home page 
__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com 
		Do you Yahoo!? 
Yahoo! Mail - Find what you need with new enhanced search. Learn more.





Sharing the knowledge on Axapta.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



  Visit your group "Axapta-Knowledge-Village" on the web.
  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] ledgerTrans.postload

2005-08-26 Thread Harry \(Harshawardhan Deshpande



hi Subbu

Demo data is never same as live data and testing is never enough. I just thought that you have enough problems right now and not add one more to the list of problems*s*

regards

harry"Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote:

Hi harry,

We need to roundoff the LedgetTrans's amountMST and AmountCUR. hence I did this way. It works for me since I could round off them while reading/loading the records. I tested properly in the local axapta with the demo data. 


Thank you for the input.

Regards,
subbu"Harry (Harshawardhan Deshpande" [EMAIL PROTECTED] wrote:

hi

be very careful with this method, you can potentially manipulate every record when it is selected from anywhere i.e. from form or from a select statement. 

regards

harry"Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote:

Hi 

Does anyone have any idea of postload() function?. what does it do?.
For example: LedgerTrans.postload(), what does it do?.

Thanks,
subbu



Start your day with Yahoo! - make it your home page 
__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com 


Do you Yahoo!?Yahoo! Mail - Find what you need with new enhanced search. Learn more. 
		 Start your day with Yahoo! - make it your home page 





Sharing the knowledge on Axapta.





  




  
  
  YAHOO! GROUPS LINKS



  Visit your group "Axapta-Knowledge-Village" on the web.
  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] ledgerTrans.postload

2005-08-26 Thread Subrahmanyam, Mamidi



:D. Thank you for the headsup and scaring me :))

Is there any solution there with you so that I can round off all the existing LedgerTrans Records's AmountCUR and AmountMST to 2 digits?.

Presently I did it in DEV environment after I tested in demo installation.

I moved this piece of code to QA Environment for user testing in a company of copy pf production as of yesterday


PostLoad is already overridden there in LedgerTrans, so I just my 2 lines of code there.

Is there any better solution there for rounding off the the exisitng records?. 

Problem is many people wrote the code and are no longer onsite now. You know when a ticket comes, onsite guy has to act :((. 

So is there any solution or idea you have which can round off to 2 decimals?. 

Appreciate the help.
Thanks  Regards,
subbu
"Harry (Harshawardhan Deshpande" [EMAIL PROTECTED] wrote:

hi Subbu

Demo data is never same as live data and testing is never enough. I just thought that you have enough problems right now and not add one more to the list of problems*s*

regards

harry"Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote:

Hi harry,

We need to roundoff the LedgetTrans's amountMST and AmountCUR. hence I did this way. It works for me since I could round off them while reading/loading the records. I tested properly in the local axapta with the demo data. 


Thank you for the input.

Regards,
subbu"Harry (Harshawardhan Deshpande" [EMAIL PROTECTED] wrote:

hi

be very careful with this method, you can potentially manipulate every record when it is selected from anywhere i.e. from form or from a select statement. 

regards

harry"Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote:

Hi 

Does anyone have any idea of postload() function?. what does it do?.
For example: LedgerTrans.postload(), what does it do?.

Thanks,
subbu



Start your day with Yahoo! - make it your home page 
__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com 


Do you Yahoo!?Yahoo! Mail - Find what you need with new enhanced search. Learn more. 


Start your day with Yahoo! - make it your home page 
		 Start your day with Yahoo! - make it your home page 





Sharing the knowledge on Axapta.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



  Visit your group "Axapta-Knowledge-Village" on the web.
  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][development-axapta] Crystal Reports and Axapta?

2005-08-26 Thread Brandon George





Maurice,

Do you have any examples, or any suggestions you 
could point out to me. Do you think you could get a simple example, or maybe 
some information of where they replaced an Axapta Report with a Crystal Report - 
Report?

thanks,
Brandon


From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:[EMAIL PROTECTED] On Behalf Of Maurice 
CohenSent: Friday, August 26, 2005 2:47 PMTo: 
Axapta-Knowledge-Village@yahoogroups.comSubject: RE: 
[Axapta-Knowledge-Village][development-axapta] Crystal Reports and 
Axapta?


Hi 
Brandon,

One of customer is 
using Crystal 
reports with Axapta and is pretty happy with it. I have never used it myself so 
I can only rely on their feedback.

Maurice 
Cohen
Senior 
consultant

Advanced Systems 
Integration, Inc.
26449 Rancho Parkway 
South
Lake 
Forest, CA 92630
ph: 
949-597-2170
fax: 
949-597-0720
cell: 
949-533-5966




From: 
Axapta-Knowledge-Village@yahoogroups.com 
[mailto:Axapta-Knowledge-Village@yahoogroups.com] On Behalf Of Brandon GeorgeSent: Friday, August 26, 2005 11:37 
AMTo: Axapta-Knowledge-Village@yahoogroups.com; 
development-axapta@yahoogroups.comSubject: 
[Axapta-Knowledge-Village][development-axapta] Crystal Reports and 
Axapta?

Hello 
Everyone,

I have some more 
advice that I need.

Ok we are getting sick 
of using the clunky Axapta Report Designer. So we are investigating how easy it 
is just to scrap the Axapta Reports, and do all reports in Crystal 
Reports?

Has anyone ever done 
this before? Does anyone have any examples of using Crystal Reports and Axapta? 
Does anyone have any experience at doing such a 
thing?

thanks in Advance, in 
advise on this - either it's bad or good, or examples, any input at all please 
give it!

thanks,
Brandon






Sharing the knowledge on Axapta.





  




  
  
  YAHOO! GROUPS LINKS



  Visit your group "Axapta-Knowledge-Village" on the web.
  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][development-axapta] Crystal Reports and Axapta?

2005-08-26 Thread Kevin Krieger






We are on Axapta 2.5 and use Crystal for anything other 
then the "Vanilla" reports contained in Axapta. I've recently updated to Crystal 
XI which is server based and web accessible, so now my users can access any of 
my reports from inside the enterprise or via the Internet. Report development, 
if you know Crystal, is pretty straight forward, you really just need a 
understanding of Axapta's table's and fields for content. The rest, at least in 
Crystal Developer 11 is drag and drop. Let me know if you need more 
info.

Kevin S KriegerInformation Systems ManagerSubaru 
Industrial EnginesRobin America, Inc.Fuji Heavy Industries Ltd940 
Lively BlvdWood Dale IL 60191 USA630-350-8200 / 630-350-8212 
Fax[EMAIL PROTECTED]http://www.subarupower.com





From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:[EMAIL PROTECTED] On Behalf Of Brandon 
GeorgeSent: Friday, August 26, 2005 1:44 PMTo: 
Axapta-Knowledge-Village@yahoogroups.comSubject: RE: 
[Axapta-Knowledge-Village][development-axapta] Crystal Reports and 
Axapta?

Maurice,

Do you have any examples, or any suggestions you 
could point out to me. Do you think you could get a simple example, or maybe 
some information of where they replaced an Axapta Report with a Crystal Report - 
Report?

thanks,
Brandon


From: Axapta-Knowledge-Village@yahoogroups.com 
[mailto:[EMAIL PROTECTED] On Behalf Of Maurice 
CohenSent: Friday, August 26, 2005 2:47 PMTo: 
Axapta-Knowledge-Village@yahoogroups.comSubject: RE: 
[Axapta-Knowledge-Village][development-axapta] Crystal Reports and 
Axapta?


Hi 
Brandon,

One of customer is 
using Crystal reports with Axapta and is 
pretty happy with it. I have never used it myself so I can only rely on their 
feedback.

Maurice 
Cohen
Senior 
consultant

Advanced Systems 
Integration, Inc.
26449 Rancho Parkway 
South
Lake 
Forest, CA 92630
ph: 
949-597-2170
fax: 
949-597-0720
cell: 
949-533-5966




From: 
Axapta-Knowledge-Village@yahoogroups.com 
[mailto:Axapta-Knowledge-Village@yahoogroups.com] 
On Behalf Of Brandon 
GeorgeSent: Friday, August 26, 
2005 11:37 AMTo: 
Axapta-Knowledge-Village@yahoogroups.com; 
development-axapta@yahoogroups.comSubject: 
[Axapta-Knowledge-Village][development-axapta] Crystal Reports and 
Axapta?

Hello 
Everyone,

I have some more 
advice that I need.

Ok we are getting sick 
of using the clunky Axapta Report Designer. So we are investigating how easy it 
is just to scrap the Axapta Reports, and do all reports in Crystal 
Reports?

Has anyone ever done 
this before? Does anyone have any examples of using Crystal Reports and Axapta? 
Does anyone have any experience at doing such a 
thing?

thanks in Advance, in 
advise on this - either it's bad or good, or examples, any input at all please 
give it!

thanks,
Brandon






Sharing the knowledge on Axapta.





  




  
  
  YAHOO! GROUPS LINKS



  Visit your group "Axapta-Knowledge-Village" on the web.
  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][development-axapta] Crystal Reports and Axapta?

2005-08-26 Thread Maurice Cohen










I will as them and get back to you on
Monday



Maurice
 Cohen

Senior consultant



Advanced Systems
Integration, Inc.

26449 Rancho Parkway South

Lake Forest, CA 92630

ph:
949-597-2170

fax:
949-597-0720

cell: 949-533-5966











From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com] On Behalf Of Brandon George
Sent: Friday, August 26, 2005
11:44 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE:
[Axapta-Knowledge-Village][development-axapta] Crystal Reports and Axapta?





Maurice,



Do you have any examples, or any
suggestions you could point out to me. Do you think you could get a simple
example, or maybe some information of where they replaced an Axapta Report with
a Crystal Report - Report?



thanks,

Brandon









From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com] On Behalf Of Maurice
 Cohen
Sent: Friday, August 26, 2005 2:47
PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE:
[Axapta-Knowledge-Village][development-axapta] Crystal Reports and Axapta?

Hi Brandon,



One of customer is using Crystal reports with Axapta and is pretty
happy with it. I have never used it myself so I can only rely on their
feedback.



Maurice
 Cohen

Senior consultant



Advanced Systems
Integration, Inc.

26449 Rancho Parkway South

Lake Forest, CA 92630

ph:
949-597-2170

fax:
949-597-0720

cell: 949-533-5966











From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com] On Behalf Of Brandon George
Sent: Friday, August 26, 2005
11:37 AM
To: Axapta-Knowledge-Village@yahoogroups.com;
development-axapta@yahoogroups.com
Subject:
[Axapta-Knowledge-Village][development-axapta] Crystal Reports and Axapta?





Hello Everyone,



I have some more advice that I need.



Ok we are getting sick of using the clunky
Axapta Report Designer. So we are investigating how easy it is just to scrap
the Axapta Reports, and do all reports in Crystal Reports?



Has anyone ever done this before? Does
anyone have any examples of using Crystal Reports and Axapta? Does anyone have
any experience at doing such a thing?



thanks in Advance, in advise on this -
either it's bad or good, or examples, any input at all please give it!



thanks,

Brandon











Sharing the knowledge on Axapta.





  




  
  
  YAHOO! GROUPS LINKS



  Visit your group "Axapta-Knowledge-Village" on the web.
  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][development-axapta] Crystal Reports and Axapta?

2005-08-26 Thread Christoph Malherbe










Hi Brandon,



Ive not deployed Crystal Reports on
top of an Axapta database but Ive done it on Great
 Plains, Accpac and a few other systems for exactly the same reason.
The principle is identical. 



It works well . But you do need to
be careful because it isnt all plain sailing. The following is a list of
issues that my co-workers(current and former) and I have come across. Its
not meant to be exhaustive.


 design
 of the queries used to feed Crystal
 with data becomes critical, especially when dealing with large databases
 and joining multiple tables
 a
 sound comprehension of the relationship between the tables is critical if
 you dont want to provide your customer with garbage
 a
 sound comprehension of the impact that your query has on the database and
 server is important if you dont want to cripple them when the
 report is run
 impact
 of uncommitted SQL transactions on your querys execution and integrity




I hope this helps.



Regards,



Christoph Malherbe











From:
Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin Krieger
Sent: 26 August 2005 09:09 PM
To:
Axapta-Knowledge-Village@yahoogroups.com
Subject: RE:
[Axapta-Knowledge-Village][development-axapta] Crystal Reports and Axapta?





We are on Axapta 2.5 and
use Crystal for
anything other then the Vanilla reports contained in Axapta. I've
recently updated to Crystal XI which is server based and web accessible, so now
my users can access any of my reports from inside the enterprise or via the
Internet. Report development, if you know Crystal,
is pretty straight forward, you really just need a understanding of Axapta's
table's and fields for content. The rest, at least in Crystal Developer 11 is
drag and drop. Let me know if you need more info.









Kevin
S Krieger
Information Systems Manager
Subaru Industrial Engines
Robin America, Inc.
Fuji Heavy Industries Ltd
940 Lively Blvd
Wood Dale IL 60191 USA
630-350-8200 / 630-350-8212 Fax
[EMAIL PROTECTED]
http://www.subarupower.com
























From:
Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Brandon George
Sent: Friday, August 26, 2005 1:44
PM
To:
Axapta-Knowledge-Village@yahoogroups.com
Subject: RE:
[Axapta-Knowledge-Village][development-axapta] Crystal Reports and Axapta?

Maurice,



Do you have any
examples, or any suggestions you could point out to me. Do you think you could
get a simple example, or maybe some information of where they replaced an
Axapta Report with a Crystal Report - Report?



thanks,

Brandon









From:
Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Maurice Cohen
Sent: Friday, August 26, 2005 2:47
PM
To:
Axapta-Knowledge-Village@yahoogroups.com
Subject: RE:
[Axapta-Knowledge-Village][development-axapta] Crystal Reports and Axapta?

Hi Brandon,



One of customer is using Crystal reports with Axapta and
is pretty happy with it. I have never used it myself so I can only rely on
their feedback.



Maurice Cohen

Senior consultant



Advanced
Systems Integration, Inc.

26449 Rancho
  Parkway South

Lake Forest, CA 92630

ph:
949-597-2170

fax:
949-597-0720

cell:
949-533-5966











From:
Axapta-Knowledge-Village@yahoogroups.com
[mailto:Axapta-Knowledge-Village@yahoogroups.com]
On Behalf Of Brandon George
Sent: Friday, August 26, 2005
11:37 AM
To: Axapta-Knowledge-Village@yahoogroups.com;
development-axapta@yahoogroups.com
Subject:
[Axapta-Knowledge-Village][development-axapta] Crystal Reports and Axapta?





Hello Everyone,



I have some more
advice that I need.



Ok we are getting sick of
using the clunky Axapta Report Designer. So we are investigating how easy it is
just to scrap the Axapta Reports, and do all reports in Crystal Reports?



Has anyone ever done this
before? Does anyone have any examples of using Crystal Reports and Axapta? Does
anyone have any experience at doing such a thing?



thanks in Advance, in
advise on this - either it's bad or good, or examples, any input at all please
give it!



thanks,

Brandon











Sharing the knowledge on Axapta.





  




  
  
  YAHOO! GROUPS LINKS



  Visit your group "Axapta-Knowledge-Village" on the web.
  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] Urgent : Problem in Select count(RecId)

2005-08-26 Thread Subrahmanyam, Mamidi



Hi,

Today I have a P1 ticket saying that consolidation is not picking up all the transaction for just one company out of 8 export companies. They are all regular trasactions in LedgerTrans.

I debugged LedgerConsolidate class and found an interesting issue after debugging in 'sumupTransact';


Select count(recid) from LedgerTable where LedgerTable.AccountNum != '';
 LedgerTable.recid = 125 records ( these only exported )

but interestingly if I change it to


Select count(recid) from LedgerTable where LedgerTable.AccountName != '';
LedgerTable.recid = 975 records.

I felt I got fever for a moment.

I reindexed the company when no one is there in the system. still I am getting 125 only. 

This sucks me now.

Any idea why it happended?. I cleared all the cache for this company.

Looks like I have a bad week end.

help pls
thanks,
subbu




		Yahoo! Mail for Mobile 
Take Yahoo! Mail with you! Check email on your mobile phone.





Sharing the knowledge on Axapta.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



  Visit your group "Axapta-Knowledge-Village" on the web.
  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] Urgent : Problem in Select count(RecId)

2005-08-26 Thread Subrahmanyam, Mamidi



When I set the table 'cachelookup prorty ' to 'none', I get the same orignal results which is 975 which is good.

But...it sucks.

I could not solve the problem. But I set temporarily the 'cahchelookupproperty in 'ledgerTable' to none for time being so that I can bring in all the regular transactions in consolidation.

"Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote:

Hi,

Today I have a P1 ticket saying that consolidation is not picking up all the transaction for just one company out of 8 export companies. They are all regular trasactions in LedgerTrans.

I debugged LedgerConsolidate class and found an interesting issue after debugging in 'sumupTransact';


Select count(recid) from LedgerTable where LedgerTable.AccountNum != '';
 LedgerTable.recid = 125 records ( these only exported )

but interestingly if I change it to


Select count(recid) from LedgerTable where LedgerTable.AccountName != '';
LedgerTable.recid = 975 records.

I felt I got fever for a moment.

I reindexed the company when no one is there in the system. still I am getting 125 only. 

This sucks me now.

Any idea why it happended?. I cleared all the cache for this company.

Looks like I have a bad week end.

help pls
thanks,
subbu






Yahoo! Mail for MobileTake Yahoo! Mail with you! Check email on your mobile phone. __Do You Yahoo!?Tired of spam?  Yahoo! Mail has the best spam protection around http://mail.yahoo.com 





Sharing the knowledge on Axapta.





  




  
  
  YAHOO! GROUPS LINKS



  Visit your group "Axapta-Knowledge-Village" on the web.
  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] Urgent : Problem in Select count(RecId)

2005-08-26 Thread Subrahmanyam, Mamidi



Hi

I did,

Flush LedgerTable; - No luck

Tools - refresh AOD and Refresh usage , but no luck.

So I suspect the problem is on AOS. So I am going to flush there also to see if it solves my problem. This is problem with 3 tier.

Anyway, thanks . I am replying to my self :D

subbu

"Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote:

When I set the table 'cachelookup prorty ' to 'none', I get the same orignal results which is 975 which is good.

But...it sucks.

I could not solve the problem. But I set temporarily the 'cahchelookupproperty in 'ledgerTable' to none for time being so that I can bring in all the regular transactions in consolidation.

"Subrahmanyam, Mamidi" [EMAIL PROTECTED] wrote:

Hi,

Today I have a P1 ticket saying that consolidation is not picking up all the transaction for just one company out of 8 export companies. They are all regular trasactions in LedgerTrans.

I debugged LedgerConsolidate class and found an interesting issue after debugging in 'sumupTransact';


Select count(recid) from LedgerTable where LedgerTable.AccountNum != '';
 LedgerTable.recid = 125 records ( these only exported )

but interestingly if I change it to


Select count(recid) from LedgerTable where LedgerTable.AccountName != '';
LedgerTable.recid = 975 records.

I felt I got fever for a moment.

I reindexed the company when no one is there in the system. still I am getting 125 only. 

This sucks me now.

Any idea why it happended?. I cleared all the cache for this company.

Looks like I have a bad week end.

help pls
thanks,
subbu






Yahoo! Mail for MobileTake Yahoo! Mail with you! Check email on your mobile phone. 
__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com 
		Do you Yahoo!? 
Yahoo! Mail - You care about security. So do we.





Sharing the knowledge on Axapta.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



  Visit your group "Axapta-Knowledge-Village" on the web.
  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] Urgent : Problem in Select count(RecId)

2005-08-26 Thread James Flavell
Title: Message





I 
believe there was a 'urgent' hotfix for consolidation by MBS (cannot remember 
which version ...I think SP4 but I guess the problem might be there in earlier 
versions)

James


  
  -Original Message-From: 
  Axapta-Knowledge-Village@yahoogroups.com 
  [mailto:[EMAIL PROTECTED] On Behalf Of 
  Subrahmanyam, MamidiSent: 27 August 2005 11:48To: 
  Axapta-Knowledge-Village@yahoogroups.comSubject: Re: 
  [Axapta-Knowledge-Village] Urgent : Problem in Select 
  count(RecId)
  When I set the table 'cachelookup prorty ' to 'none', I get the 
  same orignal results which is 975 which is good.
  
  But...it sucks.
  
  I could not solve the problem. But I set temporarily the 
  'cahchelookupproperty in 'ledgerTable' to none for time being so that I can 
  bring in all the regular transactions in consolidation.
  
  "Subrahmanyam, Mamidi" [EMAIL PROTECTED] 
  wrote:
  
Hi,

Today I have a P1 ticket saying that consolidation is not picking up 
all the transaction for just one company out of 8 export companies. They are 
all regular trasactions in LedgerTrans.

I debugged LedgerConsolidate class and found an interesting issue after 
debugging in 'sumupTransact';


Select count(recid) from LedgerTable where LedgerTable.AccountNum != 
'';
 LedgerTable.recid = 125 records ( these only exported 
)

but interestingly if I change it to


Select count(recid) from LedgerTable where LedgerTable.AccountName 
!= '';
LedgerTable.recid = 975 records.

I felt I got fever for a moment.

I reindexed the company when no one is there in the system. still I am 
getting 125 only. 

This sucks me now.

Any idea why it happended?. I cleared all the cache for this 
company.

Looks like I have a bad week end.

help pls
thanks,
subbu






Yahoo! Mail for MobileTake 
Yahoo! Mail with you! Check email on your mobile phone. 
  __Do You 
  Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around 
  http://mail.yahoo.com 
  





Sharing the knowledge on Axapta.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



  Visit your group "Axapta-Knowledge-Village" on the web.
  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][development-axapta] Crystal Reports and Axapta?

2005-08-26 Thread Brandon George





Hello Everyone,

I have some more advice that I 
need.

Ok we are getting sick of using the clunky Axapta Report 
Designer. So we are investigating how easy it is just to scrap the Axapta 
Reports, and do all reports in Crystal Reports?

Has anyone ever done this before? Does anyone have any 
examples of using Crystal Reports and Axapta? Does anyone have any experience at 
doing such a thing?

thanks in Advance, in advise on this - either it's bad or 
good, or examples, any input at all please give it!

thanks,
Brandon





Sharing the knowledge on Axapta.








  
  
SPONSORED LINKS
  
  
  

Business finance course
  
  
Business to business finance
  
  
Small business finance
  
  


Business finance consultant
  
  
Business finance magazine
  
  
Business finance schools
  
  

   
  







  
  
  YAHOO! GROUPS LINKS



  Visit your group "Axapta-Knowledge-Village" on the web.
  To unsubscribe from this group, send an email to:[EMAIL PROTECTED]
  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.