I would split up the date imported and the construct my own date variable to validate into the system.
Year := copystr([ImportedDate],1,4)
Month := copystr([ImportedDate],6,2)
Day := copystr([ImportedDate],8,2)
And then Date := DMY2DATE(Day [, Month] [, Year])
I think a workaround like this should work.
Re: I want to pass only part of a field when importing from .csv through xmlport NAV 2017
on the import after getting data use COPYSTR. Something like myvar:=COPYSTR(testtext,4)
Re: Upgrade to 365
for 2013, yes
Re: Field group extensiblity
It seems that they only gave us Addlast, unfortunately. Here's the announcement:
Re: Attempting to split an object file in Dev Shell
You have your "FullExport.fob" file in your source folder. If you specify folder as source, it will try to read everything in it. And because of the .fob file in there, you get the warning/error. Moving FullExport.fob away (at least temporarily) should do the trick.
Re: C/AL Filtering
Your sample code is missing semicolons at the end of lines, so that's probably what's causing your "Syntax error".
And in your second filter, you might wanna use ILERec instead of Rec when selecting Document Type option, i.e.
ILERec.SETRANGE("Document Type",ILERec."Document Type"::"Purchase Receipt");
Re: How do i upgrade to BC CU2
Before upgrading to CU2 uninstall all installed APP (Do not unpublish), then follow the normal upgrade procedure and reinstall :-)
(I have not tryed it on CU2 but for RTM to CU1 this was my way)
Re: keep field constantly updated with values from another table even if it changes
What version of Nav/BC are you using?
In my opinion there are 2 options.
1. You could use a flowfield.
This will calculate the sum on the fly and therefor it'll always be correct.
You just need the right filters on the flowfield.
However flowfields might be a bit slower if it's a lot of records.
2. You could work with subscribers.
Create a function and subscribe to the OnAfterModify event of the table from which you want the sum of quantities.
Then in the function you simply put your filters, get the sum and save it into the correct table/record.
But which option is best depends on what you want to use it for/how large the second table is.
This is just my opinion.
Re: Onaftergetrecord trigger
Re: Validation upon Leaving Page in NAV 2009
Set the page property RefreshOnActivate=Yes