RE: [Axapta-Knowledge-Village] Inventory OBs
Faiqa; This does not answer your specific question but when we imported inventory OBs we brought it in through the Profit and loss journal and had none of the problems that you mention. You obviously will have other issues to consider such as the PL journal creates GL entries however from the inventory perspective; it worked well. David From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Faiqa Khushi Sent: Tuesday, February 20, 2007 6:31 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Inventory OBs Importance: High Hi everyone, I am facing an issue while importing inventory OBs in Movement Journal. I am importing records in InventJournalTable, InventJournalTrans and InvenDim. It imports the records successfully in inventjournaltable and inventjournaltrans , but in invendim it generate errors against many records that the record already exist. When I check that record in invendim table using query analyzer , there wasn't that record against which it generate that error . Can anyone explain that how it generate InvenDimID for each record and can we make our own invendimid or there is some logic behind generating this id ? It would be great if someone can write the steps of importing inventory OBs into the system. Regards, Faiqa [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] create report with only cost center dimension
If you are using 4.0 then you could create a financial statement and run it with a dimension focus. David From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of IRWAN Sent: Thursday, February 01, 2007 4:42 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] create report with only cost center dimension Hello everyone, im a new axapta user. I would like to create finance report based on only cost center dimension and disregard other dimension such as departement or propose. Would someone kind to help? [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Re: Intercompany Organization Setup
Pam; What version are you implementing this in? My understanding is that you also have to link the items between the companies using external codes. David -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of ashwathi_123 Sent: Tuesday, January 30, 2007 1:32 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Intercompany Organization Setup basic set up inter company relationship example A1 COMPANY SELECT BASIC,SETUP,GATWAY,ORGANIZATIONS,OVERVIEW TAB. SELECT ORGANIZATION ACCOUNT NO 101 INTER COMPANY.NOTICE THAT THIS COMPANY HAS A CHECKMARK IN THE FIELD INTER COMPANY ORGANIZATION. NOW WE WILL SELECT THE GENERAL TAB AND CHANGE THE COMPANY CODE TO A2 NEXT, WE NEED TO SET UP THE A1 COMPANY TO BE ABLE TO A CUSTOMER IN THIS TRANSACTION.BY CLICKING THE REFERENCE BUTTON, WE CAN ADD A CUSTOMER REFERENCE BY CLICKING TYPE FIELD AND SELECTING CUSTOMER, 101, THAT WILL BE USED FOR THE INTERCOMPANY ORGANIZATION TRANACTION. NOW WE NEED TO GO BACK TO THE MAIN MENU AND OPEN COMPANY A2 BY SELECTING FILE -OPEN-COMPANY-A2 FROM THE MAIN MENU OF THE A2 COMPANY, WE WILL SELECT BASIC-SETUP- GATWAY-ORGANIZATIONS-OVERVIEW TAB. THEN WE WILL AGAIN SELECT ORGANIZATION 101 INTER COMPANY AND SELECT THE GENERAL TAB.HERE WE WILL CHANGE THE COMPANY CODE TO 101. NOW AGAIN, BY CLICKING THE REFERENCE BUTTON, WE CAN ADD A VENDOR REFERENCE BY CLICKING IN THE TYPE FIELD AND SELECTING VENDOR.THEN WE WILL SELECT THE INTERCOMPANY VENDOR 102 YHAT WILL BE USED IN OUR CURRENT A2 COMPANY FOR THE INTERCOMPANY ORGANISATION TRANACTION. select possible action button and provide the details also. WE HAVE NOW ESTABILISHED RELATIONSHIP BETWAEEN THE A1(CUSTOMER) AND A2(VENDOR) COMPANY WHICH WILLYOU MAY CREATE INTER COMPANY PURCHAE ORDER IN THE A2 COMPANY. THANKS AND REGARDS EMPORIS ACADEMY P.LTD, CHENNAI 9940068165 --- In Axapta-Knowledge-Village@yahoogroups.com, Pamela Caliguiri [EMAIL PROTECTED] wrote: Hello to everyone. I am really confused about how to go about setting up the necessary intercompany Organization entries for the following scenario: In Company # 1 (SU4), I want to enter a Purchase Order for Vendor 39101 and have it automatically issue a Sales Order for Customer 190301 in Company # 2 (PFA). I understand that I have to establish the intercompany relationship by setting up a customer and a vendor entry in the Gateway Organization table, but I am not sure which company needs the vendor setup (I had assumed it was Co. #1 with a reference entry to the customer in Co. #2. Do I need to establish the reverse relationship in BOTH companies? In other words, does every Intercompany Organization entry in a company consist of both relationships? I have tried this several ways and can never seem to get it to work. I have also read all of the other posts concerning the Intercompany setup, but still not sure how to do this in the proper sequence within the companies. Any help would be greatly appreciated. THANKS, Pam 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] Re: Intercompany Organization Setup
When we set this up we used external codes for each item; that is the only way that the inter company SO will add the correct item(s) on the original PO. Therefore it has to be a one to one not a one to many. David From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Pamela Caliguiri Sent: Tuesday, January 30, 2007 10:11 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Intercompany Organization Setup we are running version 3.0, but I thought all we needed to do on the Item end was to set up a Company Item that would link all of the items together regardless of the company where they reside. --- In Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com , Bonk, David [EMAIL PROTECTED] wrote: Pam; What version are you implementing this in? My understanding is that you also have to link the items between the companies using external codes. David -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of ashwathi_123 Sent: Tuesday, January 30, 2007 1:32 AM To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Intercompany Organization Setup basic set up inter company relationship example A1 COMPANY SELECT BASIC,SETUP,GATWAY,ORGANIZATIONS,OVERVIEW TAB. SELECT ORGANIZATION ACCOUNT NO 101 INTER COMPANY.NOTICE THAT THIS COMPANY HAS A CHECKMARK IN THE FIELD INTER COMPANY ORGANIZATION. NOW WE WILL SELECT THE GENERAL TAB AND CHANGE THE COMPANY CODE TO A2 NEXT, WE NEED TO SET UP THE A1 COMPANY TO BE ABLE TO A CUSTOMER IN THIS TRANSACTION.BY CLICKING THE REFERENCE BUTTON, WE CAN ADD A CUSTOMER REFERENCE BY CLICKING TYPE FIELD AND SELECTING CUSTOMER, 101, THAT WILL BE USED FOR THE INTERCOMPANY ORGANIZATION TRANACTION. NOW WE NEED TO GO BACK TO THE MAIN MENU AND OPEN COMPANY A2 BY SELECTING FILE -OPEN-COMPANY-A2 FROM THE MAIN MENU OF THE A2 COMPANY, WE WILL SELECT BASIC-SETUP- GATWAY-ORGANIZATIONS-OVERVIEW TAB. THEN WE WILL AGAIN SELECT ORGANIZATION 101 INTER COMPANY AND SELECT THE GENERAL TAB.HERE WE WILL CHANGE THE COMPANY CODE TO 101. NOW AGAIN, BY CLICKING THE REFERENCE BUTTON, WE CAN ADD A VENDOR REFERENCE BY CLICKING IN THE TYPE FIELD AND SELECTING VENDOR.THEN WE WILL SELECT THE INTERCOMPANY VENDOR 102 YHAT WILL BE USED IN OUR CURRENT A2 COMPANY FOR THE INTERCOMPANY ORGANISATION TRANACTION. select possible action button and provide the details also. WE HAVE NOW ESTABILISHED RELATIONSHIP BETWAEEN THE A1(CUSTOMER) AND A2(VENDOR) COMPANY WHICH WILLYOU MAY CREATE INTER COMPANY PURCHAE ORDER IN THE A2 COMPANY. THANKS AND REGARDS EMPORIS ACADEMY P.LTD, CHENNAI 9940068165 --- In Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com , Pamela Caliguiri pcaligui@ wrote: Hello to everyone. I am really confused about how to go about setting up the necessary intercompany Organization entries for the following scenario: In Company # 1 (SU4), I want to enter a Purchase Order for Vendor 39101 and have it automatically issue a Sales Order for Customer 190301 in Company # 2 (PFA). I understand that I have to establish the intercompany relationship by setting up a customer and a vendor entry in the Gateway Organization table, but I am not sure which company needs the vendor setup (I had assumed it was Co. #1 with a reference entry to the customer in Co. #2. Do I need to establish the reverse relationship in BOTH companies? In other words, does every Intercompany Organization entry in a company consist of both relationships? I have tried this several ways and can never seem to get it to work. I have also read all of the other posts concerning the Intercompany setup, but still not sure how to do this in the proper sequence within the companies. Any help would be greatly appreciated. THANKS, Pam 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 [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: »Ø¸´£º [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] How do I cancel or reverse a posted Packing slip on a sales order?
In the quantity tab, receive now field you enter a negative quantity and then post the packing slip using the deliver now drop down option. David From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of anishafakir1 Sent: Wednesday, December 20, 2006 8:56 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] How do I cancel or reverse a posted Packing slip on a sales order? Hi, I would like to know if it is possible cancel or reverse a posted packing slip on a sales order? How can we do this. Thanking you in advance Anisha [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Re: Ax 4.0 login screen as 3.0
Harsh; If you mean user input to be the 3.0 menu then try: Open AOT - Menus - Main Menu (right click on this and select 'Open'). I have not tried this in a while and do not know how to go back so try this out for yourself first. David From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ax Dev Sent: Monday, December 18, 2006 6:06 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Re: Ax 4.0 login screen as 3.0 Hi Friends, It was asked from one of our costumers as well. Does anyone has the solution of how to provide the same kind of user input in Ax4.0 as we have in Ax3.0? It is something very interesting and we are curious to know about it. Please share your views. Thanks Regards, Harsh On 12/18/06, John Lindsay [EMAIL PROTECTED] mailto:jtl%40dragonsfoot.com wrote: You can use the runas command to change the user Confidentiality Notice: This e-mail contains confidential and/or privileged information and is intended to be read only by the person or authorized representative of the organization to whom it is addressed. If you are neither of these persons, you have received this e-mail in error. Please do not print, copy, re-transmit, disseminate or otherwise use the information, all of which are prohibited. Please immediately notify the sender by return e-mail or by telephone at (303) 593-1246 that you have received this communication in error and delete this e-mail from your system. Thank you. MBS Dynamics AX Master John T. Lindsay Micro Sciences 303 593-1246 720 982-4620 _ From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of Andreas Rudischhauser Sent: Saturday, December 16, 2006 4:48 AM To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Axapta-Knowledge-Village%40yahoogroups.com Subject: AW: [Axapta-Knowledge-Village] Re: Ax 4.0 login screen as 3.0 Please contact Mr. Schuster on schuster(AT)back2.biz. Von: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] mailto:Village%40yahoogroups.com Village%40yahoogroups.com [mailto:Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] mailto:Village%40yahoogroups.com Village%40yahoogroups.com] Im Auftrag von Hardi Gesendet: Samstag, 16. Dezember 2006 00:52 An: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] mailto:Village%40yahoogroups.com Village%40yahoogroups.com Betreff: [Axapta-Knowledge-Village] Re: Ax 4.0 login screen as 3.0 As Ax40 is integrated with active directory, I think what is required is to prompt user to re-enter login/password when application started. This is something being asked too from my customer. Thanks Hardi --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoog roups.com [EMAIL PROTECTED] mailto:Village%40yahoogroups.com Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com , Jake [EMAIL PROTECTED] wrote: Hi Andreas - Do you have any info on how this is being done? Are you doing a second Active Directory login? Thanks, Jake http://axaptasource http://axaptasource.com http://axaptasource.com .com --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] mailto:Village%40yahoogroups.com Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com , Andreas Rudischhauser Andreas.Rudischhauser@ wrote: We're currently in development. I will post the link here in a few days Von: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] mailto:Village%40yahoogroups.com Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] mailto:Village%40yahoogroups.com Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] Im Auftrag von Agus Riyadi Gesendet: Donnerstag, 14. Dezember 2006 03:14 An: Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED] mailto:Village%40yahoogroups.com Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Betreff: [Axapta-Knowledge-Village] Ax 4.0 login screen as 3.0 Hi All, Is there any setting or workaround so that user can have a login screen in Axapta 4.0 like in 3.0 ? Thanks, Agus [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions
RE: [Axapta-Knowledge-Village] a problem in invoice register
Amit; My understanding of using the register/ approve process rather than just entering the invoice using Invoice journal is that there is a paper approval process in the company and by entering an employee as the approver you are documenting on the transaction that that they approved (or have been sent it for approval) the invoice for payment. Therefore the process would be; invoice comes in, gets registered, invoice is sent to person authorizing the purchase to approve the invoice, invoice is then entered into the approval journal to complete the process. So by entering the approval employee's name AP can track who has still not approved invoices that have been sent to them. That is why you would not want to default an employee code when you register invoices; you want AP to enter the correct employee. David From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Amit Nirantare Sent: Tuesday, December 19, 2006 8:59 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] a problem in invoice register Hi, In invoice register (Accounts Payable-Journal-Invoice register), the apporved by is required for the posting of the journal. It is not defaulted with the user who has logged in. i do not know if i am missing any setup. If do not enter the employee and try to validate register and you will get emp is not specified. I am talking of this emp to get defaulted as per the users who has logged in. Can an one of you guide me as to why this is not happening. Thanks in advance.. Amit [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Project Module - Billing Schedule
You will need the PSA module from FolioDev. David From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of yuli tany Sent: Friday, December 15, 2006 4:14 AM To: axapta knowledge village Subject: [Axapta-Knowledge-Village] Project Module - Billing Schedule Hi Guys, Is there any functionality in Axapta to do the billing schedule for Fixed Term project? Like recurring Journal in GL? For example 1 year Project : 12.000 and they will bill once in a month, whc is : 1.000 So everymonth they just call the Journal to bill 1.000. Thanks, Yuliana __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com http://mail.yahoo.com [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] How to use Dimension Wizard
You need to buy the license for extra dimensions before it will work. David From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Faiqa Khushi Sent: Friday, December 15, 2006 3:02 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] How to use Dimension Wizard Hi, How can we add new dimension in GL . Dimension Wizard is available with Dynamics Axapta but I want to know the prerequisites and exact steps we shall follow to create a new dimension. I tried it by using wizard but got different errors. If someone has already done this then please list the exact steps require to establish new dimension. Regards. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Multiple Users while running Invent Recalculation/Invent Closure/Master Planning
Depending on your inventory valuation method that you are using it is more important to run this for some methods (fifo, lifo, weighted avg) than others (standard) as this is where the system recalculates your actual costs for each transaction during the month. When you use FIFO for example the system will originally post transactions at an average cost and then when you run the revaluation function it sorts through the FIFO 'buckets' and creates adjustment entries for the transactions. Regarding the closure aspect it is like closing financial periods in that it prevents transactions in a closed period. Hope this helps. David From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of neyvelisrinivasan Sent: Thursday, December 14, 2006 12:58 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Multiple Users while running Invent Recalculation/Invent Closure/Master Planning Friends, Is it mandatory to run the Inventory Recalculation/Inventory Closure/Master planning under single user environment. If yes, what is the easy way to handle this issue. What will be the consequence if Users are allowed to transact during the above process. Regards, R.Rajamani [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Landed Cost in Axapta
There is no specific landed cost functionality; the only way that I have figured out how to do it is to add costs through miscellaneous charges. David From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Faiqa Khushi Sent: Wednesday, December 06, 2006 4:59 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Landed Cost in Axapta Importance: High How Axapta deals with landed cost? Is there any feature available through which we can add landed cost amount in item cost? Faiqa [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] US Sales tax setup
Tahir; I am not sure if I understand the question; are you saying this customer is taxable in one county but not in another? When you say a city the only state that I know that has taxes calculated at a lower level than a county is New Orleans as they calculate tax at a parish level. Anyway you assign a 'default' tax group to a customer; this populates the header of the sales order however it can be changed for a particular sales order if necessary. This is the only way that I can think of changing the taxes for a customer if it is taxed differently in a different county (and city). David From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of TAHIR AZIZ Sent: Monday, December 04, 2006 11:16 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] US Sales tax setup Thanks David, How we deal with the scenario that a perticular customer can have exemption certificate in some county of some city. How we can do that. Thanks Tahir Aziz Bonk, David [EMAIL PROTECTED] mailto:david.bonk%40visalign.com wrote: Tahir; You can set-up US sales tax with standard Axapta functionality however depending on the number of states that the company sells to you might want to use a service like you mentioned. The problem is the large number of different taxing authorities (counties) in each state makes the set-up tricky and maintenance an issue. Some companies that I have worked with will pick one county in a state and pay all taxes to them for that state's sales. This is not correct but it makes setting up taxes very easy. Generally the Sales tax groups are set-up for each county in a state; these are attached to the customer as that dictates where the sale is made. The item sales tax group would have all codes that are in the Sales tax group and would be attached to the items. Then you deal with the exceptions with different groups for each. David From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of aziz.tahir Sent: Thursday, November 30, 2006 9:59 PM To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] US Sales tax setup Hi Can somebody through light on how to setup US sales tax structure on Axapta. OR do we have to use third party software for this e.g. Vertax or Taxware. Please advice, Thanks in Advance, Tahir Aziz [Non-text portions of this message have been removed] - Access over 1 million songs - Yahoo! Music Unlimited. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Grouping Customers
On a customer you can have an 'invoicing account' which means you can invoice a parent account rather than the ordering customer (delivery address) Also in 4.0 you can set the invoicing address as the invoicing account or the order account so you can send the invoice to either address for payment. This gives you some grouping ability. As far as credit limit at the parent level and other features, it is not there yet. David From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Faiqa Khushi Sent: Monday, December 04, 2006 4:53 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Grouping Customers Importance: High Does Axapta Dynamics support National Accounts (i.e. grouping customers in parent child relation)? Faiqa [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Intercompany ActionID
What about on the items? You need to have them defined also. David From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of yuli tany Sent: Tuesday, December 05, 2006 9:43 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Intercompany ActionID Hi all, When I was trying to setup the Intercompany SO/PO, system always prompt me this msg: conversion of code not specified So far, i have specified all the things, I use external code for the Customer/Vendor and I've attached this code to teh Customer/Vendor too. Please help. Thanks, 'Joels --- andreas gunawan [EMAIL PROTECTED] mailto:andreas2975%40yahoo.com wrote: Dear Karina, tks a lot for your answer. I've tried and it works good. Rgds, Karina Normann Jakobsen [EMAIL PROTECTED] mailto:kjakobse%40microsoft.com wrote: You should be able to create the actions. Open End points form. Press button Action policies, then press button Create Actions. [cid:image001.jpg@01C717B7.265F1CD0 mailto:image001.jpg%4001C717B7.265F1CD0 ] Karina Normann Jakobsen Program Manager Microsoft Dynamics AX Microsoft Corporation From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of andreas gunawan Sent: 4. december 2006 14:30 To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Intercompany ActionID Dear All, I can't find how to create intercompany actionID (in Basic à Setup à Applcation integration framework à Endpoints à Action policies button à tab overview) where it should be available in the demo database contains purchaserequisition and sales order after reinstalled AX 4.0, prior to reinstall, it still exists. I am really confusing now. I appreciate your answer so much. Tks in advance. Rgds, - Everyone is raving about the all-new Yahoo! Mail beta. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] - Have a burning question? Go to Yahoo! Answers and get answers from real people who know. [Non-text portions of this message have been removed] __ Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail beta. http://new.mail.yahoo.com http://new.mail.yahoo.com [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] AX 4.0 Financial Statement help
John; Based on my time working on the statements I do not see how you could accomplish this as it asks for a column type and allows only one selection. I have built statements with six columns and because it scales the reports, the six columns fit without problem. David From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Sent: Tuesday, December 05, 2006 11:04 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] AX 4.0 Financial Statement help Hi All, In creating statement columns in 4.0 -is there any way to include both amount and quantity in the same column? We're doing cost per tons analysis and using two columns takes up too much real estate. Has anyone came across this, or have an ideas? Thanks, -John R. [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] US Sales tax setup
Tahir; You can set-up US sales tax with standard Axapta functionality however depending on the number of states that the company sells to you might want to use a service like you mentioned. The problem is the large number of different taxing authorities (counties) in each state makes the set-up tricky and maintenance an issue. Some companies that I have worked with will pick one county in a state and pay all taxes to them for that state's sales. This is not correct but it makes setting up taxes very easy. Generally the Sales tax groups are set-up for each county in a state; these are attached to the customer as that dictates where the sale is made. The item sales tax group would have all codes that are in the Sales tax group and would be attached to the items. Then you deal with the exceptions with different groups for each. David From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of aziz.tahir Sent: Thursday, November 30, 2006 9:59 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] US Sales tax setup Hi Can somebody through light on how to setup US sales tax structure on Axapta. OR do we have to use third party software for this e.g. Vertax or Taxware. Please advice, Thanks in Advance, Tahir Aziz [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] regarding Axapta certification
For the finance exam remember that you need to also study Fixed Assets. I used the MS training manuals and the on-line course with a lot of hands on as you need to know navigation as well as functions. The on-line course was very boring and as a result very hard to keep your attention however it did provide good exam question examples. For future exams I will just use the manual and the hands on approach. Good luck. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Sri ni Sent: Tuesday, May 16, 2006 1:04 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] regarding Axapta certification hi all! i would like to write Axapta certification exam on finance Can any body help me to 1)prepare for the exam ? 2)pattern of examination ? 3)What are the suggestable sites, books Please let me know soon Thanks Srini - Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1cent;/min. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" 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.
RE: [Axapta-Knowledge-Village] changing Inventory model
We were thinking of doing this for a customer and were wondering what would have to be done to accomplish it. The information from Jens is a good idea; we thought also to reduce the quantities to zero and do a recalculation to ensure the cost is zero. Then re-enter the quantities so that you have correct FIFO layer of the cost. One thing that we found using FIFO is that if your goes negative that it adversely affects your cost re-calculations; Microsoft strongly recommends that you do not let your inventory go negative using this method. This is very risky so I suggest testing these steps before you do it in your live company. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Jens Strandberg Sent: Tuesday, May 02, 2006 5:30 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] changing Inventory model Hello gammelskrot1, Well, I don't know if this helps you, but you would probably have to cancel all invent closings, calculations and regulations back to the beginning of the fiscal year. Then you change the inventory model, Afterwards you do invent closing month by month again. /Jens -Oprindelig meddelelse- Fra: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] vegne af gammelskrot1 Sendt: 1. maj 2006 18:12 Til: Axapta-Knowledge-Village@yahoogroups.com Emne: [Axapta-Knowledge-Village] changing Inventory model Hi, one of my customers want to change the Inventory Model toward FIFO. Can't remember what they use today. Does anyone have a procedure for this. HK Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" 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.
RE: [Axapta-Knowledge-Village] Reverse Payment Journal with Status None
Shiela; If the journal is posted, the only steps that I can suggest is go to the bank and see if the checks are there where you can reverse them (my guess is that they will not be there as there appears to be a problem with your set-up). The only other step that I can think of is to reverse the closed transaction through the supplier accounts but this reverses both the payment and the invoice. Take a back-up of your production company and test these out to be sure that they work for you. As far as the posting of the payment journal; the payment process is a multi-step, manual process. You must first select the vouchers that you want to pay, make the payments and then post. I do not understand your comment as it suggests that the journal is posted automatically. Posting should only be done if the printing is completed satisfactorily. David -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of squeela70 Sent: Monday, April 24, 2006 6:21 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Reverse Payment Journal with Status None Hello. I have only been using Axapta for a few months as an accountant, not a programmer/developer. Can anyone tell me the best way to completely reverse ALL transactions in a payment journal that has the payment status of None, no check numbers assigned, but has been posted? Also, is there a way to stop postings before check numbers have been assigned and checks printed? Thank you, Shiela Slothower [EMAIL PROTECTED] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" 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.
RE: [Axapta-Knowledge-Village] How to maintain stock of Stationery items
Satya; How detailed do they track this information; do they want to relive inventory every time a person takes a pad of paper or do they take a count at the end of the month and want to adjust the balance? This will have a big impact on how you relieve the inventory. The former is much harder as you need to enter a transaction each time; this which would suggest a SO for $0 amount and the latter they could use the counting or PL journal. David -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Satya Prakash Sent: Tuesday, April 04, 2006 7:50 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] How to maintain stock of Stationery items Hi friends I want to maintain stock of stationery items in AXAPTA 3.0. To purchase these items, I can use Accounts payable module. but while issuing these items, what functionality in Axapta, should I use? I cannot use Accounts Receivable module, since I am not selling these items. Can I use Production issue functionality for it? If yes, how? thanks regards Satya [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] SOX/SAP....Segregation of duties etc
James; A good example of this is that a person can enter a PO, receive the goods or services and post the invoice for payment all in one form. There is no control on this other than form level security which is very hard to set-up and maintain. I do not know SAP but in Baan you had different menu items for each of these steps which made it easier to control who gets into the sessions. I asked MS if they were going to split out the posting functionality in version 4 and they are not. Therefore you are left with form level security to get your division of duty. David -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of James Flavell Sent: Friday, March 10, 2006 12:17 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] SOX/SAPSegregation of duties etc Hi everyone, Does anyone have any ideas for how to get some segregation of duties functionality in Axapta? My prospect has SAP globally but may not take for their local office if Axapta is convincing enough. They mention the 'segregation of duties' reporting in SAP is very important and a big factor in the decision so I am trying to get something done with Axapta's security. Can anyone give any insight/ideas on: 1) How or what exactly SAP does in security. From what I gather it is having some role/function based setup whereby admin can select a user is a 'Purchase order entry clerk'. Is this correct? If so are all these roles just 'hard coded' templates that SAP make available? 2) Anything on the reporting of 'conflict of duties' that supposedly is in SAP. I mean how does SAP know what conflicts, are all the checks hard coded? 3) How can Axpata security be like SAP? For this I thought one way is A) to be able to let the user run through a process with a 'security profiler' which will gather all the tables and objects accessed and then create a user group that has rights to these objects set. This way it is easier for the admin to setup security in Axapta (i.e. they don't have to know which table they just have to run the 'security profiler'). I know its not fool proof but it's a good start (something proabably a lot of customers would like), so anyone any ideas on what classes I should be looking at (I am sure there must be some high level ones I can use without too much modification) B) how to do conflict of duties? I am really interested to know how this could be done.anyone any bright ideas..I am toying with some kind of mathemathical matrix/weighting of each table in each module and then comparing across modules to see but not sure this can work or how to go about it. Looking forward to working on this topic with you all (I am sure its one that many have had their customers/prospects ask about) Thanks James [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] NO stock on hand with a value
Also if you are using an inventory method other than standard; transactions during the month are done at a weighted average which could be different than the actual valuation. Do an inventory recalculation on this item and it should adjust the cost to zero. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andreas Rudischhauser Sent: Tuesday, February 28, 2006 9:10 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: AW: [Axapta-Knowledge-Village] NO stock on hand with a value This is normal... have no time to describe it at the moment, but if you think about time differences between invoice and delivery you may figure it out Von: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag von yifath1 Gesendet: Dienstag, 28. Februar 2006 14:51 An: Axapta-Knowledge-Village@yahoogroups.com Betreff: [Axapta-Knowledge-Village] NO stock on hand with a value hi all, I was wondering if you have ever seen this situation before, and if you would know how to fix it. Ax 3, SP3. Ave cost. A few of our items have ZERO on hand quantity but some reason have a financial cost. sometimes this is positive, sometimes this is negative. how would i fix this, how can i avoid this from happening? Regards, and thanks, Yifat Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course http://groups.yahoo.com/gads?t=msk=Business+finance+coursew1=Business +finance+coursew2=Business+to+business+financew3=Small+business+financ ew4=Business+finance+consultantw5=Business+finance+magazinew6=Busines s+finance+schoolsc=6s=185.sig=I8jDsORmsaYn0BeqghcJ2w Business to business finance http://groups.yahoo.com/gads?t=msk=Business+to+business+financew1=Bus iness+finance+coursew2=Business+to+business+financew3=Small+business+f inancew4=Business+finance+consultantw5=Business+finance+magazinew6=Bu siness+finance+schoolsc=6s=185.sig=fCzze7cxm1K7TVKkzAaOrA Small business finance http://groups.yahoo.com/gads?t=msk=Small+business+financew1=Business+ finance+coursew2=Business+to+business+financew3=Small+business+finance w4=Business+finance+consultantw5=Business+finance+magazinew6=Business +finance+schoolsc=6s=185.sig=v9sWAno7Kz4WuL8Tadcdhw Business finance consultant http://groups.yahoo.com/gads?t=msk=Business+finance+consultantw1=Busi ness+finance+coursew2=Business+to+business+financew3=Small+business+fi nancew4=Business+finance+consultantw5=Business+finance+magazinew6=Bus iness+finance+schoolsc=6s=185.sig=d1xwT3WL0E6XBf6cAV5BXA Business finance magazine http://groups.yahoo.com/gads?t=msk=Business+finance+magazinew1=Busine ss+finance+coursew2=Business+to+business+financew3=Small+business+fina ncew4=Business+finance+consultantw5=Business+finance+magazinew6=Busin ess+finance+schoolsc=6s=185.sig=qphRINaNuVm_6bwoQxgUmg Business finance schools http://groups.yahoo.com/gads?t=msk=Business+finance+schoolsw1=Busines s+finance+coursew2=Business+to+business+financew3=Small+business+finan cew4=Business+finance+consultantw5=Business+finance+magazinew6=Busine ss+finance+schoolsc=6s=185.sig=1RfnhYZpV99RKWRZzSH4gA YAHOO! GROUPS LINKS *Visit your group Axapta-Knowledge-Village http://groups.yahoo.com/group/Axapta-Knowledge-Village on the web. *To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ubscribe *Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Re: Can Axapta handle automatic Bank Reconciliation?
Bridging accounts have nothing to do with the reconciliation process; they are used in cases where for example you receive a post dated cheque from a customer. You want to record this fact in the AR sub ledger but do not want it to affect the bank GL account. If the payment method uses a bridging account then the debit will be to the bridging account. You then need to go through a process using a GL journal to reverse the bridging account entry and affecting the bank when you deposit the cheque or it clears, depending on your process. David -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Varden Morris Sent: Sunday, February 12, 2006 3:37 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Re: Can Axapta handle automatic Bank Reconciliation? I have not come across any such thing in the formal documents for Axapta but one thing I know is that you can set up Bridging Accounts in the COA and use these accounts as part of the method of payment to reduce the amount of work involve in bank reconciliation. nihar_saraiya [EMAIL PROTECTED] wrote: Hi Koh Meng Chiat If you have a solution to Automatic Bank Reconciliation, please do guide me for the same. I am also looking to import the bank statement for reconciliation for a client. I will be thankful for this. Regards Nihar --- In Axapta-Knowledge-Village@yahoogroups.com, Koh Meng Chiat [EMAIL PROTECTED] wrote: Hi all, Can Axapta handle Automatic Bank Reconciliation? I heard there is a standard template for automatic reconciliation that a bank should follow and we can actually import the template into axapta after the bank has filled in all the necessary information. Is there anyone has the template?? Thousand thanks in advance. Best Regards, Jack Koh __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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. - Varden Morris Senior Developer WellPoint Systems Inc. Microsoft Gold Certified Partner (403) 444-5848 direct (403) 444-3900 main (403) 615-1604 cell www.wellpoint.ca [EMAIL PROTECTED] - Yahoo! Mail Use Photomail to share photos without annoying attachments. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Re: Can Axapta handle automatic Bank Reconciliation?
I fully understand the process and the options that a company has when using bridging accounts. They must be included in the reconciliation process if the company's policy is to affect the bank GL account when they are on the bank statement during the reconciliation. However you can also record them when you deposit the cheque which would mean that they are not part of the reconciliation process other than to acknowledge that they have cleared. Please explain how having to create a GL journal to record the fact that the cheque has cleared makes bank reconciliation easier. David -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Varden Morris Sent: Monday, February 13, 2006 9:07 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Re: Can Axapta handle automatic Bank Reconciliation? How can you say that it has nothing to do with bank reconciliation. If you really understand the process you would see that it reduces the amount of work taken for the reconciliation process. And by the way I did not make this up, it is apart of the Financial II course for Microsoft Dynamics Ax. Bonk, David [EMAIL PROTECTED] wrote: Bridging accounts have nothing to do with the reconciliation process; they are used in cases where for example you receive a post dated cheque from a customer. You want to record this fact in the AR sub ledger but do not want it to affect the bank GL account. If the payment method uses a bridging account then the debit will be to the bridging account. You then need to go through a process using a GL journal to reverse the bridging account entry and affecting the bank when you deposit the cheque or it clears, depending on your process. David -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Varden Morris Sent: Sunday, February 12, 2006 3:37 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Re: Can Axapta handle automatic Bank Reconciliation? I have not come across any such thing in the formal documents for Axapta but one thing I know is that you can set up Bridging Accounts in the COA and use these accounts as part of the method of payment to reduce the amount of work involve in bank reconciliation. nihar_saraiya [EMAIL PROTECTED] wrote: Hi Koh Meng Chiat If you have a solution to Automatic Bank Reconciliation, please do guide me for the same. I am also looking to import the bank statement for reconciliation for a client. I will be thankful for this. Regards Nihar --- In Axapta-Knowledge-Village@yahoogroups.com, Koh Meng Chiat [EMAIL PROTECTED] wrote: Hi all, Can Axapta handle Automatic Bank Reconciliation? I heard there is a standard template for automatic reconciliation that a bank should follow and we can actually import the template into axapta after the bank has filled in all the necessary information. Is there anyone has the template?? Thousand thanks in advance. Best Regards, Jack Koh __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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. - Varden Morris Senior Developer WellPoint Systems Inc. Microsoft Gold Certified Partner (403) 444-5848 direct (403) 444-3900 main (403) 615-1604 cell www.wellpoint.ca [EMAIL PROTECTED] - Yahoo! Mail Use Photomail to share photos without annoying attachments. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village 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
RE: [Axapta-Knowledge-Village] Invoice updating of PO
Nihar; You need to do two things; the first thing is in AP parameter update tab you have to allow under delivery. The next thing, for each item in the reference tab you have to enter a percentage that you allow for over or under deliveries. That should fix your under delivery error. David From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com] On Behalf Of Nihar Saraiya Sent: Wednesday, November 30, 2005 8:16 AM To: Axapta-Knowledge-Village (E-mail) (Axapta-Knowledge-Village (E-mail)) Subject: [Axapta-Knowledge-Village] Invoice updating of PO Hi All A small scenario. I have PO with an item lineof quantity13 units. Updated the PO having entered, units 'Received' as 10. Posting Receipt List and Packing List with 10 units. Now i want to close the PO, as i will not be receiving remaining 3 units. How this has to be done? While Posting Invoice, in the Quantity field in the Parameter tab i selected 'Receive now' and at the line level, lines tab i set the checkbox for 'Close'. Iwas not able to post the invoice since the infolog gave Under Delivery error. I dont think to cancel the remaining units i need to set the 'Under-delivery'. What am i missing? Regards Nihar Saraiya, Confidentiality Notice This email is confidential and may also be privileged. If you are not the intended recipient please notify the sender immediately. You must not copy or use it for any purpose or disclose its contents to any other person. The sender accepts no responsibility for viruses received with or changes made to this email after it was sent. Any opinion expressed in this email may be personal to the sender. Sharing the knowledge on Axapta. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" 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.
RE: [Axapta-Knowledge-Village] Reconciling stock ledger to gl
Heather; When we asked MS about that report we were told that it was accurate after a close and when no other transactions were put through. I other words it does not go back into history with 100% accuracy. This is the same for the inventory report by item dimension. I therefore advise clients to run the reports after the close and to save them to a file. David -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of heatherforret Sent: Wednesday, November 23, 2005 8:28 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Reconciling stock ledger to gl Hi All I am battling to reconcile the stock ledger to gl. The values are moving independantly and the difference increasing from day to day (stock module having a larger balance than gl). I have studied one days transactions but can't seem to find the difference in movement. I am using the physical stock by item group report to try balance. The setup of axapta looks correct to me, and it is definately not due to postings directly to gl account. Am I missing something? Thanks, I really appreciate any suggestions Heather ps - using average cost and closings have been run monthly (Axapta 3.0 SP3) Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/kGEolB/TM ~- 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/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] printing invoice
You can re-print an invoice by going to the sales order - Inquiry (header) - invoice - Show- Original. That will re-print the invoice. David -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of hakan köse Sent: Wednesday, November 23, 2005 2:55 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] printing invoice Hi, I have trouble in printing Invoice. Can we send the invoice second time to the printer with any code in Axapta ? Is there any way to define that option ... __ Start your day with Yahoo! - Make it your home page! http://www.yahoo.com/r/hs Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/kGEolB/TM ~- 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/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Stock Issue on a FiFo basis
Yes and you set it by Inventory Model Group. David -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of prafful_kapoor Sent: Sunday, April 17, 2005 7:08 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Stock Issue on a FiFo basis Hi, Is there a facility to issue items from stock on a Fifo basis automatically for either a production order or a Sale invoice Thanks Prafful Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- 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/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] 3rd party tax packages
The only other US tax service is a company called Vertex (vertexinc.com). I am not sure if they have an interface to Axapta and I think that they are expensive also. Good luck. David From: John Remsberg [mailto:[EMAIL PROTECTED] Sent: Thu 18/11/2004 2:41 PM To: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] 3rd party tax packages My client is looking for a 3rd party product to load/update the Axapta tax tables on a regular basis. It would also be helpful if the product also had all of the reporting forms for the various counties across the US. Do anyone have any suggestions? Weve looked at TaxWare and it's a little too expensive. Thanks, -John R. Do you Yahoo!? The all-new My Yahoo! http://my.yahoo.com - Get yours free! Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT click here http://us.ard.yahoo.com/SIG=129ot486m/M=298184.5584357.6650215.3001176/D=groups/S=1705001380:HM/EXP=1100893281/A=2434970/R=0/SIG=11edksnhv/*http://www.netflix.com/Default?mqso=60185402 Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Groups Sponsor ~-- $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/kGEolB/TM ~- 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/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
RE: [Axapta-Knowledge-Village] Post local currency transaction not at system4s default exchange rate
I think that this is like an issue raised before. Because they also report in other currencies, the entry is going in using the Local currency but they require it to convert at a different rate than the standard exchange table. I don't think that this can be done without changing the tables, making the entry and then changing the exchange rate back. Obviously if you make it in the foreign currency you can do it but not if it is made in the local currency. David From: vaibhav pednekar [mailto:[EMAIL PROTECTED] Sent: Tue 09/11/2004 12:45 PM To: [EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] Post local currency transaction not at system4s default exchange rate hello Sorry man, but why you require the exchange rate for local currency? I dont understand this requirement, never heard any body having an exchange rate for Local currency. If my primary Currency is EURO, then my EURO exchange rate setup will be 100 EURO = 100 EURO. Please elaborate more, for me this requirement is weired, may be never faced such secanrio. thank you regards vaibhav --- VilmaQ (Axteam) [EMAIL PROTECTED] wrote: Hi Vaibhav, Thanks for the info. I tried it and it works great when the transaction I am posting is in US dollars (to convert to local currency). But when the transaction is in local currency the exchange rate shown is 100=100. I need to overide the exchange rate, for local currency transactions, used in the posting process. Any other ideas? Thanks, Vilma Quiros -Mensaje original- De: vaibhav pednekar [mailto:[EMAIL PROTECTED] Enviado el: Lunes, 08 de Noviembre de 2004 03:56 p.m. Para: [EMAIL PROTECTED] Asunto: Re: [Axapta-Knowledge-Village] Post local currency transaction not at system4s default exchange rate hi Vilmaq, For this you can do it as mentioned below When u create a General Journal, on the Journal Header under the Setup tab, check the fixed exchange rate checkbox, and enter the exchange rate. You can also enter the exchange rate for secondary currency if u want. This will override the default exchange rate specified in your exchange rate master table. This is applicable to all the journals like General Journal, Fixed Assets, Purchase, Sales, AP AR Payment journals etc with best regards Vaibhav Pednekar --- VilmaQ (Axteam) [EMAIL PROTECTED] wrote: Hi all, I need to post a transaction in local currency with a different exchange rate, for the dollar conversion, than the default given by the system (from the exchage rate table for that day). Any suggestions? Thanks, Vilma Quiros __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com Sharing the knowledge on Axapta. Yahoo! Groups Links __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT click here http://us.ard.yahoo.com/SIG=1291i5mn3/M=295196.4901138.6071305.3001176/D=groups/S=1705001380:HM/EXP=1100108814/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM ~- 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/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat
RE: [Axapta-Knowledge-Village] Exchange Rate Problem - Help please!
Is this a G/L journal? What if you did the journal in the secondary currency for the amount that you required and then in the entry (General tab) changed the default rate so that it equaled 100 of your local? An off the cuff suggestion. From: Roberto Pineda [mailto:[EMAIL PROTECTED] Sent: Tue 26/10/2004 12:26 PM To: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Exchange Rate Problem - Help please! I have this problem. I need to post a journal in local currency (exchange rate field for this journal will show 100), I need that the secondary currency posting be converted at a different exchange rate from the one I have in the exchange rate table for the day. If done manually I can go to the ExchRates table before the post and restore it after that, but this not practical, specially when other users are registering journals at the same time. Is there a solution for this problem? Thanks in advance. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT click here http://us.ard.yahoo.com/SIG=129pfhfpl/M=315388.5529720.6602079.3001176/D=groups/S=1705001380:HM/EXP=1098894387/A=2372354/R=0/SIG=12id813k2/*https://www.orchardbank.com/hcs/hcsapplication?pf=PLApplymedia=EMYHNL40F21004SS Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM ~- 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/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ winmail.dat