[development-axapta] Re: DocuRef Table inserting Wrong RefRecIds from Route
When you look at the route linked to an item, you are not looking at prodroute at all, you are looking at a temporary version of prodroute which is made up of data from Route and RouteOpr. If you click on the description tab then you can create text based document handling records, these are attached to RouteOPR If you want to add other document types then you need to link them to this table - they will then get copied to works orders --- In development-axapta@yahoogroups.com, lakshmi kanth reddy laxmikant...@... wrote: HI ALL, I need your suggestions/ help in solving this: I want to attach a document by clicking document handling on Route form (from lines) datasource: ProdRoute.. while inserting record into DocuRef table it will inserts RefTable and RefRecId for reference .. but from ProdRoute it is inserting some false values into DocuRef..so when i query the same i am not getting any records even i checked with standard its behaving the same is there anyway to overcome this?? Please help me how to get the correct ProdRoute Record from existing records Thanks in advance.. Cheers Laxmikanth.. [Non-text portions of this message have been removed]
[development-axapta] Re: [Axapta-Knowledge-Village] Problem of join Datasources on the Form
Are you sure you have a relation to salesline. I don't have AX4.0 to hand but in AX2009 there is no defined relationship to salesline from reqtrans or indeed to Forecast Sales. I've just created a form with the necessary realtions and outer joins and it works fine --- In development-axapta@yahoogroups.com, Özcan Ayyýldýz ayyildizoz...@... wrote: i said it before. i tried all join types and i have already table level relation. 2009/7/17 avi choudhury avi123choudh...@...: u should give a outer join in the link type property and use table level relation between tables. --- On Fri, 7/17/09, Özcan Ayyýldýz ayyildizoz...@... wrote: From: Özcan Ayyýldýz ayyildizoz...@... Subject: [Axapta-Knowledge-Village] Problem of join Datasources on the Form To: development-axapta@yahoogroups.com, axapta-knowledge-vill...@yahoogroups.com Cc: ozc...@... Date: Friday, July 17, 2009, 12:39 PM Hi everyone; I am experiencing a problem with my newly created form on Ax.40. There is one grid on the form, i need to place a lot of fields from three different datasources( ReqTrans, SalesLine, ForecastSales) into the grid. I don't want use display methods. Because i need to filtering and sorting on the fields. Main datasource to that grid is ReqTrans. I added two relations to the ReqTrans table relations for salesLine and ForecastSales . There may not be related records on the SalesLine and ForecastSales tables. The needed solution is that whole ReqTrans records should be seen on the grid, whether or not there is related records on the other tables. If there are related records on the other related tables, these records should be seen on the grid. I added three datasources to the form. I set the join source property = ReqTrans of SalesLine and forecastsales tables. I tried each different types of Join Type of that two tables, but not resulted as we need. Only the delayed value results that related records apeeared on the grid for the selected row. The values disappeared for the other rows. The values are not shown for active row as well, when other join types selected. Any idea would be apreciated Thanks. Özcan AYYILDIZ
[development-axapta] Re: Credit note report listing all credit notes
AX makes little distiction between Invoices and credit notes, they both appear in Reports/Transactions/Invoice/Invoice Journal to only show credit notes you simply need to filter this report --- In development-axapta@yahoogroups.com, Abhay ab...@... wrote: Dear All, Does AX 4.0 have credit notes report listing all the credit notes generated for a specified period if YES please send us the Navigation path.Regards Abhay [Non-text portions of this message have been removed]
[development-axapta] Re: PO Error
Don't import inventtrans, it will be created when you insert purchline . Rather than use a straight import of purchline, built the record and then call purchline.createline() This has a number of parameters that control how the line is created. --- In development-axapta@yahoogroups.com, Ali Jawad [EMAIL PROTECTED] wrote: Hello Group, I have imported Purchase orders and following tables were imported. 1. Purchtable 2. Purchaselines 3. Inventtrans After the port when I try to change dimensions or anything AX gives following error There are transactions with status reserved ordered for the dimension of the item It even doesn't let me to delete the Order. Please advise ASAP. Thanks in Advance. Regards, Ali [Non-text portions of this message have been removed]
[development-axapta] Re: Crystal Reports with axapta 4
Axapta 4 uses MS SQL server. You can use the database as a datasource in Crystal but the problem is that Crystal does not understand Axapta logic. Most balances in Axapta are actually calculations in Methods and Crystal will know nothing about them. Additionally Axapta has a data type called an enum which stores a number in the database but is presented as text, most drop down boxes with fixed choices use enums. To summarise, you can use Crystal for simple reports on static data but not for anything involving calculations unless you are prepared to replicate Axapta's code yourself. My advice is spend your time learning how to produce reports in Axapta and forget Crystal --- In development-axapta@yahoogroups.com, M. Nuaman Sharif [EMAIL PROTECTED] wrote: Dear all Please tell me how to use crystal reports by microsoft dynamics ax 4 thanks Regards
[development-axapta] Re: CSV Import
--- In development-axapta@yahoogroups.com, febinpc [EMAIL PROTECTED] wrote: Hi Friends I'm trying to Import data from CSV files to one Table. But CSV files Contains around 100 fileds in that only 20 fileds are required for my aplliction. Is it possible to skip unwanted fileds at the time of importing data to the table Thanks and Regards Febin Chiramel Yes, using a definition group you can simply select the fields you require. You can also set default values on other fields if you wish
[development-axapta] Re: Fixed rate
Not sure why this question is in the development group but never mind If you are posting a purchase invoice in a currency that is not the home currency then you can overide the standard exchange rate. You do this by ticking the fixed rate box and then entering the exchange rate. Suppose the prevailing exchange rate is 141 EUR for 100 GBP, but you have EUR that yyou purchased at the rate of 135, then you could overide the standard rate. You would also use this for negotiable financial instruments bought at a specific rate --- In development-axapta@yahoogroups.com, yansuryas [EMAIL PROTECTED] wrote: Dear all, Has anybody tried to use the fixed rate on the purchase order posting invoice..?? what is the function..?? it seems to useless..?? no effect to the invoice calculation and the journal as well..?? Regards, Yanti SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
YNT: [development-axapta] Re: [Urgent] Cannot Post Ledger Journal
There was an article in the old technet about a problem caused by duplicate recids which prevented you adding records in a variety of tables. The fix was to bypass Axapta and use SQL Query Analyser to edit a system table. Unfortunately I can't remember the details but this might jog someone else's memory To resolve it --- In development-axapta@yahoogroups.com, Gokhan Can [EMAIL PROTECTED] wrote: Our problem is not just Ledger also some transaction we get same king of message for inventtrans , wrkctrcapres table... We think that it is a problem of recid but we can not understand why? Gökhan CAN Software Engineer / Mic. Cert. Axapta Professional ( Pro - PB ) Datasistem Genel Otomasyon San Tic. Þti Tel : ( 232 ) 463 1663 - 131 e-mail : [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Kimden: development-axapta@yahoogroups.com bu kiþinin yerine: Mustafa CETIN Gönderilmiþ: Cum 29.07.2005 14:58 Kime: development-axapta@yahoogroups.com Konu: [development-axapta] Re: [Urgent] Cannot Post Ledger Journal Hi Cenk; Did you check voucher's number sequence? may be broken(uncheck continuous property and clean up. )... Kolay Gelsin... Mustafa --- In development-axapta@yahoogroups.com, Cenk Ince [EMAIL PROTECTED] wrote: Hi all; We try to post a ledger journal, and we get error : Cannot create a record in Ledger transactions (LedgerTrans). Voucher: MF002551, 31/05/2005. The record already exists.. When i look in LedgerTrans table, there is no data like this. How can i solve this problem. That topic is really very Urgent for me!!! Thanks a lot. [Non-text portions of this message have been removed] Yahoo! Groups Links [Non-text portions of this message have been removed] SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Re: Table Lookup on Forms by DataAreaId
I don't think you understood my reply I dont know which table you are using for your journal line so for this example I will just call it Journal Line and the datasource for your lookup I will call LookupTable Suppose you have a field on that table called CompanyID that contains the company identifier you wish as the basis of your Lookup. In your Lookup form, create an Init method someting like this:- Public Void Init() { JournalLine JournalLine; Super(); Jounalline=element.args().record(); LookupTable_DS(JournalLine.CompanyID); } This will cause your lookup form to present records from the company specified on your Journal Line. Isn't that what you want? --- In development-axapta@yahoogroups.com, axapta_coder [EMAIL PROTECTED] wrote: Hi Alla, Thanks for your reply. My issue is not setting a default comany of a data source. My issue is inter-company transactions. Imagine doing a GL journal entry where your debit balance is posted to a designated GL account in company 100, while the Credit balance must be posted to another GL account in company 200. standard Axapta let's you lookup and select an account based on your company selection. Using the same logic, I need my custom field to look up company dependent records. It curently looks up records based of my curExt() and not the company I'm selecting on the journal line! // Thanks a bunch. --- In development-axapta@yahoogroups.com, allanwallis [EMAIL PROTECTED] wrote: When you specify a datasource in a form, you can specify which company the data is derived from. So you could for example have one datasource for each company and put each on a separate tab of your lookup form. I believe that you can also set the company for the datasource in the init method of your lookup form, e.g. LedgerTable_DS.company ('aaa') Hope this helps --- In development-axapta@yahoogroups.com, axapta_coder [EMAIL PROTECTED] wrote: I have a table from which I'm looking up a field value via a Journal Line (LedgerJournalTransDaily). This value is used in relation to an Inter-Company transaction and therefore needs to be a company specific lookup. Pretty much like standard Inter-Co entries where a GL account is looked up based on account type but most importantly by company account. I need to make my table lookup to be company dependent and not looking up values from the current company I'm standing on. Any suggestions will be greatly appreciated. YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[development-axapta] Re: Table Lookup on Forms by DataAreaId
When you specify a datasource in a form, you can specify which company the data is derived from. So you could for example have one datasource for each company and put each on a separate tab of your lookup form. I believe that you can also set the company for the datasource in the init method of your lookup form, e.g. LedgerTable_DS.company('aaa') Hope this helps --- In development-axapta@yahoogroups.com, axapta_coder [EMAIL PROTECTED] wrote: I have a table from which I'm looking up a field value via a Journal Line (LedgerJournalTransDaily). This value is used in relation to an Inter-Company transaction and therefore needs to be a company specific lookup. Pretty much like standard Inter-Co entries where a GL account is looked up based on account type but most importantly by company account. I need to make my table lookup to be company dependent and not looking up values from the current company I'm standing on. Any suggestions will be greatly appreciated. YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.