[Axapta-Knowledge-Village] Document Management
Hi All, Some advice please. I am using Ax4 Sp1. On the routings my customer wants to add Standard Operating procedures. I thought of using the note one the description tab of the Operation line on the route. Is it possible to attach a word document and when the route card is printed the SOP is printed at the same time? Regards [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Credit Note Misc. charges
Hi Yifat I assume you use the Functions -- create credit note. You will notice there is a selection Copy misc charges. If you select only ome line and the misc charge has been allocated to that line, only that particular charge will be reversed - as in standard Ax Cheers Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, yifath1 [EMAIL PROTECTED] wrote: hi all, I just want to verify something. My client applies a misc. charge on the purchase order, let say $100 for 5 items, therefore, the misc. charge per item is $20. Then the client returns 1 item to the supplier. i have tested this and it appears that the whole misc. charge is reversed... $100 is this correct? I think some modification has been done on this version of Axapta 3. Please can some one just verify and tell me what should happen when credit note is created and posted. we are using misc. charge as landed cost - whereby it is debiting the item and crediting a different account. Thanks Yifat
FW: [Axapta-Knowledge-Village] Pass temporary table data from form to report
Hi VG, This is the same as the passing the standart tables. For ex, the name of your temp table is : tmpCustBalances a. In the class decleration of report , declare temp table (you'll get the record buffer to this table) : TmpCustBalances _TmpCustBalances; b. In the init() method of the report, add this code : Ýf(element.args() element.args.record()) // control the parameters and set your temp table _tmpCustBalances = element.args.record(); You get the data now !! Also you must send the record to the report. c. If you call this report from menuitem, set DataSource propery of menuitembutton to temp table from the from. c. If you call this report from code, you must add args.record(TmpCustBalances); Regards, Anil Ozay MVP Dynamics AX From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of V G Sent: Sunday, January 06, 2008 6:21 PM To: Axapta-Knowledge-Village@yahoogroups.com; [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Pass temporary table data from form to report Hi I have a form where I insert data in a temporary table. From the form a report is called on the click of a menuitembutton. Is there a way that I can retreive the data of the temporary table(which is created in the form) in the report. Thanks in advance VG [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledge-village.tk Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/join (Yahoo! ID required) * To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * 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] str2num with comma as decimal separator
Hi Jerome, You are right, but you can add this function to Global class. static real str2NumFr (str strNumber) { ; strNumber = strreplace(strNumber, ',' , '.'); return str2num(strNumber); } I'm from Turkey and we have this problem too, and we solved it with this function. Regards, Anil Ozay MVP Dyanmics AX From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Jérôme Piquot Sent: Saturday, January 05, 2008 10:19 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] str2num with comma as decimal separator Hello, it seems that str2num does not take regional settings for converting strings to real. { str strNum = 125,45; // france decimal separator is , not . real num; num = str2num(strNum); // num will contain 125 } how can i convert numbers with decimal sépartor that is not . ? -- Cordialement, __ Jérôme Piquot Gédimat Wolff-Catenne 6, rue de la Gare 67120 Ernolsheim sur Bruche France Tél : +33 3 88 59 50 60 Fax: +33 1 41 30 17 34 Blog : http://piquot.spaces.live.com/ http://piquot.spaces.live.com/ __ Google Map pour Gédimat Wolff http://maps.google.fr/maps?f=q http://maps.google.fr/maps?f=qhl=frgeocode=time=date=ttype=q=gedimat+ wolffsll=47.15984,2.988281sspn=11.460679,20.43457num=10ie=UTF8ll=48.567 52,7.646484spn=0.174254,0.31929z=12iwloc=Aom=1 hl=frgeocode=time=date=ttype=q=gedimat+wolffsll=47.15984,2.988281ssp n=11.460679,20.43457num=10ie=UTF8ll=48.56752,7.646484spn=0.174254,0.3192 9z=12iwloc=Aom=1 [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledge-village.tk Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/join (Yahoo! ID required) * To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * 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] str2num with comma as decimal separator
Hi Anil, Thanks for your reply but I can have users localized in French or English. I need to have code that works for all regional settings. Cordialement, __ Jérôme Piquot Gédimat Wolff-Catenne 6, rue de la Gare 67120 Ernolsheim sur Bruche France Tél : +33 3 88 59 50 60 Fax: +33 1 41 30 17 34 Blog : http://piquot.spaces.live.com/ __ Google Map pour Gédimat Wolff -Message d'origine- De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de Anil Ozay Envoyé : lundi 7 janvier 2008 10:40 À : Axapta-Knowledge-Village@yahoogroups.com Objet : RE: [Axapta-Knowledge-Village] str2num with comma as decimal separator Hi Jerome, You are right, but you can add this function to Global class. static real str2NumFr (str strNumber) { ; strNumber = strreplace(strNumber, ',' , '.'); return str2num(strNumber); } I'm from Turkey and we have this problem too, and we solved it with this function. Regards, Anil Ozay MVP Dyanmics AX From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Jérôme Piquot Sent: Saturday, January 05, 2008 10:19 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] str2num with comma as decimal separator Hello, it seems that str2num does not take regional settings for converting strings to real. { str strNum = 125,45; // france decimal separator is , not . real num; num = str2num(strNum); // num will contain 125 } how can i convert numbers with decimal sépartor that is not . ? -- Cordialement, __ Jérôme Piquot Gédimat Wolff-Catenne 6, rue de la Gare 67120 Ernolsheim sur Bruche France Tél : +33 3 88 59 50 60 Fax: +33 1 41 30 17 34 Blog : http://piquot.spaces.live.com/ http://piquot.spaces.live.com/ __ Google Map pour Gédimat Wolff http://maps.google.fr/maps?f=q http://maps.google.fr/maps?f=qhl=frgeocode=time=date=ttype=q=gedimat+ wolffsll=47.15984,2.988281sspn=11.460679,20.43457num=10ie=UTF8ll=48.567 52,7.646484spn=0.174254,0.31929z=12iwloc=Aom=1 hl=frgeocode=time=date=ttype=q=gedimat+wolffsll=47.15984,2.988281ssp n=11.460679,20.43457num=10ie=UTF8ll=48.56752,7.646484spn=0.174254,0.3192 9z=12iwloc=Aom=1 [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledge-village.tk Yahoo! Groups Links
[Axapta-Knowledge-Village] Use .Net output parameters
Hi, I would like to call the static TryParse method (public static bool TryParse(string s, out double result); in System.Double .Net class) from X++. How can i use num as a .Net output parameter? { str strNum = 123,25; real num; ; System.Double::TryParse(nstr, num); } Cordialement, __ Jérôme Piquot Gédimat Wolff-Catenne 6, rue de la Gare 67120 Ernolsheim sur Bruche France Tél : +33 3 88 59 50 60 Fax: +33 1 41 30 17 34 Blog : http://piquot.spaces.live.com/ __
[Axapta-Knowledge-Village] Sales Return or Invoice Cancellation - How to Restore the Sales order Lines
Dear friends My client is using AX 3.0 with SP4. He creates a sales order with three lines of items For the line no 2, he made all the cycles upto invoicing. But due to practical difficulty, he was not able to despatch it and wish to cancel the invoice He used the feature Functions - Create Credit note and cancelled the invoice. But the order is not restored. Line No 2 has No delivery reminder. Can any help me to give him a solutio to get the order line restored. Regards S Ramanan Explore your hobbies and interests. Go to http://in.promos.yahoo.com/groups [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Batch JOb
Hi well guess if u set it to repeat every day then the next startdate / time is enddate/time + 24 hours. P. --- In Axapta-Knowledge-Village@yahoogroups.com, James Flavell [EMAIL PROTECTED] wrote: mmm interesting...never noticed but guess it might be the the new job in the queue is only added when the current batch finishes. If you have something that needs another batch job to finish first you should use the batch journal I believe this will make sure sequence is correct and not bother to run later jobs if the first fails etc All the best James _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of chuapatrickd Sent: 04 January 2008 21:24 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Batch JOb HI to all, I have setup a batch job to run at 03:30am but I was surprised the everyday it add a few minutes to the starting time so much so that after several day the starting time is already 03:39 am. Is this the actual behavior of axapta batch? is there a way to fixed the start time to 03:30 am ? I need this to be fixed at 03:30 since other system will need the file that is generated from the batch 5 minutes after. Thanks. regards, Patrick [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] mix/partial payment at time of sales invoice
Hi everyone, Is it possible to do partial payment of a sales invoice in standard Axapta? Example is the sales invoice is 150 dollars and the customer pays 100 dollars in cash and 50 dollars on credit card when the invoice is issued. Both payments I want to be processed at the time of posting the sales invoice but both types of payment have different end ledger accounts (one is cash and te other is credit card collections). The situation is in a retail environment so the user would not have access or time to create any type of journals The Automatic positng of payment journal on the method of payment is by default for the full amount as far as I am aware is this correct? Is there anyway of using the payment fee or payment step functions to achieve it? I ahve tried to think of a way but not come up with anything Thanks James [Non-text portions of this message have been removed]
Re: FW: [Axapta-Knowledge-Village] Pass temporary table data from form to report
Thanks a lot Anil. Vishal On Jan 7, 2008 4:31 AM, Anil Ozay [EMAIL PROTECTED] wrote: Hi VG, This is the same as the passing the standart tables. For ex, the name of your temp table is : tmpCustBalances a. In the class decleration of report , declare temp table (you'll get the record buffer to this table) : TmpCustBalances _TmpCustBalances; b. In the init() method of the report, add this code : Ýf(element.args() element.args.record()) // control the parameters and set your temp table _tmpCustBalances = element.args.record(); You get the data now !! Also you must send the record to the report. c. If you call this report from menuitem, set DataSource propery of menuitembutton to temp table from the from. c. If you call this report from code, you must add args.record(TmpCustBalances); Regards, Anil Ozay MVP Dynamics AX From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of V G Sent: Sunday, January 06, 2008 6:21 PM To: Axapta-Knowledge-Village@yahoogroups.com; [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Pass temporary table data from form to report Hi I have a form where I insert data in a temporary table. From the form a report is called on the click of a menuitembutton. Is there a way that I can retreive the data of the temporary table(which is created in the form) in the report. Thanks in advance VG [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledge-village.tk Yahoo! Groups Links [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] What are InventSumDateTable and InventSumDateTrans used for?
Sorry i am not sure whether I asked this before (but i guess even if I did then there was no answer so its worth asking again) Can someone please tell me or give me any idea what the InventSumDateTable and InventSumDateTrans tables are used for in AX4.0? I looked at them and thought they were for the function of 'Posting periodic physical' but even though I dont use that function they are getting populated and i would like to be sure as anything around InventSum is something that should be very clear about :) Thanks James [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Pass temporary table data from form to report
Hi group, Yes you can. Lets say your temporary table name is tmpTable1. In the init method of the report, type; tmpTable1 tmp; ; tmp = element.args.record(); tmp1.setTmpData(tmp); regardas Sahin, V G [EMAIL PROTECTED] wrote: Hi I have a form where I insert data in a temporary table. From the form a report is called on the click of a menuitembutton. Is there a way that I can retreive the data of the temporary table(which is created in the form) in the report. Thanks in advance VG [Non-text portions of this message have been removed] - Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] MB6-513 MorphX Exam
Do we have any kind of study groups on this site? I am going to take this exam soon and I was wondering if anyone had any advice. I have been studying the Dev III and Dev IV Microsoft manuals for AX 4.0, but there's so much information. Is there anything in particular I should focus on? Does anyone have any sample questions/topics that they would like to share? I'd be happy to come on here after I take it to give some info from it as well. It might be nice to have this group be a repository for people wanting to take the different exams. If we could gather some suggestions/advice, it could help a lot of people! Thanks, Amber
[Axapta-Knowledge-Village] MB6-513 MorphX Exam
Do we have any kind of study groups on this site? I am going to take this exam soon and I was wondering if anyone had any advice. I have been studying the Dev III and Dev IV Microsoft manuals for AX 4.0, but there's so much information. Is there anything in particular I should focus on? Does anyone have any sample questions/topics that they would like to share? I'd be happy to come on here after I take it to give some info from it as well. It might be nice to have this group be a repository for people wanting to take the different exams. If we could gather some suggestions/advice, it could help a lot of people! Thanks, Amber
[Axapta-Knowledge-Village] Re: Use .Net output parameters
You are in Ax 4.0 right? If so, can you Add System as a References in the AOT? regards, Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Jérôme Piquot [EMAIL PROTECTED] wrote: Hi, I would like to call the static TryParse method (public static bool TryParse(string s, out double result); in System.Double .Net class) from X++. How can i use num as a .Net output parameter? { str strNum = 123,25; real num; ; System.Double::TryParse(nstr, num); } Cordialement, __ Jérôme Piquot Gédimat Wolff-Catenne 6, rue de la Gare 67120 Ernolsheim sur Bruche France Tél : +33 3 88 59 50 60 Fax: +33 1 41 30 17 34 Blog : http://piquot.spaces.live.com/ __
RE: [Axapta-Knowledge-Village] Re: Use .Net output parameters
Hi, Thanks for your answer. The reference to System is set by default in AX 4.0. The problem is not to call a .Net method but to use output parameters. TryParse(string s, out double result). Cordialement, __ Jérôme Piquot Gédimat Wolff-Catenne 6, rue de la Gare 67120 Ernolsheim sur Bruche France Tél : +33 3 88 59 50 60 Fax: +33 1 41 30 17 34 Blog : http://piquot.spaces.live.com/ http://piquot.spaces.live.com/ __ Google Map pour Gédimat Wolff http://maps.google.fr/maps?f=qhl=frgeocode=time=date=ttype=q=gedimat+wolffsll=47.15984,2.988281sspn=11.460679,20.43457num=10ie=UTF8ll=48.56752,7.646484spn=0.174254,0.31929z=12iwloc=Aom=1 De : Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] De la part de Steeve Gilbert Envoyé : lundi 7 janvier 2008 19:37 À : Axapta-Knowledge-Village@yahoogroups.com Objet : [Axapta-Knowledge-Village] Re: Use .Net output parameters You are in Ax 4.0 right? If so, can you Add System as a References in the AOT? regards, Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com , Jérôme Piquot [EMAIL PROTECTED] wrote: Hi, I would like to call the static TryParse method (public static bool TryParse(string s, out double result); in System.Double .Net class) from X++. How can i use num as a .Net output parameter? { str strNum = 123,25; real num; ; System.Double::TryParse(nstr, num); } Cordialement, __ Jérôme Piquot Gédimat Wolff-Catenne 6, rue de la Gare 67120 Ernolsheim sur Bruche France Tél : +33 3 88 59 50 60 Fax: +33 1 41 30 17 34 Blog : http://piquot.spaces.live.com/ __ [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Where is the dataarea table?
Hi, That is a system table and you will NOT find in the AOT. You can open SSMS and see the table but its better if you dont try to modify it. Regards, Arijit On Jan 8, 2008 12:18 PM, Tarek Saleh [EMAIL PROTECTED] wrote: Dear All, can we customize in the dataarea table,by adding new field represent the company group. So far i was not able to find the table under the AOT table anybody knowes were i can find the table? and is it possible to add in new field in it. Thanks a lot Tarek - Looking for last minute shopping deals? Find them fast with Yahoo! Search. [Non-text portions of this message have been removed] -- Arijit Basu [Non-text portions of this message have been removed]