Re: [Axapta-Knowledge-Village] Want to fetch distinct record from table

2009-08-17 Thread Anitha S
hi.. Try group by in ur query. Regards, Anitha On Mon, Aug 3, 2009 at 4:35 PM, Hemant Sonawane hemant.sonawan...@yahoo.com wrote: Hi, I want fetch distinct record from table. If any one have please let me know. Ex.. I have one table “*ProdTable*” in this table number of

[Axapta-Knowledge-Village] Re: Based on PurchaseOrder the purchase price of item is update

2009-08-17 Thread joeinvcost
Kishore, I'm not sure I completely understand your issue, but it sounds like you're trying to retrieve both the sales price and purch price from InventTableModule using the same join. If that's true, the problem is that the same Price field is used for Invent, Purch and Sales price and you

Re: [Axapta-Knowledge-Village] Re: sub contracting process

2009-08-17 Thread Nitin Sule
Dear Nitin, You can adopt following process, 1. Create Transfer Order (Material to be sent) to Job Worker Warehouse (Virtual) 2. Create End Production at Job Worker Warehouse 3. Create Transfer Order (FG) to Original Warehouse For this you need to take care of following set up 1. Virtual

Re: [Axapta-Knowledge-Village] Re: sub contracting process

2009-08-17 Thread visti Sethna
Hi Friends, I need one help in AX 2009. I need to map a subcontracting screnario in which i need to send a couple of items to the vendors, for painting. I need a few clarifications As this is a machine building scenario, there are almost 500 parts that need to go for painting to the vendor. 1)

Re: [Axapta-Knowledge-Village] Worklow

2009-08-17 Thread manoj manoharan
Hi,   First check that there should be only one AOS instance in the Workflow server (where workflow website is installed) and then run the WF setup config wizard and the AOS instance should be ther on the batch --- On Mon, 10/8/09, Agus Riyadi agusa...@gmail.com wrote: From: Agus Riyadi

Re: [Axapta-Knowledge-Village] Re: Slow performance on Misc Charges on Purchase Orders

2009-08-17 Thread Mike
Hi Eddie, We experienced a problem with the Miscellaneous charges some time ago. Our problem was in the UPS interface (FIShipment table) and the related table we created to move those charges into Axapta. For various reasons we would have tens of thousands of entries in this table per month

[Axapta-Knowledge-Village] I Am Trying To Set Up CLR Interop, Can Anyone Provide Guidance?

2009-08-17 Thread Girac
Hello all, I have my dll built and added as a reference in the AOT, now I need to develop code to communicate with it. The code I put in place I get error, The table does not contain this field. I am trying to reference my CLR Interop DLL in the AOT. Looking forward to your assistnace.