AL publishing error " Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong."

Sometimes if need to remove columns or fields from Table and try to compile and publish the AL extension again we face below error.

Error

 Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong.

Why it happens?

The object metadata in Sql sever could be different from that of your object.

sometime SQL does not recognize the columns or sync same time

What is the solution?

Try to put below parameter in launch.json in your AL extension file.

Hope it help and let me know for more details if we can add it here.

Using Microsoft Translations in VS AL Code

 

SHOW MICROSOFT TRANSLATIONS IN VS CODE

his post is especially interesting for the people whose native language is not English. Do you know the feeling? You are looking at the source code of some .al object and you come across a field name that means absolutely nothing to you. It would be helpful for you if you could see the translation of this field name into your native language. Often this is already sufficient. In the old C/SIDE client we had the field “Caption” in the table designer to see the translation.

Read more --- https://navinsights.net/2021/05/18/show-microsoft-translations-in-vs-code/

AL Navigator: Open/Show Microsoft Translation

Creating a Business Central Incoming document with attachment via BC Webservice.

Hey guys...

Today I am trying to create an incoming document in business central with the attached file of an extension like .pdf or .docx file, via publishing one codeunit webservice and consumed by other software or powerautomate.

Below are some steps to be followed

1. Create BC codeunit webservice with custom method in it and publish it

2. Consume this webservice via power automate and generate JSON object text

3. supply JSON object as text in the codeunit method.

4. Process the JSON object and start creating incoming document.

document:text will have a JSON text in the body as a parameter I am here also pasting my JSON objects with the proper format and the result what I am getting after using POST method as per below

Result:

Note: Please make sure header part should have parameter as mentioned below, if you are trying wizdler to use POST method, no need to use this method as wizdler(WSDL) automatically format.

Download Wizdler here for chrome extension.

Download Postman here.

After processing above I am getting my incoming document created as per below screenshot.

BC IN Version --- Microsoft Dynamics 365 Business Central Release Wave 1 2021

 

Microsoft Dynamics 365 Business Central Release Wave 1 2021

Download IN version of Wave1 - 2021

https://www.microsoft.com/en-us/download/details.aspx?id=102915

Finally IN version of BC Wave 2 available for Download

Use below link to download

Microsoft Dynamics 365 Business Central Release Wave 2 2020

https://www.microsoft.com/en-us/download/details.aspx?id=102128

LS Central 17.3: faster POS login, easier recall of items on the KDS, enhancements to LS Activity

 https://www.lsretail.com/blog/ls-central-17.3?utm_campaign=Product%20release&utm_content=155342044&utm_medium=social&utm_source=linkedin&hss_channel=lcp-902415

LS Central version 17.3 was released on February 18, 2021. Here’s an overview of what we have added and improved in the system. 

LS Activity: more options to manage activity products

Splits multiple email ids in to (List of Text) data type before sending an email notifications to someone through AL code.

EmailSplits('abc@gmail.com;xyz@gmail.com');

SmtpMail: Codeunit "SMTP Mail";

SmtpConf: Record "SMTP Mail Setup";

EmailBody: text;

SmtpMail.CreateMessage('Checking multiple Emails', SmtpConf."User ID", 

                        Receipt, 'Emails ', EmailBody, true);

        

    local procedure EmailSplits(EmaifieldValue: Text[250])

    var

        PosBgn: Integer;

        ValueLength: integer;

        PosEnd: Integer;

        SplitValue: Text;

    begin

        PosBgn := 1;

        ValueLength := STRLEN(EmaifieldValue);

        REPEAT

            IF STRPOS(EmaifieldValue, ';') = 0 THEN

                PosEnd := ValueLength

            ELSE

                PosEnd := (STRPOS(EmaifieldValue, ';') - 1);

            SplitValue := COPYSTR(EmaifieldValue, PosBgn, PosEnd);

            EmaifieldValue := DELSTR(EmaifieldValue, 1, PosEnd + 1);

            Receipt.Add(SplitValue);

        UNTIL EmaifieldValue = '';

    end;