[development-axapta] Getting opening balance on a given ledger acct
How do i do it? I tried using the balance method on LedgerBalanceSum_CurrentMST but it doesnt seem to work correctly (my opening balance on Account Statement Report is different from what i get from a simple job using the above object. I made sure to use same arguments to create my LedgerBalanceSum object as the report uses) Please help. 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 all Axapta companies data in a report
There is actually a class + a form, both called SysQueryForm, that control the queries for reports. If you change the findFields() method on the class, you can enable the Company (DataAreaId) field for selection, but there may be other things needed to have it actually pull data. I need to dig more into this later myself, but I don't have time right now. Hopefully this will get you started. From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James Flavell Sent: Monday, May 30, 2005 7:52 PM To: development-axapta@yahoogroups.com Subject: [development-axapta] Print all Axapta companies data in a report Hi I am thinking of writing a report that prints information from several Axapta companies but do not want to have to use the changeCompany function because I want a select (or query) to be able to run through all the records to consolidate records with same values and so I would like to use groupby rather than manually have to do this with change company and temp tables etc. Is this possible or will all Axapta select statements and queries always be defaulted to filter by the current company I am in? Is there anyway to turn this default behaviour off for a given select or query? I guess I can write direct SQL in Axapta but I have never done this and so am not sure the syntax to handle the returned records/results so would prefer to do it using std Axapta if possible. If it is only possible with direct SQL I would apprecaite some help as how to handle the results coming back. Can I make use of views for this? Thanks James [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] mailto:[EMAIL PROTECTED] be * 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
I Have done my problem using your's solution, thanks for your help. Regards dadan -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of Thomas Jensen Sent: Wednesday, June 08, 2005 7:39 PM To: development-axapta@yahoogroups.com Subject: SV: [development-axapta] Substring in query 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/ 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.
[Axapta-Knowledge-Village] [development-axapta] carriage return + new line in a string
Hello All, I am coding and I am coding the Address field of the VendTable for import through X++. Anyway does anyone know if a carriage return + new line = VendTable.Address = StrName + \r\n Where the + \r\n equals a carriage return + a new line. I know this is how it is in C# and also Java / C++ I believe... Is it the same here in X++ or is there another way to do this? thanks, Brandon _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Byteway Sent: Wednesday, June 08, 2005 2:37 PM To: development-axapta@yahoogroups.com; Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: [development-axapta] Reservations Hi, Do try and take the web application training if available in your neighbourhood... 'cause back in the old days, building a videowebshop was one of the things you learned. The simularity I see is that the videos can be seen as rooms, they are bought ones and then used to be rented. People could track online if something was available (on stock) or could make reservations. All kinds of combinations are possible :-) Perhaps there is still someone out there who has some demo video webshop for you to look at? You can also try and find the keyword 'service' in your own Axapta documentation. /b oscarcaravaca wrote: Hi there. We have got a very big problem with reservations/inventory/sales, and we would like to implement a Business politic concerning this topics. 1)Reservation of inventory is going to be done directly by the system weekly (normally on weekend) and reservations will expire in current week on friday. 2) Unreserve all physical inventory. 2) In this process we would like to sort sales order by amount 3) If we have got stock for the full sales order we would like to make reservation of material 4) Go step to the next order 5) if we don't have enough stock for the full order, go to the next one. I think this could be a good method to assign reservations and increase our sales. Any suggestions or tips? Wich objects/methods can we use? Thanks all. *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/. 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] mailto:[EMAIL PROTECTED] ribe * 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.
[development-axapta] Axapta CRM Telemarketing
Does anybody have customers or any experience using the Axapta CRM Telemarketing module? I have a customer asking for a case story, but I don't know anybody using this module. Regards Thomas Jensen [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] Listview Problem
Dear Expert, i having problem with the listview. my problem is i want to pass the listview value to listview value 2 by clicking one button. the is doing manually and not using panel because it involve 4 table join together. Thanks regards dave 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 all Axapta companies data in a report
Thanks a lot I will look into that but liek yourself I dont have much time for doing it right now Thanks once again James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Jesper Kehlet Sent: 09 June 2005 11:01 To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Print all Axapta companies data in a report There is actually a class + a form, both called SysQueryForm, that control the queries for reports. If you change the findFields() method on the class, you can enable the Company (DataAreaId) field for selection, but there may be other things needed to have it actually pull data. I need to dig more into this later myself, but I don't have time right now. Hopefully this will get you started. From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James Flavell Sent: Monday, May 30, 2005 7:52 PM To: development-axapta@yahoogroups.com Subject: [development-axapta] Print all Axapta companies data in a report Hi I am thinking of writing a report that prints information from several Axapta companies but do not want to have to use the changeCompany function because I want a select (or query) to be able to run through all the records to consolidate records with same values and so I would like to use groupby rather than manually have to do this with change company and temp tables etc. Is this possible or will all Axapta select statements and queries always be defaulted to filter by the current company I am in? Is there anyway to turn this default behaviour off for a given select or query? I guess I can write direct SQL in Axapta but I have never done this and so am not sure the syntax to handle the returned records/results so would prefer to do it using std Axapta if possible. If it is only possible with direct SQL I would apprecaite some help as how to handle the results coming back. Can I make use of views for this? Thanks James [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] mailto:[EMAIL PROTECTED] be * 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] 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.
R: RE : [development-axapta] Number sequences
Mmmm, seems to be very interesting, thanks a lot Steeve! Da: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Per conto di Steeve Gilbert Inviato: giovedì 9 giugno 2005 14.23 A: development-axapta@yahoogroups.com Oggetto: RE : [development-axapta] Number sequences Is that what you are looking for? http://www.axaptalink.com/index.php?option=contenttask=viewid=73 Steeve... -Message d'origine- De : development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de Zappia Alessandro Envoyé : 9 juin 2005 03:54 À : development-axapta@yahoogroups.com Objet : [development-axapta] Number sequences Hi everybody! Is there a way to include a new number sequence in a project? I try to explain my problem, i've developed an interface with a carrier and each shipment is stored in a table using an ad-hoc number sequence. I'd like to make this sequence self-creating when I import the project. Is there a way to do this? Many many thanks for any help! Alex [Non-text portions of this message have been removed] 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] 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] Print all Axapta companies data in a report
I just found out that doing this alone won't do it. What needs to be done is to change the findFields() method on the SysQueryForm class. You will find a line in there that reads like this that you must comment out (line 28 in 3.0): (field.name() != fieldStr(Common, dataAreaId)) Next step is to, in the fetch method on your reports, read the DataAreaId fields, should they exist, and if they do, loop a changecompany() -- sorry, but that's unavoidable, but this is definitely one of the easier ways to do it anyway rather than to do a dialog that prompts for company/companies etc... :-)) Hope this helps, if you need more info, let me know. From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James Flavell Sent: Thursday, June 09, 2005 5:54 AM To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Print all Axapta companies data in a report Thanks a lot I will look into that but liek yourself I dont have much time for doing it right now Thanks once again James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Jesper Kehlet Sent: 09 June 2005 11:01 To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Print all Axapta companies data in a report There is actually a class + a form, both called SysQueryForm, that control the queries for reports. If you change the findFields() method on the class, you can enable the Company (DataAreaId) field for selection, but there may be other things needed to have it actually pull data. I need to dig more into this later myself, but I don't have time right now. Hopefully this will get you started. From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James Flavell Sent: Monday, May 30, 2005 7:52 PM To: development-axapta@yahoogroups.com Subject: [development-axapta] Print all Axapta companies data in a report Hi I am thinking of writing a report that prints information from several Axapta companies but do not want to have to use the changeCompany function because I want a select (or query) to be able to run through all the records to consolidate records with same values and so I would like to use groupby rather than manually have to do this with change company and temp tables etc. Is this possible or will all Axapta select statements and queries always be defaulted to filter by the current company I am in? Is there anyway to turn this default behaviour off for a given select or query? I guess I can write direct SQL in Axapta but I have never done this and so am not sure the syntax to handle the returned records/results so would prefer to do it using std Axapta if possible. If it is only possible with direct SQL I would apprecaite some help as how to handle the results coming back. Can I make use of views for this? Thanks James [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] mailto:[EMAIL PROTECTED] be * 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] mailto:[EMAIL PROTECTED] be * 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] mailto:[EMAIL PROTECTED] be * 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.