[Axapta-Knowledge-Village] select with force_placeholders
does anyone know what is select with force_placeholder means? also is it possible to grouping with QueryBuildDataSource without using key addSortField ? common query is like this for example: QueryBuildDataSource qbds; Query q = new query(); QueryRun qr; InventDim Inventdim; ; qbds = q.addDataSource(tablenum(InventDim)); qbds.addSortField(fieldnumInventDim, configid); qbds.addSortField(fieldnumInventDim, inventBatchId); qbds.ordermode(ordermode::groupby); qr = new QueryRun(q); while (qr.next()) { ... } above statement produce grouping by configid ascending and inventbatchid ascending order. The problem is I want to join with another table (InventBatch) which is I want to make order not in InventBatchId, but ExpireDate, so it will conflict with the firt query (InventBatchId asc) bcoz might be in second table (Inventbatch), the ExpDate sorted but not the inventBatchId. please help, thx, Ton.
Re: [Axapta-Knowledge-Village] Financial dimensions on a Stock close
Hi, Yes it is AX v3.0. Oh ok interesting. Will check on partnersource. The adding of dimensions on item level will be quite a mission as items do not belong to default dimensions. Is this the only solution.. Thanks Regards Anisha - Original Message From: Asrar Ahamed [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, May 22, 2007 7:17:17 AM Subject: RE: [Axapta-Knowledge-Village] Financial dimensions on a Stock close If the Inventory Profit/Loss summary account dimension validity is set up as To be filled, you will find this message. If you want to have this set up for Inventory PL Journal as well, set up the dimensions at Item Master Level. Hope this will solve your problem. Thanks, Asrar James Flavell [EMAIL PROTECTED] com wrote: I think there was a hotfix for this issue (this is Ax3.0 right?) -Original Message- From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of anishafakir1 Sent: 21 May 2007 07:25 To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Subject: [Axapta-Knowledge- Village] Financial dimensions on a Stock close Hi. Please assist me with the following, When I do a stock close, upon completion an error appears. The error is Department, Cost center must be specified for ledger account.. How do I switch off this error for stock closings and still keep it available for the profit/loss journal? Thanking you in advance. Regards Anisha 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-knowledg e-village. tk Yahoo! Groups Links - - --- Yahoo! Answers - Got a question? Someone out there knows the answer. Tryit now. [Non-text portions of this message have been removed] Got a little couch potato? Check out fun summer activities for kids. http://search.yahoo.com/search?fr=oni_on_mailp=summer+activities+for+kidscs=bz [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] FRX integration with AX 4.0
Hi Senthil, If you download the latest service pack ( SP9 ) for FRX 6.7 you will have a version that complies with AX4.0. The link with AX is made when you enter the admin menu option in the report designer. Upon firsdt installation you will only be abale to connect to the demodata ( Fabricam Works ), but under the accounting system you will need to select AX. Of course you will aslo need the correct License numbers which can be provided to you by Partnersource or Online support ( not FRX software corp) After dowloading the last version and service pack you will also have to execute some sql scripts and procedures . All of these are explained in the included installation procedures and are independant of AX ( Setup of ODBC link, ... ) Hope this helps ! Michael -- Plaats je zoekertjes GRATIS op AdValvas Placez votre petite annonce GRATUITEMENT sur AdValvas http://www.advalvas.be
Re: [Axapta-Knowledge-Village] German Tax Forms
Dan, To my knowledge Graman comapnies are obliged to declare VAT electronicaly . No paper declaration possible. I hope this helps Best regards Michael -- Plaats je zoekertjes GRATIS op AdValvas Placez votre petite annonce GRATUITEMENT sur AdValvas http://www.advalvas.be [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Help required in making Financial Statement
Hi all, I am facing problem in displaying the Financial Statement. The problems is that I have created the Row definition and there i have created row of type calculation in the row definition and have given three fields to be added.. Now I want that I should display this total amount on the financial statement in a column as Total. Kindly let me know how to do this. Thanks and Regards, Sannam Khan [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Financial dimensions on a Stock close
Okay I think the fix was that it takes the dimensions from the original transaction rather than the item table etc. So the hotfix should help with this but if your ledger account is set to require dimensions and your original transaction did not have it then I am not sure the hotfix will solve the problem (the only way is to start specifying dimension on the original transaction) But check out the hotfix and what it is supposed to do because it is long ago and I don't fully remember... All the best -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Anisha Fakir Sent: 22 May 2007 05:17 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Financial dimensions on a Stock close Hi, Yes it is AX v3.0. Oh ok interesting. Will check on partnersource. The adding of dimensions on item level will be quite a mission as items do not belong to default dimensions. Is this the only solution.. Thanks Regards Anisha - Original Message From: Asrar Ahamed [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, May 22, 2007 7:17:17 AM Subject: RE: [Axapta-Knowledge-Village] Financial dimensions on a Stock close If the Inventory Profit/Loss summary account dimension validity is set up as To be filled, you will find this message. If you want to have this set up for Inventory PL Journal as well, set up the dimensions at Item Master Level. Hope this will solve your problem. Thanks, Asrar James Flavell [EMAIL PROTECTED] com wrote: I think there was a hotfix for this issue (this is Ax3.0 right?) -Original Message- From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of anishafakir1 Sent: 21 May 2007 07:25 To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Subject: [Axapta-Knowledge- Village] Financial dimensions on a Stock close Hi. Please assist me with the following, When I do a stock close, upon completion an error appears. The error is Department, Cost center must be specified for ledger account.. How do I switch off this error for stock closings and still keep it available for the profit/loss journal? Thanking you in advance. Regards Anisha 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-knowledg e-village. tk Yahoo! Groups Links - - --- Yahoo! Answers - Got a question? Someone out there knows the answer. Tryit now. [Non-text portions of this message have been removed] Got a little couch potato? Check out fun summer activities for kids. http://search.yahoo.com/search?fr=oni_on_mailp=summer+activities+for+kidsc s=bz [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
[Axapta-Knowledge-Village] Re: Form with 2 grids and same datasource
I don't know if it works but you can try this : Create 2 dataSources that points to the same table. Let's say the table name is YourTable. Create YourTable_Header and YourTable_Detail datasources. Like you probably already did, add filter on YourTable_Header to show only header. Then add a join relation between YourTable_Header and YourTable_Detail on the field that link the header to the detail. Good luck! Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, Dimitri Dejonghe [EMAIL PROTECTED] wrote: Hi, I try to make a form with 2 grids (Heading grid an Detail grid) that have the same datasource but with other fields of the table used. The table contains header records and detail records and are marked in a field that contains the number 1 or 2. This field is related with a field called DocuNumber. Now, On my form the heading record works correctly but I don't find it how I can show the details in the detail grid. I Know that I have to use the active method in the heading grid to change data in de detail grid when select an onther record. But I don't know what code I could use so that I get the correct data in the detail grid. Thans on advance.
[Axapta-Knowledge-Village] Printers
Hi Can we display all the available printers in a form( field). I have a requirement wherein I have to attach printer to a warehouse so that anything related to that warehouse is printed on that printer. Is there a way to get the list of printers in axapta. Thanks Vishal [Non-text portions of this message have been removed]