[development-axapta] Print To Screen

2005-06-08 Thread Nancy L Hall




I am unable to print the Check Layout to screen. Bank,
Bank Accounts, Select Bank Account, Set Up, Check
Layout, Print Test button. My Sent To box is grayed
out and the test will only print to the printer not to
screen. I am able to print all other Axapta Reports to
screen or what ever I choose. 

Has anyone else experienced this and how did you fix
it.

Thanks for your help. 



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












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

2005-06-08 Thread Hemant Kumthekar




Hi ,
 
We have a requirement may be a special and peculiar too. We would like to consolidate all the Open Invoices for a customer and create one Invoice with total amount equal to the sum of the invoices selected for consolidation. I am trying to look into the possibilities by writting a code to do this automatically. I had identified that there are tables like CustOpenTrans which can be used to display the Invoices on a form , then use the filter selection for customer code , Invoice date range , Payterm code to filter the invoices. The form will allow to mark the invoices to be consolidated and then have a menu button which will execute the consolidation routine.
 
 I don't know how should I go ahead with reversing the existing Invoices and creating a consolidated invoice. The thing to remember here is that we are not posting a Cash Payment against the invoices which are to be consolidated and this is to be done using X++ code. 
 
I highly appreciate responses and ideas from the forum/group. This is a typical requirement for a customer who deals in Finance and Leasing types aprat from a Sales and Distribution.
 
Regards,
 
HK

  
-
Discover Yahoo!
 Have fun online with music videos, cool games, IM  more. Check it out!

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












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] Need Axapta Development Training guide

2005-06-08 Thread Vikas Garg




Hello Axpata ppl,

My self Vikas Garg. I just started with Axapta Development, But the
problem here is that i don't have enough material to study Axapta
development and training. Please send the softcopy of any good
document that can help me to learn Axapta (if possible a step by step
guide for the development of Axapta objects like forms, reports,
query, tables etc). I am hopeful to get good response and material
from all you great Axapta masters..

Thanks for your time.

Vikas Garg















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] Inventory amount adjustment some warehouse not shown ???

2005-06-08 Thread SAS




Dear all,
we want to do on hand amount adjustment on an item number , if we check on 
ON Hand inventory , there are several warehouse over there , but when we 
wanna do on hand amount inventory adjustment  we saw the warehouse number 
is less then on on hand inventory .
( suppose if check on hand inventory , there are warehouse a1,a2,a3 but when 
we will do on hand amount adjustment only warehouse a1 and a2 over there ).
do you have any idea how we can show all warehouse ?
thx
sas














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] Substring in query

2005-06-08 Thread dadan_kasep_2




I have problem with substring in query like :

 while select MyLedgerJournalTrans
 where substr(MyLedgerJournalTrans.Txt,1,3) == '123'

Does anyone have any suggestions to solve this?

thank's
Regards

Dadan s














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] Inventory amount adjustment some warehouse not shown ???

2005-06-08 Thread James Flavell




I think on hand adjustment is only based on the on hand at last inventory
closing so probably do an invnetory closing up to the current date and you
should see the same warehouses...I think, let us know if this is the case
 
cheers
 

-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of SAS
Sent: 08 June 2005 18:54
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Inventory amount adjustment some warehouse not
shown ???


Dear all,
we want to do on hand amount adjustment on an item number , if we check on 
ON Hand inventory , there are several warehouse over there , but when we 
wanna do on hand amount inventory adjustment  we saw the warehouse number 
is less then on on hand inventory .
( suppose if check on hand inventory , there are warehouse a1,a2,a3 but when

we will do on hand amount adjustment only warehouse a1 and a2 over there ).
do you have any idea how we can show all warehouse ?
thx
sas







 _ 

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]
mailto:[EMAIL PROTECTED] 
 

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
http://docs.yahoo.com/info/terms/ . 




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













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] Substring in query

2005-06-08 Thread Thomas Jensen




Try

while select MyLedgerJournalTrans
 where MyLedgerJournalTrans.Txt like '123*'


Regards
Thomas

-Oprindelig meddelelse-
Fra: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] På vegne af dadan_kasep_2
Sendt: 8. juni 2005 06:50
Til: development-axapta@yahoogroups.com
Emne: [development-axapta] Substring in query

I have problem with substring in query like :

 while select MyLedgerJournalTrans
 where substr(MyLedgerJournalTrans.Txt,1,3) == '123'

Does anyone have any suggestions to solve this?

thank's
Regards

Dadan s







 
Yahoo! Groups Links



 














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] Substring in query

2005-06-08 Thread axapta developer




hi Dadan,
 
Perhaps you could try working around it:
 
while select * from MyLedgerJournalTrans
{
 if(substr(MyLedgerJournalTrans.Txt,1,3) == '123')
 do something;

}
 

dadan_kasep_2 [EMAIL PROTECTED] wrote:
I have problem with substring in query like :

 while select MyLedgerJournalTrans
 where substr(MyLedgerJournalTrans.Txt,1,3) == '123'

Does anyone have any suggestions to solve this?

thank's
Regards

Dadan s







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


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

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












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.










R: [development-axapta] Substring in query

2005-06-08 Thread Zappia Alessandro




Hi Dadan,
 
try this 
 
while select MyLedgerJournalTrans
 where MyLedgerJournalTrans.Txt like '123*'
 
You can use a pseudoSQL sintax for operator like in axapta, with the following wildcards: ? = single char replacement, * = whole string replacement.
Hope this helps.
 
Regards
 
Alex
 


 
 



Da: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Per conto di dadan_kasep_2
Inviato: mercoledì 8 giugno 2005 6.50
A: development-axapta@yahoogroups.com
Oggetto: [development-axapta] Substring in query


I have problem with substring in query like :

 while select MyLedgerJournalTrans
 where substr(MyLedgerJournalTrans.Txt,1,3) == '123'

Does anyone have any suggestions to solve this?

thank's
Regards

Dadan s









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] mailto:[EMAIL PROTECTED] 
  
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . 




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












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] Substring in query

2005-06-08 Thread Sergey Siroklin




 while select MyLedgerJournalTrans
 where MyLedgerJournalTrans.Txt like '*123*' or without *

-Original Message-
From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of dadan_kasep_2
Sent: Wednesday, June 08, 2005 8:50 AM
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Substring in query

I have problem with substring in query like :

 while select MyLedgerJournalTrans
 where substr(MyLedgerJournalTrans.Txt,1,3) == '123'

Does anyone have any suggestions to solve this?

thank's
Regards

Dadan s







 
Yahoo! Groups Links



 

















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] Print To Screen

2005-06-08 Thread Steeve Gilbert




I don't know if there's an option somewhere but if not, take a look at the prompt() method in your Check report (we use Cheque_US). Change the line 

 this.setTarget(PrintMedium::Printer);
to 
 this.setTarget(PrintMedium::Screen);

Steeve... 


-Message d'origine-
De : development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de Nancy L Hall
Envoyé : 7 juin 2005 23:13
À : development-axapta@yahoogroups.com
Objet : [development-axapta] Print To Screen

I am unable to print the Check Layout to screen. Bank,
Bank Accounts, Select Bank Account, Set Up, Check
Layout, Print Test button. My Sent To box is grayed
out and the test will only print to the printer not to
screen. I am able to print all other Axapta Reports to
screen or what ever I choose. 

Has anyone else experienced this and how did you fix
it.

Thanks for your help. 



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





 
Yahoo! Groups Links



 














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] Substring in query

2005-06-08 Thread Roberto Pineda




Try this:

while select * from MyLedgerJournalTrans where 
MyLedgerJournalTrans like '*123*' {
}

it should works.

Roberto


 --- axapta developer [EMAIL PROTECTED] escribió:

 hi Dadan,
 
 Perhaps you could try working around it:
 
 while select * from MyLedgerJournalTrans
 {
 if(substr(MyLedgerJournalTrans.Txt,1,3) == 
 '123')
 do something;
 
 }
 
 
 dadan_kasep_2 [EMAIL PROTECTED] wrote:
 I have problem with substring in query like :
 
 while select MyLedgerJournalTrans
 where substr(MyLedgerJournalTrans.Txt,1,3)
 == '123'
 
 Does anyone have any suggestions to solve this?
 
 thank's
 Regards
 
 Dadan s
 
 
 
 
 
 
 
 -
 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. 
 
 
 __
 Do You Yahoo!?
 Tired of spam? Yahoo! Mail has the best spam
 protection around 
 http://mail.yahoo.com 
 
 [Non-text portions of this message have been
 removed]
 
 
 
 


Roberto Pineda

__
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis! 
Regístrate ya - http://correo.espanol.yahoo.com/ 












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] Print To Screen

2005-06-08 Thread axapta developer




hi Nancy,
 
You might want to look at the prompt() method of the Check_* (check_us) reports. Perhaps the method is overridden and returns something like:
ret = super(false, false, showDevice, false, false); where the last parameter disables the user selection of output medium.
 
hope it helps,
 
egoby_ax
 


Nancy L Hall [EMAIL PROTECTED] wrote:
I am unable to print the Check Layout to screen. Bank,
Bank Accounts, Select Bank Account, Set Up, Check
Layout, Print Test button. My Sent To box is grayed
out and the test will only print to the printer not to
screen. I am able to print all other Axapta Reports to
screen or what ever I choose. 

Has anyone else experienced this and how did you fix
it.

Thanks for your help. 



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





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



  
-
Discover Yahoo!
 Stay in touch with email, IM, photo sharing  more. Check it out!

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













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] Ax 3 Sp4 installation errors

2005-06-08 Thread cdlmalherbe01




Hi all,

I've installed SP4 in a SP3 standard 2 tier environment on MSSQL. When 
launching Ax for the first time I'm informed that an unrecoverable 
error has occured as a result of 2 USERID fields in table 
SQLSTATISTICS (id's 2 and 61441). The log isn't much help.

The sp readme spoke of certain errors but indicated that deleting 
ax*.aoi would fix them.

Has anybody run across this or a similar issue?

Kindest regards,

Christoph Malherbe















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.