Will the mobile version be called Telekinetic? Just a thought...
Thanks Dragos, exactly what I was looking for.
Thanks Monty, I checked but it hasa valid unit weight UOM. I managed to get round the problem in the end by deleting the price list entry and creating a new one with the new price.Kind regards,Peter
Thanks both for the feedback. It turns out that the field referred to by sambetlyon needed to be added to both the OrderRel and OrderDtl calculated fields before the RDD would work.Fred, I don’t like having unused fields either, but in this case the field wasn’t even in the RDL, but the RDD would not run without it for some reason.Regardless, I have run into a further issue with this report that is RDL related, not RDD. I will post it in a separate question.
I did this with a Post Processing BPM on Customer.GetNewCustomer to set the fields our commercial office wanted to default. You don’t need any special c# skills to do this, just choose the “Set the <whatever> field of the added row to the <whatever> expression” action, and change the variables to whatever you need.
Hi Fred,That’s kind of where I was heading with my code, but fell at the first hurdle as the Script Editor doesn’t recognise ttResults.Kind regards,Peter
Thanks both of you. Still struggling with this, I tried your code, CF, but got an error “The name 'oTrans' does not exist in the current context”.
Many thanks, that makes perfect sense! Your code worked first attempt after I put it into a customization, brilliant!
Thanks Dan, it worked perfectly!And it is as you said, .Count not .Rows.
Thanks Monty, this is exactly where I was trying to get to before Dan suggested a “for” statement. Both answers are spot on, just approaching the problem from different directions.
Thanks Monty, I will have a crack at this… although it looks rather intimidating!Kind regards,Peter
Hi Monty,Once again, many thanks. I adapted your code and it works fine, after a few attempts. I only needed a couple of snippets from what you posted.Merry Christmas!Peter
Hi Joe,Thanks for the input. A DMT-based solution might be the way to go if I can’t get the InventoryQtyAdj code to work. In answer to your question, yes, my code is written in the customisation layer of the dashboard.Kind regards,Peter
For those still following this thread, I have come up with a solution based around DMT. Still in Pilot, but pretty much finalised now. It involves 2 stages, first we create a DMT-compatible CSV file from a button-click action on the dashboard and writte this to a specific Windows directory. Second, a batch command file that contains the DMT command line is run on a Windows schedule to import the CSV file.OK, here are the details…First, in the button-click script we need to define a few variables and then iterate through our dashboard results: var csvLines = new StringBuilder(); //holds the CSV lines we want to write string serialList = string.Empty; //holds info on any serial-tracked parts that can’t be adjusted programatically int qtyAdjRowCount = 0; //keeps track of how many rows are valid for a qty adjustment int serialRowCount = 0; //keeps track of how many rows are serial-tracked EpiDataView edvMyDataView = (EpiDataView)(oTrans.EpiDataViews["V_DK
Thanks Aaron & Calvin, I have tried both these suggestions.Using Aaron’s method, I have adapted the code and it compiles successfully, however the grid does not change colour as expected. I had a look at BackColor in Object Explorer and noticed it has the properties R, G and B - obviously Red, Green and Blue, so I tried changing these to different values but the code checker gave me “Compile failed” with the message “Property or indexer 'System.Drawing.Color.B' cannot be assigned to -- it is read only”. Using Calvin’s method I can change UseAppStyling to false, but there is no BackColor property on the grid properties. There is a BackColor property on the pane object that contains the grid, but setting this had no effect.It is starting to look as if BackColor is somehow disabled from being user defined in our system, which is a damn nuisance!Kind regards,Peter
Hi Fred,Thanks for the reply. Ice.Core.Session won’t compile. I get “Error: CS0234 - line 260 (519) - The type or namespace name 'Core' does not exist in the namespace 'Ice' (are you missing an assembly reference?)”I know Ice.Core.Session works in customisations of standard screens because it is used in our Part Maintenance customisation, but it doesn’t seem to work in customisations of dashboards.Kind regards,Peter
Thanks Fred, I will take a look on Monday. I’m off home now, have a nice weekend!Kind regards,Peter
Sorry Fred, I’m really struggling with this. I tried var assembly = Assembly.LoadFile(“Ice.Core.Session.dll”) but the compile failed with “The name 'Assembly' does not exist in the current context”. Am I missing a using reference?
Hi Calvin,Thanks once again for your input. I already tried setting grid.BackColor = System.Drawing.color.White. This compiled OK but when testing it the grid stayed the normal grey colour.Kind regards,Peter
Just tried grid.BackColor = System.Drawing.ColorTranslator.FromHtml("#E9E9E9"); and got the same. Compiled OK but didn’t change the grid colour.Kind regards,Peter
OK, I’m a little further forward with this - I added using System.Reflections to my code, which solved the previous error, but now I have come up against something of a catch 22 situation - if I try to get the file by referencing just its name, Ice.Core.Session.dll, I get an error saying I need to specify the full path. No problem, I know the full path, it is C:\Epicor\ERP10Client\EpicorERPPilot\Client\Ice.Core.Session.dll. But this obviously includes the environment name.So in order for the code to get the name of the environment it is running in… it needs to know the name of the environment it is running in!
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.