Re: [Axapta-Knowledge-Village] Re: ended production orders
Hi, So I think by using P/L journal you can reverse the Inventory effect and GL will be okay. But if you are having any reports that are taking in to account the Production order then you may see that there was excess production and consumption of raw materials. As far as GL is concerned you should be okay as you would pass the correcting entries. If you use P/L journal then Inventory and Inventory Profit / Loss accounts will be affected, or if you want to use Movement Journal you can book the other part of the entry to any designated GL account. Choice is what your accounting dept would like to see in the books. Hemant K - Original Message From: dj_rineer [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, March 26, 2008 9:14:18 AM Subject: [Axapta-Knowledge-Village] Re: ended production orders --- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, Hemant Kumthekar hemantdk66@ ... wrote: Yes we are on Standard cost. I do think the way to go is correcting the Inventory and GL. Yes raw materials were consumed with the excess production. Hi, Can you give details about the following 1. Costing method 2. Raw materials were also consumed or back flushed when excess production was updated may be we can rectify GL, Inventory entries. Hemant K - Original Message From: dj_rineer [EMAIL PROTECTED] To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Sent: Tuesday, March 25, 2008 8:46:27 AM Subject: [Axapta-Knowledge- Village] ended production orders I am on AX 3.0. Someone accidentally ended a production order that had too much production on it. I know you can not go back at this point and correct the original production order but is there a way to back out this excess production? _ _ _ _ _ _ __ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools. search.yahoo. com/newsearch/ category. php?category= shopping Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping
Re: [Axapta-Knowledge-Village] Trade Agreements
Hi !! Recardo, Please go to the Microsoft Partner Source.. you will find lots of informaion in PDF format on your requirement. Also see Mibosu website... Cheers Axapta friend - Original Message From: ricardodegouveia [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, 26 March, 2008 11:28:44 PM Subject: [Axapta-Knowledge-Village] Trade Agreements Hi Everyone Does anyone know where i could find some good documentation on trade agreements in AX? Like how they work and how to set them up? Thanking you in advance Ricardo Now you can chat without downloading messenger. Go to http://in.messenger.yahoo.com/webmessengerpromo.php
[Axapta-Knowledge-Village] Expense Journal Error Message
Issue Description = User has an issue that everytime they try to post an expense journal from the Projects Module the get an error message. Error message: Vocher JE_730003, date 2008/02/28, account 110180, amount currency - 11.50, amount MST - 11.50, alternative amount - 11.50, currency ZAR, text The transactions on voucher JE_730003 do not balance as per 2008/02/28. (Company currency: -11.50 - secondary currency: -11.50) Vocher JE_730003, date 2008/02/28, account 110180, amount currency 5.00, amount MST 5.00, alternative amount 5.00, currency USD, text The transactions on voucher JE_730003 do not balance as per 2008/02/28. (Company currency: 5.00 - secondary currency: 5.00) Posting has been cancelled
[Axapta-Knowledge-Village] Value Model Error Message
I receive an error message every time I try to link a depreciation model to a value model. Error message: Cannot create a record in Book lookup (AssetBookMergeLookup). Book: VEH, Value model. The record alredy exists. Any ideas? Thanks
[Axapta-Knowledge-Village] Re: Expense Journal Error Message
Hi Possibly you can check the following: 1. Do you have an offset account for that journal line? 2. Set the rounding for each currency (General Ledger -- Setup -- Exchange rates) 3. Set the max penny difference value (as well as the one for secondary currency if you use secondary currency) in ledger parameters as conversion from currency values can casue rounding differences. Regards Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, leroux_marica [EMAIL PROTECTED] wrote: Issue Description = User has an issue that everytime they try to post an expense journal from the Projects Module the get an error message. Error message: Vocher JE_730003, date 2008/02/28, account 110180, amount currency - 11.50, amount MST - 11.50, alternative amount - 11.50, currency ZAR, text The transactions on voucher JE_730003 do not balance as per 2008/02/28. (Company currency: -11.50 - secondary currency: -11.50) Vocher JE_730003, date 2008/02/28, account 110180, amount currency 5.00, amount MST 5.00, alternative amount 5.00, currency USD, text The transactions on voucher JE_730003 do not balance as per 2008/02/28. (Company currency: 5.00 - secondary currency: 5.00) Posting has been cancelled
[Axapta-Knowledge-Village] Restriction on Invoice DueDate
Hi friends, Actually i am working on Account Recievable , Sales Order I have a problem in Restricting customer That if Last Invoice of a specific Customer is not Payed within DueDate then Customer is not Allowed to Generate New Invoice Through Sales Order Form. There is not any check on Payment...Just Accross DueDate to a specific Invoice Account. I'll be very thank ful if any one help me Best Regaurds! Syed Adeel Shafqat
[Axapta-Knowledge-Village] Re: ended production orders
Another option would be to use a BOM Journal with a negative quantity. This should then reverse all inventory postings. --- In Axapta-Knowledge-Village@yahoogroups.com, Hemant Kumthekar [EMAIL PROTECTED] wrote: Hi, So I think by using P/L journal you can reverse the Inventory effect and GL will be okay. But if you are having any reports that are taking in to account the Production order then you may see that there was excess production and consumption of raw materials. As far as GL is concerned you should be okay as you would pass the correcting entries. If you use P/L journal then Inventory and Inventory Profit / Loss accounts will be affected, or if you want to use Movement Journal you can book the other part of the entry to any designated GL account. Choice is what your accounting dept would like to see in the books. Hemant K - Original Message From: dj_rineer [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, March 26, 2008 9:14:18 AM Subject: [Axapta-Knowledge-Village] Re: ended production orders --- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, Hemant Kumthekar hemantdk66@ ... wrote: Yes we are on Standard cost. I do think the way to go is correcting the Inventory and GL. Yes raw materials were consumed with the excess production. Hi, Can you give details about the following 1. Costing method 2. Raw materials were also consumed or back flushed when excess production was updated may be we can rectify GL, Inventory entries. Hemant K - Original Message From: dj_rineer drineer@ To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Sent: Tuesday, March 25, 2008 8:46:27 AM Subject: [Axapta-Knowledge- Village] ended production orders I am on AX 3.0. Someone accidentally ended a production order that had too much production on it. I know you can not go back at this point and correct the original production order but is there a way to back out this excess production? _ _ _ _ _ _ __ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools. search.yahoo. com/newsearch/ category. php?category= shopping __ __ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping
RE: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax
Cristina, How to import from a *.csv file? i saved my excel into a .csv type of file but when trying to import it through import option it does not allow me to select the file of tyep .csv!! -Tushar Cristina Carcelén [EMAIL PROTECTED] wrote: Try to import from an *.csv file. Maybe you have some blanks records. - De: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] En nombre de Tushar Joshi [EMAIL PROTECTED] Enviado el: viernes, 21 de marzo de 2008 20:18 Para: Axapta-Knowledge-Village@yahoogroups.com Asunto: Re: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax Hi Nitesh, Thanks a lot for reply! but i tried this already... i have a doubt... if i try to import a single record then it is success but when i try to import another one it syas record already exists is it something to do with Number Sequences??? would appriciate if u cud throw some light on this :) Tushar Nitesh [EMAIL PROTECTED] wrote: Hi Tushar, seems Record already exist in Table From Import Dialog box go to Import Rule Tabpage and select the Option clear table before Import from Import Rule field. Regards Nitesh On 3/21/08, Tushar Joshi [EMAIL PROTECTED] wrote: Hi, I am trying to import the masterdata provided by client into Ax 4.0 SP2. I created a new blank company account in Ax to import data n started the excelimport through Administration - Periodic - Data Import/export - excel spreadsheets - excel import. but it gives an error and says the record already exists and import is interrupted. can anyone help me on how to import data through excel? The excel sheets were given ti client were created from same company account with a defnition group created. plz help.. Regards, Tushar - Meet people who discuss and share your passions. Join them now. - 5, 50, 500, 5000 - Store N number of mails in your inbox. Click here. #ygrp-mkp { BORDER-RIGHT: #d8d8d8 1px solid; PADDING-RIGHT: 14px; BORDER-TOP: #d8d8d8 1px solid; PADDING-LEFT: 14px; PADDING-BOTTOM: 0px; MARGIN: 14px 0px; BORDER-LEFT: #d8d8d8 1px solid; PADDING-TOP: 0px; BORDER-BOTTOM: #d8d8d8 1px solid; FONT-FAMILY: Arial } #ygrp-mkp HR { BORDER-RIGHT: #d8d8d8 1px solid; BORDER-TOP: #d8d8d8 1px solid; BORDER-LEFT: #d8d8d8 1px solid; BORDER-BOTTOM: #d8d8d8 1px solid } #ygrp-mkp #hd { FONT-WEIGHT: bold; FONT-SIZE: 85%; MARGIN: 10px 0px; COLOR: #628c2a; LINE-HEIGHT: 122% } #ygrp-mkp #ads { MARGIN-BOTTOM: 10px } #ygrp-mkp .ad { PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px } #ygrp-mkp .ad A { COLOR: #ff; TEXT-DECORATION: none } #ygrp-sponsor #ygrp-lc { FONT-FAMILY: Arial } #ygrp-sponsor #ygrp-lc #hd { FONT-WEIGHT: bold; FONT-SIZE: 78%; MARGIN: 10px 0px; LINE-HEIGHT: 122% } #ygrp-sponsor #ygrp-lc .ad { PADDING-RIGHT: 0px; PADDING-LEFT: 0px; MARGIN-BOTTOM: 10px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px } #ygrp-mlmsg { FONT: x-small arial,helvetica,clean,sans-serif } #ygrp-mlmsg TABLE { FONT-WEIGHT: normal; FONT-SIZE: 100%; LINE-HEIGHT: normal; FONT-STYLE: normal; FONT-VARIANT: normal } #ygrp-mlmsg SELECT { FONT: 99% arial,helvetica,clean,sans-serif } INPUT { FONT: 99% arial,helvetica,clean,sans-serif } TEXTAREA { FONT: 99% arial,helvetica,clean,sans-serif } #ygrp-mlmsg PRE { FONT: 100% monospace } CODE { FONT: 100% monospace } #ygrp-mlmsg * { LINE-HEIGHT: 1.22em } #ygrp-text { FONT-FAMILY: Georgia } #ygrp-text P { MARGIN: 0px 0px 1em } #ygrp-tpmsgs { CLEAR: both; FONT-FAMILY: Arial } #ygrp-vitnav { FONT-SIZE: 77%; MARGIN: 0px; PADDING-TOP: 10px; FONT-FAMILY: Verdana } #ygrp-vitnav A { PADDING-RIGHT: 1px; PADDING-LEFT: 1px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px } #ygrp-actbar { CLEAR: both; MARGIN: 25px 0px; COLOR: #666; WHITE-SPACE: nowrap; TEXT-ALIGN: right } #ygrp-actbar .left { FLOAT: left; WHITE-SPACE: nowrap } bld { FONT-WEIGHT: bold } #ygrp-grft { PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-SIZE: 77%; PADDING-BOTTOM: 15px; PADDING-TOP: 15px; FONT-FAMILY: Verdana } #ygrp-ft { PADDING-RIGHT: 0px; BORDER-TOP: #666 1px solid; PADDING-LEFT: 0px; FONT-SIZE: 77%; PADDING-BOTTOM: 5px; PADDING-TOP: 5px; FONT-FAMILY: verdana } #ygrp-mlmsg #logo { PADDING-BOTTOM: 10px } #ygrp-reco { PADDING-RIGHT: 0px; PADDING-LEFT: 0px; MARGIN-BOTTOM: 20px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px } #ygrp-reco #reco-head { FONT-WEIGHT: bold; COLOR: #ff7900 } #reco-grpname { MARGIN-TOP: 10px; FONT-WEIGHT: bold } #reco-category { FONT-SIZE: 77% } #reco-desc { FONT-SIZE: 77% } #ygrp-vital { PADDING-RIGHT: 0px; PADDING-LEFT: 8px; MARGIN-BOTTOM: 20px; PADDING-BOTTOM: 8px; PADDING-TOP: 2px; BACKGROUND-COLOR: #e0ecee } #ygrp-vital #vithd { FONT-WEIGHT: bold; FONT-SIZE:
RE: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax
Did not get you. which format we need? -Tushar Dharmanadi [EMAIL PROTECTED] wrote: Hi, Checked your excel format also for example Ledger table Regards, - From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Nitesh Sent: Friday, March 21, 2008 6:56 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax Hi Tushar, seems Record already exist in Table . From Import Dialog box go to Import Rule Tabpage and select the Option clear table before Import from Import Rule field. Regards Nitesh On 3/21/08, Tushar Joshi [EMAIL PROTECTED] wrote: Hi, I am trying to import the masterdata provided by client into Ax 4.0 SP2. I created a new blank company account in Ax to import data n started the excelimport through Administration - Periodic - Data Import/export - excel spreadsheets - excel import. but it gives an error and says the record already exists and import is interrupted. can anyone help me on how to import data through excel? The excel sheets were given ti client were created from same company account with a defnition group created. plz help.. Regards, Tushar - Meet people who discuss and share your passions. Join them now. - Did you know? You can CHAT without downloading messenger. Click here
Re: [Axapta-Knowledge-Village] Company ID's in axapta
Hi, It is not possible to modify now but in AX 5.0 the length of Company ID has been increased from 3 to 4. Regards, Swati Kabra. On 3/15/08, Joydeep Dasgupta [EMAIL PROTECTED] wrote: High Company ID is a column of a system Table named 'CompanyDomainList' where you will not be able to add a new column or delete any existing column or modify any structure. Thanks n Regards Joydeep *Axapta Material [EMAIL PROTECTED]* wrote: Hi All, Is it possible to increase the width of the company ID field? Currently it is of stringsize 3. Thanks in advacnce. D __ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs [Non-text portions of this message have been removed] -- Never miss a thing. Make Yahoo your homepage.http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs
Re: [Axapta-Knowledge-Village] Re: Expense Journal Error Message
Eddie, Thanks for the advice. Unfortunately all of those are set up. What is really strange is that I can post transactions from anywhere else. It is only the expense journal that gives me the error message. Marica - Original Message From: edwardjosling [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, March 27, 2008 2:53:24 PM Subject: [Axapta-Knowledge-Village] Re: Expense Journal Error Message Hi Possibly you can check the following: 1. Do you have an offset account for that journal line? 2. Set the rounding for each currency (General Ledger -- Setup -- Exchange rates) 3. Set the max penny difference value (as well as the one for secondary currency if you use secondary currency) in ledger parameters as conversion from currency values can casue rounding differences. Regards Eddie --- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, leroux_marica leroux_marica@ ... wrote: Issue Description = User has an issue that everytime they try to post an expense journal from the Projects Module the get an error message. Error message: Vocher JE_730003, date 2008/02/28, account 110180, amount currency - 11.50, amount MST - 11.50, alternative amount - 11.50, currency ZAR, text The transactions on voucher JE_730003 do not balance as per 2008/02/28. (Company currency: -11.50 - secondary currency: -11.50) Vocher JE_730003, date 2008/02/28, account 110180, amount currency 5.00, amount MST 5.00, alternative amount 5.00, currency USD, text The transactions on voucher JE_730003 do not balance as per 2008/02/28. (Company currency: 5.00 - secondary currency: 5.00) Posting has been cancelled Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs
RE: [Axapta-Knowledge-Village] Value Model Error Message
When you setup a depreciation book you are not allowed to enter one with the same name as an existing value model. What do you mean by link the depreciation book to the value model? There is several ways to setup value models and depreciation books to default together. First, you can setup Asset Group, Asset Book Group and Asset Depreciation Book Group records to automatically default value models and depreciation books when a new asset is created. You can also setup derived depreciation books on the value model to automatically post transactions to depreciation books when they are posted to value models. Let me know if you have further questions. Jason Dinham Senior Development Lead Microsoft Dynamics Ax This posting is provided AS IS with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm http://www.microsoft.com/info/cpyright.htm The code provided (if any) may be written from the point of view of a third party and the programming style/development standards may suit such a point of view. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of leroux_marica Sent: Thursday, March 27, 2008 1:57 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Value Model Error Message I receive an error message every time I try to link a depreciation model to a value model. Error message: Cannot create a record in Book lookup (AssetBookMergeLookup). Book: VEH, Value model. The record alredy exists. Any ideas? Thanks
Re: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax
Hi Tushar, Which Table you are trying to import ? On Thu, Mar 27, 2008 at 3:17 PM, Tushar Joshi [EMAIL PROTECTED] wrote: Did not get you. which format we need? -Tushar *Dharmanadi [EMAIL PROTECTED]* wrote: Hi, Checked your excel format also – for example Ledger table Regards, -- *From:* Axapta-Knowledge-Village@yahoogroups.com [mailto: [EMAIL PROTECTED] *On Behalf Of *Nitesh *Sent:* Friday, March 21, 2008 6:56 PM *To:* Axapta-Knowledge-Village@yahoogroups.com *Subject:* Re: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax Hi Tushar, seems Record already exist in Table . From Import Dialog box go to Import Rule Tabpage and select the Option clear table before Import from Import Rule field. Regards Nitesh On 3/21/08, Tushar Joshi [EMAIL PROTECTED]tushar_s_joshi%40yahoo.co.in wrote: Hi, I am trying to import the masterdata provided by client into Ax 4.0 SP2. I created a new blank company account in Ax to import data n started the excelimport through Administration - Periodic - Data Import/export - excel spreadsheets - excel import. but it gives an error and says the record already exists and import is interrupted. can anyone help me on how to import data through excel? The excel sheets were given ti client were created from same company account with a defnition group created. plz help.. Regards, Tushar - Meet people who discuss and share your passions. Join them now. -- Did you know? You can CHAT without downloading messenger. Click herehttp://in.rd.yahoo.com/tagline_webmessenger_2/*http://in.messenger.yahoo.com/webmessengerpromo.php