[Axapta-Knowledge-Village] Cost Price
Hi everyone, Is there any table which keep record for 'cost price' for Item in InventTable ? For example, for every month, Item in InventTable who had transaction SO or PO, always make changes in 'cost price'. So I want to take 'cost price for that item Is there any ? Or I should count again everytime i need 'cost price' ? Thanks before for the answer - setiaji -
RE: [Axapta-Knowledge-Village] AX: Workflow
Standard AX doesn't however there's an add-on written by company called FolioDev which does exactly what you've been asking for. It works for both, Standard client and the Portal. The add on is called PSA (professional services automation) Regards, Shahzad Butt From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Faiqa Khushi Sent: 07 June 2007 08:12 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] AX: Workflow Importance: High Does Axapta provide any Workflow feature ? Like a user creates a requisition and it automatically forward to the Purchase department for approval. Please let me know even if we can get it through Enterprise Portal. Regards, Faiqa [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Cost Price
You can get purchase, sales and cost price from InventTableModule table. Regards, Faiqa From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of setiaji Sent: Thursday, June 07, 2007 1:15 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Cost Price Hi everyone, Is there any table which keep record for 'cost price' for Item in InventTable ? For example, for every month, Item in InventTable who had transaction SO or PO, always make changes in 'cost price'. So I want to take 'cost price for that item Is there any ? Or I should count again everytime i need 'cost price' ? Thanks before for the answer - setiaji - [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] joining 3 tables
Hi all, how to join 3 tables in querybuilder? for example I want to join InventDim Table with inventBatch and WMSLocation In my logic should be like this 1. first Query is InventDim 2. join InventDim to InventBatch 3. join inventDim again to WMSLocation is that correct? thanks in advance, Ton
RE: [Axapta-Knowledge-Village] AX: Workflow
Another option is part of the IEM IBI solution that can be bought separately, from To-Increase called Workflow. I have deployed and customized this at a few clients now and it works great. Integrates well with all Standard AX, plus email, Alerts, etc. etc. Can have complex approval chains for a given document, say OTC process? (AKA: Purchase Req. - PO, etc. etc.) -Brandon From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Shahzad Butt Sent: Thursday, June 07, 2007 4:42 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] AX: Workflow Standard AX doesn't however there's an add-on written by company called FolioDev which does exactly what you've been asking for. It works for both, Standard client and the Portal. The add on is called PSA (professional services automation) Regards, Shahzad Butt From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of Faiqa Khushi Sent: 07 June 2007 08:12 To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] AX: Workflow Importance: High Does Axapta provide any Workflow feature ? Like a user creates a requisition and it automatically forward to the Purchase department for approval. Please let me know even if we can get it through Enterprise Portal. Regards, Faiqa [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] AX: Workflow
And price of Workflow? From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Brandon George Sent: Thursday, June 07, 2007 3:11 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] AX: Workflow Another option is part of the IEM IBI solution that can be bought separately, from To-Increase called Workflow. I have deployed and customized this at a few clients now and it works great. Integrates well with all Standard AX, plus email, Alerts, etc. etc. Can have complex approval chains for a given document, say OTC process? (AKA: Purchase Req. - PO, etc. etc.) -Brandon From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of Shahzad Butt Sent: Thursday, June 07, 2007 4:42 AM To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] AX: Workflow Standard AX doesn't however there's an add-on written by company called FolioDev which does exactly what you've been asking for. It works for both, Standard client and the Portal. The add on is called PSA (professional services automation) Regards, Shahzad Butt From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of Faiqa Khushi Sent: 07 June 2007 08:12 To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] AX: Workflow Importance: High Does Axapta provide any Workflow feature ? Like a user creates a requisition and it automatically forward to the Purchase department for approval. Please let me know even if we can get it through Enterprise Portal. Regards, Faiqa [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] AX: Workflow
You would have to go through your VAR to get your pricing list, etc. I am an implementation side of things, not sales. But if you can't get a price on it, I can direct you to my VP of Sales [we are very close with Microsoft] and we can get it to you. Just let me know. (email me @ [EMAIL PROTECTED]) -Brandon From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Craig Fidler Sent: Thursday, June 07, 2007 9:25 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] AX: Workflow And price of Workflow? From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of Brandon George Sent: Thursday, June 07, 2007 3:11 PM To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] AX: Workflow Another option is part of the IEM IBI solution that can be bought separately, from To-Increase called Workflow. I have deployed and customized this at a few clients now and it works great. Integrates well with all Standard AX, plus email, Alerts, etc. etc. Can have complex approval chains for a given document, say OTC process? (AKA: Purchase Req. - PO, etc. etc.) -Brandon From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of Shahzad Butt Sent: Thursday, June 07, 2007 4:42 AM To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] AX: Workflow Standard AX doesn't however there's an add-on written by company called FolioDev which does exactly what you've been asking for. It works for both, Standard client and the Portal. The add on is called PSA (professional services automation) Regards, Shahzad Butt From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of Faiqa Khushi Sent: 07 June 2007 08:12 To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] AX: Workflow Importance: High Does Axapta provide any Workflow feature ? Like a user creates a requisition and it automatically forward to the Purchase department for approval. Please let me know even if we can get it through Enterprise Portal. Regards, Faiqa [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: joining 3 tables
Hi Ton, The Relation has to be something like this Invent Dim | | |__ Invent Batch (Relation InventBatchId) | | |__ WMSLocation (Relation InvnetLocationId) Hope this helps :) Regards Kamalakannan --- In Axapta-Knowledge-Village@yahoogroups.com, axaeffect [EMAIL PROTECTED] wrote: Hi all, how to join 3 tables in querybuilder? for example I want to join InventDim Table with inventBatch and WMSLocation In my logic should be like this 1. first Query is InventDim 2. join InventDim to InventBatch 3. join inventDim again to WMSLocation is that correct? thanks in advance, Ton
[Axapta-Knowledge-Village] Axapta 4.0 Certificate Dumps
Hi, Can anyone provide me a link or may b an attached file of axapta certification dumps?
[Axapta-Knowledge-Village] Regarding Payment of Invoice thru Manual Checks
Hi all, Can you help me in this? I want to make a paymnet for an Open Item Thru a Check. the Check Number feild is not highlighted. Please let me know how to Give a Check Reference while initiating Payments to Vendors. Is there any integration between the check and Payables? Thanks Kamaraju Vudata
[Axapta-Knowledge-Village] Re: AX: Workflow
As of the current version of Axapta is concerned there is no workflow. Most partners use Add ons for workflow there are a couple of good products available ( including WWF from MS). However ver 5.0 of Ax is expected to be released with embedded workflow rgds Vijay - Get your own web address. Have a HUGE year through Yahoo! Small Business. [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Unable to attach the charges for sales order
Hi, One of my client require's charges for sales order. I attached charges in structure. But I am getting an error message, Charges are not applicable for sales order. Please anyone help me in this regard. with regards, Chandra Download prohibited? No problem! To chat from any browser without download, Click Here: http://in.messenger.yahoo.com/webmessengerpromo.php [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Summary update !!!
Sam, I don't know exactly what's the legal dependencies for this situation in your country, but sometimes, it won't work properly and might be adapted like here in Brazil, like Daniel Zanni Said. To make the summarization do the following: 1.Create the orders. Notice that the orders must fit the sales/purchase invoice summary parameters to be grouped in 1 invoice. 2. At the Sales or Purchase orders form, hold the Ctrl key and select the orders you want to post. 3. Click Posting/invoice then Arrange. If all those conditions were met, you will notice that at the first tab grid, it will last one line per invoice generated. Then, you can check it by Inquiries/Invoice. Works the same way for other types of documents, e.g. Packing Slip. I Hope it helps! Regards André Santos Consultant -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of sam axapta Sent: quarta-feira, 6 de junho de 2007 03:36 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Summary update !!! Hi Khue, Thanks for help me. But I have a one doubt. As per you are example I create two customer account (4009, 4011) and one invoice account (4010). I setup summary update =invoice account. I create one sales order for customer =4009, 100$ I create second sales order for customer =4011, 200$ You wrote Then you can select 2 orders, and post to invoice/ the system then will post 2 orders to 1 invoice. where I can select two orders. Because each order individual. Is there any option I can select 2 orders and post in 1 invoice? (Sales order 100$+200$ and post one invoice in Invoice account 4010) Thanks in advance SAM - Original Message From: kbi kbi [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, June 5, 2007 8:37:15 PM Subject: Re: [Axapta-Knowledge-Village] Summary update !!! Hi , This is a feature allow you to summary many orders into one posting. For example: you have 2 sales order from 2 customer accounts but have the same invoice account. Then you can select 2 orders, and post to invoice. The system then will post 2 orders to 1 invoice. Hope this help. Thanks Khue - Original Message From: sam axapta [EMAIL PROTECTED] com To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Sent: Tuesday, June 5, 2007 6:48:49 PM Subject: [Axapta-Knowledge- Village] Summary update !!! Hi all What is use of Summary update functionality which can be set from AR AP- Setup - Parameters - Summary Update If possible please give one example. Thanks SAM _ _ _ _ _ _Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV. http://tv.yahoo. com/ [Non-text portions of this message have been removed] _ _ _ _ _ _ Looking for a deal? Find great prices on flights and hotels with Yahoo! FareChase. http://farechase. yahoo.com/ [Non-text portions of this message have been removed] No need to miss a message. Get email on-the-go with Yahoo! Mail for Mobile. Get started. http://mobile.yahoo.com/mail [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
Re: [Axapta-Knowledge-Village] Virtual companies query
Hi Brendon Mohit, Thank you for your advice. It will be off great help to me. Regards, Anisha - Original Message From: Brandon George [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, June 5, 2007 3:04:37 PM Subject: RE: [Axapta-Knowledge-Village] Virtual companies query Anisha, This must be done via SQL Statement. The dataareaid can not be changed from within Dynamics AX. Be careful though, because what you will have to do is make sure you don't try to have duplicate data in the same company. For example if you have: CustomerA, CustName, DA1 CustomerA, Cust Name, DA2 CustomerA, C U S T Name, DA3 And now you want all of these shared with a virtual company of vc1. Then you need to decided out of these 3 records which one is the correct one and share it only. Remove the others. So there is some data clean up as part of this if duplicate data exists. -Brandon _ _ __ From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Anisha Fakir Sent: Tuesday, June 05, 2007 7:41 AM To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Subject: Re: [Axapta-Knowledge- Village] Virtual companies query Hi Mohit, Thanks for the information. For the changing of the area Id's in the virtual company must a SQL update be done to achieve this? or can a AX job be sufficient? Regards Anisha - Original Message From: mohit rajvanshy mohit_rajvanshy@ yahoo.com mailto:mohit_ rajvanshy% 40yahoo.com To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com mailto:Axapta- Knowledge- Village%40yahoog roups.com Sent: Tuesday, June 5, 2007 12:07:39 PM Subject: Re: [Axapta-Knowledge- Village] Virtual companies query Hi Anish, If data is already there in the tables which you want to add in the virtual companies then after adding those tables in virtual comapnies you will not be able to see the data in ax untill you will change the data area id for the tables added in the virtual companies to the virtual company data area id. Rgrds Mohit --- anishafakir1 anishafakir1@ yahoo.com wrote: Hi, We need to implement virtual companies at one of our clients. The client has gone live with AX and has decided to share certain tables in the system. Is there any complications in implementing virtual companies after the client has gone live with the system? Thanking you in advance. Regards, Anisha Regards Mohit Rajvanshy _ _ _ _ _ _ Choose the right car based on your needs. Check out Yahoo! Autos new Car Finder tool. http://autos. yahoo.com/ carfinder/ _ _ _ _ _ _ Now that's room service! Choose from over 150,000 hotels in 45,000 destinations on Yahoo! Travel to find your fit. http://farechase. yahoo.com/ promo-generic- 14795097 http://farechase. yahoo.com/ promo-generic- 14795097 [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. http://new.toolbar.yahoo.com/toolbar/features/mail/index.php [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Overhead costing in a machine shop environment
Can you help. We want labour, fixed overhead and variable overhead costs for the items. Except for labour we do not have detailed costs per work center rather total cost for facility. Some items are complex and some simple in that they take more or less time per kg and use a different number of work centers. If we create operations for each of the operations with actual time for the labour cost and a dummy operation for fixed overhead and another for variable overhead how do we get a factor of time in the operation and how do we compute the rate from a total cost for the facility given that multiple jobs can be running in the facility concurrently.
RE: [Axapta-Knowledge-Village] Re: AX: Workflow
Thanks Brandon and this is a guarantee?? From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Brandon George Sent: Thursday, June 07, 2007 8:15 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Re: AX: Workflow Just to commit on the embedded workflow with v5.0. That is the To Increase workflow, where Microsoft is buying it from them and making it as part of the base, and work with can be extended with Windows Workflow Foundation. [.Net 3.0]. Just FYI, that's what I have heard, that's not official. -Brandon From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of Vijay Bhat Sent: Thursday, June 07, 2007 6:28 AM To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: AX: Workflow As of the current version of Axapta is concerned there is no workflow. Most partners use Add ons for workflow there are a couple of good products available ( including WWF from MS). However ver 5.0 of Ax is expected to be released with embedded workflow rgds Vijay - Get your own web address. Have a HUGE year through Yahoo! Small Business. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Re: AX: Workflow
Yes there was supposed to be workflow in Ax4. Until I see it in Ax5 I don't believe MS From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Vijay Bhat Sent: Thursday, June 07, 2007 12:28 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: AX: Workflow As of the current version of Axapta is concerned there is no workflow. Most partners use Add ons for workflow there are a couple of good products available ( including WWF from MS). However ver 5.0 of Ax is expected to be released with embedded workflow rgds Vijay - Get your own web address. Have a HUGE year through Yahoo! Small Business. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Unable to attach the charges for sales order
Hi, Can you be specific with the setup of charges..I think you have not setup the misc. Charges properly espeically the posting. Hemant K - Original Message From: chandra kala [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, June 7, 2007 8:02:27 AM Subject: [Axapta-Knowledge-Village] Unable to attach the charges for sales order Hi, One of my client require's charges for sales order. I attached charges in structure. But I am getting an error message, Charges are not applicable for sales order. Please anyone help me in this regard. with regards, Chandra Download prohibited? No problem! To chat from any browser without download, Click Here: http://in.messenger .yahoo.com/ webmessengerprom o.php [Non-text portions of this message have been removed] Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos more. http://mobile.yahoo.com/go?refer=1GNXIC [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Overhead costing in a machine shop environment
Hi, In standard AX you can have only a work around for these type of Costing Elements. By creating secondary operations linked to primary operation you can build the costing elements. Note that the Run Time used on the primary operation will be the time that will be used on Secondary. Other option is to create BOM Components of type Service and link to the BOM of the Parent item and use Cost categories to display the break up in the Costed BOM, and also assocaited to GL. These are only work arounds there is no functionality in AX. Hemant K - Original Message From: peterabirkett [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, June 7, 2007 8:36:42 AM Subject: [Axapta-Knowledge-Village] Overhead costing in a machine shop environment Can you help. We want labour, fixed overhead and variable overhead costs for the items. Except for labour we do not have detailed costs per work center rather total cost for facility. Some items are complex and some simple in that they take more or less time per kg and use a different number of work centers. If we create operations for each of the operations with actual time for the labour cost and a dummy operation for fixed overhead and another for variable overhead how do we get a factor of time in the operation and how do we compute the rate from a total cost for the facility given that multiple jobs can be running in the facility concurrently. Need a vacation? Get great deals to amazing places on Yahoo! Travel. http://travel.yahoo.com/ [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: joining 3 tables
hi kamal, Thx, I already know the relation, the problem is when I use QueryBuildDataSource, after I create the first Query (InventDim), add new datasource (InventBatch), linked them, and add new datasource again(WMSLocation), when I link it to the first query, seems can not work. rgds, Ton. --- In Axapta-Knowledge-Village@yahoogroups.com, kamal_ec [EMAIL PROTECTED] wrote: Hi Ton, The Relation has to be something like this Invent Dim | | |__ Invent Batch (Relation InventBatchId) | | |__ WMSLocation (Relation InvnetLocationId) Hope this helps :) Regards Kamalakannan --- In Axapta-Knowledge-Village@yahoogroups.com, axaeffect axaeffect@ wrote: Hi all, how to join 3 tables in querybuilder? for example I want to join InventDim Table with inventBatch and WMSLocation In my logic should be like this 1. first Query is InventDim 2. join InventDim to InventBatch 3. join inventDim again to WMSLocation is that correct? thanks in advance, Ton
[Axapta-Knowledge-Village] Import csv with newline character in string field.
Hi All, I need to import csv file into a table using definition group of type custom. The table has string field that allow multiline (e.g. item description), so there could be newline character in the field value. The problem is when I try to put newline character in the csv file, it is recognized as record delimiter, not as part of the field value as expected. Axapta will treat the next string after newline as first field of new record. Any workaround please help. Thanks Regards, Agus [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: joining 3 tables
Hi Agus, Thx.. IT WORKS. !!! :D --- In Axapta-Knowledge-Village@yahoogroups.com, Agus Riyadi [EMAIL PROTECTED] wrote: Hi Ton, Set the properties FetchMode to 1:1 to the second and third data source. Regards, Agus On 6/8/07, axaeffect [EMAIL PROTECTED] wrote: hi kamal, Thx, I already know the relation, the problem is when I use QueryBuildDataSource, after I create the first Query (InventDim), add new datasource (InventBatch), linked them, and add new datasource again(WMSLocation), when I link it to the first query, seems can not work. rgds, Ton. --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge- Village%40yahoogroups.com, kamal_ec casperkamal.dax@ wrote: Hi Ton, The Relation has to be something like this Invent Dim | | |__ Invent Batch (Relation InventBatchId) | | |__ WMSLocation (Relation InvnetLocationId) Hope this helps :) Regards Kamalakannan --- In Axapta-Knowledge-Village@yahoogroups.comAxapta- Knowledge-Village%40yahoogroups.com, axaeffect axaeffect@ wrote: Hi all, how to join 3 tables in querybuilder? for example I want to join InventDim Table with inventBatch and WMSLocation In my logic should be like this 1. first Query is InventDim 2. join InventDim to InventBatch 3. join inventDim again to WMSLocation is that correct? thanks in advance, Ton [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Re: joining 3 tables
Hi Ton, Set the properties FetchMode to 1:1 to the second and third data source. Regards, Agus On 6/8/07, axaeffect [EMAIL PROTECTED] wrote: hi kamal, Thx, I already know the relation, the problem is when I use QueryBuildDataSource, after I create the first Query (InventDim), add new datasource (InventBatch), linked them, and add new datasource again(WMSLocation), when I link it to the first query, seems can not work. rgds, Ton. --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com, kamal_ec [EMAIL PROTECTED] wrote: Hi Ton, The Relation has to be something like this Invent Dim | | |__ Invent Batch (Relation InventBatchId) | | |__ WMSLocation (Relation InvnetLocationId) Hope this helps :) Regards Kamalakannan --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com, axaeffect axaeffect@ wrote: Hi all, how to join 3 tables in querybuilder? for example I want to join InventDim Table with inventBatch and WMSLocation In my logic should be like this 1. first Query is InventDim 2. join InventDim to InventBatch 3. join inventDim again to WMSLocation is that correct? thanks in advance, Ton [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Timeout in Axapta
Hi friends Can anyone tell me how 2 implement Time out in Axapta Need a vacation? Get great deals to amazing places on Yahoo! Travel. http://travel.yahoo.com/
Re: [Axapta-Knowledge-Village] Timeout in Axapta
Hello, You can set it in the user options form; in the field Automatic Shutdown in the General tab. Regards, Raj. On 6/8/07, abhijit raje [EMAIL PROTECTED] wrote: Hi friends Can anyone tell me how 2 implement Time out in Axapta __ Need a vacation? Get great deals to amazing places on Yahoo! Travel. http://travel.yahoo.com/ [Non-text portions of this message have been removed]
