Best Of

Re: Sql to nav page

Hi sjen,

why don't you filter in NAV?

PurchInvLine.SETRANGE(Type,Type::"G/L Account");
PurchInvLine.SETFILTER("No.",'%1*|%2*|%3*',122350,122370,7);
IF PurchInvLine.FINDSET(FALSE,FALSE) THEN BEGIN
   REPEAT
       // Populate Temp Table //
       Rec := PurchInvLine;
       INSERT;
   UNTIL PurchInvLine.NEXT = 0;
END;

Jan87

Re: Codeunit 80 the last version of Business Central

Yes, mine is fine.

TallyHo

Re: Can I write a utility to renumber Fields IDs in some tables

You can do this by making an upgrade codeunit and table. Use the upg objects in the toolkit on the installation media as an axample.

TallyHo

Re: How to work with File Management on Business Central (AL)?

elushka wrote: »

Thanks @wolfskin . But i want that the document saved to a path on server (ex: "C:/Documents/...". As i saw at your blog this saved a record to table. Is there any other possibility to do that?

You can use DownloadFromStream function to save your file to physical path.

wolfskin

Re: Form with TableBox and Subform set coursor position

Set DelayedInsert to TRUE for the subform. See this similar topic Set Focus on Main-Form when using a subform

Luc_VanDyck

Re: Trying to modify record on Sales invoice Header Business Central

Easily add:

Permissions = tabledata "Sales Invoice Header" = RIMD;

At the beginning of your object, for example:

Codeunit 50100 YourCodeunit
{
Permissions = tabledata "Sales Invoice Header" = RIMD;
/*...your code...*/
}

RobyR

Re: write a report to copy all customers from one company to another company.

If you want to copy just the customers (no related data, such as sales/purchase documents, ledger entries, comments, prices, etc.), then it's quite simple (personally, I'd use a codeunit or a report with no data items and code in OnPostReport):

CustomerCompA.CHANGECOMPANY('SOURCE COMPANY NAME');  //can be skipped if executing from source company already
CustomerCompB.CHANGECOMPANY('TARGET COMPANY NAME');
IF CustomerCompA.FINDSET THEN BEGIN
  REPEAT
    CustomerCompB.COPY(CustomerCompA);
    IF NOT CustomerCompB.INSERT(FALSE) THEN BEGIN  //could be that a customer with the same No. already exists
      TempCustomer.COPY(CustomerCompA);  //if that happens we want to show
      TempCustomer.INSERT(FALSE);  //a list of customers that could not be copied
    END;
  UNTIL CustomerCompA.NEXT = 0;
END;
PAGE.RUN(0, TempCustomer);  //display the customers that could not be copied

Variables here:

CustomerCompA - Record - Customer
CustomerCompB - Record - Customer
TempCustomer - Record - Customer (Temporary=Yes)

If you want to copy related records, then you need to copy those related records in the same way.

ShaiHulud

Re: How to write A report that gives list of Number of records in each table for each company ??

An alternative solution to the one TallyHo presents is to use the system table 2000000028 - "Table Information". It has the following fields:

Company Name (no need to flip through the companies manually)
Table No.
Table Name
No. of Records
Record Size
Size (KB)

You can easily create a List Page to see what you'd get by using this table.

ShaiHulud

Re: How to write A report that gives list of Number of records in each table for each company ??

Create a report based on the object table

DataItemTableView SORTING(Type,Company Name,ID) WHERE(Type=CONST(TableData))

Object - OnAfterGetRecord()
TheRecRef.OPEN(Object.ID);
NumberOfRecords:= TheRecRef.COUNT;
TheRecRef.CLOSE;

in layout define
Object.id
Object.name
NumberOfRecords

That should do it.

Per company is changecompany for Object table the way you're probably used to

TallyHo

Re: Codeunit "Certificate Management" method 'GetCertAsBase64String'

As far as I know, the ISOLATEDSTORAGE is accessible only from the app that wrote the data before. So, I think, you can't see the ISOLATEDSTORAGE of native code.
You can check if the key exists in the ISOLATEDSTORAGE and, if not found, I think that my hypothesis is right

RobyR