[development-axapta] import table in AOT

Hi guys, I want to import table from my XPO to Axapta (version 3). As usual I do it from AOT, import, then compare table first. There are field differences between GLS layer and USR layer (my XPO). Question is if I only want to import some of the new field in my XPO, how to do it? I see there

[development-axapta] Re: Carriage Return in SysMailer body

Hi all, This is a very old case. Has this problem been solved. Many thanks Regards, Anton --- In development-axapta@yahoogroups.com, Christoph Malherbe christoph.malhe...@... wrote: Hi Pascal, Thank you for taking time to respond. I tried your suggestion, but still no luck. Thanks

[development-axapta] Show hidden field in table browser

Hi all, how to show hidden field in table browser without changing its Visible property? Thanks, Anton

[development-axapta] Changing enum type in runtime

hi all, can enum type attached in field change in run time? details : I have field PurchQty which have enum type PurchQty. In my form, when I open the form contain that field, I don't want use enum PurchQty for the lookupvalue insted I want to use another enum type which I created by my self.

[development-axapta] DictTable

Hi guys, can anyone tell me what is the purpose of DicTable ? I found one of the class using that and don't know for sure the meaning. the class is LedgerJournalEngine_Payment in method Active ... if ( fieldNum(ledgerJournalTrans, dimension) == dictTable.fieldCnt2Id(i) ||

[development-axapta] SubQuery

Hi, How to write a subquery in X++ Select statement for ex in SQL Server : -- select * from CustTable where createddate = (select max (createddate) from Custtable) thanks, Yahoo! Groups Links To visit your group on the web, go

[development-axapta] Re: Lookup table for EDT ?

--- In development-axapta@yahoogroups.com, anton_tjiptadi [EMAIL PROTECTED] wrote: Hi, I want to add lookup table in my EDT which is relate to some table, ex : PurchTable. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group

[development-axapta] Lookup table for EDT ?

Hi, I want to add lookup table in my EDT which is relate to some table, ex : PurchTable. I want to filter the data to show only some record, for ex : data with Dimension(4) = TNG nb : this EDT, I'm gonna use it in Dialog so user can lookup table first to insert the value in that

[development-axapta] query range - like

I want to create query range with like and or criteria, something like this : (SQL Statement) select accountnum, voucher, * from ledgerjournaltrans where voucher like '%CPP%' or voucher like '%RV%' My statement rises an error if I wrote it like this one in X++ : sCrit = strFmt('((Voucher

[development-axapta] Fetchmode vs JoinMode

I'm a bit confuse about fetchmode and joinmode, what is exactly the two method means ? 'cause sometimes a report can use fetch mode, but with value of joinmode for example : QueryBuildDataSource1 = Query.adddatasource(tablenum(SalesTable)); QueryBuildDataSource2 =

[development-axapta] Group by ??

Hi, How to create X++ query for Group By ?? My select statement is simply like this (in Transact SQL) select a.salesid, sum(b.lineamount) from salestable a, salesline b where a.salesid=b.salesid group by a.salesid I try to build in X++ like this, but it cause error said that there's no

[development-axapta] 2 different AOT Structure, 2 different DB, in 1 Axapta Application ?

Hi, Is it possible to have 2 or more company account, 2 DB, and that 2 or more company account has its own AOT (in that case different objects) in 1 Axapta Application ? for example I have installed my Axapta application, and then I created : - 1 DB for company A and 1 DB for company B

[development-axapta] Re: 2 different AOT Structure, 2 different DB, in 1 Axapta Application ?

@yahoogroups.com, Pieter Wijnen [EMAIL PROTECTED] wrote: you need 2 folders under appl 1 for companyA 1 for companyB (you can elect to use standard for one of the apps) Pieter _ From: anton_tjiptadi [mailto:[EMAIL PROTECTED] Sent: 21. desember 2004 10:12 To: development-axapta

[development-axapta] Re: How to read temporary table ?

(this.Process_InventSum(BranchId,ItemGroup)); /.../ } Best regards, Arpad Melega From: anton_tjiptadi [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 2:50 AM To: [EMAIL PROTECTED] Subject: [development-axapta] How to read temporary

[development-axapta] How to read temporary table ?

Hi, I created a temporary table, but when i can't get fetch it in my report. this is my step : I. crate a method in my report. Process_InventSum(str _Branch, str _ItemGroup) { InventSum InventSum; InventTable InventTable; tmp_mlr_invt_sum tmpTable; ; while select sum(postedqty),

[development-axapta] Re: Get Current Company Account

works like a charmed... thanks man... --- In [EMAIL PROTECTED], Nitesh [EMAIL PROTECTED] wrote: Hi Anton By using the Function CurExt() u can get the code of Current company Account; Regards Nitesh - Original Message - From: anton_tjiptadi [EMAIL PROTECTED

[development-axapta] Re: Is there a system table in SQL SERVER which stores the current date?

hi, chen, why do you want to know that ? SQL has its built in function - getdate() to retrieve current date rgds, --- In [EMAIL PROTECTED], maipian_chen [EMAIL PROTECTED] wrote: thank you for your help Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups

[development-axapta] Re: Paper size for reporting

property.. thanks, --- In [EMAIL PROTECTED], Ahmed Ibrahim [EMAIL PROTECTED] wrote: Hi Anton , How you set the printing property to use Letter for PaperSize. I tried to find a property in the report to change the paper size but I couldn't. Regards Ahmed anton_tjiptadi

[development-axapta] Re: Paper size for reporting

properties, anmd printer setup and Create a New Form in there and Create a printer that uses that form. rocco -Original Message- From: anton_tjiptadi [mailto:[EMAIL PROTECTED] Sent: Wednesday, 15 December 2004 3:03 PM To: [EMAIL PROTECTED] Subject: [development-axapta] Paper

[development-axapta] Dialog.AddField - Error

Hi, I'm trying to add field input in my report class (overide method Dialog): -- dialogOptions = dialog.addField(typeid (MLR_VAT_OPTIONS),OP ,Options); dialogOptions is my variable with type DialogField, MLR_VAT_OPTIONS is my BaseEnum with style RadioButton and has two options (or

[development-axapta] Re: Dialog.AddField - Error, .................. solve 80% :)

PROTECTED], anton_tjiptadi [EMAIL PROTECTED] wrote: Hi, I'm trying to add field input in my report class (overide method Dialog): -- dialogOptions = dialog.addField(typeid (MLR_VAT_OPTIONS),OP ,Options); dialogOptions is my variable with type DialogField, MLR_VAT_OPTIONS is my BaseEnum

[development-axapta] string manipulation

Hi, how to manipulate string in Axapta. Like the old days : mytext --- left(string,2) -- my mytext --- right(string,3) --- ext mytext --- substring(string,3,2) --- in or format string like 01234567 displayed like 0-123-456-7 thanks, Yahoo! Groups Sponsor ADVERTISEMENT

[development-axapta] Re: Add DialogField in report

coming from AutoLookup Fieldgroup in table definitions right ? thanks again, Anton --- In [EMAIL PROTECTED], Max Belugin [EMAIL PROTECTED] wrote: Hello anton_tjiptadi, ïîíåäåëüíèê, 6 äåêàáðÿ 2004 ã., you wrote: a I'm trying to add dialog field to my report, code is below

[development-axapta] Re: Add DialogField in report

, --- In [EMAIL PROTECTED], Max Belugin [EMAIL PROTECTED] wrote: Hello anton_tjiptadi, ïîíåäåëüíèê, 6 äåêàáðÿ 2004 ã., you wrote: a Wow, thanks man, it works... :)) a uhmm.. one more thing, can the column in the autolookup dress up a a bit, 'cause the data seems to truncate for just a view

[development-axapta] Executing a report from a self made form

Hi, I want to run a report from Form, which I made it earlier, The Form supposed to cater user criteria first and then they click OK button, then the report runs. ps : I just created a Class to run the form and it can display the form, but I have no idea to do next ? btw, What is the

[development-axapta] Add DialogField in report

Hi all, I'm trying to add dialog field to my report, code is below : public Object dialog() { DialogRunBase dialog = super(); ; dialog.addGroup(Range); dialogTaxInvNo = dialog.addField(typeid (MLR_LedgerJournalTrans),Tax Invoice :,Tax Invoice Number); return dialog; } I've created

[development-axapta] can Axapta handle cursor ?

I used many table and temporary tables in my legacy program, some of that requires cursor or just a temporary table (like in SQL Server we do it by statement select * from tablename into #temptable). How's Axapta handle it ? thanks, Yahoo! Groups Sponsor ADVERTISEMENT

[development-axapta] clean up database

Hi, I want to clean up my data, so there's no data, even for master and transaction (just like new installation). How can I do this ? thanks, Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go

[development-axapta] Re: SQL Server doesn't listed when install Axapta ??

need this wizard. Patrick -Original Message- From: anton_tjiptadi [mailto:[EMAIL PROTECTED] Sent: vrijdag 26 november 2004 9:22 To: [EMAIL PROTECTED] Subject: [development-axapta] SQL Server doesn't listed when install Axapta ?? dear all, I'm trying to re

[development-axapta] SQL Server doesn't listed when install Axapta ??

dear all, I'm trying to re-install my Axapta (Remove program, drop database and new install again), but when I'm installing Axapta Client, in Create Database Wizard, list of Available Server is empty. can anyone help me ? FYI, My OS is Windows Server 2003 and SQL Server 2000 SP3 thanks

[development-axapta] using total pages

Hi all, does anyone know how to use element.pagestotal(), or there is other function to display total pages. Basically I want to display total pages in my Report Header ( ex: Page 2 of 10) thanks, Anton Yahoo! Groups Sponsor Get unlimited calls to U.S./Canada