RE: [Axapta-Knowledge-Village] Reread and refresh problem
Thanks a lot Steve, That info helped me find the problem and now have solved it :)) Basically there was a form with several datasoources. In the top datasoruce in the reread method their was a call to research() for the sub datasources. Now in some code the system modified the top table and then called reread of the top ds. So this caused research of the sub to be called which basically will caused the jump to top (expected behaviour of research as far as I understand). The only thing I dont understand is why it didnt jump to top on every record! I guess its something about the form data cache or something like that... But I solved by taking the research() calls out of the top ds reread and putting explicit rereads/refresh of the sub ds in the code. Now it all seems to work great. Anyone got any input on why research didnt go to the top for every record? Thanks James -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steeve Gilbert Sent: 27 May 2006 01:11 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE : [Axapta-Knowledge-Village] Reread and refresh problem I don't know what could be the problem you're facing but here's an explanation of refresh and reread taken from a post on axapta-dev forum. Regards, Steeve... Just to clarify a few points... .refresh() will not reread the record from the database. It basically just refreshes the screen with whatever is stored in the form cache. .reread() will only re-read the CURRENT record from the DB so you should not use it to refresh the form data if you have added/removed records. It's often used if you change some values in the current record in some code, and commit them to the database using .update() on the table, instead of through the form datasource. In this case .reread() will make those changes appear on the form. .research() will rerun the existing form query against the datasource, therefore updating the list with new/removed records as well as updating existing ones. This will honour any existing filters and sorting on the form. .executeQuery() is another useful one. It should be used if you have modified the query in your code and need to refresh the form. It's like .research() except it takes query changes into account. In general, you only need to use one of these in any specific circumstance. Hope that helps clear it up Andrew Jones HGH Business Consultancy -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de James Flavell Envoyé : 26 mai 2006 12:26 À : Axapta-Knowledge-Village@yahoogroups.com Objet : [Axapta-Knowledge-Village] Reread and refresh problem Hi, I hope someone can share some understanding on something a little technical: What are the difference of reread and refresh in the context of a form? I have a modified form that has a problem whereby the user edits a field value and then press the down arrow key to go to the next record but after about 20 lines the cursor jumps back up to the first record and the lines get doubled or tripled. When I close the form and go back in then again I see only one set of all the records!!! I tested and found if I maximize the screen then if I edit any record that is more than 22 down the list then this result happens but if I make the screen smaller (i.e. less records displayed in the form) then it happens after about 19 lines. I tested sorting and filtering the records and it's the same once I scroll down the X number of records from the top and edit then the samething happens so it is not specific records but how many records down! Also I know in the field that gets modified there is a load of reread and refreshes that someone has put (too many I am sure but I am not really technical enough to say what it should be hence this email). So putting it all together I assume it is something about how many records the form reads into its 'display' memory combined with all these reread and refreshes. I hope someone can share the technical side of the reread and refresh or even better what might be the problem. Thanks James [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Bus
Re: RE : [Axapta-Knowledge-Village] How to call multiple report designs?
Hi Steeve, Thanks for the reply... Where would be the best place i can place this code in the report... Steeve Gilbert <[EMAIL PROTECTED]> wrote: After you have decided which design to use, set it that way : element.design("YourDesign"); regards, Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de sherin francis Envoyé : 22 mai 2006 05:19 À : axapta axapta Objet : [Axapta-Knowledge-Village] How to call multiple report designs? Hi All, I have created multiple designs in the Sales Quotation report. But facing a problem as to how to call them? If the item number is of a particular range a particular design has to be printed else the standard. Can anyone shed some light, as to which method to make this modification and how to call that particular report Thanks in advance... - Be a chatter box. Enjoy free PC-to-PC calls with Yahoo! Messenger with Voice. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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. - - Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Trade & Logistics Training Materials
Hi dude, I am planning to take Axapta Trade & Logistics Exam. Do any of you have the training material for course ware for me to prepare for the exam. Hope you can share with me. Thanks. Rgds CM Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Reread and refresh problem
I don't know what could be the problem you're facing but here's an explanation of refresh and reread taken from a post on axapta-dev forum. Regards, Steeve... Just to clarify a few points... .refresh() will not reread the record from the database. It basically just refreshes the screen with whatever is stored in the form cache. .reread() will only re-read the CURRENT record from the DB so you should not use it to refresh the form data if you have added/removed records. It's often used if you change some values in the current record in some code, and commit them to the database using .update() on the table, instead of through the form datasource. In this case .reread() will make those changes appear on the form. .research() will rerun the existing form query against the datasource, therefore updating the list with new/removed records as well as updating existing ones. This will honour any existing filters and sorting on the form. .executeQuery() is another useful one. It should be used if you have modified the query in your code and need to refresh the form. It's like .research() except it takes query changes into account. In general, you only need to use one of these in any specific circumstance. Hope that helps clear it up Andrew Jones HGH Business Consultancy -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de James Flavell Envoyé : 26 mai 2006 12:26 À : Axapta-Knowledge-Village@yahoogroups.com Objet : [Axapta-Knowledge-Village] Reread and refresh problem Hi, I hope someone can share some understanding on something a little technical: What are the difference of reread and refresh in the context of a form? I have a modified form that has a problem whereby the user edits a field value and then press the down arrow key to go to the next record but after about 20 lines the cursor jumps back up to the first record and the lines get doubled or tripled. When I close the form and go back in then again I see only one set of all the records!!! I tested and found if I maximize the screen then if I edit any record that is more than 22 down the list then this result happens but if I make the screen smaller (i.e. less records displayed in the form) then it happens after about 19 lines. I tested sorting and filtering the records and it's the same once I scroll down the X number of records from the top and edit then the samething happens so it is not specific records but how many records down! Also I know in the field that gets modified there is a load of reread and refreshes that someone has put (too many I am sure but I am not really technical enough to say what it should be hence this email). So putting it all together I assume it is something about how many records the form reads into its 'display' memory combined with all these reread and refreshes. I hope someone can share the technical side of the reread and refresh or even better what might be the problem. Thanks James [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Date validation
Check that page (http://www.systomatics.biz/proj18.htm) from Harry. Regards, Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de hany abodoma Envoyé : 23 mai 2006 05:50 À : Axapta-Knowledge-Village@yahoogroups.com Objet : [Axapta-Knowledge-Village] Date validation dear all i have field of type Date and enumeration field has value from 1 to 12 i need when the user select the date if i select from the enumeration 3 then he can't select all dayes in (mars) month (3) thanks and best regards Hany Abodoma [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Reread and refresh problem
Hi, I hope someone can share some understanding on something a little technical: What are the difference of reread and refresh in the context of a form? I have a modified form that has a problem whereby the user edits a field value and then press the down arrow key to go to the next record but after about 20 lines the cursor jumps back up to the first record and the lines get doubled or tripled. When I close the form and go back in then again I see only one set of all the records!!! I tested and found if I maximize the screen then if I edit any record that is more than 22 down the list then this result happens but if I make the screen smaller (i.e. less records displayed in the form) then it happens after about 19 lines. I tested sorting and filtering the records and it's the same once I scroll down the X number of records from the top and edit then the samething happens so it is not specific records but how many records down! Also I know in the field that gets modified there is a load of reread and refreshes that someone has put (too many I am sure but I am not really technical enough to say what it should be hence this email). So putting it all together I assume it is something about how many records the form reads into its 'display' memory combined with all these reread and refreshes. I hope someone can share the technical side of the reread and refresh or even better what might be the problem. Thanks James [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Invoice account vs order account in AR.
Hi depends what is the usually practice for online checking. If it is to treat each company separate then don't use invoice account but rather add a grouping field and create invoice reports and statement based on this. But if the majority of online enquiries require the data to be consolidated then use the invoice account. Which ever way will require some modifications so its just a matter of being clear what the majority of online views required so as to minimize how many modifications you have to do. All the best James -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Maurice Cohen Sent: 26 May 2006 23:47 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Invoice account vs order account in AR. In your case the invoice account is not a great solution because as you stated all the A/R transactions are against the invoice account. You can change the setting for the invoice address to go to the order account instead of the invoice account but the transactions are still against the invoice account. Instead, You may want to implement some other type of grouping (maybe a financial dimension or a custom group) and modify the report. Maurice Cohen Senior consultant Advanced Systems Integration Inc. 26449 Rancho Parkway South Lake Forest, CA 92630 Phone (949) 597-2170 Fax (949) 597-0720 Cell (949) 533-5966 -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hennie Potgieter Sent: Friday, May 26, 2006 6:18 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Invoice account vs order account in AR. Hi, We need to implement the concept of an "umbrella account" in Axapta. This means that we have a big customer that has many accounts with us. Every account gets its own set of invoices and statement at the end of the month. What we however want to do is also provide the customer with a statement and related invoices for the consolidated head office account (the "umbrella" account). Also, when we look at our top 100 customers we would like Axapta to look at the value of the umbrella account instead of at the individual accounts. My question is this: Is the invoice account/order account fields the correct place to implement this? It seems to me as if all transactions and all invoices lie against the invoice account even if you post to the order account. Can someone please shed some light on this for me? Thanks, Hennie Hennie Potgieter - Senior Business Analyst UTi | cnr Olievenhoutbush & Brakfontein Rd | Centurion | Gauteng | 0061 South Africa [EMAIL PROTECTED] | O (+27) 12 673 2340 | F (+27) 12 673 2344 [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Invoice account vs order account in AR.
In your case the invoice account is not a great solution because as you stated all the A/R transactions are against the invoice account. You can change the setting for the invoice address to go to the order account instead of the invoice account but the transactions are still against the invoice account. Instead, You may want to implement some other type of grouping (maybe a financial dimension or a custom group) and modify the report. Maurice Cohen Senior consultant Advanced Systems Integration Inc. 26449 Rancho Parkway South Lake Forest, CA 92630 Phone (949) 597-2170 Fax (949) 597-0720 Cell (949) 533-5966 -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hennie Potgieter Sent: Friday, May 26, 2006 6:18 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Invoice account vs order account in AR. Hi, We need to implement the concept of an "umbrella account" in Axapta. This means that we have a big customer that has many accounts with us. Every account gets its own set of invoices and statement at the end of the month. What we however want to do is also provide the customer with a statement and related invoices for the consolidated head office account (the "umbrella" account). Also, when we look at our top 100 customers we would like Axapta to look at the value of the umbrella account instead of at the individual accounts. My question is this: Is the invoice account/order account fields the correct place to implement this? It seems to me as if all transactions and all invoices lie against the invoice account even if you post to the order account. Can someone please shed some light on this for me? Thanks, Hennie Hennie Potgieter - Senior Business Analyst UTi | cnr Olievenhoutbush & Brakfontein Rd | Centurion | Gauteng | 0061 South Africa [EMAIL PROTECTED] | O (+27) 12 673 2340 | F (+27) 12 673 2344 [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Invoice account vs order account in AR.
Hi, We need to implement the concept of an "umbrella account" in Axapta. This means that we have a big customer that has many accounts with us. Every account gets its own set of invoices and statement at the end of the month. What we however want to do is also provide the customer with a statement and related invoices for the consolidated head office account (the "umbrella" account). Also, when we look at our top 100 customers we would like Axapta to look at the value of the umbrella account instead of at the individual accounts. My question is this: Is the invoice account/order account fields the correct place to implement this? It seems to me as if all transactions and all invoices lie against the invoice account even if you post to the order account. Can someone please shed some light on this for me? Thanks, Hennie Hennie Potgieter - Senior Business Analyst UTi | cnr Olievenhoutbush & Brakfontein Rd | Centurion | Gauteng | 0061 South Africa [EMAIL PROTECTED] | O (+27) 12 673 2340 | F (+27) 12 673 2344 [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] Invoice account vs order account in AR.
Hi, We need to implement the concept of an "umbrella account" in Axapta. This means that we have a big customer that has many accounts with us. Every account gets its own set of invoices and statement at the end of the month. What we however want to do is also provide the customer with a statement and related invoices for the consolidated head office account (the "umbrella" account). Also, when we look at our top 100 customers we would like Axapta to look at the value of the umbrella account instead of at the individual accounts. My question is this: Is the invoice account/order account fields the correct place to implement this? It seems to me as if all transactions and all invoices lie against the invoice account even if you post to the order account. Can someone please shed some light on this for me? Thanks, Hennie Hennie Potgieter - Senior Business Analyst UTi | cnr Olievenhoutbush & Brakfontein Rd | Centurion | Gauteng | 0061 South Africa [EMAIL PROTECTED] | O (+27) 12 673 2340 | F (+27) 12 673 2344 [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] How to call multiple report designs?
After you have decided which design to use, set it that way : element.design("YourDesign"); regards, Steeve... -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de sherin francis Envoyé : 22 mai 2006 05:19 À : axapta axapta Objet : [Axapta-Knowledge-Village] How to call multiple report designs? Hi All, I have created multiple designs in the Sales Quotation report. But facing a problem as to how to call them? If the item number is of a particular range a particular design has to be printed else the standard. Can anyone shed some light, as to which method to make this modification and how to call that particular report Thanks in advance... - Be a chatter box. Enjoy free PC-to-PC calls with Yahoo! Messenger with Voice. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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] report as an attachment
hello all, I want to send the report as an attachment from email. How can i do it. thanks, Gopal. - Yahoo! India Answers Share what your know-how and wisdom Send free SMS to your Friends on Mobile from your Yahoo! Messenger Download now [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. 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.