Best Of
Re: Regarding NAV 2016 Report
https://docs.microsoft.com/en-us/dynamics-nav/walkthrough--designing-a-report-from-multiple-tables
I hope this helps
I hope this helps
TallyHo
5
Re: Is it possible to call external web service form NAV C/AL code?
Yes this is very normal, but it would be hard to come with some example code, because we do not know which kind of web service your want to use :-)
Depending on your are using a SOAP or a REST API the code will be very different.
But you might want to read Gunnar's blog, he has a lot of webservice code:
https://dynamics.is/
:-)
Depending on your are using a SOAP or a REST API the code will be very different.
But you might want to read Gunnar's blog, he has a lot of webservice code:
https://dynamics.is/
:-)
SanderDk
5
Re: Applying entries without having to click on apply entries
You need to make a change in the ApplyCustLedgEntry function in codeunit 12 so that it only applies to customer ledger entries with the same global dimension 1 value. I.e. change the code as follows...
OLD CODE
NEW CODE
OLD CODE
IF Cust."Application Method" = Cust."Application Method"::"Apply to Oldest" THEN
OldCustLedgEntry.SETFILTER("Posting Date",'..%1',GenJnlLine."Posting Date");
NEW CODE
IF Cust."Application Method" = Cust."Application Method"::"Apply to Oldest" THEN BEGIN
OldCustLedgEntry.SETFILTER("Posting Date",'..%1',GenJnlLine."Posting Date");
OldCustLedgEntry.SETRANGE("Global Dimension 1 Code",GenJnlLine."Shortcut Dimension 1 Code");
END;
Kishorm
5
Re: Business Central Can't the Report on Search Bar
If you are using the RTC then you should add the report to the menusuite. Some reports are just added to the ribbon in a page, that way it cannot be found by using the search. If you are using a webclient (BC) then use the UsageCategory property in the page to make it available in search. (remember to generate symbolreference)
TallyHo
5
Re: Export a last 6 months records.
OnPreDataItem()
setrange("Entry Type",Entry Type::sale);
setrange("Source Type",Source Type"::customer);
setrange("Posting Date",calcdate('<-6M>',WORKDATE),WORKDATE);
Or use the "Document Date" for date filtering.
If you mean the last six months invoice records created, this is only possible if you add
a creation date to the table.
TallyHo
6
Re: NAV2018 - The table definition is invalid and cannot be validated
Ah the famous, Sales has sold "We can do all countries in one database" story to the customer 
The problem with the Polish language is that is not using the same code pages as for instance Dutch, German, French etc. And the C/SIDE is not really Unicode capable.
To import the Polish language into the database, you will have to switch your "Non Unicode" code page to Polish.
This will allow you to import the language (flm), after importing the language you can switch back your "Non Unicode" code page to what it was before.
You will notice if you switch back that the Polish characters will be displayed wrong.
If you now want to compile a table you could get the "table definition is invalid" message again. This can be solved by using "Force".
I would advise that the Polish users login into a different RDP as your Belgium users.
It still will be a PITA
The problem with the Polish language is that is not using the same code pages as for instance Dutch, German, French etc. And the C/SIDE is not really Unicode capable.
To import the Polish language into the database, you will have to switch your "Non Unicode" code page to Polish.
This will allow you to import the language (flm), after importing the language you can switch back your "Non Unicode" code page to what it was before.
You will notice if you switch back that the Polish characters will be displayed wrong.
If you now want to compile a table you could get the "table definition is invalid" message again. This can be solved by using "Force".
I would advise that the Polish users login into a different RDP as your Belgium users.
It still will be a PITA
panosk
5
.. find another way.Re: Reporting in MBS-Navision 4.00 SP2
GeflipteKip wrote:I have a small problem with the reporting in Navision 4.00 SP2.
Microsoft has released an update of SP2: MBS-Navision W1 4.0 SP2 Update
Re: Validating RDL for extension report in Business Central?
Visual Studio 2017 (don't know about other versions at the moment) has such a feature: select Build->Build Solution.
Errors, if any, will be shown at the bottom (on default layout), on the Output window:
Errors, if any, will be shown at the bottom (on default layout), on the Output window:
Re: How can I calculate table data and generate a RDLC report. Example is in description.
Hi,
You can create your report and set grouping by the Equipment column.
Quantity in School is a count of records on Available in column with filter by 'School' value.
Quantity in College is the same but filtered by 'College' column.
Total - is count of records without filter.
You can create your report and set grouping by the Equipment column.
Quantity in School is a count of records on Available in column with filter by 'School' value.
Quantity in College is the same but filtered by 'College' column.
Total - is count of records without filter.
swpolo
5