tag:blogger.com,1999:blog-7636069851213123669.comments2024-02-27T06:23:50.390+01:00Dynamics AX: Notes on the CuffsSasha Nazarovhttp://www.blogger.com/profile/18286448465816639282noreply@blogger.comBlogger36125tag:blogger.com,1999:blog-7636069851213123669.post-12136941144401218132022-02-01T14:27:57.107+01:002022-02-01T14:27:57.107+01:00Thank you So Much!Thank you So Much!Shereenhttps://www.blogger.com/profile/17318230312281055803noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-51160811254192900602021-09-28T17:01:29.243+02:002021-09-28T17:01:29.243+02:00Hello Blog Administrator,
I just want to leave thi...Hello Blog Administrator,<br />I just want to leave this message here on your blog to let anyone know about a financial support Mr Pedro offers me during the time of covid-19 because that time was really a bad and hard time for me after country lockdown I almost lost my business before Pedro Jerome a loan officer who helped me with a loan at the rate of 2% in return to finance my business I'm so grateful and showing gratitude to his support will testify how grateful I'm to his service and his working team as well after visiting their office at my location then I knew he was a good man with a grate heart.<br />I would like anyone here going through financial conditions to contact Mr Pedro Jerome on his E-mail pedroloanss@gmaill.com whatsapp text +1-863-231-0632. and he will help you with any type of loans,Home loan,car loan,construction loan,business loans,personal loan, as long as you are honest enough to make a return.Kimberly Thomashttps://www.blogger.com/profile/01022293785743827115noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-55793811783727408522019-04-01T19:12:13.758+02:002019-04-01T19:12:13.758+02:00может, нам завести какой-то тег, типа, "одобр...может, нам завести какой-то тег, типа, "одобрено минздравом"? а то на самом деле, неизвестно, что можно брать, а что нет.wojzehhttps://www.blogger.com/profile/17752044692176547068noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-51890373286091553722018-03-01T09:17:50.626+01:002018-03-01T09:17:50.626+01:00Hi, sorry, I have never seen this message before. ...Hi, sorry, I have never seen this message before. The original post is 6 year old, and something might have changed in Excel since then. Maybe you can workaround this by creating the file beforehand (instead of creating it with X++), and make sure the sheet is unprotected. Sorry, not sure what to do here. By this message is mentioned many times in Google.Sasha Nazarovhttps://www.blogger.com/profile/18286448465816639282noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-89228773162408106232018-02-28T11:54:41.923+01:002018-02-28T11:54:41.923+01:00Hi,
My filepath is wrong that's y i got an err...Hi,<br />My filepath is wrong that's y i got an error.Your code is perfect and i am facing one more issue.In the excel sheet ,when i tried to write something i am getting a msg,'the cell or chart you are trying to change is on a protected sheet".How to unprotect my sheet.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-45201258662612797632018-02-16T13:55:39.034+01:002018-02-16T13:55:39.034+01:00Do you use exactly the same piece of logic as in t...Do you use exactly the same piece of logic as in the example, or you wrote your own code? It looks like either spreadSheet or columnProperties object is null, and you need to check which one of them is null. You can add some if-statements to your logic that would verify that all objects are instantiated properly.Sasha Nazarovhttps://www.blogger.com/profile/18286448465816639282noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-15995950395459064932018-02-16T13:27:03.704+01:002018-02-16T13:27:03.704+01:00.When I try to do i am getting error when i tried ....When I try to do i am getting error when i tried to run in batch.<br /><br />. System. NullReferenceException: Object reference not set to an instance of an object. at Dynamics. Ax.Application.<br /><br />error line "spreadSheet.InstantiateColumn(columnProperties);".help me out to go ahead with my process.Anonymoushttps://www.blogger.com/profile/15847211796016925071noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-11777501377431115022017-11-14T09:21:50.422+01:002017-11-14T09:21:50.422+01:00Hi Atef
Could you tell me the method name and line...Hi Atef<br />Could you tell me the method name and line number, where the exception is thrown. Also, which AX version do you use?Sasha Nazarovhttps://www.blogger.com/profile/18286448465816639282noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-9926841828162024172017-11-14T08:02:53.246+01:002017-11-14T08:02:53.246+01:00hi
i have this error and i don't know how to ...hi <br />i have this error and i don't know how to solve it any helpatefhttps://www.blogger.com/profile/10924951164608126560noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-91199643639177452812017-08-20T16:59:33.098+02:002017-08-20T16:59:33.098+02:00Congratulations... Thanks for sharing information ...Congratulations... Thanks for sharing information on <a href="https://www.checkmarx.com/2016/06/30/uncategorizedwhat-is-static-code-review/" rel="nofollow">codereview tools</a>.jonathanhttps://www.blogger.com/profile/00010317696137447813noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-32256051361695694812017-08-11T20:57:35.380+02:002017-08-11T20:57:35.380+02:00what´s the value in InventTrans.StatusIssue after ...what´s the value in InventTrans.StatusIssue after run the code?Eduardohttps://www.blogger.com/profile/00972911181042744085noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-29442426000942687842016-11-18T15:21:40.227+01:002016-11-18T15:21:40.227+01:00The isSQL() is called because in AX you can have f...The isSQL() is called because in AX you can have fields with the property "SaveContents" to "No", which means they are not synced with the database, they are "virtual fields" which must be populated at record fecth time in the postLoad method on the table.KIThttps://www.blogger.com/profile/11647523397282156915noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-35915043130244822452016-08-06T00:18:53.222+02:002016-08-06T00:18:53.222+02:00Helpful blog, like it!Helpful blog, like it!Anonymoushttps://www.blogger.com/profile/07165250291750440109noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-61723938322965156622016-08-06T00:13:18.055+02:002016-08-06T00:13:18.055+02:00This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/07165250291750440109noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-14644200813845488152015-12-24T11:41:39.186+01:002015-12-24T11:41:39.186+01:00No, I didn't try to solve that, because there ...No, I didn't try to solve that, because there was no need.Sasha Nazarovhttps://www.blogger.com/profile/18286448465816639282noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-32638073543020393832015-12-17T21:46:14.880+01:002015-12-17T21:46:14.880+01:00Did you solve how to create the spreadsheet so tha...Did you solve how to create the spreadsheet so that it opens in Normal mode not "Page Layou"Anonymoushttps://www.blogger.com/profile/08124974693518457681noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-1511584393918433302015-04-24T17:37:51.197+02:002015-04-24T17:37:51.197+02:00Hello, when I try this the columns were hidden, ho...Hello, when I try this the columns were hidden, how can I solve this?<br />Another thing, how can I open xlsx in Normal mode? (It's start in Page layout).<br /><br />Thanks a lot!Anonymoushttps://www.blogger.com/profile/14576971039704188093noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-47089415060016029832014-05-07T17:03:33.324+02:002014-05-07T17:03:33.324+02:00Alternative approach is to enable SQL tracing of a...Alternative approach is to enable SQL tracing of all statements in user options dialog of Dynamics AX and set it to file. Let your process execute until it throws the update conflict exception and then search for the last UPDATE statement on this table in the trace file. There you will also see the X++ call stack which issued this update statement.Herbalizerhttps://www.blogger.com/profile/15434261992231107091noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-65263947350192380542014-04-28T20:55:25.100+02:002014-04-28T20:55:25.100+02:00Hi,
Apparently we had another issue. Our whole Ta...Hi,<br /><br />Apparently we had another issue. Our whole TaxUncommitted table got deleted ... This appears to be a std AX bug in CU5. They fixed it already in CU7, but I'm not so happy that such a mistake got ever released in a CU ...<br /><br />Scenario: Procurement and sourcing > periodic > cleanup > Purchase update history cleanup<br /><br />The bug / fix is situated in VendInvoiceInfoTable.deletewithoutDeleteActions()Anonymoushttps://www.blogger.com/profile/03031120644742432226noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-64369690427788160472014-04-25T10:22:24.677+02:002014-04-25T10:22:24.677+02:00Hi Sasha,
I have the same issue here. Will try yo...Hi Sasha,<br /><br />I have the same issue here. Will try your solution now.<br /><br />Thanks !<br />TomAnonymoushttps://www.blogger.com/profile/03031120644742432226noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-21256944015270783912014-02-18T17:11:49.762+01:002014-02-18T17:11:49.762+01:00Just what I needed, awesome!Just what I needed, awesome!Klaas Deforchehttps://www.blogger.com/profile/10895989434636035525noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-70443205684141550792013-11-04T13:33:30.897+01:002013-11-04T13:33:30.897+01:00Hi Kamalakannan
As you know, update conflict happ...Hi Kamalakannan<br /><br />As you know, update conflict happens when RecVersion value of the local table buffer, which is being updated, and the corresponding record in the DB is different.<br /><br />This script helped me avoid unnecessary "step in"-s in the debugger, because I could immediately see, if some particular line of code resulted in the "hidden" update. Then I could put a breakpoint onto this line, step in and and debug again, until the actual update_recordset, doUpdate() or update() call was found.Sasha Nazarovhttps://www.blogger.com/profile/18286448465816639282noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-38204927651427837592013-10-26T13:05:09.427+02:002013-10-26T13:05:09.427+02:00Hi Sasha,
How detecting the recversion could help...Hi Sasha,<br /><br />How detecting the recversion could help you identify the location of the update conflict ?Kamalakannanhttps://www.blogger.com/profile/08495495151167438618noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-39542390610302309172013-10-25T15:40:54.369+02:002013-10-25T15:40:54.369+02:00Dear,
I am using a similar script that runs after...Dear,<br /><br />I am using a similar script that runs after a data refresh (eg from production to live). <br /><br />What do you do in the following case:<br /><br />in sql dict you have (comes from production):<br /><br />60001 Field1<br />60002 Field2<br /><br />In the TEST in AOT we have<br /><br />60001 Field2<br /><br />So the script should change the Id of Field2 from 60002 to 60001 but this will cause an error. So all entries in the SQl dictionary for non existing fields (in this case 60001 Field1 does not exist in the test app) should be deleted prior to running the script.<br /><br />I hope the problem is a bit clear :) .<br /><br />Thanks in advance.<br /><br />AndrewAnonymoushttps://www.blogger.com/profile/01360158370643859156noreply@blogger.comtag:blogger.com,1999:blog-7636069851213123669.post-142952790298665342013-10-23T14:23:18.654+02:002013-10-23T14:23:18.654+02:00Hi Gerrit
Thanks for the comment.
We did see tha...Hi Gerrit<br /><br />Thanks for the comment.<br /><br />We did see that issue with the isSql() method sometimes, and eventually had to remove it.<br /><br />I am not 100% sure why it was used, because my script was based on another script, published by another blogger. <br /><br />I have updated the post.<br /><br />Thank youSasha Nazarovhttps://www.blogger.com/profile/18286448465816639282noreply@blogger.com