[Axapta-Knowledge-Village] Project Activities import
Hi, I am in a need of importing huge activities for a particular project in project module. If somebody has done this import then please share with me the exact tables which are used to upload these activities. Thanks in advance! Ali
[Axapta-Knowledge-Village] Synchronize database error
Hi, I got this below mentioned error when i tried to change the string size of the EDT AccountNum from 20 to 150. Can anyone please tell me what would be the impact of such a change and what will happen if all the tables using this EDT have more than 1 lakh records? error: The total, internal size of the records in your joined SELECT statement is 37264 bytes, but Microsoft Dynamics is by default performance-tuned not to exceed 24576 bytes. It is strongly recommended that you split your table(s) into smaller units. Alternatively, you have to specify a 'Buffer size' value of 37 Kbytes or higher in the 'SQL' tab page in the Microsoft Dynamics Configuration Utility. The default value is 24 Kbytes. Exit Microsoft Dynamics immediately, and follow the directives above. Use of the table(s) will cause unpredictable results. Thanks in advance! Suchitra
[Axapta-Knowledge-Village] Error when start Axapta 4.0 client
Hello, I'm trying to start Axapta 4.0 client on the Windows 2003 Server by remote desktop. I'm a member of Remote Desktop Users group. Client won't start and I get following error in the Application Log: Event Type: Error Event Source: .NET Runtime 2.0 Error Reporting Event Category: None Event ID: 1000 Date: 2009-02-11 Time: 13:35:07 User: N/A Computer: SYG_AX_TST Description: Faulting application ax32.exe, version 4.0.2503.451, stamp 48ef7a01, faulting module kernel32.dll, version 5.2.3790.4062, stamp 4626467c, debug? 0, fault address 0x00022366. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Data: : 41 00 70 00 70 00 6c 00 A.p.p.l. 0008: 69 00 63 00 61 00 74 00 i.c.a.t. 0010: 69 00 6f 00 6e 00 20 00 i.o.n. . 0018: 46 00 61 00 69 00 6c 00 F.a.i.l. 0020: 75 00 72 00 65 00 20 00 u.r.e. . 0028: 20 00 61 00 78 00 33 00.a.x.3. 0030: 32 00 2e 00 65 00 78 00 2...e.x. 0038: 65 00 20 00 34 00 2e 00 e. .4... 0040: 30 00 2e 00 32 00 35 00 0...2.5. 0048: 30 00 33 00 2e 00 34 00 0.3...4. 0050: 35 00 31 00 20 00 34 00 5.1. .4. 0058: 38 00 65 00 66 00 37 00 8.e.f.7. 0060: 61 00 30 00 31 00 20 00 a.0.1. . 0068: 69 00 6e 00 20 00 6b 00 i.n. .k. 0070: 65 00 72 00 6e 00 65 00 e.r.n.e. 0078: 6c 00 33 00 32 00 2e 00 l.3.2... 0080: 64 00 6c 00 6c 00 20 00 d.l.l. . 0088: 35 00 2e 00 32 00 2e 00 5...2... 0090: 33 00 37 00 39 00 30 00 3.7.9.0. 0098: 2e 00 34 00 30 00 36 00 ..4.0.6. 00a0: 32 00 20 00 34 00 36 00 2. .4.6. 00a8: 32 00 36 00 34 00 36 00 2.6.4.6. 00b0: 37 00 63 00 20 00 66 00 7.c. .f. 00b8: 44 00 65 00 62 00 75 00 D.e.b.u. 00c0: 67 00 20 00 30 00 20 00 g. .0. . 00c8: 61 00 74 00 20 00 6f 00 a.t. .o. 00d0: 66 00 66 00 73 00 65 00 f.f.s.e. 00d8: 74 00 20 00 30 00 30 00 t. .0.0. 00e0: 30 00 32 00 32 00 33 00 0.2.2.3. 00e8: 36 00 36 00 0d 00 0a 00 6.6. Everything is OK when I add the user to the Administrators group. I can't find the solution :-( Please help Krzysztof
[Axapta-Knowledge-Village] Interest caluculation
Presently my client caluculating interest on fixed deposits. Security deposits Term loans Bank overdraft formual is using for caluculation of interest is- Basic value * interest rate * No. of days/365 days Please any one give me the detailed description how abvoe types ate fit in to axapta Rajender Reddy
[Axapta-Knowledge-Village] Credit And Debit note process
Hi All, The senario is My client raise the credit note based upon the 1. Customer Sales target- Client gives the sales target to the customers and sales Persons. Customers and Sales persons reached the Sales target Company will gives the incentives and discounts, for that incentives and discounts Company will raise the credit note to customers and sales persons. 2. Customers pay any fright charges behalf of Company. To that customer, Company raise the credit note. 3. Schemes and advertisement expenses, hording expences, exbition sales, Glow sighne board Expences, Suplamentory items etc 4.When goods returned or rejected from customers,Company(client) will raise the crdit note please any one help me. How these are map to axapta,Please give me the datailed description Rajender Reddy === Extend your network, join the Microsoft Dynamics AX Knowledge Village at LINKEDIN ! http://www.linkedin.com/e/gis/165338 Microsoft Dynamics AX Knowledge Village
[Axapta-Knowledge-Village] Re: Serial number - production order
Hi eng_elcoach! Thanks for reply, Just now i tried it. In Serial number group form under General Tab if i use any one option like Date, Reference No. it is function well. If i use all the three option like Date , Reference number Number sequences it throughing me error message (Line 1, update has been canceled). While iam using single option called - Date option, transaction serial number of production order updated with the production start date, instead of Report as finished date. Could you guide me how bring in to function with all the option (date, ref no. number) were date should be report as finished date. Thanks in advance, --- In Axapta-Knowledge-Village@yahoogroups.com, hany ali eng_elco...@... wrote: Dear All, To generate serial numebers automatically after report as finished the production order: 1-Serial number must be active in the Dimension group 2-u must link the BOM with a Serial number group inventory managementItems general tab 3-If there is no serial number group, create a new oneby following this path Inventory management Setup Dimensions Number groups 4-hint: A)To create only one serial number for each 100 unit produced, u must do the following in number group screen the general tab , u have to select the check boxes of ( only for invenory transaction on physical update) then enter (100) in the field of per quantity. B)In Number group screen then activation tab Production Activation must be active. I Hope this covers ur inquiry Have a nice day --- On Fri, 2/6/09, see_5623 seetharaman.subram...@... wrote: From: see_5623 seetharaman.subram...@... Subject: [Axapta-Knowledge-Village] Serial number - production order To: Axapta-Knowledge-Village@yahoogroups.com Date: Friday, February 6, 2009, 1:38 PM HI All, How to generate serial number automatically to the Production orders (eg production of 100 units per production order) which caters mfg date. I feel , in no way creating serial number manually @ serial number form Inventory Management Inquiries Dimension Serial number will help any concern, were manually feding Mfg date, manually creating 100 serial number every day or for every order. Is there any way were unique serial number automatically generated along with the Mfg date for the quantity produced or after the production order reach Report as finished status. Could any one guide me on this, I am using AX 4.0 sp1 Thanks in advance,
[Axapta-Knowledge-Village] AIF - Importing multiple records
Hi.. Consider the following scenario for AIF - importing multiple records in a single XML. Say if we are importing an XML which has 5 records in it..and assume the second record has invalid data. In this case axapta aborts the whole import process.. It should import rest of the four records and skip the second record without terminating the import process. Do you have any idea how to deal with the problem..?? Any help would be greatly appreciated. -- Best Regards, Anitha Eswaran.
Re: [Axapta-Knowledge-Village] Re: Inventory opening balances
Hi Abd Allah, First it depends on what AX version you use, because AX version differences will have only impacts on inventory dimensions, because AX 4.0 has only 8 Dim, and AX 2009 has 9 (site: is new dimension). Tables are involved in this operations are: InventJournalName,InventJournalTable,InventJournalTrans,InventDim. You will also deal with some classes are existed to help you in your importing operations from Excel file. such as: sysExcelApplication, sysExcelWorkbooks, sysExcelWorkbook, SysExcelWorksheets, sysExcelWorksheet, sysExcelCells, COMVariant. ofcourse you will as the tech guy to do this whole importing operation in x++. Mahmoud Anass Senior AX Developer Caliber Plus 3 Sun Rise Tower , Elsefarate dist. Nasr city Nasr city, Cairo, Egypt Mobile: +20109967890 Blog: http://www.ax4all.blogspot.com From: Anil Kumar Sinha anilsinha1...@yahoo.com To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, February 12, 2009 7:40:31 AM Subject: [Axapta-Knowledge-Village] Re: Inventory opening balances Hi Abdullah, Right click on Journal line and see which is the table associated with this journal line form. You can ask your techi guy to let you know the table name Most Probably it is InventJournalTrans. Export this table in Excel Template with all fields. All special value fields will also come up. I think all inventory journal (lines) use this same table. There is a field in this table which keeps information whether it is movement journal, or Profit Loss, or Transfer etc. In exported excel template this filed will have drop down. In you case you need to select Movement for all your records. There is no need to import in any other table. Hope this helps you. If you need more help on this topic please add me in yahoo messenger and I will let you help you out online on this topic. Regards Anil Sinha --- In Axapta-Knowledge- vill...@yahoogro ups.com, Abdullah Al-Nunu aaln...@... wrote: Hi Anil, Thanks for your answer. I am using Ax 2009. I tried to make the std import from excel sheet to the movement journal, but I believe that there are more than one table to import to (e.g. InventJournalTrans InventTrans) Actually, I don't know the exact tables to import to and if there is a special values for some fields in those tables. So, if you have succeeded in this before, I will appreciate your help. Regards Abdullah Al Nunu ERP Consultant http://www.netways. com/ _ _ Jeddah - Saudi Arabia Mobile:00966- 50-7402504 Email: aaln...@... Website: www.netways. com.sa http://www.netways. com.sa/ From: Axapta-Knowledge- vill...@yahoogro ups.com [mailto:Axapta-Knowledge- vill...@yahoogro ups.com] On Behalf Of Anil Kumar Sinha Sent: Tuesday, February 10, 2009 7:51 AM To: Axapta-Knowledge- vill...@yahoogro ups.com Subject: [Axapta-Knowledge- Village] Re: Inventory opening balances Hi Abdullah, Use std Axapta excel import functionality. First export the excel template for movement journal table. Fill it up and then import it to AX. BTW which version of AX you are using? Regards Anil Sinha --- In Axapta-Knowledge- vill...@yahoogro ups.com mailto:Axapta- Knowledge- Village%40yahoog roups.com , mgsrush mgsrush@ wrote: Abdullah: I would suggest doing this with X++ into a movement journal. I find it easier to do the data cleansing in SQL Server with SSIS, and then end up with one line per item for import. --- In Axapta-Knowledge- vill...@yahoogro ups.com mailto:Axapta- Knowledge- Village%40yahoog roups.com , Abdullah Al- Nunu aalnunu@ wrote: Dear all, In Ax 2009, I have more than 5000 items. I have created the items in the system but the problem is how to make the opening balance for each item. I was trying to import all these data to a movement journal or counting journal but the import was too hard and I couldn't do it. So, if you have a best practice or any experience in this area, please enlighten me ASAP. Regards Abdullah Al Nunu ERP Consultant http://www.netways. com/ _ _ Jeddah - Saudi Arabia Mobile:00966- 50-7402504 Email: aalnunu@ Website: www.netways. com.sa http://www.netways. com.sa/
[Axapta-Knowledge-Village] Expiry date
Hi All, How to setup expiry date functionality in AX. Where expiry date Mfg date are updated automatically. Currently serial number have been allocated to the product through Serial number group. Is there any option other than manually creating batch number, Mfg date expiry date @ Inventory module Inquiries Dimension Batchs. Thankks in advance,