[Axapta-Knowledge-Village] Re: Subquery

2005-01-24 Thread henrik3.rm
Hi, try this; Custtable Custtable; ; select firstonly Custtable order by createdDate desc; regards, Henrik Østergård computercamp DK --- In Axapta-Knowledge-Village@yahoogroups.com, anton_tjiptadi [EMAIL PROTECTED] wrote: Hi, How to write a subquery in X++ Select statement for

[Axapta-Knowledge-Village] Price variance between purchase order invoice

2005-01-24 Thread despo1812
Hello everyone I am sure that a number of you have been faced with the problem that I have experienced. I have a received purchase order to the value of 523.15 . The supplier invoice which I have registered and posted is 525.00. When trying to approve the invoice and to link the purchase

[Axapta-Knowledge-Village] External Item ID not printing in invoice reports

2005-01-24 Thread otter_77_owns
I have setup external itemids and descriptions on many vendors. Under the form setup I have selected your for item number on forms. The vendor print management is set to use default values from form setup. On the purchase order report the external itemid and description print as expected.

[Axapta-Knowledge-Village] Re: Is Once Only a bug in Ax3.0 - SUpplementary Items

2005-01-24 Thread jaxxnrhyno
Subbu, Are you running any service packs? I was able to test your scenario on 3.0SP3 okay. What is your exact problem? Does your supplementary item not come thru on the sales order window after calculation or does it not even display on the Calculated supplementary items window?

Re: [Axapta-Knowledge-Village] Re: Is Once Only a bug in Ax3.0 - SUpplementary Items

2005-01-24 Thread Subrahmanyam Mamidi
Hi George, Thank you for the email. We are running SP3 AX3. I can see my supplementary item showup and when I hit ok, the corresponding sales lines are getting created to the particular Salesorder . But problem is, when I selected 'Only once'. it should add only one time to that particular

[Axapta-Knowledge-Village] Prinint Muliple Invocies

2005-01-24 Thread Rocco Giumelli
Hi all Has anyone found an Easy way to Print out multiple Invoices from the Projects\Inquiries\Invoice\Invoice. The Invoice Journal Won't do the Invoice print needs to look like it was printed Normally, not as a Journal Report. Previously Someone Suggested Using the

[Axapta-Knowledge-Village] Re: Subquery

2005-01-24 Thread anton_tjiptadi
well, not the way I'm expected, but thanks though :)) I guess there's a limitation in X++ query thanks, --- In Axapta-Knowledge-Village@yahoogroups.com, akin [EMAIL PROTECTED] wrote: anton_tjiptadi how about this code: custtable _table1,_table2; date

Re: [Axapta-Knowledge-Village] Re: Is Once Only a bug in Ax3.0 - SUpplementary Items

2005-01-24 Thread sunfen
Hi Subbu, It is a bug allright. 'Once only' should only create one order line only. I have experienced this long time ago when using SP2. In SP3 seems not fixed yet. Regards, Sun Fen -Original Message- From: Subrahmanyam Mamidi [EMAIL PROTECTED] To:

[Axapta-Knowledge-Village] Web Form Windows-based Form

2005-01-24 Thread mchiat
Hi all, Can anyone tell me if what is the difference of these 2? I roughly know that web form is used for EP which allows user to input data through web whereas Windows-based are those standard forms in axapta. Currently the lincense for web form and windows-based form need to be