[Axapta-Knowledge-Village] User Status - Ending-Blocked
Hello, We have a setup of AX2009 in 63 locations. These locations are accessing the application using CITRIX connectivity. Most of the times the Sales related users get their status as Ending-Blocked this was not happening earlier but suddenly this started happening and sesion gets hang in user machine. Can anyone tell the reason why this status comes frequently?? I have tried searching for the status which says - The administrator has clicked End sessions to end the session and the AOS has processed the request, but there is a problem disconnecting the session. but this did not solve my issue! -Tushar The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
[Axapta-Knowledge-Village] Error while updating item dimension combinations through a job
Hi, I have around 2500 numbers of configurations(inventory dimension) for the BOM item. And there are 1600 such BOM items i want to create a SIZE (inv dimension) for each of the item. The Item master setup has Auto create combinations option marked. So when i try to create a Size manually through Item details setup button Size option then it takes around 50 mins for the record to be updated.(This is regarding the performance of AX2009 as 2500 recorss in Configtable shudnt be a problem for AX? To avoid this time we tried running a job which validates whether the same size id exists for the item or not and then creates a record in Size. Still when i try to compare the time it took same i.e. 50 mins, also some time when the job is getting executed i got following error in between when the job is about to complete Can not create a record in NumberSequenceTracking (Number Sequence Tracking) the SQL database has issued an error(). Unable to establish the connection with the database. Can anyone help in this reagrd? -Tushar The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
Re: [Axapta-Knowledge-Village] Report as Finished for more quantity
I meant by following scenario in Purchase order, If i create a PO for 100 and allow the overdelivery of 10% the i can receive 110 while doing packing slip, similarly can we start production for 100 and Report As Fisnish 110?? I know the on order quantity is 100 in this case but there is method in ProdTable for Overdelivery which i think should allow more quantity while Report As Finish. Please let me konw any setup is missing in inventory parameters -Tushar --- On Sat, 23/1/10, rayd shil@gmail.com wrote: From: rayd shil@gmail.com Subject: Re: [Axapta-Knowledge-Village] Report as Finished for more quantity To: Axapta-Knowledge-Village@yahoogroups.com Date: Saturday, 23 January, 2010, 10:43 PM this is an standard error which comes when try to post something for which an order never existed, for example - there is no purchase order but u are trying to receive, or for that matter, there is no sales order but u are trying to ship :) i guess it is more of an investigation of the problem rather than customization, because there is something missing in the transaction. I may help you with this if you could attach screen shots of steps u are performing capturing the on-hand and transaction screens in it. regards -D On Sat, Jan 23, 2010 at 8:13 PM, Tushar Joshi tushar_s_joshi@ yahoo.co. in wrote: I have tried with Accept error option but still not accepting more quantity. Can we customize this acceptance of more qty by using the overdelivery concept of purchase orders? -Tushar --- On Mon, 18/1/10, rayd shil@gmail. com wrote: From: rayd shil@gmail. com Subject: Re: [Axapta-Knowledge- Village] Report as Finished for more quantity To: Axapta-Knowledge- vill...@yahoogro ups.com Date: Monday, 18 January, 2010, 11:20 PM Hi Tushar have u tried using 'accept error' check box, because originally ur production order started with 100, so ur ordered status was 100 initially but since u are attempting to post production for 102, system is not considering order status as 'ordered' for '2' quantity (which was originally not ordered). Accept error check box is given for tackling reporting as finished in such situations. rgds -D On Mon, Jan 18, 2010 at 7:59 PM, Tushar Joshi tushar_s_joshi@ yahoo.co. in wrote: Dear All, I have a following scenario in a process industry Item A has production order for 100 Qty Production order started for 100 Picking list posted for 100 Route card posted for 100 But while doing Report as finished I actually observed that I have produced 102 qty, and want to update the stock for the same quantity While doing so when i update the Report as finish journal for 102 quantity AX gives error as Cannot receive quantity 102 because inventory transactions with status Ordered, Arrived or Registered are insufficient. Can anyone suggest how to handle such scenario? -Tushar The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
Re: [Axapta-Knowledge-Village] Report as Finished for more quantity
I have tried with Accept error option but still not accepting more quantity. Can we customize this acceptance of more qty by using the overdelivery concept of purchase orders? -Tushar --- On Mon, 18/1/10, rayd shil@gmail.com wrote: From: rayd shil@gmail.com Subject: Re: [Axapta-Knowledge-Village] Report as Finished for more quantity To: Axapta-Knowledge-Village@yahoogroups.com Date: Monday, 18 January, 2010, 11:20 PM Hi Tushar have u tried using 'accept error' check box, because originally ur production order started with 100, so ur ordered status was 100 initially but since u are attempting to post production for 102, system is not considering order status as 'ordered' for '2' quantity (which was originally not ordered). Accept error check box is given for tackling reporting as finished in such situations. rgds -D On Mon, Jan 18, 2010 at 7:59 PM, Tushar Joshi tushar_s_joshi@ yahoo.co. in wrote: Dear All, I have a following scenario in a process industry Item A has production order for 100 Qty Production order started for 100 Picking list posted for 100 Route card posted for 100 But while doing Report as finished I actually observed that I have produced 102 qty, and want to update the stock for the same quantity While doing so when i update the Report as finish journal for 102 quantity AX gives error as Cannot receive quantity 102 because inventory transactions with status Ordered, Arrived or Registered are insufficient. Can anyone suggest how to handle such scenario? -Tushar The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
[Axapta-Knowledge-Village] Item dimension wise cost in movement journals
Hello friends, We are using the configuration and size dimensios for BOM type of items. The inventory model group selected has setup of weighted average cost for all BOM type of items. When trying to post a movement journal of any BOM type of item with specific configuration and size the cost of the item (weighted average) is not shown in cost column of the journal. The item has the setup in its master as use combination cost price but still the dimension combination cost price is not shown in inventory journals. Any setup missing for this? pls suggest -Tushar The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
[Axapta-Knowledge-Village] Report as Finished for more quantity
Dear All, I have a following scenario in a process industry Item A has production order for 100 Qty Production order started for 100 Picking list posted for 100 Route card posted for 100 But while doing Report as finished I actually observed that I have produced 102 qty, and want to update the stock for the same quantity While doing so when i update the Report as finish journal for 102 quantity AX gives error as Cannot receive quantity 102 because inventory transactions with status Ordered, Arrived or Registered are insufficient. Can anyone suggest how to handle such scenario? -Tushar The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
[Axapta-Knowledge-Village] Re: [development-axapta] Track by Serial Number.
Khalil, U can use the serial number dimension of the item for this requirement. Servicing of valve is similar to the scenario of material coming IN to your inventory so treat theat as purchase orders as and when you receive the item for servicing and after doing the observations you can send it to the person from whom u received it. At the time of purchase transaction you can generate the serial number for the item by doing setups of serial number groups and then sending the item back to the person can be done as a sale transaction by which you can keep a trace of the items through serial numbers also the sale transaction will help u in billing the servicing charges to ur customers. Hope this helps! -Tushar --- On Wed, 2/12/09, Khalil Rehman khalilrehm...@hotmail.com wrote: From: Khalil Rehman khalilrehm...@hotmail.com Subject: [development-axapta] Track by Serial Number. To: Knowlege Village axapta-knowledge-village@yahoogroups.com, AX Consultant Group axapta-consult...@yahoogroups.com, Development Axapta development-axa...@yahoogroups.com Date: Wednesday, 2 December, 2009, 6:06 PM Dear All, i have requirements in Servicing Enviroment as follows: Example 1: we receive one Valve for repairing Servicing. now first of all we inspect the valve and make observation list. after that we want to have tracking from material consumed upto invoicing. also we want to keep history of this valves by Serial Number which we need to review time to time. best regards. KHALIL UR REHMAN _ Windows Live: Make it easier for your friends to see what you’re up to on Facebook. http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_2:092009 [Non-text portions of this message have been removed] Yahoo! Groups Links The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
[Axapta-Knowledge-Village] SySDatabaseTransDelete
All, I am trying to delete the transactions from the AX server(using AX 2009 Sp1) and for that i used the SysDatabaseTransDelete class, surprisingly this class is running since last 5 days! System still shows me Deleting Transactions... Can anyone tell me what could be the reason for this delay?? -Tushar Try the new Yahoo! India Homepage. Click here. http://in.yahoo.com/trynew
[Axapta-Knowledge-Village] Record Level securities
Hi All, We have AX implemented at a FACTORY and the connectivity from the server is to 60+ SHOWROOMS through citrix server. The showrooms are treated as Warehouses in AX and for each warehouse there is record level securoty set so that users in showrooms will have limited access to specific customers, number sequences to generate Sales orders, specific items etc a ll 60 users are having restricted access through Record level securities. Can setting up the record level securities in large number affects the system performance?? assuming that the current record count of Data is 5 million?? If yes can anyone suggest how the users in different locations can be handled to have limited or restricted access?? -Tushar Connect more, do more and share more with Yahoo! India Mail. Learn more. http://in.overview.mail.yahoo.com/
[Axapta-Knowledge-Village] Coverage plan by Dimesnion - query
All, When Item dimensions are set Active, the by default the system sets them active for Primary stocking, Mandatory, physical inventory, financial inventory, and coverage plan by dimension criterias. I have Sales orders eneterd for an item with Configuration and Size dimensions active. when Master scheduling is run then items with same configuration and size are grouped and system generates the planned order for the grouped quantity. I want to group the requirements at the time of master planning which will consider only Item code and Configuration and NO SIZE... if I remove the coverage plan by dimension for SIZE dimension then system will group the item requirements only based on the item code and configuration but will it affect the sales or production or purchase transactions of the Item??? -Tushar From cricket scores to your friends. Try the Yahoo! India Homepage! http://in.yahoo.com/trynew
[Axapta-Knowledge-Village] Multiple work centers for 1 Route
Hi All, Item of type BOM has a ROUTE defined for it which sets the sequence of the tasks to be performed to manufacture a finished product. In every route a work center group or a work center can be attached for one operation. But Is it possible to create a route where one operation will have more than one work centers assigned to it?? Also is it possible to define a priority of utilization of the work center? Example - Item BOM has a route R1 defined for it. In Operations the Op1 is performed on M/c 1 but at the same time it can also be done on M/c 2 and M/c 3 so I want tos et these 3 machines for one operation and also want to define the priority that which work center should be used first (during production scheduling or work center capacity reservations) if all 3 are available. I am aware that in Std AX 2009 we can not assign more than 1 work centers for an operation, but is it possible to customize it? will it affect the core functionality of AX? Your suggestions will be of gr8 help! -Tushar Now, send attachments up to 25MB with Yahoo! India Mail. Learn how. http://in.overview.mail.yahoo.com/photos
Re: [Axapta-Knowledge-Village] Importing Exporting BOM [1 Attachment]
Hello, If u want to export the BOM data in Excel then u will have to follow following steps (this is one of the available options though) Administration Periodic Data export/import Excel spreadsheet Template wizard Then specify a file name in which u want to export the data. Select the Tables BOM, BOMTable, and BOMVersion from the list. proceed till export data option. Click Ëxport data option and it will export the data to ur workbook. Similarly If u want to import excel BOM data to AX then go to Administration Periodic Data export/import Excel spreadsheet Microsoft office excel import Select the definition group if u have selected while exporting the data to templates or u can leave it blank if not created the definition group while exporting. Select the file name in which u have entered the BOM and its related components and click OK the data will be imported in AX. Hope this will help u. A sample Template is attached. -Tushar --- On Mon, 5/10/09, Belal Marzouk belal_marz...@yahoo.com wrote: From: Belal Marzouk belal_marz...@yahoo.com Subject: [Axapta-Knowledge-Village] Importing Exporting BOM To: Axapta-Knowledge-Village@yahoogroups.com Date: Monday, 5 October, 2009, 10:37 PM Hello, How can I export and import BOM including its components? How can I import them too? Regards, Belal Now, send attachments up to 25MB with Yahoo! India Mail. Learn how. http://in.overview.mail.yahoo.com/photos
Re: [Axapta-Knowledge-Village] Reg attaching ten documents in a new tab
Hello, Instead of attaching the documents in a new tab (for which you will have to do some customization) you can use document handling feature of AX and in that you can attach as many documents as you want for a single Item in your purchase order. You can view them at any point of time by selecting the proper item in purchase line and click the Document Handling button on toolbar. Hope this will address your purpose of maintaining documents for a single record. -Tushar --- On Fri, 25/9/09, trinadh sura trinadh_s...@iicindia.com wrote: From: trinadh sura trinadh_s...@iicindia.com Subject: [Axapta-Knowledge-Village] Reg attaching ten documents in a new tab To: Axapta-Knowledge-Village@yahoogroups.com, development-axa...@yahoogroups.com Date: Friday, 25 September, 2009, 6:34 PM Hi all, In a purchase order for single record I want to attach ten documents in a new tab. Please can any explain or else send if any suggestions. Best Regards, Trinadh sura Technical Consultant 9246198102. From cricket scores to your friends. Try the Yahoo! India Homepage! http://in.yahoo.com/trynew
Re: [Axapta-Knowledge-Village] Import purchase invoice create credit note
Standard Ax 4.0SP2 does not allow to create credit note for import order. While creating a line it checks(PurchLine table - CreateLine method) that if the PO type is of Import and it has Bill of entry transaction against it then does not allow to create credit note line. If you want to create it then you can create a NEW purchase order of type IMPORT against the same vendor and same item with -ve quantity. Process the purchase order and at the time of posting invoice it prints the Credit note report. Hope it solves your purpose. -Tushar --- On Wed, 5/8/09, NITIN DESALE nitindes...@yahoo.co.in wrote: From: NITIN DESALE nitindes...@yahoo.co.in Subject: Re: [Axapta-Knowledge-Village] Import purchase invoice create credit note To: Axapta-Knowledge-Village@yahoogroups.com Date: Wednesday, 5 August, 2009, 8:32 AM Dear all, is it possible or not,any idea ? purchase order create credit note not allowed for import only. --- On Sat, 1/8/09, NITIN DESALE nitindesale@ yahoo.co. in wrote: From: NITIN DESALE nitindesale@ yahoo.co. in Subject: [Axapta-Knowledge- Village] Import purchase invoice create credit note To: Axapta Knowledge Axapta-Knowledge- vill...@yahoogro ups..com Date: Saturday, 1 August, 2009, 12:04 PM Hi all, i'm facing problem at the time of create credit note for import purchase order in Ax 4.0, for domestic purchase invoice system allowed to carete credit note but not for Import invoice. it throwing an error. Message (11:31:08) Purchase order is updated in invoice registration, changes cannot be made. Illegal inventory transaction if anyone have solution pls let me know the same. Thanks Nitin Yahoo! recommends that you upgrade to the new and safer Internet Explorer 8. Looking for local information? Find it on Yahoo! Local Looking for local information? Find it on Yahoo! Local http://in.local.yahoo.com/
Re: [Axapta-Knowledge-Village] ERROR at the time of Credit note
Nitin, We(partner) had explained the cause of this error and simulated the scenario. You(client) should follow the best industry practices while doing transactions and using a global business solution package. Please make sure you follow it in future. -Tushar --- On Sat, 1/8/09, NITIN DESALE nitindes...@yahoo.co.in wrote: From: NITIN DESALE nitindes...@yahoo.co.in Subject: [Axapta-Knowledge-Village] ERROR at the time of Credit note To: Axapta Knowledge Axapta-Knowledge-Village@yahoogroups.com Date: Saturday, 1 August, 2009, 8:57 AM Hi, For some purchase order we are facing problem at the time of creditnote creation AP--Function --Create Credit Note--select the particulal invoice number. its throwing an error Item has automatic serial number alocation. we(client) and our implementaion partner are facing to this error from last one and half month , if anybody has solution pls let me know the same. Thanks Nitin Desle (Pune,MH) Nitin Desle See the Web's breaking stories, chosen by people like you. Check out Yahoo! Buzz. Love Cricket? Check out live scores, photos, video highlights and more. Click here http://cricket.yahoo.com
[Axapta-Knowledge-Village] Updating Serial numbers for On-Hand inventory
Hi All, We have implemented Ax 4.0 SP2 IND_LOC in a manufacturing industry. The inventory was getting updated with only WAREHOUSE dimension. But now the requirement is to update the inventory with serial numbers dimension so that Store person can maintain the FIFO. For items having no transaction, the inventory dimension group got changed and it creates serial numbers perfectly but for the items having ON-HAND stock its difficult to assign the serial number. For Example Item A on hand stock 100, Ordered 200, these records were not updated with serial number dimension, but now i want to update on hand 100 qty with serial number say S1 and whenever i will receive a material through purchase packing slip it shoud take the next serial number as S2. Is it possible to acieve this? Can anyone provide a script job? Yahoo! recommends that you upgrade to the new and safer Internet Explorer 8. http://downloads.yahoo.com/in/internetexplorer/
Re: [Axapta-Knowledge-Village] Alternative workcenter with different process time
Hi, U can create 3 diferent route versions for the same item and then while running the master planning u can select the option of route versions or while updating the status of production order u can select the appropriate route out of the 3 versions and can see the different process times as per the route selected in capacity reservations. Hope this will help. -Tushar --- On Wed, 3/6/09, cüneyt köker c_ko...@yahoo.com wrote: From: cüneyt köker c_ko...@yahoo.com Subject: [Axapta-Knowledge-Village] Alternative workcenter with different process time To: Axapta-Knowledge-Village@yahoogroups.com Date: Wednesday, 3 June, 2009, 1:03 PM Hi All, Is there any way to set up the following case in AX? A specific product can be produced on Machine1 (10 min/pcs), Machine2 (15 min/pcs) and Machine3 (8 min/pcs) with different process times. Machine1 is selected as work center on the route operation. I want to make AX consider other two machines too if they are available when scheduling. And when doing this, it must consider their different process times and schedule them that way. I know that task groups are used for similar purpose but it is not possible to define different times by machine there. Thank you in advance, Cuneyt Bring your gang together. Do your thing. Find your favourite Yahoo! group at http://in.promos.yahoo.com/groups/
[Axapta-Knowledge-Village] Partial star for Production order doesn't work!
Hi All, One of our prospect is into batch production processes. For Example they crate a Production order for 1000 qty but they start the production in batches like 250 in 1st week 500 in 2nd week, etc... depending on their work center's availability and customer's requirement. In Ax when we create a production order for 1000 qty and try to start it partially say for 200 qty then intitially it will work fine till Report as Finish but when second time we start it for say 500qty then picking list journal doesn't get updated for it (not in terms of proposal qty but for started qty) also while doing the Report as Finish for the second time started qty it throws an error as Report as finish qty exceeds the started qty. Require some assistance in addressing this issue! Bring your gang together. Do your thing. Find your favourite Yahoo! group at http://in.promos.yahoo.com/groups/
[Axapta-Knowledge-Village] Barcode Scanning FIFO
Hello All, We want to introduce the Barcode scanning functionality to our client. I want to use SERIAL NUMBER or BATCH NUMBER dimension to scan the Barcode and maintain the FIFO in my inventory. Can anyone suggest how both of these or any one of these dimensions can be used for Barcode scanning and maintaining FIFO? Does anyone have a doc or spec prepared for the same from their respective prior experiences? it will be of gr8 help! Thanks in advance -Tushar Cricket on your mind? Visit the ultimate cricket website. Enter http://beta.cricket.yahoo.com
Re: [Axapta-Knowledge-Village] Material Issuance Consumption
Material is issued against a production order. While updating the status of production order to started you have an option to create and post PICKING LIST. its nothing but the material issue against the production. the stock gets reduced from inventory warehouse when the picking list is posted. It has two columns as proposal and consumption which records the consumption of the picked material. after picking the material from inventory againsta production order you need to post the Route card which also gets generated automatically if the end mark route option is checked while starting the production order (on general tab). Report as finished Journal will update the stock of the finshed goods in warehouse. --- On Mon, 9/3/09, Axapta Consultant consultant.axa...@yahoo.com wrote: From: Axapta Consultant consultant.axa...@yahoo.com Subject: [Axapta-Knowledge-Village] Material Issuance Consumption To: Axapta Knowledge Village axapta-knowledge-village@yahoogroups.com Date: Monday, 9 March, 2009, 2:41 PM How the material is issued against Production Order,how its consumption is recorded in AX and how the finished goods are recived in the warehouse. Unlimited freedom, unlimited storage. Get it now, on http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/
[Axapta-Knowledge-Village] Document Handling!
Hello All, I am facing a problem in accessing the files which are attached to the Item. for example - In Item master form I selected an Item A and have attached an image of its drawings of type file to it. The Document management setups in Basic module are as follows: Document type File is created in the list. Setup in General tab has file location as Archive directory and File location is \\server\folder1 (which is a network shared folder). In Parameters also the same path is mentioned for the Archive directory. Even after all these setups I am not able see the attached image file for the item from other machine. The other machine from which i try to access this file throws an error that c:\Temp\file1.jpg does not exists. I have changed the archive directory path on that machine also and kept it as \\server\folder1 which is same as that of the former machine from which i had attached the file still the problem persists Can anyone suggest how can we achieve this? Do we need to change some setups? -Tushar Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/
[Axapta-Knowledge-Village] Security Rights Problem
All, I am trying to set access rights for a user group. while setting up the permissions for viewing Security of Inventory management module, I want to assign View option to Tables section. It worked fine for me. I can only view the records in Inventory module on Item master form. But If i try to click on Sales Order menu on navigation pane then it throws an error as Not Enough Rights to Access Inventory Dimension table (InventDim) I checked for this particular table and the rights assigned to it are View, but under the Tables option if I select Inventory Dimensions table then fields/fields group under it are having no values for the Access option (I mean none of the 5 options no access/view/edit/create/full control are selected) and even if i try to assign any value say for e.g. View then it does not get Saved has anyone done security rights setup?? -Tushar Connect with friends all over the world. Get Yahoo! India Messenger at http://in.messenger.yahoo.com/?wm=n/
Re: [Axapta-Knowledge-Village] AX Error
Yes Naeem, You r right! if this eror occurs again then please do the synchronization in Administration periodic SQL administration Table actions button synchronize option. System table some times need to be synchronized with SQL database. --- On Wed, 3/12/08, Naeem Sarwar [EMAIL PROTECTED] wrote: From: Naeem Sarwar [EMAIL PROTECTED] Subject: Re: [Axapta-Knowledge-Village] AX Error To: Axapta-Knowledge-Village@yahoogroups.com Date: Wednesday, 3 December, 2008, 4:08 PM I synchronized the system it solved the problem. Bank accounts were required to be reconfigured! On Wed, Dec 3, 2008 at 12:13 AM, MaryAnn Hand maryann.hand@ gmail.com wrote: If the number sequence is ok, then there must be some customization which is wiping out the journal number for the records that give errors. I guess it is something you need to have a developer check by debugging. On Tue, Dec 2, 2008 at 12:06 PM, Naeem Sarwar mnaeemsarwar@ gmail.com wrote: the numbers are being generated. for JV and lines it wont give error while entering the data but during validation and posting. do you think i still needs to check it... we haven't changed anything is system the only thing changed it re-installation of AOS On Tue, Dec 2, 2008 at 7:38 PM, MaryAnn Hand maryann.hand@ gmail.com wrote: The error indicates that there is no journal number. Run the Number sequence wizard - you need to have journal numbers to post! On Tue, Dec 2, 2008 at 10:48 AM, Naeem Sarwar mnaeemsarwar@ gmail.com wrote: We are facing the attached error and the scenario is given below The windows of AOS was crashed, we recovered the axapta installation directory. Reinstalled the windows with same name. Reinstalled axapta with same AOS names mapping with existing database. (over written the AX folder) Now clients are able to connect with DB creation/deletion/ editing of SO and PO is OK. But when you validate and post Journal lines it returns attached error. Thanks Naeem Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/
RE: [Axapta-Knowledge-Village] Re: Grouping of production orders for planning
Hello James, What i understood from below communication is You want to group the production orders( for diff Items/FG) which are generated with a reference of same Sales Order. And if the Scheduling date is changed because of any material constraint then the changed date should be applicable to all related Production orders. Say 1 Customer has a Sales Order created in Ax with 10 Lines for different items. Then you want to start these production orders (for all 10 FG/Items) on a same date. But in actual scenario it will not possible as the components of these 10 FG items may have a different purchase lead time. so all the orders can not be started together. Ax will give you the start date considering the On-hand inventory and Open inventory transactions for the items. Also there might be a case in which one of the 10 Fg items have a Sub-Bom in it and without manufacturing that sub-bom you will not be able to manufacture the parent FG. Till the order is in Planned state you can anytime reschedule the order but once it is firmed then you will have to change the delivery date of the Production order (In Production order General tab) and then do the scheduling for it. You can also do the Explosion for the Production order and handle the new requirements for it. But as of now the grouping of the orders against one Sales Order is not available in Ax. Probably a customization will solve your problem as you can always see the reference of the planned order in Pegging section of the Planned Production order form. I am not sure whether my understanding is accurate. Let me know if am wrong somewhere in understanding the requirement :) Waiting to hear from you. -Tushar --- On Thu, 27/11/08, James Flavell [EMAIL PROTECTED] wrote: From: James Flavell [EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] Re: Grouping of production orders for planning To: Axapta-Knowledge-Village@yahoogroups.com Date: Thursday, 27 November, 2008, 12:46 PM Sorry Harry, The schedule with finite material which I think is what you mean by the 'limited by materials' option I understand but I am trying to group several production orders together so that they all only start on a date when all materialfor all the production orders has a confirmed date. If one of the material POs should later have a change in confirmed date then the scheduling should reschedule ALL the grouped production orders to the new date. The scenario is revolving around project based manufacturer whereby the customer does not have a lot of spare space to hold finsihed items (even if they did have space they would still want to group by the project) and so they maybe get a project that has maybe 30 different FG to be produced and then delivered on a certain date. They want to do the picking of all the material at the same time for all 30 Productions as well as do the 30 production ordrs together so they can then ship them out all together at the correct date. All the production orders are pretty much involving only human labour and therefore there is not real machine constraints. So the customer would like all 30 production orders to be 'together' in the scheduling then the shop floor (assembly) can just go and start any of them and then move on to the next one until they are all finished and then the project can be shipped out Thanks James From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Harry Deshpande Sent: 27 November 2008 00:57 To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Subject: RE: [Axapta-Knowledge- Village] Re: Grouping of production orders for planning I am not sure of what you are saying. Did you try ‘limited by materials’ checkbox while scheduling production orders? Regards Harry From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of James Flavell Sent: Wednesday, November 26, 2008 1:19 AM To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Subject: RE: [Axapta-Knowledge- Village] Re: Grouping of production orders for planning Thanks Harry Kind of getting you although probably not 100% The production orders planned start date should be based on when the material is available If the material is delayed then the start date of the production orders should be delayed and the user warned if they will miss the delivery date I believe this is how the master planning is doing in AX (for single item) if everything is still in the planned status. But once firmed then I think AX master planning does not really give a good indication to the user Thanks James From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Harry Deshpande Sent: 24 November 2008 12:22 To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Subject: RE: [Axapta-Knowledge- Village] Re: Grouping of
Re: [Axapta-Knowledge-Village] Ax Installation error . Plz send Reply Urgent.
Contents of log MSI (s) (CC:58) [11:47:38:729] : MainEngineThread is returning 1625 This installation is forbidden by system policy. Contact your system administrator indicates that you are not doing the installation being an administrative user. Make sure that you do the installation as an administrator user. -Tushar --- On Thu, 16/10/08, suneel babu [EMAIL PROTECTED] wrote: From: suneel babu [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Ax Installation error . Plz send Reply Urgent. To: Axapta Knowledge village axapta-knowledge-village@yahoogroups.com, amit bhatt AX [EMAIL PROTECTED], Arjit babu Ax [EMAIL PROTECTED], Ax Questions [EMAIL PROTECTED], Development [EMAIL PROTECTED] Date: Thursday, 16 October, 2008, 3:39 PM Hi., when i am installain g Ax 4.0 AOS at the client place, i faced the below error. Any one knows about that, plz send reply ASAP. * *ObjectServe r+log.txt* * * MSI (s) (CC:58) [11:47:38:729] : Product not registered: beginning first-time install MSI (s) (CC:58) [11:47:38:729] : PROPERTY CHANGE: Adding ProductState property. Its value is '-1'. MSI (s) (CC:58) [11:47:38:729] : Entering CMsiConfigurationMa nager::SetLastUs edSource. MSI (s) (CC:58) [11:47:38:729] : User policy value 'DisableMedia' is 1 MSI (s) (CC:58) [11:47:38:729] : Warning: rejected media source due to system policy. MSI (s) (CC:58) [11:47:38:729] : Note: 1: 1708 MSI (s) (CC:58) [11:47:38:729] : Note: 1: 2729 MSI (s) (CC:58) [11:47:38:729] : Note: 1: 2729 MSI (s) (CC:58) [11:47:38:729] : Product: Microsoft Dynamics AX 4.0 Object Server -- Installation failed. MSI (s) (CC:58) [11:47:38:729] : MainEngineThread is returning 1625 This installation is forbidden by system policy. Contact your system administrator. H:\Msi\ObjectServer \ObjectServer. msi MSI (c) (E0:9C) [11:47:38:839] : Decrementing counter to disable shutdown. If counter = 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (E0:9C) [11:47:38:839] : MainEngineThread is returning 1625 * * * * * * * Get the latest buzz on outsourcing. Up to date information on mergers, acquisitions and deals on BPO Watch. Try it now! Get perfect Email ID for your Resume. Grab now http://in.promos.yahoo.com/address
[Axapta-Knowledge-Village] Sales Tax Codes Report in IND LOC 4.0 SP2
Hello all, Does anyone have any idea about how to do the report setup for sales tax codes?? It is available as a standard feature in Ax 4.0 SP2 IND LOC at following path: GL Setup Sales Tax Sales Tax codes -- select any sales tax code and go to Report Setup tab and Report setup - credit note tab, here we can design the reports but as of now no idea of how to design it. If anyone has done some work on it, then it will be of gr8 help!! -Tushar Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/
Re: [Axapta-Knowledge-Village] Re: Item transaction reference
Hi Kiran, My client is using their customized barcode definition and for that we have customized the ean 128 type of barcode setup available in Axapta. It is modified as per their requirement. The barcode definition contains Vendor name, Item number, Item Name, Date of receipt, Lot qty(received qty) and packing qty i.e. if the supplier has sent 400 units of an item in 4 packs containing 100 units in each pack. Now based on this we have managed to print the barcode labels at the time of quality inspection and the material is inwarded but the scanning process is done when the same material is issued to production department. At the time of scanning i want to maintain FIFO i.e. the first received material should be issued first. for which i wanted to know whether we can keep a track of receipts and issues of the material. let me know if u need more information. -Tushar --- On Sun, 5/10/08, kkthadishetty [EMAIL PROTECTED] wrote: From: kkthadishetty [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Re: Item transaction reference To: Axapta-Knowledge-Village@yahoogroups.com Date: Sunday, 5 October, 2008, 2:33 AM Hi Tushar, i need some more information about the barcode for the item.when and how the barcode is generated barcode containing which data..(composition of barcode) and which barcode your client is using(ean13 or ean128..etc. ,) when the items are picked from the inventory we have to do some customisation for batch control. and there are some addons are avaliable for batch control. (FULLSCOPE Process manufacturing addon module have the batch control.) i think some other partners are also developed the batch controll. regards kiran 00971554070590 if barcode contains batch data/ batch number in that... --- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, Tushar Joshi tushar_s_joshi@ ... wrote: Agreed Kiran.  But my client has a Barcode setup in which they scan the barcode label while issuing the material from the inventory. Now I want to use FIFO methodology while scanning i.e. If i have 2 PO's for X item with different receipt days say 2/10/2008 and 3/10/2008.  Now when i will isssue the material X to production department at that time i have a barcode label printed on the material and it has a definition for it which contains date of receipt, according to this if a material with prior receipt date is available in my inventory then scanning should throw an error saying previously received material exists in inventory so i though might be the LOT ID's or REFRENCE ID's can work for this  If you have any other suggession to map this, i would gladly accept the same! :)  -Tushar --- On Mon, 29/9/08, kkthadishetty kkthadishetty@ ... wrote: From: kkthadishetty kkthadishetty@ ... Subject: [Axapta-Knowledge- Village] Re: Item transaction reference To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Date: Monday, 29 September, 2008, 12:21 PM Hi Tushar, i understood your query. but i want to know the reason why u want to track the items through LOT ID..in the Ax we have Batch number dimension available already. activate the batch number dimension for the item and the same can be tracked. Regards Kiran --- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, Tushar Joshi tushar_s_joshi@ ... wrote: Thanks Khalil,  But do we have a reference for it? how can you say that it has been reduced from the 1st PO? I am using FIFO method for my inventory transactions. Does it refers to any LOT, REFERENCE or DIMNSION ID?? if u can explain in some more detail then it would of gr8 help!!  -Tushar --- On Sun, 28/9/08, Khalil Rehman khalilrehman5@ ... wrote: From: Khalil Rehman khalilrehman5@ ... Subject: RE: [Axapta-Knowledge- Village] Item transaction reference To: axapta-knowledge- [EMAIL PROTECTED] ups.com Date: Sunday, 28 September, 2008, 12:50 PM Dear Tushar,     if you are using FIFO method, then it will reduce the quatity from that PO, which was become inventory part first. mean from the PO whose invoice generated first.  i hope it will solve your problem.  KHALIL UR REHMAN To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com From: tushar_s_joshi@ yahoo.co. in Date: Sat, 27 Sep 2008 10:34:09 +0530 Subject: [Axapta-Knowledge- Village] Item transaction reference Hi Ax Users,  I want to know how can we keep a track of Item transactions references?? which has been received and issued. In detail the scenario is like this:  I have created 2 PO's of the item X. Former with Qty 100 and Later with 500 After posting invoice for both Purchase Orders the Lot ID, Reference Lot Id and Dimension ID got generated against both of them in Inventory item transactions. My Inventory for the same Item shows now 600 qty. After Posting
Re: [Axapta-Knowledge-Village] Re: Item transaction reference
Agreed Kiran. But my client has a Barcode setup in which they scan the barcode label while issuing the material from the inventory. Now I want to use FIFO methodology while scanning i.e. If i have 2 PO's for X item with different receipt days say 2/10/2008 and 3/10/2008. Now when i will isssue the material X to production department at that time i have a barcode label printed on the material and it has a definition for it which contains date of receipt, according to this if a material with prior receipt date is available in my inventory then scanning should throw an error saying previously received material exists in inventory so i though might be the LOT ID's or REFRENCE ID's can work for this If you have any other suggession to map this, i would gladly accept the same! :) -Tushar --- On Mon, 29/9/08, kkthadishetty [EMAIL PROTECTED] wrote: From: kkthadishetty [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Re: Item transaction reference To: Axapta-Knowledge-Village@yahoogroups.com Date: Monday, 29 September, 2008, 12:21 PM Hi Tushar, i understood your query. but i want to know the reason why u want to track the items through LOT ID..in the Ax we have Batch number dimension available already. activate the batch number dimension for the item and the same can be tracked. Regards Kiran --- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, Tushar Joshi tushar_s_joshi@ ... wrote: Thanks Khalil,  But do we have a reference for it? how can you say that it has been reduced from the 1st PO? I am using FIFO method for my inventory transactions. Does it refers to any LOT, REFERENCE or DIMNSION ID?? if u can explain in some more detail then it would of gr8 help!!  -Tushar --- On Sun, 28/9/08, Khalil Rehman khalilrehman5@ ... wrote: From: Khalil Rehman khalilrehman5@ ... Subject: RE: [Axapta-Knowledge- Village] Item transaction reference To: axapta-knowledge- [EMAIL PROTECTED] ups.com Date: Sunday, 28 September, 2008, 12:50 PM Dear Tushar,     if you are using FIFO method, then it will reduce the quatity from that PO, which was become inventory part first. mean from the PO whose invoice generated first.  i hope it will solve your problem.  KHALIL UR REHMAN To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com From: tushar_s_joshi@ yahoo.co. in Date: Sat, 27 Sep 2008 10:34:09 +0530 Subject: [Axapta-Knowledge- Village] Item transaction reference Hi Ax Users,  I want to know how can we keep a track of Item transactions references?? which has been received and issued. In detail the scenario is like this:  I have created 2 PO's of the item X. Former with Qty 100 and Later with 500 After posting invoice for both Purchase Orders the Lot ID, Reference Lot Id and Dimension ID got generated against both of them in Inventory item transactions. My Inventory for the same Item shows now 600 qty. After Posting the Purchase Orders the Inventory transactions has the status as PURCHASED.  Now i did a transaction of Item movement, through Inventory Movement Journal. The qty in movement journal is -50. After posting the Movement journal, inventory transaction for the item has status as SOLD.  Here i want to know out of which two PURCHASED lots I have issued the qty (means whether from the PURCHASE of 100 or from the PURCHASE of 500)??  Would appreciate any input on this!! Its really urgent!  -Tushar Did you know? You can CHAT without downloading messenger. Click here Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! Try it! Download prohibited? No problem. CHAT from any browser, without download. Go to http://in.webmessen ger.yahoo. com/ Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/
RE: [Axapta-Knowledge-Village] Item transaction reference
Thanks Khalil, But do we have a reference for it? how can you say that it has been reduced from the 1st PO? I am using FIFO method for my inventory transactions. Does it refers to any LOT, REFERENCE or DIMNSION ID?? if u can explain in some more detail then it would of gr8 help!! -Tushar --- On Sun, 28/9/08, Khalil Rehman [EMAIL PROTECTED] wrote: From: Khalil Rehman [EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] Item transaction reference To: axapta-knowledge-village@yahoogroups.com Date: Sunday, 28 September, 2008, 12:50 PM Dear Tushar, if you are using FIFO method, then it will reduce the quatity from that PO, which was become inventory part first. mean from the PO whose invoice generated first. i hope it will solve your problem. KHALIL UR REHMAN To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com From: tushar_s_joshi@ yahoo.co. in Date: Sat, 27 Sep 2008 10:34:09 +0530 Subject: [Axapta-Knowledge- Village] Item transaction reference Hi Ax Users, I want to know how can we keep a track of Item transactions references?? which has been received and issued. In detail the scenario is like this: I have created 2 PO's of the item X. Former with Qty 100 and Later with 500 After posting invoice for both Purchase Orders the Lot ID, Reference Lot Id and Dimension ID got generated against both of them in Inventory item transactions. My Inventory for the same Item shows now 600 qty. After Posting the Purchase Orders the Inventory transactions has the status as PURCHASED. Now i did a transaction of Item movement, through Inventory Movement Journal. The qty in movement journal is -50. After posting the Movement journal, inventory transaction for the item has status as SOLD. Here i want to know out of which two PURCHASED lots I have issued the qty (means whether from the PURCHASE of 100 or from the PURCHASE of 500)?? Would appreciate any input on this!! Its really urgent! -Tushar Did you know? You can CHAT without downloading messenger. Click here Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! Try it! Download prohibited? No problem. CHAT from any browser, without download. Go to http://in.webmessenger.yahoo.com/
[Axapta-Knowledge-Village] Report Path in Report print!
All, Is Unlimited freedom, unlimited storage. Get it now, on http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/
[Axapta-Knowledge-Village] Report Path in Report print!
All, Is it possible to print the Report path in the print of the report? E.g. - I have opened a report say GLReportsTransactionsPeriodicTrial Balance, then on the report print is it possible to print it somewhere? say header or footer? In one of the implementations it has came as a requirement from Client :) -Tushar Unlimited freedom, unlimited storage. Get it now, on http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/
[Axapta-Knowledge-Village] Configuration Rules and Routes
Hi Ax users, Does anyone have idea or any document for reference on BOM Configuration Rules and Configuration Routes?? How it can be set? whats the procedure for setting a configuration rule or route? what is the significance of it? -Tushar Add more friends to your messenger and enjoy! Go to http://in.messenger.yahoo.com/invite/
Re: [Axapta-Knowledge-Village] Master data not displaying.
I think the problem is with inventdimid field of InventItemLocation table (if you check InventItemLocation is the datasource of InventTable and its having join with InventDim table) Records will be visible on form if we have: 1 Item’s record in InventTable 2 Three records in InventTableModule Table (for sales, purch and invent) 3 Record in InventItemLocation table and inventDimId field of this table is having “Axapta” value (that is default value) So what I feel, in your case you’ve not updated the InventItemLocation table correctly…. Just insert “Axapta” in the inventDimId field the u’ll be able to see the records on form…. -Tushar --- On Wed, 10/9/08, Clive Buda [EMAIL PROTECTED] wrote: From: Clive Buda [EMAIL PROTECTED] Subject: Re: [Axapta-Knowledge-Village] Master data not displaying. To: Axapta-Knowledge-Village@yahoogroups.com Date: Wednesday, 10 September, 2008, 7:01 PM Did you check the company that you used on the import file and the one that you cannot see your data. --- On Tue, 9/9/08, sachin ghodajkar [EMAIL PROTECTED] com wrote: From: sachin ghodajkar [EMAIL PROTECTED] com Subject: [Axapta-Knowledge- Village] Master data not displaying. To: Axv axapta-knowledge- [EMAIL PROTECTED] ups.com Date: Tuesday, September 9, 2008, 12:41 PM Dear friends, I uploaded the data in a company.The activity was completed succesfully without any error or message.( Message:-The import took 100 seconds) But when i goes to Item master data, the data was not displayed. The data is also not available in back-end i.e. invent table, invent table module * invent table location. Please tell me the reason why it is happening its remedy. Reply the mail ASAP. Regards Sachin S.Ghodajkar Mumbai. Unlimited freedom, unlimited storage. Get it now, on http://help. yahoo.com/ l/in/yahoo/ mail/yahoomail/ tools/tools- 08.html/ Unlimited freedom, unlimited storage. Get it now, on http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/
[Axapta-Knowledge-Village] trade agreements lead time field significance
All, I have came across a requirement regarding trade agreements based on the mode of delivery for which in standard Ax there is no setups available. Though i am trying to handle or suggest a work around for it through the lead time field in trade agreements form because if the mode of delivery for the item is say BY AIR and BY SEA then there will be a difference in the purchase lead time of it which can be set by selecting the delivery date while creating a P.O. E.g. I have created a purchase price agreement for B-Pack1 item as below Currency Account code Account selection Warehouse Unit Quantity Price Find next Lead time Working days INR Table 3000 GW Pcs 100 8 Yes 5 Yes INR Table 3000 GW Pcs 100 10 Yes 0 Yes so in above scenarion my price of the item varies on the basis of lead time. But when i create a PO and set its delivery date as today (that means the lead time in this case is 0 days) still my PO line shows the rate of the item as 8.00 Rs. which should be 10.00 Rs in this case. Can anyone help on this? Also please let me know if my approach is altogether wrong! Your valuable inputs are required! -Tushar Add more friends to your messenger and enjoy! Go to http://in.messenger.yahoo.com/invite/
Re: [Axapta-Knowledge-Village] Error during multi line voucher posting
What transaction u r doing? Service Tax, TDS? -Tushar --- On Thu, 28/8/08, asit nayak [EMAIL PROTECTED] wrote: From: asit nayak [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Error during multi line voucher posting To: Axapta-Knowledge-Village@yahoogroups.com Date: Thursday, 28 August, 2008, 9:35 AM Hi All, I am using Ax 4.0Sp2(IND). When I am posting multi line voucher ,recoverable GL account is hitting rather than interim account. It should hit interim account. Please any one help me out. Thanks Asit Unlimited freedom, unlimited storage. Get it now, on http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/
RE: [Axapta-Knowledge-Village] Production Time in Seconds
Thanks Harry for the prompt reply. Date of the sales orders is 1/1/2008. I have changed my machine date to 1/1/2008 and asked the user to enter the sales order schedule. I am doing the Master scheduling for the first time and there are no production orders exisitng so capacity reservations should not be the reason for the error. Is my conversion factor correct? and i trust that, putting it into the Hours/Time field is the correct way of doing setup! Correct me if wrong. --- On Mon, 11/8/08, Harry Deshpande [EMAIL PROTECTED] wrote: From: Harry Deshpande [EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] Production Time in Seconds To: Axapta-Knowledge-Village@yahoogroups.com Axapta-Knowledge-Village@yahoogroups.com Date: Monday, 11 August, 2008, 1:54 AM What is the date of your sales order? Regards Harry www.systomatics. com From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta- Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Tushar Joshi Sent: Saturday, August 09, 2008 3:15 AM To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Subject: [Axapta-Knowledge- Village] Production Time in Seconds Hello All, Does anyone has idea how to capture the runtime of a process in seconds? I tried the same by putting the Conversion factor as (1/3000=.0003) into the Hours/Time field in Times Tab of the Route. But it throws the error when i ran the Master scheduling saying working Time STD not defined for the period 31/12/2007. I am running the master scheduling for the month of January and have changed my system date to 1/1/2008. Logically Axapta will do the requirements calculations for Purchase and Production orders in a backward direction i.e. from the date of delivery it will go backwards. My sales order quantities are around 40,000 nos and if the cycle time for 1 unit(process qty) is 15 seconds then its should not go beyond 2 hrs of production time. But still am getting the eror for the period of 31/12/2005. Any help would be highly appreciated! a screenashot of the setups is attached for the reference. Download prohibited? No problem. CHAT from any browser, without download. Add more friends to your messenger and enjoy! Go to http://in.messenger.yahoo.com/invite/
[Axapta-Knowledge-Village] Difference between Movement Journal and Profit/Loss journal
Hello Ax Users, What is the difference between Movement Journal and Profit/Loss journal? the only difference i found is We can define an offset account in Movement journal and in Profit/Loss journal we can put only quantity ad cost for item. Can anyone put some light on how and in which scenarios these journals will be used? At least 1 example each!! -Tushar - Bring your gang together. Do your thing. Find your favourite Yahoo! Group.
Re: [Axapta-Knowledge-Village] Packing Slip Number
Hi there, I think there is no point in attaching any number sequence to Packing slip because it'a user enterable field in which the user will enter the packing slip number which he recieves from Supplier(Vendor) at the time of material reciept (it is also known as Goods Reciept Note / Delivery Challan number in INDIAN scenario) and so there should not be any number sequence attached to it. -Tushar findrajon [EMAIL PROTECTED] wrote: Hi everybody. Can anyone please help me in attaching a number sequence to packing slip no field when i try to post packing slip in purchase order.The no should be visible on this field as soon as packing slip posting form is opened. - Bollywood, fun, friendship, sports and more. You name it, we have it.
Re: [Axapta-Knowledge-Village] Packing Slip Number
Hi there, I think there is no point in attaching any number sequence to Packing slip because it's a user enterable field in which the user will enter the packing slip number which he recieves from Supplier(Vendor) at the time of material reciept (it is also known as Goods Reciept Note / Delivery Challan number in INDIAN scenario) and so there should not be any number sequence attached to it. -Tushar findrajon [EMAIL PROTECTED] wrote: Hi everybody. Can anyone please help me in attaching a number sequence to packing slip no field when i try to post packing slip in purchase order.The no should be visible on this field as soon as packing slip posting form is opened. - Explore your hobbies and interests. Click here to begin.
Re: [Axapta-Knowledge-Village] Export to Excel
You can save the report in HTML format and then open with excel -Tushar [EMAIL PROTECTED] wrote: Hi All, I have one report, which when exported to excel doesnt comes in proper format.Is there any other way to export the report in excel, may be through coding as possible in Navision. Thanks in advance. Regards Priyanka - From Chandigarh to Chennai - find friends all over India. Click here.
RE: [Axapta-Knowledge-Village] Re: Shift timings fpr Production
Thanks Anders. But does that mean we can not use these working times for INDIAN production scenario? where you have time intervals as 07:00AM to 03:00PM, 03:00PM to 11:00PM and 11:00PM to 07:00AM(next day). If NO then can we customize these working times? Its a critical requirement from client to keep track of production outputs!! -Tushar Anders Sorensen [EMAIL PROTECTED] wrote: Hi, The problem is that you are not allowed to have time intervals that cross midnight (toTime always has to be after fromTime) , since each working time interval is defined per date. Regards, Anders Sorensen This posting is provided AS IS with no warranties, and confers no rights. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Tushar Joshi Sent: 11. april 2008 10:21 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Re: Shift timings fpr Production No Sumit it still gives the error. I have attached the screenshot for reference. -Tushar dperko64 [EMAIL PROTECTED] wrote: Your end time for one shift is exactly the same as the start time for your next shift. Either change first shift to end at 2:59 PM or start your second shift at 3:01 PM. --- In Axapta-Knowledge-Village@yahoogroups.com, Tushar Joshi [EMAIL PROTECTED] wrote: Hi Sumit, I have to map the shift wise production details in Production order. We have created a Caledar and in that the working times are defined but when i try to create the time intervals as 07:00AM-03:00PM, 03:00PM-11:00PM, and 11:00PM -07:00AM(next day) it wont allow me to do this. It says illegal time intervals. can we customise the working times?? -Tushar - Unlimited freedom, unlimited storage. Get it now - Unlimited freedom, unlimited storage. Get it now
Re: [Axapta-Knowledge-Village] Re: Import the text file and create journal,lines and settle the open transactions
Hi Naveed,
Can we use the same if i want to import an Excel file and do the same tasks
mentioned in mail chain?
I have a requirement of that sort regarding the customer payment reciepts
i will recieve a excel from customer in which he will be mentioning the details
for payment against 200 odd invoices n instead of knocking off each transaction
can we upload the excel n do the required thing?
-Tushar
Navid Ahsan [EMAIL PROTECTED] wrote:
Hi Sanjeev,
Following is the code that creates the Journal, marks the transaction
(indicated by invoiceid) for settlement and then posts the Journal.
server static boolean ProcessPayment(CustPaymMode _paymMode,
AccountNum _accountNum, InvoiceId _invoiceId, AmountCurCredit
_amountCurCredit, TransDate _transDate = SystemDateGet())
{
LedgerJournalName ledgerJournalName;
LedgerJournalTable ledgerJournalTable;
LedgerJournalTrans ledgerJournalTrans;
LedgerJournalCheckPost ledgerJournalCheckPost;
Common common;
NumberSeq numberseq;
CustTransOpen custTransOpen;
CustInvoiceSalesLink custInvoiceSalesLink;
Specification specOffsetVoucher;
boolean result = false;
CompanyInfo company = CompanyInfo::find();
SalesId salesId = '';
CustTable cust = CustTable::find(_accountNum);
;
// if we have invoice id that means we are applying a payment
// on invoice otherwise on account payment
if(_invoiceId != '')
{
select firstonly custInvoiceSalesLink
where custInvoiceSalesLink.invoiceId == _invoiceId;
}
try
{
ttsbegin;
// Journal Name should be warehouse specific
select firstonly ledgerJournalName
where ledgerJournalName.JournalType ==
LedgerJournalType::CustPayment
ledgerJournalName.JournalName == 'Cust';
if(ledgerJournalName)
{
ledgerJournalTable.JournalName =
ledgerJournalName.JournalName;
ledgerJournalTable.Name = ledgerJournalName.Name;
ledgerJournalTable.insert();
if(ledgerJournalTable)
{
numberseq = NumberSeq::NewGetVoucherFromCode
(ledgerJournalName.VoucherSeries);
ledgerJournalTrans.JournalNum =
ledgerJournalTable.JournalNum;
ledgerJournalTrans.Voucher =
numberseq.voucher();
ledgerJournalTrans.TransDate = _transDate;
ledgerJournalTrans.AccountType =
LedgerJournalACType::Cust;
ledgerJournalTrans.Txt = strfmt('%1%
2', parameters.AdvSetTransTxt, _transDate);
ledgerJournalTrans.OffsetAccountType =
ledgerJournalName.OffsetAccountType;
ledgerJournalTrans.OffsetAccount =
ledgerJournalName.OffsetAccount;
ledgerJournalTrans.Dimension =
ledgerJournalName.Dimension;
ledgerJournalTrans.CurrencyCode =
company.CurrencyCode;
ledgerJournalTrans.ExchRate =
ExchRates::find(company.CurrencyCode, datenull(), NoYes::No,
NoYes::No).ExchRate;
ledgerJournalTrans.TransactionType =
LedgerTransType::Payment;
ledgerJournalTrans.Dimension[4] =
routeTable.DriverName1;
ledgerJournalTrans.PaymMode = _paymMode;
if(_invoiceId != '')
ledgerJournalTrans.SettleVoucher =
SettlementType::SelectedTransact;
else
ledgerJournalTrans.SettleVoucher =
SettlementType::None;
ledgerJournalTrans.AccountNum = _accountNum;
ledgerJournalTrans.AmountCurCredit =
_amountCurCredit;
ledgerJournalTrans.insert();
// Mark invoice for settlement only if we are doing
invoice payment
// not for account payment.
if(_invoiceId != '')
{
select custTransOpen
where custTransOpen.AccountNum == _accountNum
custTransOpen.RefRecId ==
CustTrans::findFromInvoice(_invoiceId).RecId;
if(custTransOpen)
{
common = ledgerJournalTrans;
specOffsetVoucher =
Specification_OffsetVoucher::newCommon(common, true);
if (!specOffsetVoucher.isMarked
(custTransOpen.TableId, custTransOpen.RecId))
{
if (ledgerJournalTrans.RecId)
{
specOffsetVoucher.create
(custTransOpen.TableId, custTransOpen.RecId, _amountCurCredit,
company.CurrencyCode);
}
}
}
}
// Journal Created now post it
ledgerJournalCheckPost =
LedgerJournalCheckPost::newLedgerJournalTable(ledgerJournalTable,
NoYes::Yes);
ledgerJournalCheckPost.run();
result = true;
}
}
ttscommit;
}
catch
{
result = false;
}
return result;
}
You can create a form that opens the text file and then load the data
into a temporary table and then when the user is satisfied with the
data create the journal using above code(above code creates a jounral
for one transaction only but it can be modified). Hope this will help.
Navid
--- In Axapta-Knowledge-Village@yahoogroups.com, Armaan
[EMAIL PROTECTED] wrote:
Hi friends,
i have a requirement like i have a text file i need to import the
text
file and create a journal and line with the customer name..and for
that customer i need to check all the open transactions and mark the
transactions for settlement..
the file contains all major details like invoice number,paym
reference,total amount,voucher number etc...
i need to start the process form AR periodic,i need to have a
dialog
box ..open the file ,,read the file and create journal,line and
settle
the open transactions..all the logic lies in class and from class am
not able to access the markstrans method of custopentrans form..
can u guys help me how
Re: [Axapta-Knowledge-Village] Re: Shift timings fpr Production
Thanks Hemant. But can we use this divided time interval for generating a shift wise production report? because my client is interested in SHIFTWISE production report and for nght shift we need to take 11:00 PM to 24:00 and 12:00AM to 7:00AM timings as parameters to generate the report. Can we do this? -Tushar Hemant Kumthekar [EMAIL PROTECTED] wrote: Hi, See the attached file. Hemant K - Original Message From: Tushar Joshi [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Friday, April 11, 2008 3:21:03 AM Subject: Re: [Axapta-Knowledge-Village] Re: Shift timings fpr Production No Sumit it still gives the error. I have attached the screenshot for reference. -Tushar dperko64 [EMAIL PROTECTED] com wrote: Your end time for one shift is exactly the same as the start time for your next shift. Either change first shift to end at 2:59 PM or start your second shift at 3:01 PM. --- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, Tushar Joshi tushar_s_joshi@ ... wrote: Hi Sumit, I have to map the shift wise production details in Production order. We have created a Caledar and in that the working times are defined but when i try to create the time intervals as 07:00AM-03:00PM, 03:00PM-11:00PM, and 11:00PM -07:00AM(next day) it wont allow me to do this. It says illegal time intervals. can we customise the working times?? -Tushar - Unlimited freedom, unlimited storage. Get it now __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com - Best Jokes, Best Friends, Best Food. Get all this and more on Best of Yahoo! Groups.
Re: [Axapta-Knowledge-Village] Enterprise Portal login
Hi, It seems the Enterprise Portal setup has been crashed for the users who are not able to see the tabs viz. HomeSales etc. Try running the EP set up again and check the ports through which you are accessing the sharepoint site. Also authentication should be the NT AUTHENTICATION for log on. Hope this will resolve your problem -Tushar larsj_73 [EMAIL PROTECTED] wrote: Hi, I have an Enterprise Portal site that works fine for some users. Other users can't see anything when they log in (they can't even see the tabs for home, sales etc.), even though the users are in the exact same groups in AX and on the SharePoint site. I've tried to put one of the users in the administration group, but that doesn't help either. When the 'normal' users are logged on to the site, they appear as web users in the online users list. When the users that can't see anything are logged on to the SharePoint site, they do not appear in the same list, so the problem seems to be in the logon to AX, but I can't figure out what it is. I'm kind of lost here, so any help is appreciated. -- With best regards Lars H. Sandvik-Jacobsen - 5, 50, 500, 5000 - Store N number of mails in your inbox. Click here.
Re: [Axapta-Knowledge-Village] Reports From AX
Hi, U can get some of these reports i dunno how useful they are in terms of the information u want to capture but try this out: 1. Sales Report (Sales Representative wise) ARReportsTransactionsSales OrderSales Order this will open a parameter form where in u have to pass the parameters. Click on Select button which will take u to update/change the parameters. So you can change the sales order field to Sales Responsible field by selecting through drop down. Try running the report for specific sales responsible or for all. 2. Recovery report (Sales Representative wise) No Clue. 3. Product wise sales report You can have a Product wise/customer wise statistics report. try the following: ARReportsStatisticsCustomerItem/Customer Statistics. 4. Try for ARReportstransactionsCustomersHistory by transaction, This report will give history by transactions for all customers. If u put the specific date while generating the report u might get what u want. and option no 5 even i need to dig out :) -Tushar Sanam Khan [EMAIL PROTECTED] wrote: Hiii Do anyone have any idea how can I get these reports from AX 1. Sales Report ( Sales representative Wise) 2. Recovery Report (Sales Representative wise) 3. Product Wise sales Report 4. Daily Sales Report (History wise) 5. Sales Representative Customers list Regards, Sanam khan - Save all your chat conversations. Find them online.
Re: [Axapta-Knowledge-Village] Lead Time in planning for Scheduling of operations
Can u please guide me in mapping Sub contracting process in Ax. I have a client who follows sub-contracting process in which the material from his own inventory are sent to vendor for job-work and then the material in inwarded with a different item number. E.g. I have a sub assemly named A for which i have a BOM and the components are C and D. I will send the material C and D to my vendor and in turn he will return me item A. -Tushar visti Sethna [EMAIL PROTECTED] wrote: Can someone tell me how will the time be captured for the subcontracting (Service type) item please. Coz My gant chart should capture the lead time for procurement of the subcontracted item when I schedule the jobs. Instead, it schedules the first operation instantly after the second operation. There is something called finite material and finite capacity planing. Where do i select the checkbox for finite material planning. Please suggest. -- With Regards, Mr. Vishtaspa Sethna Associate E.R.P. Consultant Godrej Infotech Ltd. Cell: +919718010823 - Download prohibited? No problem. CHAT from any browser, without download.
Re: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax
VendTable and CustTable i did the export and gave it to client to fill it up with their actual data. after recieving it i tried to import using same definition group and it gave an error -Tushar Nitesh [EMAIL PROTECTED] wrote: Hi Tushar, Which Table you are trying to import ? On Thu, Mar 27, 2008 at 3:17 PM, Tushar Joshi [EMAIL PROTECTED] wrote: Did not get you. which format we need? -Tushar Dharmanadi [EMAIL PROTECTED] wrote: Hi, Checked your excel format also for example Ledger table Regards, - From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Nitesh Sent: Friday, March 21, 2008 6:56 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax Hi Tushar, seems Record already exist in Table . From Import Dialog box go to Import Rule Tabpage and select the Option clear table before Import from Import Rule field. Regards Nitesh On 3/21/08, Tushar Joshi [EMAIL PROTECTED] wrote: Hi, I am trying to import the masterdata provided by client into Ax 4.0 SP2. I created a new blank company account in Ax to import data n started the excelimport through Administration - Periodic - Data Import/export - excel spreadsheets - excel import. but it gives an error and says the record already exists and import is interrupted. can anyone help me on how to import data through excel? The excel sheets were given ti client were created from same company account with a defnition group created. plz help.. Regards, Tushar - Meet people who discuss and share your passions. Join them now. - Did you know? You can CHAT without downloading messenger. Click here - Meet people who discuss and share your passions. Join them now.
RE: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax
Cristina,
How to import from a *.csv file? i saved my excel into a .csv type of file
but when trying to import it through import option it does not allow me to
select the file of tyep .csv!!
-Tushar
Cristina Carcelén [EMAIL PROTECTED] wrote:
Try to import from an *.csv file. Maybe you have some blanks records.
-
De: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] En
nombre de Tushar Joshi [EMAIL PROTECTED]
Enviado el: viernes, 21 de marzo de 2008 20:18
Para: Axapta-Knowledge-Village@yahoogroups.com
Asunto: Re: [Axapta-Knowledge-Village] Eror while importing Data from Excel to
Ax
Hi Nitesh,
Thanks a lot for reply! but i tried this already... i have a doubt... if i
try to import a single record then it is success but when i try to import
another one it syas record already exists is it something to do with Number
Sequences??? would appriciate if u cud throw some light on this :)
Tushar
Nitesh [EMAIL PROTECTED] wrote:
Hi Tushar,
seems Record already exist in Table
From Import Dialog box go to Import Rule Tabpage and select the
Option clear table before Import from Import Rule field.
Regards
Nitesh
On 3/21/08, Tushar Joshi [EMAIL PROTECTED] wrote:
Hi,
I am trying to import the masterdata provided by client into Ax 4.0 SP2.
I created a new blank company account in Ax to import data n started the
excelimport through Administration - Periodic - Data Import/export -
excel spreadsheets - excel import. but it gives an error and says the
record already exists and import is interrupted. can anyone help me on how
to import data through excel?
The excel sheets were given ti client were created from same company
account with a defnition group created.
plz help..
Regards,
Tushar
-
Meet people who discuss and share your passions. Join them now.
-
5, 50, 500, 5000 - Store N number of mails in your inbox. Click here.
#ygrp-mkp { BORDER-RIGHT: #d8d8d8 1px solid; PADDING-RIGHT: 14px;
BORDER-TOP: #d8d8d8 1px solid; PADDING-LEFT: 14px; PADDING-BOTTOM: 0px; MARGIN:
14px 0px; BORDER-LEFT: #d8d8d8 1px solid; PADDING-TOP: 0px; BORDER-BOTTOM:
#d8d8d8 1px solid; FONT-FAMILY: Arial } #ygrp-mkp HR { BORDER-RIGHT:
#d8d8d8 1px solid; BORDER-TOP: #d8d8d8 1px solid; BORDER-LEFT: #d8d8d8 1px
solid; BORDER-BOTTOM: #d8d8d8 1px solid } #ygrp-mkp #hd { FONT-WEIGHT:
bold; FONT-SIZE: 85%; MARGIN: 10px 0px; COLOR: #628c2a; LINE-HEIGHT: 122% }
#ygrp-mkp #ads { MARGIN-BOTTOM: 10px } #ygrp-mkp .ad { PADDING-RIGHT:
0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px } #ygrp-mkp .ad
A { COLOR: #ff; TEXT-DECORATION: none } #ygrp-sponsor #ygrp-lc {
FONT-FAMILY: Arial } #ygrp-sponsor #ygrp-lc #hd { FONT-WEIGHT: bold;
FONT-SIZE: 78%; MARGIN: 10px 0px; LINE-HEIGHT: 122% } #ygrp-sponsor #ygrp-lc
.ad { PADDING-RIGHT: 0px; PADDING-LEFT: 0px; MARGIN-BOTTOM:
10px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px } #ygrp-mlmsg { FONT:
x-small arial,helvetica,clean,sans-serif } #ygrp-mlmsg TABLE { FONT-WEIGHT:
normal; FONT-SIZE: 100%; LINE-HEIGHT: normal; FONT-STYLE: normal; FONT-VARIANT:
normal } #ygrp-mlmsg SELECT { FONT: 99% arial,helvetica,clean,sans-serif }
INPUT { FONT: 99% arial,helvetica,clean,sans-serif } TEXTAREA { FONT:
99% arial,helvetica,clean,sans-serif } #ygrp-mlmsg PRE { FONT: 100%
monospace } CODE { FONT: 100% monospace } #ygrp-mlmsg * { LINE-HEIGHT:
1.22em } #ygrp-text { FONT-FAMILY: Georgia } #ygrp-text P { MARGIN: 0px
0px 1em } #ygrp-tpmsgs { CLEAR: both; FONT-FAMILY: Arial } #ygrp-vitnav {
FONT-SIZE: 77%; MARGIN: 0px; PADDING-TOP: 10px; FONT-FAMILY: Verdana }
#ygrp-vitnav A { PADDING-RIGHT: 1px; PADDING-LEFT: 1px; PADDING-BOTTOM: 0px;
PADDING-TOP: 0px } #ygrp-actbar { CLEAR: both; MARGIN: 25px 0px; COLOR:
#666; WHITE-SPACE: nowrap; TEXT-ALIGN: right }
#ygrp-actbar .left { FLOAT: left; WHITE-SPACE: nowrap } bld {
FONT-WEIGHT: bold } #ygrp-grft { PADDING-RIGHT: 0px; PADDING-LEFT: 0px;
FONT-SIZE: 77%; PADDING-BOTTOM: 15px; PADDING-TOP: 15px; FONT-FAMILY: Verdana
} #ygrp-ft { PADDING-RIGHT: 0px; BORDER-TOP: #666 1px solid; PADDING-LEFT:
0px; FONT-SIZE: 77%; PADDING-BOTTOM: 5px; PADDING-TOP: 5px; FONT-FAMILY:
verdana } #ygrp-mlmsg #logo { PADDING-BOTTOM: 10px } #ygrp-reco {
PADDING-RIGHT: 0px; PADDING-LEFT: 0px; MARGIN-BOTTOM: 20px; PADDING-BOTTOM:
0px; PADDING-TOP: 0px } #ygrp-reco #reco-head { FONT-WEIGHT: bold; COLOR:
#ff7900 } #reco-grpname { MARGIN-TOP: 10px; FONT-WEIGHT: bold }
#reco-category { FONT-SIZE: 77% } #reco-desc { FONT-SIZE: 77% }
#ygrp-vital { PADDING-RIGHT: 0px; PADDING-LEFT: 8px; MARGIN-BOTTOM: 20px;
PADDING-BOTTOM: 8px; PADDING-TOP: 2px; BACKGROUND-COLOR: #e0ecee }
#ygrp-vital #vithd { FONT-WEIGHT: bold; FONT-SIZE: 77
RE: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax
Did not get you. which format we need? -Tushar Dharmanadi [EMAIL PROTECTED] wrote: Hi, Checked your excel format also for example Ledger table Regards, - From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Nitesh Sent: Friday, March 21, 2008 6:56 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax Hi Tushar, seems Record already exist in Table . From Import Dialog box go to Import Rule Tabpage and select the Option clear table before Import from Import Rule field. Regards Nitesh On 3/21/08, Tushar Joshi [EMAIL PROTECTED] wrote: Hi, I am trying to import the masterdata provided by client into Ax 4.0 SP2. I created a new blank company account in Ax to import data n started the excelimport through Administration - Periodic - Data Import/export - excel spreadsheets - excel import. but it gives an error and says the record already exists and import is interrupted. can anyone help me on how to import data through excel? The excel sheets were given ti client were created from same company account with a defnition group created. plz help.. Regards, Tushar - Meet people who discuss and share your passions. Join them now. - Did you know? You can CHAT without downloading messenger. Click here
Re: [Axapta-Knowledge-Village] Reverse Sales Packing Slips
No its not possible to reverse a packing slip once it is posted... u have to pass a General Journal to reverse the account entry. Regds, Tushar anishafakir [EMAIL PROTECTED] wrote: Hi, Is it possible in AX4.0 to reverse packing slips by specifying a paticular packing slip for a sales order? This is when a sales order has multiple packing slips, e.g. say 3 packing slip records DN1, DN2, DN3 and you only want to reverse a particular packing slip say DN3. Can this be done standard or must it be a mod? Thanking you in advance Regards, Anisha - Bollywood, fun, friendship, sports and more. You name it, we have it.
Re: [Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax
Hi Nitesh, Thanks a lot for reply! but i tried this already... i have a doubt... if i try to import a single record then it is success but when i try to import another one it syas record already exists is it something to do with Number Sequences??? would appriciate if u cud throw some light on this :) Tushar Nitesh [EMAIL PROTECTED] wrote: Hi Tushar, seems Record already exist in Table . From Import Dialog box go to Import Rule Tabpage and select the Option clear table before Import from Import Rule field. Regards Nitesh On 3/21/08, Tushar Joshi [EMAIL PROTECTED] wrote: Hi, I am trying to import the masterdata provided by client into Ax 4.0 SP2. I created a new blank company account in Ax to import data n started the excelimport through Administration - Periodic - Data Import/export - excel spreadsheets - excel import. but it gives an error and says the record already exists and import is interrupted. can anyone help me on how to import data through excel? The excel sheets were given ti client were created from same company account with a defnition group created. plz help.. Regards, Tushar - Meet people who discuss and share your passions. Join them now. - 5, 50, 500, 5000 - Store N number of mails in your inbox. Click here.
[Axapta-Knowledge-Village] Eror while importing Data from Excel to Ax
Hi, I am trying to import the masterdata provided by client into Ax 4.0 SP2. I created a new blank company account in Ax to import data n started the excelimport through Administration - Periodic - Data Import/export - excel spreadsheets - excel import. but it gives an error and says the record already exists and import is interrupted. can anyone help me on how to import data through excel? The excel sheets were given ti client were created from same company account with a defnition group created. plz help.. Regards, Tushar - Meet people who discuss and share your passions. Join them now.
Re: [Axapta-Knowledge-Village] Re: serial no problem
Dear Pradeep, I tried the steps(but i have skipped the 3rd one) but it gives the error as A quantity other than 1 can not be updated with serial number SR2 (the one which i created) because serial number control is activated. And it does not allow you to post registration transaction. pls help! Regards, Tushar Joshi pradeepkanagaraj [EMAIL PROTECTED] wrote: Dear Ghosh, Try these steps: 1. Inventory Management - Link the RAMs item with a dimension group in which the storage dimension Serial Number is active (and /or made primary stocking). 2.Also select the Serial Number Control option in General tab of storage dimension form against Serial Number. 3. Attach RAMs to an inventory model group with Registration option selected. This step can be skipped if required. 4. While updating Packing Slip, go to PO lines -- Inventory -- Registration -- Enter 500 or select Auto Create -- Create Serial Numbers. This should solve your problem. Guys correct me if wrong. Regards, Pradeep Kanagaraj --- In Axapta-Knowledge-Village@yahoogroups.com, ghoshsubhajit [EMAIL PROTECTED] wrote: Dear All I have a problem in handling serial no (inventory dimension) in AX4. I want to buy 500 rams from a vendor. For that I create a PO with one line where quentity is 500. Now vendor delivers 500 RAMs with 500 serial no. Now I want to tag serial no aganist each ram. But my PO line is only one. How can I do this. Is there any standard functionality for this or customization required. Regards Subhajit Ghosh - Unlimited freedom, unlimited storage. Get it now
