[Axapta-Knowledge-Village] Re: Excel Import - XML generation
Hi, 1. Do you need the Excel data into Xml data? Why don't you generate Xml after successful Excel import, from table? Not clear need more clarity. 2. Validation methods from table level will be called based on the validation level defined in the definition group used for the excel export/import. If the validation level is 'None' no validation methods will be called. If it is 'Table' only validateWrite() method on the table will be called. If it is 'Field' then both validateWrite() and validateField() method on the table will be called. Hope this may be helpful. \Balasubramanian Kumaran --- In Axapta-Knowledge-Village@yahoogroups.com, Anitha E mail2eani...@... wrote: Hi all, How to generate XML when the data is imported via Excel?? I could not trace which table level method is called when the data is Excel-imported??? -- Best Regards, Anitha Eswaran.
RE: [Axapta-Knowledge-Village] Re: excel
Was the first thing that I do. But in ax I cant make the code of macro start. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steeve Gilbert Sent: terça-feira, 3 de junho de 2008 10:26 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: excel In excel, create a macro that change borders then analyse the code. You will then be able to mimic that in Axapta with COM object extracted from SysExcel* classes. --- In Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com , Rodrigo Hentz [EMAIL PROTECTED] wrote: How i can apply borders in cells of excel by x++? image001.jpgimage002.jpg
[Axapta-Knowledge-Village] Re: excel
In excel, create a macro that change borders then analyse the code. You will then be able to mimic that in Axapta with COM object extracted from SysExcel* classes. --- In Axapta-Knowledge-Village@yahoogroups.com, Rodrigo Hentz [EMAIL PROTECTED] wrote: How i can apply borders in cells of excel by x++?
Re: [Axapta-Knowledge-Village] Re: Excel templates for Uploading opening Stock
implementors. I could successfully upload the opening stock using InventJournalTable, InventJournalTrans and InventTrans. I have not included InventDim as the DimGroupIds of all the items already exists in InventDim table. I have to include InventTrans as I was getting an error that there should be transaction with status Ordered. I have included InventTrans table with status Ordered of all the items. I have uploaded and then posted the Movement Journal. Now when you see the on-hand inventory you will see the items in Ordered as negative witht he quantity uploaded. Then I went to InventSum table and changed all those negative entries to 0. I have tested master scheduling and other functionalities. Its working fine. Please reply whether this is ok. As you have used a word malfunctioing I am worried. Awaiting your reply. Thanks and best regards, Madhu Babu Rapolu --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com, ASHWANI JAIN [EMAIL PROTECTED] wrote: Hi Madhu, Uploading the opening stock using manual activity is really a tedious job, but yes we can do a partial time saving for the creation of journal (Invent journal) and journal lines (Invent journal trans). At the time of creation of record in journal lines (Inventory journal Trans), system automatically search for inventdim and if not found, then create a new record in InventDim, else allocate the available one on the InventJournalTrans. After the creation of new record in InventDim, same numbr is allcoated to respective transaction based on Dimension combination. Different inventJournalTrans lines can have same inventDim id. So in addition to above two tables, you have to import another third table InventDim. Now the question arises, how to pick / define the correct InventDim in the import file in Table InventJournalTrans, as this table does not have Dimensions (config, color, size, warehouse, location etc...) Because system allocates, this on the basis of unique combination of dimension, so in excel using concatenate formula, create a new column and put formula in that to get value. Now there must be unique values in this field (refer above bold sentence). Filter out the duplicates, and now you should have single record of each type. Take the current data of InventDim table to Excel by copy paste. Do same concatenate column in this worksheet also in excel. now using the Vlookup formula of Excel, check in earlier inventdim, what is the inventdim of those records. you will find some records / rows in excel where you will not get any inventdim. Take those records in new worksheet for import in inventdim. When you import these records, system will create the inventdim id for those records. Put these new alocated number along with the previous that you find in the InventJournalTrans. Now you can import InventJournal and InventJournalTran Tables. After importing them, ensure that all lines will be having inventdim id and cross validate for the dimensions (config, color, size, warehouse, location etc...) in them for 5 - 10 records. If found satisfactory, then you just have to click the Post button. System will post the same in inventTrans and inventsum, to update the inventory. We should not have to import the records in InventTrans / InventSum, because these tables are the heart of Dynamics Ax, which may later on result in malfunctioning of the system. This whole lenghty explaination appears to be difficult / complicated, but once you do it, you will find it as the easiest and quicker exercise. In case you need any further assitance, do write to me. Regards, Ashwani Jain - Original Message From: nigel_cox2003 [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com Sent: Wednesday, 26 September, 2007 10:07:34 PM Subject: [Axapta-Knowledge-Village] Re: Excel templates for Uploading opening Stock Forgive me, madhubabu_r, if it's just a typo on your part, but you list InventJournalTable and InventTrans as the tables you uploaded. Shouldn't this be InventJournalTable and InventJournalTrans as Sumit Loya listed? --- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, Sumit Loya loya.sumit@ ... wrote: Hi Madhu, Am not exactly sure why this error is coming. The best way to load opening balances is thru Movement journal only. I wud not guess the reason for this error as this error information is not descriptive enough.. u can try and to debug and see from where this error is coming and on what condition. Do let me know if u come to know anything on this front. One more thing if you are posting Movement journal then u need to have data in InventJournalTable (Movement journal header) and InventJournalTrans (Movement journal line). You need not create records in InventSum
Re: [Axapta-Knowledge-Village] Re: Excel templates for Uploading opening Stock
Hi Madhu, Uploading the opening stock using manual activity is really a tedious job, but yes we can do a partial time saving for the creation of journal (Invent journal) and journal lines (Invent journal trans). At the time of creation of record in journal lines (Inventory journal Trans), system automatically search for inventdim and if not found, then create a new record in InventDim, else allocate the available one on the InventJournalTrans. After the creation of new record in InventDim, same numbr is allcoated to respective transaction based on Dimension combination. Different inventJournalTrans lines can have same inventDim id. So in addition to above two tables, you have to import another third table InventDim. Now the question arises, how to pick / define the correct InventDim in the import file in Table InventJournalTrans, as this table does not have Dimensions (config, color, size, warehouse, location etc...) Because system allocates, this on the basis of unique combination of dimension, so in excel using concatenate formula, create a new column and put formula in that to get value. Now there must be unique values in this field (refer above bold sentence). Filter out the duplicates, and now you should have single record of each type. Take the current data of InventDim table to Excel by copy paste. Do same concatenate column in this worksheet also in excel. now using the Vlookup formula of Excel, check in earlier inventdim, what is the inventdim of those records. you will find some records / rows in excel where you will not get any inventdim. Take those records in new worksheet for import in inventdim. When you import these records, system will create the inventdim id for those records. Put these new alocated number along with the previous that you find in the InventJournalTrans. Now you can import InventJournal and InventJournalTran Tables. After importing them, ensure that all lines will be having inventdim id and cross validate for the dimensions (config, color, size, warehouse, location etc...) in them for 5 - 10 records. If found satisfactory, then you just have to click the Post button. System will post the same in inventTrans and inventsum, to update the inventory. We should not have to import the records in InventTrans / InventSum, because these tables are the heart of Dynamics Ax, which may later on result in malfunctioning of the system. This whole lenghty explaination appears to be difficult / complicated, but once you do it, you will find it as the easiest and quicker exercise. In case you need any further assitance, do write to me. Regards, Ashwani Jain - Original Message From: nigel_cox2003 [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, 26 September, 2007 10:07:34 PM Subject: [Axapta-Knowledge-Village] Re: Excel templates for Uploading opening Stock Forgive me, madhubabu_r, if it's just a typo on your part, but you list InventJournalTable and InventTrans as the tables you uploaded. Shouldn't this be InventJournalTable and InventJournalTrans as Sumit Loya listed? --- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, Sumit Loya loya.sumit@ ... wrote: Hi Madhu, Am not exactly sure why this error is coming. The best way to load opening balances is thru Movement journal only. I wud not guess the reason for this error as this error information is not descriptive enough.. u can try and to debug and see from where this error is coming and on what condition. Do let me know if u come to know anything on this front. One more thing if you are posting Movement journal then u need to have data in InventJournalTable (Movement journal header) and InventJournalTrans (Movement journal line). You need not create records in InventSum. It will be taken care while posting the Movement journal also enure that the Inventory dimensions id that u will provide in InventJournalTrans exists before you post the records. Regards, Sumit On 9/26/07, madhubabu_r madhubabu_r@ ... wrote: Hi Sumit, Finally shud i take the following tables in the excel templates: InventJournalTable InventTrans InventSum??? The tables I have uploaded are InventJournalTransa and InventTrans. I have managed all the number sequences in excel template itself. I could upload the data into the Movement Journal Lines. Movement Journal was also posted. I could see the onhand stock. But when I was trying to create a Sales order/Purchase Order /any inventory journals - just after entering the item and i click save I am getting an error message - Illegal Reference and I cannot proceed further. Any answers for this?? Regards, Madhu --- In Axapta-Knowledge- [EMAIL PROTECTED] ups.comAxapta-Knowledge- Village%40yahoogrou ps.com, Sumit Loya loya.sumit@ wrote: Hi, I wudnt say only InventJournalTrans and InventDim.. All item transactions are also mirrored
Re: [Axapta-Knowledge-Village] Re: Excel templates for Uploading opening Stock
Hi Madhu, Am not exactly sure why this error is coming. The best way to load opening balances is thru Movement journal only. I wud not guess the reason for this error as this error information is not descriptive enough.. u can try and to debug and see from where this error is coming and on what condition. Do let me know if u come to know anything on this front. One more thing if you are posting Movement journal then u need to have data in InventJournalTable (Movement journal header) and InventJournalTrans (Movement journal line). You need not create records in InventSum. It will be taken care while posting the Movement journal also enure that the Inventory dimensions id that u will provide in InventJournalTrans exists before you post the records. Regards, Sumit On 9/26/07, madhubabu_r [EMAIL PROTECTED] wrote: Hi Sumit, Finally shud i take the following tables in the excel templates: InventJournalTable InventTrans InventSum??? The tables I have uploaded are InventJournalTransa and InventTrans. I have managed all the number sequences in excel template itself. I could upload the data into the Movement Journal Lines. Movement Journal was also posted. I could see the onhand stock. But when I was trying to create a Sales order/Purchase Order /any inventory journals - just after entering the item and i click save I am getting an error message - Illegal Reference and I cannot proceed further. Any answers for this?? Regards, Madhu --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogroups.com, Sumit Loya [EMAIL PROTECTED] wrote: Hi, I wudnt say only InventJournalTrans and InventDim.. All item transactions are also mirrored in InventTrans table and also the on-hand (stock detalis) are stored in InventSum table (Onhand table). Regards, Sumit On 9/25/07, madhubabu_r [EMAIL PROTECTED] wrote: Hi friends, Manually entering opening stock in Movement Journal must be the most laborious job with all those Excise related entries also included. In my current project there are about 1 items as opening stock. I would like to know which tables I have to consider for excel upload of these opening entries. Awaiting your valuable responses friends. Thanks and best regards, Madhu Babu Rapolu [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Re: Excel templates for Uploading opening Stock
To use Excel to take on stock is a nightmare. Would suggest that you ask developers to develop an import script for you. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of madhubabu_r Sent: Wednesday, September 26, 2007 7:55 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Excel templates for Uploading opening Stock Hi Sumit, Finally shud i take the following tables in the excel templates: InventJournalTable InventTrans InventSum??? The tables I have uploaded are InventJournalTransa and InventTrans. I have managed all the number sequences in excel template itself. I could upload the data into the Movement Journal Lines. Movement Journal was also posted. I could see the onhand stock. But when I was trying to create a Sales order/Purchase Order /any inventory journals - just after entering the item and i click save I am getting an error message - Illegal Reference and I cannot proceed further. Any answers for this?? Regards, Madhu --- In Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com , Sumit Loya [EMAIL PROTECTED] wrote: Hi, I wudnt say only InventJournalTrans and InventDim.. All item transactions are also mirrored in InventTrans table and also the on-hand (stock detalis) are stored in InventSum table (Onhand table). Regards, Sumit On 9/25/07, madhubabu_r [EMAIL PROTECTED] wrote: Hi friends, Manually entering opening stock in Movement Journal must be the most laborious job with all those Excise related entries also included. In my current project there are about 1 items as opening stock. I would like to know which tables I have to consider for excel upload of these opening entries. Awaiting your valuable responses friends. Thanks and best regards, Madhu Babu Rapolu [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Excel templates for Uploading opening Stock
Forgive me, madhubabu_r, if it's just a typo on your part, but you list InventJournalTable and InventTrans as the tables you uploaded. Shouldn't this be InventJournalTable and InventJournalTrans as Sumit Loya listed? --- In Axapta-Knowledge-Village@yahoogroups.com, Sumit Loya [EMAIL PROTECTED] wrote: Hi Madhu, Am not exactly sure why this error is coming. The best way to load opening balances is thru Movement journal only. I wud not guess the reason for this error as this error information is not descriptive enough.. u can try and to debug and see from where this error is coming and on what condition. Do let me know if u come to know anything on this front. One more thing if you are posting Movement journal then u need to have data in InventJournalTable (Movement journal header) and InventJournalTrans (Movement journal line). You need not create records in InventSum. It will be taken care while posting the Movement journal also enure that the Inventory dimensions id that u will provide in InventJournalTrans exists before you post the records. Regards, Sumit On 9/26/07, madhubabu_r [EMAIL PROTECTED] wrote: Hi Sumit, Finally shud i take the following tables in the excel templates: InventJournalTable InventTrans InventSum??? The tables I have uploaded are InventJournalTransa and InventTrans. I have managed all the number sequences in excel template itself. I could upload the data into the Movement Journal Lines. Movement Journal was also posted. I could see the onhand stock. But when I was trying to create a Sales order/Purchase Order /any inventory journals - just after entering the item and i click save I am getting an error message - Illegal Reference and I cannot proceed further. Any answers for this?? Regards, Madhu --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge- Village%40yahoogroups.com, Sumit Loya loya.sumit@ wrote: Hi, I wudnt say only InventJournalTrans and InventDim.. All item transactions are also mirrored in InventTrans table and also the on-hand (stock detalis) are stored in InventSum table (Onhand table). Regards, Sumit On 9/25/07, madhubabu_r madhubabu_r@ wrote: Hi friends, Manually entering opening stock in Movement Journal must be the most laborious job with all those Excise related entries also included. In my current project there are about 1 items as opening stock. I would like to know which tables I have to consider for excel upload of these opening entries. Awaiting your valuable responses friends. Thanks and best regards, Madhu Babu Rapolu [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Re: Excel templates for Uploading opening Stock
Hi Sumit, Finally shud i take the following tables in the excel templates: InventJournalTable InventTrans InventSum??? The tables I have uploaded are InventJournalTransa and InventTrans. I have managed all the number sequences in excel template itself. I could upload the data into the Movement Journal Lines. Movement Journal was also posted. I could see the onhand stock. But when I was trying to create a Sales order/Purchase Order /any inventory journals - just after entering the item and i click save I am getting an error message - Illegal Reference and I cannot proceed further. Any answers for this?? Regards, Madhu --- In Axapta-Knowledge-Village@yahoogroups.com, Sumit Loya [EMAIL PROTECTED] wrote: Hi, I wudnt say only InventJournalTrans and InventDim.. All item transactions are also mirrored in InventTrans table and also the on-hand (stock detalis) are stored in InventSum table (Onhand table). Regards, Sumit On 9/25/07, madhubabu_r [EMAIL PROTECTED] wrote: Hi friends, Manually entering opening stock in Movement Journal must be the most laborious job with all those Excise related entries also included. In my current project there are about 1 items as opening stock. I would like to know which tables I have to consider for excel upload of these opening entries. Awaiting your valuable responses friends. Thanks and best regards, Madhu Babu Rapolu
[Axapta-Knowledge-Village] Re: Excel Import Error: ContactPerson Table
And the answer is... The problem is that the ContactPerson table has an initValue method that does not get called by the file import routine, and that is what generates the reference record used to initialize the HRMVirtualNetworkTable record that cross references to the ContactPerson table. The solution is to add the following code to the Conversion tab of the Import Definition Group and enable the conversion (checkbox field). ; ContactPerson.contactPersonId = NumberSeq::newGetNum (CompanyInfo::numRefContactPersonId()).num(); Make sure that your first line of code is a single semicolon. This forces Axapta to buffer the code that follows. Compile the conversion and run the import. The record complex for the Customer Contacts is two tables: ContactPerson and HRMVirtualNetworkTable. The import is made to the ContactPerson table and the methods in that table create the necessary records in the HRMVirtualNetworkTable. If you have any problems with this just send me an email. [EMAIL PROTECTED] Best Regards, Dick Howard BKD Technologies Indiana USA --- In Axapta-Knowledge-Village@yahoogroups.com, Varden Morris [EMAIL PROTECTED] wrote: Hi Dick, Are the State, County and Country fields data accurate? These are also reference fields in addition to the customer account number that need to have corresponding values in the state, county and country tables respectively. Varden Morris Dick Howard [EMAIL PROTECTED] wrote: Have successfully imported CustTable using an Excel template and now need to import over 800 Contacts for those customers to the ContactPerson table. Mostly am importing names and phone numbers. But the import issues the following error for each record... Field 'Reference' must be filled in Attempted to correct by putting the CustAccount number into the Reference field of the import file still get an error, just a different error... Unknown type: 'VT_BSTR' Have also tried putting the RecID of the CustTable record in the Reference field but the message remains the same as with the CustAccount number in that field. Any help or suggestions welcomed. Best Regards, Dick Howard BKD Technologies Indiana USA Sharing the knowledge on Axapta. - Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Discover Yahoo! Get on-the-go sports scores, stock quotes, news more. Check it out! Yahoo! Groups Sponsor ~-- Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
