[Axapta-Knowledge-Village] Re: Where to handle tool tip in each column

Thanks :D --- In Axapta-Knowledge-Village@yahoogroups.com, manish saxena wrote: > > Hi, > The tooltip is created automatically by Ax from the field's main table form's > caption. > But you can override the tooltip for the fields using table method. I am not > in front of my system, but you can

[Axapta-Knowledge-Village] Re: On hand

Yes, I create it in table level, its in InventDim str VendBatch(ItemID _itemID) { ; if (_itemId) { return InventBatch::find(this.inventBatchId, _itemID).VendorBatch; // vendorbatch is my addition field in InventDim } else return ''; } But to parse the para

[Axapta-Knowledge-Village] Re: Inventory Transaction, Settle amount

Hi, Thanks, What about Return item, is the column updated also? Rgds, --- In Axapta-Knowledge-Village@yahoogroups.com, "Eddie" wrote: > > Hi Anton > > This is updated during the inventory closing process. > > > > --- In Axapta-Knowledge-Village@

[Axapta-Knowledge-Village] Inventory Transaction, Settle amount

Hi all, Refer to Inventory transaction (InventTrans Table), there is some columns : Financially closed, settle qty and amount settled. Under what condition these column updated? If it is a Return Order, is the settle amount/qty got updated? Thanks, Anton

[Axapta-Knowledge-Village] Re: Copy item table to another company/dataarea

Thanks Vijay, but I meant in coding :) --- In Axapta-Knowledge-Village@yahoogroups.com, "viju27_kumar" wrote: > > Export and import. > > Thanks, > Vijay > > --- In Axapta-Knowledge-Village@yahoogroups.com, "axaeffect" > wrote: > > > > Hi all, > > > > May I ask how to copy item table (Inven

Re: [Axapta-Knowledge-Village] Alternative workcenter with different process time

Hi, One possible solution could be to use field “Efficiency percentage” in work center card. This is the short description about the field in AX help file: “You can reduce or increase the processing time of individual jobs per day by using the efficiency percentage. Example If a job requires six

Re: [Axapta-Knowledge-Village] Overflow on Inventory cost for some items

/ivavgcostpricegrowth.htm The described hot fix doesn’t change old transactions – I think that it will be necessary to remove “Update General Ledger” field during inventory closing / reconciliation and to reconcile General Ledger with Inventory manually. Best regards Anton P.S. See an example that

Re: [Axapta-Knowledge-Village] Deletind transactions from a specific company

Hi Pradeep, There is a class “SysDatabaseTransDelete” that could be used to delete records from “Transaction” (in current company) tables. Tables with set-up data are not affected from this procedure (Customers, Vendors, Account etc.). Best regards, Anton Ivanov P.S. In AX 3.0 the name of the

[Axapta-Knowledge-Village] SubQuery in Axapta

Hi guys, did anyone knows how to use subquery in X++ development? for example, I have a query like this (in ANSI SQL) : select * from custpaymschedline a, custpaymsched b where a.parentrecid=b.recid and b.extrecid=-1999372754 and a.duedate= (select max(duedate) from custpaymschedline cl wher

[Axapta-Knowledge-Village] Export Financial Statement

Hi, In Report Financial Statement (menu GL - Reports - Transaction - Periodic), can the setup data (setup rows and colums) transported to another database, so we don't need to setup the report again ? Thanks in advance, Yahoo! Groups Sponsor ~

[Axapta-Knowledge-Village] running code / script before Data Import Export

Hi, I want to create and run some code before I execute Data Import Export (menu Administration - Period).. how can I do that ? for example : I want to import data to table CustTable, but first before Import/ Export started inserting my data, I want to delete existing data with createddate the

[Axapta-Knowledge-Village] Re: Delete Old Transaction/Data

ups.com, "Hardi" <[EMAIL PROTECTED] > wrote: > > Hi Anton > > May I know the reason you want to delete old transactions? > If the purpose is to have a new clean company database with all the > master data and setups from the old one, can't we just do export >

[Axapta-Knowledge-Village] Re: Delete Old Transaction/Data

-- In Axapta-Knowledge-Village@yahoogroups.com, Varden Morris <[EMAIL PROTECTED]> wrote: > > Hi Anton, > > There is a class in Axapta name DatabaseTransDelete that deletes all transactions from the database and you will have to access it from the AOT for obvious reason. &g

[Axapta-Knowledge-Village] Delete Old Transaction/Data

dear all, I wonder if I can delete all data from my axapta database, for example transaction data 2004 backward. how can i do that ? is there a function in axapta for that ? thanks in advance, Yahoo! Groups Sponsor ~--> Get fast access to your

[Axapta-Knowledge-Village] using number sequence

Hi guys, can anyone help me what's the easy and fastest way for using number sequence. I already create a number sequence in Axapta setup, now I want to use it in one of my coding, for example when I create a new document. I already see the example in some of the existing Axapta class, but sti

[Axapta-Knowledge-Village] Re: Parsing parameter from a FORM to CLASS

N C R E A S E - Y O U R B U S I N E S S > > > -Original Message- > From: Axapta-Knowledge-Village@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of Anton > Tjiptadi > Sent: 21. april 2005 13:40 > To: Axapta-Knowledge-Village@yahoogroups.com > Subject: [A

[Axapta-Knowledge-Village] Parsing parameter from a FORM to CLASS

Hi all, how to parsing variable inputed in the FORM to a CLASS ? I created a FORM and it that form there's a button to call a CLASS. I have a textbox for user input in the FORM and I want to parsing it so that inputed text known in the CLASS. I appreciate any help ? thanks in advance.

[Axapta-Knowledge-Village] Re: Run Report from a Form

ing a class which inherits from > runbasereport. In > > both cases you must call either the class or report from a menu > item. > > This menu item you just drag into the form design (preferably in a > > button group) and that's it. > > > > > > Best regards, > >

[Axapta-Knowledge-Village] Run Report from a Form

Hi, how to run reports from a Form. I plan to create 2 or more report and it will run under 1 form, so in that form will have 2 or more button, and when I clicked the button, it will run the corresponding report. thanks in advance, Yahoo! Groups Sponsor

[Axapta-Knowledge-Village] Re: Joining 3 tables with QueryBuildDataSource ?

se you should join qbs2 on qbs, not qbs1 > > /jesper > > -Ursprüngliche Nachricht- > Von: Anton Tjiptadi [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 6. April 2005 13:21 > An: Axapta-Knowledge-Village@yahoogroups.com > Betreff: [Axapta-Knowledge-Village] J

[Axapta-Knowledge-Village] Joining 3 tables with QueryBuildDataSource ?

Hi, I want to join 3 tables with QueryBuildDataSource (QBDS), the statement is like this : qbds = q.addDataSource(tablenum(InventJournalTrans)); qbds1 = qbds.addDataSource(tablenum(InventDim)); qbds1.joinMode(joinmode::InnerJoin); qbds1.addLink(fieldnum(InventDim, InventDimId),fieldnum (Inven

[Axapta-Knowledge-Village] Re: SQL Statement (crosstable / pivot table)

Hi Agus, thanks for your reply, but I guess I can't try it 'cause my company didn't buy the 'OLAP' things hahaha --- In Axapta-Knowledge-Village@yahoogroups.com, "Agus Riyadi" <[EMAIL PROTECTED]> wrote: > Hi Anton, > > You can use Axapta

[Axapta-Knowledge-Village] SQL Statement (crosstable / pivot table)

Hi guys, I want to create crosstable or pivot table from my data, for ex : Branch ItemAmount -- - --- Branch1 ItemA 10 Branch1 ItemB 10 Branch2 ItemB 10 Expected result: Item Branch1 Branch2 - ---

[Axapta-Knowledge-Village] Select Top 10 in Axapta

Hi, has anyone knows how to "Select Top 99..." in Axapta ? just like in SQL -> "Select Top 20 * from InventTable" thanks in advance Yahoo! Groups Sponsor ~--> Has someone you know been affected by illness or disease? Network for Good is THE pla