[development-axapta] No Transaction Records

Hi, I have to print a report which needs to fetch records from InventTable and InventTrans for items which have no physical transaction during a defined period(dates). I have created a query in inventTable and trying to loop through the inventrans records in fetch method and find the items

[development-axapta] Create Document handling Form

Hello, I have a small query on document handling. I have to add a lot of texts on sales order document. These texts should be predefined. It will be necessary to have the ability to have some table to choose a specific text top print on the document. Now I have created a new table and a form.

[development-axapta] Records in Report

Dear All, I just want to know that if there are 'n' lines in report for a particular query,then I have to display the first record with all the fields displayed,then the other lines for the same query should not display few fields. I cant use the controlname.visible for the same.Is there

[development-axapta] Report Display

Hi all, I have a problem in displaying the report. I want to select report from Prodtable,Prodroute and ProdBom tables. Now the trick is I have selected all the records which is showing in the report. But I want to display the first line record and if the production order line has more

[development-axapta] Query in reports

Hi All, I have a report where I need to display the records based on the grouping of WorkcenterID or startdate. I have added a footer with sum for timeleft field. whenever I select a particular workcenter from the dialog query..its working fine displaying the sum for that workcenter. But when

[development-axapta] Syntax for Axapta SQL statement

Dear All, I have an requirement like selecting records for Purch Items for 'n' number of Purchase order. This is like Select * from PurchLine where purchid in ('234334','345345','34534'). Could any one kindly help me doing this equillent in Axapta SQL. This is an urgent requirement please

Re: [development-axapta] Opening a form

Hi Shruti, I have a written code for lookup as and when i select a account type, ie., when i select a value from combo, automatically the lookup of that account type is displayed, but only account type and name are displayed in that. My code is some what like this: void lookup() {