[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]
[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. >
RE: [Axapta-Knowledge-Village] Re: Pick Inventory per Batch by ExpiryDate
Yes the date controlled wont help you need to untick that so it will do reservation based on batch number. The easiest is to make the dateexpiry be prefixed on to the start of the batch number, either as a manual process or do some modification that the user fills in a batch field (new) and the expiry date and it makes the actual batch id field out of these 2 All the best James -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of axaeffect Sent: 21 May 2007 23:31 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Pick Inventory per Batch by ExpiryDate Hi Hemant, thx, but I think it won't work, correct me if I'm wrong, but as I look in the code, "date controlled" only look for LastUpdatePhysical in Onhand Inventory. and I can't use automatic batch number bcoz already agreed, user will give the batch manually, also expiry date. The problem is like my example below, they can input batch number and expire date unmatch. rgds, --- In Axapta-Knowledge-Village@yahoogroups.com, Hemant Kumthekar <[EMAIL PROTECTED]> wrote: > > Hi Ton, > > How about checking the flag on IMG Reservation "date controlled" also you would like to consider the allocation of batch numbers to be Automatic rather than manual as the number allocated will be in sequential order. > > Hemant K > > - Original Message > From: axaeffect <[EMAIL PROTECTED]> > To: Axapta-Knowledge-Village@yahoogroups.com > Sent: Monday, May 21, 2007 10:04:38 PM > Subject: [Axapta-Knowledge-Village] Pick Inventory per Batch by ExpiryDate > > hi all, > > I want to pick Onhand Inventory, and the batch that should be picked > usually in alpabhet order (batchid). How if I want to sort by Expiry > Date ? > > For Example, > I have Onhand Inventory like this : > Item A - Batch X - ExpDate : 20/5/2007 > Item A - Batch Y - ExpDate : 18/5/2007 > Item A - Batch Z - ExpDate : 21/5/2007 > Right now, when we pick the item, it will pick batch X, how if I want > to pick batch Y, coz the expdate is earlier. > > thx in advance, > Ton. > > > > > > > __ __ > Be a PS3 game guru. > Get your game face on with the latest PS3 news and previews at Yahoo! Games. > http://videogames.yahoo.com/platform?platform=120121 > > [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
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 P&L 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_mail&p=summer+activities+for+kids&c 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] 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] 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]
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] 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 P&L 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_mail&p=summer+activities+for+kids&cs=bz [Non-text portions of this message have been removed]
[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.