RE: [Axapta-Knowledge-Village] Error on Transfer order

2007-10-04 Thread Lennart Conrad
A pallet transport will only be created for your shipment if a full pallet is requested. This is to optimize the process of moving items to the outbound dock. So if you have non-mixed pallets with 1500 pcs at a buffer location and your transfer order requires 1500 pcs a pallet transport should b

RE: [Axapta-Knowledge-Village] Is Triggers and Procedures are available in Axapta

2006-05-04 Thread Lennart Conrad
You can use the Statement (kernel class) to send SQL statements to the database. There are several examples in the application where this is used e.g \Classes\SysDataImport\recIdSimpleSqlSelect -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] O

RE: [Axapta-Knowledge-Village] InventUpd_ChildReference

2006-05-03 Thread Lennart Conrad
You are creating a movement based on salesLine which will result in an instance of InventMov_sales. This class does not override the insertChildBuffer(), hence you get the error (as designed). If you want to test the InventUpd_ChildReference class, you need a movement for a childbuffer, e.g In

RE: [Axapta-Knowledge-Village] SalesFormLetter.CheckSales()

2006-01-19 Thread Lennart Conrad
functionality. If credit limit check is set to none, the method would not perform the time consuming part of the check anyway, and it should not slow down performance. The code in SP4 and SP3 that I have access to looks identical. Regards /Lennart Conrad

RE: [Axapta-Knowledge-Village] Multi select in a form and perform operation

2006-01-18 Thread Lennart Conrad
You can use the following pattern: for (yourTable = yourTable_ds.getFirst(true) ? yourTable_ds.getFirst(true) : yourTable_ds.cursor();yourTable; yourTable = yourTable_ds.getNext()) { yourTable.doSomeThing(); } Regards Lennart Conrad -Original Message- From

RE: [Axapta-Knowledge-Village] Performance Issue

2005-12-20 Thread Lennart Conrad
Another small optimization: If you only use the name field in your TableBuffer you should only select that field While select Name from tb { } -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of mohit rajvanshy Sent: 20. december 2

RE: [Axapta-Knowledge-Village] How to get what is in picking registration

2005-12-19 Thread Lennart Conrad
form   Regards Lennart Conrad   From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James Flavell Sent: 16. december 2005 05:12 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] How to get what is in picking registration

RE: [Fwd: Re: [Axapta-Knowledge-Village] Find Label]

2005-04-19 Thread Lennart Conrad
(hours).   Lennart Conrad Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers no rights.   From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of gui_opentv Sent: 19. april 2005 17:28 To: Axapta-K

RE: [Fwd: Re: [Axapta-Knowledge-Village] Find Label]

2005-04-18 Thread Lennart Conrad
Could it be that your X-ref is not updated ?     Lennart Conrad Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers no rights.   From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Beha

RE: [Axapta-Knowledge-Village] Find Label

2005-04-16 Thread Lennart Conrad
Hi There is a Used by button in the label editor. It will present you a list of the places in the code where a label is used.   Lennart Conrad Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers no rights.   Fr

RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0

2005-03-16 Thread Lennart Conrad
Hi Daniel If you want to execute DELETE/INSERT/UPDATE etc. you must use the executeUpdate() method instead.   Lennart Conrad Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers no rights.   From: daniel lim [mai

RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0

2005-03-16 Thread Lennart Conrad
if you want to execute X++ sql syntax   Lennart Conrad Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers no rights.   From: daniel lim [mailto:[EMAIL PROTECTED] Sent: 16. marts 2005 08:37 To: Axapta-Knowledge-Village@yahoogroups

RE: [Axapta-Knowledge-Village] execute a SQL string in Axapta 3.0

2005-03-15 Thread Lennart Conrad
Hi Daniel   Take a look at the system class Statement and its documentation. Note that the SQL syntax should be “real” SQL and not Axapta sql   Lennart Conrad Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers

RE: [Axapta-Knowledge-Village] Re: How many tables r updated

2005-01-14 Thread Lennart Conrad
Hi Nishant   If you want to see which tables are updated you can enable SQL tracing under: Tools/Options/Sql.   Lennart Conrad Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers no rights.   From: Danny Gaetho