Best Of
Re: is it passible to validate field value through Navision web service before insert or update
vinceliu666 wrote: »Just copy the validation from where it currently exist, create something similar in the web service and utilize it before the create/update function in the web service. This, of course, means it will be inefficient since it's having to do the same thing twice but it does what you're asking. You can get around the inefficiency but you have to ask yourself how often it happens and whether it's worth it with a little more programming.
Thanks for your feedback , My Issue is that if I run record.insert, the record will be inserted. But I just want to validate data only, not insert record. If I run the record.insert , I must delete the record after insert . But the autoasign no for example Sales Order No will be add one.
Another option is to make a Record Variable: Temporary. By using Temp Tables you can do all CRUD operations without committing anything to your Physical table.
Re: Install Dynamics NAV 2016 problem
Try giving the "NT AUTHORITY\Network Service" full access to the following folder...
C:\Program Files\Microsoft Dynamics NAV\90\Service
C:\Program Files\Microsoft Dynamics NAV\90\Service
Kishorm
1
Re: How to find table 2000000041 ("Field") in MS SQL?
Hey UYA,
Table 2000000041 is one off the virtual Tables in NAV.
Therefore you cannot find a Reference in SQL
The Normalfields you can find in the view sys.columns
Cheers, Chris
Table 2000000041 is one off the virtual Tables in NAV.
Therefore you cannot find a Reference in SQL
The Normalfields you can find in the view sys.columns
Cheers, Chris
Re: Making a field mandatory
This will show red cross on field
1. Create global boolean variable. Example: FieldMandatory
2. on page in ShowMandatory property of field set variable "FieldMandatory"
3. On OnOpenPage trigger:
IF SomeCase THEN
FieldMandatory := TRUE
ELSE
FieldMandatory := FALSE;
This will check field:
1. On On ClosePage trigger
IF SomeCase THEN
TESTFIELD(Field);
1. Create global boolean variable. Example: FieldMandatory
2. on page in ShowMandatory property of field set variable "FieldMandatory"
3. On OnOpenPage trigger:
IF SomeCase THEN
FieldMandatory := TRUE
ELSE
FieldMandatory := FALSE;
This will check field:
1. On On ClosePage trigger
IF SomeCase THEN
TESTFIELD(Field);
Re: Handling Send HTTP Request POST
Maybe it also helps to first make it work by using a API test tool like Postman or SOAPUI. If you can authenticate succesfully by using these tools then rebuild the request in Nav.
Re: Business Central 17 - D365 2020 release wave 2 preview
you will get more info on 2020 wave 2 preview here - https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/preview-environments
manju
1
Re: How to keep the order of the columns on the form
It sound like they are losing their zup file. Do you have a specified location of the zup files?
SanderDk
1
Re: Skip empty field value during import through dataport.
can you try with CurrDataport.SKIP; ?
foo_bar
2
Re: item copy
Hi
You will have to use
Edit, Select All(CTRL+A), COPY.
You then create New blank record Insert (F3), Paste data, THEN Rename
the "No." field or you will a have a duplicate record.
Also a reminder you will have to set the "Unit of Measure", as this will not be set up.
You will have to use
Edit, Select All(CTRL+A), COPY.
You then create New blank record Insert (F3), Paste data, THEN Rename
the "No." field or you will a have a duplicate record.
Also a reminder you will have to set the "Unit of Measure", as this will not be set up.
StephenG
1