[Axapta-Knowledge-Village] Sales tax calculation
Hi all, I have some questions about Sales tax calculation. I create a PO with 1 line , Qty = 10, Unit price = 5$ -- Net Amount = 50$ Setup Sales tax group and Item sales tax group for PO Line -- the intersection Sales tax code is EU25% and EU18% EU25% has Origin: Percentage of Gross amount; MaginalBase: Net amount perline; Method of calculation: Whole amount Sales tax on sales tax : EU15% Value setup: Minimum limit = 0, Upper limit = 55 -- Value = 25 Minimum limit = 56, Upper limit = Blank -- Value = 28 EU18% has Origin: Percentage of Net amount; MaginalBase: Net amount perline; Method of calculation: Whole amount Sales tax on sales tax : Blank Value setup: Minimum limit = 0, Upper limit = Blank -- Value = 18 When I check PO/Setup/Sales tax, Axapta generates 2 lines of sales tax Line 1: EU25% : Amount origin: 59, Percent = 33.6, Sales tax amount = 16.52 Line 2: EU18% : Amount origin: 50, Percent = 18, Sales tax amount = 9 The figure in line 2 is OK, but in Line 1, I cannot find the logic of calculation of how Axapta calculate Percent and Sales tax amount. I have tried many cases but cannot found the logic. I am highly appriciated if anyone explains to me. Thanks a lot, Thang __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Errors in General ledger
Hi, 1) When I tried to open the following,an error is displaying. GL--Setup--Structures--setup--Intialize company level taxes/charges. The error is as follows. Cannot create a record in Charges Table (INDCompChargeGroupTable). Charge Group: Charges, Define various types of charges. The record already exists. 2)GL--setup--Structures--Structure details Tab---For creating a record,new icon is disabled/not appearing. Please advice me Best Regards, K.V.S.Sitaram, Functional consultant-MicroSoft Dynamics;ERP Mobile: +91-932090 __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Create prodjournalroute register
Hi all, How can I create a register in prodjournalRoute by Code? Thanks, Best Regards, Alfonso -- This e-mail and any attachments are confidential. If you are not the named or intended recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose or store or copy the information in any medium. Any unauthorized disclosure, use or storage is prohibited and might be unlawful. - This E-mail and any attachments are confidential. If you are not the named or intended receipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose or store or copy the information in any medium. Any unauthorized disclosure, use or storage is prohibited and might be unlawful. [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] News-Flash of Axapta Knowledge Village
Dear visitors of the Axapta Knowledge Village, The Axapta Knowledge Village is heading towards the end of a successful year and would like to thank all 3200 members for their contribution and support. We Wish Everyone a Merry Christmas, Happy New Year, and a Great 2007! Join the Axapta Friends Map at Frappr http://www.frappr.com/axapta . Sign in as an Axapta Friend and shoutout your best wishes to everyone. Stay informed between Christmas and New Year, come and read more about Microsoft Dynamics AX on the Axapta Knowledge Village http://axapta-knowledge-village.blogspot.com/ Share the Axapta Knowledge, the Axapta Knowledge Village [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Auto Declaration property is not working
Hi all, I m having a serious problem. I m creating a report based on production order. For this I want to calculate some quantity from code also. Now problem is, when I set the auto declaration property of ProdOrder field in report body to yes, all values of ProdOrder field are 1 only and not taking the actual values. Wat can b the solution on this problem? Please help me urgently. Regards, Ashish.
[Axapta-Knowledge-Village] COM+ and Java
Dear All, This is my first post :) Can any one told me is it posible to connect trough a java application into AXAPTA using the COM+ ? Regards, Yahya - Original Message - From: billur_kardas_1982 To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, December 28, 2006 4:08 PM Subject: [Axapta-Knowledge-Village] Re: Importing --- In Axapta-Knowledge-Village@yahoogroups.com, febinpc [EMAIL PROTECTED] wrote: hai what will happen to the usr layer when we import 'var' layer objects. will it overwrite the 'usr' layer or 'usr' will remain same? and at the time of running application what will happen? will it run on old 'usr' layer ? Usr layer will still remain same..if so you should delete the usr and import the code in var layer -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.15.28/604 - Release Date: 12/26/2006 12:23 PM [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Number sequence-Error
It sounds like you are entering a customer number yourself which is conflicting with how you have the number sequence set-up for the customer numbering. You either have a mask that is different from what you are entering or you have it set to continuous which means that the system needs to allocate the next number. If you had the wizard create the number sequences then the one for customers would be Acco_16; review the set-up. David From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of k.v.s.sitaram Sent: Tuesday, December 26, 2006 2:13 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Number sequence-Error Hi, When I tried to save a created vendor/Customer account,it is informing that,Number sequence not defined properly. Please advice me [Non-text portions of this message have been removed]
RE: RE: [Axapta-Knowledge-Village] Number sequence-Error
Hi I bet it is the missing reference in CRM module.*s* Regards harry From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Bonk, David Sent: 29 December 2006 14:58 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Number sequence-Error It sounds like you are entering a customer number yourself which is conflicting with how you have the number sequence set-up for the customer numbering. You either have a mask that is different from what you are entering or you have it set to continuous which means that the system needs to allocate the next number. If you had the wizard create the number sequences then the one for customers would be Acco_16; review the set-up. David From: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of k.v.s.sitaram Sent: Tuesday, December 26, 2006 2:13 AM To: Axapta-Knowledge-Village@yahoogroups.commailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Number sequence-Error Hi, When I tried to save a created vendor/Customer account,it is informing that,Number sequence not defined properly. Please advice me [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: »Ø¸´£º [Axapta-Knowledge-Village] Settlement reversal
Whenever I select a closed transaction, Axapta selects the associated voucher so that it is never unbalanced when the Reverse button is clicked. If you see that Axapta does this but still gives you the message below then it is a bug. However when you start deleting transactions in tables; you are asking for problems and this should never be considered a solution. Many tables are updated with a single transaction so when you start deleting from only one table you are affecting the integrity of the data base. David From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of billur_kardas_1982 Sent: Thursday, December 28, 2006 4:50 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: »Ø¸´£º [Axapta-Knowledge-Village] Settlement reversal Hi, If you have solved this problem without coding, could you tell me how..Or was that a bug? Thanks, --- In Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com , William Wei [EMAIL PROTECTED] wrote: Hi Hennie, I wonder if we can solve this problem with no development? Why would thsi happen? Does it a bug? William People's Republic of China [EMAIL PROTECTED] Hennie Potgieter [EMAIL PROTECTED] дµÀ£º Hi, We quite often have to reverse payments and general journal vouchers that have been settled against a customer (Sales Ledger Customers Functions Closed Transaction editing). This occasionaly give us problems amongst which 1) Voucher ' ' could not be found errors, 2) The marked transactions do not balance errors are the most frequently encountered. Usually I have to go into table.SpecTrans and delete the affected records and then redo the reversal. This usually solves the problem. Ocasionally however (like now) I find that regardless of the tick box status in Closed Transaction editing there exist no records is table.SpecTrans. The records do however exist in table.CustSettlement but never go through to SpecTrans regardless of the fact that I tick the records on the Closed Transaction editing form. The result is that I cannot reverse any of the settlements. It keeps saying Voucher ' ' does not exist. Does anyone have any idea how to solve this? -* Hennie Potgieter Senior Business Analyst UTi SUN Couriers Division Centurion, South Africa Cell: 0829208315 mailto: [EMAIL PROTECTED] Sharing the knowledge on Axapta. - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:Axapta-Knowledge-Village-unsubscribe%40yahoogroups.com Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - DO YOU YAHOO!? ÑÅ»¢Ãâ·ÑGÓÊÏä£ÖйúµÚÒ»¾øÎÞÀ¬»øÓʼþɧÈų¬´óÓÊÏä [Non-text portions of this message have been removed]
Re: »Ø¸´£º [Axapta-Knowledge-Village] Se ttlement reversal
Hi Hennie Check if the specific voucher u are trying to reverse is marked again (the red hand) in any GL or Payment Journal lines for settlement and left unposted.(applicable in case there was partial settlement done before on the same voucherand the remaining is settled again). The error will not occur if such multiple settlements are posted. Hope this helps. I agree with David that deleting records from a table is no solution. Regds Hema Krish - Original Message From: Bonk, David [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, December 29, 2006 8:04:24 PM Subject: RE: »Ø¸´£º [Axapta-Knowledge-Village] Settlement reversal Whenever I select a closed transaction, Axapta selects the associated voucher so that it is never unbalanced when the Reverse button is clicked. If you see that Axapta does this but still gives you the message below then it is a bug. However when you start deleting transactions in tables; you are asking for problems and this should never be considered a solution. Many tables are updated with a single transaction so when you start deleting from only one table you are affecting the integrity of the data base. David _ _ __ From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of billur_kardas_ 1982 Sent: Thursday, December 28, 2006 4:50 AM To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Subject: Re: »Ø¸´£º [Axapta-Knowledge- Village] Settlement reversal Hi, If you have solved this problem without coding, could you tell me how..Or was that a bug? Thanks, --- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com mailto:Axapta- Knowledge- Village%40yahoog roups.com , William Wei softbase57@ ... wrote: Hi Hennie, I wonder if we can solve this problem with no development? Why would thsi happen? Does it a bug? William People's Republic of China [EMAIL PROTECTED] Hennie Potgieter hpotgieter@ ... дµÀ£º Hi, We quite often have to reverse payments and general journal vouchers that have been settled against a customer (Sales Ledger Customers Functions Closed Transaction editing). This occasionaly give us problems amongst which 1) Voucher ' ' could not be found errors, 2) The marked transactions do not balance errors are the most frequently encountered. Usually I have to go into table.SpecTrans and delete the affected records and then redo the reversal. This usually solves the problem. Ocasionally however (like now) I find that regardless of the tick box status in Closed Transaction editing there exist no records is table.SpecTrans. The records do however exist in table.CustSettlemen t but never go through to SpecTrans regardless of the fact that I tick the records on the Closed Transaction editing form. The result is that I cannot reverse any of the settlements. It keeps saying Voucher ' ' does not exist. Does anyone have any idea how to solve this? -* Hennie Potgieter Senior Business Analyst UTi SUN Couriers Division Centurion, South Africa Cell: 0829208315 mailto: [EMAIL PROTECTED] .. Sharing the knowledge on Axapta. - - --- Yahoo! Groups Links To visit your group on the web, go to: http://groups. yahoo.com/ group/Axapta- Knowledge- Village/ http://groups. yahoo.com/ group/Axapta- Knowledge- Village/ To unsubscribe from this group, send an email to: Axapta-Knowledge- Village-unsubscr [EMAIL PROTECTED] com mailto:Axapta- Knowledge- Village-unsubscr ibe%40yahoogroup s.com Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - --- DO YOU YAHOO!? ÑÅ»¢Ãâ·ÑGÓÊÏä£ÖйúµÚÒ»¾øÎÞÀ¬»øÓʼþɧÈų¬´óÓÊÏä [Non-text portions of this message have been removed] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed]