[Axapta-Knowledge-Village] Re: Temp Table in Report
Hi,
You should assign the content of your temporaryTable variable to the
table variable declared as member of the report Query.
Eg.
You `ve created a Temporary Table named TmpTable.
This table is the source of your report.
So in the init you should write something like this: (where
TmpTableQuery is the name of the Table in your report Query).
TmpTable tmpTableFill;
;
While(
)
{
tmpTableFill.insert();
}
TmpTableQuery.setTmpData(tmpTableFill);
Hope this will do,
Greetz,
Yoni
--- In [EMAIL PROTECTED], Steen Rabøl
<[EMAIL PROTECTED]> wrote:
> Hi
>
>
>
> It's very hard to tell you what is wrong with out knowing what you
have done
> ;-)
>
>
>
> Best
>
> Steen Rabøl
>
>
>
> _
>
> From: mbsdeveloper [mailto:[EMAIL PROTECTED]
> Sent: 28. november 2004 08:52
> To: [EMAIL PROTECTED]
> Subject: [Axapta-Knowledge-Village] Temp Table in Report
>
>
>
>
>
> 1-I tried to use temp table and show the data from temp table in
> report since I fill-in the temp table on "init" trigger of the
report
> but unfortunality it's not showing anything. is it possible to use
a
> temp table in the report? please advise.
>
>
> regards
> Ahmed
>
>
>
>
>
>
>
> Sharing the knowledge on Axapta.
>
>
>
>
>
>
> Yahoo! Groups Sponsor
>
>
>
> ADVERTISEMENT
>
>
oups/S=1705001380:HM/EXP=1101711121/A=2434971/R=0/SIG=11eeoolb0/*http
:/www.n
> etflix.com/Default?mqso=60185400> click here
>
>
>
> :HM/A=2434971/rand=933627721>
>
>
>
> _
>
> 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]
> ribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo!
>
RE: [Axapta-Knowledge-Village] Temp Table in Report
Hi,
You should assign the content of your temporaryTable
variable to the table variable declared as member of the report Query.
Eg.
You ‘ve created a Temporary Table
named TmpTable.
This table is the source of your report.
So in the init you should write something
like this: (where TmpTableQuery is the name of the Table in your report Query).
TmpTable tmpTableFill;
;
While(…)
{
…
tmpTableFill.insert();
}
TmpTableQuery.setTmpData(tmpTableFill);
Hope this will do,
Greetz,
Yoni
From: Steen Rabøl
[mailto:[EMAIL PROTECTED]
Sent: zondag 28 november 2004 8:29
To:
[EMAIL PROTECTED]
Subject: RE:
[Axapta-Knowledge-Village] Temp Table in Report
Hi
It’s very hard to
tell you what is wrong with out knowing what you have done ;-)
Best
Steen Rabøl
From: mbsdeveloper
[mailto:[EMAIL PROTECTED]
Sent: 28. november 2004 08:52
To: [EMAIL PROTECTED]
Subject: [Axapta-Knowledge-Village]
Temp Table in Report
1-I tried to use temp table and show the data from
temp table in
report since I fill-in the temp table on
"init" trigger of the report
but unfortunality it's not showing anything. is it
possible to use a
temp table in the report? please advise.
regards
Ahmed
Sharing
the knowledge on Axapta.
Sharing the knowledge on Axapta.
Sharing the knowledge on Axapta.
Yahoo! Groups Sponsor
ADVERTISEMENT
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] Re: Temp Table in Report
Hi,
You should assign the content of your temporaryTable variable to the
table variable declared as member of the report Query.
Eg.
You `ve created a Temporary Table named TmpTable.
This table is the source of your report.
So in the init you should write something like this: (where
TmpTableQuery is the name of the Table in your report Query).
TmpTable tmpTableFill;
;
While(
)
{
tmpTableFill.insert();
}
TmpTableQuery.setTmpData(tmpTableFill);
Hope this will do,
Greetz,
Yoni
--- In [EMAIL PROTECTED], Steen Rabøl
<[EMAIL PROTECTED]> wrote:
> Hi
>
>
>
> It's very hard to tell you what is wrong with out knowing what you
have done
> ;-)
>
>
>
> Best
>
> Steen Rabøl
>
>
>
> _
>
> From: mbsdeveloper [mailto:[EMAIL PROTECTED]
> Sent: 28. november 2004 08:52
> To: [EMAIL PROTECTED]
> Subject: [Axapta-Knowledge-Village] Temp Table in Report
>
>
>
>
>
> 1-I tried to use temp table and show the data from temp table in
> report since I fill-in the temp table on "init" trigger of the
report
> but unfortunality it's not showing anything. is it possible to use
a
> temp table in the report? please advise.
>
>
> regards
> Ahmed
>
>
>
>
>
>
>
> Sharing the knowledge on Axapta.
>
>
>
>
>
>
> Yahoo! Groups Sponsor
>
>
>
> ADVERTISEMENT
>
>
oups/S=1705001380:HM/EXP=1101711121/A=2434971/R=0/SIG=11eeoolb0/*http
:/www.n
> etflix.com/Default?mqso=60185400> click here
>
>
>
> :HM/A=2434971/rand=933627721>
>
>
>
> _
>
> 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]
> ribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo!
>
[Axapta-Knowledge-Village] Axapta Professionals, can you please assist us?
Dear Axapta Professionals, Can you please assist us? We need 20 Axapta Software Engineers (possessing at least two years Axapta experience) for a major endeavor in Denmark. Do you have Axapta colleagues not presently employed by Microsoft (or its affiliates) that may be looking for work? We would like to help them advance their careers. Please let me know if you can help. Thank you very much. Best regards, Frank Labriola President Systems Resource Corp Office: 817-893-0033 Fax: 817-893-0032 Cell: 516-384-4987 email: [EMAIL PROTECTED] Yahoo! Groups Sponsor ~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/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] Global table methods
Hi Ahmed,
There are two type of map in axapta. The first is in Data Dictionary | Maps. The second is map class.
For this problem, you should only consider the first one. Data Dictionary | Map is a table definition for the use of mapping ussually two or more tables. For example: In SalesPurchTable Map, there is SalesPurchId field and it is used to map between SalesTable.SalesId and PurchTable.PurchId.
If you create a method at SalesPurchTable Map (ex: void test () {}), then you can call from SalesTable table, by using :: operator.
SalesTable a;
;
a.SalesPurchTable::test(); //the format is: myTable.myMap::myMethod
If you have a method test2 at SalesTable table, then you may call it from SalesPurchTable Map. For this example, we can modifiy SalesPurchTable.test method:
void test()
{
this.test2(); //this will call table method.
//warning: Both mapped-table (SalesTable and PurchTable) should have test2 method.
}
So, for your problem, you can probably override validateWrite method on the tables and use a map for validating those tables in one place (at the map).
at MyMap Map:
public boolean validateWrite(){ boolean ret = false;
//my validation
return ret;}
at MyTable1 Table and MyTable2 Table:
public boolean validateWrite(){ boolean ret = this.MyMap::validateWrite();
return ret;}
Regards,
Sonny Wibawa Adi
Ahmed Ibrahim <[EMAIL PROTECTED]> wrote:
Varden Morris,
Could you please brief me about the actual use of MAP. I read the help documents reg. MAP but I want to know the actual use.
regards
Ahmed
Varden Morris <[EMAIL PROTECTED]> wrote:
I think the xRecord system class has methods that are common to all tables but the fact that it is a system method means that you cannot modify it. The only solution I can think of is using a MAP. In this case you will have to manually map all tables to this MAP and then use the required method(s) from the MAP in the mapped tables.
Varden Morris
J. Wray & Nephew Ltd. - Group I.S.
234 Spanish Town Road
Kingston 11, Jamaica, W.I.
Phone: (876) - 923 - 6141 Ext. 2400, 2412Fax: (876) - 923 - 5372
Cell: (876) - 3833566Email: [EMAIL PROTECTED] [EMAIL PROTECTED]Take a guess <[EMAIL PROTECTED]> wrote:
Hi Guys,Is there any way it is possible to set up global table methods in Axapta?E.g. validation that would have to happen when any record in any table.Regards,CarstenSharing the knowledge on Axapta.
Do you Yahoo!?The all-new My Yahoo! Get yours free! Sharing the knowledge on Axapta.
Do you Yahoo!?The all-new My Yahoo! Get yours free! Sharing the knowledge on Axapta.
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
Sharing the knowledge on Axapta.
Yahoo! Groups Sponsor
ADVERTISEMENT
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] Problem in Web-Deployment
can you send me a documents reg. web installation in axapta. I tried but it's not working at all. regards Ahmed"B.B.Padhi" <[EMAIL PROTECTED]> wrote: HiWe have some problem in accessing AXAPTA in webbrowser.We have installed Application/server/client in onePC.Web deployment is also done there.The Virtualdirectory created at C:\Navision\Web Deployment\Axaptafolder.So in the installed PC if you typehttp:\\\Axapta\home.htm then we aregetting the active-X control and on clicking it wecould able to access AXAPTA -client.But in a different PC which is in the same domain andnetwork we are not getting the active-X control at allin the web browser.What could be the reason forthis.Ur early help will be appreciated.RegardsB.B.PadhiBangaloreIndia __ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com Sharing the knowledge on Axapta. Do you Yahoo!? All your favorites on one personal page Try My Yahoo! Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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] Numbering Sequence - Your opinions
Hi Subrahmanyam Mamidi, I haven't tried this before, but as you can see, the PurchTableType class have many child classes and this class have numberSeqFormHandlerPurchId method. So, for each type, you may tried to create a new number seqence. You may try this: For each PurchTableType_ ... class, override numberSeqFormHandlerPurchId method. Copy the format from PurchTableType.numberSeqFormHandlerPurchId method and change PurchParameters::numRefPurchId().NumberSequence code with other number sequence reference. Btw, if you don't know how to create new num seq reference, go to our yahoogroups files and find the number sequence documentation. Regards, Sonny Wibawa Adi Subrahmanyam Mamidi <[EMAIL PROTECTED]> wrote: Hi, Axapta allows to use only one type NumSeq to create purchase orders. This is really not a good idea to use the same sequence for different types of Purchase Types. For example, for a regular PO and a blanket also, it uses the same number sequence. Does anyone in this forum know to assign different Number sequences for different Purchase Types?. Any Opinions on this from the forum experts???. Any ideas where to look at?. Thanks, Subbu Do you Yahoo!?Take Yahoo! Mail with you! Get it on your mobile phone. Sharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Mail - You care about security. So do we. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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] Problem in Web-Deployment
Hi We have some problem in accessing AXAPTA in web browser. We have installed Application/server/client in one PC.Web deployment is also done there.The Virtual directory created at C:\Navision\Web Deployment\Axapta folder.So in the installed PC if you type http:\\\Axapta\home.htm then we are getting the active-X control and on clicking it we could able to access AXAPTA -client. But in a different PC which is in the same domain and network we are not getting the active-X control at all in the web browser.What could be the reason for this.Ur early help will be appreciated. Regards B.B.Padhi Bangalore India __ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com Yahoo! Groups Sponsor ~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/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/
[Axapta-Knowledge-Village] Upgrading Ax2.5 to Ax3.0SP3 , Language field missing
Hi All, I upgraded Axapta2.5SP3MP to Axapta3.0SP3. Everything went smoothly. But after upgradation , i found the language field ( almost everywhere CustTable, VendTable, SalesOrder, Purchase Order) is missing. The data for this field has not populated in tha Axapta3.0SP3. Is anyone ever experinced this problem?? Any ideas to fix this??? Thanks in Advance Regards Akash __ Do you Yahoo!? The all-new My Yahoo! - Get yours free! http://my.yahoo.com Yahoo! Groups Sponsor ~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/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/
