Hello everyone,
I've lurked these forums for a while, but I can't seem to find an answer for my problem. My largest problem is the fact that my company does not have a designers license, so I cannot write any C/AL code. Besides that I can still create forms etc.
My project is to simply make a dialog box pop up when someone releases a sales order. The dialog box merely states "Are you sure you did this, this and this?" "Yes" "No". Upon "Yes" it releases the sales order, "No" just closes. Again, since I can't edit any code I've tried to find a work around of making a form to do that exact function. I've had no problem until now, when you hit "Yes" to release the sales order it tells me "The codeunit Release Sales Document must be called with a Sales Header record."
Is there a way that I can do that in my form? Or is this simply impossible without being able to write any code?
Thank you for your help in advance.
-Seraph
0
Comments
Freelance Dynamics AX
Blog : http://axnmaia.wordpress.com/
but you do have cal code in reports so you may be able to find a way to make a button run a non-printing report that uses the report request form to ask all your yes/no questions, then have the cal code call the release sales order codeunit. only problem is not sure how to feed the code unit the sales order number from your non-printing report
Maybe someone here can help with that.
themave: That sounds exactly like my problem with the form that I made. I just don't know how to feed the codeunit the Sales Header (which is what I assume the error message is telling me).
I think you should pay a solution center 15 minutes to do that, it shouldn't be expensive.
We just upgraded from 2.0 to 4.0 cost was around $50000, with new license granules and all the conversion work. I see little to no chance that we will spend the money to upgrade to Navision 5.0, for many reasons. They wanted 10K more when we were upgrading to go to 4.0 SP1 instead of plane 4.0.
A big reason I don’t think we will upgrade is we use the native database, and most of 5.0’s really neat features require SQL server 2005, and there is no chance we are going to add that to the mix. We would likely have to add another person just to maintain SQL and we are too small for that. And even if I could do all the SQL server admin on top of the rest of my responsibilities, we would still need to pay a solution center a pretty significant sum to tune Navision for SQL. As I read even the SP1 And SP2 stuff, it talks a lot about optimizing code for SQL performance. In 7 years with the native database I never worried about optimizing code for performance, but now it appears all the new Microsoft code is going to be geared to SQL performance, so I can see the Native database performance suffering as a result.
I am thinking that we have already paid for the annual support for this year June 06 to July 07. So we will work out any bugs we have and cancel the maintenance after that. And rely on freelancers and myself to make any changes needed. Our annual maintenance was 16K by itself. So the application designer granule is looking like a good deal.
But "half the price" can be a problem
Themave:
it looks, but the thing is, Navision can offer unpleasant surprises even after 3 years of day-to-day programming. I suggest to calculate an internal consultancy charge - how much a days work worth. Get a quote on the number of days from an NSC. Assume you will need to spend 3 times as much days due to inexperience and having to chase illogical behaviour in Navision where only programming experience helps. Compare them. And assume an Eastern European outsourced NSC will charge about half of the US one. Decide which of the three is the most cost-effective.
We would have been much better off if 7 years ago when we implemented Navision if we had bought the license then. But at that time I had never programmed at all. And our solution center didn’t push us buying it. And why would they, it could only take away revenue from them, and possibly add a lot of trouble for them if I made a ton of changes to Navision that didn’t follow any standard conventions, or messed up Navision and then came running to them to rescue me.
Some customers buy the granule 7300 to do in-house Navision customization, but we have to be honest, a few customers have better knowledge of Navision than a NSC. I believe that a customer should only do in-house development if know Navision quite well. Customizations of Navision can de quite dangerous.
For example in Navision transfer orders don’t allow negative inventory, it is easy do allow negative inventory; a single comment in a line of code solves that. But it will have dangerous implications, adjust costing report will give wrong costing in item ledger entry.
Navision it's different from SAP and other ERP's, it gives a extreme flexibility in customization, but you have to know what you are doing.
Some NSC have huge prices (US prices as much higher than Europe), but quality isn't cheap, I have seen cheap implementations to fail, and expensive implementations to fail too .
Freelance Dynamics AX
Blog : http://axnmaia.wordpress.com/
If you use a non-printing report, you could see if it could send the key strokes as it closes.
You can use Windows Script Host (WSH) , then simulate pressing CTRL+F11 (shortcut to release document)
CreateObject("WScript.Shell").SendKeys("^F11")');
I haven't used the windows script host, but I believe this is the syntax to use it. the ^ means CRTL
So, if you have a button that ran the non-printing report, you would use the report request form to ask your yes/no questions and depending on the answers you would vary the
Report - OnPostReport() code to send the keys.
worth a try.
For a non-NAV devoper you are very creative in C/AL =D>
You should consider a career change