[Axapta-Knowledge-Village] Company Settings

2009-12-16 Thread gihan_ax
Dear all, I am having a small issue in getting records from all companies. Lets say like this, I am having two companies as A and B. There are recodes in both companies. Lets say that company A is having records 1,2 and 3. And company B is having records 4,5 and 6. When I am working on company

[Axapta-Knowledge-Village] Company Settings

2009-12-16 Thread Danny Band
Gihan, You have a few choices to get the company records, first you can use a select statement with the crosscompany keyword such as select crosscompany * from ledgerjournaltrans or you can use the DAX query with allowCrossCompany set like _newQuery.allowCrossCompany(true) or if you are

[Axapta-Knowledge-Village] how to add same field into qbds by getting AND condition instead of OR in debugg

2009-12-16 Thread giridharraj
Hi, I have a problem.. I take salestable in qbds and add range as delivery date with value in between 19/12/2008 to 20/12/2009 and again when i add the same range with a value equal to 15/12/2009 then the query is changing. Like i need the query as select * from salestable where

[Axapta-Knowledge-Village] composite query in AX through code

2009-12-16 Thread giridharraj
Hi, How to implement a composite query in AX through code Regards, giridhar Raj.

Re: [Axapta-Knowledge-Village] production journal report customisation

2009-12-16 Thread Kusman Lim
Yo may join the prodtable it has field prodtable.name Regards Kusman PT PRIMACOM Jakarta On Wed, Dec 16, 2009 at 7:46 AM, Robert Linggoputro robert...@gmail.comwrote: Hi all, I have been asked to add item name into production journal report. I have managed to create this report using

[Axapta-Knowledge-Village] Posting a Credit Note

2009-12-16 Thread Akshay
Hi, I have a requirement for changing the way Ax posts a sales order credit as compared to its initial invoice. When we post an Invoice, Ax uses the following accounts A/R (Posting Profile Summary account) Dr Sales (Item group SO revenue account)