Best Of

Re: External Document No. on Sales Order Header (Nav 2018)

First, you should make an exclusion when External Document No. is blank. Then, you need to make sure to exclude the current order itself in case some code validates the field without actually changing the value. Another suggestion from me would be to also look at Posted Sales Invoices. I think that should be done because one user may have already posted an order with for such Customer with such External Document No. and your check would ignore that. So your full code would become:

IF "External Document No." = '' THEN 
  EXIT;
SalesHeader2.SETRANGE("Document Type", SalesHeader."Document Type"::Order);
SalesHeader2.SETRANGE("Sell-to Customer No.", "Sell-to Customer No."); //from the current record
SalesHeader2.SETRANGE("External Document No.", "External Document No."); //from the current record
SalesHeader2.SETFILTER("No.", '<>%1', "No."); //if somebody manages to VALIDATE "External Document No." without changing it, you would get an error due to the order itself

IF NOT SalesHeader2.ISEMPTY THEN
    Error('Sales order for customer %1 with external document number %2 already exists', "Sell-to Customer No.", "External Document No.");

SalesInvoiceHeader.SETRANGE("Sell-to Customer No.", "Sell-to Customer No."); //from the current record
SalesInvoiceHeader.SETRANGE("External Document No.", "External Document No."); //from the current record
IF NOT SalesInvoiceHeader.ISEMPTY THEN
    Error('Sales order for customer %1 with external document number %2 has already been posted', "Sell-to Customer No.", "External Document No.");

ShaiHulud

Re: File import to NAV through webservice

Thanks TallyHo - worked like a charm :-)

Per_Kleberg

Re: CreateBookAndOpenExcel function in DBC 365

//Create a Procedure CreateExcelBook()

//In this function again call the standard functions from table 370 as shown below.

local procedure CreateExcelBook()
begin
TempExcelBuffer.CreateNewBook('Customers');
TempExcelBuffer.WriteSheet('Customers', CompanyName(), UserId());
TempExcelBuffer.CloseBook();
TempExcelBuffer.OpenExcel();
end;

//Note: for full code see in the bottom i have attached a report for exporting.
Screenshot taken from mobile so please zoom In for better view.

binesh

Re: Sharing the global variable between events in AL extension

You need to make this codeunit as SingleInsance

JJMc

Re: NAV BC SOAP Navuserpassword Error 216 HTTP 500

Since this issue persists and is still present in CU5 i'm giving an update on this issue.
Apparently this is a Business Central version 14 (Spring release) platform bug which is present in all current cumulative updates. Microsoft have been able to reproduce it and they "will" be working on a fix. We should all escalate the issue with Microsoft pressure them as much as possible so that they fix it asap.
There is a ticket filed with ID 119100322001086 named "Repetitive SOAP requests return HTTP 500 error on NavUserPassword instances"

sebsid

Re: How many companies are using Microsoft Dynamics?

For over 10 years, VLC Solutions have been selling and supporting Microsoft Dynamics 365 Business Central, Accounting Software (Microsoft Dynamics GP) in the northwestern area. We are all accountants or CPA’s and approach a project from that standpoint.

VLC Solutions is a Microsoft Silver Certified Partner for Microsoft Dynamics 365 Business Central Software. Our primary customer base is the Memphis region, but we support businesses throughout the northwestern and into, Hoffman estates, Chicago, Arlington heights Naperville, Elgin and thru out the U.S.

Our mission is to provide innovative software solutions and superior support, thereby improving the business success of our clients.

More details Click here

vlcsolutions

Re: Dynamics NAV 2016 Unicode in Dev Env

The Tools>Translate>Import function is also only intended to be used with codepage 850 (on a system running in Western Europe, US. Other regions use other code pages, like 852 in CZ, PL etc.)
You can use the PowerShell functions I have created here to convert the file
http://www.msdynamics.de/viewtopic.php?f=17&t=25726&#p107219
Use
Function Convert_UTF8_OEM850
to generate a new file based on yours and import that one.

Kowa

Re: C/AL code for specific user

This way you did it.
The code I provided does the following:

1. The OnValidate trigger of the price field is invoked
2. Get the User Setup Record for the user which invoked the trigger
3. Check if the user has the priviledge to change the price
4. The user has no priviledge/flag? Throw an error.

If you need to give other users the priviledge to modify the price, or want to remove the priviledge for a user, activate(deactivate your new boolean field at User Setup for this user.

Klappspaten

Re: Navision Mail

Hello @janki87 ,

Here there is the link:

https://www.dropbox.com/s/1cb1x4pqdp17zag/Mail_Dynamics_NAV2009R2_V7.3.zip?dl=1

Regards

ftornero

Re: "The metadata object Table 2000000053 was not found" upgrading from 2016CU13 to 2017RTM

I complied it, stopped and run the service - and the syn-navtenant worked.

Astinia