RE: [Axapta-Knowledge-Village] Uploading Opening Balances
Hi everyone, I had imported the openings without using any 3rd party tool. AX provides the facility to import and export excel sheet from the system. We can get the tables by right click (setup) on any form and then can import or export those tables .(Administration PeriodicData export /import Excel Spreadsheets) For GL and vendor balances use following tables: LedgerJournaltable LedgerJournalTrans For customer balances : CustinvoiceLine Custinvoicetable Regards, Faiqa From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of vivek sharma Sent: Thursday, May 24, 2007 9:39 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Uploading Opening Balances Hi Steve, It is better to talk abt Atlas why dont we do it only only in Axapta withoutAtlas can u let me know how we can do it??? I am also new pls help me out... Regards Vivek Steve Wright [EMAIL PROTECTED] mailto:steve%40globesoftware.com.au wrote: Hi Subbu Sorry to hear about your support issues. Atlas was developed for AX 2.1 and supports 2.5, 3.0 and 4.0. Next Innovation have requested support for your permission issue from us yesterday. Your import definition can have a user group or ax user id assigned to it, only users in this group (or specific userid) can then use the import. Security needs to be placed in AX at a table level and not a menu level. The thing to remember about Atlas and AX security...all access to AX is controlled by AX security keys, the product itself does no database access itself. If your ax permissions do not allow it (updating, reading) then you will see the normal insufficient access rights error. I will correspond with Next Innovation more on this. Re:loading external item descriptions getting confused about zip codes...forward screen pictures to Next Innovation or our support desk [EMAIL PROTECTED] mailto:support%40atlasxl.com.au Regards Steve. 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 Subrahmanyam,Mamidi Sent: Thursday, 24 May 2007 11:59 AM To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Uploading Opening Balances Hi Steve, AtlasXl is really a pain as I have been having. FIrst one is, no good support from next innovation. Second thing is: it does not work properly with Ax4.0. I tried to load Item external description, it just looks/points to zipcode. One and foremost thing is, it does not use Axapta security groups and permissions. For example, I have given limited permission to a user. The user is still able to insert/update all the listed main tables via atlas xl Login This disappointed me a lot.. Or just data export wise, yes its good..but for just data import , if the std import does not support my requirements, I rather prefer to write scripts using X++... All I wanted to say is VERY BAD support... I thought of sharing my exp...for atlasxl with Ax4.0. I hope my comments can be taken in a friendly manner! thanks, subbu Steve Wright [EMAIL PROTECTED] mailto:steve%40globesoftware.com.au mailto:steve%40globesoftware.com.au wrote: Use General Ledger general journal or all opening balances. Step 1. For GL, bring in balances per period per account (so you can use AX for prior period comparisions). Step 2. For customers, one line in the journal per open invoice (the offset account is your customer control account in the GL). The control account is used as the offset so the net effect on it (the control account) is zero. It needs to be zero as step one (above) has the correct balance in it already. Step 3. For vendors, one line in the journal per open invoice, the offset account is your vendor control account) Try using www.atlasxl.com.au It allows you to import AX journals from Excel. Get your data from the old system into Excel and then use Atlas xl to create and import the AX journals. Atlas xl handles number sequences and validation for you. Regards Steve From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of Hardees Buff Sent: Wednesday, 23 May 2007 8:16 PM To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Uploading Opening Balances Hi, I am into my first implementation of AX. I need to upload GL opening balances, Customer Balances and Vendor Balances to be transfered into the system for the first time. Can anyone help me on how to do
[Axapta-Knowledge-Village] Capacity Planning per Quota
Dear all, I want to know whether Master Planning can provide planned production order based on quota in some workcenter. My client has a request that planned production order can be created based on quota on workcenter because some of their workcenter can only be used if the quantity of production fulfilled. Example he has a boiler that can be run if the quantity is 40. The workcenter can not be run if the quantity under 40 can anyone help me. thank in advance Lukas nugroho Shape Yahoo! in your own image. Join our Network Research Panel today!http://us.rd.yahoo.com/evt=48517/*http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7 hot CTA = Join our Network Research Panel [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Autoreport - formdatasorce
Hi, I created an additional form for ProdTable and we decided to use both the standard one and new one. But in my form autoreport doesn't work. Is there any way to have double FormRef for a table ? Thanks, Syner Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us. http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7 [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: problem on picking items !
Hi, maybe the Alternative Itemnumber and the Use-Flag is setup on the item? Regards Markus --- In Axapta-Knowledge-Village@yahoogroups.com, ranganath_mbs [EMAIL PROTECTED] wrote: Hi all I am having problem on picking items and moreover let me explain scenario (when I change the production order status to start the warning message says the items was not picked with specific item no ) How do I solve this problem can any one help or suggest regarding this scenario Regards ranganath
Re: [Axapta-Knowledge-Village] Uploading Opening Balances
Hi Vivek, We can use AX 100% for the opening balance upload. GL: via General Journal (ledger account type) AR: via General Journal (customer account type) AP: via General Journal (vendor account type) Inventory: via PL Journal. Hope this help. Khue - Original Message From: vivek sharma [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, May 24, 2007 11:39:19 PM Subject: RE: [Axapta-Knowledge-Village] Uploading Opening Balances Hi Steve, It is better to talk abt Atlas why dont we do it only only in Axapta withoutAtlas can u let me know how we can do it??? I am also new pls help me out... Regards Vivek Steve Wright [EMAIL PROTECTED] .com.au wrote: Hi Subbu Sorry to hear about your support issues. Atlas was developed for AX 2.1 and supports 2.5, 3.0 and 4.0. Next Innovation have requested support for your permission issue from us yesterday. Your import definition can have a user group or ax user id assigned to it, only users in this group (or specific userid) can then use the import. Security needs to be placed in AX at a table level and not a menu level. The thing to remember about Atlas and AX security...all access to AX is controlled by AX security keys, the product itself does no database access itself. If your ax permissions do not allow it (updating, reading) then you will see the normal insufficient access rights error. I will correspond with Next Innovation more on this. Re:loading external item descriptions getting confused about zip codes...forward screen pictures to Next Innovation or our support desk [EMAIL PROTECTED] com.au Regards Steve. Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Subrahmanyam, Mamidi Sent: Thursday, 24 May 2007 11:59 AM To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Subject: RE: [Axapta-Knowledge- Village] Uploading Opening Balances Hi Steve, AtlasXl is really a pain as I have been having. FIrst one is, no good support from next innovation. Second thing is: it does not work properly with Ax4.0. I tried to load Item external description, it just looks/points to zipcode. One and foremost thing is, it does not use Axapta security groups and permissions. For example, I have given limited permission to a user. The user is still able to insert/update all the listed main tables via atlas xl Login This disappointed me a lot.. Or just data export wise, yes its good..but for just data import , if the std import does not support my requirements, I rather prefer to write scripts using X++... All I wanted to say is VERY BAD support... I thought of sharing my exp...for atlasxl with Ax4.0. I hope my comments can be taken in a friendly manner! thanks, subbu Steve Wright [EMAIL PROTECTED] .com.au mailto:steve% 40globesoftware. com.au wrote: Use General Ledger general journal or all opening balances. Step 1. For GL, bring in balances per period per account (so you can use AX for prior period comparisions) . Step 2. For customers, one line in the journal per open invoice (the offset account is your customer control account in the GL). The control account is used as the offset so the net effect on it (the control account) is zero. It needs to be zero as step one (above) has the correct balance in it already. Step 3. For vendors, one line in the journal per open invoice, the offset account is your vendor control account) Try using www.atlasxl. com.au It allows you to import AX journals from Excel. Get your data from the old system into Excel and then use Atlas xl to create and import the AX journals. Atlas xl handles number sequences and validation for you. Regards Steve From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com mailto:Axapta- Knowledge- Village%40yahoog roups.com [mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com mailto:Axapta- Knowledge- Village%40yahoog roups.com ] On Behalf Of Hardees Buff Sent: Wednesday, 23 May 2007 8:16 PM To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com mailto:Axapta- Knowledge- Village%40yahoog roups.com Subject: [Axapta-Knowledge- Village] Uploading Opening Balances Hi, I am into my first implementation of AX. I need to upload GL opening balances, Customer Balances and Vendor Balances to be transfered into the system for the first time. Can anyone help me on how to do it? I searched previous posts but could not get anything solid. Thanks, - - --- Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] - - --- Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] - - --- Luggage? GPS? Comic books? Check out fitting gifts for
RE: [Axapta-Knowledge-Village] Capacity Planning per Quota
Hi, One way one of doing this would be to set a minimum order quantity of 40 (Inventory fieldgroup on Quantity tab in the Item form) and then set the Item coverage type to Period. Whenever you create orders of less than 40 they will be grouped within the specified period (eg. 10 days) and a production order of minimum 40 pcs will be planned. Regards, Anders Sorensen This posting is provided AS IS with no warranties, and confers no rights. -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Lukas Nugroho Putro Sent: 25. maj 2007 09:13 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Capacity Planning per Quota Dear all, I want to know whether Master Planning can provide planned production order based on quota in some workcenter. My client has a request that planned production order can be created based on quota on workcenter because some of their workcenter can only be used if the quantity of production fulfilled. Example he has a boiler that can be run if the quantity is 40. The workcenter can not be run if the quantity under 40 can anyone help me. thank in advance Lukas nugroho Shape Yahoo! in your own image. Join our Network Research Panel today!http://us.rd.yahoo.com/evt=48517/*http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7 hot CTA = Join our Network Research Panel [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledge-village.tk Yahoo! Groups Links
Re: [Axapta-Knowledge-Village] Sorting
Hi there You can use a view; simply drag the tables that are required for the report to the datasouce of the view; and under the node fields create the fields that you require. Once that is done you can drag the view to the datasource of the report and from there create your report and sorting, ranges etc... On 5/23/07, V G [EMAIL PROTECTED] wrote: Hi I have a requirement where in I have to sort the report by the customer name. The table that is used in the query have customer No but not customer name. I am fetching the customer name from the custTable based on custAccount. I can create a temp table and insert the record with the customer name and than fetch it sort by customer name Is there a easier way or any other way to do this. Thanks Vishal [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Configuration Key: Sweden Dynamics Ax 40
--- In Axapta-Knowledge-Village@yahoogroups.com, Dishant Singhal [EMAIL PROTECTED] wrote: Hi All When we switch on the country specific feature for Sweden, then under the AR parameters -- Updates tab -- General field group, another field for Order entry statistics gets enabled. Does anyone have an idea of what it is meant for? Are there any more related functionalities, reports and inquiries with it? Regards, Dishant _ ___Pinpoint customers who are looking for what you sell. http://searchmarketing.yahoo.com/
Re: [Axapta-Knowledge-Village] Sorting
Hi Vishal , Include your table and custtable in the datasource of the report one under the other and make a relation w.r.t accountnum. In custtable datasource sortorder select custtable.name and ur problem will be solved. Regards , Santosh Kumar Sharma [EMAIL PROTECTED] V G [EMAIL PROTECTED] wrote: Hi I have a requirement where in I have to sort the report by the customer name. The table that is used in the query have customer No but not customer name. I am fetching the customer name from the custTable based on custAccount. I can create a temp table and insert the record with the customer name and than fetch it sort by customer name Is there a easier way or any other way to do this. Thanks Vishal [Non-text portions of this message have been removed] - Did you know? You can CHAT without downloading messenger. Know how! [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: hi
--- In Axapta-Knowledge-Village@yahoogroups.com, Orcan Barnig [EMAIL PROTECTED] wrote: - Do you Yahoo!? Express yourself with Y! Messenger! Free. Download now.
[Axapta-Knowledge-Village] Advanced Systems Integration Releases Next TREND in Apparel Software Utilizing Microsoft Dynamics AX Enterprise Software Platform
Advanced Systems Integration Releases Next TREND in Apparel Software Utilizing the Microsoft Dynamics AX (Axapta) Enterprise Software Platform LAKE FOREST, CA - May 23, 2007 - Advanced Systems Integration, Inc. (ASI) a Microsoft Dynamics-AX Gold Certified Manufacturing Solutions Training Partner is pleased to announce the release of Apparel Footwear Solution version 2.5 for Microsoft Dynamics AX. Microsoft Dynamics AX is a highly customizable, enterprise-wide, business management system. An increasing number of apparel and footwear manufacturers recognize when selecting a Microsoft-based platform the immediate benefits of a People-Ready solution. Microsoft Dynamics AX provides a more affordable, easier to use, and less complex answer than SAP or Oracle for apparel and footwear manufacturers. ASI's tailor-made, Apparel Footwear Solution, is built on and fully integrated with the Microsoft Dynamics AX platform. David Payne, President of ASI, started the company some 16 years ago and took on the Microsoft Dynamics-AX (formerly Damgaard) application because of its unsurpassed flexibility, adaptability and scalability. David charged his team to create a solution that would fulfill the specific needs of the apparel and footwear industry after working over 10 years with such manufacturers. Mr. Payne notes, Apparel companies, whether vertically integrated or those that contract manufactures overseas will benefit from ASI's updated Apparel Footwear Solution integrated with the Microsoft Dynamics AX platform. Mr. Payne goes on to explain, Companies requiring an enterprise solution for their growing and complex business processes are ideal candidates for ASI's apparel solution. Our solution offers the ability to see real-time information, better controls and visibility of supply chains, product life-cycles, inventory, and warehouse management, all built in a Microsoft-familiar environment. ABOUT ASI: Advanced Systems Integration, Inc. is a Microsoft Gold Certified Dynamics(tm) AX Manufacturing Solutions Training Partner that delivers comprehensive enterprise class applications that improve customer relations, enhance partner collaboration and create efficiencies across supply chains and business operations. ASI also offers industry specific extensions integrated with Microsoft Dynamics AX platform. ASI uses its industry focus, enterprise software domain expertise and transparent agile implementation methodology to provide its clients an enterprise class solution that is implemented properly the first time. ASI is based in Lake Forest, Calif and has sales offices in strategic locations throughout the United States. Please visit the company's web site at http://www.advancedsystemsintegration.com/ For more information on this release, please contact: Lisa Aschenbrenner Marketing Manager Advanced Systems Integration, Inc. (949) 597-2170 [EMAIL PROTECTED] This e-mail (which includes any attachments) is confidential and is intended for the exclusive use of the intended recipient (or a person authorized to receive information for the recipient). If this e-mail has been sent to you by mistake, please inform us by replying to this e-mail. Then delete the e-mail, destroy any printed copies and do not disclose or use the information in it. Please check for any defects or viruses before opening or using any attachments. There is no warranty that this e-mail is virus free or without error. Advanced Systems Integration is not liable if an attachment is altered without its written consent. If this is a private communication it does not represent the views of Advanced Systems Integration.
[Axapta-Knowledge-Village] Re: Problem in scheduling the projects.
--- In Axapta-Knowledge-Village@yahoogroups.com, Richa Agarwal [EMAIL PROTECTED] wrote: Hi All, I am facing a problem in scheduling the projects in Dynamics AX 4.0. I have forecasted the number of hours required for the activities in a project but when i am scheduling it, I am getting an error which says that The working time has not been defined for the date. I have defined the working time for the calender, which is being used for the employees, tagged to the activities of the project, i am trying to schedule. Still the error persists. Is their any other setup which needs to be done somewhere to schedule the projects? Regards, Richa [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Failed loading assembly
Hi, This message normally comes when the system is not able to find any dll that is present in the References node of AOT. Here i feel that the system is not able to find Microsoft.Dynamics.EP.Deployment.dll file. you can see that this dll has been added in the References node of AOT. Please check whether this dll is present in your client/bin folder or not. Regards, Sumit On 5/23/07, Agus Riyadi [EMAIL PROTECTED] wrote: Hi All, Has any of you experienced this error message : Error Message (14:12:55) Failed loading assembly Microsoft.Dynamics.EP.Deployment, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL Error Message (14:12:55) Failed loading assembly Microsoft.Dynamics.RfidProxy, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 It occurs intermittently while working with the editor. Please help if you know how to rectify it. Ax 4.0 SP1 Regards, Agus [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Change on SQL Server 2005
Could I make a Change on a table on AXDB directly on SQL Server and (running the sincronize tables job) see the changes on AX? for example.. Add a field on a table Tnks
Re: [Axapta-Knowledge-Village] Problem in scheduling the projects.
Hi Richa, Hope you have done the settings for validation Project/ Category, Project/Employee and Category/Employee for the projects / subprojects you are trying to schedule. Check that once. With regards, Vivek Sinha --- Richa Agarwal [EMAIL PROTECTED] wrote: Hi All, I am facing a problem in scheduling the projects in Dynamics AX 4.0. I have forecasted the number of hours required for the activities in a project but when i am scheduling it, I am getting an error which says that The working time has not been defined for the date. I have defined the working time for the calender, which is being used for the employees, tagged to the activities of the project, i am trying to schedule. Still the error persists. Is their any other setup which needs to be done somewhere to schedule the projects? Regards, Richa [Non-text portions of this message have been removed] Choose the right car based on your needs. Check out Yahoo! Autos new Car Finder tool. http://autos.yahoo.com/carfinder/
[Axapta-Knowledge-Village] Re: Change on SQL Server 2005
Unless there was a big change in AX40 that i'm not aware, sychronization in only done one way which is : Axapta push table structure to SQL Server and not the other way around. So no, you wouldn't be able to do what you're explaining. Why not adding the field in Axapta? Steeve... --- In Axapta-Knowledge-Village@yahoogroups.com, pabundes [EMAIL PROTECTED] wrote: Could I make a Change on a table on AXDB directly on SQL Server and (running the sincronize tables job) see the changes on AX? for example.. Add a field on a table Tnks