-
I have a custom temporary table with twelve period amount fields. This table is used to support an inquiry form and is filled dynamically based on user specified criteria. I would like to be able to override the (field label) headings in the grid to display the start dates of the individual periods as...
-
I'm working on a project for a client where they want a customized report that lists ledger transactions sorted by ledger account, profit center (dimension), cost center (dimension), date and then voucher number. I've set up the dimensions, dimension focuses and hierarchies. Some of the built...
-
Hello. I'm working with Dynamics AX 4.2. Has anyone figured out a way to save a user's customized profile for a form. Once the user creates his/her personal form, it can be wiped out if their usage data is cleared. I was looking for a way to save that form in case this ever happens. Thanks for...
-
Hi, How can I add HAVING clausule to query in AX? I build query by QueryBuildDataSource by adding additional suming and grouping steatments but I need to filter resoult by checking value of sum. I make CustTransSplit table that splits custTrans record by goup of iitems, I want too check if values are...
-
hi, I ve to put a validation on key press .. the requirement is sometihng like this in a form there is a text box which accepts phone number.. i want the user to preess only number if press any key other than number it should not be displayed in the box. -- Save Tree Save Earth
-
The final solution was to do with relations - thankyou. The field that I used was a generic field that couple hold ledger accounts/customer accounts/project accounts/etc. On the new table that I created, I needed to set up a whole heap of relations that was relevant to each table I needed to relate to...
-
Thanks for that, especially on your day off. I understand that flow, however, I think the LedgerJournalAC is slightly different. It seems to do things dynamically, depending on the account type. If I move away from my modification that I made, and look at the standard 'General Journal' screen...
-
I have created a new table which uses the 'LedgerJournalACType' EDT and 'LedgerJournalAC' EDT. There are the account fields on the 'LedgerJournalTrans' table, and they are supposed to behave in the same fashion. That is, when the account type is 'CUST', then a customer...
-
Hi, I have 2 dateedit controls on the form. I have to initialize the second control with the calculation based on the the value of the first control and an integer value. How do i get the value of the first contorl in the code and then display it in the second field. thanks
-
Hi there I have a form with text boxes to capture comments (normally paragraphs of text) from the user. I am busy writing a report linked to this form which should display the comments that have been inputted into the form. My problem is that when the user writes a few paragraphs and separates these...