Am still new in navision development I want to block a user from entering two same item number in the sales line this is because the user can inserts different quantities in the two lines in the same order number and two same item numbers want to have only one item number in the sales line not repeating the items number in the lines.Am using navision 2015.
I'm absolutely with MOnafuye here. If you are using warehousing/picking then that's the right place to enforce it.
The problem is so much that you change the code, but that you change, even if you know it will give problems down the road?
Did you consider Locations? What if one line is to come from one location and another from another location? That will beak the code. Or if variants are used, the same.
Consider all consequences, and present it as one to the customer. This one is way from over, even if it works for you now. It will come back and bite you, or at least the customer.
One of the big problems why so many customers is locked in their current versions, unable to upgrade (or pay the ransom), because their system has way too many changes they really didn't need. Only because their consultant/developer never learned the system well enough to say or dared to say no. Sad to see - and that's on a Friday afternoon.
Erik, I'm not sure if your comment is directed at me or Masholeupao but anyway let me respond. I implemented this exact solution at a client who runs a large warehouse, with sales orders coming from various sources and it works fine. It is appropriate for their situation. It may not be appropriate for Masholeuapo's exact needs but that is for him or her to decide. In my case, sales orders do not come from multiple locations and variants are not used. They use "chaotic" bin management (to call it something), so the products are not tied to one bin and can be found anywhere, so bin ranking is not appropriate. It has worked fine for years and has not come back to bite me. So if you are referring to me when you say the developer never learned the system - that is not a fair thing to say and I have been a developer since 2001. Chris
Nothing personal at your. There very well be good business reasons for doing this. And you just help out because someone asked how it could be done. Looks like you do know what you're doing. We definitely need more like you.
What I'm a little upset about, is that we see so many new NAV developers, who starts changing the system, often in very "dangerous areas", BEFORE they have any idea of what they are actually doing. As soon as they see part of a requirement, then they start coding it. What they should do is to ask enough question, that they really understand the full requirement. And then suggest the better solution, based on their expertise.
Being a NAV developer, is NOT like being a (typical) Java/Web developer. NAV takes a lot more, it requires that you know business and accounting and the consequences of what changing the system in one area can cause in another.
They may feel that they are "not to blame", as it is their employer who doesn't really take care of them, and make sure that their developers/consultants actually have the skills required for their job. Their employer don't offer any training or anything, just expect them to start work. But that's not really an excuse, there are plenty of ways to learn it, even if that has to be done outside normal working hours.
I'm just crying a little over how unprofessional many people are treating our profession.
Hi Erik let us not criticize each other on the above matter at the end of the day we need to have a long lasting solution that is viable to every one ,would like you give me your solution on the above issue Chris provided me with his solution which seem to be working on my side but will happy if you give me your guide line on this.
Hi Masholeluapo, after reading the above comments, I think I was probably wrong to offer a C/AL solution - although it might work it also might not be the best way to do it for your client's situation. What you now have is a question about system design, and what are your client's exact requirements and why? Why do they prefer to do it one way and not another way? Read up about the warehousing and bin management functionality and see if standard NAV can achieve what you need. Also be aware that going down that route may need the client buy a new license granule. There are lots of things here, and lots of learning opportunities.