[Axapta-Knowledge-Village] Re: Section Printing in Report.
Hi,
From what I've just learned, I think you should add some statement
in Fetch Method in the report, such as :
While (qr.next())
{
(your data source) = qr.get(tablenum(your table));
.
.. //the calculation
if (YourAmount 0)
element.send(your data source); // or element.execute(x);
ret = true;
}
don't know it will help ? :)
rgds,
Anton
--- In [EMAIL PROTECTED], Ahmed Ibrahim
[EMAIL PROTECTED] wrote:
Tony,
Thanks so much but actually I want to prevent the printing of
bodysection if the return value of display methos is zero so how can
I bypass the printing of bodysection if value is zero?.
Thanks in advance.
Ahmed
Tony Depalo [EMAIL PROTECTED] wrote:
One way of doing this is to have your display method return a
str. Then within your display
display str yourAnswer()
{
if(your answer 0)
StrFmt('%1',YourAnswer;
return '';
}
I think there is a property Show Zero that might also work?
Tony
-Original Message-
From: mbsdeveloper [mailto:[EMAIL PROTECTED]
Sent: Monday, 6 December 2004 3:38 PM
To: [EMAIL PROTECTED]
Subject: [Axapta-Knowledge-Village] Section Printing in Report.
Dears,
I created a display method in the body section to do some
calculations, that works fine but actually I don't want the body
section to be printed if the value of the function is zero. so can
someone tell me how to do it?
regards
Ahmed
Sharing the knowledge on Axapta.
Sharing the knowledge on Axapta.
Yahoo! Groups SponsorADVERTISEMENT
-
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.
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Yahoo! Groups Sponsor ~--
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/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] Re: Section Printing in Report.
Hi Anton ,
thanks for your help.
Ahmedanton_tjiptadi [EMAIL PROTECTED] wrote:
Hi,From what I've just learned, I think you should add some statement in Fetch Method in the report, such as :While (qr.next()) { (your data source) = qr.get(tablenum(your table)); . .. //the calculation if (YourAmount 0) element.send(your data source); // or element.execute(x); ret = true; }don't know it will help ? :)rgds,Anton--- In [EMAIL PROTECTED], Ahmed Ibrahim [EMAIL PROTECTED] wrote:
Tony, Thanks so much but actually I want to prevent the printing of bodysection if the return value of display methos is zero so how can I bypass the printing of bodysection if value is zero?. Thanks in advance. Ahmed Tony Depalo [EMAIL PROTECTED] wrote: One way of doing this is to have your display method return a str. Then within your display display str yourAnswer() { if(your answer 0) StrFmt('%1',YourAnswer; return ''; } I think there is a property Show Zero that might also work? Tony -Original Message- From: mbsdeveloper [mailto:[EMAIL PROTECTED] Sent: Monday, 6 December 2004 3:38 PM To: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Section
Printing in Report. Dears, I created a display method in the body section to do some calculations, that works fine but actually I don't want the body section to be printed if the value of the function is zero. so can someone tell me how to do it? regards AhmedSharing the knowledge on Axapta. Sharing the knowledge on Axapta.Yahoo! Groups SponsorADVERTISEMENT - 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. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.comSharing the knowledge on Axapta.
Do you Yahoo!?
The all-new My Yahoo! Get yours free!
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] Label file system
Hi everyone, I am currently going through a hard time getting the label system to work when exporting some changes (in an xpo) to another Axapta system. Although during the import process, the labels are clearly being imported (label details tab on import dialog), only the references (e.g.: @QWE12123) subsequently show up in the objects where the labels have been used. To make things simpler, I am currently ensuring that only the en-gb version of the labels are being exported. To sum up my query: 1) How can you delete a label file system in Axapta (previously created using the Label Wizard)? I tried removing the *.ald files but to no avail. 2) Is there some 'foolproof' system to ensure that labels will work once they get to the testing/user environment? Best Regards, J.Chircop, Malta. 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/
YNT: [Axapta-Knowledge-Village] packing slip error
Thanks i solved it. Kimden: Sun Fen [mailto:[EMAIL PROTECTED] Gnderilmi: Pzt 06.12.2004 06:56 Kime: [EMAIL PROTECTED] Konu: Re: [Axapta-Knowledge-Village] packing slip error Hi, For under delivery message : Have you checked the Accept Under delivery setup in AP Parameter and in the Purchase line? For physical updating quantity: This could be caused by the unit conversion cause i have face similar problem. Check the conversion calculation for the quantity that you are going to receive and the inventory quantity that will be stored. Regards, AFEN - Original Message - From: Cenk Ince mailto:[EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 03, 2004 10:59 PM Subject: [Axapta-Knowledge-Village] packing slip error Hi all I get error when i post purchorder as packingslip. Physical updating quantity in the inventory unit '' must be other than zero Under-delivery of line is 100,00 percent, but the allowed under-delivery is only 0,00 percent. I create the purchline with code and i think that i miss something. Because for example i can't see Inventory Registration on my purchline. Please help. Cenk NCE ERP Teknik Danman (Microsoft Axapta) ERP Technical Consultant (Microsoft Axapta) Data Sistem Genel Otomasyon Sanayi ve Ticaret A.S www.datasistem.com.tr http://www.datasistem.com.tr/ Tel : 0232 463 16 63 (Dah: 128) Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT click here http://us.ard.yahoo.com/SIG=129cii75l/M=298184.5639630.6699735.3001176/D=groups/S=1705001380:HM/EXP=1102396078/A=2434971/R=0/SIG=11eeoolb0/*http://www.netflix.com/Default?mqso=60185400 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] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . 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/ winmail.dat
RE: [Axapta-Knowledge-Village] DIFFERENCE BETWEEN FINANCIAL AND PHYSICAL INVENTORY VALUES
Thank you Gulan I will investigate further to see if there are any other hidden costs which we may not have taken into account. I do agree with you though,that for standard costing if the quantities are equal one should get the same amount. Regards Des _ From: Van Den Langenbergh Gunther [mailto:[EMAIL PROTECTED] Sent: 03 December 2004 02:53 PM To: [EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] DIFFERENCE BETWEEN FINANCIAL AND PHYSICAL INVENTORY VALUES Also in production you have the same difference between physical amount and financial amount (like with a purchase: packing slip: physical and invoice: financial). Physical amount you could consider as an temporary amount (must be ON in inventory model group). If i'm not mistaken: a production is also a receipt and creates a physical amount when reported as finished (temporary) and a financial when costing (postcalculation) = definitive. Although I never used standard cost price as a validation method (I mainly use AWP) I saw that physical amount was based on qty * costprice (from item table) and financial was the real costprice (i.e. total of components and operations). So in case of FIFO or AWP this will definatly always be different. I only don't know what Axapta takes in case of standard costprice. I should think: the totals of (QTY's * the standard cost of component) and totals of operations or maybe QTY * (standard cost of your produced item). But the last one seems to me not logic and it that case ofcourse you would end op with the same amount (if the qty's where equal). Gulan _ From: Des Patsourellis [mailto:[EMAIL PROTECTED] Sent: vrijdag 3 december 2004 12:23 To: [EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] DIFFERENCE BETWEEN FINANCIAL AND PHYSICAL INVENTORY VALUES Thank you for your reply Gulan There was definitely no change in the cost price between the finished and costing phases as we are testing in a very controlled environment. What do you understand the difference between physical and financial inventory to be ? We have done further testing and each production order seems to create a variance between these two values. We have also tried switching off the financial inventory posting in the inventory model group,but then nothing is posted to the finished goods and work in progress accounts (posting only happens to the report as finished accounts). Regards Des _ From: Van Den Langenbergh Gunther [mailto:[EMAIL PROTECTED] Sent: 03 December 2004 11:06 AM To: [EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] DIFFERENCE BETWEEN FINANCIAL AND PHYSICAL INVENTORY VALUES Hi, I'm not sure but I remember that standard costprice also should be recalculated/closed (according to a specified model) Although receipts and issues are posted at standard costprice their could be manual changes to the items costprice. Maybe their was a change in costprice between reported as finished and the time of costing the production order. gulan -Original Message- From: despo1812 [mailto:[EMAIL PROTECTED] Sent: woensdag 1 december 2004 14:47 To: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] DIFFERENCE BETWEEN FINANCIAL AND PHYSICAL INVENTORY VALUES Hi everyone, I would appreciate your help on the following: I have created a production order which carries a cost of R191.70 When analyzing the integration entries in the Chart of Accounts I noticed the system posts Physical Inventory to the value of R191.66 and Financial Inventory to the value of R191.25 and posts the difference to Inventory Adjustment Profit. If one is using Std cost why does it generate this difference? Kind regards, 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 Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT http://us.ard.yahoo.com/SIG=1297fch33/M=294855.5468653.6549235.3001176/D=gr oups/S=1705001380:HM/EXP=1102164808/A=2376776/R=0/SIG=11ldm1jvc/*http:/promo tions.yahoo.com/ydomains2004/index.html click here http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=groups/S= :HM/A=2376776/rand=648509585 _ 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] mailto:[EMAIL PROTECTED] ribe * Your use of Yahoo! Groups is subject to the Yahoo! Terms of http://docs.yahoo.com/info/terms/ Service. Yahoo! Groups Sponsor
RE: [Axapta-Knowledge-Village] Purpose of Axapta Tables
That would be great if you help me for thesame. I keen to know it. AhmedHennie Potgieter [EMAIL PROTECTED] wrote: If you find this, I would like to see it too.This would be a tremendous help.Hennie-Original Message-From: madtrs [mailto:[EMAIL PROTECTED] Sent: Friday, 03 December 2004 20:38 PMTo: [EMAIL PROTECTED]Subject: [Axapta-Knowledge-Village] Purpose of Axapta TablesHello,Does anyone know where I can find a reference toAxapta tables? I'd like to know what tables arepopulated when a sales order is created? What tablesare created when an invoice is created and posts, etc?Thanks... __ Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more.http://info.mail.yahoo.com/mail_250Sharing the knowledge on Axapta. Yahoo! Groups LinksSharing 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] inventory journal
Dear, I made an inventory journal for a profit/loss (2 pieces for a certain item). I posted it. When I look at the net requirements for the article, I still see an a reference to my inventory journal (quantity = -1 ???). Normally it should be gone(because its posted) I need to get rid of this reference because the journal is posted... how can I do this? Kind regards, Jeroen Vangheluwe Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/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] Section Printing in Report.
Peng, I'm sorry, I could't understand what is meaning by YourSession and where can I write this code. I appreciate if you could give me more clarifications. Regards AhmedPeng Qing Hua [EMAIL PROTECTED] wrote: Hi, ahmed Can you do some like this? If (SomeFiledValue==0) YourSession.visable(false);Best Regard!Andy. Peng Qing hua-Original Message-From: mbsdeveloper [mailto:[EMAIL PROTECTED] Sent: 2004Äê12ÔÂ6ÈÕ 13:38To: [EMAIL PROTECTED]Subject: [Axapta-Knowledge-Village] Section Printing in Report.Dears,I created a display method in the body section to do some calculations, that works fine but actually I don't want the body section to be printed if the value of the function is zero. so can someone tell me how to do it? regards AhmedSharing the knowledge on Axapta. Yahoo! Groups LinksSharing the knowledge on Axapta. Do you Yahoo!? The all-new My Yahoo! What will yours do? 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] Section Printing in Report.
Hi Ahmed
All you need to do is make the call to super() in the executeSection method of the section conditional. That is, override the executeSection method of the section that you want to print conditionally and do something like this:
if (FunctionValue() != 0)
{
super(); }
This means that if whatever function value you are checking for is not equal to zero print the section otherwise don't print it. The curly brackets are not necessary in the case since only one statement follows but I use it for illustration.
VardenMorris
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]m
[EMAIL PROTECTED]m
Ahmed Ibrahim [EMAIL PROTECTED] wrote:
Peng,
I'm sorry, I could't understand what is meaning by YourSession and where can I write this code. I appreciate if you could give me more clarifications.
Regards
AhmedPeng Qing Hua [EMAIL PROTECTED] wrote:
Hi, ahmed Can you do some like this? If (SomeFiledValue==0) YourSession.visable(false);Best Regard!Andy. Peng Qing hua-Original Message-From: mbsdeveloper [mailto:[EMAIL PROTECTED] Sent: 2004Äê12ÔÂ6ÈÕ 13:38To: [EMAIL PROTECTED]Subject: [Axapta-Knowledge-Village] Section Printing in Report.Dears,I created a display method in the body section to do some calculations, that works fine but actually I don't want the body section to be printed if the value of the function is zero. so can someone tell me how to do it? regards AhmedSharing the knowledge on Axapta. Yahoo! Groups
LinksSharing the knowledge on Axapta.
Do you Yahoo!?The all-new My Yahoo! What will yours do? Sharing the knowledge on Axapta.
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search. Learn more.
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] QueryBuildRange question
Dear all, I added a QueryBuildRange to my query. I expected that when opening the Criteria column I would see all the unique values available in my table but I do not. I believe I understand the reason, but while I am not sure, I just want to have some input of you. I think it is because I am not using a field that is indexed. It happens I am using a field that is part of an index. This is the QueryBuildRange I added to my query: qryBuildRange = qryBuildDataSource.addRange(FieldNum(Address, AddrTableID)); The field AddrTableId is part of the index AddreIdx, which contains the fields AddrRecId and LineNum. How can I get the full list of available values shown in the column criteria? regards, Danny Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/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] Section Printing in Report.
Varden,
Thanks, it's working fine
Regards
AhmedVarden Morris [EMAIL PROTECTED] wrote:
Hi Ahmed
All you need to do is make the call to super() in the executeSection method of the section conditional. That is, override the executeSection method of the section that you want to print conditionally and do something like this:
if (FunctionValue() != 0)
{
super(); }
This means that if whatever function value you are checking for is not equal to zero print the section otherwise don't print it. The curly brackets are not necessary in the case since only one statement follows but I use it for illustration.
VardenMorris
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]m
[EMAIL PROTECTED]m
Ahmed Ibrahim [EMAIL PROTECTED] wrote:
Peng,
I'm sorry, I could't understand what is meaning by YourSession and where can I write this code. I appreciate if you could give me more clarifications.
Regards
AhmedPeng Qing Hua [EMAIL PROTECTED] wrote:
Hi, ahmed Can you do some like this? If (SomeFiledValue==0) YourSession.visable(false);Best Regard!Andy. Peng Qing hua-Original Message-From: mbsdeveloper [mailto:[EMAIL PROTECTED] Sent: 2004Äê12ÔÂ6ÈÕ 13:38To: [EMAIL PROTECTED]Subject: [Axapta-Knowledge-Village] Section Printing in Report.Dears,I created a display method in the body section to do some calculations, that works fine but actually I don't want the body section to be printed if the value of the function is zero. so can someone tell me how to do it? regards AhmedSharing the knowledge on Axapta. Yahoo! Groups
LinksSharing the knowledge on Axapta.
Do you Yahoo!?The all-new My Yahoo! What will yours do? Sharing the knowledge on Axapta.
Do you Yahoo!?Yahoo! Mail - Find what you need with new enhanced search. Learn more. Sharing the knowledge on Axapta.
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
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] Section Printing in Report.
You are most welcome.Ahmed Ibrahim [EMAIL PROTECTED] wrote:
Varden,
Thanks, it's working fine
Regards
AhmedVarden Morris [EMAIL PROTECTED] wrote:
Hi Ahmed
All you need to do is make the call to super() in the executeSection method of the section conditional. That is, override the executeSection method of the section that you want to print conditionally and do something like this:
if (FunctionValue() != 0)
{
super(); }
This means that if whatever function value you are checking for is not equal to zero print the section otherwise don't print it. The curly brackets are not necessary in the case since only one statement follows but I use it for illustration.
VardenMorris
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]m
[EMAIL PROTECTED]m
Ahmed Ibrahim [EMAIL PROTECTED] wrote:
Peng,
I'm sorry, I could't understand what is meaning by YourSession and where can I write this code. I appreciate if you could give me more clarifications.
Regards
AhmedPeng Qing Hua [EMAIL PROTECTED] wrote:
Hi, ahmed Can you do some like this? If (SomeFiledValue==0) YourSession.visable(false);Best Regard!Andy. Peng Qing hua-Original Message-From: mbsdeveloper [mailto:[EMAIL PROTECTED] Sent: 2004Äê12ÔÂ6ÈÕ 13:38To: [EMAIL PROTECTED]Subject: [Axapta-Knowledge-Village] Section Printing in Report.Dears,I created a display method in the body section to do some calculations, that works fine but actually I don't want the body section to be printed if the value of the function is zero. so can someone tell me how to do it? regards AhmedSharing the knowledge on Axapta. Yahoo! Groups
LinksSharing the knowledge on Axapta.
Do you Yahoo!?The all-new My Yahoo! What will yours do? Sharing the knowledge on Axapta.
Do you Yahoo!?Yahoo! Mail - Find what you need with new enhanced search. Learn more. Sharing the knowledge on Axapta.
Do you Yahoo!?Read only the mail you want - Yahoo! Mail SpamGuard. Sharing the knowledge on Axapta.
Do you Yahoo!?
Meet the all-new My Yahoo! Try it today!
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] QueryBuildRange question
There's not link between fields in indexes and range not being there. Try pressing Reset when you see the range columns. In what method did you add your range? Steeve... -Message d'origine- De : Danny Gaethofs [mailto:[EMAIL PROTECTED] Envoyé : 6 décembre 2004 06:23 À : [EMAIL PROTECTED] Objet : [Axapta-Knowledge-Village] QueryBuildRange question Dear all, I added a QueryBuildRange to my query. I expected that when opening the Criteria column I would see all the unique values available in my table but I do not. I believe I understand the reason, but while I am not sure, I just want to have some input of you. I think it is because I am not using a field that is indexed. It happens I am using a field that is part of an index. This is the QueryBuildRange I added to my query: qryBuildRange = qryBuildDataSource.addRange(FieldNum(Address, AddrTableID)); The field AddrTableId is part of the index AddreIdx, which contains the fields AddrRecId and LineNum. How can I get the full list of available values shown in the column criteria? regards, Danny Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/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: RE : [Axapta-Knowledge-Village] QueryBuildRange question
it is just a job I am running --- In [EMAIL PROTECTED], Steeve Gilbert [EMAIL PROTECTED] wrote: There's not link between fields in indexes and range not being there. Try pressing Reset when you see the range columns. In what method did you add your range? Steeve... -Message d'origine- De : Danny Gaethofs [mailto:[EMAIL PROTECTED] Envoyé : 6 décembre 2004 06:23 À : [EMAIL PROTECTED] Objet : [Axapta-Knowledge-Village] QueryBuildRange question Dear all, I added a QueryBuildRange to my query. I expected that when opening the Criteria column I would see all the unique values available in my table but I do not. I believe I understand the reason, but while I am not sure, I just want to have some input of you. I think it is because I am not using a field that is indexed. It happens I am using a field that is part of an index. This is the QueryBuildRange I added to my query: qryBuildRange = qryBuildDataSource.addRange(FieldNum(Address, AddrTableID)); The field AddrTableId is part of the index AddreIdx, which contains the fields AddrRecId and LineNum. How can I get the full list of available values shown in the column criteria? regards, Danny Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/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] constructor problem or ..
I am new to Axapta.
Axapta supports overloading. This is what help says..
But I can not define constructors with diffrent parameters
for a class..
Example;
void new(){...}
void new(str _to, str _from, str _subject, str _body ){...}
Gökhan Mutlu
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] unbalanced x++ ttsbegin/ttscommit
put the ttsbegin after
if (qryRunAddress.prompt()) and then close the
transaction by ttscommit accordingly.
cheers,
Girish
--- Danny Gaethofs [EMAIL PROTECTED] wrote:
-
dear all,
I am writing a job to update some values on a table
based on input
from the user.
The user is presented a query input form and can enter
a value.
The whole job is intended to enable users to correct
the relations
between alternate addresses and custtable.
The job now generates an unbalanced x++
ttsbegin/ttscommit error,
which I am unable to resolve. Is there someone that
can help me out.
Hereafter part of the job.
static void UTIL_CreateAddressRelation(Args _args)
{
Address address;
CustTable custTable;
Query qryAddress;
QueryRunqryRunAddress;
QueryBuildDataSourceqryBuildDataSource;
QueryBuildRange qryBuildRange;
qryAddress = new Query();
qryBuildDataSource =
qryAddress.addDataSource(TableNum
(Address));
qryBuildRange =
qryBuildDataSource.addRange(FieldNum
(Address, AddrTableId));
qryBuildRange.value(*);
qryBuildDataSource.update(true);
/* begin transaction */
ttsbegin;
qryRunAddress = new QueryRun(qryAddress);
if (qryRunAddress.prompt()) // here is where
the query starts
{
while (qryRunAddress.next())
{
address =
qryRunAddress.get(TableNum(Address));
print address.Name;
print address.AddrRecId;
print address.AddrTableId;
print address.AddrTableId == 77;
pause;
switch (address.AddrTableId)
{
case 77:
{
select custTable
where custTable.AccountNum
== 4002;
if (custTable)
{
print
custTable.AccountNum;
pause;
ttsbegin;
address.AddrRecId =
custTable.RecId;
address.update();
ttscommit;
}
break;
}
default:
print Default; pause;
} // end switch
} // end while
} // end if
/* end transaction */
ttscommit;
}
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.
__
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail
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] unbalanced x++ ttsbegin/ttscommit
here between the ttsbegin and ttscommit try to avoid
entering the pause. you could use debugging to find
the values or else you could put the pause after
ttscommit.
--- Danny Gaethofs [EMAIL PROTECTED] wrote:
-
dear all,
I am writing a job to update some values on a table
based on input
from the user.
The user is presented a query input form and can enter
a value.
The whole job is intended to enable users to correct
the relations
between alternate addresses and custtable.
The job now generates an unbalanced x++
ttsbegin/ttscommit error,
which I am unable to resolve. Is there someone that
can help me out.
Hereafter part of the job.
static void UTIL_CreateAddressRelation(Args _args)
{
Address address;
CustTable custTable;
Query qryAddress;
QueryRunqryRunAddress;
QueryBuildDataSourceqryBuildDataSource;
QueryBuildRange qryBuildRange;
qryAddress = new Query();
qryBuildDataSource =
qryAddress.addDataSource(TableNum
(Address));
qryBuildRange =
qryBuildDataSource.addRange(FieldNum
(Address, AddrTableId));
qryBuildRange.value(*);
qryBuildDataSource.update(true);
/* begin transaction */
ttsbegin;
qryRunAddress = new QueryRun(qryAddress);
if (qryRunAddress.prompt()) // here is where
the query starts
{
while (qryRunAddress.next())
{
address =
qryRunAddress.get(TableNum(Address));
print address.Name;
print address.AddrRecId;
print address.AddrTableId;
print address.AddrTableId == 77;
pause;
switch (address.AddrTableId)
{
case 77:
{
select custTable
where custTable.AccountNum
== 4002;
if (custTable)
{
print
custTable.AccountNum;
pause;
ttsbegin;
address.AddrRecId =
custTable.RecId;
address.update();
ttscommit;
}
break;
}
default:
print Default; pause;
} // end switch
} // end while
} // end if
/* end transaction */
ttscommit;
}
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.
__
Do you Yahoo!?
Yahoo! Mail - Easier than ever with enhanced search. Learn more.
http://info.mail.yahoo.com/mail_250
Yahoo! Groups Sponsor ~--
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/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] unbalanced x++ ttsbegin/ttscommit
You cant have UI between tts statements, move your ttsbegin
down in the code some after the prompt (UI)
Don
-Original Message-
From: Danny Gaethofs
[mailto:[EMAIL PROTECTED]
Sent: Monday, December 06, 2004
8:57 AM
To:
[EMAIL PROTECTED]
Subject:
[Axapta-Knowledge-Village] unbalanced x++ ttsbegin/ttscommit
dear all,
I am writing a job to update some values on a
table based on input
from the user.
The user is presented a query input form and can
enter a value.
The whole job is intended to enable users to
correct the relations
between alternate addresses and custtable.
The job now generates an unbalanced x++
ttsbegin/ttscommit error,
which I am unable to resolve. Is there someone
that can help me out.
Hereafter part of the job.
static void UTIL_CreateAddressRelation(Args _args)
{
Address
address;
CustTable
custTable;
Query
qryAddress;
QueryRun
qryRunAddress;
QueryBuildDataSource qryBuildDataSource;
QueryBuildRange qryBuildRange;
qryAddress
= new Query();
qryBuildDataSource =
qryAddress.addDataSource(TableNum
(Address));
qryBuildRange =
qryBuildDataSource.addRange(FieldNum
(Address, AddrTableId));
qryBuildRange.value(*);
qryBuildDataSource.update(true);
/* begin transaction */
ttsbegin;
qryRunAddress = new QueryRun(qryAddress);
if
(qryRunAddress.prompt()) // here is where the query starts
{
while (qryRunAddress.next())
{
address = qryRunAddress.get(TableNum(Address));
print address.Name;
print address.AddrRecId;
print address.AddrTableId;
print address.AddrTableId == 77;
pause;
switch (address.AddrTableId)
{
case 77:
{
select custTable
where custTable.AccountNum == 4002;
if (custTable)
{
print custTable.AccountNum;
pause;
ttsbegin;
address.AddrRecId = custTable.RecId;
address.update();
ttscommit;
}
break;
}
default:
print Default; pause;
} // end switch
} // end while
} //
end if
/* end transaction */
ttscommit;
}
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: unbalanced x++ ttsbegin/ttscommit
dear Girish,
Thanks a lot! The problem is solved. I got rid of the unbalance by
moving the ttsbegin down the prompt and closing it accordingly.
regards,
Danny
--- In [EMAIL PROTECTED], Girish B
[EMAIL PROTECTED] wrote:
put the ttsbegin after
if (qryRunAddress.prompt()) and then close the
transaction by ttscommit accordingly.
cheers,
Girish
--- Danny Gaethofs [EMAIL PROTECTED] wrote:
-
dear all,
I am writing a job to update some values on a table
based on input
from the user.
The user is presented a query input form and can enter
a value.
The whole job is intended to enable users to correct
the relations
between alternate addresses and custtable.
The job now generates an unbalanced x++
ttsbegin/ttscommit error,
which I am unable to resolve. Is there someone that
can help me out.
Hereafter part of the job.
static void UTIL_CreateAddressRelation(Args _args)
{
Address address;
CustTable custTable;
Query qryAddress;
QueryRunqryRunAddress;
QueryBuildDataSourceqryBuildDataSource;
QueryBuildRange qryBuildRange;
qryAddress = new Query();
qryBuildDataSource =
qryAddress.addDataSource(TableNum
(Address));
qryBuildRange =
qryBuildDataSource.addRange(FieldNum
(Address, AddrTableId));
qryBuildRange.value(*);
qryBuildDataSource.update(true);
/* begin transaction */
ttsbegin;
qryRunAddress = new QueryRun(qryAddress);
if (qryRunAddress.prompt()) // here is where
the query starts
{
while (qryRunAddress.next())
{
address =
qryRunAddress.get(TableNum(Address));
print address.Name;
print address.AddrRecId;
print address.AddrTableId;
print address.AddrTableId == 77;
pause;
switch (address.AddrTableId)
{
case 77:
{
select custTable
where custTable.AccountNum
== 4002;
if (custTable)
{
print
custTable.AccountNum;
pause;
ttsbegin;
address.AddrRecId =
custTable.RecId;
address.update();
ttscommit;
}
break;
}
default:
print Default; pause;
} // end switch
} // end while
} // end if
/* end transaction */
ttscommit;
}
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.
__
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail
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] Find RecId
Dear all, I have a small question. I have a table that contains a field of type string. This fields contains values that correspond to recid's in another table. Now I want to use the first table and find the records in the other table. I am looking for a way to search for recid's based on values in a string field. Something like select table where RecId == (stringfield) How can I transform the stringfield into a recid type or vice versa ? the function any2str is not working regards, Danny Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/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/
AW: [Axapta-Knowledge-Village] Find RecId
num2str() ? -Ursprngliche Nachricht- Von: Danny Gaethofs [mailto:[EMAIL PROTECTED] Gesendet: Mo 06.12.2004 16:26 An: [EMAIL PROTECTED] Cc: Betreff: [Axapta-Knowledge-Village] Find RecId Dear all, I have a small question. I have a table that contains a field of type string. This fields contains values that correspond to recid's in another table. Now I want to use the first table and find the records in the other table. I am looking for a way to search for recid's based on values in a string field. Something like select table where RecId == (stringfield) How can I transform the stringfield into a recid type or vice versa ? the function any2str is not working regards, Danny Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/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/ winmail.dat
[Axapta-Knowledge-Village] Re: Find RecId
Andreas,
No that is not working.
You can check it when you print for example:
print custTable.name + num2str(custTable.RecId)
Now that is not what I am trying to do but it gives me the quickest
result to check whether it is possible.
regards and thanks anyway,
Danny
--- In [EMAIL PROTECTED], Andrae, Tobias
[EMAIL PROTECTED] wrote:
num2str() ?
-Ursprüngliche Nachricht-
Von: Danny Gaethofs [mailto:[EMAIL PROTECTED]
Gesendet: Mo 06.12.2004 16:26
An: [EMAIL PROTECTED]
Cc:
Betreff: [Axapta-Knowledge-Village] Find RecId
Dear all,
I have a small question. I have a table that contains a
field of
type string. This fields contains values that correspond to
recid's
in another table. Now I want to use the first table and find
the
records in the other table.
I am looking for a way to search for recid's based on values
in a
string field. Something like
select table
where RecId == (stringfield)
How can I transform the stringfield into a recid type or
vice versa ?
the function any2str is not working
regards,
Danny
Yahoo! Groups Sponsor --
--~--
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/kGEolB/TM
-
---~-
Sharing the knowledge on Axapta.
Yahoo! Groups Links
Yahoo! Groups Sponsor ~--
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/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/
AW: [Axapta-Knowledge-Village] Re: Find RecId
of course jour job will not work, because I just hit the wrong method ;-// I
meant int2str() which converts a int to a string, while num2str() needs some
more params (just must have earned a syntax error while trying).
br, Tobias
-Ursprngliche Nachricht-
Von: Danny Gaethofs [mailto:[EMAIL PROTECTED]
Gesendet: Mo 06.12.2004 16:44
An: [EMAIL PROTECTED]
Cc:
Betreff: [Axapta-Knowledge-Village] Re: Find RecId
Andreas,
No that is not working.
You can check it when you print for example:
print custTable.name + num2str(custTable.RecId)
Now that is not what I am trying to do but it gives me the quickest
result to check whether it is possible.
regards and thanks anyway,
Danny
--- In [EMAIL PROTECTED], Andrae, Tobias
[EMAIL PROTECTED] wrote:
num2str() ?
-Ursprngliche Nachricht-
Von: Danny Gaethofs [mailto:[EMAIL PROTECTED]
Gesendet: Mo 06.12.2004 16:26
An: [EMAIL PROTECTED]
Cc:
Betreff: [Axapta-Knowledge-Village] Find RecId
Dear all,
I have a small question. I have a table that contains a
field of
type string. This fields contains values that correspond to
recid's
in another table. Now I want to use the first table and find
the
records in the other table.
I am looking for a way to search for recid's based on values
in a
string field. Something like
select table
where RecId == (stringfield)
How can I transform the stringfield into a recid type or
vice versa ?
the function any2str is not working
regards,
Danny
Yahoo! Groups Sponsor --
--~--
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/kGEolB/TM
-
---~-
Sharing the knowledge on Axapta.
Yahoo! Groups Links
Yahoo! Groups Sponsor ~--
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/kGEolB/TM
~-
Sharing the knowledge on Axapta.
Yahoo! Groups Links
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/
winmail.dat
Re: RE : RE : [Axapta-Knowledge-Village] QueryBuildRange question
Dear Steeve, See my previous message on the unbalance ttsbegin/ttscommit. That is the job. Have a look at it. When I run it I am only see one record in the list that pops up when I open the field criteria. regards, Danny --- In [EMAIL PROTECTED], Steeve Gilbert [EMAIL PROTECTED] wrote: Can you send your job here? Steeve... -Message d'origine- De : Danny Gaethofs [mailto:[EMAIL PROTECTED] Envoyé : 6 décembre 2004 09:14 À : [EMAIL PROTECTED] Objet : Re: RE : [Axapta-Knowledge-Village] QueryBuildRange question it is just a job I am running --- In [EMAIL PROTECTED], Steeve Gilbert [EMAIL PROTECTED] wrote: There's not link between fields in indexes and range not being there. Try pressing Reset when you see the range columns. In what method did you add your range? Steeve... -Message d'origine- De : Danny Gaethofs [mailto:[EMAIL PROTECTED] Envoyé : 6 décembre 2004 06:23 À : [EMAIL PROTECTED] Objet : [Axapta-Knowledge-Village] QueryBuildRange question Dear all, I added a QueryBuildRange to my query. I expected that when opening the Criteria column I would see all the unique values available in my table but I do not. I believe I understand the reason, but while I am not sure, I just want to have some input of you. I think it is because I am not using a field that is indexed. It happens I am using a field that is part of an index. This is the QueryBuildRange I added to my query: qryBuildRange = qryBuildDataSource.addRange(FieldNum(Address, AddrTableID)); The field AddrTableId is part of the index AddreIdx, which contains the fields AddrRecId and LineNum. How can I get the full list of available values shown in the column criteria? regards, Danny Sharing the knowledge on Axapta. Yahoo! Groups Links Sharing the knowledge on Axapta. Yahoo! Groups Links 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] Re: Label file system
No idea anyone? (no this is not an exam question) --- In [EMAIL PROTECTED], axaptagrp [EMAIL PROTECTED] wrote: Hi everyone, I am currently going through a hard time getting the label system to work when exporting some changes (in an xpo) to another Axapta system. Although during the import process, the labels are clearly being imported (label details tab on import dialog), only the references (e.g.: @QWE12123) subsequently show up in the objects where the labels have been used. To make things simpler, I am currently ensuring that only the en-gb version of the labels are being exported. To sum up my query: 1) How can you delete a label file system in Axapta (previously created using the Label Wizard)? I tried removing the *.ald files but to no avail. 2) Is there some 'foolproof' system to ensure that labels will work once they get to the testing/user environment? Best Regards, J.Chircop, Malta. Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/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 : RE : RE : [Axapta-Knowledge-Village] QueryBuildRange question
Just tried the job and... I have no answer for you. I don't understand why it behave like that. Steeve... -Message d'origine- De : Danny Gaethofs [mailto:[EMAIL PROTECTED] Envoyé : 6 décembre 2004 11:39 À : [EMAIL PROTECTED] Objet : Re: RE : RE : [Axapta-Knowledge-Village] QueryBuildRange question Dear Steeve, See my previous message on the unbalance ttsbegin/ttscommit. That is the job. Have a look at it. When I run it I am only see one record in the list that pops up when I open the field criteria. regards, Danny --- In [EMAIL PROTECTED], Steeve Gilbert [EMAIL PROTECTED] wrote: Can you send your job here? Steeve... -Message d'origine- De : Danny Gaethofs [mailto:[EMAIL PROTECTED] Envoyé : 6 décembre 2004 09:14 À : [EMAIL PROTECTED] Objet : Re: RE : [Axapta-Knowledge-Village] QueryBuildRange question it is just a job I am running --- In [EMAIL PROTECTED], Steeve Gilbert [EMAIL PROTECTED] wrote: There's not link between fields in indexes and range not being there. Try pressing Reset when you see the range columns. In what method did you add your range? Steeve... -Message d'origine- De : Danny Gaethofs [mailto:[EMAIL PROTECTED] Envoyé : 6 décembre 2004 06:23 À : [EMAIL PROTECTED] Objet : [Axapta-Knowledge-Village] QueryBuildRange question Dear all, I added a QueryBuildRange to my query. I expected that when opening the Criteria column I would see all the unique values available in my table but I do not. I believe I understand the reason, but while I am not sure, I just want to have some input of you. I think it is because I am not using a field that is indexed. It happens I am using a field that is part of an index. This is the QueryBuildRange I added to my query: qryBuildRange = qryBuildDataSource.addRange(FieldNum(Address, AddrTableID)); The field AddrTableId is part of the index AddreIdx, which contains the fields AddrRecId and LineNum. How can I get the full list of available values shown in the column criteria? regards, Danny Sharing the knowledge on Axapta. Yahoo! Groups Links Sharing the knowledge on Axapta. Yahoo! Groups Links Sharing the knowledge on Axapta. Yahoo! Groups Links 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] Add cost to inventory and recalculate issues on month closing
Hello everybody, We've been working with Axapta for about one year and we're currently developing one little module do add some direct and indirect cost based on Ledger Accounts using a cost month closing journal and job (splitting direct cost for salary for example into the orders that have time appointment in the month, and indirect costs like Administrative cost based in total hours appointed in the orders, then update de inventory and after, the ledger), there's no problem with this. But we need to add this cost to the inventory, we're currently researching to use the InventTransAdjust class that fills the field adjust for a specified inventTrans voucher. This is the most correct way to do this? Another question is, as we use de average cost, and our issues was with the previous cost, does the Inventory month closing will adjust all the issues for the goods??? For example, the cost of a semi- manufactured good will change with this (as we add´s up the cost with InventTransAdjust), and consequently the cost of finish manufactured good have to change to production order cost + semi- manufactured cost (the new one with that InventTransAdjust adjustment) + the amount that we add up to the order with InventTransAdjust. Example: Production Order 1 : semi manufactured have to be adjusted in $10 due administrative and other direct costs (this process its ok, no problem with that) + std Axapta cost ( not touched, BOM cost + cost of work centers, already in the inventory when the production order was finished) = $100 Production Order 2 : finish manufactured good 1 have to be adjusted in $33 due administrative and other direct costs (this process its ok, no problem with that) + std Axapta cost ( not touched, BOM cost + cost of work centers, already in the inventory when the production order was finished) = $120 Finish good 1 120 + 10 + 33 | | - semi manufactured100 + 10 As it is, all the issues for finish good 1 has to be corrected in 43 when we run the inventory month closing and adjust. And the issues for semi manufactured have to be corrected in 10. This can be tested if we purchase some raw material, product some semi manufactured good with it, product another finish good with the semi- manufactured good then sell it. Turn back on purchase invoice for the raw material and adjust the cost with the misc. charges function, all the cost tree has to be changed. Does Axapta do this??? Thanks Rodrigo Matiazo [EMAIL PROTECTED] Cadia Consulting do Brasil Ltda. Av. Eng. Luis Carlos Berrini, 1091 2º andar Edifício A R S Cep. 04571-010 - Brooklin - SP Tel. (55-11) 5505-0173 Fax. (55-11) 5505-0659 www.cadia-consulting.com.br Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/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] Re: Purpose of Axapta Tables
Dear Ahmed, Hennie, Start by looking at the form SalesTable. You will see the data sources that are used, SalesLine, SalesTable, InventDim. These are the tables that are directly used in some way. For sure the salesline and salestable are used. When an invoice is created you clicked the button posting. This will ultimately activate the class SalesFormLetter_Invoice. Tables populated during that process are for example: CustInvoiceJour, SalesParmTable, SalesParmLine, ... But it is possible if you activate buttons and functionality behind it that you update other tables. It goes too far to explain all of it. Best is you start looking at the form. Let us know precisely what you are looking for. regards, Danny --- In [EMAIL PROTECTED], Ahmed Ibrahim [EMAIL PROTECTED] wrote: That would be great if you help me for the same. I keen to know it. Ahmed Hennie Potgieter [EMAIL PROTECTED] wrote: If you find this, I would like to see it too. This would be a tremendous help. Hennie -Original Message- From: madtrs [mailto:[EMAIL PROTECTED] Sent: Friday, 03 December 2004 20:38 PM To: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Purpose of Axapta Tables Hello, Does anyone know where I can find a reference to Axapta tables? I'd like to know what tables are populated when a sales order is created? What tables are created when an invoice is created and posts, etc? Thanks... __ Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. http://info.mail.yahoo.com/mail_250 Sharing the knowledge on Axapta. Yahoo! Groups Links Sharing the knowledge on Axapta. Yahoo! Groups SponsorADVERTISEMENT - 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. - Do you Yahoo!? Yahoo! Mail - You care about security. So do we. 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/
AW: [Axapta-Knowledge-Village] Syncronization error - Invalid object name 'INFORMATION_SCHEMA.VIEWS'
Hi
Preston,
you
are right. The views in the master database has not the owner
INFORMATION_SCHEMA.
I used
your sql script to fix the owner.
Now
everything works great (the syncronization).
Thank
you.
Ursprngliche
Nachricht-Von: Preston A. Larimer
[mailto:[EMAIL PROTECTED]Gesendet: Freitag, 3. Dezember 2004
20:06An: [EMAIL PROTECTED]Betreff:
RE: [Axapta-Knowledge-Village] Syncronization error - Invalid object name
'INFORMATION_SCHEMA.VIEWS'
Using Enterprise
Manager look at the Master database, and the views in it, you should see the
following views
'SCHEMATA',
'TABLES',
'TABLE_CONSTRAINTS',
'TABLE_PRIVILEGES',
'COLUMNS',
'COLUMN_DOMAIN_USAGE',
'COLUMN_PRIVILEGES',
'DOMAINS',
'DOMAIN_CONSTRAINTS',
'KEY_COLUMN_USAGE',
'REFERENTIAL_CONSTRAINTS',
'CHECK_CONSTRAINTS',
'CONSTRAINT_TABLE_USAGE',
'CONSTRAINT_COLUMN_USAGE',
'VIEWS',
'VIEW_TABLE_USAGE',
'VIEW_COLUMN_USAGE',
'ROUTINES',
'PARAMETERS',
'ROUTINE_COLUMNS'
All of these views
should be owned by INFORMATION_SCHEMA, if they exist and are owned by another
account you can get this error, another cause could be the sql server is set
up with case sensitivity, but if that was your problem you would most likely
have other issues as well.. If the views exist and the owner is just
wrong run this script via query analyzer to fix the
owner.
--Script
Start
use
Master
go
exec sp_configure 'allow updates', 1
reconfigure WITH OVERRIDE
go
Begin Transaction
update sysObjects
set uid = user_id('INFORMATION_SCHEMA')
where name in(
'SCHEMATA',
'TABLES',
'TABLE_CONSTRAINTS',
'TABLE_PRIVILEGES',
'COLUMNS',
'COLUMN_DOMAIN_USAGE',
'COLUMN_PRIVILEGES',
'DOMAINS',
'DOMAIN_CONSTRAINTS',
'KEY_COLUMN_USAGE',
'REFERENTIAL_CONSTRAINTS',
'CHECK_CONSTRAINTS',
'CONSTRAINT_TABLE_USAGE',
'CONSTRAINT_COLUMN_USAGE',
'VIEWS',
'VIEW_TABLE_USAGE',
'VIEW_COLUMN_USAGE',
'ROUTINES',
'PARAMETERS',
'ROUTINE_COLUMNS'
)
Commit Transaction
go
exec sp_configure 'allow updates', 0
reconfigure WITH OVERRIDE
--Script
End
-Preston
From: El
Caramba [mailto:[EMAIL PROTECTED] Sent: Friday, December 03, 2004 1:33
PMTo: Development-Axapta;
Axapta-Knowledge-VillageSubject: [Axapta-Knowledge-Village]
Syncronization error - Invalid object name
'INFORMATION_SCHEMA.VIEWS'
Hi all,when I try to syncronize Axapta, I get some error messages
like this:[Microsoft][ODBC
SQL Server Driver][SQL Server]Invalid object name'INFORMATION_SCHEMA.VIEWS'.(IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS
WHERETABLE_NAME =
'PROJCOMMITTEDCOSTPROJECTVIEW') DROP VIEWPROJCOMMITTEDCOSTPROJECTVIEW)All in all I get 14 error messages, all like the one
above.But when i take a look into
the AOT there are more than 20 Views.For some Views i get no error
message.Where is the
problem?Can sombody help
me??Thanks in
advance.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] Document Management
Hi all, Document management functionality allows us to add all sorts of documents to table records. Incoming, outgoing mail, word documents, outgoing faxes, and so on. Looking at these documents however I notice that you have to create entries in document management for a document or else it will not become visible. Secondly when you delete an entry the document is also deleted from the file location. Some questions: - Is it possible to have document management create its own catalog from files in a folder? The reason for asking is that I have incoming faxes which are stored in a folder and I want these to be available for searching in document management. But I do not want to raise each of these as entries in document management manually. - How can I prevent documents from being deleted once the entry is removed from document management. - Has anyone worked with Indexing Services? Made it possible to connect all information related to a customer for searching . regards, Don 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] String Manipulation
Hi, what is the syntax for string manipulation in X++, for ex (in VB): MyText -- left(string,2) -- My MyText -- right(string,4) -- Text MyText -- Substring(string,4,2) -- ex or format string like 0123456789 to be display like 01-234-567- 8.9 thanks, Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/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] String Manipulation
See AOT System Documentation Functions for all the string manipulation functions available in X++ viz: stralpha,strcmp,strcolseq, strdel,strfind,strins,strkeep,strlen,strline,strtrim,strlwr,substr etc. You can do pretty nifty stuff with combinations of these functions. Hennie -Original Message- From: anton_tjiptadi [mailto:[EMAIL PROTECTED] Sent: Tuesday, 07 December 2004 06:23 AM To: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] String Manipulation Hi, what is the syntax for string manipulation in X++, for ex (in VB): MyText -- left(string,2) -- My MyText -- right(string,4) -- Text MyText -- Substring(string,4,2) -- ex or format string like 0123456789 to be display like 01-234-567- 8.9 thanks, Sharing the knowledge on Axapta. Yahoo! Groups Links 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[2]: [Axapta-Knowledge-Village] String Manipulation
Hello Hennie Potgieter, , 7 2004 ., you wrote: See AOT System Documentation Functions for all the string HP manipulation functions available in X++ viz: HP stralpha,strcmp,strcolseq, HP strdel,strfind,strins,strkeep,strlen,strline,strtrim,strlwr,substr etc. HP You can do pretty nifty stuff with combinations of these functions. and the TextBuffer class... -- Best regards, Max http://belugin.newmail.ru ICQ:9406811 Yahoo! Groups Sponsor ~-- $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/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/
