[Axapta-Knowledge-Village] Re: Horizantal Report Bodies
yeah, thats what I did .. i hope Axapta will support crystal soon. --- In Axapta-Knowledge-Village@yahoogroups.com, Harry \(Harshawardhan Deshpande [EMAIL PROTECTED] wrote: hi there are multiple ways you could do this. for e.g. create a temp table with four fields : additive allowance name, amount, deduction name, amount. Fill up this table before printing a pay-slip and then you could use a single body to print the same. regards harry RFK142 [EMAIL PROTECTED] wrote: Aasmee, Sorry about the confusion, here is my situation: I have 1 table in which records are classified according 1 field, so the field is either deductive or additive, as u can guess this is concerning payroll. Our customer prints the payslips on preprinted paper on dot matrix. This payslip has a table with two columns alongside each other, one for additive allowances and the other for deductions. My problem is that i need to print different kinds of records (ie additions and deductions) to different boddies that lie next to each other and not above one another. See my issue? Thnx a bunch for your help, Rabih --- In Axapta-Knowledge-Village@yahoogroups.com, Aasmee [EMAIL PROTECTED] wrote: Hi Rabih Can't u use a single body bcoz u can always fetch data from 2 or more tables in a single body or can u further elaborate your problem. Thanx RFK142 [EMAIL PROTECTED] wrote: Hi guys, I have a report that is printed with two bodies horizantal to each other, each body is from a seperate table(datasource), so you will have the bodies aligned next to each other and not above one another. Is that possible? Thanks, Rabih 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 the Yahoo! Terms of Service. Aasmee Axapta Tech. Consultant Yahoo! India Matrimony: Find your life partneronline. 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 the Yahoo! Terms of Service. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com 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] Search for CustVendExternalItem in form InventTable
Thanks James, You are not too simple; that's a very good idea. Haven't actually thought about it, but of course that will work. Next issue; would you happen to know, where you can set the initial tables to use in the filter ? I know that the user can save the query for later use, but is there a way to set up the default tables to search in ? /Jens -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] Sendt: 23. april 2005 04:42 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: RE: [Axapta-Knowledge-Village] Search for CustVendExternalItem in form InventTable Sorry maybe I am being too simple but can you not just use the cross refence and add the custvendexternalitem table in your filter on the inventtable form? -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] Sent: 23 April 2005 05:57 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Search for CustVendExternalItem in form InventTable Thanks Jesper, I will try to be a little more specific: Let's say that I would like to search for part numbers that have XYZ as ExternalItem field. I would do a select on CustVendExternalItem table, and I might find 4 records that match. Now, I would like to see the corresponding records in InventTable; displayed in the normal InventTable form. Pretty much the same result, as if I did a Ctrl+F in a given field and only retrieved and displayed the records that match. I have seen some installations, where you simply add a Search button to the InventTable form. When pressed, you can click on External Item, and you are then presented with a search dialog. After searching, the corresponding InventTable records are displayed in the InventTable form. /Jens -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] vegne af Jesper Kehlet Sendt: 22. april 2005 19:22 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: RE: [Axapta-Knowledge-Village] Search for CustVendExternalItem in form InventTable It would be helpful with a little more detail on what you want to search on, but here is a generic approach to selecting InventTable records from criteria in related tables: First, add fields to the form corresponding to your search criteria, preferably in a group. To make things easier, create edit methods to tie to these fields. The edit method will then activate with the set flag when changing the contents. On the InventTable data source, in the executeQuery() method, you would test for these fields being set (non empty), and if they are, add a linked QueryBuildDataSource for CustVendExternalItem to the InventTable_ds.query(), and set that datasource to exist join. If the fields are not set (empty), traverse/get linked datasources, and clear the datasource you have set. Another approach is to add the CustVendExternalItem as a form datasource, and control the joining through code. This way it will show up in the filter view, and you do not have to add search fields on the form, but it would make it less user friendly. That's a couple of generic approaches based on a set of assumptions about what you want to accomplish. Let me know more detail if you want more specific help. /Jesper _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Jens Strandberg Sent: Thursday, April 21, 2005 11:23 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Search for CustVendExternalItem in form InventTable Hello there, Ax 3.0 SP 3 I would like to add a feature to the InventTable form, so that I would be able to search for certain information in CustVendExternalItem, join this information with the corresponding InventTable records and present the InventTable records in the normal InventTable form. I am looking for a generic way to accomplish this in order to be able to expand the search facilities to other, related tables, e.g. InventTxt. What would be the best solution ? Thanks in advance ! Best Regards, Jens Sharing the knowledge on Axapta. 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/ 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/ . 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!
RE: [Axapta-Knowledge-Village] Search for CustVendExternalItem in form InventTable
Title: Message I believe that's what I mentioned in the second approach below, but James please correct me if I'm wrong: Add CustVendExternalItem as a form datasource. Now you can use it with the filter (Ctrl-F3). From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Jens StrandbergSent: Monday, April 25, 2005 5:40 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] Search for CustVendExternalItem in form InventTable Thanks James, You are not too simple; that's a very good idea. Haven't actually thought about it, but of course that will work. Next issue; would you happen to know, where you can set the "initial" tables to use in the filter ? I know that the user can save the query for later use, but is there a way to set up the "default" tables to search in ? /Jens -Oprindelig meddelelse-Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED]Sendt: 23. april 2005 04:42Til: Axapta-Knowledge-Village@yahoogroups.comEmne: RE: [Axapta-Knowledge-Village] Search for CustVendExternalItem in form InventTable Sorry maybe I am being too simple but can you not just use the cross refence and add the custvendexternalitem table in your filter on the inventtable form? -Original Message-From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] Sent: 23 April 2005 05:57To: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] Search for CustVendExternalItem in form InventTable Thanks Jesper, I will try to be a little more specific: Let's say that I would like to search for part numbers that have "XYZ" asExternalItem field. I would do a select on CustVendExternalItem table, and I might find 4 records that match. Now, I would like to see the corresponding records in InventTable; displayed in the "normal" InventTable form. Pretty much the same result, as if I did a "Ctrl+F" in a given field and only retrieved and displayed the records that match. I have seen some installations, where you simply add a "Search" button to the InventTable form. When pressed, you can click on "External Item", and you are then presented with a search dialog. After searching, the corresponding InventTable records are displayed in the InventTable form. /Jens -Oprindelig meddelelse-Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED]På vegne af Jesper KehletSendt: 22. april 2005 19:22Til: Axapta-Knowledge-Village@yahoogroups.comEmne: RE: [Axapta-Knowledge-Village] Search for CustVendExternalItem in form InventTable It would be helpful with a little more detail on what you want to search on, but here is a generic approach to selecting InventTable records from criteria in related tables: First, add fields to the form corresponding to your search criteria, preferably in a group. To make things easier, create "edit" methods to tie to these fields. The edit method will then activate with the set flag when changing the contents. On the InventTable data source, in the executeQuery() method, you would test for these fields being set (non empty), and if they are, add a linked QueryBuildDataSource for CustVendExternalItem to the InventTable_ds.query(), and set that datasource to exist join. If the fields are not set (empty), traverse/get linked datasources, and clear the datasource you have set. Another approach is to add the CustVendExternalItem as a form datasource, and control the joining through code. This way it will show up in the filter view, and you do not have to add search fields on the form, but it would make it less "user friendly". That's a couple of generic approaches based on a set of assumptions about what you want to accomplish. Let me know more detail if you want more specific help. /Jesper From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Jens StrandbergSent: Thursday, April 21, 2005 11:23 AMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Search for CustVendExternalItem in form InventTable Hello there, Ax 3.0 SP 3 I would like to add a feature to the InventTable form, so that I would be able to search for certain information in CustVendExternalItem, join this information with the corresponding InventTable records and present the InventTable records in the "normal" InventTable form. I am looking for a generic way to accomplish this in order to be able to
SV: [Axapta-Knowledge-Village] Search for CustVendExternalItem in form InventTable
Jesper, Yes, you are correct. I missed / did not understand that one, but I have tested it today, and it works perfectly. Thanks for your input ! /Jens -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] vegne af Jesper Kehlet Sendt: 25. april 2005 15:49 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: RE: [Axapta-Knowledge-Village] Search for CustVendExternalItem in form InventTable I believe that's what I mentioned in the second approach below, but James please correct me if I'm wrong: Add CustVendExternalItem as a form datasource. Now you can use it with the filter (Ctrl-F3). _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Jens Strandberg Sent: Monday, April 25, 2005 5:40 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Search for CustVendExternalItem in form InventTable Thanks James, You are not too simple; that's a very good idea. Haven't actually thought about it, but of course that will work. Next issue; would you happen to know, where you can set the initial tables to use in the filter ? I know that the user can save the query for later use, but is there a way to set up the default tables to search in ? /Jens -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] Sendt: 23. april 2005 04:42 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: RE: [Axapta-Knowledge-Village] Search for CustVendExternalItem in form InventTable Sorry maybe I am being too simple but can you not just use the cross refence and add the custvendexternalitem table in your filter on the inventtable form? -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] Sent: 23 April 2005 05:57 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Search for CustVendExternalItem in form InventTable Thanks Jesper, I will try to be a little more specific: Let's say that I would like to search for part numbers that have XYZ as ExternalItem field. I would do a select on CustVendExternalItem table, and I might find 4 records that match. Now, I would like to see the corresponding records in InventTable; displayed in the normal InventTable form. Pretty much the same result, as if I did a Ctrl+F in a given field and only retrieved and displayed the records that match. I have seen some installations, where you simply add a Search button to the InventTable form. When pressed, you can click on External Item, and you are then presented with a search dialog. After searching, the corresponding InventTable records are displayed in the InventTable form. /Jens -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] vegne af Jesper Kehlet Sendt: 22. april 2005 19:22 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: RE: [Axapta-Knowledge-Village] Search for CustVendExternalItem in form InventTable It would be helpful with a little more detail on what you want to search on, but here is a generic approach to selecting InventTable records from criteria in related tables: First, add fields to the form corresponding to your search criteria, preferably in a group. To make things easier, create edit methods to tie to these fields. The edit method will then activate with the set flag when changing the contents. On the InventTable data source, in the executeQuery() method, you would test for these fields being set (non empty), and if they are, add a linked QueryBuildDataSource for CustVendExternalItem to the InventTable_ds.query(), and set that datasource to exist join. If the fields are not set (empty), traverse/get linked datasources, and clear the datasource you have set. Another approach is to add the CustVendExternalItem as a form datasource, and control the joining through code. This way it will show up in the filter view, and you do not have to add search fields on the form, but it would make it less user friendly. That's a couple of generic approaches based on a set of assumptions about what you want to accomplish. Let me know more detail if you want more specific help. /Jesper _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Jens Strandberg Sent: Thursday, April 21, 2005 11:23 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Search for CustVendExternalItem in form InventTable Hello there, Ax 3.0 SP 3 I would like to add a feature to the InventTable form, so that I would be able to search for certain information in CustVendExternalItem, join this information with the corresponding InventTable records and present the InventTable records in the normal InventTable form. I am looking for a generic way to accomplish this in order to be able to expand the search facilities to other, related tables, e.g.
[Axapta-Knowledge-Village] After Upgrade DB increases over 13 GB
Hi all, i have a short question. After an upgrade from AX 30 SP2 to SP3 the DB increases from 10 Gb to 13 Gb. The DB is on a sql server 2000. What kind of possibilities are there to shrink the database? Thanks for your help. best regards sigtown 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 the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] After Upgrade DB increases over 13 GB
Yes. It's usually the log file. An easier way to accomplish this is to enter the following commands in Query Analyser. Backup logDatabaseName with truncate_onlyDBCC ShrinkFile(LogFileName, 0) It is best to do this after you have done a full backup since you do not want to kill the tranasaction logs that you may need in an emergency to restore the database. VardenMorris J. Wray Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I. Phone: (876) - 923 - 6141 Ext. 2226Fax: (876) - 923 -5372 Cell: (876) - 3833566Email: [EMAIL PROTECTED] [EMAIL PROTECTED] Raul Llorente Peña/OPENSOLUTIONS [EMAIL PROTECTED] wrote: Securely the most of increasing have been on Log file. Backup the BBDD, detach it, delete log file, and then reatach the data file. SQL will create a new, empty, very much smaller log file. SQL have provided some shrink options, but they are often few effective. Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS Sharing the knowledge on Axapta. __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 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 the Yahoo! Terms of Service.
Antwort: Re: [Axapta-Knowledge-Village] After Upgrade DB increases over 13 GB
Hi, I tried this, but the real problem is the .mdf file. this one increases from 10 Gb to 13 Gb. the log file has 5 gb, but i have delete it. so the other problem ist, that on normal use the db.file increases 3-4 Gb per year. so what strategy is the best way to shrink the .mdf file? thanks for your help best regards sascha Raul Llorente Peña/OPENSOLUTIONS [EMAIL PROTECTED] Gesendet von: Axapta-Knowledge-Village@yahoogroups.com 25.04.2005 18:09 Bitte antworten an Axapta-Knowledge-Village@yahoogroups.com An Axapta-Knowledge-Village@yahoogroups.com Kopie Thema Re: [Axapta-Knowledge-Village] After Upgrade DB increases over 13 GB Securely the most of increasing have been on Log file. Backup the BBDD, detach it, delete log file, and then reatach the data file. SQL will create a new, empty, very much smaller log file. SQL have provided some shrink options, but they are often few effective. Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-Axapta OPEN SOLUTIONS 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 the Yahoo! Terms of Service. 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 the Yahoo! Terms of Service.
Re: Antwort: Re: [Axapta-Knowledge-Village] After Upgrade DB increases over 13 GB
It is not a good idea to shrink the data file. The data file growth is dependent on the growth option you set on it. If you set it to say 10% and the initial size is 100G it will grow to 110G when all the 100G of space is all use up. It will then grow to 121G next and so on. The fact that it is taking up 121G on the disc does not mean that it needs all that space presently and if you shrink it, it may go down to 111G but it will grow again shortly after to allocate more space. Performance will degrade for each growth so you should set the growth percentage to a figure that will not cause the database to grow very often. The reason why you can shrink the log file to zero is because after transactions are committed the logs are not needed except in the case where you need to restore the database from the them. This is not the case with the data file. You cannot shrink the data beyond the actual size being used. VardenMorris J. Wray Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I. Phone: (876) - 923 - 6141 Ext. 2226Fax: (876) - 923 -5372 Cell: (876) - 3833566Email: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi, I tried this, but the real problem is the .mdf file. this one increases from 10 Gb to 13 Gb. the log file has 5 gb, but i have delete it. so the other problem ist, that on normal use the db.file increases 3-4 Gb per year. so what strategy is the best way to shrink the .mdf file? thanks for your help best regards sascha Raul Llorente Peña/OPENSOLUTIONS [EMAIL PROTECTED] Gesendet von: Axapta-Knowledge-Village@yahoogroups.com 25.04.2005 18:09 Bitte antworten anAxapta-Knowledge-Village@yahoogroups.com An Axapta-Knowledge-Village@yahoogroups.com Kopie Thema Re: [Axapta-Knowledge-Village] After Upgrade DB increases over 13 GB Securely the most of increasing have been on Log file. Backup the BBDD, detach it, delete log file, and then reatach the data file. SQL will create a new, empty, very much smaller log file. SQL have provided some shrink options, but they are often few effective. Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS 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 the Yahoo! Terms of Service. Sharing the knowledge on Axapta. __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 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 the Yahoo! Terms of Service.
RE: Antwort: Re: [Axapta-Knowledge-Village] After Upgrade DB increases over 13 GB
Look at http://www.acnc.com/raid.htmland http://www.sql-server-performance.comfor more information on how to performance optimize SQL. My suggestion is that you leave your data file(s) alone on its/their own RAID 10 logical drive, set the growth to a megabyte multiple of the RAID stripe size, and not to a percentage. Same with the log file, although you can shrink it if you want to. General rule of thumb and statement contrary to the general perception: Unless disk space is a critical factor, do NOT mess with SQLs data! It is OK for it to grow, and it will be managed OK by SQL itself, as long as SQL Server has been optimized for the hardware configuration employed! From: Axapta-Knowledge-Village@yahoogroups.com on behalf of Varden MorrisSent: Mon 4/25/2005 12:40 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: Antwort: Re: [Axapta-Knowledge-Village] After Upgrade DB increases over 13 GB It is not a good idea to shrink the data file. The data file growth is dependent on the growth option you set on it. If you set it to say 10% and the initial size is 100G it will grow to 110G when all the 100G of space is all use up. It will then grow to 121G next and so on. The fact that it is taking up 121G on the disc does not mean that it needs all that space presently and if you shrink it, it may go down to 111G but it will grow again shortly after to allocate more space. Performance will degrade for each growth so you should set the growth percentage to a figure that will not cause the database to grow very often. The reason why you can shrink the log file to zero is because after transactions are committed the logs are not needed except in the case where you need to restore the database from the them. This is not the case with the data file. You cannot shrink the data beyond the actual size being used. VardenMorris J. Wray Nephew Ltd. - Group I.S. 234 Spanish Town Road Kingston 11, Jamaica, W.I. Phone: (876) - 923 - 6141 Ext. 2226Fax: (876) - 923 -5372 Cell: (876) - 3833566Email: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi, I tried this, but the real problem is the .mdf file. this one increases from 10 Gb to 13 Gb. the log file has 5 gb, but i have delete it. so the other problem ist, that on normal use the db.file increases 3-4 Gb per year. so what strategy is the best way to shrink the .mdf file? thanks for your help best regards sascha Raul Llorente Peña/OPENSOLUTIONS [EMAIL PROTECTED] Gesendet von: Axapta-Knowledge-Village@yahoogroups.com 25.04.2005 18:09 Bitte antworten anAxapta-Knowledge-Village@yahoogroups.com An Axapta-Knowledge-Village@yahoogroups.com Kopie Thema Re: [Axapta-Knowledge-Village] After Upgrade DB increases over 13 GB Securely the most of increasing have been on Log file. Backup the BBDD, detach it, delete log file, and then reatach the data file. SQL will create a new, empty, very much smaller log file. SQL have provided some shrink options, but they are often few effective. Raúl Llorente Peña Análisis, Desarrollo e Implementación en Microsoft Bussiness Solutions-AxaptaOPEN SOLUTIONS 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 the Yahoo! Terms of Service. Sharing the knowledge on Axapta. __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 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 the Yahoo! Terms of Service. 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 the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Intercompany Sales Order and Purchase Order
Hi all, When i wantto create a Intercompany Sales Order the following messeage appears and the system stops me from creating Sales Order. " Conversion of Customer code was not specified" May i know is there any setting i miss out? Thanks in advance. Best Regards, Jack Koh __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 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 the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Intercompany Sales Order and Purchase Order
Did you click in the AR\Customers in the Sales Order Tab the intercompany checkbox? -- ___Sign-up for Ads Free at Mail.com http://www.mail.com/?sr=signup 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 the Yahoo! Terms of Service.