SV: [Axapta-Knowledge-Village] Company Account ID Change
Den 30. juni 2009 23:48 skrev Axapta-Knowledge-Village@yahoogroups.com: but i am surprised to know if this minor change can not be handled easily. Why - with 4 characters and using letters and numbers you can create 1679616 companies - I doubt you hitting that limit ;-) Søren
SV: [Axapta-Knowledge-Village] Issue with dateNull() function.
Den 25. juni 2009 12:13 skrev Axapta-Knowledge-Village@yahoogroups.com: Why is dateNull() returning no value. Is this the expected behaviour? Yes - dateNull() returns an empty date - how it is implemented is irrelevant. Søren Armstrong IT ApS
SV: [Axapta-Knowledge-Village] Non editable field
Den 17. juni 2008 11:25 skrev Axapta-Knowledge-Village@yahoogroups.com: Here in this form after entering the value in one of the field once i save the form this field should become uneditable. On the field in the table set AllowEdit to No Søren Armstrong IT ApS
SV: [Axapta-Knowledge-Village] not more than 100 %
Den 20. maj 2008 11:03 skrev Axapta-Knowledge-Village@yahoogroups.com: Den 7. maj 2008 12:31 skrev Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com : Has anyone come across this situation in standard AX, suppose you have field called percentage in your form and the total percentage should not be more than 100% if it exceeds so system should throw the error, percentage should be some of values in all the rows. In ValidateWrite on the table do something like: Actually it should probably be: Table.update if ((select sum(percent) from mytable).percent100) throw error(Percent over 100); Table.insert if ((select sum(percent) from mytable).percent+this.percent100) throw error(Percent over 100); Greetings Søren
SV: [Axapta-Knowledge-Village] not more than 100 %
Den 7. maj 2008 12:31 skrev Axapta-Knowledge-Village@yahoogroups.com: Has anyone come across this situation in standard AX, suppose you have field called percentage in your form and the total percentage should not be more than 100% if it exceeds so system should throw the error, percentage should be some of values in all the rows. In ValidateWrite on the table do something like: if ((select sum(percent) from mytable).percent100) return checkFailed(Percent over 100); Greetings Søren
RE: [Axapta-Knowledge-Village] Date and week operation
Den 4. maj 2006 09:38 skrev Alfonso Collados Arroyo: I have a Date and I want to get the date 13 weeks after. Date+=(7*13); Hilsen Søren 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] MBS = Microsoft Dynamics... please join the ONE group.....
Den 30. oktober 2005 13:57 skrev Sajeed: Microsoft Business Solutions (MBS) are going be Microsoft DynamicsSo thought of pooling all the members from Axapta, Navision, GP Solomon groups to be ONE Why? 1) There are already more than one Axapta group - why add another? 2) Even though the name changes it is still 4 different products - so why would I join when I am only interested in Axapta, XAL C5 - which is only 25% of the group... Hilsen Søren 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: RE : [Axapta-Knowledge-Village] Performance analysis
Den 20. oktober 2005 16:49 skrev Steeve Gilbert: exec sp_cursorexecute 241, @P1 output, @P2 output, @P3 output, @P4 output, 'boa', 0, 0, 'boa', '596965' In Axapta go to Tools/Options select the SQL tab. Enable SQL trace. Under long queries enter 1000 (= all queries over 1 sec are logged) in Threshold and check Table (database). This has to be done for each user you want to monitor. Check the log at Administration/Inquiries/Database/SQL statement trace log - it will give you all the information you could want: sql statement, stack trace, execution plan You can lower the threshold if nothing shows up. Hilsen Søren 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] Index usage
Den 6. september 2005 17:29 skrev Cenk Ince: inventTrans table has some indexes on it. But when i create a select sentence for most records in table, i can't find an index that has fields itemid and dateFinancial. So i can't decide to use itemidX or OpenItemidx. Always use the index where you have the most fields (from the top of the field list). So in this case use ItemIdx as the first field here is known. Hilsen Søren Yahoo! Groups Sponsor ~-- Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/r7D80C/dlQLAA/cosFAA/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] Any Idea abou this?
Den 31. august 2005 11:27 skrev Hennie Potgieter: I know now how it works but it still doesnt make much sense to me why it is right aligned and why Axapta prefixes the data with blanks. Sorting. Right aligned: 1 2 10 11 12 Left aligned 1 10 11 12 2 Makes sense now ;-) Hilsen Søren Yahoo! Groups Sponsor ~-- Put more honey in your pocket. (money matters made easy). http://us.click.yahoo.com/r7D80C/dlQLAA/cosFAA/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] Label problems
Den 24. august 2005 12:09 skrev [EMAIL PROTECTED]: I am having problems with one set of label files. In our environment we have been adding a lot of labels over the past period, but the corresponding label files are not updated, when the AOS service is shut down. Shutdown AOS, delete *.udb from appl dir. start and exit Axapta (2 tier preferred) - it should update the label file then. Hilsen Søren Yahoo! Groups Sponsor ~-- font face=arial size=-1a href=http://us.ard.yahoo.com/SIG=12hr9klll/M=362343.6886682.7839641.1493532/D=groups/S=1705001380:TM/Y=YAHOO/EXP=1124886764/A=2894352/R=0/SIG=11fdoufgv/*http://www.globalgiving.com/cb/cidi/tsun.html;Help tsunami villages rebuild at GlobalGiving. The real work starts now/a./font ~- 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] Labels not being output during service shutdown
Den 27. april 2005 17:13 skrev Jens Strandberg: I have done as per your recommendations, but in 2 of our 3 environments labels are not flushed. In 2 tier? - remember 2 tier is the preferred development environment. Hilsen Søren Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/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: RE: [Axapta-Knowledge-Village] Labels not being output during service sh utdown
Den 28. april 2005 08:33 skrev Steen Rabol: ??? Who said that 2-tier is the preferred development environment? Expirence At Microsoft all development is done in 3-tier, SP4 was developed in 3-tier. I am not going to comment on that ;-) Hilsen Søren Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/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] Labels not being output during service shutdown
Den 26. april 2005 21:22 skrev Jens Strandberg: Does any of this ring a bell ? Any pointers ? Labels are flushed when the last user logs out. So if the suer count gets messed up it will not flush. You need to delete the .udb file and then have ONE person log in anf out again and it should flush the labels. Hilsen Søren Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/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] X++ Projects
Den 27. april 2005 07:32 skrev Bayliss, Barry: Does anyone know: The upgrade wizard can create a project with elements you need to check - so it is possible. Can't remember off the top of my head what the same of the upgrade class is though. Hilsen Søren Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/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] Actual Scrap on Finished Goods in Production Order
Den 3. februar 2005 19:27 skrev mchiat: FG scrap will not be posted into my scrap account even though my scrap method set up to be 'scrap account'. In 3.0 the scrap account is not used if you run standard cost. Don't ask me why - it did in previous versions. Hilsen Søren Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/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/